Senior Data Analyst Resume

SUMMARY

8 years of experience in Data Analysis, Data Modelling, Data warehouse, Data validation and reporting solutions
Involved in JAD sessions & workshops with stakeholders for requirement gathering and risk mitigation
Experience in creating and optimizing data models in a Data Warehouse
Strong experience in End to End implementation of Data warehouse & Data Marts using Star/Snow flake schemas
Develop descriptive and exploratory analysis using Tableau, OBIEE and SQL
Experience creating visualizations via Stories and Dashboards in Tableau/OBIEE
Experience in writing SQL scripts and Stored Procedures in a data warehouse for reporting needs
Experience migrating excel reporting solution to Tableau based out of EDW
Schema and data validation of EDW post data loads from multiple source systems
Functional validation of BI reports against CRM and ERP systems
Functional Knowledge on Order to Quote, Quote to Order and Order to Cash Business processes involving SFDC, Model - N and EBS systems
Self-motivated to thrive for efficiency and effectiveness through ideation, analysis, innovation and continuous improvement and be self-sufficient
Experience working in Agile approach in Health care and Hi-tech Domains.
Troubleshooting production issues and involved in UAT and production support

TECHNICAL SKILLS

Database: Microsoft SQL Server, Oracle, Mongo, GreenPlum, AWS Redshift

Visualization tools: Tableau, OBIEE, Power BI, Qilk, MicroStrategy

ETL: Informatica. AWS Glue

Languages: Python, R

Project Management Tools: JIRA, SalesForce CMT, Trello, HP ALM

IDE: SQL Developer, TOAD, pgadmin, TOAD, MS Visual Studio, Robo Mongo, PyCharm, R Studio

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

Understand business requirements and define data strategy for implementation
Define data classification, analysis and modelling strategy combining Billing, Invoicing and adjustment schemas
Use Labeling & annotations, data blending, data extract, publishing & re-using data sources, applying use as filter actions, quick filtering, hierarchies, conditional formatting, groups the rows and Title and Caption.
Created Dual Axis / Multiple Measures, Combo Charts with different mark types, Pie Charts and Bar Charts, Sorting & Grouping and Drilling and Drill Through reports.
Coordinate with integration team to build pipelines using python for data enrichment
Data validation of Business templates against GPLM and Kinaxis systems
Create templates to link new warehouses to existing manufactures in Agile PLM
Create excel templates to load planning data on Regulatory information to Kinaxis form Agile PLM
Suggest best practices in maintaining environments dealing with huge volumes of data

Environment: Agile PLM, Kinaxis, Gvault, Tableau, SQL Developer

Confidential

BI Developer

Responsibilities:

Managing key activities, data analysis, test data design, data modelling and data classification
Perform exploratory analysis on data using Tableau to identify outliers and patterns
Create and Maintain Tableau extracts
Developed SQL scripts to analyze data from Submit order and Acknowledgement APIs and find usage patterns
Created Procedures to load data from APIs into EDW
Published data sources, worksheets and dashboards into Tableau server
Performance tuning of Tableau dashboards
Implemented Row-level security by referencing entitlement tables
Used Postman to check the response from Submit Order, Acknowledgment and Usage API
Involved in backlog refinement and retrospective meetings for continuous improvement
Communicating project metrics, Incidents and KPIs with Project Review Board of as part of governance meetings

Environment: Oracle EBS, postman,SFDC, Greenplum EDW, Oracle DB, Analysis for office (Hyperion), ARIA