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) wif 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 wif SME (Subject Matter Expert).
• Extensively worked on Data analysis and reporting teh data using advanced Microsoft Excel skills. Effectively used vlookup, regression, pivot tables, etc to map data to informative reports.
• Experience wif data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snowflaking etc. Worked wif 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 wif 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 wif 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 wif Business Process Modeling.
• Adept in creating Use cases, Test Cases and GUI (Graphic User Interface) using MS WORD/VISIO.
• Strong domain noledge in Financial services wif 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 wif 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
• Gatheird requirements from business to define scope and prioritize teh critical KPIs for business reporting needs and created BRDs for teh same
• Educated and consulted teh team on writing highly tuned complex Teradata SQL queries keeping in mind teh size of teh underlying tables and architecture of teh DW
• Worked wif Data Modeling team to come up wif teh 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 wif ETL teams to deliver teh reporting layer composed of teh highly tuned and aggregated tables designed from teh base tables
• Used advanced Microsoft Excel for providing prototype of reports prior to actual Tableau implementation.
• Created teh POC and prototype Tableau reports and dashboards wif teh key metrics
• Participated and hosted bi-weekly scrum planning meetings to prioritize and delegate teh tasks to teh reporting and data teams. Collaborated wif teh scrum team to generate a relative size estimate for sprint backlogs and assisted in developing burn down charts.
• Worked wif teh QA team to come up wif test scenarios and test cases to validate teh aggregate datasets wif teh 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 wif teh Product Managers to enhance teh Behavior Insights product wif new metrics and KPIs as per teh business requirements
• Worked on R to implement clustering on behavior data.

Confidential, Richmond, VA

Business/Data Analyst

Responsibilities:

• Designed teh business requirement collection approach based on teh 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 teh primary liaison between teh ETL developers, PMs and Business teams
• Led teh JAD sessions and was responsible for teh field-to-field mapping activities between teh source and target for teh subject area.
• Worked extensively on building teh Bus Matrix to capture teh Metrics(facts) against Dimensions
• Devised teh business transformation logic to be implemented in teh ETLs and developed validation scripts for teh same
• Was responsible to ensure that standards are followed for missing and default value handling
• Worked wif teh data modelers to come up wif teh fact table structures that conformed teh 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 wif Test cases and performed QA and User Acceptance Testing on data processed into teh EDW
• Generated POC ETL scripts using Teradata SQL for giving demo on complex business transformation logic to implement teh backout logic
• Was responsible for getting teh sign offs and approvals prior to release
• Handled changes and evaluated teh 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 teh business users that helped in getting high level view of teh data.

Confidential, Richmond, Virginia

Business/Data Analyst

Responsibilities:

• Gatheird requirements through discussions wif teh customer and various stakeholders wifin teh 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 teh Business Case development through to post implementation and support
• Analyzed teh impact of new requirements on teh existing functionalities and systems in teh Enterprise DataWarehouse environment
• Created teh Bus Matrix to capture teh 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 teh data into business
• Worked on Cost- Benefit Analysis, SWOT Analysis & Feasibility Analysis.
• Was involved in analyzing teh data and providing business insights & forecasts.

Confidential

Financial Data Analyst

Responsibilities:

• Worked extensively on financial analysis of teh companies, sector and teh economy.
• Analyzed financial data and extracted and defined relevant information; interpret data for teh purpose of determining past financial performance and to project a financial probability.
• Was involved in ensuring that teh financial models adhere to teh quality standard of teh organization
• Was involved in collecting data from various sources and performing analysis using Excel on teh 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 teh purpose of analysis.
• Worked on performing analysis on complex data and presenting teh 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 teh Financial Model and Revenue Model of companies under coverage using valuation techniques such as FCFE, FCFF & Ratio Analysis for forecasting teh 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 teh news/ results of teh stocks under coverage in a timely manner and preparing teh event update and result update
• Standardization of Excel models and testing teh enhancements to these models.