Shilpi Gupta

Experience

• 

  Cognizant

  Dec 2011 - Dec 2014

  Program Analyst

  The project involves assimilation of Credit Suisse components BMR (Basel Measurement Reporting) data mart analysis Pull the data from different source into BMR data mart, from which reporting is fetched for Investment banking and Private banking data.OBIEE is used to query on the presentation layer for user viewing. My role involves – • Performing cleansing, standardization of commonly used data at ODS level • Customize and streamline the data into an Oracle DB according to client requirements • Provide vendor comparative analysis to the client and support best vendor decisions on various parameters • Conduct or coordinate unit, system and regression tests to ensure that intelligence are consistent with defined needs. • Understanding the architecture of the source system.• Review FRD from Business analyst team and modify data sources to meet requirements.• Generated the extracts from different server (Upstream Application) for IB Data through Control-M process.• Performed data manipulation using basic functions and Informatica transformations• Developed mappings using transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Rank, and Sequence Generator.• Used Informatica Workflow Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.• Data load into Data ware house and BMR data Mart by using control M scheduler and ETL process.• Data Adjustment through MISC uploads by using STAR application.• Validation of dataflow, staging tables, dimension and fact tables.• Defect tracking using HP Quality Center.• Developed process related documents like SDS, SRS, URS, Impact Analysis, Traceability Matrix and Test Plan and Summary report. Show less

• 

  Tata Consultancy Services

  Dec 2014 - Feb 2017

  IT Analyst

  The project involves assimilation of GE Healthcare components supplier data from multiple sources (Oracle, Flat File) and pull into a Sourcing Data Warehouse using Informatica connectors into ODS and then summarized into EDW for calculating Bill of Material for Item data. OBIEE is used to query on the EDW layer for user viewing.My role involves – • Participated in system design and feasibility analysis discussion• Interacted with data Modeller, Business Analyst and Business users to clarify the change requirements.• Analysed Data Specification Documents (DSDs) and implemented their logic in the form of Informatica mapping design.• Managing development in truly AGILE methodology by conducting daily Scrum Calls with Client and team.• Assigning task as per user stories created by Functional users under rally and tracking the same for billing purpose.• Preparing project estimate and development executions docs as per requirement size. • Developed multiple PowerCenter Transformations like Lookup, Joiner, Expression, Router, Update Strategy, Source Qualifier, Aggregator, SQL, Filter, Sequence Generator to accomplish the mapping design process to cleanse data and load into ODS BI Stage table• Developed multiples Teradata Bteq to accomplish business logic for calculation of Best of Best Analysis Report and Bill of Material for items.• Developed Fast Load and Multi load scripts to load data from heavy flat file date into our BI stage tables.• Developed Fast Export script to generate files for downstream applications.• Developed UNIX script for file processing and mail configuration for Failure/Successful load status with concerned team.• Cross-checked codes developed by peers to validate robust, error free and quality standards as per business requirements.• Involved in developing test plans, writing test scripts, creating test data, testing and result analysis. Show less

• 

  Amdocs

  Feb 2017 - now

  10 +years of IT experience with Leadership quality, exceptional communication, Interpersonal, and team building skills.Sound Knowledge in providing quality solutions for the data analysis and business intelligence functions of a data driven firm and contribute effectively with my refined skills in ETL, Informatica,Azure, Snowflake, Python,Oracle, Teradata ,BO and Power BI reporting tool under Dataware housing projects.I always desire to learn new ideas and concepts quickly, ability to perform under pressure. Proficient in others skills sets to automate work by using Excel coding, Unix Shell scripting. I always use to be disciplined with strong work ethic. Show less

  • Software Development Manager

    May 2024 - now

  • DWH BI team lead

    Feb 2017 - now