Design, implement and lead Advanced Analytics, Data Modernization and Business Intelligence based solutions across multiple verticals and help client on their cloud journey to Microsoft Azure, AWS platform.Created integrated, automated, and scalable, and cost-effective Enterprise Data Hub solutions in cloud with near real time reporting and self-service capability for data engineers and business usersDesigned and implemented migration strategy for the migration of traditional infrastructure to automated cloud-based infrastructure.Proactively identified work stream /program level risks to delivery timelines and engage program leadership over weekly progress and expected outcomes.Delivered detailed roadmaps including action items and project targets.

Conducted Proof of Concept for MultiCloud solution using Azure and AWS. Conceptualized and prototyped mobile solution for client to performance tracking of insurance agents, generating an entirely new source of client engagement and revenue.Hands-on implementation of Big Data solutions (HIVE and Informatica BDM) and Azure operations dealing with IAAS Infrastructure (VMs, Virtual Networks, Azure Services and Azure Data Factories). Implemented multiple Microsoft BI (SSIS, SSRS and SSAS) solutions.Proposed performance improvement of technical objects. Worked on Agile Scrum process to deliver project needs on time and within the agreed acceptance criteria.Developed Key deliverables, process definitions, best practices, system integration and system test plans.Updated all relevant documentation including user manuals, application specifications, design documents, problem management and development procedures.Worked with Microsoft and Informatica to understand new solutions and its best practices.Provided day-to-day production support for client solution.

Extensively used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.Designed complex T-SQL queries, user defined functions; stored procedures and triggers followed by thorough analysis and testing of those database objects before deployment to the production server.Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Developed reports using SSRS tool using advanced features as Report Parameters, Charts, and Sub-reports etc.Created Business Intelligence solutions including Executive Dashboards and Business Scorecards with SSRS.Created ad-hoc queries from SQL Server databases for custom reporting needs.Developed SSIS packages and jobs using high end controls like Script tasks, Email etc. to generate various reports with proper error handling.Integrated custom .Net assemblies into Integration Services for outside the box solutions.Created custom ETL solutions using SSIS packages scheduled as jobs.Developed custom T-SQL stored procedures to perform ETL operations.

Developed high quality and re-usable packages in SSIS for ETL with extensive use of features like Data flow transformations, Breakpoints, Checkpoints, Configurations, Error Handling and Deployment.Created SQL and T-SQL scripts requiring in-depth knowledge of advanced SQL features like views, cursors, stored procedures, Functions and Indexes.Performed cleaning of raw data and transforming of data according to the business rules as required in ETL.Designed and implemented Process Training Manual using ASP.NET.Developed Client Reports using SSRS controls like navigation, charts, lists, tables.Conducted interviews and provided technical and process training to fresher level entries.Coordinated with business analysts on estimating schedules and project plans for Clients.Key Highlight: Awarded as the best planner and innovator.