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 - Los Angeles, California

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.

Data Analyst

Confidential

Responsibilities:

• Used Power point to present the design issues / challenges documents to solution architect and DBA.
• Took part in requirements gathering through interactions with business analyst/users team Analyze requirements and source systems, perform Source data identification, Analysis and Data Profiling
• Created detail mapping trackers prepared by business analyst
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved with review of estimation of DW development and testing effort.
• Track tasks progress through daily/weekly status calls. Took part in bug triage meetings to make sure defect aging was controlled.
• Involved with the request creation for the development and test environment set up.
• Reviewed if required SSIS projects and Teradata fastload and multiload scripts, to extract, transform, generate files and transfer the files to Vendor and collected the metadata and validated it with the mapping document.
• Provide necessary assistance to offshore team for development and testing activities.
• Address performance related issues through performance tuning and query optimization
• Responsible for release management of code through development, system integration testing, User’s acceptance test, Implementation Readiness, Production implementation.
• Quality Management- Ensure adherence to CMMI and Six Sigma. Update related documents.
• Project Management - CMMI Implementation, Developing Project Plans, manage work activities, meet deadlines, resources.
• The challenge was using SSIS ETL tool to load tables in Teradata using fastload scripts in the absence of UNIX environment.

Environment: SQL, ETL, SQL Server BI Development Studio, Teradata V12, Excel, SSIS, MS SQL Server, Flat files

Data Analyst

Confidential

Responsibilities:

• Verifying the Business requirement document and Technical design document against requirements.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Trained on building Conceptual, Logical and Physical data model.
• Worked on the model based volumetric analysis and data based volumetric analysis to provide accurate space requirements to the production support team.
• Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System.
• Worked with the test team to provide insights into the data scenarios and test case
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Verify and analyze data mapping issues and work with data analysts to find effective fixes. Involve in review the Use cases of functionality with project team.
• Involve in peer review of Test scenarios written by testing team. Prepared Daily Status and Weekly status report
• Attending reviews, status meetings and customer interaction.

Environment: SQL, Quality Center, Oracle, Agile.

Jr. Data Analyst

Confidential

Responsibilities:

• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case.
• Used SQL queries for organizing and abstracting data from MS access databases, created reports, forms on MS Access.
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Accumulated system requirements from various departments like accounting, retail, IS (Information Systems) through surveys and interviews.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Environment: SQL, MS Access, Word, UML.