SUMMARY

• Strong domain knowledge in Banking & Finance, Healthcare and Media & Entertainment.
• Strong knowledge on SQL & ETL and Data Warehouse concepts.
• Have experience working on Teradata, Hive, Impala and SQl Server.
• Create PowerPoint presentations for Business Analytics & Data Insights for various key metrics.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Preparing Dashboards using calculations and parameters in Tableau.
• Used Pivot Tables and charts in MS Excel for data presentation of adhoc requests.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau.
• Proficient in creating end - to-end Business Analyst deliverables.
• Process Improvements

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles

Data Analyst

Responsibilities:

• Worked on strategic projects for the Digital Marketing, Pay Per View and Premium Channel subject areas.Created streaming dashboard, campaign management dashboard (by working with third parties like Turn, Merkel) and managed requests and data related issues for the above mentioned subject areas.
• Identify, analyze and interpret trends or patterns in complex data sets in MS Excel using Pivot tables.
• Work closely with management to prioritize business and information needs.
• Derived streaming data insights and stories that drive business decision and usability improvement of the streaming app from all aspects of the streamer experience including search, content, clicks, patterns of behavior.
• Analyze and visualize large data sets to provide data insight across platform (set top box, TV App and website) to understand and improve AT&T TV products (in the area of UI/UX, Search, Recommendation and Live Streaming)
• Discover and track customer behavior data from set-top boxes to identify trends and business impact.
• Leveraging data using BI tools Tableau for Data visualization and storytelling.
• Profile raw data sets across platforms and develop KPI/dashboard to measure product performance.
• Collaborate with executive management team to rapidly prototype business dashboards and KPIs.
• Perform quantitative analysis of product sales trends to recommend pricing decisions.
• Designed and developed various dashboards to encircle the complete summary of streaming patterns of the customers. This is required to facility the organization goal of increasing streaming percentage to 90% by DEC, 2018.
• Monitored and enhanced performance of Confidential 's existing Sales and Marketing models including customer life time value models and retention models using statistical techniques.
• Develop and implement data collection systems and other strategies that optimized statistical efficiency and data quality.
• Made use of the aggregated tables on the most frequently queried data for Monthly and Yearly based reports.
• Used Database Delegation property for the objects that involves ratios or averages.
• Created Reports using combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports.
• Made use of alerts, filters and Breaks in the reports.
• Co-ordinated with the Business users for the UAT testing.
• Worked aggressively on very tight deadlines for the completion of the Project.
• Worked closely with management to prioritize business and information needs.
• Worked as Functional SME for Digital Marketing, Viewership, PPV, Premium Packages, ADE.
• Collaborated with Quality Assurance teams to conduct UAT and ensuring project readiness for production and validation.

Confidential, New York

Business Analyst

Responsibilities:

• Worked for Front office applications as a Business Analyst.
• Worked towards the launch of FlexOne, Citi’s new currentaccount product targeted at customers in the age range of 11 to 18 years old (youth) aiming to enhance the customer experience of new current account was to be opened in 2 click.
• Understood the impact of change on the application used to sell the current account products.
• Understood the impact of change on business processes.
• Organized and running the workshops with all the stake holders like product owners, Enterprise architect, Legal.
• Created Use Cases, UI wire frames, Business rules.
• Created Business requirement documents.
• Created System requirement specification document.

Confidential

Technical Analyst

Responsibilities:

