SUMMARY

• 8+ years of industry experience as a Data Analyst with a solid understanding of Data Modeling, Evaluating Data Sources, and a good understanding of Data Warehouse, and OLAP.
• Knowledge in all phases of SDLC like Requirement Analysis, Implementation and Maintenance, and Good experience with Agile and Waterfall.
• Good knowledge in a Python - based environment, along with data analytics, data wrangling, and Excel data extracts and Familiar with Pandas, NumPy, Matplotlib, SciPy, and PySpark.
• Knowledge of maintaining and managing Tableau and Power BI drove reports and dashboards.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact, and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Good experience in data analysis, data profiling, data validation, developing low-level design patterns based on the business, and functional requirements.
• Good experience in the Strategic development of a Data Warehouse and Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Proficient in importing and cleansing of data from various sources like Teradata, SQL Server with high volume data.
• Good knowledge in Metrics analysis, Reporting, Pivot tables, Charts, Graphs using (KPI) Key Performance Indicator.
• Good Experience on, GCP services Computing and hosting services, Serverless computing. Application platform, React Native.
• Experience in RDBMS implementation and development using MySQL, SQL Server, SQL, and PL/SQL stored procedures and query optimization.
• Experience in Data Visualization including producing tables, graphs, listings using various procedures and tools such as Tableau.
• Skilled in data manipulation and generating customized reports with SAS data steps and procedures and have experience in handling large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Good experience in extracting data from multiple sources to Power BI for Data Preparation.
• Knowledge in RDBMS implementation and development using SQL, PL/SQL stored procedures and query optimization.
• Exposure to different QA and development methodologies: Agile (Scrum), SDLC (Waterfall).
• Experience in deriving data-driven insights and showcasing them using various business metrics and charts such as Regression, Time Series, Histogram on reporting dashboards using Tableau and Data Studio.
• Experience in Veeva Vault Secures inventories by executing controls and ensuring strict compliance with security procedures. Proactively reduces risk exposure and ensures implementation of measures to reduce work’s compensation injury costs and security losses within the market.
• Experience in cloud native, enterprises started discovering Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) services and their utilization in building applications that leverage the elasticity and scalability of the cloud, all the while embracing the inherent failures of the cloud platform.
• Experience in data Extraction, Transformation, and Loading ETL using various tools such as SQL Server Integration Services (SSIS) and Informatica.
• Experience with Create Release Plan document using JIRA Dashboard reports, used Confluence for Release Notes, shared release documents with Product Owner.
• Good experience with databases like SQL, MySQL, SQL Server, and Teradata.
• Having good Knowledge of Normalization (1NF, 2NF, and 3NF) and Denormalization techniques for improved database performance in OLAP.
• Experience in Veeva Consistently analyzes and reviews workflow for process improvements
• Good knowledge of pivot tables and VLOOKUP function for analyzing and generating reports.
• Experience in multiple operating systems including Linux and Windows.
• Good communication skills, analytical mind, people skills, a team player, an individual contributor, and a quick learner to adapt to new technologies, processes, and business domains.

TECHNICAL SKILLS

Programming Languages: SQL, SAS, R, Python, Statistical Analysis, Predictive Analysis

Database technologies: MySQL, MSSQL Server, PostgreSQL, Oracle SQL Developer, ETL Strategies

Cloud & BI Tools: Tableau, Power BI, Access, Pivot Tables, AWS(Redshift), GCP services

Other functional skills: MS Word, MS Excel, MS PowerPoint, Agile Methodology (JIRA), SDLC

Visualization: Tableau, Power BI, Python Matplotlib, Jupyter Notebook

