QA Manager
Resume:
SUMAN AGARWAL
acr5gl@r.postjobfree.com
PROFESSIONAL SUMMARY:
Over 15 years of total IT experience.
4+ years of experience in data warehousing and ETL projects.
Experience in Informatica powercenter and SAP BW development.
Worked on both relational and Dimensional Data Modeling.
Experience working on ETL process consisting of data transformation, conversion, loading and data analysis, design and development of mappings.
Used Informatica PowerCenter Tool for data conversion from variety of source systems. Dealt with various transformation logic like Lookup, Aggregator, Joiner, Source Qualifier, Normalizer, Expression, Update Strategy and more while designing and developing complex mapping and mapplets.
Exposure to Banking, Health Care, Retail and Telecommunication domain.
Proficient in writing and executing complex SQL queries
Worked in Agile Scrum Methodology environment.
Constantly learning and upgrading skills with the advances in the field and excellent team member.
Worked in Onsite-Offshore Model and have managed a team of 2-4.
Capable team player, detail-oriented and motivated individual with strong analytical and communication skills
TECHNICAL SKILLS:
Data Warehouse
Informatica Powercenter, MDM, SAP BW 7.3
Databases
Oracle 8.x/9.x/10.x, SQL SERVER 6.0/7.0/2000, DB2, My SQL.
Reporting Tools
BEx Reporting(Analyzer, Query Designer), Web Reporting(WAD)and Crystal Reports,
Operating Systems
Windows 95/98/00/XP, NT, MVS, IBM MAINFRAMES MS-DOS, UNIX (Solaris 2.8), Lotus Notes, AS/400
Software Languages
JAVA, C, Visual Basic, Cobol
Web Technologies
HTML, JavaScript, XML
DB Tools
TOAD, SQL*PLUS, PL/SQL Developer
PROFESSIONAL EXPERIENCE:
Moodys, NYC, NY
January 2015 – Present
MDMS (Master Data Management System): The main objective of the MDMS project is to build a central repository that houses Vendor data and Moody’s in-house data such as Organization, Instrument, Common Reference, Rating and Person. The data collected from various sources was processed through Batch processing (Apply Business rules, Match and Merge processing and Exception handling). The Exceptions are routed to Data Steward for further enhancements or approvals before mastering the final data. The Mastered Data is then made available to EDW (Enterprise Data Warehouse) application real time.
Responsibilities:
Worked with BA for preparing the Functional requirement document, use case document, vizio diagrams, Business rules and Project Plan document.
Developed data models for MDMS system.
Developed mapping to populate data from various sources to single data warehouse.
Developed slowly changing dimensions and fact loading mappings.
Developed parameter files generation for all the staging mappings.
Extensively worked with Lookup Transformation and Normalizer Transformation.
Involved in Unit Test case preparation.
Development of ETL Mappings, Sessions and Workflows for data cleansing and Performance Tuning of mappings.
Created Reusable Transformations, Mapplets using Informatica Designer Tool.
Created Test cases, preparation of Test Data and testing of mappings.
Created stored procedure.
Data Loading by ETL mappings and performing required data checks.
Used IDQ console for Manual Match and Merge records.
Performed Data Integration on data from various sources.
Design and development of XML extracts from a relational database using Informatica, SQL & PL/SQL.
Helped in migration of Moody’s legacy data to new MDMS system.
Guiding Test team for running their test cases.
Environment: Informatica Power Center, MDM, IDQ, ETL, Java, Oracle, SQL Developer, APPM, AutoSys Automation Tool.
IntegriChain, Princeton, NJ
April 2014 – Present
Order Planning (Vendor Managed Inventory) project: Order Planning is a tool built by IntegriChain for inventory management and order fulfillment. Various Algorithms are provided to the trade partners for demand forecasting. Customers are also provided with reports like Inventory level, Safety stock, promotion and event, lead time.
Responsibilities:
Worked as ETL developer.
Helped in building the data model for Order Planning system.
Majority of the work involved was for designing the data flow and verifying the data flow is working correctly.
Different Manufacturers and trade partners were sending data in form of flat file either in CSV format or text format.
Developed mapping to populate data from various sources to single data warehouse.
Involved in slowly changing dimensions and fact loading mappings.
Worked extensively with various complex type of Transformations such as Lookup Transformation, Normalizer Transformation and Update Strategy Transformation.
Development of ETL Mappings, Sessions and Workflows for data cleansing and Performance Tuning of mappings.
Created Reusable Transformations, Mapplets using Informatica Designer Tool.
Created complex Sql queries for forecasting Techniques.
Created Test cases, preparation of Test Data, testing of mappings.
Data Loading by ETL mappings and performing required data checks.
Performed Data Integration on data from various sources.
Environment: Informatica Power Center, MDM, ETL, Java, SQL Developer, Data Science, Hadoop, R programming, Forecasting Algorithms, Agile environment, Jira.
Galaxe Solutions/CVS Caremark, Somerset, NJ
03/2011-Feb 2014
Tech Lead
Benefit Builder (ETL) project : Benefit Builder is in-house tool built by CVS Caremark/ Galaxe solutions for migrating Benefit Plan data to RxClaim System. Benefit Plan information comes to Benefit Builder tool from many different source systems and in different file formats like CRDs(XML) and CIF(Xlsx). The data is converted and stored into oracle table for further processing. Here, the data is also parsed in order to make sure it meets the business requirement. During parsing, invalid data is rejected entirely or partly and reports are sent back to the source client. Benefit Builder tools also applies series of business rules to the meta data in Transform stage. This data is again converted to flat file (BPF) and then gets loaded to RxClaim using the BPL tool.
This automated tool has benefited CVS Caremark considerably by helping the Plan migration 100 times faster and with no room for manual error.
BPL (ETL – Load Stage) project: BPL is in-house tool built by CVS Caremark/ Galaxe solutions for loading data into RxClaim system. The data is converted from XLS format to BPF files before loading them into RxClaim. It has helped CVS Caremark to upload data in mass during migration.
Med D Dashboard project is implemented by CVS Caremark to provide various reports for the Business Management. Several categories of reports were created - Daily Summary and Targeted Reject Review Summary reports, Potential Outlier Reports, Management Reports and Adjustment Reports. Potential Outlier reports are the reports which give more information for the claims (Paid or Rejected claims) based on Drug, Step Therapy, Prior Authorization, Formulary, etc. Management Reports are further categorized as Summary Report, Weekly report, YTD ranking report, Transition Fill etc.
Responsibilities:
Serving as BW/BI Senior Lead for front end/back end and Report Designer.
Majority of the work involved was for designing the data flow and verifying the data flow is working correctly.
Different Source systems were sending data in form of flat file either in CSV format or XML format.
Created Workflow, InfoCube and DSO and Performed Unit testing
Created Dashboard reports using sample data from DW. Some of the reports were Daily Summary and Targeted Reject Review Summary reports, Potential Outlier Reports, Management Reports and Adjustment Reports.
Involved in defect fixing and production support.
Performed Data Integration on data from various sources.
Helped in migration of Aetna Legacy data to CVS Caremark system.
Environment: SAP BW 7.3, Data warehouse, ETL, BI Reports, Dashboards, Java, Oracle, HANA, Toad, SQL Queries, Agile environment, Sharepoint.
Client Connect Gaps project is implemented by CVS Caremark to help Recap Customer to migrate to RxClaim system. There were many gaps which were identified by the Business experts between the two application systems. In order to bridge the gap between the two systems, gap projects were created for each wave cycles. Both Batch processing and Adjudication system of RxClaim application was impacted. All the members will be moved from Recap to RxClaim System. Along with the members files, History Claim Load file, Accum file and PA files also needed to be moved to RxClaim. Each member old claims are again adjudicated prior to the move. There were several edits on Plan Options which were implemented as part of the project. Due to complexity and risk involved, the project was done in waves.
Single Source Generic project implemented by CVS Caremark will allow the Network participating in SSG program to process the claim with Single Source pricing rather than Generic pricing. Single Source Generic allows the Client or Pharmacy networks to participate in the Single Source Generic Program. SSG Drug list containing Single Source Generic drugs can now be defined independent of the network and later mapped to the network. The project allows flexibility to the network to define pricing scheduler at various level – product, list or network. Adjudication logic is initially modified for certain types of claim.
Now, Program NDC/ GPI list could be created and attached to Benefit Pricing Profile Network. During Claim Processing, Adjudication will check if the network is participating in the SSG program. If the drug is matched against the drug list attached to the network, the price schedulers are searched based on the priority. Upon first match the claim is paid based on the new price schedulers for SSG drug.
Cross Platform Age-In Transfer project implemented by CVS Caremark provides functionality for Quantum Leap (QL) Commercial client to migrate to RxClaim Med D. A process was created to send a file from RxClaim to QL Eligibility that identifies the members who transitioned to Med D from QL Commercial. A process was created that will allow ongoing movement and loading of selected members’ trailing files as current members on QL begin to transition to Med D benefits with SilverScript on RxCLAIM.
Responsibilities:
Worked in creating Business Requirement Documents and Functional Requirement Specification.
Was identified as Subject matter
Wrote and maintained Design document.
Reviewed both online and batch code.
Guided both development and QA team.
Worked with Clients and offshore team to meet deadlines.
Environment: AS/400, RxClaim, DB2, Cobol, Quality Center, Healthcare Domain, Agile environment, Sharepoint
ING Direct, Wilmington, DE
12/2009 – 03/2011
Analyst
The project, Apollo, is aimed at merging all lines of business, which include Annuities Investment, Life Insurance and Retirement Planning and Benefits tools, into one common access ground for services through IBM's WebSphere Portal. Unique user names will enable ING Securities Group to identify the individual users logging into ING to access their accounts and/or portfolios. Therefore, SSO (Single-Sign-On) registration process must provide a high level of assurance that the customer is adequately authenticated. Individual entitlements will decide the view of individual account for the users.
The new solution being implemented by ING includes a content management system (Stellent) to manage content for public sites such as ing.com/us and Post Login sites such as the Virtual Finance Center. Migration of the Application modules from the Legacy Mainframe to Three Tier System. Also included is a redesigned public-facing site for ING and a new Portal to support the firm’s representative and brokers that sell ING Products (VFC). Content Management is needed to support publishing content that may appear on the public-facing site, the new VFC portal and on the other ING managed sites such as SmartWorks.
The new solution was also implemented on Sharebuilder application which is ING Direct online Electronic trading tool for capital markets & global equities.
Responsibilities:
Worked with business team to gather requirements.
Create Stories and use cases.
Helped Developers and QA team to understand the business requirements and prioritize them.
Facilitated testing.
Reviewed Design Document, Test Plan and Test cases provided by QA team.
Helped developers to recreate and track the technical issues.
Environment: Java, V1, Windows 2000/XP, DB2, Oracle, Informatica, Banking Domain, HTML, XML, PVCS, IBM Web-Sphere.
Cosmonet Solutions 09/2001 to 04/2005
Systems Analyst / Developer
Worked for Cosmonet Solutions as a Project Lead/Systems Analyst in their Web development project. My Earning Ezine was designed to help create and publish E-magazine with minimal effort. Powerful tools were created like content bank, Email bank to help Eziner in maintaining their data. This site also offers Residual Earning opportunity with 3*9 Forced matrix.
Responsibilities:
Responsible for Requirement analysis and preparation of Software requirements specification and Software specification document for senior managements and Client.
Coordinate design and implementation of applications, collaborating with Client and engineers to ensure on-time completion of product deliverables.
Provided technical leadership to junior engineers, developing overall project architecture.
Developed programs in Java language.
New features for enhancement of application was suggested and given approval.
Iterative SDLC model was used to develop the application.
Off the shelf components were used throughout the project, thus reducing development and testing time.
Developed powerful tools were for the creation of e-magazine.
Sophisticated algorithms like residual Earning Opportunity with 3*9 matrix was developed for the end users.
Responsible for development of standard documentation package (Requirements, Specification, Design, and Quality Testing Plans)
Prepared test cases and created test scripts for the UAT testing and support
Project Management including co-ordination with Client, Senior Management & Team members.
End to End implementation and Post-production support
Coordinated deliveries, queries, issues with client and track it to closure
Conducted technical/non-technical presentations to the management.
Configured the network and set-up hosting facilities.
Involved in Programming, performing Unit testing, system testing, and integration testing.
Perform data analysis, testing, debugging, audits, disaster recovery, and problem resolution.
Research and evaluate technology solutions and present recommendations for improved system operations.
Create data verification methods and comply with standard system procedures.
Used to arrange meetings to discuss Requirement issues with Clients.
Wipro Technologies 06/1996 to 08/2001
Systems Analyst / Developer
Nortel Telecommunications
The Automatic CAll Distribution Group in Wipro-Nortel Meridian group works in conjunction with the Advanced Call Center Technology Team (ACCT) in Nortel Networks, Canada. The ACCT team (formerly called as Business Application Team), works in X11 ACD, X11 interface to all the Application Modules, Applications Modules like Meridian Link, Customer Controlled Routing and Symposium. The activities of Call Center group encompass three distinctive areas. It is consists of: 1.X11 ACD 2.X11 MLink 3.Symposium 4.Meridian Mail 5.CCR
Responsibilities:
Responsibility for the programming, design and testing of new features for ACD application.
Analyzing Problem Reports (PRs) and fixing defect found in the existing ACD application.
Prepared test cases and created test plan for the UAT testing and support
Provided customer support and demos for Nortel customer.
Conducted technical/non-technical presentations to the management and training workshops for the clients.
Designed and developed QC tools for the project.
Home Depot
Home Depot is leading company in USA. It has more than 800 stores in USA and planning to expand their business in Europe, Asia and South America. The System developed by them was specific to USA and to customized for individual store requirements. As part of globalization, the system across stores needed to be same within USA and elsewhere in the world. Since the languages are different, the programs needed to be made language independent. That is, in England the program would generate reports in England and the screens are also in English, whereas when in France, the same program would generate reports in French and Screens are displayed in French.
Responsibilities:
Responsibility for the analyzing, programming, and unit testing of online and batch programs.
Analyzing Programs for globalization and creating form express programs to solve the issue.
Prepared test cases and created test plan for the UAT testing and support.
Responsible for globalization of highly critical and difficult SV (Special Service) system.
Involved in developing tools for globalization. This tools was highly appreciated by the clients due to its efficiency.
Coordinated deliveries, queries, issues with senior management.
Responsible for reviewing team members program.
Worked on POS systems
Nexgen-Ceridian
Ceridian Corporation is an information services company in the human resources, transportation and retail markets, serving businesses and employees in the USA, Canada and Europe. Ceridian wanted Wipro to upgrading its customers product to the highest version. Ceridian Product was customized by their customers as per their requirement. Upgrading would overwrite their customization. Hence, Wipro provided each ceridian customer with update patches with their customization and also have their product Y2K complaint.
Responsibilities:
Responsibility for the analyzing, programming, unit testing, and system testing of Customer System.
Analyzing Programs for customization and Y2k compliance.
Created update patches for upgrading the system to the highest version, include customization and Y2K changes.
Prepared Change Report, test cases and created test plan for the UAT testing and support.
Coordinated deliveries, queries, issues with senior management.
Responsible for reviewing team members program.
Putnam Investments
Programmer
Putnam Investments is one of the largest mutual fund complexes in the United States. The project required for Conversion of VSAM files to DB2 tables and writing SAS report programs.
Responsibilities:
Studied individual program thoroughly for impact analysis.
Modified Programs such that they use DB2 tables instead of VSAM files and also for Y2K compliance.
Involved in writing I-o routines so that DB2 tables are used instead of VSAM files in the program.
Responsibility for the analyzing, programming, unit testing, and system testing.
Involved in migrating the VSAM files to DB2 tables.
Developed SAS programs to generate reports for the customers.
Prepared Change Report, test cases and created test plan for the UAT testing and support.
Coordinated deliveries, queries, issues with senior management.
Attended conference meeting with on-site clients.
Involved in training junior engineers in the project.
Education
Taken PMP training and candidate for PMP exam in January.
Bachelor of Computer Science, Bangalore, India 1996
Computer Science Training at KREC, Suratkal, India 1996
Wipro Academy of Software Excellence, 1999
Masters in Information Technology, BITS Pilani (Not Completed)
Training taken
Project Management training
Situational leadership
Business Analyst training
SDLC process
SAP BW / Hana
Informatica
R programming
Contact this candidate