SUMMARY

• An overall 7+ years of work experience as a Data Analyst and Business Analyst. Passionate about Business Processes and communicating insights derived from data. Well experienced in interpreting and analyzing data and presenting detailed reports to clients from various domains. Skilled in providing Business Solutions, Programming, Visualization and Problem solving.
• Good experience in Data mining with large datasets of Structured and Unstructured data, Data Acquisition, and Data Validation.
• Experienced in using Python and Power BI for data cleaning, data visualization, risk analysis and predictive analytics.
• Strong working experience with various Python libraries such as NumPy for mathematical calculations, Pandas fordatapreprocessing/wrangling, Matplotlib fordatavisualization.
• Well experienced in conducting exploratorydataanalysis to identify trends, groups, and deviations in thedatato understand thedatadiagnostics and addressing missing values.
• Strong knowledge of stored procedures,dataanalysis anddatavalidation using SQL.
• Expertise in SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub - queries from multiple tables and establishing relationships between the tables using primary and foreign key constraints.
• Extensive experience on building reports and dashboards in Microsoft Power BI by using Azure data warehouse and Microsoft Azure Analysis Services.
• Strong Knowledge and hands on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modeling and Waterfall model.
• Ability to write and communicate system descriptions and specifications for both technical and non-technical audience.
• Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision.
• Competent, confident and strategic decision maker organized with effective Time Management and Prioritizing skills in conflicting demands to execute business objectives.

TECHNICAL SKILLS

Programming Languages: Python (Numpy, Pandas, Scipy)

Databases: SQL, MySql, NoSQL

Data Visualization: Power BI, Matplotlib

Data Mining, Cleaning and Munging:

Machine Learning: Regression, Classification, Clustering

Microsoft Office Suite: Excel, Word, Access

Soft Skills: Communication, Critical Thinking, Problem Solving

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

SQL DATA ANALYST

Responsibilities:

• Responsible for building complex reports and dashboards in Power BIfrom scratch
• Performing Data cleaning process using Python and SQL
• Manage views and queries from multiple databases into Microsoft Power BI
• Interpret data, analyze results using analytical techniques and provide ongoing reports
• Implemented the use ofPythonlibraries (NumPy and Pandas) in Jupyter notebooksin order to clean, merge and compile data from various data sources
• Used Pandas dataframes to address Duplicate and Missing data in large datasets
• Design and development of SQL Data Model to satisfy the end user reports by creating different types of Reports and Dashboards inPower BI
• Build and maintain SQL scripts and complex queries fordataextraction for analysis and preparation of ad-hoc reports
• Involved withdatamodel and reporting requirements for Power BI Reports with theDatawarehouse/ETL and Reporting teams
• Responsible for Scheduling jobs for weekly, daily data refresh on differentPower BIreports

Confidential, Newark, NJ

BUSINESS DATA ANALYST

Responsibilities:

• Designing work flows and developing a roadmap for migration of various products of Prudential
• Used Python Pandas for doing the exploratory data analysis
• Assess the effectiveness and accuracy of new data sources by analyzing the data using Python libraries
• Extensively used SQL for writing complex queries and extracting the data
• Weekly meetings with the Acquia Team to discuss about critical decisions, key recommendations and requirements that will assist in the delivery of planning and vision of Confidential ’s project goals
• Documenting Information on - Best practices for content workflows, Best practices compliance, Integration solution with existing applications and High-level Drupal module recommendations
• Identifying the Risks, Dependencies and Mitigation
• Establishing a Migration methodology plan that includes various phases - Analysis, Mapping, Development and Launch
• Worked with business requirementsanalysts/subject matter experts to identify and understand requirements and conducted user interviews anddataanalysis review meetings

Confidential, Sunnyvale, CA

TECHNICAL BUSINESS ANALYST

Responsibilities:

• Ensuring that the platform supports specific Business functions - Customers, Orders, Fulfillment, Reporting, CRM
• Communicating with external API gateways via REST API to support Payments, Rx-PWN, USPS, Netsuite, Refunds
• Translate business requirements into functional requirements for development and QA teams
• Designing and developing Activity Diagrams, Process Maps and Sequence Diagrams using MS Visio
• Communicating client's business requirements by constructing easy-to-understand data and process models
• Creating Use Cases, Use Case Diagrams, User Stories,Business Flow Diagrams, Activity Diagrams and other related UML diagrams
• Documenting Test Cases, reviewing and maintaining Test Scripts, analyzing bugs, interaction with team members in fixing errors and User Acceptance Testing (UAT)
• Assisted the Quality Team in designing the Test Plans, Test Scenarios and Test Cases
• Developed requirement traceability matrix for recording the requirements
• Participating in sprint planning, daily stand up, reviews and retrospective meetings
• Elicit, analyze and document clear, concise, detailed business requirements
• Utilizing JIRA Project Management Tool to manage and track sprints, epics, stories, issues, and bugs

Confidential, DeKalb, IL

DATA ANALYST

Responsibilities:

• Populating all the Census data for the state of Illinois on Illinois Data Website
• Helped generate a PDF report of the relevant data for all 10 Enterprise Zones
• Developing complex database objects like Stored Procedures, Functions and Triggers using SQL
• Creating indexes on the tables for faster retrieval of the data to enhance database performance
• Collecting and interpreting data
• Ran complex queries to retrieve data and ad-hoc reports from multiple tables within SQL
• PerformingDataValidation/DataReconciliation between disparate source and target systems for various projects
• Build and maintain complex SQL scripts for both Production and Development environments
• Involved in extensivedatavalidation using SQL queries and back-end testing
• Created and reviewed mapping documents based ondatarequirements
• Used Excel spreadsheets to manipulate numericaldataand formulas
• Prepared the validation scripts to compare the newdatawith legacy systems

Confidential

DATA ANALYST

Responsibilities:

• Successfully interpreted data to draw conclusions for managerial action and strategy
• Manipulating, cleansing & processing data using Excel, Access and SQL
• Acquiring data from primary or secondary data sources and maintaining databases
• Proposed solutions to improve system efficiencies, thereby reducing total expenses
• Created interactive dashboards and reports for teams within the organization
• Locate and define new process improvement opportunities
• Resolving the Abends encountered during batch processing
• Making corrective action enhancements to improve the Performance of production system
• SLA Tracking & Generating status reports of all the applications
• Making Permanent fixes for repeated Abends and monitoring Production box
• Generating various reports, viz. system performance reports, EOM logs, etc