PROFESSIONAL SUMMARY:

• Goal Oriented Data Modeler/Analyst having around 12+ years of extensive experience in data analysis, data modeling, design, development and implementation of OLTP, Data Warehouse & Business intelligence
• Extensive business domain experience in Finance, Banking & Insurance.
• Hands on experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling
• Expertise in Data Modeling using tools likes ERWIN, Embarcadero ER Studio, IBM Infosphere and MS Visio along with the hands on experience in using Forward Engineering and Reverse engineering functionality.
• Hands-on experience with data architecting, data warehousing, data mining, large-scale data modeling, business Intelligence, data sharing techniques across enterprise systems, system analysis, business requirements gathering/analysis and experienced in implementing enterprise data management procedures
• Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping and data profiling tools.
• Demonstrated expertise with repository creation, and data and information system life cycle methodologies
• Experience with business requirements analysis, entity relationship planning, database design, reporting structures.
• Excellent experience in sub model/subject area sync, compare and merge operations
• Experience in working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverables in the Organization by creating Use Case Models, Data Flow Models, Workflow Analysis, Functional decomposition Analysis, Object Modeling along with Activity Diagrams
• Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience on various Software Development Life Cycles including Analysis, Design, Development and Testing to solidify client requirements in conjunction with Software Developers.
• Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling
• Experience in implementing Data warehousing solutions involving Dimension modeling and Snow flake schema implementation (3 NF).
• Excellent experience in Extract, Transfer and Load process using ETL tools like Data Stage, Informatica, Data Integrator and Sql Server Integration Services for Data migration and Data Warehousing projects.
• Involved in performance optimization of DWH solutions, both on ETL as well as Database side.
• Experience in preparing project cutover plan, test plan with test cases for unit test, regression test and User Acceptance Testing (UAT)
• Strong experience providing support during User Acceptance Testing
• Highly skilled in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Excellent experience in problem solving and supporting applications comes under 24/7
• Good team player, hard working, excellent work ethics, enthusiastic and high adaptability to changes in technology.
• Worked with the senior members of team to improve quality processes and data modeling best practices while implementing the projects.
• Completed 3 Day Big data provided by Cloudera

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/8i/7X,SQL Server 2000/2005 and SYBASE ASE 15,Teradata

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 5.9, 5.10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

LANGUAGES: SQL, PL/SQL, T-SQL, C, C++, VB, UNIX Shell Scripting, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), Erwin, TOAD, Power designer, Embarcadero, MS Visio, Rational Rose, SQL TRACE, EXPLAIN PLAN, TKPROF, SYBASE Central and MS Management Studio

WEB TOOLS: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metal ink, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, VA

Data Architect

Responsibilities:

• Worked Extensively on Agreement Subject Area to Create Application and Data Warehouse Data Model for Confidential ’s High visibility Agile methodology Project “CETS”.
• Worked on Coordinating with 4 Different Team to Document and Spec out the requirement.
• Created Logical and Physical Data Models with Source to Target Mapping Document.
• Used ER Studio for Creating/Updating Data Models.
• Designed Informatica ETL Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc.
• Created DDL, DML & PL/SQL script for deployment.

Confidential - DE

Database Solution Architect/ Data modeler

Responsibilities:

• Working closely with Data Modeling Manager to overlook different modeling projects within Commercial Card Business (CCB)
• Working simultaneously on multiple Data modeling task within Chase Card LOB
• Worked on model maintenance project to decommission Erwin Model manager
• Regularly profile data, publish data profiles and take corrective actions if required to ensure high quality data
• Document / reverse engineer / analyze data mapping using data integration code/tools
• Defined standards for naming, describing, managing, modeling, cleansing, enriching, transforming, moving, storing, searching and delivering all data within the enterprise and do gap analysis and resolution, if needed
• Designed and documented logical and physical Enterprise Application (OLTP) and Data Warehouse (OLAP) databases and created related ETL Design Specifications and supporting documents
• Extensively Used Erwin functionality for Reverse engineering, forward engineering & complete compare
• Created Implementation plan for Physical Model in respective Database.
• Generate DDL for Documentation and Implantation according to JMPC standard
• Used Teradata SQL assistance and SQL navigator for Data Analysis

Confidential

Sr. Data Modeler

Responsibilities:

