SUMMARY

• Around 6 years of Experience in Data Analysis, Data Modeling, Data Warehouse professional with applied Information Technology.
• Excellent SQL skills for creating queries, procedures, database triggers to collect profile and scan data.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN and ER Studio.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for Physical Data model from Data Modeling changes.
• Specializing in the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms.
• Experience in Data Warehouse, Data Mart Design and Data Warehouse Bus Architecture. Deep knowledge of RDBMS structures including schema creation, modification.
• Worked with Teradata, MS SQL Server, Oracle, Hadoop Bigdata and MySQL database environment. Extensive knowledge of Structured Query Language including SQL and vi editor commands.
• Experience in Extract, Transform, and Load (ETL) / Data Staging, Design and Testing. Excellent knowledge of waterfall and Agile methodologies of Software Development Life Cycle (SDLC).
• Extensive experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Experience in Relational and Dimensional (Star Schema) Data Modeling. Experience in Understanding Business Requirements, analytical and communication skills with a strong technical background.
• Excellent communication skills, including writing failure and maintenance emails to large groups of people. Excellent Math skills required for data reconciliation and profiling.
• Having good experience in Excel, macros VBA and Visio. Experienced in working for data governance and interacting with data stewards to understand data issues that prevent good quality of data.
• Efficient in VBA for MS Excel for planning/status reporting and creating test data.
• Highly dependable Data Analyst successful at profiling and interpreting data. Supportive and enthusiastic team player dedicated to streamlining processes and efficiently reconciling data issues.

TECHNICAL SKILLS

Operating Systems: UNIX, LINUX, Windows 95/98/XP/Vista/Win 7, MAC OS, DOS, Linux

ETL Tools: Informatica, Data stage, SSIS, Ab Initio, Talend, BigData - Hadoop

Software Methodologies: SCRUM Agile, Waterfall Model, Kanban

Databases: MS Access, Oracle, SQL Server, DB2, Teradata, Hadoop, MongoDB, PostgreSQL, Netezza. Technologies SQL, PL/SQL, C#, Core Java, HTML, XML, Python, R, Sheel Scipting, Perl

Microsoft Office Suite: MS Office (Excel, Word, Power Point, Access and Visio)

Reporting tools: Cognos, Tableau, OBIEE, SSRS, Business Objects, Crystal Reports, Micro Strategy

Testing Tools: Quality Center/ALM, Rational Clear-Quest, TFS, Remedy, Rally, JIRA

Version Control: Requisite-Pro, Clear-Case

DB Query Tools: Toad, Rapid SQL, Teradata SQL Assistant, SQL Server Assistant

BigData Tools: Hadoop, HIVE, PIG, Spark, Scala, MapReduce

PROFESSIONAL EXPERIENCE

Sr. Data Analyst/Data Modeler

Confidential - Jersey City, New Jersey

Responsibilities:

• Interacted with clients, participates in requirement gathering and system analysis
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Created reports and graphs using Business objects to meet the business requirements of the project. Worked closely with BA to determine feasibility and determine LOEs
• Created and complete testing of repository, reports, dashboards and analytics to ensure they meet documented business requirements.
• Experience in creating visualizations using Bar Charts, Line Charts, Pie Charts, Maps, Heat Maps etc. in Tableau. Built dashboards for measures with forecast, trendline, and reference lines.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Created SQL queries and database triggers for state mandated reports and data elements.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin with Architect teams.
• Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Data SME to the project team and business customers through documentation, drive-by questions, research, Visio, Excel pivot tables, and SQL queries
• Designed ETL architecture to Process large no of files and created High-level design, low-level design documents.
• Loaded data into Hive Tables from Hadoop Distributed File System (HDFS) to provide SQL-like access on Hadoop data.
• Designed the Logical Data Model using ERWIN with the entities and attributes for each subject areas.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Used VBA and macros to automate large Excel spreadsheets of 1M + rows of data for easier navigation, data scrubbing, conversion and manipulation.
• Creation of BTEQ, Fast export, Multiload, Tpump, Fast load scripts for extracting data from various production systems. Design MOLAP/ROLAP cubes on Teradata Database
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Experience in creating UNIX scripts for file transfer and file manipulation. Data mapping, logical data modeling, created class
• Customized and monitored incremental and full loading of Production using DAC. Worked with data architects team to make appropriate changes to the data models.
• Configure DAC execution plans for scheduling to run ETL processes.

Environment: SQL, Tableau, Excel, SSIS, SSAS, Erwin Data Model, ETL Informatica, Microsoft Office Suite, Microsoft Visio, Oracle, XML Files, Excel, Flat files, Java SQL Server, Teradata, Sharepoint, UNIX, Business Objects.

Data Analyst/Data Modeler

Confidential

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.
• Preparation of technical specifications for the development of ETL mappings to load data into various tables in Data Marts and defining ETL standards
• Experience in creating Cube and deploying cube. Involved in end-to-end process.
• Automating reports in MS Excel VBA SQL Reporting Services. Suggested the data formats on the front-end screen to ensure its compatibility with SWIFT format
• Debugging the SQL-Statements and stored procedures for business scenarios.
• Assisted design logical models (relationship, cardinality, attributes, candidate keys) as per business requirements using ERwin Data Modeller.
• Generate ad-hoc or management specific reports using SSRS and Excel. Created SQL queries to generate ad-hoc reports for the business.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects and dentified the Facts and Dimensions from the business requirements
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Provided testing results and weekly status reports to the QA Manager
• Tested Performance & Accuracy related queries under SQL Server and Teradata.
• Created relationships in Requirement Traceability Matrix linking Business Requirements / Mapping document to test case design document

Environment: SQL, SSIS, SSAS, Erwin Data Model, Excel, ETL, Microsoft Office Suite, Microsoft Visio, Oracle, XML Files, Excel, Flat files, Java SQL Server, Teradata, Sharepoint, UNIX, Business Objects.