SUMMARY:

• Over 10+ years of working experience as a Data Architect/Modeler with Data Warehouse & Business intelligence and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in Online Transactional processing (OLTP) and Online Analytical Processing (OLAP), Data Warehousing concepts and ETL Environment.
• Experienced in developing Conceptual, logical models and physical database design for OLTP and OLAP systems using ER Studio and Erwin.
• Expertise in Star schema and Snowflake schema, FACT &Dimensions, Additive and Semi additive facts, Base level fact, Aggregate Fact, Fact less fact, Grain, Data Sparsity, Degenerate dimensions, Junk dimensions, Conformed Dimensions, Hierarchies of Dimensions and Rapid Changing Dimensions.
• Experienced in Data mapping, (source to target mapping) Data transformation between sources to target data models.
• Strong Data modeling experience using ERdiagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm(3NF)
• Strong Database experience using Oracle, XML, DB2, Teradata, Netezza, SQLserver, Big data and NoSQL.
• Good Knowledge in designing the DataMart using RalphKimball’s and Bill In mon Dimensional DataMart Modeling techniques.
• Hands on experience in Normalization and De - Normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in writing Stored Procedures, Functions, Materialized Views & Triggers; Good at using TOAD, SQL*Plus, SQL Navigator and PL/SQLDeveloper.
• Excellent experience on Teradata SQLqueries, Teradata Indexes, Utilities such as Mload, Tpump, Fastload and FastExport.
• Excellent experience in writing SQLqueries to validate data movement between different layers in data warehouse environment.
• Excellent understanding and working experience of industry standard methodologies like Software Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE and Waterfall Methodologies.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Strong expertise in building, Templates, Graphical analysis charts and Statistical reports using MS Excel and also expertise in MSWord, MS PowerPoint.
• Experienced with Management and implementation of database models, data flow diagrams, database schemas, dbscripts, DTD schemas, structures and data standards to support a data management infrastructure.
• Expertise in Importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
• Experienced with NoSQL databases like Hbase, and MongoDB as well as other ecosystems like Zookeeper, AWS Redshift etc.

TECHNICAL SKILLS:

Operating systems: UNIX, WINDOWS, MS-DOS, Linux

ETL Tools: DataStage, Informatica Power Center, Talend, Pentaho, Mulesoft

Other Tools: MS Office, Clear Quest, Princeton Softech, Oracle APEX

Data Modeling Tools: Erwin ER Studio and IBM Infosphere Data Architect, Erwin Data modeling, Rational Rose 2000, MS Visio, ER Studio, Toad Data Modeler 3.4, MS Visio, Sybase Power Designer.

Databases & Database Tools: MS SQL servers, Oracle, MS Access, Teradata, DB2,TOAD 9, DataStage, Informatica 8, Netezza, Teradata data lake, Hadoop, Bigdata, NoSQL

Reporting Tools: Cognos 8, Business Objects XI, Crystal Reports, OBIEE, Tableau, Tibco Spotfire

Programming Languages: UML, XML, XSD, XSLT, and HTML.

ETL/Data warehouse Tools: Informatica, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Data Architect/ Data Modeler

Responsibilities:

• Understand and analyze business data requirements and architect an accurate, extensible, flexible and logical data model and Defining and implementing conceptual, logical, and physical data modeling concepts.
• Generated and DDL (Data Definition Language) scripts using ERWIN 9.6 and assisted DBA in Physical Implementation of data Models.
• Defining Data Sources and data models, documenting actual data flows, data exchanges, and systems interconnections and interfaces.
• Design and build world class high-volume real-time data ingestion frameworks and automate various data sources into Big Data technologies like Hadoop etc.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in the data model.
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Designed and Developed logical & physical data models and Metadata to support the requirements using ERStudio.
• Involved with Data Profiling activities for new sources before creating new subject areas in warehouse
• Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Worked with business to identify the distinct data elements in each report to determine the number of reports needed to satisfy all reporting requirements.
• Taking the data from databases to Data warehousing of DB2, Oracle, SQL Server and MS Access.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB and MS SQL Server) from various heterogeneous data sources.

Environment: ERWIN 9.6,Netezza, ER Studio, DB2, Information Analyzer, Informatica, Quality Centre, Excel, Toad, Oracle Designer, SQL Server 2008, TOAD, PL/SQL, Flat Files, Teradata, NIX AIX 5.2, PERL, Shell Scripting

Confidential, Madison, WI

Data Architect/ Data Modeler

Responsibilities:

