SUMMARY

• 6+ years of experience in machine learning, statistical model building, data analysis, data cleaning, reporting, visualization and storytelling.
• Developed SAS, Pig, Hive code for data manipulation, data cleaning. Analyzed and confirmed the integrity of source data.
• Being part of analytics project team, contributed to clustering, feature engineering, information retrieval activities working directly with onshore management for wholesale and retail markets analysis of an energy client.
• Experienced in acquiring, merging, cleaning, analyzing and mining structured, semi - structured and unstructured data sets for analysis.
• Design and develop ETL processes to ingest and maintain data from various sources.
• Write scripts to pull/push data from/to other reporting engines.
• Re-engineered the existing process by introducing tool CCRP (Core & Center Resource Planner) for use by management to monitor actuals vs forecasts of various projects & resources.
• Knowledge of basic construct of HDFS (Hadoop File Distribution System), Map Reduce and use of tools like Hue for operations and monitoring on a Hadoop Cluster.
• Performed complex data analysis on company’s data using SQL and solved problems using well-defined algorithms
• Experience in complex BI Reports, Dashboards, Project Management
• Experience in Tableau and Qlikview Dashboards in latest Design and Presentation.
• Profound analytical and problem solving skills along with ability to understand current business processes and implement efficient solutions to problems.
• Ability to present complex data and analytics to non-analytical audience.
• Detailed oriented professional, ensuring highest level of quality in reports & data analysis.
• Expert in innovation and formulation of new ideas and predictive models.
• Proven ability of multi-tasking to engage with stake holders at various levels to process data at large scale (Big Data) with enterprise systems.
• Designed, programmed and monitored Learning Management System (LMS) for the company and used simple predictive analysis techniques to forecast agent’s success.
• Involved in evaluation, data cleaning, data enrichment and reprogramming process of the company’s Quality Assurance (QA) system
• Generate KPI for customer satisfaction survey results and disease management.
• Advanced written and verbal communication skills.

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis
• Involved in creating Hive tables, and loading and analyzing data using Hive queries.
• Developed Pig Latin scripts to extract the data from the web server output files to load into HDFS.
• Developed the Pig UDF’S to pre-process the data for analysis
• Moved all RDBMS data into flat files generated from various channels to HDFS for further processing.
• Working on a POC for various products’ recommendations on websites based on user behavior patterns and products availability.
• Experimenting with collaborative filtering methods.
• Ingest data from SQL databases and other sources into Hadoop cluster using Sqoop.
• Conduct exploratory analysis and prepare dashboard & visualizations using Tableau
• Being part of analytics project team, contributed to clustering, feature engineering, information retrieval activities working directly with upper management for wholesale and retail markets analysis.
• Involved in weblog analysis.

Environment: Windows and Linux, HDFS, Tableau, MS-Excel, SQL Server, Microsoft office, Pig, Hive, Sqoop

Data Analyst

Confidential, Dallas, TX

Responsibilities:

• Re engineered the existing process by introducing tool CCRP (Core & Center Resource Planner) for use by management to monitor actual vs. forecasts of various projects & resources.
• Data Quality checking, data validation, cleaning up data to make accurate reports and analysis to use in key decision making.
• Preparation of Operational Decks in every month to show the ticket counts raise and decrease for the status for each Business unit.
• Implemented the Support Vector Machine Learning algorithm to predict energy consumption for a household
• Performed Measurement and Verification analysis of energy savings across the customers of Central Maine
• Prototyped a Model Predictive Control system, using real-time smart meter data, to optimally schedule
• Maintained SQL scripts to create and populate tables in data warehouse for daily reporting across departments.

Environment: Microsoft office, SQL, Toad

Data Analyst

Confidential

Responsibilities:

• Tracking the AMC created for each of the applications and validating the same before sending it to the onshore team.
• Assisting the PQL (Project Quality Lead) in the audit process.
• Produced summary audit reports of FAQs in Excel to quality assure benefit information and quantify use of webpage
• Prepare process documents and maintain all the reports for the team.
• Getting the inputs from all SME's for governance call.
• Created quantitative and qualitative reports based on replies; wrote findings anddata-driven suggestions for senior staff delivery
• Assist leadanalystin obtaining / collecting all documents / info to complete files.
• Reviewdataand information from multiple sources.
• Built database, created forms and reports using MS Access.
• In addition to the existing responsibilities, worked on development of a PMO portal that was aimed at providing real-time analytics & dashboards for both Middle and Senior Management.

Environment: MS-Excel, MS Access

Junior Data Analyst

Confidential

Responsibilities:

• Contributed to case studies such as, ‘Attrition Analysis’, ‘Process Capacity Review’, ‘Client Value Survey’, ‘Optimal Desk Utilization’ by collating, analyzing MI and produce graphs & reports.
• Manage & schedule operations resources to ensure the Service Level Agreements are adhered to.
• Continuously strive towards improving process efficiency through internal projects and/or re-engineering opportunities.
• Designed and developed prototypes.
• Participate in meetings with management and business partners. Identify potential improvement areas/ bottlenecks and provide appropriate solutions to the operations management.
• Preparing rich visualizations, attractive presentation layers, best practices around Dashboards, storyboards to show business insights to the top Management.
• Responds to all customer inquiries and requests for information and reports from the database.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Environment: MS-Excel, Macros, BMC Remedy