Data Power

Location:

Central Secretariat, Delhi, India

Salary:

50000

Posted:

August 23, 2019

Contact this candidate

Resume:

SAZID KHAN

Block B***,Okhla, #**-***,New Delhi-**0025

*****.*********@*****.*** Cell: +919********* +658*******

SUMMARY:

Over all 9+years of experience in IT industries as BI Developer, Tools including Power BI Desktop, Power BI Services, Tableau Desktop, Tableau Servers, ETL, SSIS, SSAS, SSRS with strong background in database and data warehousing concepts

Experience on Data Warehousing using fact tables, dimension tables and star/snowflake schema Database modeling, Designing Datawarehouse structures.

Expertise in Complex calculations, building advanced charts, effective use of parameters report Development. Strong SQL knowledge to analyze the data and to prepare data sources. Knowledge in Data warehouse and Data mining concepts.

Extensive knowledge in reporting objects like Hierarchies, filters, DAX fields, Groups, Parameters etc., in Power BI Desktop.

Extensively worked on Dash boards like Filled maps, Bar Chart, Scatter Plot, Pie Chart etc. by using Power BI Desktop.

Strong skills in Data Modelling, Report Design and Visualizations and Power BI Visuals including TreeMap, Funnel, Line Chart with Map Reports and Stacked Reports in Power BI Desktop.

Experience on Power Query (M Language) Functions, Power Query Parameters and Variables and Power Query Lists, Tables and Records.

Working with DAX Functions and Usage, DAX Measures and Calculations and BI Enhancements using DAX.

Working on Power BI Cloud and App Creation, Publishing and Dashboarding and Dataset Refresh using Gateways (Personal).

Knowledge using Content Packs and Card Level Alerts, Created Scorecards, Bookmarks and QR Codes for Reports.

Experienced in Power BI Desktop to deliver KPI and trend information to business lines, sales development.

Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.

Configured Project Server with Team Foundation Server (TFS) to synchronize task/work item tracking process.

Integrated MS Project Server data with external systems like “Time Entry, Resource Center, Contractor database” on PeopleSoft/SAP/Oracle.

Prepared document of installation and configuration of SharePoint/Project Server/TFS by referring Microsoft guidelines and best practices.

Configured EPK Suite with Project Server and developed custom reports.

Provided guidance to PMs on managing project schedules effectively using MS Project and MS Project Server.

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2012 using SSIS/DTS, SSRS.

The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversion.

Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.

Creating different type of Function, Procedure, Trigger, Cursor, package in the SQL and writing complex Query in the T-SQL.

TECHNICAL SKILLS:

Operating System

Windows 98/2000/Window/XP, Windows 7,8

Languages/Technologies

Visual Basic 6.0, VBA, Macro, MS Office, Advance Excel, MS Access

GUI Tools

Tableau desktop 9.x,10.x,Tableau Server,Power BI,Python,SSIS

RDBMS

Microsoft SQL Server 2012,2014,2016

EXPERIENCE:

Company: U3 Infotech Pte Ltd (Contract) Oct 2018 – Till Date

Client: JP Morgan Chase

Position: Data Engineer

Project Name: Compliance Digital

Project Description: JPMC, Inc. established in 1837 is US multinational Bank that, deals all the Banking related product like Banking, Stock and Compliance. One of the most powerful bankers of his era, J.P. (John Pierpont) Morgan (1837-1913) financed railroads and helped organize U.S. Steel, General Electric and other major corporations. The Connecticut native followed his wealthy father into the banking business in the late 1850s, and in 1871 formed a partnership with Philadelphia banker Anthony Drexel. In 1895, their firm was reorganized as J.P. Morgan & Company, a predecessor of the modern-day financial giant JPMorgan Chase

Responsibilities:

Extensive knowledge in reporting objects like Hierarchies, filters, DAX fields, Groups, Parameters etc., in Power BI Desktop.

Extensively worked on Dash boards like Filled maps, Bar Chart, Scatter Plot, Pie Chart etc. by using Power BI Desktop.

Strong skills in Data Modelling, Report Design and Visualizations and Power BI Visuals including TreeMap, Funnel, Line Chart with Map Reports and Stacked Reports in Power BI Desktop.

