SUMMARY

• 8+ years of IT experience and 6 years in Data Warehousing, which includes requirement analysis, Gap analysis, Source Systems Analysis along with design, development, testing, data modeling, ETL jobs, Shell scripting, Query optimization, Performance tuning, full cycles of SDLC, Data Cleansing and Production support monitoring.
• Aspiring Professional with proven record in Planning, Executing, Controlling and Designing implementations in projects life cycle using Agile methodologies.
• Strong subject and technical matter expert at inception, elaboration, construction and transition stages of various successful data warehouse and data migration implementations complying with industry best practices.
• Successful implementation of Telecom, Health Care, Retail and Financial Data Warehouses, OLTP and Operational Data Store systems in wide variety of businesses.
• 3+ years of experience in job monitoring with scheduling tools on Unix box in production environment.
• Involved in writing Test strategies, Test plans, Test cases, Test scripts, Test summaryreports, test tractability matrix and defect reporting.
• Involved in coordinating development activities with onsite and off shore team and participating in status meetings with clients.
• Extensively involved in writing scripts to Extract, Transform and Load raw data (XML, EDI, Flat files, IDOC’s, DB) into tables as part of Data Warehousing development using Power CenterTool.
• Worked extensively on Query optimization & Performance tuning for maximum throughput, and benchmarking.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in using Informatica Power Center to create and schedule workflows and expertise in Control - M for scheduling.
• Strong technical development and design experience with systems integration and interface development
• Experiencein working with developers and application support staff in System, Unit, Functional, Integration, Regression, User Acceptance testing and troubleshooting applications.
• Ability to solve complex technical problems and work under time constraints.Highly skilled, self-motivated team player, excellent communication and interpersonal skills with results oriented dedication towards goals.
• Involved in on call rotation schedule supporting 24/7 production applications.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5, 9.1(PowerMart &Power Center)

Languages: PL/SQL, Shell scripting, Cobol, JCL

Databases: Oracle 11g/10g/9i, DB2, SQL Server 2008 R2/2005, Teradata 13.10, Mainframes

Tools: and Utilities SharePoint, Teradata SQL Assistant, Teradata Administrator, BTEQ, TOAD, Quality center expert, ITSM Tools (Service Now, AOTS-Remedy), File Manager, Change man, SPUFI, FMIMS, SOAPUI (UI).

Operating Systems: Z OS, Windows 10/7/2000/XP/NT, UNIX, Linux

Scheduling Tools: TVM, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Sr Informatica Developer

Responsibilities:

• Correcting Informatica and Vertica scripts of failed jobs and testing data throughput in consecutive runs until desirable results are obtained.
• Executing scripts for data count, number of files and rejected data as a part of testing for successful data-load.
• Complete analysis of life cycle of a process from data being obtained from the source till loaded to the target including the archival process, which is supposed to be run daily weekly, or monthly.
• Creating guides for commonly occurring errors stating the reason and mitigation steps for smooth handover across shifts.
• Fixing all types of failures involving Teradata, Informatica and Vertica failures and involvingstakeholders that are TDBA's/VDBA's/L3 teams at various levels if required.
• Reporting current status of the critical issues to the client and managers in daily calls, which included detailed discussion of strategies to mitigate the issue by clearing all roadblocks.
• Conducting team meetings to discusstasks ownership and ongoing issues within team members.
• L2 level support and failure fixtures for 29 SLA and around 300 Non-SLA applications using Teradata SQL Assistant, Teradata decision expert, Unix shell scripting, Informatica power center and AOTS Remedy etc.
• Preparing various weekly/monthly reports to track improvements and monitor SLA's progressions via Gantt charts.
• Responsible to send proactive notifications in case of any SLA misses and open triage to involve all stakeholders unless issue is resolved.
• Taking KT sessions for the team and new team members and brief them about various tasks and responsibilities that needs to be taken care as a T1/T2 resource.

Environment: UNIX, Informatica Power Center 9.6.0, Teradata 13, Oracle 11g, Windows 7, AOTS Remedy.

Confidential, Concord, New Hampshire

Sr. ETL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, testing and implementation of project Hub ODS.
• Involved in the meetings with business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the ETL loading
• Work with multiple teams and Subject Matter Experts (SMEs) performing development activities across all phases of the project development lifecycle and participated in GAP analysis.
• Provided in-depth technical consultation to ensure development of efficient application systems by utilizing established methodologies and best practices
• Followed AgileDevelopmentmethodology starting from the User Stories reviews, planning, development and testing of the objects.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Worked on Informatica transformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected & Unconnected Lookup transformation, Sequence Generator etc.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Developed Informatica SCD type-I, mappings and tuned them for better performance. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Coordinated deployments that include Informatica deployments as well as Unix Shell Scripts, Database DDL, DML Scripts. Automated scripts to enable Job status information.
• Extensively wrote user SQL coding for overriding generated SQL query in Source Qualifier.
• Used Power Center (Designer, Workflow Manager, Monitor and Administrator) at variety of stages. Designed templates and used them for coding jobs for loading dimensions, details, facts and summaries. ETL naming standards were strictly followed.
• Used designer debugger along with session log to monitor data flow and fix related bugs.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of the project with the workflows and their dependencies.
• Created and scheduled Interface jobs to feed data into Dashboard applications using Autosys
• Involved in Unit testing of Mappings, Workflows and debugging mappings for failed sessions.
• Involved in end-to-end Integration testing and issues/defects resolution and coordination with off shore team
• Used ITSM tool Service Now for troubleshooting user issues and service requests.

