BHAVANA SINGH

Sr. Business Analyst/Business Data Analyst

acz0lp@r.postjobfree.com

732-***-****

acz0lp@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 9 years of IT experience in the field of Business/Data Analysis, Process Improvement and Data Integration

Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, and Metadata Management Services

Strong understanding of Data Modeling concepts, Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Models

Ability to collaborate with peers, in both business and technical areas, to deliver optimal business process solutions in line with corporate priorities

Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design, and Testing

Experience in developing accurate business process requirements for Insurance, Banks, and State Government projects

Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL

Good Data Warehousing concepts including Metadata and Data Marts

Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams

Extensive experience in project management best practices, processes, & methodologies, including Rational Unified Process (RUP) and SDLC

Excellent communicator focused on customer service

Ability to understand current business processes and implement efficient business processes

Expertise in defining scope of projects based on business requirements, including documentation of constraints, assumptions, business impacts & project risks.

Relationship Management Process Design and Improvement Database Design

Strong background in support documentation

Involved in the process design documentation of the Data Warehouse Dimensional Upgrades

Analysis and review of software and business requirement documents

Experience in conducting requirement gathering sessions, feasibility studies, and organizing the software requirements in a structured manner

Experience in gathering business and technical requirements that would best suit the needs of the technical architectural development process

Team lead skills encompassing user interviews, coordination with Tech Lead, DBAs, Developers, and QA/QC Analysts during the design phase

Skilled at interviewing Subject Matter Experts by asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people

Work Experience in People soft Tool

Application testing experience with working knowledge of automated testing tools like Mercury Quick Test Professional and Load Runner

PROFESSIONAL EXPERIENCE

PVH Corporation (CALVIN KLEIN, TOMMY HILFIGER, MICHEAL KORS, PHILIPS VAN HEUSEN), New York, NY

Sr. Business/Data Analyst April 2016-Till Date

Work as Sr. Business /Data Analyst for Multi-Brands on Back end as well as front end. Support the data integration of all the brands from legacy PLM Systems into JDA Systems to XPC system.

Responsibilities:

Create Business Requirement and Functional Requirement for data integration from JDA System to XPC system for Multi -Brands

Generate Daily report for Style Attribute for Multi- Brand and Run the analysis if all the required fields are populated if not Analysis it why it’s missing, and if it’s Missing in Both XPC and JDA or its data entry error.

Create Weekly Data Quality Reports for Multi Brands which includes Data Extraction, Business Rules Generation, Compiling and Building Report and Trouble Shooting if any Issues.

Maintaining the Business Document with new season and new Style Attributes and it comes.

Creating Data Dictionary with the Attributes details and definitions.

Working on price files and creation mapping documents

Worked on document test cases, perform testing, and document test findings

Database level Update for any change to Domain values used in SQL Rules, Update the tables

Working on New –Attributes addition and creation mapping documents

Understand data, data relationships, and identity data gaps across multiple Brands.

Worked on scale business intelligence and data warehousing systems

Worked on Agile Development methodologies

Experience on JDA,XPC systems

Experience in data analysis, strong SQL, Excel and Access

Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

NYU LANGONE (NYU SCHOOL OF MEDICINE AND NYU HOSPITAL), New York City, New York

Sr. Business/Data Analyst March 2015- April 2016

Working as Sr. Business/Data Analyst on collaborating with senior-level functional leads to identify and execute opportunities for cost reductions and avoidance for indirect goods and services

Responsibilities:

Work with functional leads and Finance to identify opportunities for cost reductions and avoidance using PeopleSoft Applications

Create and deploy targeted category strategies supported by robust analysis and research

Design, deploy and monitor indirect procurement metrics

Analysis and working on spend data and piece data

Working on big Data, Data warehouse, reports and historical data.

Creating data bases, reporting and contract documentation

Working on price files and creation mapping documents

Relationship Management Process Design and Improvement Database Design.

Involved in the process design documentation of the Data Warehouse Dimensional Upgrades

Design, deploy and monitor indirect procurement metrics

Experience in data analysis, strong SQL, Excel and Access

Create and deploy targeted category strategies supported by robust analysis and research

Worked on construct meaningful and persuasive business cases and productively influence multiple functions and senior management.

STRYKER (HEALTH CARE), Portage, MI August 2014-Feb 2015

Sr. Business Analyst/Business Data Analyst

Worked as Sr. Business Data Analyst on sourcing Orders and Sales data in a staging area for 16 different Selling Divisions, from 15+ disparate global source systems, originating from 5 different ERP Systems (Oracle 11i, Oracle R12, MfgPro, JD Edwards, and PRMS)

Responsibilities:

Work with a diverse IT community to identify project data requirements and detailed data requirements need to source data for the project.

Secure source data from 15+ disparate sources, identifying and communicating data gaps or inconsistencies.

Testing to verify data accuracy in staging area from sources and in delivered extracts to downstream application team.

Ensure clear communication between all involved IT Teams.

Strong communication and relationship skills for working with global teams remotely.

