PROFESSIONAL SUMMARY:

• Over 7 years of IT Industry experience and professional hands on experience as Data Engineer using Oracle, SQL, ETL (Extract, Transform, Load), Business Intelligence wif Oracle Tableau and Power BI, SQL, DB2,MS Excel, MS Access on windows and UNIX platforms from diverse domains such as Analytics, Consulting and Implementation in BFS, retail and Insurance industry and building highly efficient metrics to derive actionable insights for business environments leveraging exploratory data analysis.
• Experience wif Operational and Exploratory Analysis, Data Mining and Machine Learning Skills using R, Python, MATLAB and SQL.
• Good familiarity in entire Data Science project life cycle, including Data Acquisition, Data Cleansing, Data Manipulation, Feature Engineering, Modeling, Evaluation, Optimization, Testing and Deployment.
• Experience in problem solving, data science, machine learning, statistical inference, predictive analytics, descriptive analytics, prescriptive analytics, graph analysis, natural language processing, and computational linguistics; wif extensive experience in predictive analytics and recommendation.
• Extensive experience in various phases of software development like analyzing, gathering and designing the data wif expertise in documenting.
• Expertise in Model Development, Data Mining, Predictive Modeling, Descriptive Modeling Data Visualization, Data Clearing and Management, and Database Management.
• Extensive hands - on experience and high proficiency wif structured, semi-structured and unstructured data, using a broad range of data science programming languages and big data tools.
• Experience in using Python & R libraries like Numpy, SciPy, Pandas, Matplotlib, Scikit-learn, Beautiful Soup, Caret, forecast, xgboost, tidy text, dplyr, ggplot2, Shiny, bokeh, Seaborn, SparkContext, Tensor- Flow, genism Microsoft Azure
• Deep understanding of Software Development Life Cycle (SDLC) as well as Agile/Scrum methodology to accelerate Software Development iteration.
• Proficient in SAS, MATLAB and Hands on experience in writing queries in SQL (Teradata, MySQL) and Informatica to extract, transform and load (ETL) and Visualization using Tableau
• Used predictive modeling to optimize current processes and improve corrective action timeliness. Coordinated wif different functional teams to implement models and monitor outcomes.
• Experience in designing visualizations using Tableau and Power BI software and Storyline on web and desktop platforms, publishing and presenting dashboards.
• Technical expertise and business acumen necessary to translate business requirements and objectives into scalable, highly resilient and successful system solutions.
• Expertise in using Microsoft Office including using Microsoft Excel to build Pivot Tables and Visualizations.
• Strong noledge in all phases of SDLC (Software Development life cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance.
• Great exposure in interacting wif end-users to gather and document the requirements, project planning and scheduling. Actively participated in creation and implementation of Test plans.
• Strong business sense and abilities to communicate data insights to both technical and nontechnical clients. Worked in both Agile and Waterfall implementations.
• Extracted data from production database (Oracle) and prepared financial reports using oracle SQL, PL/SQL..
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse wif SQL * LOADER.
• Skilled in designing data warehouse databases for OLAP processing.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, Collections.
• Proficient in writing complex SQL Queries, Stored procedures, creating Indexes, Functions, Triggers, Sub Queries, Global Temporary Tables.
• Proficient in tuning queries and troubleshoot for bugs in the application.
• Developed databases and data warehouse. Analyzed and specifying specific data requirements.
• Possesses strong programming experience in developing JavaScript, PL/SQL, Packages, Stored Procedures, Functions and Database triggers.
• Proficient in all phases of Software Development Life Cycle (SDLC).
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Quality.
• Strong business sense and abilities to communicate data insights to both technical and nontechnical clients.

TECHNICAL SKILLS:

Programming: R(caret, glmnet, xgboost, dplyr, survival, rpart, ggplot, dply) Python (numpy, pandas, scikit-learn, scipy, matplotlib, seaborn, tensor-flow, Keras)

Data Visualization: Tableau, PowerBI, R (ggplot2), Python (Matplotlib, Seaborn), SAP Lumira

Database / ETL Querying: SQL Server, Postgres, MySQL, SSIS, SSAS, Hadoop DDL/DML statements, Subqueries, Joins, Normalization, Entity Relationship Diagrams, Star schema / Snowflake schema (Fact and Dimension tables), Data Warehousing

Others: Linux, Git, Software Development Life Cycle, Agile, IT Project Management, Prototyping, Gathering Functional and Non-Functional Requirements identification and analysis, SWOT Analysis, Root cause analysis, Dataflow diagrams, Use case diagrams, Technical Documentation

WORK EXPERIENCE:

Confidential, Carlsbad, CA

Sr. Data Analyst

Responsibilities:

• Real time and Historical reporting setup & web pages development for reporting data dashboard.
• Working on complex data driven business requirements, perform analytics on the data using multiple visualization tools and presenting the findings and recommendations to management.
• Perform data analytics by combining different datasets residing in diverse databases using ETL tools.
• Integrating, improving, and analyzing large databases using Tableau, PowerBI, Excel, Python and R.
• Extensive data cleansing and analysis, data validation, conditional formatting, and graph and chart manipulation.
• Conducted and Participated in Joint Application Development (JAD) sessions wif stakeholders.
• Created artifacts such as Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
• Created Business Requirements Document, including full traceability throughout all states of the Systems Development Life Cycle (SDLC).
• Performed in-depth quantitative analysis by combining SFDC CRM dataset wif other corporate vertical large datasets.

Confidential, Pittsburgh, PA

Data Analyst

Responsibilities:

• Extracted data from existing data source and performed ad-hoc queries by using SQL, SAS, MS Access.
• Performed in depth analysis of data & prepared reports by using MS Excel, MS Access, VBA, SQL, PL/SQL.
• Extracted data from various production databases and exported into MS Excel by using SAS, SQL.
• Developed macros and views to integrate complex business rules.
• Analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
• Prepared data for transfer to internal lead distribution system or third-party vendor for delivery via ETL process.
• Created Pivot tables, Pivot charts and reports in different formats by using advanced features in MS Excel.
• Designing and creating SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.
• Responsible for data identification, collection, exploration, and cleaning for modeling, participate in model development.
• Visualize, interpret, report findings, and develop strategic uses of data by python Libraries like Numpy, Scikit-learn, MatPlotLib.
• Performed Data Cleaning, features scaling, features engineering; responsible for loading, extracting and validation of client data.
• Missing value treatment, outlier capping and anomalies treatment using statistical methods, deriving customized key metrics.
• Performed analysis using industry leading text mining, data mining, and analytical tools and open source software.
• Understanding and implementation of text mining concepts, graph processing and semi structured and unstructured data processing.
• Used Meta data tool for importing metadata from repository, new job categories and creating new data elements.
• Worked wif several R packages including knitr, dplyr, Causal Infer, space-time.
• Built multiple features of machine learning using python and R based on need.
• Strong skills in data visualization like matPlotLib and seaborn library.
• Developed predictive models using Decision Tree, Random Forest, Naïve Bayes, Logistic Regression, Cluster Analysis, and Neural Networks.
• Extended data wif third party sources of information when needed.
• Enhanced data collection procedures to include information dat is relevant for building analytic systems.
• Processed cleansed and verified the integrity of data used for analysis.
• Ad-hoc analysis and presented results in a clear manner.
• Created automated anomaly detection systems and constant tracking of its performance.
• Strong command of data architecture and data modelling techniques.
• Hands on experience wif commercial data mining tools such as R and Python depending on job requirements.
• Identification of relevant metrics and preparation of dashboards wif visualization technologies such as Tableau.
• Draw inferences and conclusions, and create visualizations of processed data, identify trends, anomalies.
• Participated in meetings, teleconferences and video conferences to keep track of project requirements.
• Solved analytical problems, and effectively communicated methodologies and results.

Confidential

Data & Analysis Manager

Responsibilities:

• Objective was to understand growth projections in two popular product categories.
• Provided the univariate and multivariate forecasts for all the categories at channel level and multivariate forecasts at category and segment level.
• Used the Time Series analysis techniques like ARIMA, exponential smoothing, Theta and Spline
• Data preparation, cleaning and merging the necessary files suitable to perform the time series analysis wif SAS
• Model building wif using multiple regression and Time series analysis like Exponential smoothening, ARIMA and Finalizing the models based on the MAPE, Historical CAGR, Forecasted CAGR, and Month on month % change wif Business intuition.
• Generate Proc SQL to extract data from csv, excel and oracle database.
• Data preparation and Data processing using BASE/SAS and SAS/Macros to build time series Analysis.
• Involved in model building using Exponential smoothing and PROC ARIMA procedure for univariate and multivariate forecasts.
• Creating TOP DOWN and BOTTOM UP Approach to align channel forecasts wif each segments and category forecasts using BASE/BASE, SAS/ETS and SAS/MACROS.
• Decompose volume & dollar into different factors using more contributing the volume growth rate using BASE/SAS and SAS/STAT.
• Involved in preparing SAS code to pick the best forecasts using MAPE, CAGR, YTD, YTG, YOY growth and annual share.
• Involved in giving business insights for all the categories, segments and their channels.
• Documentation of analysis and SAS Programs Preparing the waterfall charts to easily understand the historical data.

Confidential

Business Analyst Programmer

Responsibilities:

• Worked on a data analytics and data mining solution for a leading North America healthcare client for tracking performance details of individual agents to maximize customer contact center usage.
• Daily interaction wif Business Customer, Requirements Gathering, Preparing and maintaining project documentation and Use case documents. Delivered 100% documents wifin cut-off date, dat increased the release score of projects from 4.2 to 4.85/5.
• Prepared Level of Effort in terms of hours and dollar amount needed, translated business & stakeholder requirement to solution requirement and captured it in Functional Design and Use Case Specification Documents, created data flow models using modelling tools such as Microsoft VISIO.
• Provided gap analysis, requirement gathering & user by collaborating wif client.
• Created views in Tableau Desktop dat were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current customers by color dat were broken into regions allowing business user to understand where we has most users vs. least users using Tableau.
• Projected and forecasted future growth in terms of number of customers in various classes by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and excel.
• Blended data from multiple databases into one report by selecting primary key from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop dat were presented to Business Users, Program Managers, and End Users.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly wif the usage of quick filters for on demand needed information.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Assisted Testing team in preparing test scenarios and test cases, introduced a tracking mechanism tool for logged defects, increasing resolving efficiency of tickets by 25%.
• Recognized as top performer for successful delivery of business-critical project, wif zero defects (Jan. 2011).
• Worked on a data management and reconciliation solution for a leading North American investment bank.
• Rewrote various business process and tested result in MS Excel using various functions and sub query wif not exists.
• Involved in updating functional requirement document after development and created documentation for deployment team.
• Data quality check on variable level including missing values, unique values, frequency tables.
• Obtained the data from variety of sources such as Database, CSV, flat files etc.
• Wrote complex join SQL queries to extract, load data.
• Worked on SQLServer concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Coached a 4-member team on a new portfolio management application development, leading to successful on time delivery of the project. Ensured 100% coverage of test cases for the application, leading to zero hours for rework.
• Saved $80,000 and 300-ma hours for client support teams by developing an automatic trade reconciliation tool.
• Reduced team effort by 2 hours per week by designing and developing applications wif proper documentation.