• Contributed to the due diligence for $1-billion budget allocation for various technical units, identifying key factors and forecasting the expense for the year.
• Established new forecasting tracking and management reporting system to improve availability and accuracy of financial data, triggering 5% increase in accuracy.
• Worked with the third party vendors firms and come up with the amount for the specialized services required by the WHO.
• Supported multiple internal levels of management in the evaluation of initiatives.
• Support Central Procurement agency on Health Supply Chain Management and Warehousing and oversee company’s transition to automated ordering system, which eliminated redundancies and warehouse downtime and saved 10% annually.
• Contributed to the health repository through collection of data and statistics as well as preparation and editing of notes related to technical work plans
• Used Teradata Query editor to write the SQLs for preparing data points on prevalence of Leprosy in the States of India for Mid-Term Evaluation- Leprosy 2014.
• Drafted a policy Position Paper on Promoting Production and Technology adoption in Pharmaceutical Enterprises for Meeting National and Global Public Health Needs for India Pharma Summit 2015.
• Planning and programming of technical meetings and workshops which were related to the “Pharmaceuticals” & “Communicable Diseases” Work plan through appropriate planning, identifying steps and phases to be followed, defining milestones and deadlines and conducting budgeting exercises
• Preparation of technical documents suggesting implementation modalities, criteria for selection of consultants and partners, defining milestones, deadlines and deliverables and identifying potential risks and mitigation measures and performing an intense budgeting exercise for the various technical activities.
• Collection of data related to ADRs (Adverse Drug Reactions) from various ADR Monitoring centers located in the country to compile reports on trend analysis over the years and generating reports, which would be stored in a centralized database.
• Contributed in formulation of Presentation highlighting the outcomes from Survey for Promoting Production and Technology adoption in Pharmaceutical Enterprises for Meeting National and Global Public Health Needs for India Pharma Summit 2015.

Confidential

Healthcare Analyst

Responsibilities:

• Worked as a Business Analyst for one of India’s biggest Hospital chain. This project required creating the reports and dashboard so that executives can have better insight of the Revenue
• Drive interviews and end user interactions to determine requirements for creating Reports/Dashboards.
• Worked with Business Users to define Key Performance Indicators for the reports and Dashboards.
• Assessed and identified potential data sources for the reports and dashboard.
• Documented the changes/new requests determined after discussion with business users into a Business Requirements Document.
• Translated business questions and requirements into conceptual and UI application models to enable dashboard development.
• Worked with the application development team to create the required structures needed to enable the reporting of data as per requirements gathered from the business users.
• Identified potential risk areas during the analysis phase.
• Analyzed data flow and business requirements to create High Level Design document.
• Made use of the aggregated tables on the most frequently queried data for monthly and yearly based reports.
• Created the universe and report check list templates, which are used as check points before migrating the objects to QA and Production environments.

Confidential

Business Analyst

Responsibilities:

• Worked for this financial institution in India to develop the capability so that bank can reach out to the maximum customers through multiple channels.
• Worked on the projects to open the Saving Products, Personal Loans from Internet Bank and Mobile Banking apps.
• I was also responsible for projects to enhance the customer experience in Internet and Mobile Banking apps.
• Defined the process as to how the solutions will be implemented. This involves coming up with 3 stages, starting from idea initiation to delivery of final deliverable.
• Initiation of an idea and creating HLFD (High Level Functional Design) for the same.
• Worked on feasibility check, impact assessment and work effort estimates through various stages of sprint planning.
• Created Business Requirements document for the project.
• Created the matrix of documents (like the Use Case Model, Use Case, Activity Diagram, Service Spec, Service Sequence diagrams, UI spec, Business Rule Catalogue, Content Catalogue, Data Dictionary, Audit Catalogue, Traceability Matrix, Wireframes and Data Model).
• Created functional documents for Dashboard and Reports for the Savings product and loan products.
• Understood business needs by conducting numerous interviews and stakeholder workshops with users, funders and other stakeholders.
• Responsible for Show and Tell to client and Reconciliation with other work stream teams.
• Created requirement traceability and UML modelling for functional deliverable.
• Presented complex concepts in a meaningful and concise manner for clients, project stakeholders, team members, and end users.
• Understood organizational dependencies, regulatory constraints, technical limitations and other factors that may impact the user experience.
• Communicated and collaborating with project managers, developers, designers, and clients in all stages of the project lifecycle.
• Developed the AS - IS and TO-BE systems.
• Conducted Gap Analysis in Solution and Defect Management processes.