Data Warehousing: Informatica(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, Data Stage

Reporting Tools: Business Objects, XIR3, Cognos Suite

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Boston,MA

Responsibilities:

• Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team.
• Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions for the company.
• Worked with Pandas, NumPy, and Matplotlib for developing various algorithms.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience in Veeva Vault Secures inventories by executing controls and ensuring strict compliance with security procedures. Proactively reduces risk exposure and ensures implementation of measures to reduce work’s compensation injury costs and security losses within the market.
• Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts, and Density Chart.
• Generated PL/SQL scripts for data manipulation, validation, and materialized views for remote instances.
• Worked with OLAP tools such as ETL, Data warehousing, and Modeling, Used Informatica / SSIS to extract, transform &load data from SQL Server to MySQL databases.
• Performed programming of data listings using SAS. Converted MS-Word documents and Excel tables into SAS datasets.
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Implement point of view security to Tableau dashboards to facilitate visibility across various levels of the Organization.
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Responsible for Source to Target Data Mapping, design, and validation of sample data to identify and fix data issues.
• Created Data Warehouse Cubes in SQL Server Analysis Service (SSAS).
• Responsible for creating ETL mapping documents to define data flow from the source system to the target database.
• Responsible for resolved data investigation issues and provide granular level information related to it and updated in Jira.

Data Analyst

Confidential

Responsibilities:

• Working with database tables, spreadsheets, and unstructured data to identify the client data needed and where the data is stored
• Involve in loading of data in between the schemas using Oracle One Source Database Loader
• Cross walk client data schema to internal data requirements to identify the client data needed and where the data is stored
• Creating Extract in SQL scripts to help correct data issues or trigger system activities based on customer requests
• Migrate the existing data into Amazon Redshift Database using PL/SQL programming, triggers, views, and functions
• Integration of Veeva HCP/HCO affiliation data to generate several tableau reports and required results of call tracks analysis
• Dealing Mediclaim datasets (HMO/PPO) to generate the active user analysis using pivot tables, advanced Excel functions
• Tableau reporting for Neurology, Oncology Drugs Shipment Data analysis, Calculate metrics of Patient metrics PAP, data validation for Oncology KPI measures dashboard
• Analyses sales and other reports and provides insight into how the business can make adjustments to sales opportunities to improve performance
• Metric calculation, data validation and dashboard for prescribers counts resulted Serostim counts of approx. 6%
• Creating reports in Tableau to track files & ensure data quality across MS Lifelines, Clinical trials increasing data quality by 30%

Data Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Understood the business needs of business department leaders and translated those needs into actionable plans for measuring success
• Extracted raw commercial data from shopping website into Python (Numpy, Pandas) to process data cleaning and show basic statistics index to prepare for the experiment design
• Loaded transformed dataset in Mysql workbench using sql sentence to do table merge, filter and easy calculation. Output the result into excel or csv format
• Partnered with engineering team to design and implement A/B testing with 500+ experiment groups
• Estimated customer behavior changes with product description format changes nearby "checkout" bottom on online shopping website
• Created A/B testing experiment with sales and tech department leader to set up metrics, experiment duration and customer sample size details
• Helped to conduct experiment on click-through rate to observe customer behavior change significance of experiments
• Managed business intelligence tool (Tableau) to confirm control and compare group to distinguish the difference of the result between two customer groups
• Used advanced analytical skills to monitor trends and surface opportunities to show the details of changes in each customer group
• Evaluated the experiment result and recommended solutions based on analysis knowledge and anticipated business needs
• Utilized reporting channel to analyze and report on ecommerce system performance, metrics to help sales department leader to implement the experiment or not in order to make more profit and more product purchase deals

Business Application Analyst

Confidential | Boston | MA

Responsibilities:

• Evaluated business challenges, implemented lean startup principles, and provide solutions to support fast Enterprise product iteration, for group of 1000 employees and leadership in diverse domains, contributing to quarterly revenue 0.1 billion
• Collected, analyzed, and reported user behavior, JAD sessions in relation to product usage
• Integrated custom visuals based on business requirements using Power BI Desktop.
• Developed complex SQL queries using stored procedures and temporary table to support Power BI and SSRS reports
• Developed custom calculated measures using DAX in Power BI to satisfy business needs
• Designed reports for effectively narrating the product usage key metrics and high priority initiatives which allows developer to readily access these test cases and test labs this reduces the report creation time by 50%
• Validated hypothesis using Functional, User Acceptance Testing, A/B test for mobile and web app, Manual testing which helps in integration of existing product raised customer counts by 1.2 times
• Enhanced workflow analysis, tested each single step of transforming data to target columns through count validation, data validation helps in implementing real-time business intelligence dashboards Measures to forecast company sales calculated by predictive analysis, Machine Learning, data mining techniques resulted quality with 95%

Application Support Analyst

Confidential

Responsibilities:

• Extracted data from HMDB resource, transformed the file formats to consolidate data targeting concentrations count of 50 metabolites to get stored in Data Warehouse which provides the levels of health tests
• Build custom API to transfer formatted data into cloud storage which exports as a CSV file & GUI displaying real-time test records, resulted in display the information as user command
• Innovated a new feature of Reminder - Notification by applying analysis clustering of same molecules concentration and keeping record of last time period health check-up. Concluded in customer satisfaction with 78% efficient feature in the app that track the health records

Business Analyst

Confidential 

Responsibilities:

• Integrated various education website data sources, built business mapping documents for transferring the data using complex SQL queries and SDLCmethodology
• Performed data clean up, data relationships, data analysis, data profiling, web scrapping and ETL strategies in Data Stage
• Used excel sheet, flat files, CSV files to generated Tableauad-hoc reports.
• Built R scripts to calculate performance metrics, changed content management user training by enhancing current methods and improved internal QA testing methods which improve strategies and business governance operations
• Created Tableau scorecards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality, utilized Excel (pivot tables and VLOOKUP) & validated Tableau dashboard reports to find the insights of the business
• Developed and analyzed distinctive designs, increased the accuracy of data migration by 83% by utilizing Excel macros