Environment: Informatica Power Center 9.1, Oracle 11g, UNIX, Service Now,Autosys, DB2.

Confidential, Milwaukee, WI

Sr. ETL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, testing and implementation.
• Responsible for Functional specs signoffs for OTC and STP objects and Involved in source to target mapping documents.
• Coordinated with Master Data team and Legacy data team in creating design standards and technical specifications for power-center jobs.
• Responsible for conducting daily scrum calls with different data leads about integration testing of all the objects.
• Design Jobs for Order to Cash (OTC) and STP Schedule to Produce (STP).
• Responsibilities include migration of jobs for multiple process areas across different projects.
• Involved in troubleshooting failed jobs, fixing bugs, performance tuning and enhancements.
• Used Power Center (Designer, Workflow Manager, Monitor and Administrator) to develop business compliant mappings.
• Involved in unit testing and validating the data on target SAP system and Familiar with the SAP table structures and T-codes.
• Created job sequences to control networks of jobs and handle the load dependency.
• Used Autosys to run, monitor and schedule the jobs.
• Involved in Unit Testing and developing Test Cases for various complex scenarios of input data.
• Provided On-call support 24x7 when required.

Environment: Informatica 8.5/8.1,SAP ECC 6.0, Autosys,Oracle 11g, UNIX, Windows XP, HP Quality Center, Microsoft Access.

Confidential, Woodland Hills, CA

ETL Developer

Responsibilities:

• Designed the ETL Framework that included Data modeling for Staging Database
• Written single reusable Code with Table driven/Parameterization for migration of 8 source systems
• Involved in the meetings with business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the ETL loading
• Worked with data modelers in preparing logical and physical data models.
• Integrated 3rd Party Business Rule engine to validate the Staging Provider Information
• Understanding functional specification, data model requirement and ETL specification document and preparing HLDs and LLD’s of, to be implemented requirement.
• Perform mock conversions to load data in test environments
• Involved in Integration testing and UAT Support.
• Analyzed existing system and prepared and presented Impact Analysis.
• Prepared technical design documents based on BRD and SRS in a standard template explaining entity relationships and its components.
• Created Shell scripts for Automating of Worklets, batch processes and Session schedule using pmcmd.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow and if deposited correctly in Target Tables.
• Scheduled the jobs through UNIX shell scripts using CTL-M.
• Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.
• Used Remedy to log and track user issues.
• Extensively worked with QA team to resolve the issues

Environment: Informatica Power Center 8.0/8.1, Teradata, DB2, MS SQL Server, UNIX, MVS Mainframes, COBOL, JCL, TOAD, Remedy and Control-M.

Confidential, Woodland Hills, CA

Informatica Developer

Responsibilities:

• Extensively used Power-center designer to develop various parallel jobs to extract, cleanse, transform into Enterprise Data Warehouse Tables.
• Modified the existing COBOL, JCL to include new functionality as per the business rules.
• Translation of project requirements into project objectives and tasks; manages project resources and reports on project progress throughout its lifecycle.
• Experience in data Extraction, Transformation and Loading (ETL) processes. Worked extensively on data extraction, cleansing and data integration, and loading from different data sources using Power Center 7.5. (Data Designer, Workflow Manager, Monitor, and Administrator).
• Responsible for the Data Cleansing of Source using LTRIM,RTRIM along with all mathematical and logical functions of the Expression Transformation
• Extensively worked with both Connected and Un-Connected Lookups using all types of Look up Caches to improve the performance of the lookup transformations
• Replicate operational tables into staging tables, Transform and load data into enterprise data warehouse tables using Informatica from their legacy systems and load the data into targets by ETL process through scheduling the workflows.
• Involved in developing the SQLs, which are used to apply all business rules on the data before load into the target tables.
• Implemented optimization techniques for performance tuning and wrote necessary Pre & Post session shell scripts.
• Worked with reusable objects like Re-Usable Transformation and Mapplets
• Handled various loads like Daily Loads, Weekly Loads, Monthly Loads and Quarterly Loads using Incremental Loading Technique
• Worked on ERWIN Tool for data modeling.
• Worked extensively with the release team to plan and execute the releases
• Involved in production support

Environment: Informatica Power Center 8.6/7.1, UNIX, MVS Mainframes, COBOL, JCL, Oracle 10g, SQL, Shell Scripts. Erwin, Control-M.

Confidential

Intern/ Trainee/ Informatica and Mainframe Developer

Responsibilities:

• Involved in Requirements gathering, Logical design model & physical design model meetings to understand the data flow, frequency of data loads into EDW and create Mapping documents and Visio diagrams.
• Captured data from a variety of sourcesincludingDB2,VSAM files, MS SQL Server, Sybase, Oracle, and flat files and other formats
• Designed & developed numerous Jobs in all the projects which involved complex transformations, performance enhancements, validations, referential integrity, surrogate keys, SCD’s on mainframe and distributed environments.
• Involved in Database Migration/upgrade & Testing from existing legacy systems to single db.
• Written Various SQL procedures for insert, update and bulk load into EDW.
• Involved in documenting changes and potential Production Issues, Workflow Analysis and Standards.
• Prepared unit test, integration test, and performance test plan documents. Performed unit test, integration test, and performance test as per the approved test plan, and documented test results.
• Creation of Triggers, Stored Procedures, Tables, Indexes, Rules, Defaults etc.
• Analysis of Issues in Production Runs and fixes.

Environment: Power Center 8.x, DB2, Oracle 11g, MS SQL Server 2000,Windows 2000, Autosys, Control-M