Candidates About

Rohit

Sr. Data Modeler/Architect

(H1B Visa Valid till Nov 2018, GC In Process, Looking only for C2C)

Goal Oriented Data Modeler/Analyst having around 11+ 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 Training provided by Cloudera

Skill Set
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,Powerdesigner,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:

Fannie Mae, VA

Data Modeler                                                                                                                                              Dec 2015 – Current

Worked Extensively on Agreement Subject Area to Create Application and Data Warehouse Data Model for Fannie Mae’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.

JPMorgan Chase (Credit Card) – DE

Database Solution Architect/ Data modeler                                                                                                               Dec 2014 – Dec 2015

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

The HartFord Insurance. CT                                                                                                                                        Aug 2013 – Dec 2014

Sr. Data Modeler

The Hartford Financial Services Group, Inc. (NYSE:HIG), usually known as The Hartford, is a Fortune 500 company and one of America’s largest investment and insurance companies

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.

Barclays Capital, Investment Banking . NJ                                                                                                   Nov 2012- June 2013
Sr. Data Modeler

Barclays Investment Bank has offices in over 29 countries and since the acquisition of Lehman Brothers' main U.S. division in September 2008, employs over 20,000 people, over 7,000 people work in the IT division.

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.



ER Studio 9.1, TOAD, Oracle 11g, Informatica 9.1, SQL server , Agile , Star Schema, Kimball , Business Objects , SAP HANA

American Family Insurance Company. WI                                            Nov 2011 – Nov 2012
Sr. Data Modeler /Analyst

American Family Insurance (AmFam) is a private mutual company that focuses on property, casualty and auto insurance, but also offers commercial insurance, life, health, and homeowners coverage, as well as investment and retirement-planning products. A Fortune 500 company, its revenues for 2008 were over $6.7 billion.

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





Hilton Worldwide Inc. June.VA                                                                                                             June 2011 - Nov 2011
Data Modeler

Hilton Worldwide (formerly, Hilton Hotels Corporation) is a global hospitality company. The Blackstone Group, a private equity firm, owns it. Hilton brands encompass 3,750 hotels with over 600,000 rooms in 84 countries. Forbes ranks Hilton as the 36th largest private company in the United States. Recently decided to Create centralizes Contract management system (CMLS) for all contract related to the group and other parties.

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




BB&T Bank                                                                                                                              Oct 2008 Nov 2009
Data Modeler/ Data Analyst

BB&T Corporation, headquartered in Winston-Salem, N.C., is a fast growing; highly profitable financial holding company. BB&T Corporation is one of the top financial holding companies in the country. BB&T's operating strategy distinguishes it from other financial holding companies. This project is intended to develop a customer data warehouse to understand customer behavior to various products and services and identify critical customers in support of improved decision-making across the organization.

Roles and 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


Dell Corp. India                                                                                          Nov 2007 - Sep 2008
Data Modeler

The data warehouse environment at Dell includes a number of user-developed databases known as CSSs Client-Supported Systems that augment the core warehouse. The CSSs were co-developed by the business not by IT and as such are not product ionized per IT standards. As part of a larger effort called Rationalizing the Core (RTC) which aims to bring greater order, sharing and consistency to Dell systems it was decided to integrate a number of the CSSs into the core data warehouse and retire them.
Project mainly dealt with migrating the business reports created with excel from Oracle and SQL server to Teradata and create reports using BOBJ.

Roles and 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.


TIAA-CREF, India                                                                                     Sept 2005 - Oct 2007
Data Modeler

Advisor Services is the conversion of Siebel platform which will provide Advisor Services with the ability to more efficiently manage Advisor relationships and their business as a whole. With Greater Reporting capabilities Siebel will allow Advisor Services to better communicate their business needs to the organization. Advisor services use two separate systems that do not communicate with each other to track information on Advisor relationships, Goldmine and CAS.

Roles and 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 NT



Sprint Nextel Corporation                                                                                                                            Aug 2004 - Sept 2005
Business Analyst / Data Analyst

Sprint Nextel Corporation is the largest Wireless Company in the United States, with providing Wireless Phones, Sprint Mobile Broadband Card, and Sprint Relay Services, etc.

Roles and Responsibilities:

Responsibilities
Gathered and articulated business requirements from users and SME interviews and maintained the document repository on RequisitePro
Compiled Vision and Scope documents to better define the rationale for the project.
Derived Functional Requirement Specifications (FRS) based on User Requirement Specification (URS).
Wrote SQL queries to perform data validation, report validation and data integrity test effort.
Effort in different iterations and phases of software development life cycle (SDLC).
Prepared use case, process flow, and activity diagrams using MS Visio for a clear understanding of the requirements.
Conducted Risk Analysis to identify the risks associated with developing the new system, and formulated a Mitigation Plan to eliminate or reduce risks of high severity and major financial effects.
Assisted in reviewing test plan based on Requirement Traceability Matrix (RTM) and defect tracking using Clear Quest
Played a pivotal role in conducting Functional testing, Regression testing, and User Acceptance Testing (UAT).
Created bi-monthly status reports to keep the Business Lead informed of developments.
Prepared and updated all documentation for the project and interacted with all concerned departments on a regular basis.

Environment: VB, ASP .NET, HTML, XML, AS400/Main frame (Reflections 6.02) with DB2


Reference available on request
Education – Masters in Information technology, University of Virginia Graduated in June 2011