OBJECTIVE:

To continue my career with an organization that will utilize my experience and skills in Development/ Maintenance projects of Data Warehouse, Data Migration and Integration using Amazon Web Services to benefit mutual growth and success.

PROFESSIONAL SUMMARY:

• AWS Certified Solution Architect - Associate and having one-year experience in AWS project
• 12 years of IT experience in Analysis, Design, Solution-ing, Development, Implementation/ Support and Testing using ETL different tools
• 10+ years of extensive experience in Informatica PowerCenter (6x, 7x, 8x and 9x)
• In-depth knowledge and experience in Design, Development and Implementation/ Support of various interfaces, Data Migration & Loading for Siebel CRM applications
• Experience in Requirement gathering and FRD documents creation
• Experience of End-to-End Implementation of a Validated System in Life Science domain
• Experience with Windows Batch/ UNIX shell scripting - Controlling Data Loading sequence & Informatica Workflow
• Strong functional understanding of Life Science domain and Healthcare domain
• Basic understanding of Insurance, Aviation and Retail domain
• Experience in working in an agile team

TECHNICAL SKILLS:

• Amazon Redshift
• Teradata 10.14
• Oracle 8i, 9i, 10g and 11g
• Microsoft SQL Server 2005
• DB2 UDB7, IBM UDB DB2 9.7
• Windows scheduler
• Informatica scheduler
• Control M

FUNCTIONAL SKILLS:

• Requirement gathering
• FRD document creation
• Designing the ETL frameworks
• Reviewing code, debugging and troubleshooting the application
• Providing post-implementation, application maintenance and enhancement support to the client
• Extensive domain knowledge Insurance, Life Science, Aviation and Retail

WORK EXPERIENCE:

Confidential

Associate System Engineer

Responsibilities:

• Senior Consultant of Datawarehouse Design and Development team
• Responsible for Designed and developed ETL jobs based on requirement
• Extensively involved in Design, Development, Unit Testing and Review of new data warehousing jobs
• Responsible for deployment for higher Environment

Confidential

Responsibilities:

• Lead Consultant of Informatica development team with complete delivery responsibilities for member interfaces
• Responsible for documentation and process definition
• Technical Design Document
• Mapping document
• Unit test document
• Designed Interface Data Flow based on requirement
• Extensively involved in Design, Development, Unit Testing and Review of new Interface jobs
• Responsible for deployment planning and deployment for higher Environment
• Responsible for Scheduling Interface jobs
• Responsible for Demo session with State
• Responsible for coordination with SME, DBA and Deployment team
• Responsible for SAT support and fix defect within time

Confidential

Responsibilities:

• Lead Consultant of Informatica development team with complete delivery responsibilities for SFDC Application
• Responsible for Leading Data Migration & Integration team from Customer location
• Responsible for requirement gathering in liaison with Business users
• Planning and co-ordination with customer and SFDC team for solution of different issues and requirements
• Responsible for documentation and process definition
• Functional Requirement Document- Data Migration & Interface
• Technical Design Document- Data Migration & Interface
• Reviewed, Walked through and Signed off: BRD, FRD & TSD Documents
• Designed Data Migration and Interface Data Flow
• Extensively involved in Design, Development, Unit Testing and Review of new Interface jobs
• Responsible for deployment planning and deployment for Data Migration to Production Environment
• Responsible for Scheduling & Monitoring Interface jobs during Post Production Warranty
• Data validation in GPM and SFDC environment
• Scheduling of Interface jobs using Maestro Scheduler

Confidential

Responsibilities:

• Lead Consultant of Informatica development team with complete delivery responsibilities for Siebel Confidential and Siebel One Stop Shop Application
• Responsible for Leading Data Migration & Integration team from Customer location for Siebel Confidential
• Responsible for requirement gathering in liaison with Business users
• Planning and co-ordination with customer and multiple vendors for solution of different issues and requirements
• Responsible for documentation and process definition
• Functional Requirement Document- Data Migration & Interface
• Technical Design Document- Data Migration & Interface
• Interface Agreement document
• Reviewed, Walked through and Signed off: FRD, TSD & Interface Agreement Document
• Designed Data Migration and Interface Data Flow
• Extensively involved in Design, Development, Unit Testing and Review of new Interface jobs
• Actively involved in PQ & PPQ, facilitate execution in direct coordination with business users
• Responsible for deployment planning and deployment for Data Migration to Production Environment
• Responsible for Scheduling & Monitoring Interface jobs during Post Production Warranty
• Design, Development and Unit Testing of IFB files to load data in Siebel application through Siebel EIM
• Performance Tuning: Source level, Target level and Map level bottlenecks
• Experience with Informatica Repository Manager: Creation Folder and Assign Privileges, Import, Export Objects
• Scheduling of Interface jobs using Informatica Scheduler and Windows Scheduler
• Full responsibility and ownership for maintenance of all the interfaces in Production Environment

Confidential

Responsibilities:

• Responsible for Design, development and unit testing of ETL jobs using Informatica Power center
• Worked extensively on different application transformations like expression, joiner, lookup, normalizer in order to integrate different sources systems
• Extensively used of variables and parameters
• Responsible for Deployment plan for Data Migration
• Responsible for project deliverables like FSD, TSD and process walkthrough documents

Confidential

Responsibilities:

• Experience in Design, Development and Testing of data migration process using SAP BO DS/DI
• As a certified SAP BO DS/DI developer responsible for creating projects, developing job, workflow, data flow using various transformations script
• Experienced in Various Transformations like Validation Transformation, Merge Transformation, and Case Transformations
• Involved in the preparation of test scripts, Unit testing, system and integration testing
• Responsible for building the SAP BO DS/DI/DQ expertise in the team and build up Knowledge Repository