SUMMARY

• Experienced data analyst with focus on client services management and driving business solutions through technology and data driven solutions approach.
• Experienced in multiple sectors such as energy, IT, financial services, and supply chain.
• Experience in IT infrastructure and IT transitions, working towards organizational strategic initiatives, team handling, data analysis and visualization for strategic decision - making efforts.
• Around 8+ years of experience with 6+ years of in areas including data analysis, statistical modeling, data mining, and working with large data sets in sectors including Energy, Oil & Gas, Finance, and Supply chain.
• Highly skilled in using visualization tools like Tableau Desktop, QlikView, ggplot2 for creating dashboard.
• Proficient in data mining tools like R, Python, SQL, Excel.
• Good Experience in using various Python libraries (NumPy, SciPy, matplotlib, Pandas, MySQL dB for database connectivity).
• Strong working knowledge with SQL, SQL Server, Tableau and Jupyter while handling various applications in multiple projects.
• Experienced Data Analyst with solid understanding of Data Mapping, Data warehousing (OLTP, OLAP), Data Mining, Data Governance and Data management services with Quality Assurance.
• Hands on experience in SAP and QlikView analysis and reporting.
• Experience in Managing QA, Business, Product and Production Support teams to deliver new or enhanced features and address issues/concerns and assisting them in the setup of Production environment including Application and Database servers.
• Maintaining strict adherence to project schedules and timelines by prioritizing multiple tasks efficiently.
• Hands on experience in designing Workflows, Sequences, Data and Web Scraping Techniques.
• Quick learner of business applications, addressing the ad hoc reporting needs of the customer and the ability to work as an individual or as a team member to accomplish project deliverables on time to meet deadlines and work under pressure with strong analytical and solution approach skills.
• Involved in the full life cycle of Agile methodology for various modules even including Design, Implementation of the Interfaces, Testing and Maintenance and ensuring the optimum utilization of the Resources.
• Extensive experience with SharePoint, Visio, Power Point, Microsoft Project, and Microsoft Office tools.
• Expertise in data governance, data stewardship, data quality, data analytics and reference data management.
• Experienced in Data Collection, Data Extraction, Data Cleansing, Aggregation, Data Mining, Verification, Reporting and Data Warehousing.
• Strong understanding of ETL, reporting, business analytics (business intelligence) and data warehouse concepts.
• Experience with reports and dashboards development for operational and analytical needs and exploring data using data visualization tools.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Worked with BI/Reporting tools such as Tableau, Crystal Reports and Quick sight, having created various Visualizations using Bar/Line/Pie charts, Maps, Scatter Plots, Heat maps and client reports.

TECHNICAL SKILLS

Databases: SQL, MySQL, MS Access

Programming & Scripting: Python, SQL

Development tools: Notepad++, Jupyter, Spyder, Python IDLE, shell scripting

Python Packages: Numpy, SciPy, Pandas, TensorFlow

Statistical software: SAS JMP

Programming skills: C, VB.Net, C++, Java, Python.

Operating System: Windows, Linux

Visualization tools: Tableau, QlikView, Power BI, SAS JMP

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Data Analyst

Responsibilities:

• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Implemented Indexes, Collecting Statistics, and Constraints while creating table.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Experience in developing business solutions by utilizing SQL, Python, and implementation of data analysis methodologies.
• Worked with data visualization tools Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 7.0, 8.0,8.3, 9.0 and 10 as data analyst.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Captures the changes for each market to create a daily email alert to the client to help make better investment decisions.
• Conducting and participating in the regular team meetings to achieve agile development of project.
• Analyzing various logs that are been generating and predicting/forecasting next occurrence of event with various Python libraries.
• Automate different workflows, which are initiated manually with Python scripts and Unix shell scripting.
• Worked on predictive analytics use - cases using Python language.
• Clean data and processed third party spending data into maneuverable deliverables within specific format with Excel macros and python libraries such as NumPy, SQL Alchemy and matplotlib.
• Used Pandas as API to put the data as time series and tabular format for manipulation and retrieval of data.
• Helped with the migration from the old server to Jira database (Matching Fields) with Python scripts for transferring and verifying the information.

Confidential, Denver, CO

Management Consultant Intern

Responsibilities:

• Operational support for Confidential acquisition of Confidential Funds for vendor side, performance management, data analytics, data visualization, reporting to Director of vendor management.
• Was responsible for Key Performance Indicators report building based on historical data, Line of business feedback, interacting with service providers (leading national banks)
• Presentations to senior management to inform the financial data results, trends and suggest improvements.
• TCO/Cost benchmarking, should-cost analysis for contracts with vendors like Citibank, JP Morgan, Deutsche Bank
• Data mining and analysis to support process improvements for managing banks and internal teams in the organization.
• Utilized Tableau to develop dashboards related to performance management on monthly and quarterly reporting.

Confidential

Category Manager - Data services

Responsibilities:

• Developed and executed day-to-day inventory analytics with respect to fulfillment, replenishment, inventory on hand, transfer activity, aged inventory reduction, forecasting, and forecast accuracy.
• Performed exploratory data analysis, generates and tests working hypotheses, and uncovers important trends and relationships.
• Performed data management through a combination of data mining, data modeling, data analysis, and/or problem analysis, while executing day-to-day processes related to area of responsibility.
• Participated in all stages of front-end and back-end web application development including but not limited to coding, testing, installation, and documentation.
• Documented business requirements, functional and system design, processes, and procedures.
• Created, analyzed, and published reporting to drive cross-functional business insights.
• Developed and maintained business tools and solutions to drive continuous improvement.
• Leveraged data analysis and statistical tools such as SAS JMP to create data forecasting and additional requests for data analysis.
• Worked on SAP T-codes and QlikView to pull data and create visualizations for executive level decision makings.
• Developed supply chain data driven approach with subject matter expertise in functional areas of procurement and supply chain.
• Worked for clients covering Qatar, U.K., Denmark, Kazakhstan, and Africa.
• Improved product delivery efficiency by 55% using customer feedback reports.
• Involved in forecast of demand of products and performed predictive analysis using SAS JMP statistical tool.
• Determined safety stock levels and need for replenishment by reviewing inventory, consumption rates, performed daily & weekly count, characteristics of items in storage, and current market conditions.
• Planned, scheduled, and monitored the inbound movement of products and services from suppliers across the supply chain.

Confidential 

Data Management Analyst

Responsibilities:

• Worked with the Business Analysts in identifying and defining the requirements.
• Involved in all phases of Software Development Life Cycle including design, development and creating test cases.
• Conduct data analysis to identify trends and lean process improvements opportunities.
• Understanding of workflow-based logic and ability to understand workflow diagram and conceptualize future state of automated solution.
• Develop automation solutions in support of various operational automation initiatives.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Assessments and cost/benefit analysis for technology enabled projects within the team.
• Monitor work processes, procedures, expenses, stakeholder management to drive organizational goals and business priorities.
• Worked with DBAs to create a best fit Physical Data Model from the Logical Data Model using Erwin.
• Interacted with clients to assess needs, identify key challenges, and define project scope & deliverables.
• Involved in developing data mapping documents for integration into a central model and depicting data flow across systems.
• Performed Verification, Validation and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor.
• Involved in performing extensive Back-End Testing by writing SQL queries and PL/SQL stored procedures to extract the data from SQL Database.
• Used Business Objects for validating the metadata and testing the data of reports.