Data Project
Resume:
Adarsh Kumar
Senior Associate Consultant
Infosys India
Email: **.**********@*****.***
Career Objective:
To obtain a position of responsibilities that utilizes my skills and experience and keen to work in an environment where I can enrich my knowledge.
PROFESSIONAL SUMMARY – MDM & DWH/BI Support projects
• 7+ years of experience in Business Intelligence and Data warehousing project in Production support and Staging Environments.
• Created and maintained Versions, Hierarchies, properties, property query, import, Blend, exports, system & property categories in Hyperion DRM (Data Relationship Management).
• Engaged in Assessment for planning & reporting tool for a US-based Insurance services company and Experienced in various Banking sector project, Reinsurance Project.
• Designed and deployed Reports for the End-User requests.
• Worked on WODM/iLog (IBM ETL- Tool ) on jrules to handle business rules for Nationwide USA with different stages of projects which includes design, build, testing, maintenance and support also have strong Functional Knowledge of rule flow(BRMS).
• Experienced in solving Real Time issues with Event Handling using SLAM & SI. [Monitoring Application].
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Familiar with SDLC (Analysis & Design, Testing, Implementation).
• Effective & Excellent Role playing capabilities. Academic Qualification:
Graduation University Specialization Division
B.Tech UPTU Informational Technology I Division
Employment History:
No. Company Name Location Duration
1 Infosys LTD Pune, India Sep 2017- Till Date
2 Cognizant Tech Solution Pune, India May 2016- Sep 2017 3 Genpact PVT. LTD Gurgaon, India Jun 2012 – May 2016 TECHNICAL SKILLS
Databases: SQL SERVER 2005/2008,
Operating System: Windows 98-Win7,Unix
Tools Expertise:
Hyperion DRM/ Oracle MDM,Hyperion Essbase, Hyperion Smartview, Hyperion interactive reporting, FDMEE, iLog (ODM), TeraData SQL Assistant, Toad, MS Access/Excel/Power Point, Control M, CA Autosys Testing skill: Unit Testing, UAT, Regression Testing, SIT Concepts:
Data Warehouse, Data Modeling, Data Validation, RDBMS, Business Object, OLAP/TP
Onsite Exposure Duration 3 month.
• I travelled onsite location SYDNEY AUSTRALIA in March 2019 and stayed there till mid of Jun 2019.
• During this phase, I interacted with all the stakeholder and presented new ideas over the project’s obstacle.
• Effectively communicated to the Business and finalized changes for go live date.
• Involved, helped and provided strategic solutions to the business in their mid-year reconciliation.
• Awarded 2 times during this phase and one-time winner of SUPERTECH award during this phase. PROJECT SUMMARY
Company Client Working Place Role Duration
Infosys Westpac Group Pune India DRM
Developer
Sep 17 - Till Date
ERDM Upgrade Project Implementation
• Successfully Implemented latest version of DRM application for the COA changes as a part of upgradation from 11.1.1.2 to 11.1.2.4.341.
• Independently worked on upgrade project and made successfully go live.
• Independently installed & configured shield –pack of latest version DRM application.
• Worked on all the component of DRM application and great experienced on each i.e. Web client, Console configuration, Migration Utility & Batch client.
• Performed Reconciliation of data between MDM staging data & DRM staging data without any discrepancy
• Successfully tested and created project on multi-level approval process using worklist as DRG flow (Governance flow request)
• Successfully installed RCU (Repository Creation Utility) to enable web services of new DRM 11.1.2.4
• Worked on 2 projects simultaneously and made go live parallel for Ref data changes and COA changes.
2. PROJECT SUMMARY
Company Client Working Place Role Duration
Cognizant Technology
Solutions
CAS Pune India Associate Jan 17 – Sep 17
DRM Migration Clone Testing
• Actively participating in the migration project of Hyperion DRM from 11.1.2.3 to 11.1.2.4.
• Performing testing in various environment namely Clone, EXA DEV, EXA QA & EXA Prod
• Creating Test cases for all the functionality of DRM (Work list, Browse, Script, Import, Export, Admin, Blend)
• Validating the functionality of the clone environment w.r.t Production environment.
• Responsible for migrating folder structure, DRM artifacts which points to production.
• Setup security system performance and migrating version.
• Exploring new feature in the latest version of DRM. 3. PROJECT SUMMARY
Company Client Working Place Role Duration
Cognizant Technology
Solutions
MUFG Pune India Associate June 16 - DEC 16
Peoplesoft & Change Management
• Client handling and finalizing changes in DRM.
• Hierarchy Maintenance – Working on modification in DRM through Action script to process bulk change request.
• Inwards/outwards integration with source and target system.
• Customization of DRM validation using property definition and Node access type.
• Changed validations and verification in DRM which are responsible for meta data maintenance.
• Created imports for one time build in DRM.
• Perform operational maintenance of Data product. Identify problematic areas and conduct research to determine the best course of action to correct. 4. PROJECT SUMMARY
Company Client Working Place Role Duration
Genpact Pvt Ltd Nationwide insurance Gurgaon, India Associate JAN 13 – MAY 16 Reference data & Reporting
• Created, maintained and updated metadata in Hyperion DRM.
• Designed and Deployed Reports for the End-User requests.
• Developed & setup the Versions, Hierarchies, properties, property query, Automatous, import, Blend, exports, system & property categories in Hyperion DRM(Version_11.1.2.3) (Data Relationship Management) System.
• Maintained the historical copies/version of hierarchies, nodes, and properties for previous periods in time
• Migrated database & set up three copies of Database (DEV, QA, Prod).
• Created Action script to process bulk change request.
• Performed data validations to maintain Data Integrity throughout all the systems.
• Monitored ESP jobs in CA WA Workstation to ensure proper data propagation.
• Generated monthly and ad-hoc reporting metrics through DRM export.
• Changed validations and verification in DRM which are responsible for meta data maintenance.
• Created imports for one time build in DRM.
• Validated of Data before the hierarchy data propagation to ensure data integrity in the downstream systems.
• Validation of data in Data Warehouse and DataMart after the data propagation.
• Identified areas of improvement in the process and optimize the same.
• Created new data to existing data without affecting other users or processes.
• Loaded data from different sources for comparing, rationalizing and blending.
• Interpret data, analyze results, and construct ongoing reports in MS Excel.
• Good Experience in the business intelligence field; product suites and reference reporting task. Good Knowledge of DRM, Hyperion Smart view and Interactive reporting.
• Perform operational maintenance of Data product. Identify problematic areas and conduct research to determine the best course of action to correct. 5. PROJECT SUMMARY
Company Client Working Place Role Duration
Genpact Pvt Ltd Nationwide insurance Gurgaon, India Associate JUN 12 – DEC 13 Interface Support & DSA
• Worked closely with business users to gather requirements, defined project specifications, developed implementation and tested plans for the projects & enhancements.
• Being a part of “Nationwide Insurance” DWH Support Project, I had good experience in designing and developing the business rule through iLog(Intelligence Logic tool) which is also known as WODM (Version_8.5) and was given the responsibility of a configuration manager.
• Worked with WODM and was responsible for Rule grouping, rule authoring in iLOG.
• Defined decision tables and validated them through Rule runner testing (Unit Testing).
• Experience of jRule Analysis, Rule Authoring and deployment.
• Good understanding and hands on experience of Rule Designer/Rule Studio, Decision Table, Rule Execution Server, Decision Center, RTS (Rule team Server) and Prod_break fix testing/System Testing.
• Transformed, Validated and Loaded data using iLog.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing
• Scheduled and automated jobs for batch process
• Performed UAT and Regression Testing.
• Provided On-Call support to Mission critical Environments and expertise when any Interface fails.
• Experience in solving Real Time issues with Event Handling using SLAM & SI. [Monitoring Application].
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
Professional Achievement and Trainings:
• Lean Six sigma trained, tested & certified.
• After three month of joining, Received Caught on Spot award (Recommended by the client).
• Received Bronze and Silver award on the second quarter of 2013 and third quarter of 2014 respectively.
• Received service excellence Q1_2015 award from Nationwide USA.
• Attended 6 week live training on Hyperion Suits (Oracle DRM, Hyperion Essbase, Hyperion Interactive Reporting, Hyperion Smart view.)
• Attended 4 days session on Email writing & Soft skill.
• Attended 2 days session on MS Excel/access database. Strength:
• Hard working
• Good Listener
• Good Team Player
• Flexible to work in any shift
Personal Details:
Date of Birth: 10/10/1990
Marital Status: Single
Language: Hindi/English
Passport: L3128985
Declaration:
I hereby declare that the above-mentioned information is true to the best of my knowledge. Adarsh Kumar
10/10/2019
Contact this candidate