SUMMARY

• 5 years of professional experience in Data Modeling, Business Data Analysis and design of OLTP and OLAP systems.
• Strong Knowledge of Data Warehousing, ETL and Business Intelligence Reporting Architecture.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, Embarcadero E - R Studio and Microsoft Visio.
• Well versed in Normalization and DeNormalization techniques for optimum performance in relational and dimensional database environments.
• Strong experience working with conceptual, logical and physical data modeling considering meta data standards.
• Experience working with Agile and Waterfall data modeling methodologies.
• Experience in OA Framework personalization for Self Service Web pages.
• Extensive experience analyzing and documenting business requirements and system functional specifications including use cases facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Involved in the critical design review of the finalized database model.
• Worked extensively with XML schema designing and XML data.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.
• Worked with various RDBMS like Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 UDB, Teradata.
• Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS 2005/2008).
• Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
• Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.
• Excellent communication skills, self-starter with ability to work with minimal guidance.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, PASCAL, COBOL, C, C++, Visual Basic, .NET, HTML, CSS, Oracle 11g/10g/9i, TeraData

Operating Systems: Windows 95/98/NT/2000/XP/7, UNIX, MS-DOS

Modeling Tools: Erwin r7.3, Power Designer, ER/Studio, Microsoft Visio

Reporting Tools: Crystal Reports, OBIEE 10.3.4.1, Microsoft Reporting Services, Cognos

ETL Tools: Informatica 8.1/9.1

Other Tools: MS Office (Word, Excel, PowerPoint), MS Project 2003

PROFESSIONAL EXPERIENCE

Confidential, Stamford CT

Data Modeler/Analyst

Responsibilities:

• Participated in the requirement gathering sessions to understand the expectations and worked with system analysts to understand the format and patterns of the upstream source data.
• Developed multiple logical models per the requirements and validate it’s alignment with the enterprise logical data model (ELDM).
• Participated and conducted many design sessions with the ELDM team if there are any potential violations with respect to the ELDM data model and come out with a solution to resolve it.
• Validated the entity/attribute names as per RBS’s data model naming standardsand check for appropriate primary qualifier and class word in the names.
• Developed many physical models from the logical model using RBS’s standard abbreviation wizard and implement indexes, partitions and apply normalization and denormalization techniques per requirements.
• Tag data model attributes with Core, Critical and NPI attachments which helps Security Architecture team identify and restrict NPI Data.
• Implemented naming standards when creating indexes, partitions, primary keys and relationships.
• Created reference values, lookup tables, history and staging tables per requests from development teams and worked with them in developing the mappings.
• Created data model PDFs, data dictionaries for logical and physical models as per code drops and post to SharePoint project site
• Participated in bi-weekly status calls to update the team on development status, work closely with system and business analysts to finalize the model and review the final model with the whole team for both educational and approval purposes.
• Worked extensively on legacy models that were reverse engineered from database to implement object naming standards in the logical model and completing definitions by working with respective application teams.
• Assisted other teams in integrating multiple data models when the respective systems were migrated from multiple databases into a single oracle schema.
• Created DDL Scripts using ER/Studio for the ODS and Mart model and executed them in respective DEV environments so as to make sure the ETL can start the build/code drop development.

Environment: Windows XP, PL/SQL Developer 8.0.4, Oracle 11i, 12c, Microsoft SQL Server 2008 R2, Informatica 9.1.

Confidential, Danvers, MA

Data modeler/ Database Design Analyst

Responsibilities:

• Data Modeling, Data Analysis for OLTP and OLAP systems.
• Logical & Physical Data Modeling, which involved ER Modeling - Developing Entity Relationship Diagrams (ERD).
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Requirements & Business Process Analysis; Rapid Audit of the requirements and existing systems.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Design & Implementation of Data Mart; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Normalization techniques to arrive at effective Relational Schemas.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Involved incapturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Documented all the information of application and saving them for future reference.
• Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models.
• Create and alter SQL statements before sending database change request to DBA team.
• Maintained and documented all create and alter SQL statements for all release.
• Designing Data Flows & System Interfaces.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Documenting using Interface Diagrams, Flow Charts & Specification Documents.
• Coordinating with DBA team to implement physical models & to setup development, test, staging & production environments for MGP; BPR Management; DDL & DML Generation & usage

Environment: ERWIN V7.2, Oracle 11g/ 10g, Teradata V2R6, Oracle Warehouse Builder, SQL, PL/ SQL, Sybase Power Designer 12.5/ 15, SQL Server 2000/ 2005, UNIX, Toad, Business Objects, Ms office, MS Access.

Confidential

Trainee/Software Engineer

Responsibilities:

• Developed prototypes using a Data Warehouse and created cubes for multidimensional analysis of data
• Developed web form to interact with Data Warehouse and created cubes for multidimensional analysis of data
• Performed data migration into SQL Server
• Generated reports using SQL from Oracle database, which were used for comparison with legacy system.
• Designed and implemented the backend SQL server.
• Created Temporary Tables to store the data from Legacy system.
• Creation of Materialized views and function based indexes.
• Setting up various notification scripts which will notify if the database is not up and running or if any directory space is filled up.
• Administer database with MS SQL servers including setting up backup, disaster recovery planning, replicating between multiple servers and implementing log shipping with standby database server.
• Identify and determined causes of security violations, and recommend corrective actions to ensure data security.

Environment: Rational Suite (RUP, UML with Rational Rose), Oracle, SQL Server 2000, SQL, MS Access, Windows, UNIX.