~Worked on Data Conversion phase to implement new system by transforming existing data

~Understanding business requirement and Worked on ELT approach using SSIS

~Created required etl packages & performed unit testing

~Performed several assessments on the existing BI systems to prepare data model documentation for new Cloud data warehouse on Redshift

~Worked on dimensions and facts creation

~Wrote the source query/ stored procedures which helps to create the business reports

~Analyzing the new functional requirement(s), and propose solution POC

~Working aside with On-shore architect on designing

~Creating the optimized SSIS ETL packages with required SQL procedures

~Worked on performance tuning of existing packages/solution

~Worked on existing cube issues & creating new cubes for business analytics using SSAS

~Wrote the source query/ stored procedures which helps to create the business reports

~Created new business reports using SSRS and Power BI

~Handled daily status calls with client, Scrum meetings

~Training and assisting new associate resources within team

~Responsible to design new packages as per the project requirements

~Implement enhancements to the existing packages with new features

~Worked on CozyRoc SSIS components to add additional features to packages

~Creating and running the Unit Test conditions to the implemented/enhanced packages

~Performing job execution on the designed interfaces

~Coordinating with the dependent teams on the changes/new features