Professional Summary:

• Around 6+ years of professional experience working as a Data Modeler/Analyst, business system analyst with diverse industry verticals like insurance, banking and service domains.
• Extensive experience in developing logical and physical data models for both transaction as well as analytical systems.
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling.
• Experience in analyzing the business requirements and creating Business Requirement Document (BRD). 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.
• Proficient in requirement gathering, Organizing JAD sessions, one to one interviews, and focus groups.
• Well versed in Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments.
• Expertise in Data Modeling using tools likes ERwin, ER Studio and Power Designer.
• Experience with Teradata using database commands and Teradata utilities such as BTEQ, SQL Assistant, Fast Load, Multi Load, Fast Export etc. Worked extensively on XML Schema designs.
• Hands on experience with modeling using ERwin in developing Entity-Relationship, modeling Transactional Databases and Data Warehousing, Dimensional Data Modeling for Data Marts and Fact & Dimensional Tables.
• Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping and data profiling tools.
• Extensive Experience working on SQL Queries along with good experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Good Understanding and Knowledge with Agile and Waterfall Environments.
• 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).
• Excellent in verbal and written communication, organizational skills combined with the ability to work in a fast paced environment as an individual and/or as a team member.

Technical Summary:

• Data Modeling Tools: ERwin 7.1/7.2/7.3, System Architect 11.3, MS Visio 2000/2007/2010, ER/Studio, Power Designer 11.0/12.0/12.5/15.
• Databases & Database Tools: MS & SQL servers 2000/2005/2008, Oracle 9i/10g/11g, MS Access 2003/2007/2010, Teradata, My SQL.
• Reporting Tools: Cognos 8.3/8.4, Congos Report Studio, Cognos Analysis Studio, Cognos Framework, Microstrategy
• Operating Systems: Linux, Unix, DOS, Win Server 2003/2008, WIN 98/NT4/0/2000/XP/VISTA./ WIN
• Languages: MY SQL, PL/SQL, SQL.
• ETL Tools & Others: Informatica Power Center 8.x, Tools Include Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, MS Office, Rational Requisite Pro, SharePoint

Work Experience:

Client: Confidential, Washington DC April 2011 - Present
Role: Data Modeler/Data Analyst
Confidential is a global connector of knowledge, learning and innovation for poverty reduction. It is part of Confidential. It connects practitioners, networks and institutions to help them find solutions to their development challenges. To fund development projects in member countries, Confidential bonds are issued by the International Bank for Reconstruction and Development (IBRD) in the international capital markets.

Responsibilities:

• Gathered and translated business requirementsintodetailed, production-level technicalspecifications, new features, and enhancements to existing technical business functionality.
• Worked is close coordination with the PM and the Business owners to developed project vision and define the scope of the project.
• Developed Project Plan with Project manager's assistance for the first two phases of the Project.
• Worked with DBAs to create a best fit physical data modelfrom thelogical data model using forward engineering in ERwin.
• Extensively used ERwin to model and transform date requirements in to data models and maintaining the database schema.
• Widely used Normalization methodsandhave done different normalizations (3NF).
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tableswith data and performedunload/copy/replicate datafrom one databaseinto another after detail analysis and design.
• Involved in the Database design and application development to support the creation and management of online business unitsforbusiness usersand customers usage.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms and documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Generated the DDL scripts by forward engineering the physical model and interacted with DBA to implement the physical database.
• Involved in the process of loading data intoTeradataand creating Process Flow Diagrams using MSVISIO.
• Analyzed the performance of the job during the project. Utilized standard techniques for enhancing the performance.
• Authored User reference documentson all the deliverables created for future reference by Business Users and conducted training sessions.
• Documented and delivered Functional Specification Document to the project team.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries.

Environment: DB2, ERwinr7.3, MS Visio, Teradata 12, SQL, PL/SQL, HTML, MS OFFICE.

