PROFESSIONAL SUMMARY:

• 8+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using InformaticaPowercenter (9.1/9.6/10.1 ) and Mainframes((COBOL,DB2, NATURAL, ADABAS, VSAM).
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2, ADABAS .
• Have intensively developed/read data from ADABAS and VSAM files .
• Have knowledge on data modeling with ERWIN.
• Hands on experience on Oracle Data Integrator (ODI 12C).
• Hands on experience on SSIS for investments domain.
• Used Topology Manager to define data servers and physical schemas for various sources and target databases.
• Hands on experience on dealing with ODI Knowledge Modules like, LKM, IKM, CKM and JKM.
• Worked on Join, LookUp, Split, aggregate components in ODI.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Worked on waterfall methodology and Agile methodology.
• Have led projects both using waterfall and agile in different technologies.
• Have worked in developing ETL/ELTmappings for supporting Data Extraction, transformations/loading and loading/transforming using Informatica Power Center/ODI 12C.
• Experience with dimensional modeling using star schema and snowflake models .
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Strong experience in the concepts of building Fact and Dimensional Tables, Surrogate Keys, Slowly Changing Dimensions (SCD), Cleansing, Profiling, Conversion, Aggregation, Performance Optimization and setting up Change Data Capture (CDC) mechanisms.
• Strong with relational database design concepts.
• Hands on experience in Qlik View and Tableau BI tools with both data modeling.
• Creating QVDs from DW datamart and transforming them to hold natural values using QVWs.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Skilled in performance tuning of ETL processes and SQL queries.
• Experience with creating high level design, low - level technical design, Unit test plan and Unit test results.
• Developed PL/SQL packages, shell scripts to execute the packages and PL/SQL blocks to debug the package in production environment and migrated bulk data.
• Strong business understanding of verticals like Brokerage, automotive, Mutual funds and al.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Worked in complete Software Development Life Cycle (SDLC) Implementation from Requirement gathering, analysis, data modeling, design, testing, debugging, implementation, post implementation support and maintenance
• Expertise in implementing complex business rules by creating re-usable transformations, and Mappings/Mapplets.
• Expertise in importing data from COBOL Files, Flat Files (Fixed Width and Delimited), XML files and different relational sources like Oracle, DB2, ADABAS and SQL Server.
• Scheduling jobs using CA7, Autosys, informatica scheduler etc.
• Self-learning in Python2.7/3.0, Scala and Spark using eclipse IDE.
• Extensive experience with Production support.
• Worked extensively in an agile software development process, with 2 week sprints.
• Worked with BI users to gather requirements and trouble shoot issues by back tracking from the report.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

SOFTWARE KNOWLEDGE:

Operating Systems: Windows, UNIX, ZOS.

Software/Applications: MS XP, MS 2000, MS Word,MS Excel, MS Access,Outlook,PowerPoint.

Databases: -SQLServer- 2014/2012/2008 R2/R 2/2008/2005/2000 , Oracle11g/10g/9i,ADABAS,DB2.

File Organization: VSAM.

ETL: InformaticaPowerCenter 7.1/8.1/8.6.1/9.1/9.5/9.6.1

ELT: ODI 12C

Utilities: Informatica Power exchange 8.6.1, Metadata Manager, IBM Utilities, Abend-Aid.

Languages: SQL,PL/SQL,NATURAL,COBOL.

Tools: SQL developer, Beaver, Visio, TOAD,CA-7.

PROFESSIONAL EXPERIENCE:

Confidential, Charlottesville, VA

Senior ETL developer/Senior Data Analyst/PL/SQL Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Work on developing the entire ETL design to retrieve data from various sources and build the stage data that will be used by the DW process to load the final tables.
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
• Responsible for creating complex mappings according to business requirements, which can are scheduled through ODI Scheduler
• Develop and work on Slowly Changing Dimensions Type 1, 2 and 3 types processes.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• As a PL/SQL Developer created sprocs in Oracle to meet the available technology usage.
• Created complex mapping involving multiple transformations including procedure transformation to have the codes utilized instead of sun-setting them.
• Used Informatica file watch events to pole the FTP sites for the external Oracle Ebusiness Suite.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Create data model for the star schema developed using ERWIN.
• Create, manage and modify logical and physical data models using a variety of data modeling philosophies and techniques including Inmon and Kimball models.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.
• Have been POC for all the above mentioned modules and have groomed team members as and when needed.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Created functional documents, business requirement document, low-level technical design document, unit test plan and unit test results.
• Production support, issue analysis, trouble shooting, etc.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Wrote test scripts in ETL validator and table & flat file comparison scripts.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica10.1 , Informatica Power exchange 10.1.1, Informatica Metadata Manager, Oracle 11g, Qlik Sense/view, Unix, ETL Validator 3.4.7(DATAGAPS).

Confidential, Reston, VA

Senior ETL developer/Data Analyst

Responsibilities:

• Data analysis on the scores processed for each assessment.
• Creating SQL queries to provide data requests to business users.
• Created packages to run every day to produce reports for different data points.
• Created CDC to have sync up between schemas to have the data maintainability applied.
• Worked on star schema to load data to dimension and fact tables to be used on Cognos to create user report.
• Developed ETL programs using Informatica to implement the business requirements.
• Develop and work on Slowly Changing Dimensions Type 1, 2 and 3 types processes.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Maintain/modify sprocs/packages in oracle to meet the available technology usage.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Was involved in Production Support, trouble shooting and fixing ongoing issues.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Wrote validation scripts for unit testing and QA testing. Minus query, relational table difference and flat file difference.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: InformaticaPowerCenter 9.1 , InformaticaPowerExchange 9.6.1, Oracle 11g, Cognos 10, SQL server 2014, Unix.

Confidential, Aurora, CO

Senior ETL developer/SQL developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Work on developing the entire ETL design to retrieve data from various sources and build the stage data that will be used by the DW process to load the final tables.
• Develop and work on Slowly Changing Dimensions Type 1, 2 and 3 types processes.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Created sprocs in SQL developer to meet the available technology usage.
• Created complex mapping involving multiple transformations including procedure transformation to have the codes utilized instead of sun-setting them.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Created JIL files to promote new ETL jobs.
• Created .ksh script and placed as an Autosys jobs thru JIL(job information Language).
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Created functional documents, business requirement document, low-level technical design document, unit test plan and unit test results.
• Production support, issue analysis, trouble shooting, etc.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Wrote unit test scripts and table& flat file comparison scripts.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 9.1 , Informatica Power exchange 8.6.1, Informatica Metadata Manager, SSIS, SQL Server 2014, Cognos 10, Autosys, Unix.

Confidential, Franklin, TN

Senior Data Analyst/Mainframe/ETL developer

Responsibilities:

• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Worked in complete Software Development Life Cycle (SDLC) Implementation from Requirement gathering, analysis, data modeling, design, testing, debugging, implementation, post implementation support and maintenance
• Expertise in importing data from COBOL Files, Flat Files (Fixed Width and Delimited), XML files and different relational sources like Oracle, DB2, ADABAS and SQL Server.
• Scheduling jobs using Autosys, CA7, Informatica scheduler etc.
• Worked extensively on BMC remedy, ITSM ticketing tools.
• Have done RCA for CPIA,VSC,CA applications.
• Have been SME for VSC/CA/CPIA applications.
• Worked closely with BIDW team for various new requirements/enhancements/RCA.
• Extensive experience with Production support.
• Analyze ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 9.6.1 , Informatica Power Exchange 9.1/9.6, Informatica Metadata Manager, SQL Server 2008 R2, Mainframes (COBOL, VSAM, DB2, NATURAL, ADABAS).