Data Integration Cloud Services
Resume:
HONEY MARY TOM
**** * **** **. ***** OK *****
Mobile: 918-***-**** / Email: ************@*****.*** CAREER SUMMARY
• Over twelve (12+) of experience in IT industry, related to various aspects involving Data integration and Data warehousing techniques, using ETL tools like Informatica Power Center, Informatica Intelligent Cloud Services (IICS).
• Strong experience in Data Warehousing and Data Integration Solutions using Informatica PowerCenter (Mapping Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Expertise in Data Warehouse/Data mart, ODS implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experienced in developing conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
• Experience in Dimensional Modeling using Star and Snow Flake Schema.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle, SQL Server, DB2, Sybase, Teradata, and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Worked extensively with slowly changing dimensions.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Experience in delivery of multiple SLA driven production support engagements.
• Extensive experience in automation of the ETL processes using UNIX shell scripting and scheduling tools like Autosys, Control-M and UC4.
• Experience in incident and change management using ServiceNow ticketing system
• Experience in providing L2 and L3 support of ETL processes
• Experience working in agile methodology
• Experience integrating data to/from On - premise database and cloud-based database solutions using Informatica intelligent cloud services IICS
• Experience in data masking of sensitive elements using Information Lifecycle Management (ILM)
• Knowledge in cloud-based database solutions including Azure Data Factory, Data Bricks, Data Lake, Azure Synapse and Snowflake.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines. HONEY MARY TOM
8509 E 98th St. Tulsa OK 74133
Mobile: 918-***-**** / Email: ************@*****.*** TECHNICAL SKILLS
• Informatica Power Center
• Informatica intelligent cloud services (IICS)
• Azure Data Factory
• Azure Data Bricks
• Azure Data Lake
• Azure Synapse
• Snowflake
• Oracle
• SQL Server
• Teradata
• Sybase
• Windows
• UNIX
• Shell scripting
• PUTTY
• Agile methodology
EDUCATIONAL QUALIFICATION
• Masters in Information Technology and Management (2000 – 2002) Periyar University, India
• Bachelors in Computer Application (1997 – 2000)
Mahatma Gandhi University, India
TRAININGS & CERTIFICATIONS
• Azure Data Factory Training for DP-203 Certification (Undergoing) Intellipat.com
• Cloud Data Integration for PowerCenter Developers (2023) Foundation Level Certification, Informatica.com
EMPLOYMENT HISTORY
Cognizant Technology Solutions Ltd, India
Senior Associate
Dec 2012 – Apr 2018
UST Global, India
System Analyst
Aug 2010 – Nov 2012
Affiliated Computer Services (ACS) Inc. (A Xerox
Company), India
Senior Software Engineer
Dec 2005 – Aug 2010
HONEY MARY TOM
8509 E 98th St. Tulsa OK 74133
Mobile: 918-***-**** / Email: ************@*****.*** SUMMARY OF RELEVANT PROJECTS
Unclaimed Property Initiative
(Lincoln Financial Group, USA)
Role: Team Lead
Tools & Technologies: Informatica Power Center 9.6, IICS, SQL Server 2008, UNIX, Jira, Control-M
Project Description
Unclaimed Property Initiative Project is a Data Integration Project for UPI Compliance. UPI identifies the policies that have unclaimed funds and ensures these funds are paid to the beneficiaries or escheated to states. Informatica 9.0.1/SSIS are the ETL tools used for extracting and loading data for Resolution and Pre-resolution process of the project and SQL Server Reporting is used for creating reports.
Responsibilities & Contributions
• Lead the offshore team with tracking the task assigned to all team members, providing technical guidance and support for resolving complex issues.
• Participated in planning and execution of implementation and migration to IICS.
• Created proper technical documentation outlining the entire process.
• Worked on effort estimation, coordination with various teams and tracking work progress
• Used Jira as Project tracking tool to assign tasks to team members and track the status
• Created and maintained all relevant production support documentation including change management process, job run book, data backup and retention policy and applicable access controls documentation
• Performed L2 and L3production support activities which involve issue analysis and resolution within the specified SLAs
• Monitored production job run times to documented SLA and troubleshoot and resolve production job failures and issues
• Provided on-call technical support assistance for Informatica jobs as part of an on-call rotation
• Participated in production deployment of the developed change request code
• Coordinated with QA team to monitor the defects logged against the deliverables and ensure it is analyzed and closed on time.
• Extensively worked with Scheduling tools like Control M
• Attending quality audits
• Driving calls with Informatica admins and Database admins to optimize the ETL architecture.
• Provided daily and weekly status updates to onsite and client leadership team. HONEY MARY TOM
8509 E 98th St. Tulsa OK 74133
Mobile: 918-***-**** / Email: ************@*****.*** MRM Integration
(AAA, USA)
Role: Team Lead
Tools & Technologies: Informatica Power Center 9.6, Oracle 11g, UNIX Project Description
The MRM Integration project aims at preparation of marketing data for Marketing staging area- SPINE which in turn would feed data to PEGA.PEGA is a Marketing Relationship Management (MRM) product - for Campaigning and Selling of products across Marketing, Sales and Service business areas. The model is built around the customer information tied to existing products, Membership, Quotes and Claims information to provide a single product-level snapshot of the customer. This enables the marketing team to have a 360- degree view of the customer in terms of products.
Responsibilities & Contributions
• Lead ETL team, participated in the entire project life cycle from requirement specification to implementation, ensuring the solution fits its intended purpose from functional, technical and quality perspective
• Worked with Project manager on project management activities such as project planning, risk identification and tracking, resource planning, effort estimation and provide project timeline based on requirements.
• Interact with business users to get business requirements and analyze source system data
• Worked with various teams like business analysts, architects, all infrastructure teams to design and setup new systems, DBA, QA
• Developed ETL specification based on business requirements
• Established best practices and standard for ETL process
• Created source to target mapping documents
• Worked with team members to ensure informatica mappings, sessions and workflows are created as per technical design specifications.
• Used Informatica reusability at various levels of development
• Tuned informatica code in mapping level and session level.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
• Creation and review of unit test case documents
• Used UC4 jobs to automate ETL jobs
• Assisted in migrating jobs across development, QA, UAT, Production environments
• Assisted in migrating all UNIX shell scripts, parameter files and ENV files through SVN version to various environments
• Effectively worked in Informatica version-based environment and used deployment groups to migrate ETL Workflows, sessions and mappings.
• Provided pre and post production assistance
• Prepared the support document and transition the project to the support team
• Review of deliverables and ensuring quality
• Provide status updates to onshore\Client through status calls, WSRs and status emails HONEY MARY TOM
8509 E 98th St. Tulsa OK 74133
Mobile: 918-***-**** / Email: ************@*****.*** SSB Encounter
(Wellpoint, USA)
Role: Offshore Track Lead
Tools & Technologies: Informatica Power Center 9.1, Unix, Teradata 13.10 Project Description
SSB or State Sponsored Business is one of the divisions of WellPoint which gets the Claim reimbursement from the State. Encounter is normally a monthly process through which finalized claims data are extracted from the claims processing system and submitted to the State for processing. The project involves pulling the claim data from the institutional and professional claim header and detail tables in WCF (WellPoint Common Format) format and then convert to HIPAA 837 format or proprietary layout before submitting to state, submit to state, receive 997 acknowledgements and updates the database. Multiple validations and reports are also being generated during the process. Responsibilities & Contributions
• Analyze the requirements of the business team and designing mappings, workflows, UNIX scripts to produce required outputs.
• Interaction with onsite team regarding different design strategies to simplify the process.
• Change existing code as per the client requirement and also enhancing the process.
• Quick and accurate replies on researches on production Issues
• Performance tuning has been done to increase through put for both mapping and session level by increasing target-based commit interval
• Provide technical guidance and support to the team members for resolving complex issues.
• Review of deliverables and ensuring quality
PSG CLAIMS AUDIT
(Wellpoint, USA)
Role: Offshore Track Lead
Tools & Technologies: Informatica Power Center 8.6, Unix, Teradata. Project Description
The migration of Pharmacy business from legacy NextRx applications to ESI application was the key focus area for Pharmacy Solutions Group (PSG) in 2010. PSG assists, co-ordinates, and supports the transparent migration of the WellPoint members to ESI. Post 2010, one of the major activities for the PSG is to ensure the migrated members Claims at ESI are adjudicated exactly the same way as they would be at WellPoint. The current option of validating the Claims through Compass would not be feasible for performing audits in a large scale. So a new design was proposed that would create a platform for PSG to perform the validation in a large scale and identify the benefit set-up issues at ESI. The scope of the project is to design an automated process that validates the migrated member’s claim at ESI against the Benefit set-up at WellPoint HONEY MARY TOM
8509 E 98th St. Tulsa OK 74133
Mobile: 918-***-**** / Email: ************@*****.*** Responsibilities & Contributions
• Design, development and testing of ETL mappings, sessions, workflows and UNIX scripts as per the business requirement.
• Involved in business requirement analysis and prepared functional requirement document
• Involved in ETL technical design discussions and prepared ETL high level technical design document
• Prepared low level design document for each of the target table
• Created source to target mapping documents
• Worked on developing Informatica mappings, sessions and workflows as per design specifications.
• Involved in Unit Testing and resolution of various bottlenecks came across
• Provide all kind of support in migration activities
• Provide technical guidance and support to the team members for resolving complex issues.
• Provide regular updates to management on project, defect status and progress ESI MEDD AUDIT
(Wellpoint, USA)
Role: Offshore Track Lead
Tools & Technologies: Informatica Power Center 8.6, Unix, Oracle. Project Description
The scope of project is to load Claims Extract from WLP NextRx system (ProPBM) to ESI Systems. The Claims extract process contains all historical paid and reversal claim records for the date of service time period of 01/01/2008 through 12/31/2010. Rejected claims were not being pulled in the extract. Separate files were generated for each ESI DIV. Extracted Claims files were FTP’ed to ESI via the GA bridge server. The claims migration process has the following processes.
Process to extract all historical paid and reversal claims from the claims history files with date of service from 1/1/2008 through 12/31/2010.
Process to separate the reformatted file based on ESI DIV code. The final files are generated based on ESI DIV code/month.
Process to reformat the extracted claim details into ESI requested layout (Claims layout) with header, detail and trailer.
Process to FTP the final Claims file.
Responsibilities & Contributions
• Involved in requirement gathering, analysis, design and development
• Involved in preparing technical design document, unit testing and system testing documents
• Designed Informatica mappings and workflows for populating tables for one time load and incremental loads
• Developed informatica SCD Type-1, Type-2 mappings
• Configured the sessions using Workflow manager to have multiple partitions on source data to improve performance
• Wrote UNIX scripts for archiving and Email notifications HONEY MARY TOM
8509 E 98th St. Tulsa OK 74133
Mobile: 918-***-**** / Email: ************@*****.***
• Provide technical guidance and support to the team members for resolving complex issues
• Support during QA/UAT/PROD deployments and bug fixes
• Create QA testing scripts and test case document
• Support UAT testing and defect fixes
• Provide all types of production support
Health &Welfare Others
(Morgan Stanley, GlaxoSmithKline, Northwestern Memorial Hospital, CISCO, Tenneco) Role: ETL Developer
Tools & Technologies: Informatica Power Center 8.6, Unix, Oracle. Project Description
This project was developed for multiple clients listed above and the scope of this project is to develop interfaces for COBRA, PAYROLL and FSA.
The COBRA interface will provide a list, eligible for COBRA benefits. The eligibility data will be provided to ADP and Ceridian on a weekly basis depending on their integration definition. Payroll Interface calculates the amount that has to be deducted from the employee’s pay check for the health benefits that he has opted for, and submitted to employer’s payroll system. The payroll file contains deduction record and earning record and sent to the employer based on the pay frequency of the employee. Deduction record gives the amount that the employee has to pay the employer on a regular basis for electing the benefit. Earnings record gives the amount that the employer will be paying the employee on a regular basis for the employee opting out of the plan.
FSA interface will provide information about indicative data, Health care Election Amount, Dependent care Election Amount, Termination dates for health care or dependent care plans. Type 20 record corresponds to health care election while type 21 corresponds to dependent care.
Responsibilities & Contributions
• Collect business requirements from the business analysts and converted the business logic into functional specifications
• Created technical requirements and detail level documents.
• Involved in entire of SDLC process that includes implementation, testing, deployment and maintenance.
• Extensively worked on developing Informatica mappings, mapplets, sessions, workflows and worklet for loading data to target.
• Developed mapplets and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Used Informatica debugger, session logs to resolve problems in a timely manner HONEY MARY TOM
8509 E 98th St. Tulsa OK 74133
Mobile: 918-***-**** / Email: ************@*****.***
• Worked on performance tuning Informatica mappings to identify and remove processing bottlenecks.
• Used Informatica file watch events for the external mainframe files
• Coordinate and develop all documentation related to ETL design and development
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections
• Created UNIX shell scripts to create parameter files from parameter templates
• Used Autosys to schedule the jobs by creating JIL scripts
• Prepared unit test documents and executing unit testing queries
• Support the UAT and fixing the issues raised in QA
• Assisted in migrating jobs across development,QA, UAT,Production environments
• Assisted in migrating all UNIX shell scripts, parameter files and ENV files through SVN version to various environments
• Used deployment groups to migrate ETL Worklows, sessions and mappings.
• Provide post production support for the project
• Effectively worked on Onsite and Offshore work model
• Participated in daily status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
Contact this candidate