PROFESSIONAL HISTORY:

Confidential, Chicago, IL

Sr. Associate Insurance Management

Responsibilities:

• The role was for Production support L2 (Route cause analysis) and L3 (hot fixes and patches).
• Attended the HCSC AMS Knowledge Acquisition Sessions;
• During Shadow Support Resolved high priority incidents along with incumbent teams;
• During Reverse Shadow provided the support independently by closing the open tickets;
• Cooperate with Source System Teams, SMEs and Requester to finalize and close membership tickets.
• Navigate Operating Systems (BlueStar, MF ODS, Member inquiry profile) and provide assistance to customers.
• Involved in Continuous Service Improvements.
• Check the escalated issues first (usually process the requests based on the SLA.)
• Know the flow of the application (Zena, Data Stage) and do deep dive into the issue and fix it. Work on defects and enhancements.
• SQL used to analyze, test, re - trigger (missing data) and soft delete (duplicate rows) data with Nested SQL

SKILLS:

ETL Tools: Informatica Power Center 9.5, IBM InfoSphere DataStage and QualityStage v.8.5

Databases: Oracle 9i/10g, SQL Server, Teradata SQL Assistant v. 14.10.0.01 , DB2 Squirrel SQL Client 3.3.0

Operating Systems/ Nettwork: Windows XP, Unix, IBM Personal Communications Workstation v.6.0

Schedule Tools: CA Workload Control Center r11.3 (Autosys), ASG-Zena Workstation v.3.1.1.210

Confidential

Purchase, NY

Informatica Sr. Associate

Responsibilities:

• The role was to Support Teradata code that should match DB2 using Informatica and Autosys.
• Have interacted with SME (for business rules clarification), DBA (for Process Improvements, confirm the server/database is up and running fine, Stats Update), Unix admin and Offshore Team.
• With Informatica PowerCenter have done Changed Management process to Migrate project components between environments (UAT and PROD). I have done Performance Tuning on mapping and session level. Modified and performed existing code in mappings and workflows based on business requirements or decisions. Prepared reports to be presented to the Business Analyst. Have done the Unit Testing to validate Source/Target, to analyze rejected rows and calculate the load time jobs by checking on session running files: workflow logs, bad/rejected files, error and session logs.
• UNIX shell scripting was used for file manipulations (sed; awk.. ), functions, expressions, variables, conditional statements, decisions in order to compare data files between SRC/TGT for example on unique ID and see where is a miss match value. Checking the UNIX script file for correct configurations (DBConnections, SQL files, parameters.. )
• SQL was used for Built in Functions (Numeric, Character, Aggregate (group by, having), Conversion (NVL, CASE) and Date Function) and Sub-queries on issues for timing, sum and matching data.

Confidential

New Jersey, Bridgewater

Informatica Sr. Associate

Responsibilities:

• My responsibility was to perform the existing Informatica code in • more optimal one.
• Modified and performed existing code based on business requirements/decision.
• Prepared test result to be approved by manager and save on share path.
• Done Changed Management process - Migrated components (Deployment groups) between environments (DEV, UAT, PROD).
• In Informatica PowerCenter During development for new mapping I did Import- Export Objects; set up Mapping/Seesion/Workflow Variables and Parameters; run Concurrent and Sequential Workflow; configure Session, Task and Workflow Properties, Link conditions Between Session.
• I have done the Performance Tuning at Mapping and Session level (To reduce runtime and avoid rework); Partitioning has been used to improve performance (round robin, key range); used Push down Optimization (Source/Target/Full); checked on Error Logging/Handling on Data Errors.
• Based on existing template created UNIX sh script that will run Informatica Workflow with correct Workflow details (Test DBConnections, session name, parameter, badfile name, log file, name Input/Output file or relational table). Transferred files (scp, sftp) between remote host for data load and test data.
• Operators in SQL (Union, Intersect, Minus, Except) used to compare data between Source and Target tables. Used Hints for testing the performance of a specific access path.

Confidential

Informatica Sr. Associate

Responsibilities:

• On daily meetings I worked closely to business analysts to analyze requirements and be able to translate these requirements into code for developing.
• Manage offshore resources and ensure quality code is correct.
• In Informatica PowerCenter worked with Integrity Constraint Load Ordering, Target Load Order Plan, Debugger, XML Source, Target and Transformation.
• For new requirements created mappings end to end and prepared test logs result to be presented to Business Analyst.
• Responsible for all Informatica code to be parameterized ($DBConnection, $InputFiles etc.)
• In Repository Manager have done Changed Management Process, Migrated Deployment groups between environments Dev and QA.
• UNIX used in Pre-Post session commands to rename, move/backup files.
• Done changes on existing PLSQL (Functions, Stored Procedures, Triggers, Exceptions, Packages) using Microsoft SQL Server Tool.

Confidential, California, LA

ETL Informatica Team Lead Associate

Responsibilities:

• Project was to load data from multiple environments (ODS, KT) into HN DWH ( Confidential data warehouse).
• Co-ordinate with Offshore Team for all ETL deliverable and ensure quality code is delivered to client on time.
• Responsible to design, build, deploy and support end to end ETL processes; to review of all offshore
• In Informatica PowerCenter modified existing code on mappings and workflows based on business requirements/decision. Done trouble shooting (error messages, mapping and workflow errors)
• Prepared Solution document for existing requirements to be presented for Business Analyst.
• UNIX used to find, rename, archive/move files to different directories. Analyze data files (grep, wc, cut, sort..) to compare between Source and Target.
• Running SQL queries to analyze the data issue (worked with Indexes, Views, Synonyms, Set operation Union, Intersect)

Confidential, New York, NYC

ETL Informatica Developer

Responsibilities:

• My work was related to data integration from two merged entities
• Responsible for understanding the BRDs (Business Requirement Documentations) and translating the business requirements into TRDs (Technical Requirement Documentations).
• Used Informatica Client tools for ETL Development (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Repository Manager,Workflow Manager and Monitor)
• Experience in Implementing Slowly Changing Dimensions SCD Type1, Type2. Used Active and Pasive Transformations to implement complex mapping logic.
• Responsible for error handling using Informatica Session Logs, Workflow Logs, and Informatica Errors Tables used by Row Error Logging; debugger and also capture errors using expression transformation Error functions.
• • Used SQL for DML, DQL. For reports worked with Joining tables (Inner, Outer, Full).