SUMMARY

• Having 12 years of IT experience and 5 years working on ETL/snowflake project, worked on snowflake, Informatica and Oracle/DB2 database technologies.
• Strong experience in DWH Technologies (Snowflake, Informatica PowerCenter, Netezza, SQL, UNIX shell).
• Having working experience on IBM Mainframe using skills such as Cobol, DB2, VSAM, CICS, JCL, SQL.
• Strong understanding of operational data staging environments, data modeling principles, and data warehousing concepts.
• Ability to record and restate information in an effective and professional manner.
• Excellent understanding of SDLC process and able to work under any project management methodologies.
• Ability to identify and appropriately escalate issues/risks to management for direction.
• Ability to work quickly and accurately under pressure and project time constraints.
• Proven ability to transfer knowledge and stay aware of current trends and technical advancements.
• Strong knowledge of database SQLs and Stored Procedures.
• Strong Analytical and debugging skills. Quick turnaround time for any issues reported.
• Demonstrated ability to translate functional/high level design in detailed technical design.
• Strong time management and task prioritization.
• Strong Data modeling and understanding of key business elements.
• Strong Data analysis skills, Strong analytical skills, and SQL proficiency.
• Excellent Organizational, Interpersonal skills along with good communication and a very good team player, Ability to handle tasks independently.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

Data Engineer/ETL Developer

Responsibilities:

• Development of ETL Informatica applications and Metadata Management
• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
• Create and implement Informatica workflows
• Modify existing software to correct errors, to adapt it to new hardware or to upgrade interfaces and improve performance
• Work as part of the team to deliver on critical projects and work - related items
• Understand, translate, and create mappings using provided ETL Specifications
• Identify problems, develop ideas, and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work.
• Provided support to QA team and coordinated for various phases of testing.
• Address queries raised by QA with defined timelines.

Environment: Informatica PowerCenter, Snowflake, Oracle, DB2, VSAM files, Netezza, JIRA, Control-M, GitLab, Qtest, ServiceNow, SQL, flat files, Unix Shell.

Confidential, O Fallon, Missouri

ETL Developer

Responsibilities:

• Develop Informatica workflows to collect data from multiple data sources based on mapping specifications provided to the developer
• Provide assistance and training to developers regarding the use of ETL development standards as necessary
• Assist project team with unit testing. Develop system test plans and perform full system testing prior to implementation
• Provide guidance to onshore, offshore, and near shore development service providers as necessary
• Work closely with technical leads, analysts and developers to design and implement Oracle solutions within a structured development process
• Assist in continuous improvement efforts and enhancing project team methodology and performance
• Contribute to the design and development of Informatica master data management components of the solution in support of both member and provider master indexes

Environment: / Tools:Informatica PowerCenter, Snowflake, Oracle, DB2, VSAM files, JIRA, Control-M, Service Now, SQL.

Confidential, O Fallon, Missouri

Technical Lead

Responsibilities:

• Involved in Functional Requirements discussion and review meetings.
• Responsible for technical design and Customer Interaction.
• Coding new functionality and changes in existing, testing new/modified programs.
• Developed and maintain operational procedure documentations.
• Coordinated with internal and external customers, venders as necessary.
• Coordinated the development activity with offshore team members.
• Demonstration of IDAA usage in GCMS application with onshore and offshore teams.

Environment: / Tools: COBOL, DB2, JCL, IDAA, SPUFI, DB2 Tool, Change-Man, XPEDITOR

Confidential

Technical Lead

Responsibilities:

• Involved in Requirement Analysis, Technical Design, Development, Testing.
• Providing solutions to user requests.
• Responsible for technical design and Customer Interaction.
• Coding new functionality and changes in existing, testing new/modified programs.
• Coordinated the development activity with offshore team members.
• Production Support, Estimation, providing guidance to development team,
• Interacting with client for requirement clarification.

Environment: / Tools: COBOL, DB2, JCL, CICS, VSAM, SPUFI, XML, SOAP, FILE-AID, XPEDITOR, NDM, SOA Test.

Confidential

Senior Developer

Responsibilities:

• Analysis, technical Design, Coding, Unit Testing, providing guidance to development team.
• Responsible for technical design and Customer Interaction.
• Coding new functionality and changes in existing, testing new/modified programs.
• Production Support for Batch and online system.
• Interaction with client for requirement clarification, Defect logging and tracking.

Environment: / Tools: COBOL, DB2, JCL, CICS, VSAM, IMS-DB, SAR, NDM, FTP Control-M, BMC Remedy

Confidential

Senior Developer

Responsibilities:

• Analysis, technical Design, Coding, Unit Testing, providing guidance to development team.
• Responsible for technical design and Customer Interaction.
• Coding new functionality and changes in existing, testing new/modified programs.
• Production Support for Batch and online system.
• Interaction with client for requirement clarification, Defect logging and tracking.

Environment: / Tools: COBOL, DB2, JCL, CICS, VSAM, IMS-DB, SAR, NDM, FTP Control-M, BMC Remedy

Confidential

Senior Developer

Responsibilities:

• Analysis, Technical Design, Coding, Unit Testing, System Testing, test results review.
• Identify and document the Inventory of JCL, Cobol Programs, DCLGEN, and Files for re-hosting the applications.
• Develop the Test Strategy and create Test Plans
• Team Management activities (Status report preparation etc.)

Environment: / Tools: JCL, COBOL, DB2, VSAM, QMF, NDM, Micro Focus Enterprise Server

Confidential

Senior Developer

Responsibilities:

• Analysis, technical Design, Coding, Unit Testing, providing guidance to development team.
• Responsible for technical design and Customer Interaction.
• Coding new functionality and changes in existing, testing new/modified programs.
• Production Support for Batch and online system.
• Interaction with client for requirement clarification, Defect logging and tracking.

Environment: / Tools: JCL, COBOL, DB2, VSAM, CICS, FILE-Aid, CHGMAN, QMF, CA-librarian.

Confidential

Senior Developer

Responsibilities:

• Analysis, technical Design, Coding, Unit Testing, providing guidance to development team.
• Responsible for technical design and Customer Interaction.
• Coding new functionality and changes in existing, testing new/modified programs.
• Production Support for Batch and online system.
• Interaction with client for requirement clarification, Defect logging and tracking.

Environment: / Tools: COBOL, DB2, JCL, CICS, VSAM, IMS-DB, SAR, NDM, FTP Control-M, BMC Remedy

Confidential

Developer

Responsibilities:

• Coding new modules (batch & online) and code change in existing modules (batch & online).
• Code review, and unit testing for new and modified application Programs.
• Creating problem analysis document, estimation sheet, test case document and test results Document for production Problems.
• Communicating with OSC and client on daily basis for requirement clarification and Project status reporting on weekly basis.

Environment: / Tools: JCL, COBOL, CICS, VSAM, DB2, QMF, File-Aid, Xpeditor (Batch & Online), Change-man.