Client: Confidential, NYC April 2009-March 2011
Role: Data Modeler/Analyst
It is an American multinational banking corporation of securities, investment and retail. JP Morgan is the one of the big four banks of the United States with Confidential. The main objective of the project was to build a Data Warehouse for the Financial Aid/Loans provided to University Students for their Education. The source system involves multiple databases like Oracle, SQL Server and Teradata. The data was extracted from these sources, then it was transformed and then finally loaded into Data Warehouse. This Warehouse will help the management to better understand the trend and help in improving the company's performance.

Responsibilities:

• Working with the Business Analyst and DBA, conducting team meetings and JAD Sessions for technical requirements gathering, business analysis, testing and project coordination.
• Analyze and evaluate existing system for assessing how it supported functions from the Use Case diagrams and UML diagrams.
• Developed Logical data model using ERwin 7.2 and created physical data models using forward engineering.
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin 7.2.
• Used BTEQ for SQL queries, and TPump for loading data from source into Teradata tables
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Participate in updating the dimensional model, and identify the Facts and Dimensions.
• Employed process and data analysis to model a Customer Information Business System.
• Produced functional decomposition diagrams and defined logical data model.
• Coordinated with ETL team for analysis and reporting needs.
• Developed data migration strategies and impact analysis for database.
• Design, plan and program data conversion procedures from old to new databases.
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality.
• Model a database to store customer demographic and other data.
• Work with Business analyst to design weekly reports using a combination of Cognos Impromptu and Power play multidimensional, to deliver reports to CEL and Marketing groups.
• Design complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to incorporate the new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: DB2,Teradata V2R5, SQL, Cognos Impromptu 7.2, Cognos 7.2, ERwin 7.2, XML, Microsoft Access, Microsoft Excel.

Client: Confidential, LA Oct 2007- March 2009
Role: Data Modeler/Data Analyst
Confidential is one of the largest insurance and financial service providers in the United States. The firm provides a range of services in the areas of property and casualty insurance, life and health insurance, asset management and banking. Designed and developed a client server application that is easy to use and provide the Nationwide Finance System (NFS) Retail Business Management group with sufficient information from the Entity Information File (EIF) database to maintain relationships with current clients and identify opportunities for new entity relationships.

Responsibilities:

• Involved in gathering business requirements by conducting a series of meetings and brain storming sessions with the business users.
• Gathered and translated business requirements into detailed, production-level technical specifications, new Features, and enhancements to existing technical business functionality.
• Involved in identifying the process flow, the work flow and data flows of the core systems.
• Worked extensively on user requirements gathering and gap analysis.
• Created Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department.
• Conducted logical data model walkthroughs and validation.
• Worked with DBA's to create a best fit physical data model from the logical data model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the reverse engineering ER/Studio tool.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using ER/Studio.
• Involved in designing the integrated Data Warehouse for the company to store the data from the OLTP systems.
• Involved in implementing and testing of the developed application data standards.
• Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
• Data Warehouse - Designed and programmed ETL and aggregation of data in target database, working with staging, de-normalized and start schemas and dimensional reporting.

Environment: SQL Server 2000, Oracle 10g, ER/Studio, PL/SQL, UNIX, Windows NT.

Client: Confidential, India Nov 2006-Oct 2007
Role: Data Analyst
Confidential is one of the largest financial groups in India. The project involved key retail financial operations, such as automated teller services, signature verification, and tracking of uncollected funds.

Responsibilities:

• Involved in designing physical and logical data model using ERwin Data modeling tool.
• Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables fordata marts.
• Extensively used ERwin data modeler to design Logical/Physical Data Models, relational database design.
• Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.
• Created Triggers, Views, Synonyms and Roles to maintain integrity plan and database security.
• Creation of database links to connect to the other server and Access the required info.
• Integrity constraints, database triggers and indexes were planned and created to maintain data integrity and to facilitate better performance.
• Used Advanced Querying for exchanging messages and communicating between different modules.
• System analysis and design for enhancements Testing Forms, Reports and User Interaction.

Environment: Oracle 9i, SQL* Plus, PL/SQL, ERwin, TOAD, Stored Procedures.