Devanshu Gupta Email & Phone Number

Cambridge, On, Ca

Waterloo, Ontario, Canada

Waterloo, Ontario, Canada

Toronto, Ontario, Canada

Waterloo, Ontario, Canada

Delivered end-to-end development to client operations for multiple complex ETL projects. Serve in a client-facing role translating business requirements related to data integration and data warehousing into robust ETL solutions. Closely working with Systems and Technical Consultants, Data Operation Analysts and Data Architects to review requirements and drive solutions. Collaborate with Data Architects and Systems Consultants for data model management and technical designs, conceptualization. Provide technical advice and consultancy to clients and management on matters of technical architecture infrastructure developments, including their feasibility. Lead discussions and questionnaire sessions to ensure solutions meet requirements. Coordination with multiple teams and meetings with client groups, stakeholders for weekly status reporting. Coordinate with multiple IT vendors and business users through project life-cycle and ensure successful completion. Build strong relationships with technical team members and business partners. Lead and execute end-to-end project implementation as a subject matter expert and provide guidance to team members. Assign work distribution to team members, ensure quality deliverables and review solutions. Coordinated and ensured on-schedule and zero-defect delivery in monthly & quarterly releases for projects, enhancements. Handled effort estimation, development, testing support & implementation. Implemented SDLC activities: Requirements gathering and analysis, design, development, testing, reviews, implementation and warranty along with configuration & knowledge management. Created entity relationship diagrams, multi-dimensional data models, reports, diagrams and technical documentation of ETL projects. Developed core technical ETL Informatica components and modules such as sources, targets, transformations, mapplets, mappings, sessions and workflows using Informatica PowerCenter 10.1.

Jaipur, India

Developed multiple Informatica ETL workflow solutions to convert and transform large flat file extracts into centralized database repository applying complex business rules, with proper error handling and audit trail mechanism. Converted legacy DTS packages for multiple systems into Informatica ETL solutions along with automating jobs scheduling for seamless continuation of batch processing. Successfully led migration of more than 30 application databases from Microsoft SQL Server 2008 to 2016 along with resolving deprecated features spanning across more than 800 database objects. Slashed nightly batch execution time by 50% by means of optimization of the job dependencies, tweaking SQL queries and performance tuning in Informatica PowerCenter ETL mappings and sessions. Work closely with clients and business analysts to optimize requirements and data mappings to meet the business needs and overcome the challenges within the systems. Collaborate with data architects, systems consultants for data model management and technical designs, conceptualization. Work in a team environment and prove to be a key contributor to the end deliverables involving ETL project releases and ETL enhancements. Work in harmony with geographically distributed teams as part of Global Delivery model. Deliver end-to-end development to client operations for enhancements in multiple applications. Implemented SDLC activities – requirements analysis, design, development, testing, implementation, warranty and handover to support. Created entity relationship diagrams, multi-dimensional data models, reports, diagrams and technical documentation of ETL projects. Developed core technical ETL Informatica components and modules such as sources, targets, transformations, mapplets, mappings, sessions and workflows using Informatica PowerCenter 9.0. • Worked on Database Design, Database Maintenance and Database Migration activities.

Jaipur, India

Subject Matter Expert for multiple project applications and support operations. Coordinating weekly communications with client for requirements discussion. Identify application pain points and derive approaches to strengthen the application processing by performing in-depth data and system analysis. Implement design, development and validation in line with architecture requirements. Provide re-engineering solutions for .NET applications and perform application level changes for business requests and enhancements. Implemented SDLC activities: Requirements analysis, design, coding, testing and implementation. Developed database objects such as tables, stored procedures, functions and views in Microsoft SQL Server 2008 database. Designed and developed Business Intelligence reports using SAP Business Objects Enterprise XI R2. Participate in knowledge management and defect prevention activities.