SUMMARY

• IT Professional with nearly 9 years of experience as a Data Modeler& Data Analystwith strong expertise in design & support of various applications in OLTP, DataWarehousing, OLAP and ETL environments.
• Proficient in delivering Quality Conceptual, Logical and Physical DataModels for Multiple projects involving various Enterprise New and Existing Applications and DataWarehouse.
• Experience in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing the model.
• Experience in designing Star Schema, Snowflake Schema for datawarehouse, ODS architecture by using tools like Erwin Data Modeler, Power Designer, Embarcadero E - R Studio and MS Visio.
• Good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Well versed on Agile and Waterfall datamodeling methodologies.
• Proficient in datamart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes and canonical model.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ, MLDM and MDM
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL, Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Experience in logical/physical database design and review sessions to determine and describe data flow and datamapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application.
• Experience in generating DDL scripts and creating indexing strategies.
• Oracle administration on 10g, 9i versions. Backup and Recovery strategies using RMAN, Cold\Hot backups, Replication and other datamigration strategies.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.

TECHNICAL SKILLS

Data Modeling Languages: Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5/9.6 Embarcadero ER/Studio, Oracle Designer, Sybase, Power Designer.

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

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

Database Tools: Microsoft SQL Server 200/2005/2008/2012/2014 , MySQL, Oracle 11g/10g/9i/8i, DB2, and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

ETL Tools: Informatica 7.1/6.2, Data Junction, DataStage SSIS, BODS.

Other Tools: SAS Enterprise Guide, SAP ECC and Panorama Web Service, Code Flow/TFS

PROFESSIONAL EXPERIENCE

Confidential - Malvern, PA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Created conceptual, logical and physical models based on requirements gathered through interviews with the business users.
• Updated existing models to integrate new functionality into an existing application. Conducted one-on-one sessions with business users to gather warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.
• Developed normalized Logical and Physical database models to design OLTP system.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Created DDL scripts for implementing DataModeling changes.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Datamodel in model mart, created naming convention files, co-coordinated with DBAs to apply the datamodel changes
• Used forward engineering to create a Physical DataModel with DDL that best suits the requirements from the Logical DataModel.
• Maintaining and implementing DataModels for Enterprise DataWarehouse using ERWIN.
• Create and maintain Metadata, including table, column definitions.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Responsible for defining the naming standards for Datawarehouse.
• Conducted Datamodeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
• Worked on PL/SQL programming Stored Procedures, Functions, Packages and Triggers
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Eliminated errors in ERwin models through the implementation of Model Mart (a companion tool to ERwin that controls the versioning of models).
• 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
• Developed DataMigration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Identified the most appropriate datasources based on an understanding of corporate datathus providing a higher level of consistency in reports being used by various levels of management.
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data.

Environment: Erwin r8, Windows XP NT 2000, SQL Server 2008, Teradata, Oracle11g, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential - Torrance, CA

Data Modeler / Data Analyst

Responsibilities:

• Worked with Business users for requirements gathering, business analysis and project coordination.
• Involved in the entire dataMigration process from analyzing the existing data, cleansing, validating, translating tables, converting and subsequent upload into new platform.
• Developed a Conceptual Model and Logical Model using Erwin based on requirements analysis.
• Created various Physical DataModels based on discussions with DBAs and ETL developers.
• Worked on datamapping process from source system to target system.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Extensively used Star and Snowflake Schema methodologies.
• Developed and maintained dataDictionary to create Metadata Reports for technical and business purpose.
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• Prepared datadictionaries and Source-Target Mapping documents to ease the ETL process and user's understanding of the datawarehouse objects
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Used Normalization (1NF, 2NF & 3NF) and de-normalization techniques for effective performance in OLTP and OLAP systems.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Worked with business analystto design weekly reports using combination of Crystal Reports.
• Identified existing datamodel and documented suspected design affecting the performance of the system.
• Extracted datafrom databases like Oracle, SQL server and DB2 using Informatica to load it into a single repository for dataanalysis.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Worked on migration and cleansing rules for the integrated architecture (OLTP, ODS, DW)
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.

Environment: Oracle SQL Developer, Oracle Data Modeler, Teradata, SSIS, Business Objects, Teradata, Oracle12c, SQL server 2012, SQL Assistant 13.11,datastage 8.1, DB2, Informatica Power Center 9.5

Confidential - Los Angeles, CA

Data Modeler/Data Analyst

Responsibilities:

• Handled multiple projects simultaneously and manage the projects to accomplish desired results.
• Implemented dimension model (logical and physicaldatamodeling) in the existing architecture using ER Studio.
• Created ER diagrams using Open Sphere Model and implemented concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Designed and Developed Oracle PL/SQL Procedures LINUX and UNIX Shell Scripts fordata Import/Export anddataConversions.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys).
• Wrote Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.
• Generate DDL scripts for database modification, Macros, Views and set tables.
• Developed logical and physicaldatamodels and mapping logical entities to the enterprise Data Model.
• Designed and developed star schema model for target database using ER/Studio.
• Extensively worked in SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences.
• Applied appropriate level of abstraction in designs and confirmed that datadesigns support the integration of data and information flow across systems and platforms.
• Analyzed and made recommendations on the impact ofdesigns as they related to common conceptual models.
• Updated and enforceddataarchitecture policies, standards and procedures.
• ProvideddataSME knowledge to both IT and business users to promote a common understanding and the appropriate usage of the bank'sdataassets.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Ensureddataobjects adhere to defined standards and best practices data Promoteddatamodels into production metadata environments.
• Worked with both relational and dimensionaldatamodeling, data standards and data model practices.
• Performed maintenance of current datadiagrams and metadata to enable further enhancements.
• Provided Level of Efforts, activity status, identified dependencies impacting deliverables, identified risks and mitigation plans, identified issues and impacts.
• Designed database solution for applications, including all required database design components and artifacts.

Environment: Data modeler, SSAS, T-SQL, SQL Server, LINUX, MDM, PL/SQL, ER/Studio, ETL, Normalization and De-normalization, Metadata, Star-Schema Modeling, UNIX, Snowflake Schema Modeling

Confidential

Data Analyst

Responsibilities:

• Involved in gathering user requirements along with the BusinessAnalyst.
• Participated in creating the logical model of an online processing system for a large financial institution using Erwin.
• Worked with DBAs to generate physical model.
• Worked on Bill Inmon methodologies for modeling.
• Created tables, views, procedures and SQL scripts and mapping documents.
• Worked on slowly changing dimensions (SCD) and hierarchical dimensions
• Worked on conversion process ofdata, which is stored in flat files into oracle tables.
• Designed and Developed SQL procedures, functions and packages to create Summary tables.
• Generated ad-hoc reports using crystal reports 9.
• Developed database backup and restore policy.
• Created Report Models for building Ad-hoc Reports Using SSRS.
• Generated Reports using SSRS and Excel Spreadsheet.
• Created various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.
• Created ETL Packages using SQL Server 2005 Integration Services (SSIS).

Environment: Oracle8i, SQL Server, SSIS, SSRS, ERWIN, HTML, Crystalreports9, MSOFFICE, Windows XP