SUMMARY

• Over 8+ years of total IT experience in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications and acquired excellent analytical, co - ordination and interpersonal skills for leadership.
• Experience in all phases of Software development life cycle (SDLC) including System Analysis, Design, Data Modeling, Implementation and Support and maintenance of various applications in both OLTP and OLAP systems.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities
• Extensive Experience working with business users as well as senior management.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Strong experience with Database performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
• Experience in using various packages in R and python-like ggplot2, caret, dplyr, Rweka, gmodels, twitter, NLP, Reshape2, rjson, plyr, pandas, NumPy, Seaborn, SciPy, Matplotlib, sci-kit-learn, Beautiful Soup.
• Extensive experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau.
• Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data.
• Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, ER Diagrams and OLTP and OLAP System Study and Analysis.
• Extensive experience in Enterprise Information Management and Architecture technologies including Information Lifecycle, Master Data Management and Business Intelligence.
• Proficient in Tableau and R-Shiny data visualization tools to analyze and obtain insights into large datasets create visually powerful and actionable interactive reports and dashboards.
• Automated recurring reports using SQL and Python and visualized them on BI platform like Tableau.
• Extensive experience in conducting Gap Analysis, Business Process Re-engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
• Very strong using MS Excel. Used advanced functions like V-lookup, Pivot tables and analysis.
• Extensively used ERWIN and PowerDesigner to design Logical and Physical Data Models, to forward and reverse engineering data models and publishing data model to acrobat PDF files.
• Excellent leadership, organization skills and requirement gathering skills such as JAD.
• Strong experience in Database such as Microsoft Access, Oracle, SQL Server, DB2, Teradata, on Windows platforms and latest.
• Experienced in writing Toad and PL/SQL Stored Procedures, Triggers and Functions.

TECHNICAL SKILLS

Analytical Tools: SQL, Tableau Desktop, R, Python, Advanced Excel.

Modeling Skills: Supervised Learning Methods (Linear Regression, Logistic Regression, Decision Trees, Random Forests, SVM), Unsupervised Learning Methods (K-means, Hierarchical Clustering).

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Confidential

Responsibilities:

• Performed data analysis and data profiling using complex SQL on various sources systems including Databricks and Snowflake
• Implemented Classification using supervised algorithms like Logistic Regression, Decision trees, KNN, Naive Bayes, Random Forest etc.
• Worked with Machine learning algorithms like Linear Regressions (linear, logistic etc.) SVMs, Decision trees for classification of groups and analyzing most significant variables such as FTE, Waiting times of purchase orders and Capacities available and applied process improvement techniques.
• Built models using Statistical techniques like Bayesian HMM and Machine Learning classification models like XG Boost, SVM, and Random Forest.
• Participated in all phases of data mining, data collection, data cleaning, developing models, validation, and visualization and performed Gap analysis.
• Implemented Data Exploration to analyze patterns and to select features using Python SciPy.
• Built Factor Analysis and Cluster Analysis models using Python SciPy to classify customers into different target groups.
• And utilized SAS for developing Pareto Chart for identifying highly impacting categories in modules to find the work force distribution and created various data visualization charts.
• Worked on various Statistical models like DOE, hypothesis testing, Survey testing and queuing theory.
• Experience with risk analysis, root cause analysis, cluster analysis, correlation and optimization and K-means algorithm for clustering data into groups.
• Design Logical and Physical Data Model using MS Visio data modeler tool. Coordinate & communicate with technical teams for any data requirements.
• Used Pandas, NumPy, seaborn, SciPy, Matplotlib, Scikit-learn, NLTK in Python for developing various machine learning algorithms and utilized machine learning algorithms such as linear regression, multivariate regression, naive Bayes, Random Forests, K-means, & KNN for data analysis.
• Used packages like dplyr, tidyr & ggplot2 in R Studio for data visualization and generated scatter plot and high low graph to identify relation between different variables.
• Worked on Business forecasting, segmentation analysis and Data mining and prepared management reports defining the problem; documenting the analysis and recommending courses of action to determine the best outcomes.
• Work with business stakeholders to refine and respond to their ad hoc requests and improve their existing reporting and dashboards as necessary.
• Used advanced Excel functions to generate spreadsheets and pivot tables.

Senior Business Analyst

Confidential

Responsibilities:

