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 noledge 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 teh 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 TEMPeffective 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 teh 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 teh 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 teh exploratory data analysis
• Assess teh TEMPeffectiveness and accuracy of new data sources by analyzing teh data using Python libraries
• Extensively used SQL for writing complex queries and extracting teh data
• Weekly meetings with teh Acquia Team to discuss about critical decisions, key recommendations and requirements dat will assist in teh 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 teh Risks, Dependencies and Mitigation
• Establishing a Migration methodology plan dat 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 dat teh 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 teh Quality Team in designing teh Test Plans, Test Scenarios and Test Cases
• Developed requirement traceability matrix for recording teh 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 teh Census data for teh state of Illinois on Illinois Data Website
• Helped generate a PDF report of teh relevant data for all 10 Enterprise Zones
• Developing complex database objects like Stored Procedures, Functions and Triggers using SQL
• Creating indexes on teh tables for faster retrieval of teh 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 teh validation scripts to compare teh 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, theirby reducing total expenses
• Created interactive dashboards and reports for teams within teh organization
• Locate and define new process improvement opportunities
• Resolving teh Abends encountered during batch processing
• Making corrective action enhancements to improve teh Performance of production system
• SLA Tracking & Generating status reports of all teh applications
• Making Permanent fixes for repeated Abends and monitoring Production box
• Generating various reports, viz. system performance reports, EOM logs, etc