Project Data
Resume:
Bharath Rayam
Informatica Lead
: *******.****@*****.***
PROFESSIONAL SUMMARY:
10+ years of Professional IT experience spanning from Consulting, Architecture, Solution Design and Implementations of projects and product developments in Enterprise Information Management and Analytics.
Designed and delivered large scale Data warehousing Programs and E2E Data Integration Solutions for Major Clients Across Domains as Project Lead.
Expertise in providing ETL Solutions for business data warehouse.
Extensive hands-on experience in Informatica Intelligent Cloud Services (IICS) & Informatica PowerCenter and multiple databases (Oracle 12g, SQL Server 2014, Sybase, Teradata, SAS 9.3, DB2) and Unix Shell Scripting.
Project reviewer for Major Healthcare Client to review SDLC Cycle, Coding practices, Process Compliance, Document standards etc and Received high CDI for the same.
Hands-On experience on Analysing SAS ETL, Implementation of Data integration in Informatica using XML, Webservices, SAP ABAP, SAP IDoc.
Worked on Dimensional Data modelling in Star and Snowflake schemas and Slowly Changing Dimensions.
Developed Informatica Development Standards, Best practices, Solution Accelerators and Re-usable components for design and delivery assurance.
Pro-Active to Production Issues, punctuality in Meeting deadlines and always follow First Time Right (FTR) and On Time Delivery (OTD) approach.
Team facilitator with good communication and interpersonal skills. Ability to deal with people diplomatically and a team facilitator.
Very good in building strong relationships between teams within IT Solutions and between IT Solutions and related business teams and maintains professional relationships with peers in other corporations and outside organizations.
Has strong communication and influence skills when interacting with all levels of the organization starting with senior leadership on down to the team members.
Data warehousing with exceptional background in designing, developing, analysis, implementation and post implementation support of Data warehouse applications.
Sound analytical and problem-solving skills with a good exposure to the key facets of leading teams to meet set objectives and ability to adapt and learn new technologies.
EDUCATION:
Bachelor of Engineering in Electronics and Communication Engineering, Anna University, Chennai, India 2008.
CERTIFICATIONS/ACHIEVEMENTS
Six Sigma Green Belt certification for improvement on automatic release creation for development which leads to reduced time and effort and cost saving of $1250 annually.
TECHNICAL SKILLS
Methodologies : Agile, Waterfall.
Database : Teradata, Oracle, Sybase, SQL server, DB2
ETL Tools : Informatica Power Center 8.x,9.x,10.x, Informatica Intelligent Cloud Services (IICS)
Operating System : Windows, UNIX, Linux
Scripts : PL/SQL, Unix shell scripting, XML
Defect Tracking tools: HP Quality Center, Microsoft TFS
Design : Microsoft Visio.
Business Domain : Financial, Healthcare, Hospitality, Banking.
PROJECT RESPONSIBILITIES
Act as overall technical authority for the project.
Design, creation and management of Informatica Mappings with Unix & SQL.
Work with business owners in understanding the business requirements.
Analyze and solve business problems at their root, stepping back to understand the broader context.
Functional testing of the developed objects.
Performance tuning of Informatica Mappings & SQL.
Analyze and solve business problems at their root, stepping back to understand the broader context.
Leading and developing a team of DWBI Engineer.
Leading DW/BI team engagements.
Establishing ETL Governance standards and best practices.
Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses.
Good exposure in projects with the Onsite - Offshore model.
Created the Process Flow Documentation for the Informatica process.
Focuses on results and success, conveying a sense of urgency and driving issues to closure.
Optimizes use of available resources.
ORGANIZATIONAL RESPONSIBILITIES
Contribute to the development of the Enterprise Integration Management (EIM) competency.
Provided Informatica Training sessions to ETL trainees.
Provided Knowledge transfer to internal team members specific to my subject area.
Creation of Process Documents with quality standards.
PROJECT EXPERINCE
Bloomin Brands- Application Integration, Tampa, FL Mar 2018 - Till Date
Title: Informatica Lead/ Developer
Domain: Hospitality
DESCRIPTION:
BBI has different Applications streams under Financial, Corporate, Front of House, back Of house and Customer Personalization where they engaged Virtusa to provide the integration solution for the applications falling under those streams using Informatica Cloud and PowerCenter 10.x. Also, integration support was provided to existing Production Applications too.
Roles & Responsibilities:
Work with business analyst or functional analyst in understanding the business requirements.
Based on Business requirement, Understand the technical requirements and define mapping documents and business rules.
Design and creation of Informatica Mappings or Mapping task (IICS), SQL Server tables, UNIX shell scripts.
Performance tuning of Informatica workflows or Task flows.
Establishing ETL and Database Governance standards and best practices.
Analyze the existing Informatica Workflows or Task flows or PL/SQL for Impact Analysis before updating the same based on new requirement.
Analyzed Complex ETL and PL/SQL Jobs to solve different business problems with Effective and Efficient solution.
Follow the Client Process of Check-in the code to VSTS using GIT process, Updating the status of the work in VSTS using Kanban Board, Code Review Process with Enterprise Architecture Team, Creating Change request using Service Now for QA and PRD Deployments.
Focuses on First Time Right (FTR) and On Time Delivery (OTD) Approach all times which earned Customer Appreciation many times.
Healthfirst- HEDIS Mede Analytics Integration, NYC, NY Aug 2017 – Mar 2018
Title: Informatica Lead/Developer
Domain: Healthcare
DESCRIPTION:
Healthfirst has procured Mede Analytics HEDIS rate engine, the claim analysis tool and Virtusa tasked to provide the integration solution between Healthfirst and Mede Analytics. The data for Mede Analytics need to be sourced from various source systems, which need to be consolidated and supplied to Mede Analytics system.
Roles & Responsibilities:
Work with business analyst and technical lead in understanding the business and technical requirements.
Analyze SAS ETL programs and defined mapping documents and business rules.
Design and creation of Informatica Mappings, SQL Server tables and views.
Develop reusable & concurrent executable workflows SAS data extraction.
Performance tuning of Informatica Mappings or workflows.
Establishing ETL Governance standards and best practices.
Focuses on results and success, conveying a sense of urgency and driving issues to closure.
Postproduction support for loading history data.
Implemented this project in Agile Methodology by providing value add to the business users.
M&T Bank- EPIC TDP, Baltimore, MD Jun 2016 – Jul 2017
Title: Module Lead/Developer
DESCRIPTION:
This project is related to migration of data from Datamart Analytix system to the Teradata Environment using ETL. This data contains sensitive information which is very important for business to use it for Analytics purpose and is available to users through views based on authorization levels. The technical challenge was to improve the performance constraints for some of the jobs using Multi Load and partition concepts. Also handle the history load of 5 years of weekly and monthly data into the tables.
Roles & Responsibilities:
Work with business analyst and technical lead in understanding the business and technical requirements.
Design and creation of Informatica Mappings, Unix scripts Teradata tables and views.
Unit testing of the developed objects.
Performance tuning of Informatica Mappings or workflows.
Establishing ETL Governance standards and best practices.
Focuses on results and success, conveying a sense of urgency and driving issues to closure.
Postproduction support for loading history data.
Implemented this project in Agile Methodology by providing value add to the business users.
MVP Healthcare, Chennai, India Oct 2015 – May 2016
Title: Project Lead/Reviewer
Projects:
a)Medicaid OMIG Provider report
b)MVP User Request
Domain: Healthcare
DESCRIPTION:
a)Medicaid OMIG Provider report: This project is related to generation of Quarterly report which identifies the value of claims, payments, referrals orders and prescriptions made for members of the Medicaid Managed care (MMC) plan using MVP In -house data and data from vendors.
b)MVP User Request: The Objective of this project team is to work on the multiple change requests raised by different stakeholders on different functional and technical aspects of DWBI projects. It involves all modules of MVP Healthcare system for solution implementation.
Roles & Responsibilities:
Work with business solution analyst in understanding the business requirements.
Review the business & technical requirements and ensure that all functional and non-functional requirements are captured without any miss.
Review the impact analysis and raise queries in terms of covering business impact.
Review the design solution and provide any suggestions and feedbacks on the solution.
Review the test cases and provide feedback on missing scenarios.
Review the coding standards for both Informatica mapping and SQL scripts.
Ensure that the team members and Leads follow both Virtusa and client related process and guide them if required to ensure non-compliance.
Review all the client related documents to ensure quality of deliverables.
Review the design of the jobs scheduled in scheduler and also review the documentation for the same
Acts as Lead at times to guide team members in terms of technical challenge.
Owning end to end responsibility and accountability of each change request in terms of no requirements miss, noncompliance of process and quality of deliverable etc.
Combine patience, determination, and persistence to troubleshoot performance issues.
MVP Healthcare, Chennai, India Sep 2014 – Sep 2015
Title: Project Lead
Projects:
a)CVS Accumulator
b)IBM Cast light
c)Electronic EOB/ADL
d)Care plus
e)Vital Decisions
Domain: Healthcare
DESCRIPTION:
a)CVS Accumulator: This project is related to exchange of accumulator information to facilitate claims adjudication processes for Inbound and Outbound Extract
b)IBM Castlight: The objective of this project is to automate the creation and transmission of IBM Member data (eligibility, medical, accumulator, provider directory) feed to Castlight.
c)Electronic EOB/ADL: This project is related to building a process for MVP members to view and print individual EOB’s from the member portal based on LOB.
d)VitalDecisions: The objective of this project is to automate the creation and transmission of Medicare member’s data (Member Enrollment/Eligibility, Member Claims, Pharmacy Claims, Providers and Lab) feed to Vital Decisions.
e)CarePlus: The objective of this project is to automate the creation and transmission of Medicare member’s data (Membership and Demographics data, Medical/Pharmacy Claims data and Providers) feed to Optum.
Roles & Responsibilities:
Design, creation and management of Informatica Mappings & Pl/Sql.
Work with business owners in understanding the business requirements.
Analyze and solve business problems at their root, stepping back to understand the broader context.
Functional testing of the developed objects.
Performance tuning of Informatica Mappings & Pl/Sql.
Leading and developing a team of DWBI Engineer.
Leading DW/BI team engagements.
Establishing ETL Governance standards and best practices.
Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses.
Focuses on results and success, conveying a sense of urgency and driving issues to closure.
Optimizes use of available resources.
British Airways- ICW-Engineering Module Oct 2013 – Aug 2014
Title: Module Lead/Developer
Domain: Travel (Airlines), Retail
Roles & Responsibilities:
Co-ordinating with Business Users understanding the requirements and interpreting or providing the technical solutions.
Preparing estimations for all development and enhancement work.
Identified Risks, Issues and Dependencies and timely communication to clients for changes in the existing mapping or scripts i.e impact analysis.
Managed code development and working on the existing code changes either through ETL or Teradata SQL queries.
Creation of Unit Test script document for the developed mapping and enhancement changes.
Additionally, analyze existing code and suggest possible ways of improving the performances of mapping.
Process followed, and documents created for smooth deployment of mapping, Teradata scripts to UAT, Prelive and LIVE and also promotion of DDL’s to UAT and LIVE database.
Updation of change details in the Wiki link.
Best Buy-Employee Dashboard and Tech Support Jun 2013 – Sep 2013
Title: Module Lead/Developer
Domain: Travel (Airlines), Retail
Roles & Responsibilities:
Co-ordinating with Business Users understanding the requirements and interpreting or providing the technical solutions.
Preparing estimations for all development and enhancement work.
Identified Risks, Issues and Dependencies and timely communication to clients for changes in the existing mapping or scripts i.e impact analysis.
Managed code development and working on the existing code changes either through ETL or Teradata SQL queries.
Creation of Unit Test script document for the developed mapping and enhancement changes.
Additionally, analyze existing code and suggest possible ways of improving the performances of mapping.
Process followed, and documents created for smooth deployment of mapping, Teradata scripts to UAT, Prelive and LIVE and also promotion of DDL’s to UAT and LIVE database.
Updation of change details in the Wiki link.
GE Healthcare, Chennai & Mumbai, India Apr 2011 – May 2013
Title: ETL Developer & Tester
Projects:
a)Informatica 9.5 Upgrade project
b)SAP GECARS Lite Integration
c)HCIT Marketo Automation Integration
d)UCM Real time and Batch Integration
Domain: Healthcare
DESCRIPTION:
a)Informatica 9.5 Upgrade project: The project requirement is to upgrade the existing Informatica 8.6.1 version to Informatica 9.5 version in all the environments by Migrating all the integrations along with testing the same.
b)SAP GECARS Lite Integration: The project requirement is to Extract the customer and open invoices extract from SAP source system and transform the data into target GECARS server through sFTP flat file.
c)HCIT Marketo Automation Integration: The project requirement is to pull the changed records for contact, account and asset data on a daily basis from Siebel and Sales Logix oracle database system and transforms the data into a Wsdl Marketo message based on the Marketo requirements which is further sent to SOAf and Marketo SOAPAPI.
d)UCM Real time and Batch Integration: The project requirement for both real time and batch is to cleanse the America Customer Master data before creation and manipulation in UCM. The Interface must be able to read America Customer Master data, perform the data quality check and respond back the data to UCM through web services.
Roles & Responsibilities:
Developed real time mapping based on the design and requirement where source and target are web services and logic for data quality is built in IDQ as mapplet and mapplets are exported from IDQ tool to power center.
Developed batch integration mapping based on the design and requirement where source is a flat file and target is oracle database and logic for data quality is built in IDQ as mapplet and mapplets are exported from IDQ tool to PowerCenter.
Analyzing business requirements and creating design document which contains design process to handle the data sent from source to target system.
Develop mapping based on the design and requirement and send the data from oracle source to Target web service and oracle table.
Created documentation part of whole project and delivered it on time.
Testing done for the developed mapping and fixed the bugs too.
Preparing & Review of migration and deployment documents for the deliveries.
Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses.
Support of post-production deployment.
GE Commercial Finance, Mumbai, India Jul 2009 – Mar 2011
Title: ETL Developer & Application Support Member
Projects:
a)Fleet Europe - AAA +1 Extraction & load
b)Fleet Europe -Phoenix Application Support
Domain: Finance
DESCRIPTION:
a)AAA +1 Extraction &Load: The project aim is to basically enhance the development of AAA project. The main goal of the project is to merge the data from oracle and Ingres database and send the final data to DWH production environment.
b)Phoenix Application Support: The objective is to support the daily, weekly, monthly &yearly critical batch run on the legacy and other supporting system for Phoenix application.
Roles & Responsibilities:
Schedule batch jobs as per project request, analyzing chain Compatibility and timing of the job.
Monitor scheduled batch job(s).
Managing the File system.
Yearly Purging Activities in Scheduler.
Check issue(s), in case of any failure of batch run.
Send status report(s) of the job’s run status.
User id creation, modification and deletion.
New printer creation, Printer modification/deletion.
Management of production server like disk space, performance issue, removal of shared memory, application server checks.
Database management like disk space issue, performance issue related to application.
Contact this candidate