SUMMARY

• 61/2 years of experience in Information Technology with Expertise in Data modeling and Data Analysis for Data Warehouse/Data Mart development, Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Data Management & Data Modeling experience in an Enterprise Data Warehouse/Data Mart application environment utilizing both the Ralph Kimball Star Schema Dimensional Modeling methodology and the Bill Inmon Relational Modeling methodology.
• Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.
• Data Modeler with strong Conceptual and Logical Data Modeling skills has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Experience in conductingJoint Application Development (JAD)sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Proficiency in Normalization to 3NF and Denormalization techniques for optimum performance of database environments like OLTP and OLAP systems.
• Strong Experience in ER and Dimensional Data Modeling to deliver Normalized ER and Star/Snow Flake schemas using ERwin, ER Studio, EA Studio and Oracle designer.
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using ERwin tool.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.
• Experience designing, reviewing, implementing and optimizing data transformation processes in the Hadoop and Informatica ecosystems.
• Hands on experience on Distributed Processing of Big Data - Business Research Methods using Hadoop.
• Having experience in Hadoop and Map Reduce Framework and Oracle database.
• Developed Test Plans, Test Cases, Procedures and Designed Documents within the given business requirements to ensure specifications and regulations.
• Experience with design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence solution.
• Experience in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration by using SQL Server 2005 Integration Services (SSIS) and PL/SQL Scripts and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Hands on experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions. Developed custom dashboards/reports using Qlikview.
• Extensively worked on Tableau Administrator and Tableau Server. And effectively used data blending feature in tableau.
• Expertise in writing complex Access, Excel Macros with Excel VBA for different Business Environments.
• Experience in report design, table/query design and automation utilizing VBA modules.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience with Teradata utilities like Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Extensive knowledge onproducing tables, reports, graphsand listings using various procedures and handlinglarge databases to perform complexdata manipulations.
• Experience in various phases ofSoftware Development life cycle(Analysis, Requirements gathering, Designing) with expertise in documenting variousrequirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Worked with project and business teams throughout the software development life cycle to deliver a data model that is consistent with business needs and architectural standards.
• Working experience in both traditional Waterfall and sprinted Agile Methodologies.
• Good Knowledge on SQL queries, Dynamic-queries, Sub-queries and creating database objects like Stored Procedures, Triggers, Packages, Cursors and Functions using SQL and PL/SQL for implementing the business techniques.
• Proficiency in extracting data and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets.
• Expertise in Generating Graphs, listings, PDF and RTF files using various Base SAS Procedures.
• Involved in implementing the Referential Integrity by using Primary and Foreign key relationships.
• Generated DDL Scripts from Physical Data Model by using Forward Engineering technique which helped in better understanding of the data flow process.
• Extensively worked on Talend Designer Components-Data Quality (DQ), Data Integration (DI) & Master Data Management (MDM).
• Worked on Data Profiling, Data Mapping, Data Validation and Data Cleansing for data accuracy between the data warehouse and the source systems.
• Hands on experience in different stages of handling data viz. requirement gathering, identifying data sources/targets, data loading, and building Star schema. Also performed various operations like Data Scrubbing, Data Profiling and maintained data governance.
• Excellent analytical and problem solving skills, effective team worker and quick learner with the ability to master and work efficiently with new technologies.

TECHNICAL SKILLS

Data Modeling Tools: ERwin 7.1/7.3/8.2/9.0/9.6 , ER Studio & Power Designer.

OLAP Tools: Microsoft Analysis Services, Business Objects, Oracle Business Intelligence, Cognos Suite.

ETL Tools: Microsoft SSIS and Informatica 7.1.3.

Languages: SQL, PL/SQL, T-SQL, HTML, XML, Python, Basic Java and JavaScript

Database Tools: Microsoft SQL Server 2005/2008/2012 , DB2, Oracle 11i/10g/9i, VBA MS Access, Teradata

Operating Systems: Microsoft Windows 7/NT/2000/XP/Vista and UNIX

Reporting Tools: MS Excel, SSRS, Tableau 8.3/8.2/8.1/8.0 and Qlikview.

PROFESSIONAL EXPERIENCE

Senior Data Analyst/Modeler

Confidential, Hackettstown, NJ

Responsibilities:

• Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
• Installed & configured the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning.
• Designed Relational Data Model for Enterprise Data Warehouse using CA ERwin.
• Used ERwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created Star schema cubes using SSAS and worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Worked on the Reports module of the project as a developer on Tableau, MS SQL Server 2008 Reporting service (SSRS) (using SSRS, T-SQL, scripts, stored procedures and views).
• Migrated reports from Tableau and SSRS to Cognos 8 Environment.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values and business rules in accordance with the Corporate Data Dictionary etc.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets.
• Widely implemented Normalization methods up to third normal form (3NF).
• Worked with DBA to create Physical Data Model (PDM).
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Resolved data type inconsistencies between the Source systems and Data Warehouse.
• Worked with ETL to develop source to target data mapping with transformation rules, physical naming standards, datatypes, domain definitions and corporate Meta data definitions.
• Create ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server usingSSIS.
• Create and load Staging and Dimensional databases usingSSIS.
• Designed tables for staging and integration layers.
• Created one on one views for downstream users.
• Used Forward Engineering to generate Data Definition Language (DDL).
• Implemented SQL scripts to modify data to resolve the assigned defects.
• Involved in the critical Design review of the finalized database model.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation.
• Worked on the reporting requirements for the data warehouse.
• Produced daily risk report scenario analysis and stress testing using Excel and VBA.
• Developed the Dashboard reports using Cognos Report Studio.
• Created support documentation and worked closely with production support and testing team.

