SUMMARY

• More than 8 years of Experience in Data Analyst, Data Modeler, Data Quality Analyst, Business Analyst, Data Analysis, Data Modeling, Data Warehouse professional with applied Information Technology.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tool like ERWIN.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Strong SQL and PL/SQL skills for creating queries, procedures, database triggers to collect profile and scan data.
• 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, Hadoop, DB2, Excel, Oracle and MySQL database environment.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co - coordinated with DBA's to apply the data model changes.
• 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.
• 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, Windows 95/98/XP/Vista/Win 7, MAC OS, DOS., Linux

ETL Tools: Informatica, Data stage, SSIS, Ab Initio

Software Methodologies: SCRUM Agile, Waterfall Model

Databases: MS Access, Oracle 12c/11g/10g/9i, SQL Server 2014/2012/2008 R2/2008, DB2, Teradata

Web Technologies: SQL, PL-SQL, C#, Core Java, HTML, XML.

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

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

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

Version Control: Requisite-Pro, Clear-Case

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

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Data Analyst/Business Analyst/Data Modeler/SQL Analyst/Data Quality Analyst

Responsibilities:

• Coordinated with Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Develop a Conceptual, Logical and Physical database models using Erwin based on requirements and Data Profiling Results, involved reverse engineering Legacy Source system
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• 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.
• Worked on building the data model using ERWIN as per the requirements, discussion and approval of the model
• Created and complete testing of repository, reports, dashboards and analytics to ensure they meet documented business requirements.
• Created the DDL scripts using ERWIN tool and source to target mappings to bring the data from source systems to the warehouse
• 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.
• Presented the data scenarios via, ERWIN logical models and excel mockups to visualize the data better
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• 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.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked with data architects team to make appropriate changes to the data models.
• Configure DAC execution plans for scheduling to run ETL processes.

Environment: Erwin 9.6, SQL, PL/SQL, Excel, ETL Informatica, Microsoft Office Suite, Microsoft Visio, Oracle, XML Files, Excel, Flat files, Java SQL Server, Teradata, Sharepoint, UNIX, Business Objects.

Confidential, NYC, NY

Sr. Data Analyst/Business Analyst/Data Modeler/SQL Analyst/Data Quality Analyst

Responsibilities:

• Extensively involved in every phase of the SDLC process starting from Inception to Transition.
• Involved in designing Logical data model and Physical conceptual data model using Erwin.
• Interviewed Business Users to gather reporting / data requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work.
• Designed and Developed logical & physical data models and Meta Data to support the requirements using ERWIN
• Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Designed the ER diagrams, Logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using ERWIN
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements
• Conducted Joint Application Development (JAD) sessions with IT groups
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Part of a team that was responsible for 20+ schemas and ERWIN models. Maintained schemas that contain views that were used by a live reporting application
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Created adhoc reports and pivot tables in Excel using VBA and macros.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Analyze the Business Object reports/extracts and submit to the Risk manager after the proper validation.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Erwin, SQL, PL/SQL, ETL Informatica, HP QC /ALM, Agile, XML, Teradata, Visio, Erwin, Windows and UNIX, TOAD for Oracle 10g, MS SQL Server 2008R2, Excel, Access, MS PowerPoint, MySQL, MS Excel, BI Business Objects

Confidential, Oak Brook, IL

Sr. Data Analyst/Data Modeler

Responsibilities:

• Extensively involved in every phase of the SDLC process starting from Inception to Transition
• Interviewed Business Users to gather reporting / data requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work.
• Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.
• Designed conceptual, logical and physical models using ERWIN and documented analysis results in a logical format to be presented to the client
• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Data Profiling, data Attribution through reverse engineering of target database using Erwin
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ERWIN.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements
• Conducted Joint Application Development (JAD) sessions with IT groups
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Analyze the Business Object reports/extracts and submit to the Risk manager after the proper validation.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Erwin, SQL, PL/SQL, ETL Informatica, HP QC /ALM, Agile, XML, Teradata, Visio, Erwin, Windows and UNIX, TOAD for Oracle 10g, MS SQL Server 2008R2, Excel, Access, MS PowerPoint, MySQL, MS Excel, BI Business Objects

Confidential, NYC, NY

Data Analyst

Responsibilities:

• Gathered and translated Business requirements into detailed, production-level technical Specifications, new features, and enhancements to existing technical business functionality.
• Involved in review of Functional Requirement Specification and System Design Specification documents for testing
• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Performed extensive manual testing on critical functionalities of the application.
• Tested ETL mappings to extract and load data from different databases such as Oracle, SQL Server, XML files and flat files and loaded them in to Oracle.
• Design and Developed QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Involved in validating the Informatica workflows.
• Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do; whether the mapping work correctly in relation to other processes in your data logistical flow.
• Written SQL queries to validate Business Objects reports according to the system requirements.
• Prepare defect reports and tracked the defects.

Environment: Informatica Power Center, Oracle 10g, MY SQL Server 2008, Business Objects, Rally, SQL, PL/SQL, TOAD, Log Files, PuTTY, SQL Loader, TOAD, Flat files, Erwin, Windows NT and UNIX