PROFESSIONAL SUMMARY

• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm 3NF and Multidimensional Data Modeling Schema Star schema, Snow-Flake Modeling, Facts and dimensions .
• Expertise in Normalization/De normalization techniques for optimum performance in relational and dimensional database environments.
• Expert in data analysis, design, development, implementation and design and code reviews for Extraction, Transformation and Loading ETL .
• Dimensional Data Modeling experience using ER/Studio, Erwin, Multidimensional Data Modeling Schema- Star Join Schema, Snowflake modeling, Fact Dimension tables, Conceptual, Physical Logical Data modeling.
• 8 years of experience in IT industry with expertise as Data Modeler, Data Quality Analyst, Business Analyst and Data Analyst.
• Expert at Full SDLC processes involving Requirements Gathering, Source Data Analysis, Creating Data Models, and Source to target data mapping, DDL generation, performance tuning for data models.
• Responsible for interacting with business users to identify information needs and business requirements for reports.
• Excellent team member with interpersonal and communication skills, highly motivated, result oriented with strong analytical, organizational, presentation and problem solving skills.
• Expert in developing effective working relationships with client team to understand support requirements, developed tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler

PROJECTS WITHIN:

BASEL II

Responsibilities:

• Conducting JAD sessions with business to extract Data Modeling requirements.
• Designing and maintaining the Logical /Physical Staging Data Models.
• Generating the DDL statements and working with the database team in creating the tables, views, keys in the database.
• Conducting turnover sessions for the designed data model to stakeholders / business for approval.
• Implementing and executing Ad-hoc and weekly requested Data Modeling changes as a part of Release process.
• Reverse Engineering the SQL scripts to design Data Model stage tables.
• Metadata capturing of the designed tables from ERwin 7.3

confidential

Data Analyst/Business Analyst

PROJECTS WITHIN:

ELECTRONIC CUSTOMER INFORMATION FILE eCIF Global Information Warehouse GIW

Responsibilities:

• Performing data standardization for key account and customer tables and fields.
• Decommissioning legacy systems - accounts and customers closuring.
• Extracting required account and customer data requested by customers.
• Writing scripts to capture front end application of our system.
• Data mapping between upstream systems, our system and downstream systems/warehouse system for account and customer tables and fields.
• Documenting end-to-end process/data flow and details from upstream systems to downstream systems/warehouse system as regression test package for account and customer data.

confidential

Data Modeler/Data Quality Analyst/Data Analyst/Business Analyst

PROJECTS WITHIN:

ANTI MONEY LAUNDERING AML END-TO-END RECONCILIATION PROGRAM

DATA QUALITY RECONCILIATION PROGRAM

Responsibilities:

• Understanding of existing systems and gathering requirements to reconcile all transactions from Product Processors / applications.
• Overseeing the development of requirements gathering plan including layout project scope, project artifacts accumulation and activities prioritization.
• Managing Data reconciliation and Pre-Processor routines delivery.
• Development of Database and Unix Shell Scripts for implementation of each Product Processor.
• Simulation of application of the transaction conversion rules and measure results versus transaction conversion process.
• Measuring data quality of the transactions, as well as the conversion process.
• Interacting with Operations Team and implementing Production and Stability environment processes.
• Assisting in creating standard procedure documentation.
• Providing documentation of the functional specifications.
• Analysis of the data elements applicable for the Product Processors.
• Performing functional testing during Stability Test phase.
• Implementation of Product processors in Production and provide post production support.
• Managing metadata portal as a part of data quality reconciliation and data profiling.
• Understanding and managing metadata hub MHUB - web-based tool as a part of data quality reconciliation and data profiling.
• Understanding and managing application configuration environment ACE - web-based tool as a part of data quality reconciliation and business rules development.
• Understanding and managing data quality platform DQP - web-based tool as a part of data quality reconciliation and business objects reports development.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Gathered and analyzed requirements from the end users and converted functional specifications to technical specifications documents.

• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Created Data Model from scratch which involved a complete life cycle implementation that encompassed business requirement gathering, analyzing their source systems and then building financial data mart in order to provide functionality for their reporting purposes.
• Created conceptual, logical physical data models with Erwin and did design review meetings with other team members in order to finalize the model.
• Implemented advance modeling concepts like Bus Matrix Architecture, Resolving Multi Valued dimensions, and Conform dimensions, Junk dimensions, Degenerate dimensions in designing multi-dimensional model.
• Created and developed Slowly Changing Dimensions tables SCD2, SCD3 to facilitate maintenance of history.
• To maintain the consistency and quality of the data worked with Data Governance, Data Profiling and Data Quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.
• Developed and maintained enterprise data dictionary by interacting with data steward, data governance team.
• Divided model into subject areas for reflecting understandable view to business as well as data model reviewers.
• Created DDL for physical model using Erwin and handed over to the DBA team.
• Created Source to target matrix and worked with ETL developers for mappings. Did design reviews for all the mappings and created Work flow documentation of the load dependencies.
• Worked in parallel with DBA for Data growth estimates and Performance tuning.

Environment: Orac1e 10g, Erwin 7.3, Microsoft Visual Source Safe, Informatica PowerCenter 8.6, TOAD 8.5.

confidential

Data Modeler/Data Analyst

Responsibilities:

• Interacted with business users to clarify on business logic required for the data models.
• Involved in gathering complete requirements by organizing and managing meetings with Business Analysts, Data Stewards and subject matter experts on a regular basis.
• Analyzed OLTP source systems and Operational Data Store and research the tables/entities required for the project. Designing the measures, dimensions and facts matrix document for the ease while designing.
• Analyzed the specifications and identified the source data from disparate data sources like Oracle, MS SQL Server and flat files that needs to be moved to data warehouse.
• Analyzed functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Designed and maintained the Logical /Physical dimensional data models and generating the DDL statements and working with the database team in creating the tables, views, keys in the database.
• Performed Data profiling and identified the risks involved with data integration to avoid time delays in the project.
• Worked on specifications given by the Data governance team and Data quality team that required managing the master data from all the business units and ensuring data quality across the enterprise.
• Validate the models with the production data and developed the Source to Target mapping matrix, an expert solutions to design and develop the mappings for the loading of data, to the ETL developers.
• Conducted frequent meetings with my ETL coding and development team to co-ordinate the process and to efficiently organize and distribute the workflow among the team.

Environment: ER Studio 7.6.1, Informatica Power Center 7.1.4, Oracle 9i, SQL Server 2005, Flat files, SQL/PL SQL, Win XP.

confidential

Database Developer

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Established frameworks for ER modeling, database design and schema maintenance.
• Created normalized models for various OLTP applications.
• Involved in the coding of stored procedures and triggers using PL/SQL for various business requirements.
• Designed and developed all the tables, views for the system in Oracle.
• Modifying the database design and as necessary from time to time upon information given by the application users and developer.
• Designing and developing forms validation procedures for query and update of data.

Environment: Oracle 8.0, PL/SQL.