BHAVANA

Senior Data Analyst

acc3bn@r.postjobfree.com

732-***-****

PROFESSIONAL SUMMARY

• Over 8 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

Strong background in support documentation

•

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

• Application testing experience with working knowledge of automated testing tools like Mercury Quick Test

Professional and Load Runner

PROFESSIONAL EXPERIENCE

1

BLUE CROSS BLUE SHIELD OF WESTERN NEW YORK (HEALTHNOW), Buffalo, NY March 2013 Present

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

2

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

•

3

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, 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

•

4

• 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, 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

•

5

• 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, 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

•

6

• 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

WELLS FARGO, CA Feb'06

Mar'07

Business Analyst

Worked as a Business Analyst involved in implementing a centralized web based SOA application infrastructure to

save time, provide online data access, and reengineer the credit card process in order to expand the company's

business. It was a 24 hour online access to credit card holders, where customers can login and view their account

information (Current and Previous Account history), can make online payments, change their contact information

(such as Contact Address, Phone Number, Email Address if available), and can contact customer service

representatives for questions.

Responsibilities:

• Interacted as a liaison between users and the different teams (including Deposit/Withdrawal, Customer

Service, and Loan) involved in the application development for better understanding of the business and IT

processes

• Responsible for analysis and functional specifications of “As Is” and “To Be” business model to conduct GAP

analysis in comparison to the proposed system to enhance the functionality of the application

• Gathered business requirements through interviews, surveys and observing from account managers and

conducted controlled brain storming sessions with project focus groups and documented them in the business

requirement document

• Planned and defined system requirements to Use Cases, Use Case scenarios and Use Case narratives using

the UML methodologies. Created Use Case diagrams, activity diagrams, and sequence diagrams using MS

Visio

• Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan

closed, borrowers info, mortgage payments etc, and their mapping for standard analysis

• Identified different types of users (brokers, borrowers and loan officers) and analyze several important

human engineering factors and guidelines and incorporated them into a design of a user interface using MS

Visio

• Managed and coordinated the QA team to create the test approach and determine test needs, test

environment, test data, resources and limitations

Provided 24 x 7 problem management support to the development team

•

Created various Data Mapping Repository documents as part of Metadata services (EMR)

•

7

• Provided inputs to development team in performing extraction, transformation and load for data marts and

data warehouses

• Provided support in developing and maintaining ETL processes that extracted data from multiple SOR's

residing on various technology platforms then transported the data to various delivery points such as data marts

or data warehouses

• Performed manual and automated tests related to the graphical user interface, functionality testing, security

testing, and testing related to data sources

• Helped to develop test strategies, test cases, test plans, defect reports, traceability matrices and test

environments and managed the testing process, bug reporting and analysis of test results

Tracked the progress of system testing, and provided a daily status report to the Test Manager

•

Used Test Director to house all test documentation and report/track all issues and defects

•

Environment: Rational Suite (Rational Rose, Requisite Pro), Rational Unified Process (RUP), Windows 2000,

UML, MS Project, MS Office Suite, MS Visio, Win Runner, Test Director

ALLSTATE INSURANCE, MO Feb'04

Dec'05

Business Analyst

Allstate is the nation's largest publicly held personal lines insurer. Allstate Financial Group includes the businesses

that provide life insurance, annuity, retirement, banking and investment products through distribution channels. The

aim of the project was to enhance the SOA (Service Oriented Architecture) web based policy management system,

which integrated Allstate’s five policy management systems (life insurance, annuity, retirement, banking and

investment products) and extend the functionality to provide anywhere, anytime information access to Allstate’s

countrywide network of producers.

Responsibilities:

• Analyzed consumer surveys and gave technical inputs in business meetings

• Involved in meeting with Business process owners, SMEs and marketing team for requirements gathering in

definition stage

Facilitated the customer in defining the high level functional requirements and needs

•

• Gathered the requirements, developed process model and detailed business policies, and modified the

business requirement documents

Utilized RUP to create use cases, activity, class diagrams and workflow process diagrams

•

Prepared the prototype and mockup screens

•

Involved in the data movement between systems and validated the business requirements

•

Wrote test cases based on test strategies

•

Involved in functionality testing during the various phases of the development

•

Verified the correlation between the UML diagrams and developed detailed diagrams

•

Validated the system End to End Testing to meet the approved functional requirements

•

• Blueprinted technical and operational training manuals and led PowerPoint/Visio presentations for the

development of financial and technical applications for the departmental user base and for audit purpose

Responsible for providing fiscal and economic solutions through financial modeling and cost basis analysis

•

• Lead an entire QA Team comprising of 5 senior QA testers. Managed their activities through daily and

weekly status reports

Hands on QA Analyst, responsible for coordinating and performing functional testing

•

8

Conducted the final Customer Acceptance Testing (UAT)

•

• Increased process efficiencies and reduced development cycle time across department by spearheading the

implementation of the full lifecycle software development methodology

Participated in weekly meeting and discussed modification request with management team

•

Interacted with the developers to report and track bugs using Rational Clear Quest

•

Environment: Windows 2000, Microsoft Project 2000, Java, HTML, Oracle, MS Visio, Rational Unified Process

and Rational Clear Quest

EDUCATIONAL QUALIFICATIONS

M.S. In Computer Science

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

9

Contact this candidate