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

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Data Analyst

Responsibilities:

• Worked as Subject Matter Expert for Confidential 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.

Confidential, Richmond, VA

Business/Data Analyst

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.

Confidential, Richmond, Virginia

Business/Data Analyst

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.

Confidential

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.

Confidential

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.