SUMMARY:

• Having 12 years of total IT experience that span across in Health care, Banking, Financial and Retail, domains. In depth knowledge about various phases of IT projects which include planning and designing, gathering business requirements, analysis, development, testing, data modeling, data governance and implementation encompassing both waterfall and AGILE SDLC methodologies.
• Works with Stakeholders to capture the business requirements, functional specifications & enhancements to create technical design and functional specification documents.
• Strong Exposure in Data Warehouse concepts like Star schema & Snow - flake schema. Experience in implementing Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements using INFORMATICA Power Center(9.6/10.1)
• Well experienced in Analysis, Design, Development, Testing, Implementation and Support of Data Warehousing projects and Legacy System Applications.
• Worked with heterogeneous source systems ranging from legacy systems, Databases like TERADATAv13, Vertica 6.1, DB2, Oracle, XML and flat files.
• Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.
• Proficient in Unix Shell scripting, Shell programs were developed for data cleansing, data movement and validation.
• Hands on experience on handling huge volume of data and performance tuning. Successfully worked in global delivery models working with offshore & onsite teams
• Widely used JIRA Dashboard to track the issues and communicate with the team members upon the particular issues.
• Experienced in Mainframe technology- JCL, COBOL, VSAM, DB2 and CICS.

TECHNICAL SKILLS:

Data warehousing Tool: INFORMATICA POWERCENTER 9.X/10.1, INFORMATICA Cloud

Database: ORACLE 9i/10g/11g, Teradatav13, Vertica 6.1, MS SQL server 11, DB2 & IMS

Scripting Language: SQL, Unix Scripting, Bteq, Fast load & Multiload

Data Modelling: CA Erwin

Reporting tool: Business Objects XL R3

Scheduling Tools: WLM, Control-M(CTM), ESP & CA-7

Others: JIRA, SNOW Now, HPSM, MS Office suite including MS Visio

MAINFRAME: COBOL, JCL, CICS, VSAM, CHANGEMAN, ENDEVOUR, FILE-MANAGER, File-Aid, SPUFI.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead, Virginia

Responsibilities:

• Worked closely with Business analysts and Data architects to understand and analyze the user requirements and prepare functional and technical documents
• Involved in building the ETL architecture including source to target mapping to load the data into the data warehouse.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations.
• Performed data manipulations using various Informatica Transformations like Aggregate, Filter, Normalizer, Sequence Generator etc.
• Set Up ODBC, Relational and FTP connections for Teradata, DB2 and flat file.
• Developed Mappings, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules.
• Extensively used Change data capture concept in Informatica to capture the changes in the datawarehouse.
• Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Developed logical and physical data models that capture current state/future state data elements.
• Generated UNIX scripts for automating daily load processes.
• Generated completion messages and status reports using workflow manager.
• Involved in preparing ETL specifications and unit test plans for the mappings.
• Extensively worked in the performance tuning of the ETL process.
• Successfully migrated the mappings to the testing and production environment.
• Exposure on INFORMATICA Cloud Real Time technical skills.

Tools: INFORMATICA Power center 10.1/9.6, INFORMATICA Cloud, Teradata v13, MS SQL serverDB2/IMS, UNIX, JIRA, Business Object, WLM/CTM

Confidential

Senior ETL Developer, PA

Responsibilities:

• Analyzed functional specifications provided by the architect and created technical specifications document.
• Ensured architectural adherence through blueprint and design reviews.
• Designed and implemented the complex project with high quality.
• Developed logical and physical data models, DB2 look alike physical model structures that capture incremental and history data.
• Performed data manipulations using various Informatica Transformations like Joiner, Sorter, Router, Filter, Expression, Aggregator, Union, Update Strategy & Look Up.
• Extensively used Change data capture concept in Informatica to capture the changes in the datawarehouse.
• Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Support of bug fixes and data issues reported.
• Designed data feeds to load Teradata tables from flat files, using BTEQ scripts.
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.
• Applied different optimization techniques to enhance performance at various levels which includes SQL tweaking, Sourer, Target and transformation level optimization.
• Extended support for SIT & UAT
• As part of release management, participated in migration of the components till PROD from development environment.
• Logical and Physical data model build using ERWIN.
• Created WLM/CTM jobs to automate run and designed required recovery/ad-hoc components.

Tools: INFORMATICA Power center 9.6, Oracle 10g, UNIX, SQL developer, WLM

Confidential

Senior System Developer, TX

Responsibilities:

• Worked closely with business team to finalize on the validation rules that need to be applied outside Informatica ETLs.
• Participated in meetings with business analysts to understand the user requirements and assisted in the design of BRS.
• Created technical specification document for each workflow in exhaustive detail listing all technical and business validation rules, look-up tables and error messages.
• Reviewed the design with project tech lead and test team.
• Using Informatica Power Center Designer, designed Mappings.
• Created Mappings with Transformations, Sessions and Workflows.
• Created various transformations such as Expression, Lookup, Joiner, Router, Filter, Aggregator and Sequence Generators.
• Created and used reusable transformations when required.
• Extensively used mapping parameters, mapping variables and parameter files.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping
• Logged the errors during execution in Error tables.
• Created backup tables to store the history of all the transactions performed on the given data.
• Worked with Informatica administration and integration teams to migrate code to higher environments without any glitches
• Created training guides and run books for production support team

Tools: Informatica power center 8.6, ORACLE 8i, DB2, ERWIN, Unix shell scripting

Confidential

System Developer

Responsibilities:

• Ensured architectural adherence through blueprint and design reviews.
• Analyzed existing system and prepared and presented Impact Analysis.
• Support of bug fixes and data issues reported.
• Experienced in Requirement Gathering, Analysis, Design and Development.
• Write High level and Technical design documents.
• Developed new batch and online functionalities using COBOL, DB2, CICS, VSAM and JCL
• Developed Online Screen using Basic Mapping Support(BMS) macros.
• Develops test plans to verify logic of new or modified programs. Identifies issues as appropriate
• Assists in resolving production support problems. Develops and suggests alternative approaches to resolving problems.
• Understanding the business process and updating SAD (System Appreciation
• Documents)
• Worked on project under SOA architecture.
• Involved in user reported Issues - Root cause analysis & its fix
• Managing MF batch jobs & Online transactions
• Fixing Job failures/Transaction abend - Data Issues & Problem Management
• Reviews and attend client meetings.
• Quality assurance by defect tracking.
• Ownership of the checklists.
• Project Co-ordination with various application teams involved

Tools: - Cobol, JCL, CICS, DB2, IMS, File Manager, File-Aid, Fault Analyzer, SPUFI, CA -7, Endevor