Home

MADHU - INFORMATICA DEV

[email protected]

Location: Edison, New Jersey, USA

Relocation:

Visa: H1B

Employer : [email protected]; [email protected]; (609) 778-4215 ext 1000 Madhu PROFESSIONAL SUMMARY 10+ years of total IT experience in Programming and maintenance of Software along with designing of Data Warehousing Projects using ETL Tool Informatica. Experience in conceptual, logical and physical data models using ERWIN. Experienced in all phases of the project life cycle including Requirement Analysis, Design, Coding and testing. Worked in technical architecture, data modeling proof of concept, requirement study, system analysis, testing and development of decision support systems in the area of Sales and Marketing, Finance and Procurement. Worked as an Onsite Coordinator and led an offshore team of five in different projects within IBM for Wellpoint. Designed the Aggregate tables for summary calculations. Used Erwin as a Data Modeling tool. Worked on Oracle (PL/SQL), Teradata to write procedures for computation and of data and loaded into data warehouse/flat files. Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers. Worked on Informatica PowerCenter (10.2/9.6) Transformations i.e., Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator. Proficient in using Informatica workflow manager, Workflow monitor, Repository manager to create, control and monitor workflows, tasks, and sessions. Worked in Performance Tuning of Informatica Mappings and Sessions. Knowledge of different Schemas (Star and Snowflake) to fit reporting, query and business analysis requirements. Proficient in reporting tools such as QlikView 11, Business Objects etc. TECHNICAL SKILLS Data Warehousing Tools : Informatica PowerCenter 10.4.1/10.2/9.6/9.5/9.1/8.6/7.1 (Data Warehousing designer, Mapping Designer, Mapplets, Transformations), SSIS. Reporting tools : QlikView 11/10, Business Objects 6.1, Micro Strategy, Cognos. Data Modeling Tools : Erwin 4.1, E-R Modeling, Star Schema, and Snowflake. Databases : SQLServer 2012/2008/2005/2000, Oracle 11g/10g/9i, Teradata, IBM DB2 7.2, Netezza 7.2, Amazon RedShift. Languages : SQL, T-SQL, PL/SQL, C, C++, Visual C++, Java, Visual Basic Script. Web Technologies : Rest API, ASP, Java Script, HTML, DHTML. Operating Systems : Sun Solaris, AIX, HP-UX, Linux, Windows NT/2000/XP, MS-DOS. Utilities : Toad 7.x, SQL Developer, Aginity, SQL*Plus, SQL*Loader. EDUCATION Master s in Computer Science from NJIT, USA. Aug 2005 Aug 2006 PROFESSIONAL EXPERIENCE Kaiser Permanente, CA Sep,2021 Present Sr Informatica Developer Kaiser Permanente is one of the nation's largest not-for-profit health plans, serving 12.6 million members. It offers care and coverage together to support its members total health. This Project MMM (Member Month Mart) is a membership data sourcing from MDW (Oracle) and loading into MMM (Oracle) creating two main streams which is Member Month and Master and later combined with BDM to pull up the benefits information and load it to MBI (SL Server) and provide the same to Kaiser members through the portal. This project involved development of KPMC code by modifying current logic. The loading of data in MMM has different concepts such as Regular, Retro, Primacy, Newborn (only CA), Future, Person Enrich, ZRAM etc. for 8 different regions (i.e., MA, HI, WA, CO, GA, NW, NC, SC). Roles & Responsibilities: Attend daily KT sessions and Q&A sessions with the team. Involved in getting the requirements and business logic by understanding the Data Dictionary prepared by the Business Team. Design & Development of Informatica mappings, sessions & workflows by following company standards especially for the development of KPMC code. Use variables to configure queries and values for different regions and reusability of ETL code. Prepare support documents such as SQL code for migrating the code to different environments. Interact with Database Administrators, INFA Admins to deploy the code to higher environment and follow up on the Approvals. Develop the code and migrate it to multiple environments such as DEV, SIT, UAT, SOAK and PROD. Run the EHPE cycles for different regions to load data into portal by coordinating with the BDM team for downstream testing. Involved in re-setting the UAT environment for parallel testing. Use Version Control in Informatica to maintain multiple versions of an object and coordinate with team. Environment: Informatica Power Center 10.4.1, Oracle, SQL Developer, SQL Server 2012, TSQL/PLSQL, Clarity, Data Dictionary (Excel), Tivoli, Windows SharePoint, JIRA, Service NOW, Notepad++. Anthem INC, Virginia Beach, VA Jan,2018 Aug,2021 Sr Informatica Developer Anthem Inc (Amerigroup) is one of the largest health benefits companies in the United States. Through its affiliated health plans, Anthem companies deliver several leading health benefit solutions through a broad portfolio of integrated health care plans and related services. This project, PHS (Pharmacy Home System) is to identify members who have been misusing the system and to lock them in a state specified timeline. This involves loading data from ODW to our system (SQL Server) and perform business validations and provide the members data to PEGA team. Another project is to facilitate Provider loads from various markets and integrate them with GBD Facets. Files from the markets such as Central Region Facets (such as OH, IN, KY etc.), TX, MN, KS etc. need to be integrated and follow the standard process, which is GPI (Governance Provider Interface). The Source is mainly Flat Files, and the target would be SQL Server and Oracle. Responsibilities Attend daily Scrum calls, along with grooming, planning, review and retrospective meetings with the Business. Create stories and assess points and work with the team to complete them every sprint. Involved in migrating Informatica Workflows from 9.5.1 to 10.2 version and providing support accordingly. Perform code review for Jr Developers and provide design approach and guide them. Design & Development of Informatica mappings, sessions & workflows by following company standards. Use variables to facilitate File validations and reusability of code. Extract the data from flat files and load as Raw tables & Audit tables to SQL Server and Oracle. Use Informatica Data Transformation tool to parse JSON files and create POC to use them with REST API. Worked with the team to use GET and POST data to REST API. Create and modify ad-hoc stored procedures for better functionality of the code. Prepare support documents such as BOIPs for migrating the code to different environments. Interact with Architects, Database Administrators, INFA Admins to deploy the code to different phases and follow up on the Approvals at each stage. Develop the code and migrate it to multiple environments such as DEV, SIT, UAT and PROD. Use Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes. Use Tortoise SVN for Version Controlling of the scripts, command and XML files to move from one env to another. Use CNR Test Utility tool to perform QA Testing by executing the command files in Databases. Create Tidal jobs and job groups to schedule Informatica jobs and automate workflows along with stored procedures. Create jobs in Control M to schedule Informatica jobs for PHS to run on a daily/weekly/monthly basis. Environment: Informatica Power Center 10.2/9.5.1, Informatica DT 10.2, Oracle 9, SQL Developer, SQL Server 2012, TSQL/PLSQL, TIDAL, Control M, CNR Test Utility, Windows SharePoint 2010, TortoiseSVN, JIRA, Service NOW, Ultra Edit, PEGA, Planview Enterprise 11, Windows 7 Enterprise. Ryder, Miami, FL Jun,2017 Dec,2017 Sr Informatica Developer/Led Ryder provides fleet management, transportation, and supply chain solutions to companies of all sizes that ease complexity, increase efficiency, and keep goods and materials flowing so that the economy can grow and thrive. The work in Ryder involves in developing individual projects such as HR Feed, iVOS as well as working on Change Requests, Regression testing (on GIS, Call Center) and Production issues etc. The data will be extracted from the source systems such as SQL Server, Oracle (Cloud) to different layers in Netezza, such as IDL, SDL and BDL by following data warehouse concepts such as Dimensions and Facts. Responsibilities Attended standup meetings on a weekly basis to provide status and outstanding issues on the current projects. Conducted meetings to gather requirements from business/vendors and communicate with SMEs and BAs. Got BRD signoff and provide timelines and estimates to business on individual projects. Involved in Leading individual projects as well as working with team and guiding CRs and Production support. Design & Development of Informatica mappings, sessions & workflows by following company standards. Used ETL Control Cycle logic to control the connection and load of data for incremental & historical loads, which involves updating the dynamic parameter file by extracting information from static parameter file. Extracted the data from Oracle & SQL Server and loaded to the Data Warehouse (in Netezza) and/or outbound files. Worked on Star Schema data model consisting of dimensions and facts and created views by joining multiple tables for the reporting team. Performed different validations in Staging Data Layer (SDL) before loading the data into BDL for the Business. Prepared support documents such as SQL Scripts, XML documents for migrating the code to different environments. Interacted with Database Administrators, INFA Admins for deploying the code to different phases such as DEV to QA and Production and following up on the Approvals at each stage. Work with reporting team to assist in joining tables/views to create reports and gain understanding of MicroStrategy. Involved in migrating about 100 Informatica mappings & related workflows for iVOS project while in development, from IDL to IAS (Insurance Accounting Services) layer to control the level of access for other departments. Worked with the EDI team to schedule the SFTP process for the outbound files to vendors. Used Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes. Used Run My Jobs (Redwood) to schedule Informatica jobs to automate workflows on a regular basis. Environment: Informatica Power Center 9.6.1, Informatica MDM 10.1, IDQ 9.6.1, Netezza 7.2, Oracle 11g, SQL Server 2012, AWS RedShift, Redwood RMJ 9.0, Aginity, SQL Developer, WinSCP, Micro Strategy, Unix, Windows 7 Enterprise. Anthem INC, Virginia Beach, VA Nov,2013 Apr,2016 Sr Informatica Developer Anthem Inc (Amerigroup) is one of the largest health benefits companies in the United States. Through its affiliated health plans, Anthem companies deliver several leading health benefit solutions through a broad portfolio of integrated health care plans and related services. This project mainly focuses on providing a solution to the vendor loads that support different states such as VA, GA, FL, KY etc. The source is a flat file, and the target would be ODW in SQL Server. This project also focuses on the table moves that support different states where the Source database is mainly Oracle, and the target would be ODW in SQL Server. Responsibilities Attended meetings regularly on a weekly basis to provide status updates on the current projects. Used Team Status Log on SharePoint to estimate milestones and communicate with Business Analysts. Design & Development of Informatica mappings, sessions & workflows by following company standards. Used parameters and variables to facilitate the reusability of code. Extracted the data from Oracle and/or flat files, transformed it as per the business requirements and load to ODW. Created synonyms, triggers, tables etc. in Oracle to support Incremental loads. Performed different validations at field level and provided Error Handling to the customers. Provided Error Report for each file load and present customers with the quality of the vendor data. Prepared scripts to create/update the tables in the Target Database in multiple servers. Prepared support documents such as BOIPs for migrating the code to different environments. Interacted with Architects, Database Administrators, INFA Admins to deploy the code to different phases such as DEV to QA and Production and following up on the Approvals at each stage. Used Tortoise SVN for Version Controlling of the scripts, command and XML files to move from one env to another. Used CNR Test Utility tool to perform QA Testing by executing the command files in Databases. Used Tidal to schedule Informatica jobs to automate workflows on a daily basis. Environment: Informatica Power Center 9.5.1/9.1.0, Oracle 11g, SQL Developer, SQL Server 2008 R2, Teradata, TSQL/PLSQL, TIDAL, CNR Test Utility, Windows SharePoint 2010, TortoiseSVN 1.8/1.7, JIRA 6.3.6, Service NOW, Planview Enterprise 11, Windows 7 Enterprise. CoreLogic (RP Data), Irvine, CA Sep,2012 Oct,2013 Sr Informatica Developer RP Data, a division of CoreLogic INC, based in the USA, is the biggest provider of property information, analytics and risk management services in Australia and New Zealand. Using public and proprietary data, it brings insight and transparency to the property market. The goal of this project "Suburb Scorecard" is to develop the reports based on property information with different metrics and provide the same to its customers. Responsibilities Participated actively in Client Scrum Calls, meetings with Project Manager and status meetings. Responsible for design and development of ETL solutions using Informatica 9.0.1. Designed and Developed mappings for loading the historical data and also developing the User Management Functionality using different transformations using Informatica Designer. Extensively used data conversions transformations, sort, aggregate and other transformations as per business logic. Developed customized email notifications using C# in script task. Used various Connection Manager Components to extract data from disparate sources like SQL Server, CSV, Excel. Performed data cleansing and data scrubbing of the staging data and integrating the data using SQL stored procedures and functions. Prepared the Deployment Instructions document and provided support to the on-site Admins for DB Scripts, ETL code, Dot Net code and SSRS reports for deployment in UAT and Production. Scheduled the Jobs to run the workflows at a defined frequency such as monthly loading of the historical data etc. Involved in unit testing of data and bug fixing of complex reports like Suburb Scorecard developed using SSRS. Used Tortoise SVN for code repository and versioning. Used Version One for Requirements Gathering and Defect Tracking. Used "Atlassian, Inc" JIRA software for logging the hours on a weekly basis. Environment: Informatica Power Center 9.1, SQL Server 2012/2008 Database, SQL/PLSQL, SSRS 2012/2008, Visual Studio 2008, Version One v13.0, TortoiseSVN 1.6.12, JIRA, AETTS, Tankhwa, Windows 7. Tria Beauty, Dublin, CA Jul,2011 Aug,2012 Sr ETL Developer TRIA Beauty is a pioneer in the field of laser hair removal and innovative cosmetic products. TRIA Beauty sells their products across the globe from various different Countries. TRIA Beauty preferred Adaequare as an implementation provider for the Marketing forecast which would help in analyzing the spending on various advertisement channels; return on investments, customer service channel revenue generated through various ads media like Google, Yahoo, MSN etc. Responsibilities Participated actively on Clients Calls, meetings with Project Manager and delivery head to discuss and produce alternatives of problems. Developed Technical Design Documents and follow the Software Development Life Cycle and coding standards. Responsible for implementing the ETL solutions using SQL Server Integration Services. Designed and Developed SSIS Packages for Daily Loads, GA_Ecomm, Customer Service Portal, Invoice Return Loads using Control flow task, Data Flow Task, Execute SQL Task in SSIS Designer, besides other Transformations. Extracted data from various sources like SQL Server 2005/2008, CSV, XML, Excel and Text file. Unit tested the SSIS packages with new table locations and fixed the errors exposed. Scheduled Jobs to run the SSIS Packages in a timely manner through SQL AGENT. Performed data validation, supported and maintained existing ETL packages. Developed complex reports such as Standard Reports, Physician Dispense, Gross Revenue Reports etc. using QlikView 10/11. Generated different reports using objects such as List Box, Straight/Pivot Table, Bar/Line Charts, Buttons, and Container etc. and tested the functionality in Access Point as well. Involved in the migration of QlikView from vs 10 to vs 11 and supported accordingly. Checked-in the code/documents to SVN and keep it up to date. Logged in the hours spent into Jtrack as well as AETTS (Adaequare Employees Time Tracking System), weekly. Environment: SQL Server Integration Services 2008, SQL Server 2008/2005 Database, SQL Agent, SQL/PLSQL, QlikView 11/10, Access Point, TortoiseSVN 1.6.12, Jtrack, AETTS, Tankhwa, Windows XP / Windows 7. Wyndham Hotel Group, Parsippany, NJ Nov,2010 May,2011 Sr Informatica Developer Wyndham Worldwide is one of the world's largest hospitality companies across six continents. Wyndham offers individual consumers and business customers a broad array of hospitality products and services as well as various accommodation alternatives and price ranges through their premier portfolio of world-renowned brands. Responsibilities Understanding user problems or that business is facing with the data and processes and finding ways to correct them. Understand the definitions of each field, map the fields in the table(s) using Metadata Manager. Responsible for writing Technical Design Documents, follow Software Development Life Cycle & Coding Standards. Responsible for understanding of existing Informatica processes and finding out ways to tune/improve them. Support the business groups by resolving issues and providing guidance and feedback to the user. Handle business and user inquiries about data and processes. Development of SQL scripts in Oracle 9i or DB2. Write code in Informatica v8.1.1 and create Transformations, Mappings, Sessions and Workflows as per requirement. Create Projects in Trillium v13 to standardize incoming data & merge with existing data & find possible match of recs. Responsible for consistent and frequent updates to the immediate manager about the project status and concerns, also to other project team members on a need basis. Support QA/UAT team in resolving the defects found. Deployment coordination, including seeking Change Management approvals and build management. Respond to support tickets and resolve issues based on the urgency and the importance of the issue. Environment: Informatica Power Center 9.0.1/8.6.1, Oracle 9i, DB2, Toad, Quest Central for DB2, Trillium v13.0, TSQL/PLSQL, Assyst, Release Manager, WinSCP, Clarity, Windows XP Professional, UNIX - AIX. International Business Machines Corporation (IBM) Dec,2009 Oct,2010 Wellpoint, Richmond, VA Sr Informatica Developer (Onsite coordinator Leading Offshore Dev Team) Wellpoint (Anthem INC) is one of the Nation s largest publicly traded Health benefits companies, with services like Health Insurance, dental benefits and pharmaceutical benefits. This project (Standard Data Extracts) mainly focuses on providing a solution to the vendors who would want data as per their Business Requirements. If the SDE does not meet the Business Requirements, then it would be treated as a separate Project/SSCR. The Source database is Teradata, and the target would be Flat files sent to the Customers. Responsibilities Participated in Requirements gathering, Business Analysis and User meetings, discussing the issues to be resolved and translating user inputs into ETL Design Documents. Prepared Technical Design Documents & Approach review documents based on the Functional/Business requirements and receiving Sign Off from the Business Users on the Mapping Documents. Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow Monitor. Extensively used transformations such as Expression, Filter, Joiner, Lookup, and Aggregator. Used Parameter and Variables for dates to facilitate the reusability of code. Used Teradata utilities such as BTEQ, Fast Load, Multi Load, Fast Export, DDL and DML commands (SQL). Design and Development of Unix shell scripting for Parm/Env/Logon files and scripts. Extracted the data from EDLR1 as well as Edward (EDLR2), transformed it as per the business requirements and loaded it to the Flat Files/Temp Tables. Extensively interacted with Data/Solutions Architect, Database Administrators, INFA Admins, Environment Coordinators and Production Control Team to move the code to different phases such as DEV to SIT, UAT, IR (Implementation Readiness) and Production and following up on the Approvals at each stage. Performed extensive testing on the mappings and wrote queries in SQL Assistant to check if the data was loading from one instance to another. Extensively worked with the WLM COE team to schedule the job sets/jobs to run the Informatica workflows through a 3rd party tool, WLM (Workload Manager). Documented each stage of the project in SDLC Workbook, by conducting meetings and gaining Approvals. Lead a development team of 5 for different Projects. The Dev team is from offshore IBM. Environment: Informatica Power Center 8.6.1, Teradata SQL Assistant 12.0, TSQL/PLSQL, Ipswitch WS_FTP Professional 2007, Windows SharePoint 3.0, Unicenter WLM scheduling tool, Planview Enterprise 9, Service Center Enterprise v6.2, Windows XP Professional. American Financial Group, Cincinnati, OH Feb,2008 Oct,2008 ETL Informatica Developer for Claim Center Conversion AFG provides insurance products and services tailored to meet the specific and ever-changing financial risk exposures facing their customers. This project mainly focuses on converting current data so as to use it in Claim Center, which is maintained by Guide Wire. Claim Center uses the data in SQL server 2005 populating from different sources, to process all the pending claims for Equine. Responsibilities Participated in Functional Meetings to understand various Source systems to be consolidated and involved in designing the data model for the Warehouse. Designed the procedures for getting data from all systems, like IMS to the Data Warehousing system. The data was standardized to store various Business Units in tables. Worked closely with Business Analysts to Design & Develop SQL Statements, Data Conversions, Data Cleansing. Data Quality Analysis to determine cleansing requirements. Used Oracle, Sql server, DB2, and Flat Files as sources and Sql server 2005 as target. Extensively used ETL to load data from Flat Files, such as Cobol Files to Sql server 2005. Coding and Debugging, Sorting out their time-to-time technical problems. Worked with almost all Transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter, Router, Expression, Aggregator, Joiner etc. Written simple & complex SQL-overrides in source qualifier & look-up transformations according to the Business Reqs. Developed Informatica mappings and tuned them for Better Performance and validate the data. Worked on Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes. Involved in Batch processing & Scheduling Informatica jobs on a weekly/monthly basis using 3rd party tool, UC4. Environment: Informatica Power Center 8.6.0/7.1.2, Toad, SQL Server 2005, IBM DB2 7.2, Oracle 9i, SQL, WinSCP 3.7.6, UC4 Portal, Scrum Works Portal, Windows XP Professional. New Jersey Institute of Technology, Newark, NJ Jan,2006 May,2006 Master s Project: Online Video Store The goal of this project is to design an online video store that rents movies (cd/DVD), video cameras and VCRs. Responsibilities Developed the Interface using ASP.NET. Written the code in Visual Web Developer using Visual Basic Language. Designed database and table structure using Oracle 9i as Backend. Validated the code and tested for correctness of the output. Environment: ASP.NET, Visual Web Developer 2005, VB Language, Oracle 9i, SQL, Windows XP. Keywords: cprogramm cplusplus csharp continuous deployment quality analyst user experience database active directory rlang information technology hewlett packard microsoft procedural language California Colorado Florida Georgia Kansas Kentucky Massachusetts Minnesota New Jersey North Carolina Ohio South Carolina Texas Virginia Washington