Keywords
Skills
Project history
EcoSys –Engineering firm
We manage the data one of the largest US based engineering firm, which contains mainly account receivable, payable finance daily data.
Responsibilities: To understand the functional requirements in detail and providing technical solution, responsible for all kind of data reporting in Power BI and building ETL on full azure services
- Developing ETL from different kind of source by azure pipeline and SSIS package, Job and pipeline Monitoring, identifying discrepancies and recording the variances for business to research and remediate.
- Building data model/Cube in Azure analysis service for power bi reporting purpose.
- Creating Facts, Dimension, measures, relationships on business rule
Technology/Tools: Azure SQL warehouse, SSIS/ADF, Azure AS, Power BI
Office Products Group (Data Reporting system for financial evolution and MAU)
More than 500+ reports of business process are developed in these projects, which include finical evolution and monthly active device of Office Product Groups
Role: Experience in Power BI, SSIS Data Pull, SSAS Cube generation and measure creation/calculation Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
- Build SSIS package to get data from heterogeneous sources and automate that through sequel jobs
- Extensively used SQL Server database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts. Written several complex SQL, MDX queries for data verification and data quality checks.
- Building analysis cube with calculated measure and derived column and automate that through sequel jobs
Responsibilities: To understand the functional requirements in detail and providing technical solution, responsible for all office product data reporting
- Job Monitoring, identifying discrepancies and recording the variances for business to research and remediate.
- Debugging and Scheduling Query Jobs/Mappings and monitoring error logs.
Technology/Tools: SQL Server 2008, 2016, SSIS, SSAS, Power BI
Duration: 11-Aug-2017 to Till now