SUMMARY

• Data Analysis professional with a Master’s degree in Management Information Systems and 7+ years of experience in handling large - scale IT projects in SQL/Teradata, Tableau reports, Unix shell scripting and 2+ years of experience in AWS cloud services which includes SnowSQL/Redshift.
• Highly skilled in writing complex SQL scripts and scheduled tasks using cron jobs.
• Hands-on experience in migrating 100’s of tables and scripts from Teradata to SnowSQL.
• Developed AWSync module in python, which exports giga bytes of data to S3 and also clones the dataset in platforms like Hive and Redshift.
• Proven experience in performing Data Retrieval, Data validation, Data integrity, Data Quality checking before delivering data to operations and business.
• Hands on experience in writing shell/bteq/python scripts and automating in unix.
• Developed and conituously providing support and enhancements to the most extensively used product like Micro-Market Monitoring(M3) which helps the senior leadership and executives to take crucial descisions.
• Single handedly worked on end to end implemention of M3 which involves 100’s of tables and more than 1TB of data.
• Highly experienced in building, publishing customized interactive reports and dashboards from various data sources and servers, report scheduling using Tableau Server.
• Have good experience in working in EMR/EC2 and writing queries in Hive, Presto, Spark etc.
• Improved the performance and efficiency of navigating through the tableau reports and extracting the data which connects to multiple data sources and pulls GB’s of data. Worked on all aspects of engineering of the service like performance, testing, dashboard design and tuning.
• Strong communication skills to complement requirement elicitation, requirement analysis, requirement management & communication, enterprise analysis, solution assessment & validation, status-reporting, issue escalation/remediation and stakeholder meetings.
• Performed proof of concepts and provided training on tools like AWSync and other in-house developed tools.

TECHNICAL SKILLS

High-level languages: SQL, Python, Teradata SQL, SnowSQL

Cloud Technologies: Amazon Web Services (EC2, EMR, S3, Redshift, Presto, Hive)

Environment: s: Unix and Windows

Data Visualization: Tableau, MS-Excel

RDBMS: Oracle, Teradata

Database Tools: Oracle SQL Developer, Teradata SQL Assistant, Snowflake

Tools: Putty, SAS, Nebula, Okera(Cerebro), AWSync

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Data Analyst

Responsibilities:

• Developed Tableau dashboards with various complex worksheets that help the market planners, regional executives take important decisions on branch transformations.
• Developed and continuing to provide support to the most widely used data product “Micro Market Monitoring” which involves loading and extracting >1TB of data, creating complex reports which provides data analysis in every dimension.
• Developed python script to load the Excel data to Snowflake tables as a ETL process.
• Worked on creating Python scripts to automate the Teradata scripts.
• Worked Extensively with Teradata, Tableau and AWS (EMR, EC2, S3, Redshift, Hive, Presto, Spark) and Snowflake.
• Added the Teradata Fast Export module to the AWSync tool written in python to export Teradata tables to the cloud.
• Developed Teradata scripts to update the data infrastructure that feeds the Tableau reports.
• Worked with SAS as an ETL tool to extract and load the data into Teradata table from excel data sources.
• Performed Performance Tuning for Tableau refresh, which extracts close to 37 billion records.
• Worked on migrating Teradata tables and bteq scripts to Snowflake.
• Developed and automated bteq scripts with Unix commands and Teradata SQL queries embedded to update the data infrastructure as part of monthly scheduled processes.
• Performed testing for data products (Tableau reports and Teradata data infrastructure).
• Created user guide documentation for all the data products.
• Provided training regarding some of the tools like Nebula and AWSync.
• Developed proof of concept to replicate the processes and reports using cloud technologies.
• Lead the data Correction and validation process by using data utilities to fix the mismatches between different shared business operating systems.
• Performed Data Quality and Data Modeling.
• UtilizedTeradataSQL queries to collect and evaluatedataelements fromdataproviders to ensure quality ofdata, and translate thedatainto reports for marketing department.
• Verifying data quality after every deployment and perform extensive analysis for the data variance pre and post implementation.

Confidential, Charlotte, NC

Principle Data Analyst

Responsibilities:

• Interacted with the Senior Leadership Team to gather Business Requirements for the data product and worked on developing the data product.
• Involved in data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide the analysis to development/bug fix team.
• Proper analysis of data included identification and enforcement of standards to ensure consistent and maintainable queries and reporting SQL data through Excel.
• Followed department SDLC methodology and development procedures.
• Created Fast Export scripts for extracting and formatting customer data from data warehouse.
• Developed modules to extract, process & transfer the customer data using Teradata utilities.
• Developed ETL jobs with mappings, sessions, and workflows to extract/load data from/into diverse source/target systems like Teradata, Oracle and Flat Files.
• Developed and automated bteq scripts with Unix commands and Teradata SQL queries embedded to update the data infrastructure as part of monthly scheduled processes.
• Handled logical and/or physical mapping of flat files and SQL Server database source files toTeradatadatabase target.Maximized integration ofdatafor analysis and reporting.
• UtilizedTeradataSQL queries to collect and evaluatedataelements fromdataproviders to ensure quality ofdata, and translate thedatainto reports for marketing department.
• Worked on data concepts such as data quality and data modeling for feeding the data to the data products to avoid data issues.

Confidential, Lexington, KY

Data Analyst

Responsibilities:

• Built Couple Custom SQL reports to monitor the Loss Data and had to alert the business if the Threshold value is exceeded or any unforeseen exceptions occur.
• Had to come up with Mock ups & design for Tableau for reporting requirements including sharing the join & filter conditions.
• Responsible for creating and designing views, SQL, PL/SQL to determine the optimal access and relationship between the data objects.
• Responsible for requirement elicitation & documentation, impact analysis and obtaining the approvals from the required business partners.
• Played Instrumental in providing design to ETL Team for Unique ID creation and Delta processing based Source data profiling
• Responsible for Root Cause analysis and day to day Source data rejects in ETL load to warehouse and had provided permanent resolution.
• Responsible for task prioritization; created task WBS to prioritize and assign the tasks to the team members.
• Managed and directed efforts of project leads and developers to ensure effective planning and synergy among project teams.
• Responsible for validating the Business object reports by comparing the output with SQL query output (Built based on for the report intent).
• Responsible for creating user acceptance documents and review the same with business sponsors and stakeholders.
• Worked with the project sponsor to create and maintain work pipeline and forecast for the project IT team.
• Review of system test plan and UAT test plan for ETL, Oracle & Teradata.
• Responsible and accountable for understanding the ASIS process and creating the process map capturing the current and future state of the process.
• Preparing a process overview for individual processes which is simple to understand and is used to train the new person taking the responsibility in the process.

Confidential

Data Analyst

Responsibilities:

• Managed relationships with established key accounts and developed new accounts.
• Created internal processes & procedures to ensure delivering account specific commitments.
• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Analyzed information flow from source system through reporting and analysis. Proactively managed the availability and quality of data and information needed to grow the business.
• Analyzed report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.
• Creating Summary Reports and Tabular Reports.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Created Teradata objects like Tables and Views.
• Used Joins like Inner Joins, Outer joins while creating tables from multiple tables.
• Monitoring the existing code performance and change the code for better performance.