PROFFESSIONAL SUMMARY:

• Over 6 Years of professional experience in Data Modeling, Data Analysis, Data 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.
• Experienced in creating data mapping documents, DDL and scripts for Operational Data Store and Source to Target Mapping for legacy migration.
• Expertise in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions)
• Depth experience in development methodologies like SDLC, AGILE, SCRUM and Waterfall.
• Extensive experience in Database Creation and maintenance of physical data models with Oracle, Teradata and SQLServer databases.
• Extensive experience in development of T-SQL, DTS, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Expertise in SQL queries, PL/SQL Packages, SQL Plus, Stored Procedures, Functions, Triggers and Performance Analysis, Creating Partitions, Indexes, Aggregating tables when required.
• Excellent experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• Excellent oral and written communication skills, analytical skills, problem solving, leadership and management capabilities with quick learning abilities.
• Experience in performing root level analysis for data problems by identifying the system processes that lead to inaccurate data.
• Proficient in Advanced Microsoft Excel (Pivot Tables, Lookup, V-Lookup, Data Analyzing)
• Proficient in Microsoft PowerPoint and Microsoft Word.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL

Databases: Oracle 12c/10/11g, Teradata R12, R13, R14, R15, MS SQL Server, MS Access, IBM DB2

Tools: MS-Office Suite (Word, Excel, MS Project and Outlook), VSS

Testing & Defect Tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

Operating System: Windows, UNIX, Sun Solaris, Linux

Data Modeling: Erwin r 9.6/9.5/9.1/8. x, ER/Studio, Star-Schema Modeling, Snowflake-Schema Modeling, FACT and Dimension Tables, Pivot Tables

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

Project Execution Methodologies: Ralph Kimball and Bill Inmon Data Warehousing Methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

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

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Data Architect/Data Modeler

Responsibilities:

• Developed strategic oversight and planning of data models and database design within the CRM platform.
• Worked with key stakeholders to understand the data requirements and translates strategic requirements into usable enterprise information architecture. Ensures existing data/information assets are identified, documented, stewarded, and leveraged across the organization.
• Used Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement and identified the Facts and Dimensions from the business requirements and developed the logical and physical models using Erwin.
• Working with various Teradata tools and utilities like Teradata Viewpoint, MultiLoad, ARC, Teradata Administrator, BTEQ and other Teradata Utilities.
• Conducting complex Notes ETL data migrations to include assessing, planning, implementation, software development and data validation.
• Developing data and metadata policies and procedures to build maintain and leverage data models, ensuring compliance with corporate data standards and Analyze change requests for mapping of multiple source systems for understanding of Enterprise wide information architecture to devise Technical Solutions.
• Created stored procedures and functions using Dynamic SQL and T- SQL.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis and handled performance requirements for databases in OLTP and OLAP models.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, Netezza, flat files, SQL Server with high volume data.
• Developed complex Stored Procedures for SSRS (SQL Server Reporting Services) and created database objects like tables, indexes, synonyms, views, materialized views etc.
• Documented ER Diagrams, Logical and business process diagrams and process flow diagrams and Understand and analyze business data requirements and architect an accurate, extensible, flexible and logical data model.
• Created complex SQL server and Oracle stored procedures and triggers in support of the applications with Error handling.
• Involved in Performance tuning the SQL Server Queries, which are used in SSRS Reports and developed Ad Hoc Report Model for specific users is SSRS.

Environment: Erwin r9.6, Informatica Power Center, Teradata, Oracle 12c, Microsoft SQL Server 20012, SVN tool, BTEQs, Load, SSRS, T-SQL, Teradata SQL Assistant, Netezza, Fast Load, UNIX scripting, PL/SQL Programming

Confidential, Teaneck, NJ

Sr. Data Architect/Data Modeler

Responsibilities:

