Resume

Sign in

Data Analyst

Location:
New York City, New York, United States
Posted:
June 05, 2019

Contact this candidate

Resume:

BHAVANA SINGH

Phone: 732-***-****

Email:ac9ji1@r.postjobfree.com

PROFESSIONAL SUMMARY:

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

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

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

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

Experienced with Microsoft SharePoint 2010, Business Intelligence Analytics SQL Server Integration services SSIS, SQL Server Analysis services, Performance Point Services, Reporting Tools, Salesforce.com, Siebel CRM and other business applications

Excellent communicator focused on customer service

Developed Import Sets to import data from different Sources. Developed Transform maps to map values between Import Set and Service Now tables.

Ability to understand current business processes and implement efficient business processes

Worked on creation of Service Now Templates, Schedule Driven Requests as per User requirements.

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

Used tools like, SharePoint 2010, Service Now.

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

Analysis and review of software and business requirement documents

Proficient in the use of various requirements management tool like Rational Requisite Pro, Application lifecycle management, JIRA Agile.

Proficient with SharePoint 2007 and SQL Server 2005

In-depth knowledge of SharePoint and its features and functionality

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

Developed Use Cases, Process Diagrams using VISIO 2013 and worked with team in developing Business Rules.

Work Experience in People Soft Tool

Captured Use Cases, Activity, Sequence diagrams and detailed process flows using MS Visio 2013, MS Office and Rational Rose

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

Worked on SAP Customer Activity Repository(CAR ) to check the updated transaction form APTOS (POS system) to SAP (CAR)

Worked on SAP (S4) to track the Inventory across all the Retail full price stores

