SUMMARY

• Over 9 Years of experience as anOracle SQL, PL/SQL Developerin Analysis, Design,Data Modeling(Logical and Physical) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Extensive experience in Data Modeling, Data AnalysisData Architect and design of OLTP and OLAP systems.
• Experienced in Designing Star Schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin Data Modeler, Power Designer, Embarcadero E - R Studio and Microsoft Visio.
• Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional Database environments.
• Strong experienced working with conceptual, Logical and physical Data Modeling considering Meta Data standards.
• Experience in creatingstored procedures, PL/SQL Packages, TriggersandFunctions. Strong knowledge in Oracle cursor management and exception handling.
• Excellent conceptual knowledge of Oracle 9i/10g/Orcle12c, PL/SQL.
• Experienced working with Agile and WaterfallData Modeling methodologies.
• Experiencedin Extracting Data from Mainframes Flat File, Oracle, Netezza and converting them into Teradata tables using SAS PROC IMPORT, PROC SQL etc.
• Experienced in designing a canonical model (relational model) and very good knowledge in Ralph Kimball and Bill Inmon approaches.
• ExtensiveexperiencedAnalyzing and documenting Business Requirements and system functional specifications including use cases; facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Experienced inAutomating and Scheduling the Teradata SQL Scripts in UNIX using Korn Shell scripting.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a Business Analysis methodology for application functionality designs using Rational Rose and MS-Visio.
• Experienced in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and DataWarehousing environments.
• Excellent experience in facilitatingData Requirement meetings with Business and Technical stakeholders and resolved conflicts to drive decisions.
• Expertise with various RDBMS like Oracle, SQL Server,DB2 UDB, and Teradata, Netezza.
• Experienced in Data Transformation and Data Mapping from source to target Database Schemas and AlsoData Cleansing.
• Expertise in implementingSlowly Changing Dimensions - Type I, II&III in Dimension tables, Conformed Dimensions, Role Playing Dimensions, and Degenerate Dimensions as per the Requirements.
• Experienced in extracting, transforming and loading (ETL) Data from spreadsheets, Database tables and other sources using SQLServer Integration Services packages(SSIS … .
• Performed extensive Data Profiling and Analysis for detecting and correcting inaccurate Data from the Databases and to track Data Quality.
• Having very Good exposure to ETL tool like Informatica.
• Building reports using SQL SERVER Reporting Services (SSRS … Crystal Reports and Business Objects.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r9.6/r9.5/9.1/8.x, ER Studio and Oracle Toad Modeler, Power Designer.

ETL Tools: Microsoft SSIS andInformatica Power Centre.

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, PL/SQL.

Database Tools: Microsoft SQL Server … Teradata, Netezza, Oracle 12c/11g/10g/9i, and MS Access.

Operating Systems: Microsoft Windows 9x / NT / 2000/ XP / Vista/7 and UNIX, Linux.

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

PROFESSIONAL EXPERIENCE

Sr. Data Modeler/Architect

Confidential, Durham, NC

Responsibilities:

• Develop database system, data architectural designs, and other related databases and develop and implement strategies, policies and standards for data architecture in the enterprise.
• Provide support in database architecture of the organization through database design, modeling and implementation and develop plans, strategies and standards for data within the enterprise
• Understand the end-to-end scope of work and design architectural solutions accordingly and ensure that designing, recovery and implementation of a database is carried out effectively.
• Lead the development, validation, publishing, and maintenance of logical and physical data models required to migrate existing independent data marts into the EDW, and for new business requirements to be implemented using the EDW.
• Identified several SQL and PL/SQL bottlenecks using PL/SQLProfiler(packageDBMS PROFILER),explain plan, auto trace.
• Created custom PL/SQL procedures to read data from flat files to dump into Oracle database using SQL * Loader.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Documented Logical, Physical, relational and dimensionalDataModels, designed theDataMarts in dimensionalDataModeling using star and Snowflake Schemas.
• Use database design and database modeling concepts to ensure data accessibility and security
• Used Informatica Power Center 9.6 for migrating data from various OLTP databases to the data mart.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database. Involved in analysis, development, testing, implementation and deployment.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning using Netezza Database.
• Developed commonSQL*Loaderscript using UNIXshellscript which is been used for most of the conversions.
• Involved in dimensional modeling of the data warehouse to design the business process dimensions, facts, Star Schema and Snow flake schemas.
• Comprehensive knowledge in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL plus.
• Delivering Oracle Database performance-tuning services by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, EXPLAIN PLAN, TKPROF and SQL TRACE.
• Analyzed the business requirements and designed conceptual, logical, physical, multidimensional data models.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements toTeradataRDBMS.
• Provide maintenance and support for SAS products during deployment, upgrade and any changes to SAS products and/ or during other enterprise activities that impact SAS infrastructure.

Environment: Erwin r9.6, Informatica Power Center 9.6, PL/SQL, SAS, MDM, Netezza, Teradata, Oracle 12c, SQL Server, SQL, Teradata SQL Assistant, Aginity, Microsoft Word/Excel.

Sr.Data Modeler /Architect

Confidential, Houston, TX

Responsibilities:

• Involved in sessions with business, project manager, Business Analyst and other key people to understand the BusinessNeeds and propose a solution from a Warehouse stand point.
• Standard in designing the architecture of the organization at the enterprise level and thorough understanding and hands on experience of Software Development life cycle from Ideation to Implementation.
• Conducted live JAR sessions to Elicit, Analyze and Document Business Requirements from the Business and conducted live JAR&JAD sessions with SMEs, and all the placeholders to develop High Level Requirement and then formalized those Requirements to Detail Level Requirements.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN,TKPROF, SQL TRACE and DBMS SQLTUNE.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Conducted series of sessions with Business People and IT People to bridge the gap and to translate the Business Ask to the IT product.
• Worked in close co-ordination with Business People, Architects, Developers, Testers and Project Managers and also at times reported to the higher leadership.
• Worked with SME's and other stakeholders to determine the Requirements to identify Entities and Attributes to build Conceptual, Logical and Physical Data Models.
• Designed an Industry standard Data Model specific to the company with group insurance offerings, translated the Business Requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Responsible forAnalyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.
• Created a high-level industry standard, generalized Data Model to convert it into Logical and Physical Model at later stages of the project using Erwin.
• Identified and Defined entities, relationships and attributes in the Data Model as per new specifications in Erwin after Analyzing the Database systems currently in use. Identified source elements and done Mapping with the target systems.
• Enforced referential integrity in the OLTPData Model for consistent relationship between tables and efficient Database Design.
• Developed numerousTeradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
• Conducted design walk through sessions with Business Intelligence team to ensure that Reporting Requirements are met for the Business.
• Developed Data Mapping, Data Governance, and Transformation and Cleansing Rules for the Master Data Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams while working on, SQL Server, Teradata to Analyze and provide solutions to Data issues and other challenges while implementing the OLAP model.
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies.
• Worked on Business Segmentation for Direct Mail and Email by writing SQL queries in Teradata SQL Assistant.
• Generated ad-hoc reports using Crystal Reports 9 and Prepared Analytical and Status Reports and Updated the project plan as required.
• Developed and maintained Data Dictionary to create Metadata Reports for Technical and Business Purpose.

Environment: Erwin 9.5, Teradata, Netezza, Oracle 12c, Windows 7, Microsoft Office SharePoint, Cognos, Rational Requisite Pro, MS Office (Word, Excel and PowerPoint), SQL Server, MS Project, MS FrontPage, MS Access, EDI, UML, Java, MS Visio, Toad, Oracle Designer, SQL Server 2012, Oracle SQL developer 2012, Crystal Reports, SSRS, SSIS, SAS.

Sr. Data Modeler/ Data Analyst

Confidential, Phoenix AZ

Responsibilities:

• Worked with Business users to know the Business Requirements and Gathered the entire detail Requirements from Business for reporting.
• Designed Star schema for Risk Reporting for renal and immune diseases subject area.
• Implemented logical and physicaldata modeling with techniques usingErwinin Data Mart and 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.
• Extensively used the advanced features ofPL/SQL like Records, Tables, Object types and Dynamic SQL.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers, extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies and performed gap Analysis.
• Conducted team meetings and JAD sessions for the Requirements clarifications and gave suggestions in the Requirements to Business.
• Created and maintained Logical and Physical Models for the Data Mart which supports the Risk Reporting for renal and immune diseases which included creating partitions, indexes for the tables.
• Development of scripts for loading the data into the base tables in EDW usingFastLoad,MultiLoad and BTEQ utilitiesof Teradata.
• Involved in Business process modeling using UML through Rational Rose and maintained Metadata, version controlling of the Data Model.
• Conducted design reviews with Business Analysts, Enterprise Data architect and solution lead to create proof of concept for the reports.
• Created source to target Mapping Documents for renal and immune disease Data Mart with all the upstream sources.
• Wrote SQL scripts for creating tables, Sequences, Triggers, views and materialized views and wrote SQL scripts for Loading Data from staging area to target tables.
• Involved heavily in writingcomplex SQL queriesto pull the required information from Database usingTeradata SQLAssistance.
• Did performance Analysis and Created partitions, indexes and Aggregate tables where necessary and broken down the hierarchies from the dimensions to create the roll up dimensions.
• Worked on testing primary index and skew ratios before populating data into tables using sampling techniques,explainplan in Teradata before querying large tables with several joins.
• Created SQL scripts for Loading the Aggregate tables and rollup dimensions and created package for automated Loading of Historical and Ongoing Data into aggregates.
• Extensively used AginityNetezzawork bench to perform various DML, DDL etc. operations on Netezzadatabase.
• Performed unit testing, System integrated testing for the aggregate tables.
• Performed Data Analysis on the target tables to make sure the Data as per the Business Expectations.

Environment: ORACLE, Teradata, SQL, T-SQL, PL/SQL, XML, NetezzaAginity, Teradata SQL Assistant, SQL Plus, Erwin 9.1, SSRS, SSIS, SAS, Excel, MS Visio, Source Offsite (SOS), Windows 7, QC Explorer, Business Objects, Share point workspace 2010.

Sr. Data Modeler/Data analyst

Confidential, Chicago, IL

Responsibilities:

• Analysis reports prototypes from the Business Analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Provided support to other developers in accurately mapping source attributes into theTeradata Financial Services Logical Data Model (FSLDM)and in interpreting business requirements
• Reverse Engineering the existing Data Marts and Identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR Schema for sales Data Involving shared dimensions (Conformed) for other subject areas using Erwin Data Modeler.
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies.
• 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, codes, business rules, glossary terms, etc.
• Performedtuningandoptimizationof complexSQLqueriesusingTeradataExplain.
• Performed tuning and optimization of complex SQL queries usingTeradataExplain.
• 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 and ensured the feasibility of the Logical and Physical Design Models.
• Involved in loading of data into Teradata from legacy systems and flat files using complexMultiLoadscripts andFastLoadscripts.
• Worked closely with the ETL Developers to explain the complex Data Transformation Logic and provided source to target Mappings to the ETL team to perform initial, full, and Incremental loads into the target Data Mart.
• Coding usingTeradataAnalytical functions, BTEQ SQL ofTERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Extensively managed the data skew all theNetezzadatabase tables.
• Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference Data Changes.

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Crystal Reports7.5/8.0, Windows 2000, Micro strategy 9.2, Crystal Enterprise8.0, Erwin 9.1, power designer, CSV files, XML files, Business Objects, Oracle10g, Teradata, Netezza, SAS, SSIS, Informatica, XML.

Data Modeler/Analyst

Confidential - Kennett Square, PA

Responsibilities:

• Engaged with Business users Involved in gathering the related Business Requirements and documented the performance of the system by understanding the existing Data Model.
• Mapped the Business Requirements and NewDatabases to the Logical Data Model which defines the project delivery needs.
• GeneratedDDL statements and scripts from Physical Data Model to create objects like table, views, indexes, stored procedures and packages.
• Designed Fact tables, Dimension and aggregate tables for Data warehouse and worked on the conversion process of Data which is stored in flat files into Oracle tables.
• Provided technical guidance for re-engineering functions of Teradata warehouse operations into Netezza.
• Implemented naming Standards and Warehouse Metadata for fact and dimension of Logical and Physical Data Model.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Used Reverse Engineering and Forward Engineering techniques on Databases from DDL scripts and created tables and Models in Data Mart, Data Warehouse and Staging.
• Worked on slowly changing dimension tables and hierarchies in dimensions and worked on Data Mapping process from source system to target system.
• Used variousTeradataIndex techniques to improve the query performance.
• Reverse Engineered DB2 databases and forward engineered them to SQL Server 2000 using Erwin.
• De-normalized the Database to put them into the Star Schema of the Data Warehouse and created documentation and test cases, worked with users for new module enhancements and testing.
• Understood existing Data Model and documented suspected design affecting the performance of the system.
• End-to-end grasp of the entire Software Development life cycle (SDLC) including Analysis, Design, Development and testing of Software applications.

Environment: Erwin 8.x, Oracle 10g, SQL Server, Crystal Reports, Windows 7, MS Office, Teradata, Netezza, SQL, PL/SQL, T-SQL, Informatica, SSRS, SAS, SSIS, XML, Excel, Pivot Tables, Metadata, Cogon’s.