Data Analyst

Data Analyst

Bharathi

Email: *******************@*****.***

Phone: +1-678-***-****

PROFESSIONAL SUMMARY

Over 5+ years of IT experience in Data Modelling, Data Analysis, Visualization, and Reporting.

Excellent understanding of Agile and Scrum development methodology.

Extensive expertise in Database Design, Development, Implementation, and Administration using SQL Server with a focus on ETL/Business Intelligence solutions using Microsoft components.

Proficient in implementing Microsoft Business Intelligence (BI) platforms, including SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).

Skilled in Python development, including pandas, for decoding SAS scripts and migration to Python for various reports.

Experience converting Teradata SQL scripts to Snowflake SQL scripts, optimizing code, and improving efficiency in databases.

Developed and implemented BI solutions utilizing Tableau, SQL, and R for forecasting analysis and reporting.

Hands-on experience with Power BI Desktop, Power BI Service for calculated columns/measures.

Expertise in database object creation, optimization, performance tuning, and data integrity using SQL Server and T-SQL.

Experience in creating Power BI reports and Dashboards using Power BI Desktop & Web Interface.

Developed and implemented BI solutions utilizing Tableau and SQL.

Proficient in ETL design/development using SSIS, data extraction, and transformation between multiple data sources (Oracle, MS Excel).

Experienced in report generation using XML, SSRS, Tableau, and Excel spreadsheets.

Developed web-based applications using Python, HTML.

Strong statistical programming skills in Python and R, data analysis, and data visualization.

Experienced in Python and R to manipulate data for data loading and extraction. R packages for data analysis.

Worked with complex applications such as R.

I am skilled in data wrangling, data visualization, and reporting using Python, Tableau, and Power BI.

Very strong knowledge of Amazon Web Services (AWS) and Google Cloud Platform (GCP) for building and managing Data Lakes for analytics.

Excellent communication skills and ability to translate complex data insights into actionable recommendations for business stakeholders.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, R and Python.

Statistical Software: BI Server Base SAS, SAS Enterprise Guide and SAP. Databases: MS Access, Oracle, SQL Server, DB2

Software Packages/Tools: MS Office (Word, Excel, PowerPoint), SQL Navigator, Tableau, Microsoft Power BI, Spark.

Operating Systems: Windows, DOS, UNIX.

Web Technologies: HTML

Visualization tools: Tableau, Power BI.

PROFESSIONAL EXPERIENCE:

Rotomaker Jul 2020 – Jan 2022

Role: Data Analyst II

Responsibilities:

Conducted extensive data validation using complex SQL queries and performed back-end testing, addressing data quality issues.

Developed and maintained a high-level data strategy aligned with Data Warehouse Standards and organizational strategy.

Developed dashboards in Tableau and present data to track KPIs and product performance using data from various sources such as MS Excel, AWS S3, and XML.

Developed ETL processes and transformation standards using Data Stage best practices.

Connected Tableau to Database for real-time analytics and utilized various transformations like Source Qualifier, Lookup, Router, etc.

Collaborated with developers on Python applications for RISK management for Google Analytics aggregation.

Designed and maintained MYSQL databases and created pipelines using user-defined functions and stored procedures for daily reporting tasks.

Developed Python applications for graphics, XML processing, data exchange, and business logic implementation.

Created and documented mappings according to design documents and mapping specs.

Generated data extractions, summary tables, and graphical representations in SAS, Excel, R, and PowerPoint.

Used Python scripts for database content updates and file manipulation.

Applied advanced classification models such as train data using Python packages.

Have created data visualizations and reports based on data using tools like Power BI.

Streamlined reporting, improved office processes, and made strategic recommendations based on data analysis.

Utilized data blending, filters, actions, and Hierarchies features in Tableau for effective visualization.

Developed interactive dashboards and storytelling dashboards in Tableau Desktop and published them on Tableau Server.

Created Source-Target SQL scripts for transformation rules and utilized IBM DB2 Utilities for database object creation and data import/export.

Involved in analyzing client data requirements between various Benchmark Data Providers, leveraging Data Hub and Alpha technology.

Built and implemented strategies using Data Hub and Alpha to migrate clients off legacy benchmark services onto next-generation solutions.

Implemented Data Hub and Alpha systems to manage reconciliation and support for benchmark indices across multiple platforms.

Managed Data Hub and Alpha technologies to support future Data Service Benchmarks enhancements.

Analyzed data from various sources using complex SQL, and data mining techniques, and performed data profiling.

Used Teradata SQL Assistant, Administrator, data load/export utilities for batch processes on UNIX/Windows environments.

Environment: Power Designer, PL/SQL, Oracle, SQL/PL, Python, Navigator, UNIX, Microsoft Access, Teradata, R Scripting, Teradata SQL Assistant, Microsoft Visio, IBM DB2, SQL Server, Tableau, MS PowerPoint, MS Access, Microsoft Excel.

Rotomaker Mar 2017 – Jun 2020

Role: Data Analyst

Responsibilities:

Developed calculations to measure NPS, Financial Confidence, and product usage. Responsible for analytical support for Credit and Marketing initiative strategies.

Analyzed Operational Risk datasets to identify key risks and documented actions required to address each risk.

Designed and automated interactive KPI dashboards in Tableau that enabled business users and executives to explore product usage and customer trends.

Created custom SQL queries on various databases such as Teradata, MySQL and DB2 for data analysis and data validation.

Performed data profiling and analysis on various datasets like customer profile data, branch hierarchy, contact history and email campaign data.

Designed and executed A/B testing and maintained reports for both ad-hoc and ongoing business operating needs.

Prepared dashboards with drill-down functions such as date filters, parameters and actions using Tableau to reflect the data behavior over time.

Involved in ETL processes to handle data migration from multiple business units and sources including Oracle, MSSQL and Access.

Worked on providing end-to-end Web Analytics services from reporting, analysis, business strategy

(optimization) and implementation.

Involved in analyzing client data requirements within ADS and Data Service frameworks, utilizing Data Hub and Alpha technology for efficient data management.

Utilized SQL automations within Data Hub and Alpha environments to validate, cleanse, and enrich data, ensuring accuracy and reliability within ADS and Data Service contexts.

Acted as the primary liaison between data vendors and clients within the ADS and Data Service frameworks, resolving issues and optimizing data flow using Data Hub and Alpha capabilities.

Managed ADS and Data Service projects to support future enhancements and advancements, leveraging the full potential of Data Hub and Alpha technology.

Collaborated with cross-functional teams to contribute to the evolution of Data Service offerings, integrating ADS and Data Hub and Alpha expertise for continuous improvement. Environment: Teradata SQL Assistant, Tableau, Python, MS Excel, MS PowerPoint, Google Sheets, ETL

Contact this candidate