BIPIN TIWARI
Auburn,NSW
Summary
Dynamic and detail-oriented SQL Developer with extensive experience in designing, developing, and maintaining complex database systems. Proficient in writing optimized SQL queries, stored procedures, and functions for data manipulation and retrieval. Collaborates effectively with cross-functional teams to integrate database solutions that support business objectives.
Worked on Power BI with a strong background in data modelling, analysis, and visualization, delivering comprehensive business intelligence solutions that drive decision-making. Experienced in designing interactive reports and dashboards and with experience in DAX, Power Query, and data integration.
Proficient in report design, data source integration, and advanced data visualization techniques to create clear, impactful reports. Demonstrates expertise in query writing, report parameterization, and layout formatting to enhance report interactivity and user experience.
Overview
1
1
year of professional experience
Work History
Data Analyst
Smart Careers
06.2023 - Current
- Working with SQL (Designing Data Warehouse):
- Designing and implementing database schemas, including tables, indexes, views, and other database objects, based on business requirements
- Writing and optimizing T-SQL queries for data manipulation (INSERT, UPDATE, DELETE) and data retrieval (SELECT)
- Creating and managing stored procedures, functions, and triggers to encapsulate complex business logic within the database, improving reusability and performance
- Identifying and resolving performance bottlenecks, including optimizing stored procedures and tuning database configurations for better efficiency
- Ensuring data consistency and accuracy through data validation and cleansing techniques
- Using SQL Server's backup and restore capabilities to manage database backups and recover data when necessary
- Working with ETL (SSIS SQL Server Integration Services)
- Involved in migrating data from different DB's to Bespoke ERP Solutions
- Designing packages in SSIS to populate data from various sources and data extraction from Flat Files, Excel Files, OLEDB, and Import data into clients' DB after proper validations
- Creating ETL, Data Profiling, Data Quality Server/Client, and Cleanups for SSIS Packages
- Cleanup tasks are implemented within SSIS packages to remove or correct erroneous data before it's loaded into the destination
- Designing Sequence, For and For-Each Loop to Import and Using Variables to Export Multiple Files in Different Formats
- I used control flow elements in SSIS, such as sequence containers and loop constructs (For Loop, For Each Loop), to efficiently manage the execution of tasks, including the dynamic import and export of data across multiple files of varying formats
- Variables are used within these loops to handle file paths, names, and other dynamic properties during runtime
- Data is loaded into the destination server using various methods, including direct SQL commands through the Execute SQL Task, high-speed data insertion with Bulk Insert, and complex transformations such as lookups for data updates
- A variety of SSIS transformations are used to prepare the data for loading
- This includes converting data types, creating new computed columns, cleaning data using Data Quality Services (DQS), and performing lookups to enrich or validate the data
- These transformations ensure that the data is consistent, accurate, and ready for analytical or operational use
- Working with Reporting and Analytics (SQL Server Reporting Services)
- Developing reports and dashboards using SQL Server Reporting Services (SSRS) or other reporting tools, providing critical insights to business stakeholders
- Supporting data analytics initiatives by providing data extracts and executing complex analytical queries
- Designing the Daily, weekly (Sales, Marketing, Inventory, KPI reports)
- Design Invoices reports layouts and apply formatting to make reports visually appealing and easy to read
- Working with POWER BI:
- Data Modeling and Preparation:
- Designing and implementing data models that effectively represent business processes and requirements, including establishing relationships, calculated columns, and measures
- Report and Dashboard Design: Creating interactive reports and dashboards that provide actionable insights using Power BI's visualization tools, such as charts, graphs, maps, and tables
- Applying best practices in data visualization to ensure reports are clear, engaging, and accessible to end-users
- DAX (Data Analysis Expressions): Writing DAX formulas to create complex calculations, aggregations, and data analysis within Power BI models
- Ensuring that DAX calculations are optimized for performance and accuracy
- Report and Dashboard Design:
- Creating interactive reports and dashboards that provide actionable insights using Power BI's visualization tools, such as charts, graphs, maps, and tables
- Applying best practices in data visualization to ensure reports are clear, engaging, and accessible to end-users
- DAX (Data Analysis Expressions) formulas were used to create complex calculations, aggregations, and data analysis within Power BI models
- CSBIKES
- Project 1: Creating store procedures and views
- Tool used:, (SSMS)
- Created Insert, Update and Delete Store procedures for all the required tables, which created higher productivity and performance
- Created a view for Staff details to get the manger name by using self-join
- Which made it clear to view staff details
- Created a view for customer details along with store name and staff name wherever they made the purchases
- Created a view for orders and products to analyze all the sales
- Created a view to check the total sales for each product
- Created a view to examine the total sales for each customer
- Created a view to get the top products with highest sale
- Created a view to check the stock availability in various stores
- Project 2: Creating reports
- Tool used: Ms-sql (SSRS)
- Create various reports and Power bi dashboard based on the requirements
- Created a report which contains all the staff details
- Created a report with all the customer details, store, and staff details
- Created a report for all the products with all the order details and designed a parameter to select one or multiple products
- Created a report for all products with total sales and designed a parameter to select one or multiple products
- Created a report for total sales for all customers and designed a parameter to choose one or multiple customers
- Created a report for products with the highest sales
- Created a report on stock availability in various stores
- Created a report for customers who made the total sales above a certain value
- Created a KPI report to review and analyze performance of the strategic goals of the company
- Project 3: Creating dashboard
- Tool used: Power BI
- Created a Power Bi dashboard by using an import method to improve the speed and efficiency
- Transformed the date based on the requirements by using the power query
- Created the dashboard by using various analyzing methods and visualizations
- Created a date hierarchy to make the model light
- Created various measures by DAX expressions
- Dashboard consists of total revenue, gross profit, and net profits with the percentage along with the bar graphs with yearly information, COGS, total sales by annually, quarterly, monthly, weekly and daily along with the visualizations and yearly sales variance, total sales of the individual salesperson with the ranks, top customers with the total sales and more
- Project 4
- Created a database for a Company and Stage table in SQL SERVER and created Primary Key and Foreign Key using appropriate data types
- Store procedures and views were created
- After creating the table SSIS was used to integrate with SQL and inserted all the data from EXCEL file source
- Designed a package for increment loading, using an initial loading with lookup, using ole db command
- For another table, designed a package for increment loading, using an initial loading with lookup, designing a stage table.
Education
Master of business information systems -
Torrens University
11.2021
Bachelor of Science - Statistics and Physics
Trichandra Campus
07.2016
Skills
- Technical Skills
- RDBMS - SQL SERVER
- Business Intelligence Stack – MS SQL, SSRS, Power BI
- SQL Skills- Procedures, Functions, Triggers and Views
- Data Analysis, BI reporting
- Reporting- SSRS – SQL Server Reporting Services
- Power BI
- Excel- Power pivot, lookup, Conditional formatting
References
Reference
Mohammad Rahman
Senior Data Analyst
Smart Careers
Contact No: 0406613808
Timeline
Data Analyst
Smart Careers
06.2023 - Current
Master of business information systems -
Torrens University
Bachelor of Science - Statistics and Physics
Trichandra Campus