SUMMARY

• Around 5 years of experience in the IT industry working as Data Analyst with strong understanding of Data Analysis, Data modeling, Data Mart/Data Warehouse concept and design, ETL tools and BI reporting excellence
• A result driven individual having worked in all phases of System Development Life Cycle (SDLC)
• Expert in working on full Project Development Life Cycle using methods such as, Agile and Waterfall
• Expert in writing SQL Queries and also good in performance tuning
• Experienced with multiple relational database like SQL Server, MySQL, PostgreSQL, ORACLE and Teradata
• Solid experience of Data import, Data Export, Data Transformation, Data Cleansing, Data Migration, Data Consolidation, ETL Mapping using ETL tools such as, SQL Server Integration Services (SSIS), Talend Studio for Data Integration for large volume of data
• Experienced in creating customized job, designing complex mapping and defining loading strategies in Talend for ETL requirement
• Hands on experience working with MS Excel utilities such as, Pivot table, Lookup table, VBA macros for different requirements
• Expertise in analyzing Business Requirement Documents (BRD), understanding the business requirement and preparing Low Level Design (LLD)
• Hands on experience on Data Analysis, Data Profiling, Data Validation, Data management, Data Verification and Data Masking for various requirements throughout projects.
• Experienced in using Teradata utilities such as, Teradata SQL queries, TPump, FastLoad, MutliLoad and FastExport etc.
• Carried out testing responsibilities such as preparation of test cases, unit testing, test data preparation, system testing. Performed SQL validation with test outputs
• Proficient in writing Data Mapping documents, Data Transformation rules and maintaining Data dictionary and Interface requirements documents
• Experienced in working with Data mart schema such as Star Schema, Snowflake Schema and strong understanding of dimension and facts table
• Good understanding of OLTP and OLAP systems
• Good knowledge of NoSQL Databases
• Experienced in creating interactive reports and visualization in Tableu and created rich dashboards
• Experienced in creating reports using Cognos, MS Excel and SSRS
• Good knowledge of Python

TECHNICAL SKILLS

ETL Tools: SSIS, Talend integration suite 5.3

OLAP Tools: Tableau, Cognos

Databases: Teradata 14/V2R6/V2R5, Oracle 12c/11g/10g/9i, SQL Server 2005/2008, MySQL

Operating Systems: UNIX, WINDOWS

Languages: C, C++, C#, UNIX Shell Scripting SQL

Version Control: VSS, Git

Other Tools: T - SQL, SQL Developer, Microsoft Office, Teradata View Point, Teradata SQL Assistant, JIRA, GitHub, control-M

PROFESSIONAL EXPERIENCE

Confidential - Frisco, TX

Data Analyst

Responsibilities:

• Understood the business requirements for Alloy DataMart
• Participated in preparation of design documents (High level & Low level), Unit Test Cases, data flow diagrams and business/technical metadata
• Created Source to Target mapping documents and use ETL tool to create Cognos reports for TCF Bank and Carver Bank from data warehouse tables (Alloy Data)
• Wrote SQL queries to create views for various reporting requirements
• Performed data cleansing, remove duplicates and identified redundant data coming in the staging area. Several ODS data Issues were confronted and solved while preparing the views for reporting purpose
• Identified several data issues existing in data mart and worked with ETL team on these issues
• Prepared different Unit Test Reports as per requirement of the MGI clients for Alloy data
• Performed Data Analysis and Data Profiling using SQL queries both in staging and data warehouse to ensure the data conforms to expected results
• Removed data duplication and several domain integrity issues
• Learned and interpreted physical and logical data models provided by the data modelers
• Worked closely with ETL team, Reporting team and DB teams during project deployment
• Followed MGI standard best practices throughout project. The clients of MGI had different reporting requirements.
• Helped ETL & Reporting team for identifying the data element
• Performed Data retrieval from SQL server and .csv files and MS Excel for different requirement
• Performed Data Analysis, Data Profiling using complex SQL queries on various source system using Oracle & SQL server

Environment: Erwin Data Modeler 9.5.2, SQL Server 2012, ORACLE 11g/ 12c, T-SQL, UNIX Shell Scripting, Cognos Reporting tool, SSIS, Teradata 14/V2R6/V2R5

Confidential - Dallas, TX

Data Analyst Intern

Responsibilities:

• Understood the business rules
• Co-ordination from various business users stakeholders to get Functional expertise, design and business test scenarios review, UAT participation and validation of financial data
• Prepared Low Level Design Documents, unit test cases as per requirement
• Wrote SQL queries for various reporting requirements
• Performed detailed data investigation and analysis of known data quality issues in related databases through SQL
• Performed data cleansing, removal of redundant data coming at the staging area. Checked for data consistency and data integrity
• Used MS Excel for Ad-hoc reporting and status reporting. Heavily used pivot and the Vlookup.
• Wrote requirements, functional and design specification which includes BI dependency plan, job scheduling and cycle management documents
• Coordinated the development efforts with offshore team
• Created interactive reports using Tableau
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights

Environment: ORACLE 11g, MS Excel, MS Access, Tableau 8.x/9.x

Confidential

Data Analyst

Responsibilities:

• Worked with ETL Team; responsible for writing functional and design specification documents
• Performed Data Profiling to ensure Data Quality; worked with enterprise architect team for business glossaries and data standards for large volume of customer data of Confidential
• Created technical specifications which include functional and non-functional requirement, logical and Physical data models using Erwin Data modeler for the Data Mart for campaign management section
• Handle multiple change requests from customer during project through standard business process change request/ change management
• Designed customized jobs in Talend to populate multiple tables in the Postgres database tables
• Defined target load plans and constraint based loading strategies and wrote ETL specifications for Talend
• Developed complex Talend mappings with best approach and technique; performed unit and system/integration testing and help users for UAT
• Implemented row level security on DataMart tables to restrict Ad-hoc and reporting users using Oracle’s Fine Grain Access Control (FGAC) mechanism.
• Created various visualized reports using SSRS

Environment: ORACLE 10g, Postgres, SSRS, Control - M, ERwin, HPSD, Talend Studio for Data Integration