• Working on Multiple Data warehouse projects simultaneously.
• Worked with large group of Data modeler team
• Developed conceptual, Logical, Physical Data Model Using Ervin 8.2 based on Business requirement.
• Used Informatica, Oracle TOAD and Trillium 8 extensively for data Analysis and profiling.
• Coordinated with onsite and offshore team on daily basis.
• Developed source to target Mapping document based on Hartford standard mapping template and conducted mapping reviews
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Resolved the data type inconsistencies between the source systems and the target system.

Confidential, NJ

Sr. Data Modeler

Responsibilities:

• Studied In house Requirement for The data Warehouse to be developed for Compliance IT Department.
• Worked on two projects for Issue Tracking and Management Reporting.
• Developed Source to Target Mapping from 13 Major source systems.
• Developed Relational Staging and Star Schema Target Data Model for Management Reporting.
• Studied Source Data Model to extract more information.
• Identify Mata Data, its properties, constraints and Relationship from Multiple source Systems.
• Used ER studio to create Data Dictionary and Model Repository
• Used Toad for Creating and updating Physical Data Model.
• Sole owner for All DDL of the project.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Worked with Team of BAs to facilitate Data Analysis.
• Coordinated with ArcLogic team for Development of Issue Tracking Tool.
• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.

Confidential

Sr. Data Modeler /Analyst

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Responsible for Model Reviews at AMFAM Data modelers meetings.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint requirements Development sessions
• Developed a Conceptual, Logical model using ER Studio based on requirements analysis
• 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 ER Studio
• Facilitate creation/migration of data objects (DDL) across Development /QA/Production
• Worked on onshore-offshore model
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Created Billing CSA and Data Mart from scratch
• Coordinated with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards for data warehouse
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 database systems
• Exhaustively collected business and technical metadata and maintained naming standards
• Used ER studio for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges
• Responsible for Modifying/Upgrading Dynamic Data Mode provided by Guidewire as per Amfam Standards
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation
• Created OLAP data cubes, to show dimensions and reporting formats that would be identical to the applications client would be using
• Responsible for updating Enterprise data dictionary provided by Guidewire

Environment: ER Studio 8.1, WinSQL Informatica 7.1.3, SAP HANA, Windows XP/NT/2000, Oracle11g,DB2, MS Excel, Agile. Guidewire

Confidential, VA

Data Modeler

Responsibility:

• Worked as Business Analyst for Business requirement from all stake holders through one to one meetings & JAD sessions
• Participated in all Business and technical Meeting to facilitate User need.
• Understand Hilton Data Base and suggest the best way out for Logical data model
• Identify Mata Data, its properties, constraints and Relationship
• Creating Logical and Physical Design of Database and ER Diagrams with all related entities and relationship with each entity based on the rules provided by the business manager. Worked extensively in forward and reverse engineering processes.
• Assisted in analyzing risks and Developed Risk Mitigation plans for identified risk.
• Assisted the project manager in creating detailed project plan and scheduling and tracking project timeline using MS Project.
• Worked with ETL team to create source and Target Data Model for Reporting.
• Worked on Gathering Reporting Requirement from Users.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Designed SSIS Design & Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.
• Worked with the Test Lead to prepare test cases based on the Requirement Traceability Matrix (RTM).
• Worked on offshore-onshore model with TCS.

