Power Bi Data Analysis
Resume:
Geeta Singh
Mob: 203-***-****
***** **** **** ****, **** o’ Lakes FL, 34638
***********@*****.***
EXPERIENCE SUMMARY
• The consultant has experience of 12 years in system development activities, system analysis, requirement analysis, team coordination, design, coding, Manual Testing, maintenance, and implementation of Software Systems.
• Interactive and creative person with strong DW skills and strong Data Management processes skills using ETL Tools. Developed modularized applications with database procedures using database objects such as procedures, and functions. Good Knowledge of reporting and developing dashboards using the reporting tool Tableau with exposure to Spotfire.
• 10 years of Experience in ETL tools using Informatica Power Center, SSIS, Excel, Oracle, and SQL Server.
• Skilled in system analysis and problem-solving. Experience in Data analysis using SQL/Excel and converting into meaningful information using BI tools like MS Excel, QlikView, Tableau
• Good experience in system and Interface testing.
• Proficient in verifying and validating data. Excellent exposure to QA processes and process improvements.
• QA testing and reporting as per organization KPI. Created a QA dashboard for leadership for reporting and status updates.
• Possesses strong analytical skills to interpret customer data needs and translate them into application and operational requirements.
• Experience in creating in Business data flows using Visio for existing and to-be business processes.
• Implemented the process of continuous Business improvement by interacting with users and Stakeholders.
• Completed Internal trainings on Training on QMS, Process Champion Workshop (PM)
• Worked in a scrum team. Used Jira for Project deliveries and tracking.
• Used SharePoint for Document management.
• Working knowledge of Service Now.
• Trained in Informatica data management tool - MDM
• Self-learning Microsoft Power BI and IICS (Informatica Cloud). Page 2 of 5
EDUCATION
Degree Year of Passing
Master of Computer Science (M.Sc., Mathematics 2004 Master of Computer Science (M.Sc., Comp Science) 2003 Bachelor of Science (B.Sc.) 2001
TECHNICAL EXPERTISE
BI and other Tools Informatica Power Center 8.x, 9.x, SSIS 2008, Tableau 10.2 and 2020, Spotfire, Toad 8.6.1, JIRA, TIVOLI, Dimensions, Edit Plus, MS Visio, VSS, PGADMIN, GE Specify Tools (ODV/OAV/ SHP)
Languages PL/SQL, Unix Shell Scripting
Operating System Windows 95/98/2000/NT, MS-DOS, UNIX Certification Informatica 8x Certified Developer (#278098) Professional experience
Employer: Genpact LLC
Client: CVS Buffalo Grove, IL, USA
IngenioRx-Benefit Repository and Error Handling (Jan18-Aug 2020) CVS has an important line of business which is Pharmacy benefit management. It acquired a big client ANTHEM. CVS needed to migrate all ANTHEM’s existing plans for CVS to process. This project was built from scratch to create a repository and Error handling for Anthem. The data will be received from the client in the form of XML with separate formats based on the LOB. This data will be stored in the staging tables and then will be validated at 2 levels where one will be data validation including field length, valid values, and mandatory fields. The second level of validation will be for business rules. This client data will then be transformed into a CRD Excel file. Later the generated CRD file will be attached to a Salesforce case and submitted to the benefit builder for plan build.
• Worked with the business users for Requirements gathering and created requirement documents.
• Created BRD and data mapping documents to outline data flow from sources to targets.
• Created and presented current and future data process model for business users using VISIO
• Created user stories, epics, issues, and releases in JIRA.
• Worked with the Development and other support team to build the ETL solution based on the requirement document
• Developed Informatica maps, sessions, and workflows for 2-level validations of data once XML is loaded in the stage table.
• Worked with the QA team to test workflows, sessions, mappings, source, and target objects by checking the dependency of each object.
• Performed System Testing of APIs using SoapUI.
• Conducted data analysis and visualizations to help clients make informed business decisions. Excellent exposure to Microsoft Excel for data analysis. Page 3 of 5
• Designed, developed, and maintained functional ad-hoc reports on business requirements using Tableau Desktop.
• Used Tivoli and Dimensions as supporting tools.
• Performed QA with the testing team and UAT with business users
• Helped QA team to create and verify test documents
• Supported Prod deployment and postproduction support Role: Sr. System Analyst
Employer: Genpact LLC
Client: CVS Buffalo Grove, Illinois, USA
PBM Batch Job Monitoring and Dashboards (Jul17- Dec17) The project is to design the process that builds controls to gather and transfer data to a central location that will help monitor all the batch jobs and file transfers on the PBM application systems. Also, data reporting through Tableau is part of the initiative.
• Worked in the discovery phase and created requirements documents.
• Worked with different teams to collect data using various sources.
• Designed the ETL solution to combine the data collected for various sources and loaded in central SQL Server for reporting
• Implemented Data Quality logics using Informatica ETL.
• Designed, developed, and maintained Tableau functional reports on business requirements.
• Utilized Tableau server to publish and share the reports with the business users
• Used Tivoli and Dimensions as supporting tools.
• Worked in a Scrum team.
Role: System Data Analyst
Employer: Genpact LLC
Client: GE Power & Water, Houston, Texas, USA
Aero Analytics (Dec 2014 – Jun17)
Worked with Data Scientists of GE Power and Water to develop Detection, Diagnostic, and Predictive models for Prognostic health management that led to $32 million worth of revenue saves last year; Algorithms involved techniques like Multivariate Gaussian, Hoteling T-square, Regression, and Rule-based.
• Worked with Performance Data Engineers to collect, analyze, and validate data from multiple sources to upgrade models for Lifting, Performance, and Reliability of gas. Used Informatica/SSIS/Proficy/PG Admin/Organization QA Process and metrics and GE internal tools for this.
• Developed volume and priority-based scenarios to test the model leading to an effort reduction of 2 hours to a few minutes
• Worked extensively with other teams for testing including unit, integration, and performance testing, Executed checklist and organization metrics in QA.
• Created QA reports and a dashboard for each QA run for status updates for all the stakeholders.
• Used Tableau and Spotfire to visualize the model outcomes to the end client.
• Developed and maintained documentation for all Tableau solutions. Role: Data Analyst
Employer: Birlasoft INC
Client: GE Energy Management, Atlanta, GA, USA
EM SA Integrations (Jul13 – Oct13)
EM SA is Sourcing Analytics integrations for Energy Management. Currently, it is integrated with BTP DWH and getting data from Flat Files to integrate the information and generate MOR, Initiate, Page 4 of 5
and other Reports. The scope of this project is to integrate EM SA into several other systems to get the required data to meet Report requirements for upcoming quarters. These integrations can be directly pulled from other systems or through flat files generated from those systems made manually available. Unit and integration testing includes creating and executing unit tests, integration tests, and performance tests. Also include a Dashboard presentation for Senior Management through Tableau.
Role: Onsite ETL Lead
Employer: Birlasoft Ltd India
Client: GE Aviation, Cincinnati, OH, USA
EED Operations Metrics (Apr12 – Nov12)
The EED Ops Metrics portal is a tool used by many to understand the status of projects across EED
(Energy Engineering Division). EED portal has many metrics developed in the web portal or Cognos report studio for the monthly VP review. The major program consists of bringing additional business into the metrics portal, integration with additional data sources, and ensuring smooth data flow from the PLM tool via TERADATA.
Role: Team Lead/System Analyst
Employer: Birlasoft Ltd India
Client: GE Energy, Cincinnati, OH, USA
POLARIS BA Support (Jan12 – Mar11)
This project belongs to the Fundamental project for Polaris of GE Aviation. This project is working to deliver OASIS (SAP) data into the Aviation Data Warehouse in Phase 1. Additional shops will follow in Phases 2 and 3. Tasks will include requirements definition, analysis, and project management. Assist with ongoing support of SLC (Sales and Cost) DW and MSOR application. It also includes Informatica Upgrade (to version 9.1) for SLC DW and MSOR applications and translates requirements to the new ADW solution.
Role: Team Lead/System Analyst
Employer: Birlasoft Ltd India
Client: GE Energy, Cincinnati, OH, USA
EFCM (Sep11 – Dec11)
EFCM is a global billing system for all Power Generation and provides a centralized financial solution with contract management tools with a global visibility of the financial project situation in each of the business units.
Role: System Analyst
Employer: Birlasoft Ltd India
Client: GE Energy, Cincinnati, OH, USA
Payment Term Reconciliation
Environment: PL/SQL, ETL Tools (Power Center 8.1.1 of Informatica), UNIX, JAVA Role: Senior Developer
Employer: Birlasoft Ltd India
Client: GE Energy, Cincinnati, OH, USA
ILS Informatica
Environment: PL/SQL, ETL Tools (Power Center 8.1.1 of Informatica), Service Now, UNIX Role: Senior Developer
Employer: Birlasoft Ltd India
Client: GE Infra, USA
AVIATION JAVA PROJECT (TCD Re-Architecture)
Environment: PL/SQL, ETL Tools (Power Center 8.1.1 of Informatica), Service Now, JAVA, UNIX Page 5 of 5
Role: Senior Developer
Employer: Birlasoft Ltd India
Client: Xerox Capital Services, USA
XCS Cash Data warehouse & Scorecard
Environment: PL/SQL, Informatica Power Center 8.1.1, Service Now Role: Developer
Employer: Birlasoft Ltd India
Client: GE Commercial Finance, Danbury, USA
BO PA MapInfo Support
Role: Developer
Environment: PowerAnalyzer5.0.1, MapInfo 9.0, Business Objects, Service Now, Oracle 9i, PL/SQL, Linux
Employer: Bharti TeleSoft Ltd, India
Client: Guam Cell Communications & IT&E, Guam, USA Differential Billing System
Role: Developer
Environment: Oracle 9i, PL/SQL, Pro *C/C++, Linux (7.2), SQL Loader, Designer 2000, Rational Rose 98, Jakarta – Tom Cat 4.0.3, Servlets, Java, Swing.
Contact this candidate