(From Fiori app to SAP (S4)

CERTIFICATIONS:

Certified Scrum Master (CSM)

EDUCATIONAL QUALIFICATIONS

M.S. In Computer Science.

PROFESSIONAL EXPERIENCE:

New York Department of Building New York, NY Dec2017 – Till Now

Sr. Business Analyst

Working as Sr. Business Analyst with Department of Buildings New York on their Integration Project form BIS (Building information system to DOB NOW)

I have been working with Department of buildings for their biggest integration project from their Legacy system to DOB NOW

Responsibilities:

Create Business Requirement and Functional Requirement for data integration from BIS to DOB Now

Creating Epics in JIRA for each Phase and different Releases

Creating MockUps and Dashboads for reporting and Working with the development team to design

Creating project plan for each release with detail form aspects (Communications, Planning,Testing,Reporting,Support)

Drafting Service Notice and making sure it goes out 60 days before the change is implemented

Formulate the cutover plan (Backlog of paper filings, Black out period, Data Migration,E-Filing Impact)

Working with Stakeholders to understand their requirements and adding them in requirements

Work with Testing team to create test plans

Experienced in advanced GIS techniques to determine the intelligence and geospatial information contained in imagery, including evaluation of tools, and creation of customized methodologies and products to address a variety of geospatial intelligence challenges.

Involved in designing a training program to promote and bring awareness about the ESRI Suite of Programs and Enterprise GIS Applications

Creating Initial Draft of training material with step by step guide for industrial Training and internal Training

Identifying the SME’s and other team related or will be impacted from the upcoming future release

Prepare for First,Second and if required third Q/A Review

Finalize the Training Schedule

Create an online go to meeting link for the ones who cannot be in training room

Creating/Setting up a CRM users with group/dashboard assignments

Creating and setting up CRM access (Read only ) for CPE/ACPE/PF STAFF

Created wireframe diagrams and business process models using MS Visio 2013

Maintaining the Business Document for future release

Creating Data Dictionary with the Attributes details and definitions.

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

create mock ups as per requirements for share point implementation

use to update epics in JIRA as part of share point implementation

Create task/tickets under each mockup in JIRA.

Used management tools such as SharePoint 2007 for understanding client business

Worked as business analyst to create and modify Service Catalogs and Request Workflow Design and Configuration.

Send “Release Day One” Communication to each release group

Worked on scale business intelligence and data warehousing systems

Worked on Agile Development methodologies

Tory Burch, New York, NY Dec 2016 – Dec 2017

Sr. Business Analyst

Working as Sr. Business Analyst with Tory Burch on their Tulip Project (Reporting Project)

Tulip is a mobile application for iPad to support store associate. The store associate can use Tulip to access product, inventory and customer information to manage its own customers and provide better customer service. For North –America and Canada, the data created in Tulip will also be created in Aptos with new customer number and that new customer number will be send back to Tulip.

Responsibilities:

Create Business Requirement and Functional Requirement for data integration from DW Data base to Aptos and Micro Strategy

Creating Epics in JIRA for each Phase of Tulip

Creating Mockups and Dashboards for reporting and Working with the development team to design

Working with Stakeholders to understand their requirements and adding them in requirements

Work with Testing team to create test plans

Provide Training to the Store Associates, To understand the Report and its calculations

Created wireframe diagrams and business process models using MS Visio 2013

Maintaining the Business Document with new Stores and new for Tory Sports

Creating Data Dictionary with the Attributes details and definitions.

Maintain the integrity of the service-now tool across production and non-production environments.

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

create mock ups as per requirements for share point implementation

use to update epics in JIRA as part of share point implementation

create task/tickets under each mockup in JIRA.

Used management tools such as SharePoint 2007 for understanding client business

Worked as business analyst to create and modify Service Catalogs and Request Workflow Design and Configuration.

Prepare Business Requirement Documents to present to the respective functional teams to assure successful implementation of projects Main point of contact for the process and design for the Auto Integrate (AI) implementation

Worked on scale business intelligence and data warehousing systems

Worked on Agile Development methodologies

Worked SAP (CAR ) to check the updated transaction form APTOS (POS system) to SAP (CAR)

Worked on SAP Customer Activity Repository(CAR ) to check the updated transaction form APTOS (POS system) to SAP (CAR)

Worked on SAP (S4) to track the Inventory across all the Retail full price stores

(From Fiori app to SAP (S4)

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

Sr. Business/Data Analyst April 2016 -Dec 2016

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 JDASystems 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 analysisif 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.

Extensively Worked with Service Catalogs and Request Workflow Design and Configuration.

Acted as a liaison between the business and development team in gathering requirements and supporting the MDM team.

Created wireframe diagrams and business process models using MS Visio 2013

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.

Maintain the integrity of the service-now tool across production and non-production environments.

Manage outside vendor issues regarding PointofSale parts ordering and connectivity issues

Taking care of SharePoint 2007 site (adding/removing users, add/remove/edit documents, and assign retention policies, giving site permissions responsible to take care of expiring items)

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

create mock ups as per requirements for share point implementation

use to update epics in JIRA as part of share point implementation

create task/tickets under each mockup in JIRA.

Used management tools such as SharePoint 2007 for understanding client business

Worked as business analyst to create and modify Service Catalogs and Request Workflow Design and Configuration.

Prepare Business Requirement Documents to present to the respective functional teams to assure successful implementation of projects Main point of contact for the process and design for the Auto Integrate (AI) implementation

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

Support existing SharePoint implementation across the enterprise and work on future site development projects

Build and implement solutions in the SharePoint environment using out-of-the-box functionality, custom developed tools, and 3rd party add-ons

Support the review, clean-up (moving/copying sites), management and configuration of SharePoint accounts and sites

Experience on JDA, XPC systems

Assisted in testing of newly created Pointof Sale System

Experience in data analysis, strong SQL, Excel and Access

Worked on JIRA for creating, updating and managing story board and product backlog

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 Analyst March 2015- April 2016

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

Responsibilities:

Worked as the EHR/ EMR system subject matter expert for internal and external resources, which involved learning and keeping apprised of the user interface, systems administration functions, as well as the operational impacts of changes

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

Scanning all patient’s medical records into EMR system.

Strong MS Office skills including Advanced Excel, Pivot Tables and VLOOKUP’s, PowerPoint, Access

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

Design, deploy and monitor indirect procurement metrics

Technical Applications / Taught & Used: (EHR / EMR- Electronic Health Record / Electronic Medical Record)

Analysis and working on spend data and piece data

Software Application & Equipment _Practice Fusion (EHR / EMR application) taught & retrieved information in EHR

Works with peer organizations as a subject matter expert on the existing SharePoint functionality

Promote user adoption through user and site manager training, consultation, and support of existing SharePoint functionality

Demonstrate initiative by proactively reviewing/assessing SharePoint COE desk procedures and recommending improvements

Work with end users to facilitate the migration of new and existing business processes to a SharePoint environment

Participated with Optimization team - Suggested (found) ways to increase and maximize the use of the EMR

Dynamics 365 CRM administrator – maintained the permission of CRM for NMC.

Assisted clinicians with charting _ Entered live data into EHR/ created labs, Diagnosis Imaging, familiar w/ ICD9 & ICD10 codes, linked CPT codes to ICD10 codes.

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

Implemented four Microsoft Dynamics CRM solutions for different departments of NY State.

Worked on JIRA for Bug Reporting.

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

Independently and efficiently resolved issues relating to store processes and procedures, Point of Sale inquiries, Windows applications, password resets, etc.

Configuration of MS Dynamics CRM with Microsoft Outlook 2013.

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.

Functional Testing of MS Dynamics CRM;

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 upgrade of Dynamics CRM from 2011 to 2015. Worked on post upgrade tasks

Worked on elicit detailed data requirements from other IT Teams.

Worked on integrating Dynamics CRM with Dynamics GP using scribe online

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.

Worked on customizing and extending Dynamics CRM.

Responsible for gathering CRM information and developing a comprehensive report once a month for management.

Provided the first line of support for technical and functional issues related to CRM systems.

Assisted in developing several database procedures that made CRM research significantly easier.

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

Manage weekly sprints in agile environment using JIRA.

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

Sr. Data Analyst March 2013 –July 2014

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

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 2012 - Mar 2013

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 2007

Deutsche Bank, New York, NY June 2011 – March 2012

Charles River to Aladdin System migration

Worked with the European team and the US team to successfully implement Aladdin system.

Established business analysis methodology using agile dynamic systems development process.

Processed Agile, RUP, SDLC/Waterfall.

Interacted with Portfolio Managers and Traders to resolve trading issues and/or violations.

Lead conference calls with the global team (Team= Liquidity Fund Mgrs., ARA Fund Mgrs., Fixed Income and Equity Managers) and various other levels of management to discuss progress and to ensure that daily issues were addressed.

Validated BlackRock portfolio holdings and positions against Charles River equivalents.

Worked with Blackrock on the development of a platform to support order creation, trade execution and portfolio management.

Worked closely with the Vice-President of Guideline Monitoring Team to ensure Fixed Income, Equity, Alternative Investment violations appearing on the daily violation reports have been investigated and correctly identified as valid (reportable/non-reportable) or invalid.

Followed the Agile methodology for elicitation and representation of requirements based on interaction with the business process owner, SME’s and the development team. Participated in daily scrum

Ran test (buy-sell) trades within and in excess of compliance rules to ensure response viability. Did portfolio rebalance (buying-selling securities) to ensure portfolio is in Compliance and the % NAV is positive.

Ensure that all portfolio rules falling out of Compliance were investigated and corrected by external vendor with regards to coding and were followed through on for final resolution

Monitored and lifted flags for real time trades wrongly deemed out of Compliance.

Worked to develop relevant test scenarios, system regression Test Plans and scripts and ensure the test results correspond to the business expectations

Worked with Quality Assurance to test Compliance rules associated with transitioning from Charles River Trading Platform to Aladdin Investments Software

Investigated and reported validity of any discrepancies resulting from side by side testing.

Worked with the PMs to review Client Investment Guidelines and reconcile against Charles River rule descriptions.

Rewrote Compliance rule descriptions for BlackRock programming based on Client Investment Guidelines.

Worked with the DQM (Data Quality Maintenance) and Benchmark team to resolve data and benchmark issues.

Worked closely with the Vice-President of AWM on PM final sign-offs and related testing of the new and revised rules.

Run test trades within and in excess of compliance rules to ensure response viability.

Created testing procedures and directed the team to achieve desired goals by implementing those procedures.

Worked on Regulatory rules (40 Act, 2a7 rules and Dodd-Frank) to resolve issues related to the assigned funds (Liquidity, ARA, etc.)

BANK OF AMERICA, NC Jan2010-June2011

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 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 2013, Windows XP, AFS, MS Excel, SharePoint 2007, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook

CME Group, Houston, TX Jun 2008–Jan 2010

Project Manager/Business System Analyst

SPAN System

The project dealt with determining performance bond/initial risk margin utilizing the CME Group’s proprietary margin system called SPAN (Standard Portfolio Analysis of Risk). The SPAN system, a global industry standard, monitors market activity, including large and concentrated positions and manages risk through multi-lateral netting by customer and house account per firm while assuring the segregation of customer assets from firm assets.

Interviewed SMEs and recorded requirements. Coordinated and prioritized outstanding risks and enhancement requests based on business requirements to ensure timely delivery.

Designed and developed business requirement collection approach based on the project scope, SDLC Methodology and the client environment.

Analyzed and documented system requirements and supplementary requirements like complying with industry standards such as ISDA CFTC (Commodity Futures Trading Commission) and NFA (National Futures Association).

Products included options, swaptions (caps, floors, digital and Bermudan options) and exotic products.

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 Requisite Pro 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



Contact this candidate