Data Project

Kalpana

Email: ************@*****.*** / Ph #: 408-***-****

PROFESSIONAL SUMMARY:

• 8+ years of experience in Data Analysis, Business Modeling, Requirement Gathering and Analysis,

Software testing and Project Management.

• Experienced in all stages of Software Development Life Cycle (SDLC) with proficiency in Various

Methodologies including Waterfall and Agile (SCRUM).

• Proficient in using Teradata SQL on very large datasets

• Experience in Data Analysis, Data Modeling, Data cleansing, preparation of scenario based data and

clarification of requirements with SME (Subject Matter Expert).

• Extensively worked on Data analysis and reporting the data using advanced Microsoft Excel skills.

Effectively used vlookup, regression, pivot tables, etc to map data to informative reports.

• Experience with data warehousing techniques like Slowly Changing Dimensions, Surrogate key,

Snowflaking etc. Worked with Star Schema, Data Models, E R diagrams and Physical data

Models.

• Worked on Tableau and created adhoc reports and dashboards

• Implemented Clustering using R programming and packages

• Experience on Clickstream data analytics, Healthcare & Finance domains

• Experience with JIRA for logging bugs and enhancements

• Sound Knowledge of Business Intelligence, Data Warehousing, and Business Architecture.

• Excellent facilitation skills in conducting walkthroughs, interviews, brainstorming for Gathering and

Analyzing Requirements. Experienced in conducting Joint Application Development (JAD) sessions

with Business users, Business system analysts, SMEs, software developers, and QA team.

• Adept at transforming business requirements into functional requirements and creating Business

Requirement Document & Functional Requirement Document. Experience in designing UML

diagrams Use Case Diagram, Activity Diagrams & Data Flow Diagrams.

• Good experience in conducting GAP Analysis, SWOT Analysis, Cost Benefit Analysis, ROI analysis,

Risk Analysis, Impact Analysis, Feasibility Analysis and extensive experience with Business Process

Modeling.

• Adept in creating Use cases, Test Cases and GUI (Graphic User Interface) using MS WORD/VISIO.

• Strong domain knowledge in Financial services with solid understanding of Equity & Fixed income

markets

• Extensive experience of creating Revenue models, Financial modeling, P&L analysis, Balance sheet

analysis and cash flow analysis. Solid understanding of Investment Returns, IRR & Net Present

Value calculation and Discounted Cash Flow analysis.

• Strong analytical skills in financial analysis and technical skills in Excel modeling, Excel PowerPoint

• Possess strong analytical, verbal and presentation skills that help in communicating with team members

as well as Project sponsors.

TECHNICAL SKILLS

Databases: Teradata, Oracle, MySQL

Reporting Tools: Tableau, MS Excel, R, Bloomberg

Office Tools: MS Office (MS Excel, MS Word, MS PowerPoint)

Programming: Advanced SQL, Java, R

Operating systems: Windows NT/95/98/2000/XP, DOS, UNIX

Web Technologies: HTML/CSS, Javascript, XML

Company: Ebay, San Jose, CA Nov 2012 Till Date

Title: Data Analyst

Roles & Responsibilities:

• Worked as Subject Matter Expert for Ebay Click stream data. Responsible for translating business

requirement to technical reporting requirement

• Handled Immensely large dataset that loaded around 4 billion (5 TB) records DAILY

• Gathered requirements from business to define scope and prioritize the critical KPIs for business

reporting needs and created BRDs for the same

• Educated and consulted the team on writing highly tuned complex Teradata SQL queries keeping

in mind the size of the underlying tables and architecture of the DW

• Worked with Data Modeling team to come up with the aggregate and denormalized table

structures for some specific business reporting requirement or/and improve performance of reports

• Organized and participated in Dimensional Modeling sessions to create Star Schema for reporting

layer

• Worked with ETL teams to deliver the reporting layer composed of the highly tuned and

aggregated tables designed from the base tables

• Used advanced Microsoft Excel for providing prototype of reports prior to actual Tableau

implementation.

• Created the POC and prototype Tableau reports and dashboards with the key metrics

• Participated and hosted bi weekly scrum planning meetings to prioritize and delegate the tasks to

the reporting and data teams. Collaborated with the scrum team to generate a relative size estimate

for sprint backlogs and assisted in developing burn down charts.

• Worked with the QA team to come up with test scenarios and test cases to validate the aggregate

datasets with the base tables

• Provided post implementation support for production reports and handled ad hoc usage related

questions from business teams by interpreting data into meaningful information

• Used Jira extensively to log bugs, support requests and user stories

• Worked with the Product Managers to enhance the Behavior Insights product with new metrics and

