Business/Data Analyst Resume

PROFESSIONAL EXPERIENCE

Business/Data Analyst

Confidential

Responsibilities:

Developed and Automated daily ETL and reporting tasks using SQL, SSIS and Tableau reducing 25% of the employee’s workload
Maintained the data quality of multiple databases in SQL Server database and validated the data to ensure accuracy in the output, generated descriptive statistics and extracted insights
Reduced manual efforts for data retrieval to 40% by coding and managing SQL stored procedures, functions and views
Developed robust dashboards with critical KPI’s on several platforms, including Excel and Tableau by creating data extracts and scheduled weekly/monthly distribution of reports to stakeholders
Developed and automated reporting for Monthly customer subscription renewals which accounts for more than 80% of Platts revenue
Became the go - to person for colleagues who faced issues on reporting automation or data analysis.
Acted as a lead for various Data cleaning projects on Salesforce. Utilized SQL, Tableau, and custom reports to create scenarios and defined the scope of data cleaning activities like de-duping on enterprise-wide production environment
Interviewed key stakeholders from Business units like Sales, Marketing, Contract support, Finance etc. to identify business, functional and technical requirements for Salesforce Platts (CRM-e) platform
Product ownership along with Product owners which included SME interviews, product research, current state and future state journey mapping, feature ideation, product roadmap, MVP prototyping and User testing
Developed detailed crisp use-cases, test-scripts, documentation and ran deep dive data analysis for User Acceptance testing (UAT) sessions to debug any errors and push workflows into production
Evaluated, prioritized and sequenced the product backlog based on business value and/or ROI
Rendering client satisfaction by having constant interactions with the business stakeholders in understanding and catering to their technical specifications. Involved in Sprint planning sessions as part of Agile methodology and oversee activities in VSTS dashboard

Financial Transactions Data Analyst

Confidential

Responsibilities:

Load, analyze and normalize trading data for 400+ clients using Oracle SQL Loader, Toad and ETL process
Deciphered and interpreted patterns and information in consolidated databases using data mining techniques to maximize settlement recoveries
Identified key data points and metrics, and developed queries to examine data quality issues
Determine eligibility of trades in multi-million-dollar securities class action lawsuits by assessing data quality, detecting patterns, performing gap analysis, and identifying unrelated information
Provided trend and variance analysis by using visualizations on Tableau and identified causes for shifts in Metrics

Data Analyst/Consultant

Confidential

Responsibilities:

Defined and implemented the AWS data pipeline to configure data loads from Sprint’s Data Warehouse to Amazon S3 and Amazon Redshift
Developed data pipelines using ETL and reporting tasks using Microsoft SQL server and SSIS
Improved runtime of existing SQL queries by 20% with maintaining code architecture to ensure smoothness and completeness of operations
Automated reports generation for the Revenue Assurance team at Sprint to track data inconsistencies using Alteryx
Collaborated with global teams to troubleshoot & resolve inconsistencies in wireless mobile data quality and reports
GAP analysis to find the root causes for revenue leakages worth $5 million for 6 million subscribers

Data/Business Analyst Intern

Confidential

Responsibilities:

Designed ETL(SSIS) processes to develop jobs for extracting, transforming and loading data using workflow manager
Optimized and tuned database up to 30% by creating clustered and non-clustered indexes
Designed web scraping system using Python to pull HTML data and convert it to temporally sorted, tabular data
Performed deep-dive analysis of Minority/Women Business Enterprise (MWBE) data through SQL and Tableau/Power BI to enable comparative insights among business domains. Perform market assessment and comparative analysis to create process documentation. These contributions led to:

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship