CSC, BI Modeller
January 2011 - Present, Noida, India
• BI / Dimensional modelling, Process implementation, Technical architecting
• Analysis, Application designing, Development, Cube designing, Business reports creation
• Assisted another project on stretch time ~300 Hrs to develop the modular SSIS packages in order to load various XML files, transform and outputted them in multiple XML files
• Being certified scrum master successfully managed the releases / sprints for the project
• Developed intranet website (BDO) and invoked SSIS packages through this application
Microsoft, Technical Lead
January 2008 - January 2011, Hyderabad, Andhra Pradesh, India
• Leading the team by providing guidelines for speedy resolution of the queries.
• Analysis, Designing, development, Performance Tuning, ETL Optimization, Cube creation, Business reports creation, TSD creation, Time estimation, and impact analysis preparation.
• Analysis and implementation of PRW Reverse Engineering logic into Premier Project.
• Migrated PCD application from SQL 2005 (SSAS, SSRS, SSIS) to SQL 2008 suite.
• Build/Deployment activity automation through VSDBPro, WIX, Octopus and TeamBuild.
• Creation of DB objects like Stored Procedures, Functions, Triggers, Scheduled tasks etc
Syntel, Onsite coordinator/Database developer
July 2003 - January 2008, Mumbai, Maharastra, India
• Coordination with the client - offshore team, providing guidelines/query resolutions.
• Development, Integration testing, Time estimation, and impact analysis preparation
Administration, Data Modelling, Designing, SSIS Package creation, Performance Tuning.
Administration, Analysis, Data Modelling, Designing, TSD creation, Development, and Performance Tuning of time intensive Procedures.