• Involved in the Architectural role to design and develop EDW program initiative and involved in design and conversion of business requirements to Conceptual Data Model, logical Data Model and Physical Data Model for subject areas
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements and queried the databases, wrote test validation scripts and performed the System testing.
• Involved in design and conversion of business requirements to Conceptual Data Model, logical Data Model and Physical Data Model for subject areas and reverse engineered all the Source Database's using Erwin.
• Participated in integration of MDM (Master Data Management) Hub and data warehouses.
• Created complex SSIS packages and SSRS Reports from Stored Procedures, Views and by writing complex T-SQL.
• Wrote large/complex queries using SQL and by using Teradata SQL Assistant and created databases, users, tables, triggers, macros, views, stored procedures, functions, joins and hash indexes in Teradata database.
• Worked with internal architects in the development of current and target state data architectures and documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Created Entity relationship diagrams (ERD), Function relationship diagrams (FRD), data flow diagrams (DFD) and enforced all referential integrity constraints using Erwin.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.

Environment: Oracle 10g/11g, Erwin r9.5, UDB, Informatica PowerCenter 9.1, SSRS, MS Access, MS Excel, Netezza Aginity, UNIX, MDM, MS Word, SQL Server, MS Outlook, SQL, T-SQL, Teradata SQL Assistant, Crystal Reports, PowerPoint 2007, Hadoop.

Confidential, Lake Forest, IL

Sr. Data Modeler/Data Analyst

Responsibilities:

• Developed normalized Logical and Physical database models to design OLTP system for finance applications. Created dimensional model for reporting system by identifying required dimensions and facts using Erwin.
• Conducted team meetings and Joint Application Design (JAD) session.
• Developed a Conceptual model using Erwin based on business requirements and produced functional decomposition diagrams and defined logical data model.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQLServer database systems
• 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.
• Managed the historical data in the data warehouse from various data sources and generated various drill down, drill through, matrix and chart reports using SSRS.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model and implemented Referential Integrity using primary key and foreign key relationships.
• Performed Data validation, Data cleansing, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, Teradata.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement and identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT) and applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Worked on enterprise logical data modeling project (in 3NF) to gather data requirements for OLTP enhancements.
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked in importing and cleansing of data from various sources like
• Teradata, Oracle, flatfiles, SQLServer with high volume data.

Environment: Erwin 9.x, SQL, SQL Server 2008, Rational Rose, Windows XP, Oracle 10g, TOAD, PL/SQL, Flat Files, Teradata, T-SQL, Netezza Aginity, MDM, informatica Power Centre, DB2, SSRS, SAS.

Confidential, Dallas, TX

Sr. Data Modeler/Data Analyst

Responsibilities:

• Review Mapping Documents formula and rule engine and Analyzing change request for the existing mapping and creating an impact analysis for the change on Data.
• Involved in Logical and Physical modeling of various Data marts as well as data warehouse and wrote new mappings specification according to the business data requirements and designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment and created Tabular, matrix and chart reports.
• Developed normalized Logical and Physical database models to design OLTP system for applications.
• Using SQL Server SSRS generate and maintain five business reports including dashboard report, matrix report, parameter report with charts and drill down function to monitor project progress and used store procedures, views, functions using Report Writer, SSRS and Crystal Reports.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Used Pivot tables, vlookups and conditional formatting to verify telemarketing data against data uploaded to proprietary database and online reporting.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Intensive data mining practice for data manipulation/extraction in Teradata environment for data integration and created data rules to handle SCD Type II data using PLSQL.
• Perform Source-to-Target Data Mapping in Informatica. (ETL) and optimized mappings.
• Reviewed all artifacts created with respect to Logical and physical data models including Tables, procedures, indices, synonyms, views, functions, triggers, sequence, and constraints.

Environment: ETL, SQL Server, Crystal Reports, Quality Center 10.0, Agile, Java, XML, HTML, Windows and Unix, Shell Scripting, SQL, Netezza, PL/SQL, TOAD for Oracle 9.x, Requisite Pro, Oracle 10g, Pivot Tables, MS Office, Erwin, Teradata, COGNOS, SAS.