OBJECTIVE:

• Seeking a challenging position in ETL Development, Data Analytics, and Data Conversion / Migration where I can apply my experience and knowledge to efficiently contribute to the company’s growth.

SUMMARY

• 10+ years of extensive IT experience with Analysis, Design and Development experience in ETL tools/ processes using Informatica client and server tools like Workflow Manager, Workflow Monitor, Repository Manager, etc. Experience in creating mappings using various transformations like Expression, Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy and more, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica Power center.
• Analysis of Systems, architect the data process flow diagrams and building Functional /Technical Documents.
• Expertise’s in UNIX shell scripting and running interface on scheduling environment.
• Actively involved in Agile Methodology in recent projects.
• Experience in Source Systems Analysis and data extraction from various sources like Flat files, Oracle and MS SQL Server. Data Mapping of data between Source and Target and applying Transformation Logic.
• Experience in Oracle, SQL, PL/SQL, stored procedures, triggers, SQL * Loader. Strong experience in writing SQL Queries, PL/SQL stored procedures, functions, triggers, packages and creating tables, indexes and views.
• Experienced in creating Data Models using Erwin - ER Diagrams, Logical & Physical
• Experienced in System and Integration Testing using HP-ALM. Creating Test Plans, Test Scripts and Managing Defects.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.7.1 (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), Data Mapping, Data Profiling