Strong business intelligence and data warehousing understanding.

Worked on elicit detailed data requirements from other IT Teams.

Involved in the process design documentation of the Data Warehouse Dimensional Upgrades

Worked on translate project data requirements into detailed extract specifications in order to source the data needed to provide the requested data.

Understand data, data relationships, and identity data gaps across multiple sources.

Worked on document test cases, perform testing, and document test findings.

Maintain clear communication channels with IT and business stakeholders.

Understand and navigate complex interpersonal and political issues.

Experience navigating complex interpersonal and business relationships

Experience working remotely with multiple global teams

Worked on scale business intelligence and data warehousing systems

Worked on Agile Development methodologies

Worked on Order and Sales data

Experience on Oracle EBS, MfgPro, JDE, and PRM ERP systems

BLUE CROSS BLUE SHIELD OF WESTERN NEW YORK (HEALTHNOW), Buffalo, NY March 2013 – July 2014

Sr. Data Analyst

Worked as a Sr. Data Analyst on “Out of Pocket Max” Project (Obama Care) for Health Now’s members

Responsibilities:

Identified sources and performed data profiling on the identified sources

Performed Source to Target data analysis and data mapping

Participated in meetings with Technical and Business SME's and provided solutions in various aspects

Participated in Data Validation discussions with Data Architects

Performed smoke testing on developer release code

Assisted Developers with development effort and integration needs

Assisted QA with business validation, knowledge transfer, and QA result validation. Wrote (inbound and outbound) mapping for all the vendors

Performed validation process for all the inbound and outbound mapping documents using sample claim file received from all vendors

Wrote business rules in source to target data mapping document to make it easy and clear for developers and testers

Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues

Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding

UNITED HEALTHCARE, NJ Mar'12 - Mar ‘13

Sr. Business/Data Analyst

Worked as a Sr. Data Analyst and created a sales and service data mart required for Business Intelligence and reporting purposes. The existing system, which allows the agents to enter, modify new sales/service data, is used as one of the company’s major source systems.

Responsibilities:

Performed data profiling in the source systems that are required for Data Marts

Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding

Worked with internal architects and assisted in the development of current and target state enterprise data architectures

Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines

Performed data analysis and data profiling using complex SQL on various sources systems

Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues

Involved in defining the source to target data mappings, business rules, and data definitions

Responsible for defining the key identifiers for each mapping/interface

Responsible for defining the functional requirement documents for each source to target interface

Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testing team

Reverse engineered all the Source Databases using Erwin

Documented data quality and traceability documents for each source interface

Involved in data warehouse design

Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding

Worked with internal architects in the development of current and target state data architectures

Used data analysis techniques to validate business rules and identified low quality missing data in the existing Amgen enterprise data warehouse (EDW)

Environment: Oracle 10g/11g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, Erwin, Crystal Reports, PowerPoint 2007, SharePoint

STATE of ARIZONA, Phoenix, AZ Jul'11-Feb'12

Sr. Data Analyst

The "customers" of the Information Technology Department are the other Pima County departments, and the services cover the spectrum of information technologies. The services include programming, operating, and maintaining County computer systems. I worked as a Sr. Data Analyst for Information Technology Department in generating about 200 reports to the county's other departments (Project Management, Finance and Budgeting). The Data Warehouse was developed from the operational source systems after consolidating into a Decision Support System for analyzing data. The Data Warehouse was scheduled to get data from different databases of operational system, which then is loaded into staging area using Informatica. This was a huge Data Warehousing Implementation involving ETL Informatica, Oracle 11g, MS SQL Server, and Business Objects.

Responsibilities:

Gathered requirements, analyzed, and wrote the design documents

Provided End-user Training and documentation for customer reporting services

Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments of Pima County

Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department

Performed data analysis and data profiling using complex SQL on various sources systems

Wrote SQL queries on the databases, wrote test validation scripts and performed system testing

Wrote SQL scripts to test the mappings and developed traceability matrix of business requirements mapped to test scripts to ensure any change control in requirements leads to test case update

Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues

Worked with the developers during coding and while doing the remediation of the software

Worked with the users to do the User Acceptance Testing (UAT)

Documented all data mapping and transformation processes in the functional design documents based on the business requirements

Created technical specifications documents based on the functional design document for the ETL coding to build the data mart

Created data trace map and data quality mapping documents.

Performed data profiling and data quality

Designed and implemented report layouts according to reporting standards of the department.

Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report

Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic

Adhered to the reporting standards laid down by Pima County ITD

Took initiative to drive the report development process

Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF

Responsible for making the report available for scheduling or viewing on demand

Worked with Technical Experts to Improve Report Performance and performed System testing

Environment: Oracle 11g, SQL Server 2008, Windows XP, Microsoft Project 2000, Informatica, HTML, Business Objects, Erwin, MS Excel, SharePoint 2010, PowerPoint, MS Visio and MS Outlook

BANK OF AMERICA, Columbus OH Jan'10-June'11

Sr. Data Analyst

