SUMMARY

• Over 8 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.
• Depth experience in Database Administration also experience in development methodologies like SDLC, AGILE, SCRUM and Waterfall.
• Extensive experience in Database Creation and maintenance of physical data models with Oracle, DB2 and SQLServer databases.
• Expertise in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) Teradata, ORACLE and other relational and non-relational 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 creating Use Cases, Use Case Diagrams, Class Diagrams, Sequence Flows using MS Visio and Rational Rose using UML concepts.
• Experience with Data profiling tools and proficient in Data Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Experienced in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
• 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.
• 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).
• Experienced on working around SQL on Hadoop technologies such as Hive, Impala & HBase.
• Excellent experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• Well versed in conducting Joint Application Design (JAD) and Joint Requirement Planning (JRP) sessions, User Acceptance Testing (UAT), Gap analysis, Cost benefit analysis and ROI analysis.
• Expertise in SQL queries, PL/SQL Packages, SQL Plus, Stored Procedures, Functions, Triggers and Performance Analysis, Creating Partitions, Indexes, Aggregating tables when required.
• Experience in performing root level analysis for data problems by identifying the system processes that lead to inaccurate data.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX shell Scripting

Databases: Oracle 12c/10/11g, Teradata R12, R13, R14, R15, MS SQL Server, MS Access, 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

ETL/Data Warehouse Tools: Web Intelligence, Tableau, Pentaho

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

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos Powerplay

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, SAS/SQL, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Data Management Analyst/Data Governance

Responsibilities:

• 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.
• Analyzed unstructured data from using SQL Queries.
• Generated multiple metrics to present the value of information according to the requirements.
• Used SQL Queries on daily basis for data analysis.
• Implemented data processes/flows, frameworks, controls, models, and solutions to ensure data is effectively managed across Consumer Bio (Deposits).
• Managed Data effectively using MHUB.
• 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.
• Performed Data validation, Data cleansing, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, Teradata.
• Creation and registration of Critical Data Element (CDE)
• Registered Business Terms and created business rules for Data Mart.
• Done Profiling on Data Sets for Data Mart.
• Defined and supported others in creating definition for Critical Data Element.
• Created Mapping Documents for CDE to PDE lineage.
• Generated custom report in MHUB as per client requirements.
• Conducted JAD session and worked closely with SR.Business analyst to understand the requirement.
• Converted BRD into Technical Document and Conducted session with offshore team to walk through the requirement.
• Held session with offshore ETL team to walk through Mapping Documents and answer any question related to logic and requirement.
• Registered SYSRs in Application management lifecycle (AML) system.
• Registered Change control and managed priority list.

Environment: Erwin r9.6, Teradata, Oracle 12c, Microsoft SQL Server 2012, DB2, Toad, SSRS, T-SQL, Teradata SQL Assistant, UNIX scripting, PL/SQL Programming, Express IT

Confidential, Pittsburg, PA

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.
• Used Teradata FastLoad utility to load large volumes of data into empty Teradata tables in the Data mart for the Initial load and used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• 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, 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.
• Used several transformations like expression, Aggregator, Lookups, Joiner, Normalize, Router, update strategy, Filter, Union, Sequence Generator, Stored Procedure, Source qualifier, XML transformation, etc
• Involved in Performance tuning the SQL Server Queries which is used in SSRS Reports and developed Ad Hoc Report Model for specific users is SSRS.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) to load it into a single data warehouse repository.
• Used SQL for Querying the database in UNIX environment and fine- tuned the mappings using push down optimization, session partitioning, bulk load, fast load, etc.

Environment: Erwin r9.6, Teradata, Oracle 12c, Microsoft SQL Server 2012, SVN tool, Load, SSRS, T-SQL, Teradata SQL Assistant, Fast Load, UNIX scripting, PL/SQL Programming

Confidential, Mayfield, OH

Data Modeler/Data Analyst

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.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica PowerCenter and created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• 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 and Configured Workflows, work lets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager and worked with NZLoad to load flat file data into Netezza tables.
• 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, PowerPoint 2007.

Confidential, Memphis, TN

Data Modeler

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.
• Loaded Flat file Data into Teradata tables using Unix Shell scripts Interact with clients/business users when issues arise on Data governance
• 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.
• Developed the SQL scripts and Procedures for the business rules using Unix shell and NZSQL for Netezza
• 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.

Confidential, Lahore, Pakistan

Data Analyst

Responsibilities:

• Involved in gathering user requirements along with business analysts. • Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Identified the key facts and dimensions necessary to support the business requirements and developed the logical dimensional models.
• Used Rational Rose for Object Modeling in UML and worked with Master Data Management.
• Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
• Assisted the DBA in converting the logical models to physical and released the reports through UNIX shell script in every month based on requirement
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Conducted Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Used Erwin for developing data model and forward engineer the data model.
• Reverse engineer the data base in to physical data model by using Erwin.
• Developed entities and relationships using Sybase PowerDesigner. • Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents between legacy, production and user interface systems.
• Designed different type of STAR schemas like detailed data marts, Plan data marts
• Used Erwin for monthly summary data marts and inventory data marts. • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Oracle 9i, Windows NT, ER-Win, Sybase Power Designer, Teradata, UNIX, SQL Loader, Data Junction, Rational Rose 2000, Linux, Oracle Express Server