SUMMARY

• Overall, 5+ years of Professional IT experience as a Data Analyst. Excellent analytical and problem - solving skills in developing and implementing innovative business processes and providing system solutions using new approaches.
• Experienced working as a Business Analyst in various roles and functions including System migration, Python, Use Cases, Data and BI integration, Data Mapping, Reporting, Project Management, Documentation, Testing, Agile methodology, user story creation, Data Validation.
• Experience writing complex queries for data analysis, report generation and data validation on SQL Server database along with performance tuning activities.
• Excellent conceptual and technical skills to create Business Requirements Document, Functional Specifications Document, Process Flow Diagram, and Detailed Design Document.
• Proficient in design and execution of Test Strategy, Test Plan, Test Scenarios, and Test Cases based on the requirements for the applications.
• Experience with working in a Data governance/Data management or Data quality program.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Experience in working with large volumes of Data using SQL, Tableau, and Python.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Experience in Data Management like Data Sourcing, Staging, Transformation and Publication.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau.
• Strong Experience in Performing data analysis and data profiling using complex SQL on various source systems including Oracle and Microsoft SQL.

TECHNICAL SKILLS

Programming Languages: SQL, Python 3.

RDBMS: SQL Server, MySQL.

Reporting Tools: Tableau 8.1, 8.3,9.0,2019.4, Power BI.

Other Tools: XML, JIRA, Share point.

Packages: MS-Office, Excel, Power point.

Methodologies: Agile Methodology, Water flow methodology.

Operating System: Windows, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, IL

Data Analyst

Responsibilities:

• Used Python to implement various API’s to download multiple reports from various sites.
• Automated the complete process of downloading the reports using SA 360 API’s, Google Ads API’s and Facebook API’s and upload the same into SQL Server for data comparison using Python.
• Developed various queries and procedures to analyze the data and generate reports for business needs.
• Conducted requirement sessions, identifying business needs, getting sign-off on requirements and capturing requirements
• Involved in pre-planning meetings, demos and daily stand ups.
• Wrote test cases and test scripts for theUser Acceptance Testing (UAT).
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design.
• Worked with various teams to prepare Project plan.
• Tracked daily issues and dependencies and coordinated with common team to work on the impediment list.
• Created Technical design documentation and runbooks for deployments of Developed code.
• Writing queries using SQL and T SQL for data validation on SQL Server DB.

Confidential, TX

Business and Data Analyst

Responsibilities:

• Followed AGILE methodology viz.Scrum throughout the project.
• Writing complex queries for data analysis, report generation and data validation on SQL Server database along with performance tuning activities.
• Re-factor Epics to Stories and maintain theprioritized Sprint backlogs
• Conducted requirement sessions, identifying business needs, getting sign-off on requirements and capturing requirements.
• Facilitated pre-planning meetings, demos and daily stand ups.
• Wrote test cases and test scripts for theUser Acceptance Testing (UAT).
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Tracked daily issues and dependencies and coordinated with common team to work on the impediment list.
• Creation of data mapping documents.
• Used SQL skills including complex queries, unions, multi-table joins etc to build and Run SQL queries to identify data issues, data fixes, and validate new and existing data.
• Perform research, data collection, quality assurance and analysis.
• Experience in analysis of source systems to uncover erroneous, duplicate data and integrity issues related to the data.

Confidential, FL

Data Analyst

Responsibilities:

• Conducted assessment to ensure data quality and completeness with validation techniques.
• Designed and developed continuous outcomes reporting for multiple programs.
• Created and executed SQL scripts to validate, verify and compare the source data to target table data.
• Created and loaded temporary staging tables for Data validation and to enhance performance.
• Performed data analysis and data profiling using complex SQL on various source systems including Oracle.
• Involved in identifying the Data requirements and creating Data Dictionary for the functionalities
• Created Stored Procedures, Triggers, view, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Performed detailed requirement analysis and created data mapping documents
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Working on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Wrote multiple SQL queries to analyze the data and presented the results using Excel and Tableau reports.

Confidential

Data Analyst

Responsibilities:

• Gathering user requirements analysis and designing software solutions based on the requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Provided assistance for health care projects using different software tools.
• Assisted in development of Data formatting and cleaning criteria from various data sources.
• Created and analyzed reporting within Tableau based on the business requirement.
• Writing complex statistical calculations for report and performing future predictive analysis using tableau.
• Extensively used advanced chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Defined best practices for Tableau report development and effective use of data blending and data joining features in tableau.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server using TABCMD.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards
• Strong SQL skills including complex queries, unions, multi-table joins.
• Experience in back-end server programming, web services, micro services to integrate with UI and databases.
• Performed Gap analysis by identifying existing systems, documenting the enhancements to meet the end state requirements.
• Created dashboards and reports for ad-Hoc Reporting.