• Worked as a Data Architect/Modeler to generate and architect
• Data Models using Erwin and developed relational database system.
• Provide production support for Data Acquisition and Distribution processes. Identification and resolution of problems encountered with ETL processes.
• Develop and keep current, a high-level data strategy that fits with the Data Warehouse Standards and the overall strategy
• Developed logical data models and physical database design and generated database schemas using Erwin 8.
• Worked with DBA to create Best-Fit Physical Data Model from the logical Data Model using Forward Engineering in Erwin.
• Generated and DDL (Data Definition Language) scripts using ERWIN 8 and assisted DBA in Physical Implementation of data Models.
• Performed Data analysis of existing data base to understand the data flow and business rules applied to Different data bases using SQL.
• Reverse Engineered the existing Stored Procedures and wrote Mapping Documents for them.
• Used Erwin entity-attribute editor and Erwin relationship definition editor to modify, update existing primary, foreign, alternate keys and identifying, non-identifying, recursive and subtype relationships.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Participated in the Master Data Management (MDM) effort; provide technical advice and support toward the development of strategic and tactical plans for client master data management strategy, data inventories, data governance, data management, storage, and distribution alternatives in support of client MDM strategy.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3rdNFmodel.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle, SQLServer and DB2.
• Involved in designing and implementing the security for the databases.
• Created stored procedures, functions, database triggers and packages as per the business needs for developing ad-hoc and robust reports.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: ERWIN 8, MS SQL Server, Oracle Database 11g, XML, HP Quality Center, Java, RUP, MS Visio, SQL Server Reports, Win Runner, Load Runner, Quick TestPro.

Confidential, NYC, NY

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in the data model.
• Presented the data scenarios via, Erwin logical models and excel mockups to visualize the data better.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, TOAD, MS Access, Excel and SQL
• Worked on Naming standards for Table/Column/Index/Constraints names thru Erwin Macros and Master Abbreviations file.
• 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.
• Prepared required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
• Worked on Physical design for both SMP and MPPRDBMS, with understanding of RDMBS scaling features.
• Performed Researching and deploying new tools, frameworks and patterns to build a sustainable Bigdata platform.
• Performed Data Analysis tasks on warehouses from several sources like Oracle, DB2 and XML etc. and generated various reports and documents.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Worked in Data Analysis, data profiling and data governance identifying DataSets, Source Data, Source Metadata, Data Definitions and Data Formats.
• Understood source business process and data model and do Data Analysis and map the requirement to source system.
• Generated comprehensive analytical reports by running SQLqueries against current databases to conduct Data Analysis.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Written complex SQLqueries for validating the data against different kinds of reports generated by BusinessObjectsXIR2.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Business Objects XIR2, ETL Tools Informatica 8.6/9.1/9.5, Oracle 11G, Big Data, Teradata R13, Teradata SQL Assistant, CA ERWIN r8, Subversion, MS-Office, Oracle 10g, 11g RAC, SQL Server 2008/2012,, SQLPLUS, PL/SQL

Confidential, Wilmington, DE

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Performed data analysis and profiling of source data to better understand the sources.
• Created logical data model from the conceptual model and it's conversion into the physical database design using Erwin.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Interacted with the database administrators and business analysts for data type and class words.
• Conducted design sessions with business analysts and ETL developers
• Used ModelMart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created ER Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified PK/ FK for lookup tables.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.
• Involved in ETL mapping documents in data warehouse projects.
• Created high level ETL design document.
• Involved in extensive data analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning.
• Conducted several Physical Data Model training sessions with the ETL Developers. Worked with them on day-to-day basis to resolve any questions on Physical Model.

Environment: Oracle 10g, SQL Server 2005, Teradata, MS Access, Teradata 13.0, Data stage, Windows XP, MS Excel, Business Objects XI, MS Access, Teradata, Data stage, Erwin7.0, Windows XP, Excel, Informatica.

Confidential, Phoenix, AZ

Data Analyst/ Data Modeler

Responsibilities:

• Conducted major stakeholder interviews involving SME's, Business Analysts and other stakeholders to determine the requirements.
• Gathered, analyzed and translated the business requirements into detailed reporting requirements for Data warehousing.
• Designed of the Conceptual, Logical and Physical data models to meet the business requirements and reporting requirements using Erwin 7.0.
• Provided Conceptual, Logical, Physical data models and data management support using Erwin data modeling tool and ERstudio business architect and repository for the Business Intelligence
• Performed Data Profiling for multiple sources by using SQL and Informatica Data Quality and answered complex business questions by providing data to business users.
• Produced 3NF data models for OLTP applications using data modeling best practices modeling skills.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Part of Business Intelligence and Warehousing (BIW) group, supported design and development of Enterprise-wide, integrated Data Warehouse environment for future deployment of Decision support data marts utilizing both BillInmon and Ralph Kimball methodologies.
• Generated ad-hoc repots using Crystal Reports and SQLServer Reporting Services(SSRS)
• Performed Reverse Engineering the reports and identified Data Elements (in the source system). Dimensions, Facts and Measures required for reports.
• Analyzed the existing ETL application (python based), which is written using BTEQs to understand the ETL transformations.
• Worked closely with the ETL Developers to explain the complex Data Transformation using Logic.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.

Environment: Erwin 7.0, DB2, Teradata, SQL-Server2000, Informatica, Enterprise Architect, Power Designer, Crystal Reports, SSRS, ER Studio, Lotus Notes, Tableau, Windows XP, MS Excel, word and Access.