SUMMARY

• Having 9+ years of vast experience in IT industry with wide range of skill sets, roles and industry verticals.
• Expertise in Financial Services and Insurance Domains.
• Having 6+ years of work experience in Informatica using Informatica Power Center and experienced major roles as Senior Developer.
• Mainframe Analyst with Over 3 Years of experience in Analysis, Design, Development, Testing & Prod Support of systems in Mainframe .
• Extensive experience in Informatica Power Center and Informatica Power Exchange to implement data marts which involve creating, debugging and executing mappings, sessions, tasks, and workflows and testing SQL queries.
• Actively involved in all stages of SDLC including requirements analysis, estimation, high level design, low level design, coding/testing/review, integration testing, installations, scheduling and production support.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files and Mainframe into Warehouse.
• Experienced in developing Database Design Document including Data Model: Conceptual, Logical and Physical Models using Erwin.
• General understanding of Database Management System and Data Warehouse including their functional and technical architecture and the design of Data Flow Diagram.
• Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Implementation and Support of various web based applications in OLTP, Data Warehousing, and OLAP application.
• Extensively worked with Slowly Changing Dimensions(Type I, Type II and Type III).
• Experience on Informatica designer tools - transformations, reusable transformations, mappings, and mapplets.
• Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions; experienced optimizing query performance.
• Worked extensively with Informatica Workflow Manager (using tools such as Task Developer, Worklet and Workflow Designer, and Workflow Monitor) to build and run workflows.
• Exposure to Teradata BTEQ, FastLoad, MultiLoad, T-pump,TPT utilities and Netezza.
• Experience using CTRL+M 7.0 for scheduling workflows.
• Extensive knowledge and hands on experience in z/OS, OS/390, COBOL, JCL, VSAM, DB2, MQ Series and CICS.
• Well versed with all Tools/Utilities like - FileAid, Abend-Aid, Intertest, DFSort/ICETOOL, CHANGEMAN, TSO/ISPF, IDCAMS, SPUFI, QMS, SQL and other IBM Utilities.
• Excellent communication and strong interpersonal skills with ability to interact with end-users, managers and technical personnel.
• Experience in leading teams. Roles included Project Lead, System Analyst, Onsite Coordinator and Developer.
• Expertise in Technical documentation, Induction Manuals, User guides, Documents, Traceability Matrix, Weekly & Monthly Status reports.
• Working on both Water fall and agile methodology.

TECHNICAL SKILLS

Software/IDE: Mainframe, SQL*PLUS, TOAD

Languages: COBOL, JCL, SQL, CICS,ADSO, Sync Sort, CLIST,CICS and REXX

Database: DB2, VSAM, Oracle, SQL Server and IDMS.

ETL Tools: Informatica Power Center 8.x

Special Software: File-Aid, DFSORT, Expeditor, FTP, NDM, VSAM, REXX, MQ Series, Abend-Aid, Lotus Notes, and SPUFI

Scheduling Tools: Job Trac and CNTL+M

Migration Tools: Change man, Endeavour and SCM

Documentation: IBM Domino DOC, Document Direct

Defect trackers: Clear Quest, JIRA and STAR

Office Tools: MS Word, MS PowerPoint, MS Visio, MS Access, MS Excel, Share Point

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr. ETL Developer

Responsibilities:

• Actively participated in the business meetings with business users to get the business requirements.
• Participated session meetings for understanding of data points, identifying the source systems and target system paths.
• Used Informatica to extract, transform and load data from multiple input sources like Oracle/ SQL Server, Flat files into Oracle 10 g database.
• Extensively Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Used different transformations like Aggregator, Filter, Router, and Sorter, Stored Procedure, and Sequence Generator, lookup, Expression and update strategy in the development of mappings.
• Performed various reusable techniques for business logic reusability like mapplets, Reusable transformations, and reusable sessions.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files and Mainframe into Warehouse.
• Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Implementation and Support of various web based applications in OLTP, Data Warehousing, and OLAP applications
• Design/Develop/Monitor/Schedule Workflows, Sessions, Event based tasks, parameter files, pre-session/post-session tasks for development/UAT/SIT environment.
• Developed Unix shell scripts to FTP source files, validate source files, automated archival of Log files, through PUTTY.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system.
• Implemented Slowly Changing Dimensions (SCDs: Type 1, Type 2 & Type 3).
• Involved in fixing invalid Mappings, testing of Stored Procedures and Testing of Informatica Sessions, Batches and the Target Data.
• Responsible for internal reviews of the deliverables by the team members.
• Monitored Workflows and Sessions
• Developed Unit test cases for the jobs.
• Responsible for attending status meeting with offshore team..
• Recruit & Manage the Offshore Development Team to track the productivity and deliverables.
• Provide the team with technical leadership on ETL Design, Development best practices, Version Controlling and customization of Data loads.

Confidential, Minneapolis, MN

Sr. Mainframe developer

Responsibilities:

• Interacting with Business Users and Business Analysts to gather requirements
• Contribution related to Requirements Study, Analysis, Estimation, Design, Development, Testing and Implementation
• Understanding the Business Requirements and analyze the system for enhancements and converting them into a Technical Design.
• Design review with Architects
• Coded programs and modified existed programs as per specification requirements in VS COBOL using DB2, VSAM files and Flat files.
• Responsible for internal reviews of the deliverables by the team members.
• Responsible for attending status meeting with onsite coordinators.
• Unit testing, reviewing results & preparing U.T.R’s (Unit Test Results)
• Peer reviewing the components.
• Code reviews with Tech Leads and Maintenance Team.
• Support for Implementation, QA and User acceptance Testing.
• Set the dependencies for new jobs and scheduling the jobs in CTL-M.
• Resolve batch cycle issues and ABENDS during the batch run
• Create exception and adhoc jobs.
• Writing SQL queries
• Support System testing and Release testing.
• Implementation and warranty support.
• Prepared induction Manuals, Flow charts of Batch/Online systems.
• Preparing wisdom solutions for changes implemented.
• Handled multiple projects at the same time.
• Worked on REXX tools to improve quality of deliverables and in impact analysis.