SUMMARY

• Over 8 years of Professional experience in IT industry wif Microsoft Certification, Involved in BI projects wif extensive usage of SSIS, SSRS, SSAS Tabular, SSAS Multidimensional, Power BI, Azure SQL, Azure Data Lake and Azure Data Factory.
• Excellent experience in implementing end to end BI & Data warehousing solutions.
• Designing and developing experience of Data warehousing projects.
• Good experience in working wif the SQL Server databases.
• Experience in building data visualization (dashboards) solution using SSRS, Power BI.
• Experience in Relational and Dimensional Data Modeling.
• Experience in Data Warehouse Design solution which includes OLAP modeling and ETL design.
• Experience in Architecting ETL Packages using SSIS which includes creating HLD and Mapping document.
• Experience in SSAS multidimensional and tabular model design and development.
• Experience in Microsoft Azure, Azure SQL, Azure Data Lake, Azure Data Factory.
• Created Power BI Reports by extracting data from Data lakes.
• Deployed SSIS Packages to Azure SQL DB and executed packages by using Azure Data factory.
• Created Azure - SSIS Integration Runtime and ADF pipe lines to execute SSIS packages.
• Experience in Agile development methodology and experience in tools like CA Harvest, TFS and VSTS GIT.
• Knowledge on SQL Server Master Data Services (MDS).
• Assist the business analysts wif data analyzing, data requirement and data modeling.
• Deployed SSIS packages by using the SSIS Deployment wizard, Executed packages by using the environmental variables.
• Assist the wif the Testing, implementations and bug fixes/data fixes.
• Experience in migrating SSIS projects from 2005 to 2008 R2.
• Experience working wif Oracle databases and PL/SQL.
• Worked on end to end project development from analyzing the source till production implementation and support activities.
• Microsoft Certified Professional on Business Intelligence.
• Worked in different projects as independent contributor and Team member.
• Developed a POC by using Azure Data Lake and Azure Data Factory.

TECHNICAL SKILLS

Database: SQL Server, Azure SQL, Oracle, PL/SQL

BI Tools: SSIS, SSAS, SSRS, Power BI

Cloud Platform: Azure SQL, Azure Data Lake, Azure Data Factory

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer

Responsibilities:

• Extracting and loading data from multiple sources such as Oracle and SQL Server by using SSIS to into SQL Server DWH.
• Created the Power BI reports to compare the data between two versions of the DWH.
• Used different visualizations, deployed the Reports to Power BI service.
• Worked wif different types of SSIS packages.
• Used different tasks, containers and transformations to load the data from sources to DWH.
• Deployed SSIS packages by using Deployment wizard.
• Worked wif the dynamic SQL concepts in Oracle procedures and SQL server Procedures.
• Applied different rules by using the Oracle functions and other concepts.

Confidential

Senior Consultant

Responsibilities:

• Analyzed the source data, involved in the ETL architecture, Database Design, Data warehouse design and end to end project flow.
• Created the Data warehouse Project by using SSIS and SQL Server.
• Developed the project for Azure Platform, deployed to Azure cloud.
• Developed Power BI Dashboards from Azure SSAS Tabular cube, used different types of visualizations to create the reports. Used custom visuals to handle few requirements.
• Worked on in error handling SSIS, used error mails and logging to resolve the issues.
• Deployed SSIS Packages to Azure SQL DB and executed packages by using Azure Data factory.
• Created Azure-SSIS Integration Runtime and ADF pipe lines to execute SSIS packages.
• Worked on stored procedure to load the data from stage to ODS and ODS to DWH.
• Used Azure Data Lakes to storage the data in cloud.
• Experience in using U SQL
• Created Different types of dash boards by extracting data from Azure Data Lakes.

Confidential

Senior consultant

Responsibilities:

• Worked on Azure Stream analytics and IOT hub.
• Loaded data into Azure Data Lake and SQL data warehouse.
• Created Power BI live Reports by streaming data.
• Created Power BI Reports from Azure Data Lake.

Confidential

Senior Consultant

Responsibilities:

• Modifying existing SSIS packages to accommodate the changes to the cloud connect data.
• Create Stored Procedures to load the data from source tables to DWH.
• Create new SSIS Packages to handle the changes.
• Create Design documents, architectural documents.
• Involved in Architectural discussions and decisions.

Confidential

Senior Consultant

Responsibilities:

• Extracting data from Excel, XML, flat files,SQLServer,Oracle,DB2 and transforming it and Loading into DWH and building cubes and delivers to the clients.
• Designed packages Using Control Flow Tasks like Sequence Container, For Each Loop Container, Execute Package Task, Execute SQL Task and Data Flow Task
• Developed the SSAS Multidimensional cubes.
• Maintained Custom Log tables for Incremental load, Auditing and error handling.
• Created different types of reports and dashboards by using Power BI.
• Created content packs to share the dash boards.

Confidential

Senior Engineer

Responsibilities:

• Handling support activities like resolving the production Issues.
• Analyzed the data issues by replicate the issues in support server.
• Adhere to Production SLAs and resolved incidents wif in the SLA limits.
• Involved in the enhancements to the SSIS and SSAS codes.
• Used QMS ticketing tool to address the issues.
• Experience in error handling SSIS, used error mails and logging to resolve the issues.
• Worked on root causes to provide the permanent solutions for the recurring issues.
• Developed Production Deployment tool by using SSIS to reduce the manual work of the support team.

Confidential

Software Engineer

Responsibilities:

• Designed SSRS Reporting Solution for the internal Customer Survey Reports.
• Created different types of Reports such as Charts and Table reports.
• Deployed the Packages to Report servers.
• Created subscription to send reports to the higher management.

Confidential

Software Engineer

Responsibilities:

• Extracting data from multiple Source systems Flat files and SQL databases and Transforming, Cleansing, Validating data and Loading into final Data Warehouse.
• Created partitions to increase the performance, loaded data by switching the partitions.
• Designed packages Using Control Flow Tasks like Sequence Container, For Each Loop Container, Execute Package Task, Execute SQL Task and Data Flow Task
• Dropped and recreated indexes to improve the load and extraction performances.
• Created different types of Reports by using SSRS such as Sub Reports, Drill throw, Drill down and Parameterized Reports.
• Created Linked Reports, Snap shots and scheduled reports as per the requirement.

Confidential

Software Engineer

Responsibilities:

• Handling support activities like resolving the production Issues
• Involved in the enhancements to the SSIS and SQL codes.
• Used QMS ticketing tool to address the issues.
• Experience in error handling SSIS, used error mails and logging to resolve the issues.
• Worked on root causes to provide the permanent solutions for the recurring issues.

Confidential

Software engineer

Responsibilities:

• Designed packages Using Control Flow Tasks like Sequence Container, For Each Loop Container, Execute Package Task, Execute SQL Task and Data Flow Task.
• Extracted data from sources and transformed the data using different transformations like Data conversion, Derived columns, Look up, Multicast and Union all Transformations.
• As per requirements developed the reports in the form of Table, Matrix and Chart by using SSRS2008R2
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports
• Experience in migrating SSIS projects from 2005 to 2008 R2.
• Fixed the issues raised while migrating packages from lower to higher versions.