Experience on Power Query (M Language) Functions, Power Query Parameters and Variables and Power Query Lists, Tables and Records.

Working with DAX Functions and Usage, DAX Measures and Calculations and BI Enhancements using DAX.

Working on Power BI Cloud and App Creation, Publishing and Dashboarding and Dataset Refresh using Gateways (Personal).

Knowledge using Content Packs and Card Level Alerts, Created Scorecards, Bookmarks and QR Codes for Reports.

Experience on Power BI Licenses and Gateway Type, Azure and On-premise Database Report Visualization and Able to design complex queries for Power BI Report Visualizations.

Experienced in Power BI Desktop to deliver KPI and trend information to business lines, sales development.

Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.

Developed complex Tableau Visualizations. Participated in requirement gathering, prepared BRD document.

Able to manage all the stages of software development, develop applications in a detail-oriented environment and identify and resolve intricate problems.

Created Complex workbooks and Dashboards by connecting to multiple data source using Power Query.

Published Reports, workbooks & data source to server and exporting the reports in different Formats.

Configured Project Server with Team Foundation Server (TFS) to synchronize task/work item tracking process.

Integrated MS Project Server data with external systems like “Time Entry, Resource Center, Contractor database” on PeopleSoft/SAP/Oracle.

Prepared document of installation and configuration of SharePoint/Project Server/TFS by referring Microsoft guidelines and best practices.

Configured EPK Suite with Project Server and developed custom reports.

Provided guidance to PMs on managing project schedules effectively using MS Project and MS Project Server.

Environment: Power BI Desktop, Power BI Services, ETL,SSIS Excel and SQL Server 2016

Company: Maneva Management Consultant (Contract) Feb 2018 – June 2018

Client: Wipro

Position: Technical Lead

Project Name: Professional Proto Type (P3)

Project Description: Adient, Inc. established in 1894 is an Germany multinational corporation that, manufactures Seats. Adient Company, a subsidiary of his Lancaster Caramel Company. Adient products are sold in over 60 countries worldwide. The Purpose of Orders and Sales project is to develop a Centralized and Structured Data mart for all Adient Systems Order and Sales Data. The Orders and Sales project created a new process and collection point to funnel and summarize enterprise wide orders and sales information to the appropriate user level for the Enterprise Data Warehouse for doing quality check. The Data warehouse is aimed at delivering mission critical reports such as Vendor Analysis reports, Inventory tracking reports and Forecast on inventory allocation reports which should be on time, accurate and critical for business managers to make decisions.

Responsibilities:

Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Expertise in creating Reports Dashboards in Power BI and Data Schema Design and Table Design.

Work on Power BI Reports & Dashboards with SQL Server and on DAX Data Analysis expressions and functions.

Extensive knowledge in reporting objects like Hierarchies, filters, DAX fields, Groups, Parameters etc., in Power BI Desktop.

Extensively worked on Dash boards like Filled maps, Bar Chart, Scatter Plot, Pie Chart etc. by using Power BI Desktop.

Strong skills in Data Modelling, Report Design and Visualizations and Power BI Visuals including TreeMap, Funnel, Line Chart with Map Reports and Stacked Reports in Power BI Desktop.

The packages created included a variety of transformations, for example Slowly Changing Dimensions, look up, Aggregate, Derived Column, Conditional Split, Merge, Merge Join and Data Conversion.

Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Working Experience on Precedence Constraints, Break Points, Check points and Logging.

Experience in importing/exporting data between different sources using SSIS and insert into SQL Data Warehouse.

Creating configuration files to deploy the SSIS packages across all environments and designing SSIS ETL framework or Data Integration Projects.

Worked on the both the development and Maintenance projects and followed the Operational SLA and Processes.

Implemented SSIS Best practices in the projects and has focus on Quality deliverables within predefined SLA.

Maintain and support Extract Transform and Load Process in huge Database and Experience designing front end interfaces to database systems.

Excellent understating of concepts like star-schema, Snow flake schema using fact and dimeson tables and relation databases like MS Access, SQL Server.

Environment: Power BI Desktop, Power BI Services, Excel and SQL Server 2016,Tableau Desktop