KPIs as per the business requirements

• Worked on R to implement clustering on behavior data.

Company: WellPoint (Healthcare), Richmond, VA May 2011 Oct 2012

Title: Business/Data Analyst

Roles & Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC

Methodology.

• Requirement analysis including data analysis and gap analysis

• Aware of general Healthcare concepts of Subscribers (Members), Claims types (Facility and

Professional) and Revenue types (deductible, co payments,co insurance and premium)

• Column to column mapping between source and Enterprise DataWarehouse data for Healthcare

subject areas like Claims and Member

• Designed and developed project document templates based on SDLC waterfall methodology.

• Developed business requirement specification documents as well as high level project plan.

• Functioned as the primary liaison between the ETL developers, PMs and Business teams

• Led the JAD sessions and was responsible for the field to field mapping activities between the source

and target for the subject area.

• Worked extensively on building the Bus Matrix to capture the Metrics(facts) against Dimensions

• Devised the business transformation logic to be implemented in the ETLs and developed validation

scripts for the same

• Was responsible to ensure that standards are followed for missing and default value handling

• Worked with the data modelers to come up with the fact table structures that conformed the business

reporting requirement as well as performance requirements

• Worked to model Star schema for Claim forms UB04 (Facility Claims) and CMS1500 (Professional

Claims)

• Used Teradata SQL to Query on large datasets (approx 30 TB)

• Came up with Test cases and performed QA and User Acceptance Testing on data processed into the

EDW

• Generated POC ETL scripts using Teradata SQL for giving demo on complex business transformation

logic to implement the backout logic

• Was responsible for getting the sign offs and approvals prior to release

• Handled changes and evaluated the effort and feasibility of accepting adhoc scope or requirement

changes.

• Advanced use of Microsoft excel for giving a quick picture of various key metrics to the business users

that helped in getting high level view of the data.

Company: Capital One, Richmond, Virginia March 2010 April 2011

Title: Business/Data Analyst

Roles & Responsibilities:

Gathered requirements through discussions with the customer and various stakeholders within the

•

enterprise and prepared business requirement documents and functional specifications document.

Conducted Requirement analysis using Data analysis & Gap analysis.

•

Involved in various stages of project lifecycle from the Business Case development through to post

•

implementation and support

Analyzed the impact of new requirements on the existing functionalities and systems in the Enterprise

•

DataWarehouse environment

Created the Bus Matrix to capture the Fact Vs. Dimension relation for business reporting

•

requirements

Participated in Dimensional Modeling sessions

•

Worked on making Requirement Traceability Matrix and Change Management Matrix

•

Developed Proof of Concept and prototypes of new reports. Also worked on making reports for key

•

performance Indicators across different user segments

Used Teradata SQL for firing SQL queries to perform data analysis and comparisons

•

Interpreted the data into business

•

Worked on Cost Benefit Analysis, SWOT Analysis & Feasibility Analysis.

•

Was involved in analyzing the data and providing business insights & forecasts.

•

Company: Edelweiss Securities, Mumbai, India July 2007 Nov 2009

Role: Financial Data Analyst

Responsibilities:

• Worked extensively on financial analysis of the companies, sector and the economy.

• Analyzed financial data and extracted and defined relevant information; interpret data for the purpose of

determining past financial performance and to project a financial probability.

• Was involved in ensuring that the financial models adhere to the quality standard of the organization

• Was involved in collecting data from various sources and performing analysis using Excel on the same

for purpose of forecasting.

• Created Graphs, Financial Models, Charts and Diagrams for presentation to Senior Management &

Client.

• Was involved in extracting Economic & Financial data From Bloomberg and manipulating it for the

purpose of analysis.

• Worked on performing analysis on complex data and presenting the report to management on day to day

basis.

• Worked on developing a Product named CASH EQUITY GROUP for short term investment.

Company: Anandrathi Securities, Mumbai, India Aug 2005 June 2007

Title: Finance Analyst

Responsibilities:

• Preparing the Financial Model and Revenue Model of companies under coverage using valuation

techniques such as FCFE, FCFF & Ratio Analysis for forecasting the stock’s value.

• Generating Positional & Trading Calls based on Market Research & Fundamental Research of

stocks

• Designing portfolio based on Fundamental research and various quantitative screening techniques

• Managing Client Portfolios.

• Creating and maintaining external presentations for potential investors

• Responsible for responding to the news/ results of the stocks under coverage in a timely manner

and preparing the event update and result update

• Standardization of Excel models and testing the enhancements to these models.

•

EDUCATION

• Bachelors in Engineering – Mumbai, India

• MBA Finance – Mumbai, India

Contact this candidate