Master Data Analyst Resume
Richmond, VA
PROFESSIONAL SUMMARY:
- Over 12+ years of extensive hands on experience on Teradata Utilities like BTEQ and SQL Assistant.
- More than two years hands on experience with the AWS environment.
- Developed Python scripts that download and upload files from AWS S3 buckets and run on EC2 servers.
- Used Pandas packages to parse Xlsx/CSV/raw file formats and download / upload data into snowflake for Data Analytics and reporting.
- Using Shell/Perl/Python programs, automated the process of combining data from multiple databases for data validation.
- Worked on developing monthly/weekly business critical reports for performance monitoring and analysis.
- Performed in depth analysis of data and prepared weekly, biweekly, monthly reports using MS Excel, MS Access, SQL, PL/SQL, SAS, Business Objects, Tableau and UNIX.
- Used UNIX shell scripting to modify existing scripts, checking daily logs for automating backup procedures.
- Thorough grasp of Teradata RDBMS Architecture and concepts.
- Experience in implementing Business Intelligence and data warehousing solutions using Tableau, Business Objects, Crystal report, Crystal XCelsius, Central Management Console (CMC), BI Launch Pad and Information Design Tool.
- Strong Knowledge and experience in software development life cycle (SDLC) including requirement analysis, design, development, support & maintenance for Business Intelligence applications.
- Skilled in determining business/technical requirements and specifications for complex application development projects.
- Ability to grasp complex business and technical applications and contribute to design, implementation and testing.
- Able to communicate effectively with multifunctional teams, programmers and technical staff at all levels.
- Design, Develop & Test complex Business Objects Universes with features like Aggregate Awareness, Contexts, Pre - Defined Conditions, Cascading Prompts, Outer Joins & Complex metrics.
- Excellent Communication and Problem-solving skills, Self-motivated, Ability to learn and apply new technologies, highly committed to responsibilities, ability to work independently as well as in teams.
- Good Analytical and documentation skills.
TECHNICAL SKILLS:
Reporting: Business Objects XI R4/R3/R2 (Designer, InfoView, Xcelsius, Live OfficeDesktop Intelligence, Web Intelligence), Tableau
Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake schema, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 3.5, Oracle Designer, Visio
Databases: Teradata (12.0, 13.0, 15.0), Oracle, MS SQL Server 2005, MS Access
Programming: UNIX Shell scripting, SAS, SQL, PL/SQL, SQL Plus, ANSI SQL, C, VBVB.Net, Python, Apache Spark, Hive
Frameworks & IDE Tools: SQL Assistant, TOAD, SQL Server Management Studio, Oracle SQL Developer, Pycharm, DBVisualizer Pro
Others: MS Office Suit (Word, Excel, Power Point), BTEQ, TPump, AlteryxDatabricks
PROFESSIONAL EXPERIENCE:
Confidential, Richmond, VA
Master Data Analyst
Responsibilities:
- Performed Discovery/Requirement/Development for CECL financial disclosure reporting project for COAF LOB.
- Worked closely with business in requirements phase of the CECL project and developed complex queries that pull balances based on the Delinquency and FICO buckets and grouped by Vintage from Snowflake Datawarehouse.
- Developed Python scripts/solutions that will connect to snowflake and execute queries and generate reports in CSV/Xlsx formats.
- Used Pandas packages to parse Xlsx/CSV/raw file formats and download/ upload data into snowflake for data analytics and reporting.
- Involved in various projects with business teams (data stewards) gathering requirements, performing analytics and providing data quality results after analyzing the data.
- Build quantum workflows as part of the CECL project.
- Wrote complex SQL queries including JOINS, nested sub queries, CASE statements to pull data from Snowflake.
- Developed business critical reports using Snowflake, Databricks and Tableau.
- Performed data management, including creating Snowflake SQL reusable code for various business as usual (BAU) reports.
- Migrated the scripts from SQL Server to Snowflake.
- Wrote SQL Testing scripts to validate migrated data from SQL Server to Snowflake.
- Involved in various projects such as Auto Securitization and OCC MRA Phase II testing using snowflake.
- Worked on data analysis and Ad Hoc reporting to assess the performance of various processes.
- Wrote optimized SQL queries to pull required data for further reporting.
- Analyzed and implemented code and table changes to improve performance and enhance data quality.
- Created several reports with key metrics for monthly business reviews.
- Assisted business customers in pulling the required data for analysis.
- Used Tableau and designed various charts and tables for data analysis and creating various analytical Dashboards to showcase the data to business customers and managers.
- Worked in an Agile environment.
- Used Databricks on numerous Ad Hoc data pulls for business analysis.
- Used Spark SQL in databricks to perform transformations after reading data from AWS S3.
- Maintained the data integrity during extraction, manipulation, processing, analysis and storage.
- Engaged with the Data Steward team to promote scripts into Production.
- Used python programming to combine data from multiple databases and Excel.
- Used Nebula to create metadata information as part of data migration and management.
- Coordinated with the Business Owners to outline Business Requirements for various projects such as CECL.
Confidential, Richmond, VA
Master Data Analyst
Responsibilities:
- Used Teradata Utilities like BTEQ, Teradata SQL Assistant, SAS, UNIX Scripting, Excel and Tableau.
- Worked on Script remediation of the FHLB process to improve performance and reduce the time spent running that process.
- Coordinated with the Business Owners to outline Business Requirements for Travel and Expense Project.
- Based on business needs extracted relevant data to facilitate desired customer communication.
- Big data analytics with Hadoop, HiveQL and Spark SQL.
- Wrote optimized SQL queries to pull required data for further reporting.
- Designed and developed weekly, monthly reports related to the Travel and Expense project using Teradata SQL.
- Designed and developed Ad-hoc reports as per business analyst, operations analyst and project manager data requests.
- Used VLOOKUP and pivot table functions in Excel for validations.
- Designed and developed various analytical reports from multiple data sources using Tableau Desktop.
- Developed Tableau dashboards and reports for validations and analytics.
- Performed data manipulations and data validations for build reporting structure.
- Created several reports with key metrics for monthly business reviews.
- Used python programming to combine data from multiple databases and Excel.
- Created Hive Queries to pull data from Data Lake for Travel and Expense Project.
- Automated BAU reporting using Unix/SAS.
- Involved with projects, regular requests, system enhancements and defect remediation.
Confidential, Richmond, VA
Master Data Analyst
Responsibilities:
- Created SAS Scripts for pulling data from Version One (All-in-One Agile ALM Platform) and loading data back into Teradata for reporting and analysis.
- Coordinated with the Business Owners to outline Business Requirements.
- Developed business critical reports using Teradata and Tableau.
- Based on business needs extracted relevant data to facilitate desired customer communication.
- Involved with projects, regular requests, system enhancements and defect remediation.
- Used Teradata Utilities like BTEQ, Teradata SQL Assistant, SAS, UNIX Scripting, Excel, Tableau, Alteryx, Business Intelligence and Universe Designing.
- Worked on data analysis and Ad Hoc Reporting to access the performance of various processes.
- Developed SAS programs to analyze data and assure that the processes are running as intended.
- Analyzed and implemented code and table changes to improve performance and enhance data quality.
- Assisted business customers in pulling the required data for analysis and assisted them how to create reports in Tableau.
- Performed numerous data pulling requests involving 50 different tables using SQL.
Confidential, Richmond, VA
Senior Data Analyst
Responsibilities:
- Developed Complex Universes by linking different data sources.
- Designed and maintained Universes using features like creating Aliases and contexts for resolving Loops, Integrity Check, Cardinalities, Contexts and Hierarchies.
- Used Business Intelligence and Xcelsius reporting to represent data and presentation.
- Worked on Ad Hoc Reporting.
- Migrated scripts from SQL Server to Teradata.
- Built dashboards using Business Intelligence and Xcelsius.
- Used Teradata Utilities like BTEQ, Teradata SQL Assistant, SAS, UNIX Scripting,
- Excel, Business Intelligence and Universe Designing.
- Performed UAT to check integrity of the database.
- Analyzed and implemented code and table changes to improve performance and enhance data quality.
- Assisted business customers in pulling the required data for analysis.
- Performed numerous data pulling requests involving 40 different tables using SQL.
Confidential, Richmond, VA
Senior Data Analyst
Responsibilities:
- Extracted data from existing data sources and performed ad-hoc queries using Teradata, BTEQ and UNIX.
- Created Intent Vs Execution scripts to validate probe logic for Tools.
- Used Business Intelligence Reporting to represent data and presentation.
- Created and Maintained Universes for COSMOS and MCP Processes.
- Built Self Service Tool which allows users to plug in the account number and get the plastic numbers associated with that account using Excel, VBA and Teradata
- Reduced False Positives from MCP Scripts.
- Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.
- Engaged with the Data Steward team to promote scripts into Production.
- Configuration, scheduling, and execution of Teradata utilities (BTEQ, Tpump) to maintain the database.
- Created MBR's (Monthly Business Reviews) by integrating Business Intelligence directly into MS Office environment (Excel documents and PowerPoint presentations) with SAP Live Office for higher level management.
- Utilized skills for problem solving.
- Good Analytical and Documentation skills and ability to perform in a Team Environment.
Confidential, Richmond, VA
Senior Data Analyst
Responsibilities:
- Automated existing EXCEL reports using VBA Macros.
- Automated BTEQ Scripts using UNIX Shell Scripting.
- Have used analytical skills and quantitative knowledge for problem solving.
- Used Excel Pivot Tables to represent data and presentation.
- Used Teradata BTEQ, Tpump, UNIX Scripting and Excel.
- Maintained Data Consistency and database integrity.
- Performed data validations for business requirements.
- Converted existing scripts from User Container Tables to Presentation Layer Tables.
- Performed in depth analysis of data and prepared weekly, bi-weekly and monthly reports using MS-EXCEL, SQL and UNIX.
- Created tables, views, procedures using Teradata SQL Assistant.
- Prepared documentation for all level 3 processes.
Confidential, Richmond, VA
Data Analyst
Responsibilities:
- Responsible for loading data from flat files in UNIX, MVS into Teradata tables.
- Worked on Script remediation to enhance the scripts as per the departmental and business requirements.
- Responsible for the analysis, design, coding and development of building a new schema for Segmentation.
- Created Shell Campaigns and Response Campaigns.
- Calculated the Estimated quantities for the Pre-Campaign and the Response Rate for the Post Campaigns.
- Target segments according to their profit potential and the company’s ability to serve them in a proprietary way.
- Used tree document from the segmentation to add offers to the spreadsheet based on test cell number or cell code generated.
- Worked closely with the segmentation team to optimize the segmentation script.
- Prepared Documentation for Shell Campaigns.
- Shared ideas and implemented with the group for enhancement of the segmentation.
- Used Teradata BTEQ, Tpump, Unix Scripting and Excel.
Confidential
Research Assistant
Responsibilities:
- Involved in various projects, which deals mainly with handling databases, generating reports. Assisted professor in research.
- Involved in analysis, design, development and coding using SQL, PL/SQL, Ms Access.
- Prepared documentation for various projects.
Environment: Windows 2000/NT, UNIX, MS Access, PL/SQL, SQL, VB, SQL server.