Prateek Singh Email & Phone Number

A dynamic, team spirited and performance driven professional with 9+ years of experience in IT (Software) industry, presently associated with BCG as Business Intelligence Manager. Has successfully worked on finance domain with multiple clients across the world (India, UK)- Client experience of activities like requirement gathering,impact assessment, solution design, test team support, integration and project transition. - Expertise in all phases of a project lifecycle starting from requirement gathering and design up to coding, testing and maintenance. - Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS, creating packages to extract data from different sources and load into various Business Entities using logging, event handler, configuration, parent-child package, security, scheduling etc. - SQL Expert to write complex queries (inline view/derived table, Correlated Sub queries, Dynamic SQL), Complex Views, different types of joins, different types of statements (DML, DDL) etc.- Analyzing IT requirements, proposing solutions and their implementation.- Preparation of high level and detail level design. - Design and develop store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance. - Coordinate work flow between Onsite, Offshore andMiddleware teams. - Conducted trainings on project specific Technologies, Domain to other team members.

• 

  Guru Gobind Singh Indraprastha University

  Computer Science