Company: Sunera Technologies Pvt. Ltd. July 2015 – Jan 2018

Client: Hershey’s

Position: Technical Lead

Project Name: Obsolete Packaging (Hershey’s BI)

Project Description: Hershey’s, Inc. established in 1894 is an American multinational corporation that, manufactures Hershey Chocolate. Hershey’s Chocolate Company, a subsidiary of his Lancaster Caramel Company. Hershey's products are sold in over 60 countries worldwide. The Purpose of Orders and Sales project is to develop a Centralized and Structured Data mart for all Hershey’s Systems Order and Sales Data. The Orders and Sales project created a new process and collection point to funnel and summarize enterprise wide orders and sales information to the appropriate user level for the Enterprise Data Warehouse. The Data warehouse is aimed at delivering mission critical reports such as Vendor Analysis reports, Inventory tracking reports and Forecast on inventory allocation reports which should be on time, accurate and critical for business managers to make decisions.

Responsibilities:

Designing and developing Tableau Reports, Documents and Dashboards as per specified requirements and timelines and presenting them in a variety of formats to users.

Extensive knowledge in reporting objects like Hierarchies, filters, calculated fields, Groups, Parameters etc., in Power BI.

Creating Workbooks by Importing data, Defining Relationships in Power BI Model.

Created Hierarchies, Drill Down Reports Drill through report to report next level data or granular data.

Hands on experience in creating parameters, complex calculated fields, groups and Hierarchy.

Creating Row level security with Power BI and integration with Power BI Service Portal and Gateway services and handling user and app security.

Designing and developing Tableau Reports, Documents and Dashboards as per specified requirements and timelines and presenting them in a variety of formats to users.

Extensive knowledge in reporting objects like Hierarchies, filters, calculated fields, Sets, Groups, Parameters etc., in Tableau.

Creating Workbooks by Importing data, Defining Relationships in Tableau Desktop.

Created List, Drill Down Reports with Quick Filters, Summarized Filters in Tableau Desktop.

Working experience on Tableau with Big Data connectivity and relational Database Connectivity.

Hands on experience in creating parameters, complex calculated fields, groups and Hierarchy.

Hands on experience on tableau functions- date, string, numeric.

Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.

Connecting multiple data source with Data Blending technique.

Strong work experience in Tableau desktop/ server with different versions including 6.x to the newest version 10.x.

Involved in creating Dashboard using Tableau Desktop, Tableau Server.

Installation and configuration of tableau server in cluster environment and Upgrade of tableau server to various versions including minor and major upgrades.

Creating incremental refreshes for data sources on Tableau Server.

Providing the Roles and Security while Publishing to the Tableau Server.

Excellent in scheduling, Subscription and deployment of reports in Tableau Server.

Combined visualizations into Interactive Dashboards and publish them to the Tableau Server.

Excellent understating of concepts like star-schema, Snow flake schema using fact and dimeson tables and relation databases like MS Access, SQL Server.

Understanding and analyzing the business requirements and Developed various types of complex reports like Drill Down, Drill through, Cross tab.

Creating Different type of Macro using Excel VBA and Different Tools using VBA Front End Forms and Back End MS Access and SQL Server 2014.

Excellent understating of concepts like star-schema, Snow flake schema using fact and dimeson tables and relation databases like MS Access, SQL Server.

Understanding and analyzing the business requirements and Developed various types of complex reports like Drill Down, Drill through, Cross tab.

Creating Different type of Macro using Excel VBA and Different Tools using VBA Front End Forms and Back End MS Access and SQL Server 2012.

Environment: Power BI Desktop, Power BI Services, Tableau Desktop 10.3, Tableau Server, Excel and SQL Server 2014

Company: HCL Technologies Pvt. Ltd. May 2014 – June 2015

Client: PepsiCo

Position: Specialist

Project Name: My Dashboard Tool (PepsiCo BI)

Project Description: This application is helpful in to Getting the Data from the HPSM Tools (Ticketing System) and it will be Refresh automatically after 12 hours interval and Producing Different Types of Reports to Team and Customer also. Creating Different Types of Workbooks, Dashboard to Maintain SLA, OLA and KPI’s.