Data Modeling: Physical modeling, Logical modeling, Relational modeling, Dimensional modeling(Star Schema, Snowflake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 4.1.4/3.5.2/3. x

Databases: Oracle, Sybase, SQL Server Management Studio, Teradata, Netezza, DB2, Access, Logica Database, Veeva

Job Scheduling & Other tools: Unicenter, Remedy, Serena Change Man, Clear Quest, TOAD, HP Quality Center, Caliber RM, UC4 Autosys, CONTROL-M

Utilities: TOAD, SQL Loader, SQL Navigator, SQUIRREL, Rapid SQL, SQL Developer, MS SQL Server, Sybase Central, Razor SQL, TortoiseGIT, JIRA, Confluence, Jenkins, AIM Deployment, BitBucket

Languages: UNIX Shell Script, SQL, CQL, PL/SQL, Visual Basic, Python

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows 2013/2000/XP, Siebel Tools, Enterprise Integration Manager (EIM) Process, Salesforce.com, Eclipse, Sonic ESB 8.5.1

Mainframe: MVS, COBOL, CICS, JCL, and IMS DB2

Others: Enterprise Architect, Visio, InfoPath Forms, DOORS

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Developer

Responsibilities:

• Provide Application support fixes to Alerts generating Procedure codes and deploy them to UAT & PROD. Test in Dev and UAT with data validations.
• Conduct UAT Regression testing once UI code is deployed to UAT for Reliance Application.
• Make new or modify changes to Contol-M and deploy the changes to Dev and UAT based on business requirements and requests.
• Conduct Analysis on current procedure code before enhancing them based on business needs.
• Create JIRA based on the code changes and update them as the sprint comes to an end.
• Watch live Production Jobs that run on Control-M for US region and update the team based on the progress or completion.
• Interact with the client team in India and Scotland on a daily bases and give status on progress daily. Discuss and Analyze code details and review code changes with them.
• Modify Informatica Mappings and workflows, Source/Targets based on Business requirements and deploy to UAT and PROD.
• Interact with the users and their request queries on a daily basis.
• Analyzed current state Reporting Database(Access Based) and identifying the front end user screen functionality, providing solution and detail summary of their existing database functionality to the Business teams. Provided detail data workflow diagrams for existing reporting database.

ETL Informatica Developer

Confidential

Responsibilities:

• Resolve High & Critical defect fixes in the development of ETL processes generated by System Test & business rules change.
• Validate ECF XML generated Files through ETL Processes.
• Created new Mappings and modified existing Mapping and Developed new Informatica mapping (Target - XML and DB), workflows, updated existing Informatica mapping, Workflows, processed defect fixes, tested, validated data. Documented and implement all the objects being used in ETL development into upper environments.
• Created Test Documents for all the changes and uploaded to the sharepoint.
• Created new Autosys job scheduling entry to run the interface. Jilled them and implemented logic for Dependency scheduling jobs. Ran autosys jobs to verify migration moved correctly
• Migrated data from one environment to another. Created data validation sheets for unit test for each Releases.
• Generated Mock data, Test scripts for various data scenarios and tested all the Test Script using backend.
• Migrating the Development work into UAT, BOT environment and Production.

Conversion / Migration Designer

Confidential

Responsibilities:

• Prepared the Data Dictionary for the Confidential ( Confidential Life Insurance Platform) database for the Target System.
• Created Client based Target Data Dictionary with field definitions and Valid Values documents for data reference fields.
• Worked in Data warehouse environment and responsible to enhancing and fixing bugs to the existing systems. Worked on Development, Documentation, Unit Test Scripts, System Test Scripts, Unix Script Runs, Bug Fixes.
• Assessed & Analyzed Web Method codes from existing system and generate Analysis and Design documents for ETL Data Stage.
• Arranged Meeting with Web Method support teams to understand the current state design.
• Generated Design documents and Data Mapping documents to represent the future state into ETL Data Stage.
• Generated current state and future state Visio Diagrams for all the 96 Interfaces that would be migrating to new environment as part of Design Documentations.
• Arranged Meeting with Application Teams and review the current State designs and Future State Designs and get feedback on any enhancement the teams may want to implement in Future design.

ETL Designer/Developer

Confidential

Responsibilities:

• Involved in a Merger project to split single server into 3 different servers, including Informatica Mappings, Workflows, New Databases and Unix Shell scripts. Implemented the new code and migrated the same into BIT environment.
• Analyzed the existing environment list of workflows for the new Matco environment for various projects.
• Designed and Developed the code in informatica for Matco, FMC environment. Unit test the same for various projects under Matco, FMC.
• Analyzed the unix shell script which executed the workflow and modified based on the database changes, environment changes.
• Corrdinated with the BW team to test in BIT environment data passing from BW to Informatica DB2/Oracle tables.
• Coordinated with Off shore team during Analysis, Development and Testing phase. Gave guidance to other junior team members during Development and Testing phase.
• Coordinated with Test lead to implement the BIT test scripts for ETL. Executed HPQC BIT test scripts during Testing phase.

ETL Developer

Confidential

Responsibilities:

• Gathered Requirements to understand the data flow and analyze Functional Design, coordinate with the client thru emails and conduct meeting to clarify all the insufficient information with in the FD.
• Created Technical Design based on all the information provided in the Functional Design to transform data from one Interface to another to create a Integrated Marketplace.
• Conducted Joint review with the clients to go thru the design and code for the Technical Design, Mapping and Workflow build for the interface stakeholders.
• Working on multiple technical designs at the same time to meet the deadlines.
• Learned Enterprise Architecture to demonstrate the visual Data Architecture, Data Flow Diagrams.
• Created about 40 sessions, mapping and 10-15 workflows for all the Technical Design created.
• Build and Configured each and every workflow to generate error messages on failures and success run and return session status to another common mapping session.
• Imported data from Netezza to Oracle, Flat file to Oracle transformed and loading into various Interface Targets using Informatica.
• Created Data Compare Validation informatica workflow process for the entire Target created.
• Created Workflow process to send outbound notification and passing inbound parameters thru the sonic ESB.
• Migrated the development work into ITE, Test Environment and Production.

Confidential

Data Analyst and ETL developer

Responsibilities:

• Gather, analyze and model client data on customers, financials, operations and access channels or market data on competitors, products and suppliers to help improve insight and decision making.
• Reviewing of Functional Requirements to understand the data flow from one application to another. Reviewed the product requirement and requirement traceability matrix document.
• Interacted with BI and functional team to gather information regarding the source and target mappings.
• Studied the dimensional data model to understand the structure of the data and data types. Mapping the data types between the source and target tables. Reached out to the Data Architecture team for any difference or issues.
• Created design documents for the development team to transform data from the Verizon data warehouse into VIS dimensional data mart. Load of all the dimensional and fact aggregated tables.
• Coordinate with the Client development team responsible to build the VIS platform, which includes integration with the existing Verizon Wireless Data Warehouse and business operations and support systems, the data staging, data stores, and ETL data processes to move data from warehouse to data marts, an analytics and consumption layer based on the data marts and the portal to display to external, subscription based customers the VIS products, i.e. reports and dashboards of the aggregated, calculated Verizon Wireless Customer data.
• Created Source to Target mapping document to understand the mapping scenario between the two applications.
• Created test data for the target database, which was created in the VIS datamart.

CRM PL/SQL Developer, Production Support Analyst

Responsibilities:

• Resolved the day-to-day tickets, which could be client inquiry, data request or any form of customer service, change request or enhancement.
• Resolved Production failure process that runs on a daily basis, which was a high priority job. Executed UNIX shell scripts on Production or requested the scheduling team to restart the process upon any failure.
• Involved in enhancement of the UNIX shell script to be more efficient for various processes. Involvement of FTP files in these processes.
• Investigate the Informatica pipeline to resolve the business side issues which do not show up in Callmax Application. Modified System Design Documents to update the changes that involved business logic change.
• Create Reports for the business client providing data for them to evaluate.
• Worked on major enhancement on process, PL/SQL codes and Informatica Mapping that would enable the business client to receive their reports more efficiently. Automation of many manual processes was implemented in Production as per business requirements.
• Migration of the State Reporting Process which was running under old server, to the new Production server.
• Involved in email correspondence daily with the business clients regarding the business rules or other issues that business faces on the front end. Correspondence with the UNICENTER Scheduling team, PTP team, Support group such as DBA, UNIX and Informatica administrator on a daily basis.
• Major resolutions of High Priority tickets involved related to State License being invalid, prescriber showing as DO NOT SAMPLE and Prescriber not being added to the customer pool, henceforth not visible in Callmax Application.
• Involvement of adding and deleting the customers from the customer pool, based on business requirements and approvals.
• Worked as an Integration Tester for the Customer Master Hub application integrating with other applications. Prepared Test Script, Test Mock Data, executed Test Script and validated the data scenario using HPQC.
• Created Defects and Resolved various Defects assigned to me, relating to any data load or database issue.
• Role: ETL Developer for Pfizer
• Created Functional, Technical, Data Mapping documents for the ETL Interface to be developed.
• Developed Designer Mapping, Session, Workflow for Pricing Interface in development environment.
• Coordinate with the client thru emails and conduct meeting to clarify all the insufficient information with in the FD.
• Created Unix shell script to execute the batch job and reconcile the pricing matrix data.
• Ran the interface using Unix shell script (UC4 scheduler), tested and migrated to the Production environment.

Interface Lead

Confidential

Responsibilities:

• Created Detail Design Documents for the required changes on the Interface, that were related to the Application changes.
• Created Mapping documents for the extract files for each SQL view interfacing between the Seibel tables and the extract files, which are executed on a daily, monthly and weekly basis.
• Created Detail Design Documents for the EIM extract and EIM Processing for the load of data between the EIM tables and Base tables.
• Ran the EIM Process to load data from the EIM Tables to the Base Tables.
• Created Procedure that would update the Year in the Birth Date Column and insert data into the EIM Tables.
• Created Test Scripts for the functionality of the Application and the backend interface.
• Modified various Interfaces to incorporate the changes made on the front end (Siebel Configuration).
• Executed various Procedures to create Extract Files and was responsible for testing and validating data.