Environment: .Net, IBM Infosphere, SQL 2008, Cognos, SSIS, MS office, MS Visio

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Participated in Joint Application Design/Development (JAD) sessions and involved in discussions with clients/users to determine the dimensions, hierarchies and levels, basic measures, derived measures and key metrics for relational / multidimensional data model for the system, understanding reporting requirements, designing star schema data model. Extensively involved in requirement analysis.
• Experienced using ERwin for Data modeling for creating Logical and Physical Design of Database and ER Diagrams with all related entities and relationship with each entity based on the rules provided by the business manager. Worked extensively in forward and reverse engineering processes.
• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Worked on the Data Warehouse team analyzing data files that had to be compiled from disparate non-production sources and readied them for production. Tasks included: comparing data to requirements documentation, creation of data layouts, data dictionary, and the pipe delimited and fixed width files. In addition, was team lead for managing the completion and loading of these files for the Data Management group
• Participated as member of a project team performing various lifecycle tasks for an intranet application with Oracle database for tracking public offering orders. Developed logical and physical database models and data dictionary documentation. Worked as liaison between users and developers refining and explaining user requirements.
• Assess data quality requirements in terms of data completeness, consistency, conformity, accuracy, referential integrity, duplication and evaluate vendors (Informatica Data Explorer/Data Quality, identify and measure data quality, design and implement data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
• Develop data quality reports/dashboards with Cognos Framework Manager and Report Studio.
• Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc..
• Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
• Worked as a Data Warehouse and Database Developer. Core responsibility is to interview with customers and subject matter experts to gather the requirements for a proposed database analyze these requirements and source systems required to build the data warehouse using Data Warehouse Builder.
• Data Architect in a centralized group doing logical and physical data models in ERWIN. Also, wrote database interface specifications and documented in Data Manager data dictionary.
• Designed Informatica ETL Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.
• Extensively used Erwin and Normalization Techniques to design Logical/Physical Data Models, relational database design.
• Experience with utilities Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
• Conducted data modeling sessions for different user groups, facilitated common data models between different applications, and participated in requirement sessions to identify logical entities.
• Extensively involved in creating, maintaining, updating documents like requirement document, database design document, System design document, naming standard procedures, SOPs etc.
• Analyzed and optimized the existing business processes using Conceptual Models and Data Flow Diagram. The process included performance enhancement requirements assessment and mapping of existing workflow and data flows.

Environment: Erwin, Informatica Power Center v 8.6.1, IBM Data Stage7.5.1, Power Exchange, DB2v9.5, XML/XSD, Qwest Center, MS SQL Server, Teradata, RedHat Linux Shell Scripts, PL/SQL, IBM Control Center, Cognos v8, TOAD, PVCS, Microsoft Project Plan

Confidential

Data Modeler

Responsibilities:

• Familiarity with the offshore/onshore model to co-ordinate with both reporting and ETL offshore teams regularly.
• Participated in Daily Status meeting and Weekly Status Reports of the group and meeting with Manager and Client Executives.
• Played a major role in SDLC from requirement, design, development, testing and rollout to the field user and support for production environment.
• Analyze old CSS application reports running on SQL and Oracle, look into the stored procedures and sql statements running behind the scene and decide on the tables needed to be migrated from SQL and Oracle to Teradata Warehouse.
• Discuss with reporting team and report users about the tables needed to be migrated and used Erwin to design Logical/Physical Data Models, relational database design, forward/reverse engineering, publishing data model to acrobat files using the DELL naming conventions and co-coordinated with DBA to apply the data model changes in production.
• Analyze the data present in the source system before migration to the target and identify the Unicode issues and give a clear picture to the ETL team about the kind of data the needs to be migrated.
• Created informatica mappings and sessions by importing source and target tables with appropriate transformations required for the data to be migrated to Teradata.
• Perform Database Administrators task on Teradata Development Database like create tables, collect stats, creating indexes, grant access, verify the distribution of data on all amps, load tables from a text file using the import option in T-SQL Assistant.
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model. The design document was finalized through conduct of design walkthroughs, and independent review by the user
• Analyze the cubes, dtss/ssis packages running on SQL and Designed and Developed Star Schema and created Fact and Dimension Tables for the TERADATA Warehouse using Erwin.
• Informed the users about the expected difference between excel reports and BOBJ reports.

Environment: ERWIN 7.3, NEXUS for Teradata, T-SQL, TOAD for oracle, SQL Server Management studio, SQL Enterprise Manager, Informatica 8.6, Control-M Job scheduler, Oracle 9i, SQL, PL/SQL, Windows 2000, Teradata.

Confidential

Data Analyst

Responsibilities:

• Designed and mapped the data from various legacy sources onto Siebel OLTP.
• Extracted data from different sources like Teradata, Oracle, and Flat files.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Actively involved in designing of low level process diagram for the project, Consumer Data Warehouse.
• Designed the logical data model from the technical design documents and translating to a physical data model using ERWIN/ERstudio.
• Worked on Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes.
• Data Modelers analyze the data from different sources, design Data Models, and then generate scripts to create necessary tables and the corresponding records.
• DBAs create the databases and tables based on the scripts generated by the data modelers.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
• Written SQL overrides in source qualifier according to the business requirements.
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
• Writing PL/SQL stored procedures, Functions, packages and triggers and exported into Informatica (ETL) and used them wherever stored procedure required for improving performance.
• Involved in Teradata performance tuning
• Created sessions and workflow for designed mappings
• Documented the design using Microsoft VISIO.
• Production Support and troubleshooting of ETL workflows and sessions

Environment: Siebel 7.8, OBIEE, Erwin, Informatica 7.3, Teradata, COBOL, ORACLE9i, DataStage UNIX, Windows