As a Sr. Data Analyst, I was involved in documenting the business process by identifying data required in determining the Asset Based Lending loans that are eligible for financing and securitization from multiple sources and the method of obtaining and storing data.

Responsibilities:

Worked according to the software development life cycle

Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees)

Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder

Wrote the test cases and technical requirements and got them electronically signed off.

Created new reports based on requirements

Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders

Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements

Interacted with teams in AFS, ACBS and Infolease to extract the information for the reports

Involved in defining the source to target data mappings, business rules, business and data definitions

Created Report-Models for ad-hoc reporting and analysis

Extensively designed data mapping and filtering, consolidation, cleansing, integration, ETL, and customization of data mart

Provided 24 x 7 problem management support to the development team

Documented various Data Quality mapping document

Performed small enhancements (data cleansing/data quality)

Performed data analysis on the existing data warehouse

Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation

Communicated with the third party vendor to do the programming

Upgraded the present application by adding new functionalities and adding new reports

Wrote regression test cases, did smoke testing with users

Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing

Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook

VERITA, Arizona AZ Jul'08-Dec'09

Business/Data Analyst

Worked as a Business/Data Analyst at the State of Arizona Department of Education in a unit that is responsible for carrying out the rules and statues for the licensure of certified school professionals. The product of this unit is the legal document that enables the professional educator to work in Arizona.

Responsibilities:

Analyzed the business and wrote Business Rules Document

Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team

Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio

Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements

Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people

Used MS Visio for business flow diagrams and defined the workflows

Performed data analysis for the existing data warehouse and changed the internal schema for performance

Participated in designing and development of the application

Used user stories approach for describing the requirements using the user story template

Wrote technical papers, gathered technical requirements, and compiled them to help the design system

Created Use Case specifications, business flow diagrams, and sequence diagrams to facilitate the developers and other stakeholders to understand the business process according to their perspective with possible alternate scenarios

Interacted with the software development team and executive team to liaison the business requirements to ensure that the application under development adheres to the business requirement

Performed data mapping from source to target

Extensively used SQL for accessing and manipulating database systems

Participated in design walk-throughs with SMEs to baseline the business architecture

Facilitated in the overall management of the project including mitigation, status reports, client presentations, defining milestones, deliverables and establishing critical success factors

Was jointly responsible for monitoring the progress of the development and QA team

Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs

Created Use Case diagrams using UML to define the functional requirements of the application.

Performed Acceptance Testing (UAT), unit testing and documenting

Maintained a close and strong working relationship with teammates and management staff to achieve expected results for the project team

Organized meetings with the development teams to elicit use cases and document them

Wrote manual Test Cases for checking the application

Used Agile methodology for repeated testing

Involved in manual testing by checking of various validations

Created, maintained, and executed manual test scripts

Developed functional specifications and testing requirements using Test Director to conform to user needs

Environment: MS Office 2007, MS Visio 2003, Share Point, PowerPoint, MS Project, Windows XP, UML, SQL, Test Director, MS Outlook

PNC BANK, Philadelphia PA May'07-Jun'08

Business/Data Analyst

Worked as a Business/Data Analyst for the “E-commerce” platform, an online banking application that enables customers to access their checking, savings, and credit card accounts through the internet. This project involved developing the application using Servlets and JSP's under the Struts framework.

Responsibilities:

Involved in gathering business requirements from end users and management

Analyzed requirements and created Use Cases, Use Case diagrams, sequence diagrams using Rose

Used Rational RequisitePro for managing and configuring the requirement analysis effort

Extracted the business requirements for E-commerce from various sessions with business leads and maintained them using Requisite Pro, tracing them all the way to the system artifacts

Planned, coordinated, and monitored project levels of performance and activities to ensure project completion on-time

Prioritized requirements to be developed according to Agile methodology

Performed extensive requirement analysis and gap analysis

Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people

Used sessions, workforce for running and loading the data from source to target data warehouse

Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents

Extensively used SQL for accessing and manipulating database systems

Participated in design walk-through with SME's to baseline the business architecture

Worked closely with QA and developers to clarify/understand functionality, resolve issues and provide feedback to nail down the bugs

Effectively implemented defect management process using Clear Quest

Maintained a close and strong working relationship with teammates and management staff to achieve expected results for the project

Involved in writing manual test cases and test scripts for checking the application

Assisted the database modelers in preparing the logical and physical data models and ascertained that requirements have been met

Developed functional specifications and testing requirements using Test Director to conform to user needs

Was involved in UAT testing

Prepared user training manuals and successfully conducted user training sessions

Environment: Windows XP, Rational Rose, MS Visio, Rational Requisite Pro, UML, MS Project, Oracle 9i, MS Office, UML, MS Word, SQL, Clear Quest, Test Director, Oracle 11i, Oracle R12, MfgPro, JD Edwards, and PRMS,PeopleSoft

EDUCATIONAL QUALIFICATIONS

M.S. In Computer Science.

Master in Computer Application (M.C.A.)

Contact this candidate