• Developed an analytical wing on the dealer side of business by bringing in business intelligence reporting and data analytics projects. This endeavor made dealer side systematic in data and increased sales by 20 percent.
• Performed analysis of Integrated Voice Recording in sales funnel and recommended change in workforce distribution to reduce wait time for customers resulting in a 5% reduction in abandon rate.
• Created high and granular level dashboard in tableau for dealer side of the business encompassing business KPI s with the forecast of sales to achieve positive growth rate.
• Created approaches, estimated time, designed, analyzed, wrote, tested, documented, and implemented program development / enhancements to meet business and system project goals and specifications. Consulted with client, users, management, technical staff and other programmers for desired outcome.
• Created, coded and tested, with later modifications, a set of programs using DB2, IMS, VSAM for monthly Sales reports of dollars and counts of prior month beginning, new business split by customer type, resales, acquisitions, discontinued business, and transfers of business between regions.
• Developed, wrote and tested to create ad hoc reports/files for internal auditing requests regarding installation costs, sales and order and invoice data.
• Worked closely with SME's, developers, BA's to gather details not just for the requirement at hand, but to know how it is carried on in production today, so the information can be put together to arrive at sound test case
• Present sales presentation and proposal to prospects, identifying positive features and advantages of Confidential products and services over competition
• Carrying out requirement gathering, requirement analysis, prominent level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s related to the split scenario and post production data cleansing.
• Worked on Data migration, Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.

Data Analyst Intern

Confidential

Responsibilities:

• Worked alongside the Office of Analytics to design a Classification Model in R to predict wastage of metal during importing in plant operations, thereby reducing costs by 10% annually.
• I built and executed regression test plans representing end-to-end supply chain and manufacturing functionality in a highly customized environment.
• Forecast the customer’s transactions using time series analysis using R and Python Libraries
• Performed data analysis and data profiling using complex SQL queries on various sources systems including Oracle and SQL Server.
• Arrived independent variables with financial ratios for modelling and forecasting the data using time series analysis -R and Python
• Arrived character and capacity model to predict customer capacity to repay based on various capacity and character indicators.
• Model development, model maintenance and model validation.

Data Analyst

Confidential

Responsibilities:

• Led team of five analysts to analyze data from the monthly business plans and actual statistics to identify profitable revenue growth opportunities which resulted in a 10% increase in revenue
• Developed tableau reports to analyze key business drivers (Revenue, NPS, Sales, Insurance, customer trends) and enable data-driven decision making at the Senior Executive level.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Involved in requirement gathering, business Analysis, design and development, testing and implementation of business rules.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Created different views in workbook to visually analyze the data.
• Blended data from multiple tables from the same database into one report.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Designed and developed operational dashboards with parameters, calculated fields, groups and hierarchies.
• Subject Matter Expert (SME) for Power BI and worked on Microsoft Business Intelligence stack.
• Design the Data Model for the current solution to make it centralized for the other line of businesses.
• Migrated Excel reports and Pyramid analytics reports to Power BI.
• Developed and maintained multiple Power BI dashboards/reports.
• Created Datasets using different data sources like Microsoft SQL Server, Microsoft Azure and Excel.
• Implemented Data security (Row level security) on Dataset and Reports in Power BI.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS.
• Developing and Maintaining of Data Dashboards, Reports and Data Visualization tools and Products using SSRS, Power BI, Tableau, Visio and Excel.
• Understanding the existing data and create the required data models for the development.
• Created Databases, Data Mart Tables, Views, Stored Procedures, Triggers, Cluster/Non-Cluster Index, Unique/Check Constraints.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Developed master ETL packages for loading and migrating historical data from Legacy system into D/W.
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
• Developed complex reports with multiple datasets and sources in SSRS.
• Optimized SSRS reports with snapshots, caches, execution log views, embedded queries and stored procedures.
• Involved in Data scrubbing/Cleansing/validating/Translating, and scheduling SSIS packages.

Business Analyst

Confidential

Responsibilities:

• Increased customer retention rate by 5% and new customer acquisition rate by 10% by fabricating customer lifecycle dashboards to enable personalized customer experience.
• Analyze and distribute monthly sales dashboard for Confidential fresh loyalty sales program which generates over $6M annually comprise of over 110000 customers
• Achieved 25% growth in sales over the year by performing supply and demand analysis using budgeting and forecasting using Python.
• Assisted in gathering Business Process Requirements and translated them into functional and non-functional requirements of the Business Requirement Document (BRD), which used as input to the functional design specifications.
• Assisted in Creating Use Case/Activity /Sequence Diagrams in MS Visio
• Worked along with the testing team to derive test cases for efficient Data reporting
• Conducted the Unit testing and prepared the testing document
• Worked with senior Business Analysts to create business requirements, workflow, environment details and plan phases in development.
• Created SQL statements to validate the data tables.