Environment: CA ERwin 9.6, Teradata 14.0, Oracle11g, MS SQL Server 2008, MS Excel 2010, SSIS, Cognos, SSRS.

Data Modeler/Data Analyst

Confidential, Warren, MI

Responsibilities:

• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form.
• Extensively used Data Modeling, Data Analysis for OLTP and OLAP systems.
• Participated in brain storming sessions with application developers and DBAs to discuss about various de-normalization, Partitioning and Indexing Schemes for Physical Model.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS).
• Created the Conceptual Model for the Data Warehouse using ERwin Data Modeling tool.
• Reviewed the Conceptual EDW (Enterprise Data Warehouse) Data Model with Business Users, App Dev. and Information Architects to make sure all the requirements are fully covered.
• Created Logical & Physical Data Modes using Entity Relationship Diagrams.
• Designed the physical data models using data provisioning and consumption techniques in Oracle environment.
• Utilized ERwin’s forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Analysed the existing logical model of the ODS to understand the relationships between different entities.
• Worked on Requirements Traceability Matrix to trace the business requirements back to Logical Model.
• Developed SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Developed efficient, well-documented and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Reviewed the Logical Model with Application Developers, ETL Team, DBAs and Testing Team to provide information about the Data Model and business requirements.
• Normalized the tables/relationships to arrive at effective Relational Schemas without any redundancies.
• Identified the Facts & Dimensions Tables and established the Grain of Fact for Dimensional Models.
• Created Multi-Way Aggregate Fact Tables as a specific summarization across dimensions of product, region and date.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Created Snowflake Schemas by normalizing the dimension tables as appropriate, and creating a Sub Dimension named Demographic as a subset to the Customer Dimension.
• Created refined data models pertaining to reassessed business requirements conforming to applicable data standards and successfully documenting the existing system model and changes proposed/applied to the model.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Extensively used Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Applied Data Governance rules (primary qualifier, class words and valid abbreviation in Table name and Column names).
• Involved in capturing Data Lineage, Table and Column Data Definitions, Valid Values and others necessary information in the data models.
• Worked on Forward Engineering to enhance the Data Structures of the Existing Database and Creating New Schemas.
• Generating output files in the form of listing, HTML, RTF and PDF formats using SAS ODS.

Environment: ERwin r9.0/8, Oracle 10g/11g, SAS, Windows XP, SQL Server 20012, SSRS, Microsoft Excel.

Data Modeler / Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• As a Data Modeler/Data Analyst I was responsible for all data related aspects of a project.
• Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
• Ensure data design follows the prescribed reference architecture and framework.
• Ensure design reflects appropriate business rules, and facilitates data integration, data conformity and data integrity; Ensure data structures are designed for flexibility to support future business needs and enhancements.
• Develop 3NF modeling and dimensional modeling constructs.
• Worked at conceptual/logical/physical data model level using ERwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in ERwin after analyzing the database systems currently in use.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Developed the required data warehouse model using Star schema for the generalized model.
• Used forward engineering approach for designing and creating databases for OLAP model.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data involving OLTP, ODS and OLAP.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Design and govern data services messaging constructs in XSD format.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Designed and developed MS Access user interfaces with user validations using VBA.
• Used VBA extensively and provided options to query the data based on their selection.
• Imported data from SQL Server into Access.
• Understand the relationships across business information and units of data; collaborate with Business Analysts, Data Stewards and Business Customers to identify data usage patterns and to formulate Business names, definitions and data quality rules for data elements.
• Perform source data analysis, data discovery, data profiling and data mapping.
• Worked on all data management activities on the project data sources, data migration.
• Worked on creating DDL, DML scripts for the data models.
• Worked on stored procedures for processing business logic in the database.
• Performance query tuning to improve the performance along with index maintenance.
• Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modeling solutions; provide data structures optimized for information entry and retrieval.
• Self-directing individual contributor with skills at matrixes and virtual team contribution/integration and with experience in leading and directing other team members.

Environment: ERwin 8.2, Oracle 11g, MS SQL SERVER 2008, DB2, MS Excel 2010.

Data Modeler

Confidential

Responsibilities:

• Gather the various reporting requirement from the business analysts.
• Gather all the Sales analysis reports prototypes from the business analysts belonging to different Business units.
• Designed Dashboard, a front end Excel/user form based application which connects to back end Access database using Excel/VBA.
• Reverse Engineering the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Worked on profiling source data to determine the key consistency, data type, size, etc.
• Worked on logical and physical model using ERwin based on requirements.
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• Create and deploy reports using SSRS.

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, MS Excel 2010,Windows 2000, ERwin, Power designer, CSV files, XML files, Business Objects, Oracle10g.