Data Project
Resume:
BHAVANA
Senior Data Analyst
******@*************.***
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