Data Analyst Sql Server

Ranta Kumar

Sr Data Analyst / Business Intelligence / Report Developer

PH: 202-***-**** ******@*****.***

OBJECTIVE: Experienced Data Analyst and BI Developer with over 12 years of expertise in SQL Server, SSIS, and 10 years in data visualization using Tableau. Seeking a challenging role to leverage strong skills in SQL, Tableau, and data warehousing to drive data-driven decision-making and deliver impactful business insights. Adept at designing and implementing end-to-end BI solutions, from data integration to dashboard creation, with a focus on optimizing performance and ensuring data accuracy.

SUMMARY

Data Analyst and BI Developer with 12+ years of SQL Server and 10+ years of Tableau expertise. Adept at delivering impactful BI solutions in both on-site and remote environments. Skilled in:

●Advanced SQL querying, stored procedures, and optimization

●Interactive Tableau dashboard creation and data visualization

●Full BI lifecycle management, including SSIS and SSRS

●Data warehousing, ETL processes, and data modeling

●Performance tuning and data quality best practices

●Cross-functional communication and team leadership

Experience spans fintech and healthcare sectors, including Medicare/Medicaid systems.

TECHNICAL SKILLS

●Languages: Python, R. SQL, TSQL, C/C#, VBA, COBOL

●Databases: SQL Server, Oracle, SAP HANA, Teradata, MySQL, MS Access, A

●Tools: Tableau, Alteryx, Power BI, Business Objects, Crystal Reports

●Technologies: ASP.Net, HTML/XML, MS Visual Studio, MS Office, SharePoint

●Operating Systems: Windows, Unix/Linux, DOS

EXPERIENCE

Cisco, San Jose

Sr. BI Analyst/Tableau Report/SQL Developer Oct 2018 – May 2024

●Designed and implemented 50+ interactive Tableau dashboards, integrating data from multiple sources (SQL Server, SAP HANA, Oracle, Teradata, Salesforce), providing real-time insights into key business metrics.

●Managed end-to-end monthly TSS (Technical Sales Services) data processing and reporting, automating workflows that reduced manual reporting time by 40% and data accuracy.

●Developed complex SQL queries, stored procedures, and views across various database platforms to support data extraction, transformation, and loading (ETL) processes.

●Led training sessions for 100+ team members on Tableau best practices and advanced features, fostering a data-driven culture and improving overall team productivity.

AIG, Houston, TX

BI Analyst/Tableau Report/SQL Developer May 2017 - Oct 2018

●Automated global year-end compensation reporting using Tableau and complex T-SQL queries, reducing processing time by 40% and improving data accuracy for critical financial analyses across multiple departments.

●Designed and implemented interactive dashboards integrating data from diverse sources (SQL Server, Oracle), enabling real-time visualization of key performance indicators and facilitating data-driven decision-making for senior management.

Clorox, Pleasanton, CA

SQL/BI Analyst/Developer May 2016 - Dec 2017

●Migrated country-specific data reports to QuickBase and developed comprehensive Tableau dashboards, improving data accessibility and enabling real-time analysis across multiple international markets.

●Designed and implemented automated data processes using SQL and VBA, creating efficient user interfaces for data handling and reducing manual data entry errors and processing time.

Southwest Airlines, Dallas, TX

BI Analyst/Tableau Report/SQL Developer Jul 2015 - Jun 2016

●Enhanced reporting systems by migrating from MS Access to Tableau and Power BI, while optimizing complex SQL queries and stored procedures, resulting in a 30% reduction in query execution times for critical reporting systems.

Southern Wine & Spirits, Miramar, FL

ETL Developer/Report Developer Jan 2015 - Jun 2015

●Developed a national pricing dashboard tool using Tableau and SQL, automating data integration from multiple sources and significantly improving pricing analysis efficiency.

Fannie Mae, Washington, DC

QL, Hyperion EPPM, MS Access Developer Jan 2014 - Nov 2014

●Implemented automation tools for financial reporting and analysis using SQL and VBA, integrating multi-platform data to enhance reporting accuracy and timeliness.

General Motors, Warren, MI

Senior Reporting Developer/Tableau/MS Access VBA Feb 2012 - Dec 2013

●Created complex Tableau reports and dashboards for prototype tooling and cost analysis, leveraging advanced SQL queries and stored procedures to optimize data retrieval and processing.

BD (Becton, Dickinson and Company), Franklin Lakes, NJ

Data Analyst/SQL, Sr. MS Access Developer Mar 2011 - Dec 2012

●Developed and implemented a process database tool for program effort planning and capacity management, utilizing SQL and VBA to automate data integration from multiple sources.

Pension Benefit Guaranty Corporation (PBGC.), Washington, DC

Programmer/Developer/Analyst Oct 2009 - Jan 2011

●Designed and developed pension plan automation tools using MS Access and Oracle, implementing complex SQL queries and data validation procedures to ensure data integrity and accuracy.

ADDITIONAL EXPERIENCE

●Programmer Analyst, Citi Group

●Programmer Analyst, Fannie Mae

●Programmer Analyst, Mayor's Office, Government of DC

EDUCATION

●Bachelor of Science, Calcutta University, India

Contact this candidate