SUMMARY

• 7+ years of professional experience in Data Modeling and Data Analysis as a Proficient in gathering business requirements and handling requirements management.
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin, IBM InfoSphere Data Architect 7.6.0 (IDA) and ER Studio Data modeling tools.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• Having a very good experience in working with IBM Rational Team Concert 3.0.1 (RTC)
• Good in Normalization / Demoralization techniques for effective and optimum performance in OLTP and OLAP environments.
• Having good experience with Normalization (1NF, 2NF and 3NF) and Denormalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Well - versed in designing Star and Snowflake Database schemas pertaining to relational and dimensional data modeling.
• Experienced in designing the data mart and creation of cubes.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Having experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.
• Efficient in analyzing and documenting business and functional requirements along with Use Case Modeling and UML.
• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures.
• Well versed in conducting Gap analysis, Joint Application Design (JAD) session, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
• An excellent experience in generating ad-hoc repots using Crystal Reports 9 and T-SQL.
• A good familiarity and experience in the work environment consisting of Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently

TECHNICAL SKILLS

Data Modeling Tools: Erwin r7.1/7.2/8.0, IBM InfoSphere Data Architect 7.6.0 (IDA), IBM Rational Team Concert 3.0.1 (RTC) and ER/Studio

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports9

ETL Tools: Microsoft DTS/SSIS,Data Stage 7.5, Ab Initio and Informatica 7.1.3

Programming Languages: SQL, PL/SQL, Base SAS, HTML, XML, VB.NET, C, C++, UNIX and Shell Scripting

Database Tools: Microsoft SQL Server 2000/2005, MySQL, Oracle 10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP andMicrosoft Visio

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, California

Data Modeler/ Data Analyst

Responsibilities:

• Conducted one-on-one sessions with business users to gather the requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Created Logical and Physical Data Models by using IBM Info Spear Data Architecture (IDA) 7.6.0 based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for banking applications.
• Responsible in creating the Business Objective Model (BOM), Logical Data Model (LDM) and Physical Data Model (PDM) by using IBM Info Spear Data Architecture (IDA) 7.6.0
• Used Forward Engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Used IDA for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships Diagram (ERD)
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Have a very good experience in using the IBM Rational Team Concert 3.0.1 (RTC) for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Exhaustively collected business and technical metadata and maintained naming standards.
• Worked with ETL teams and 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.
• Participated in data anomaly resolution, data cleansing and development of cleansing rules for ongoing data synchronization.
• Conducted impact analysis for changing business requirements as per user needs.
• Analyzed existing banking application versions along with design and technical teams to create Gap Analysis Documents.
• Studied in-house requirements for the Data warehouse to be developed.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• 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 phase.
• Developed necessary support documentation for end users, operations and testing teams.

Environment: Info Spear Data Architecture (IDA) 7.6.0, IBM Rational Team Concert 3.0.1 (RTC) Informatica 7.1.3, Windows XP/NT/2000, SQL Server 2000/2005, SQL, Oracle 8i, MS Excel, MS Visio, Rational Rose, Requisite Pro.

Confidential, Carmel, IN

Data Modeler/Data Architecture

Responsibilities:

• Conducting the meetings with business users to gather data warehouse requirements
• Conducted team meetings and Joint Application Design (JAD) session
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for education finance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Modeled a database to store customer demographic and other data.
• Produced functional decomposition diagrams and defined logical data model.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Exhaustively collected business and technical Metadata and maintained naming standards
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Created physical data models using forward engineering
• Identified the Facts and Dimensions.
• Worked with ETL teams and 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.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in Data Mapping.
• Participated in performance management and tuning for stored procedures, tables and database servers
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Worked with ad-hoc reporting using Crystal Reports and T-SQL.
• Responsible in integrated the work tasks with relevant teams for smooth transition from testing to Implementation phase.

Environment: Erwin, SQL, SQL Server, Rational Rose, Windows XP, Oracle,Windows.

Confidential, McLean, VA

Ab Initio Architect /Data Analyst

Responsibilities:

• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Worked on ETL effort estimates and preparing SRS for applications for couple of projects
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio
• Interact with business and document the requirements
• Understand and enhance the current architecture
• Review the functional and technical Design Documents.
• Prepare estimates for the CRs and upcoming projects
• Prepare project/Module implementation plan.
• Prepare deployment plan and support transition activities.
• Participated in Architecture and Design review with Customers.
• Worked with Data Architects in designing Physical model for.
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Managing the offshore team as Architect and Technical Lead.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log, Requirement doc, Technical spec, SOW, project Estimates etc.

Environment: Ab Initio, Db2, UNIX Shell Scripting, EME, Control M

Confidential, Emeryville, CA.

Data Analyst

Responsibilities:

• Responsible to play a key role in day-to-day support of Business Intelligence tools, Decisional and Reporting solutions, Business Objects, and underlying ETL framework.
• Responsible to gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Responsible to create Data Stage jobs to extract transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Provide application support to ensure availability and reliability of the shared Business Objects XI reporting environment, including administration and maintenance of user groups, users, folders, events, schedules and security.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Developed and maintained reports using in MS Excel queries, SQL in Teradata, and MS Access.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elemenomahats, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Participated in monitoring of Enterprise server performance and stability, and perform required support and maintenance to improve where necessary.
• Conducted analysis of alternatives and provide recommendations for support issue resolution.
• Worked with project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs.
• Performed peer reviews on all BO universes, reports and dashboards.
• Engaged in user facing and communication tasks while interacting with support teams, Business users and Super Users, vendors, and quality assurance team.
• Work with IT quality assurance and software delivery teams regarding code tuning efforts, project phase, post-implementation phase, and performance analysis, as matters are observed in the production environment.

Environment: RUP, UML, SQL Server, Informatica, Business Objects-Web Intelligence and Desktop Intelligence, MS Office Suite (Word, Excel, Access and PowerPoint).

Confidential

Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with the Business Analyst.
• Prepared business case for the data mart and then developed and deployed it.
• Part of the team responsible for the analysis, design and implementation of the business solutions.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables.
• Mapped the data between Source and Targets.
• Used Star schema methodology in building and designing the logical data model in the dimensional Models.
• Used MS Visio for creating of process flow diagrams.

Environment: Oracle Database 8i, SQL, PLSQL, Linux, MS Visio, TOAD.