Profile

• 7 Years and 6 Months of experience in Analysis, Design, Development, Testing, Implementation and Production support in DW/BI applications.
• Extensive ETL experience using Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager for Multiple Source types Like Database and Flat Files and Multiple Target types as well.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema, Also have experience in Slowly changing Dimensions
• Vast experience in Understanding Business Requirements, Technical Design, Estimation and Project Management activities, Also have experience in Reqpro and Rational Tools
• Extensive experience in Preparing Flow Charts, Analysis Reports, Technical Design documents, Profiling results and Data Modelling.
• Proficient experience in designing SQL's using Teradata, DB2, PL/SQL and working with flat files.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD.
• Created UNIX shell scripts to run the Informatica workflows, FTP and controlling the ETL flow.
• Have worked and User scheduling tools like WLM, Control M.
• Development and Reporting experience in Business Objects Designer and Desktop Intelligence.
• Expertise in Teradata query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks. Query Rewrite, tuning Mappings and Sessions.
• Have expertise in Industry's best practices, Coding standards. Preparing User Manuals, Presentations, Bug Fixing, Troubleshooting, Root Cause analysis and Solution Development.
• Strong documentation skill using Microsoft Word and Excel.
• Have good experience in Managing Team Offshore and Onshore to Coordinate Work.
• Extensive experience with analysis, design, development, customizations and implementation of software applications related to ezetrieve, COBOL and DB2.
• Agile delivery of software using practices from SCRUM
• Experience in Peer-reviewing the Codes Results , Transformations and Performance as part of System Integration Test SIT and User acceptance Test UAT
• Having Healthcare Domain Knowledge and Certifications
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Skill Set

• ETL Tools : Informatica Power center
• Database : DB2, Teradata
• Database GUI : Teradata SQL assistant, Mainframe DB2.
• Programming Languages : PL/SQL, UNIX Shell Script, JCL, COBOL, Ezetrieve, VSAM
• Reporting Tools : Business Objects designer and Desktop Intelligence
• Operating Systems : UNIX, Windows NT/2000/XP/7, OS/390, ZOS Mainframes
• Development Tools : Endeavor, File manager and debugger
• Processes : IBM's QMS Quality Management System
• Scheduling Tools : Workload Manager WLM , Control M

Professional Experience

Confidential

Senior Software Engineer

Responsibilities:

• Lead Offshore teams of India and Phillipines.
• Involved in Business Users Meetings to understand client requirements.
• Transform the Business requirements into Technical requirements.
• Worked with Billions of Data as Enterprise Warehouse house Data for 14 States.
• Have prepared Project Plans, Estimates based on the Work effort and the Complexities.
• Develop Optimum Design and Conduct Design Review meetings with Architects for the Technical requirements and obtain their Design approval
• Transform the Design into Flow Charts, Workflows and Explain that to the Developers.
• Worked on Heterogeneous Source and Target Systems for Movement of Data
• Worked with FTP Teams and Vendor to establish the connectivity and the Transmission Protocols.
• Peer reviewed each Design and given suggestion for an Optimum design and Code based on Performance and Coding standards.
• Worked with the Developers to profiling the Data, Analyzing the Join conditions, Development of Mappings and write the Informatica code UNIX scripts.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Transaction Control, Sorter and Sequence Generator transformations.
• Worked on code merge between two different development teams.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Wrote codes in Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process. Also wrote codes in FTP scripts and Post Process Scripts for Data Validation.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Coded BTEQ Teradata scripts to extract Data and Send it to the Vendor.
• Effectively worked on Onsite and Offshore work model. Conducted Project Health and Status meeting using SCRUM calls.
• Created and scheduled Sessions for different Job setups like on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Extensively worked with Scheduling Teams to setup the Job flows and Processes.
• Developed implementation and test plans, built software acceptance criteria, coordinated and worked with clients to oversee the acceptance and dissemination process.
• Performed Unit, Integration, System testing of Informatica mappings and Workflows.
• Created Test plans and Test cases and discussed with the Stakeholders for the things in scope and documented them in the rational tools.
• Tested the Informatica and UNIX components based on the Test plan and prepared Test evaluation summary reports for Stakeholders sign-off.
• Communicate activities/progress to project managers, business development, and clients.
• Performed User acceptance testing for different modules and Supported Vendor for the Data.
• Developed Error and Validation reports as per the User requirements
• Created Universes and generated reports in Business Objects using Star Schema.
• Doing Production Support and resolving abends.
• Maintained Quality Procedure for the code and continuously monitor and audit to ensure code meets quality goals.
• Mentoring new People and giving them technical as well as business knowledge.
• Have created User Manuals and Development guide for best practices and presented it across the Team and Clients.