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.

PROFESSIONAL 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.

STRENGTHS:

• Strong Analytic and good problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
• Experience in seeking solutions effectively and aggressively in challenging environments.
• Kept up-to-date with changes in technology through continuing education and training.
• Committed to continual performance development in the workplace and extremely dedicated, self - motivated, pro-active and willing to assume responsibility and adopt new tool and techniques.
• Motivated to develop and guide others within team environment.

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, PL/SQL, Visual Basic

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, NJ

Functional Data Integration Specialist

• 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.

Confidential

Conversion / Migration Developer

• Prepared the Data Dictionary for the ALIP (Accenture Life Confidential 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.

Confidential

Technical Designer, ETL Designer/Developer

• 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.
• Corrdinated with the BW team to test in BIT environment data passing from BW to Informatica DB2 tables.
• Created Data Compare Validation Informatica workflow process for the entire mapping created. Created Workflow process to send outbound notification and passing inbound parameters thru the sonic ESB. 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.
• Prepare Functional Design for Conversion and InfoPath Forms, Technical (Detailed) Design, Configuration, Development Lifecycle, Data Mapping Documentation, Understand the data model of Logica Database, Logica ARM Suite, CINDE (Legacy) system Database and Conversion of CINDE Inspection data into the New Database.
• Gather requirements and analyze Functional Design, coordinate with the client thru emails and conduct meeting to clarify all the insufficient information with in the FD.

Confidential, NJ

Sr. Software Analyst

• 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.

Confidential

ETL Developer, CRM PL/SQL Developer, Production Support Analyst / Integration Tester, Siebel Developer

• Created Functional, Technical, Data Mapping documents for the ETL Interface to be developed. Developed Designer Mapping, Session, Workflow for Pricing Interface in development environment. Ran the interface using Unix shell script (UC4 scheduler), tested and migrated to the Production environment.
• Involved in loading of data using SQL loader, creating PL/SQL stored procedure to load data from temp tables to stage tables. Executed the procedures and coordinated with Offshore team to load the data into Veeva (Salesforce.com). Validated the data loaded into Veeva tables.
• Worked as a CallMax application Developer in Production Support Team. Resolving day-to-day tickets rose thru Remedy and supports the CallMax application with various enhancements, Production bug-fix, reports and maintenance. Worked on resolving major logic change in PL/SQL stored procedures codes, Informatica Mappings, Unix shell scripts and Workflow to in corporate with the business needs. Migrated the State Reporting Process which was running under old server, to the new Production server.
• 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 Detail Design Documents for the EIM extract and EIM Processing for the load of data between the EIM tables and Base tables. Modified various Interfaces to in corporate the changes made on the front end (Siebel Configuration).