SUMMARY:

• Over 12+ years of IT experience working as and working as a Technical Architecton Enterprise data warehouse projects and Transactional Applications database design.
• Strong Data Modeling experience (Teradata FSLDM/ IBM BDW) using ER diagram, Dimensional data modeling, Star Schema modeling, Snow - flake modeling using tools like Erwin, EMBARCADERO ERStudio.
• Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin, E/R Studio and IBM Rational .
• Possess strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications.
• Work with ETL teams to create source to target mapping, data profiling and project management.
• Leveraging / implementing data modeling standards, profiling legacy databases, developing data mapping, Data Lineage analysis & documentation, cleansing and migration rules to a new enterprise database, generating DDL and collaborating with the Development team on implementation of the DDL
• Also have a strong knowledge and understanding of Data Modeling and Data Governance, Meta Data Management, Master Data Management and Data Management best practices. Understanding and knowledge of Airline, Financial Services, Retail and Consulting Sectors.
• Experience in backend programming includingschema and table design, Partitioning, stored procedures, Triggers, Views, and Indexes.
• Experience in DW/BI tools like Informatica, Talend DI, Teradata, Netezza, Tableau, SAS BI etc.
• Good communication skills with strong interpersonal, written and verbal skills

TECHNICAL SKILLS:

Data Modeling: Data Modelling (Conceptual/Logical/Physical) for relational and dimensional databases, Data Warehouse-Database Architecture design (Staging, data profiling, data mapping, data integration, Table Partitioning), Data Management & Data Analysis. Also have good understanding of Hadoop Framework, NoSQL Database - HBASE, Hive, Apache Spark

Data Modeling tools & Techniques: Erwin 7.2/4.5/4.1.4/3.5.5/3.5.2 , ER Studio 7.1.1/7.5,9.0,10.0 IBM Rational System architect, Dimensional Modeling, Relational Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data mart, OLTP, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, Teradata SQL Assistant, Aginity for Netezza, HTML, C#, Unix Korn Shell Scripting, PERL.

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/ 95/98/2007/2008 , Win NT/ XP Professional, Red Hat Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

Sr. Data Modeler/Data Architect

Responsibilities:

• Supported enterprise based data warehouse applications by provision of data modeling services.
• Created system requirements from functional requirements and Logical data model for OLAP systems, inbound and outbound Feeds to and from data warehouse
• Analyzed FRs, attended meetings with customers, designed, provided logical/Physical model (LDM/PDM) for EDW & data marts, source to target mappings and performed walk-throughs to offshore/business stakeholders and hand over for development.
• Create and maintain a fully attributed data model in ERwin. Design and document new tables need to support the reporting requirements.
• Produced a source to target attribute level data mapping cross document
• Data mapping is prepared using Business Rules and data transformation logic for ETL purposes.
• Involved in Migrating the data model from one source database to NZ database and prepare staging models by the process of Reverse and Forward Engineering.
• Work with the DBA on the first cut physical design of the new tables.
• Created schema objects like Indexes, Views and Sequences
• Perform data profiling, data cleansing, and data quality. Enforce standards and best practices around data modeling efforts.
• Provided technical assistance for inclusion of new data structure into Meta data strategies and plans.
• Conducted research and documented data quality aspects and potential resolution.
• Provided technical assistance for designing and development of Netezza Stored Procedures in production.
• Optimization and query performance tuning in Netezza using various techniques involving distribution analysis, data-type analysis, zonemaps, CBTs, configuration parameters etc.
• Proficient in writing stored Procedures in Netezza and converting cursor based PL/SQL procs into set based nzsql procs
• Developed NZSQL procedures to different to perform transformations requires joining data from several sources, generating aggregates, generating surrogate keys, sorting, deriving new calculated values, and applying advanced validation rules(Merge and Data De-Duplication).
• Assisted in the design of report layouts to maximize usability and business relevance.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse. Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.

Environment: ER-Studio 9.0, Erwin v9.5, Informatica v10, Tableau 7.0.10, Windows, Netezza 7.2.1, UNIX.

Confidential, New York, NY

Senior Data Modeller/Architect

Responsibilities:

• Developed database models and support documentation in order to meet business requirements for reporting and analytic databases.
• Analyzed data sources and requirements and business rules, performed logical and physical data modeling, wrote prototype SQL to prove data transformations
• Map source system attributes to targets within the FSLDM.
• Extend the existing FSLDM to add new entities and attributes related to use cases and Business needs
• Reverse Engineered various Source databases and then forward engineered them to Teradata using ERWIN.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• Maintain data lineage from source systems to support impact analysis for changes to the integrated data warehouse.
• Extensively worked on the naming standards which incorporated the enterprise data modeling
• Used data profiling tools and techniques to ensure data quality for data requirements.
• Gather feedback from the development team on the physical model, for any specific operational/performance requirement, which needs demoralization.
• Analyze if existing data structures can be reused, thereby, saving development costs.
• Coordinate data models across marts and warehouses; manage dictionaries and other documentation across multiple data marts and data warehouses.

Environment: Erwin Data Modeller, Datastage, Teradata.

Confidential

Teradata Enterprise Architect

Responsibilities:

• Attended and participated in information and Requirements Gathering sessions.
• Ensured that Business Requirements can be translated into Data Requirements.
• Translated Business Requirements into working Logical and Physical Data Models.
• Developed the Logical and physical data model and designed the data flow from source systems to Enterprise Datawarehouse (Teradata FSLDM) and then to the Target reporting system/Data Marts.
• Designed the technical specifications document for Teradata ETL processing of data into master data ware house and strategized the integration test plan and implementation.
• Developed complex Stored Procedures, BTEQ, Multi load and Fast Load scripts for loading data into Teradata tables from legacy systems and source systems.
• Used advanced data modeling concepts such as Family of Stars, Confirmed Dimensions, and Bus Matrix in order to handle complex BI reporting requirements
• Designed Star and Snowflake Data Models for various Reporting requirements (BASEL/FATCA/Anti-Money laundering/Payment protection insurance/FSCS) and product specific datamarts from Enterprise Data Warehouse using ER Studio.
• Data modeling in Erwin; design of extended target data models for enterprise data warehouse (Teradata) and various product specific datamarts (Cheques/Deposits/Loans/Mortgage/Insurance) etc based on business requirements.
• Capture technical metadata through data modeling tools.
• Documentation of all Entities, Attributes, Data Relationships, Primary and Foreign key Structures, Allowed Values, Codes, Business Rules, Glossary Terms, etc.
• Worked extensively on Transactional- grain, Periodic snap shot grain and Accumulating snap shot grain while designing dimensional models.
• 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.
• Designed the Database Tables, Views, Triggers, Macros & Created Table and Column Level Constraints using the suggested naming conventions for constraint keys.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance batch and response time of data for users.
• Developed and designed automated solution using Teradata macros, stored procedures and excel macros for business users to load data directly to tables and to automate various housekeeping/reconciliation processes within the physical database.
• Maintained Data Model and synchronized it with the changes to the databaseas part of day to day responsibility
• Involved in all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Attendant architecture meeting and data governance meeting to understand the project.
• Identified and mapped (Data Mapping) applying transformations based on business rules various data sources and their targets successfully to create a fully functioning data repository.

Environment: Erwin, ER-Studio Architect 9.0/10.0, Data Stage, Teradata.

Confidential

Data Modeler/ETL Designer

Responsibilities:

• Dimensional/Dmart data modeling for the Marketing, Campaign and Finance department of the group.
• Conceptual and Logical data models development; Standards development including naming rules, class words, domains; extending data dictionary to accommodate new DW contents; data mapping from existing and new systems to the datamart, planning of data transfer to ETL repository; Designed logical data models, Teradata/Oracle physical data models, and semantic data models to support Shopko's Finance Reporting that resided over Teradata while their Campaign Management and Customer relation management datamarts reside over Oracle.
• Involved in designing the ETL architecture and Source to Target mapping to load data into Data warehouse and other reporting documents.
• Created mapping documents to outline data flow from sources to targets.
• Worked in Informatica to design and develop mappings to load into Data warehouse. The project involves building and maintaining data warehouse to meet the organization reporting needs. Data warehouse will function as the central repository of all sales data which is extracted from various sources and loaded into Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings in the Informatica Designer.
• Developed Mapping parameters and Variables to support SQL override.
• Created Mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Designed and developed Archiving program written in PLSQL
• Involved in Database performance tuning effort; Analyzed the database stats from the production system to determine performance issues, running explain plans, created table partitions for several tables that have large volume of data and having a wide data structure, analyzed the slow running queries rewrote the queries, or determined an index was necessary.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loaded into data warehouse.

Environment: Erwin, Informatica, Oracle 9.1, Unix, Unix Shell Scripting, Teradata12.1.

Confidential

Sr. Database Developer

Responsibilities:

• Interaction with Business Clients for implementing the requirements
• Analysis, design, coding and testing of COBOL, VSAM, CICS,DB2programs for the Customers Trade Processing Systems
• Created DB2, SQL queries and stored procedures for ad hoc reporting.
• CreatedCICSprograms that executed in house web services utilizing IBM’s MQ Broker Queues
• Development of Mainframe code using COBOL, DB2, JCL, VSAM,CICS, SQL, DB2 utilities like load, unload, etc., JCL utilities like sort, etc.
• Coordinate with the front end teams in regression testing the Applications
• Unit Test Cases (UTC)/ Test Data creation
• Worked in Endeavor, File Aid, Smart Test, SAR, XPEDITOR, SPUFI, EZTRIEVE IBM Utilities
• Utilize the business intelligence enterprise system software development suite(SAS BI) to create, maintain and publish reports, dashboards, scorecards, and other visual information displays through front end interfaces as well as through application and database programming
• Analyze and troubleshoot system, application, and user issues resulting from the use and/or release of functionality
• Develop, and implement information delivery solutions for the purpose of providing business intelligence

Environment: DB2 v9.1, DB2 PL/SQL, DB2 Stored procedures, MVS, & z/OS COBOL, CICS, VSAM, SAS BI.

Confidential

Java Developer

Responsibilities:

• Coordinating with Project Manager for getting the requirements and developing the code to support new applications.
• Providing Java programming support for existing and new applications.
• Designed the Front-end Screens using JSP, Servlets, HTML and JavaScript.
• Wrote SQL queries and PL/SQL procedures for JDBC.
• Involved in system design and development in core java using Collections, multithreading and exception handling

Environment: Java, Servlets, JSP, JDBC, Spring, HTML 4, CSS 3,Javascript, Oracle