SUMMARY

• Over 7 years of experience in data modeling, Data warehouse design, Business Data Analysis and design of OLTP (relational) and OLAP(dimensional) systems, production support, database management, and decision support with knowledge in insurance, healthcare, banking and retail domain.
• Experience developing conceptual, logical and physical data models as per enterprise standards.
• Good knowledge and experience with Normalization and De - normalization techniques for effective and optimum performance in Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems (ODS, ADS and Data Marts).
• Experienced in identifying the Facts and Dimensions from the Enterprise Architecture for designing the Star and Snowflake Schema.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies.
• Experience in creating Mapping documents for data extraction, transformation and loading.
• Worked in many Software Development Life Cycle (SDLC) implementations, performing process-planning, documentation, functional and system design, implementation, unit, integration, regression testing, and system maintenance.
• Experience in Data Analysis using SQL Queries and Data profiling tools.
• Extensively worked on Data Quality framework for Data Warehouse.
• Involved in maintenance of Metadata Repository.
• Experience in usage of Erwin Model Mart.
• Strong performance tuning abilities. During the tuning process, developed various indexes and partitions as needed.
• Experience in developing Data Model’s for Semantic/Aggregate layer.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience in performing Gap analysis.
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, and SQL Server.
• Strong Database experience using Oracle 11g/10g/9i, XML, DB2,Teradata, SQL Server
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus and SQL Navigator.
• A good familiarity and experience in the work environment consisting of Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.

TECHNICAL SKILLS

Modeling Tools: Erwin data modeler r7.3/8.2.5/9, ER Studio, Rational Rose, Oracle Designer, SQL data Modeler and MS Visio

Operating Systems: Windows, UNIX and Linux.

Databases: Teradata, Oracle7/8i/9i/10g/11g, MS SQL Server 2009/05, MS Access, DB2, Sybase and PL/SQL.

Programming Language’s: SQL, PL/SQL, HTML, XML, UML’s, C, C++, Java and .NET.

Reporting Tools: Cognos 8, Microsoft Analysis Services, Business objects, OBIEE and Crystal Reports 9, Oracle Reports, Tableau

ETL Tools: Informatica Power center 8.6/7.1/6.2, Data Stage 8.5 and Microsoft DTS.

Other Tools: SQL Developer, Toad, SSMS, Microsoft DTS, MS Office, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Data Modeler and Cognos Developer

Responsibilities:

• Worked with BSA’s to gather the requirements and involved in analyzing and creating the Conceptual, logical, and physical Data Models and also few enhancements to the existing models.
• Involved in creating data models for the OLTP systems and also simultaneously involved in creating the Dimensional Model in the Cognos Framework manager.
• Extensively worked on the Organizations Naming Standards and also maintained a Data Dictionary based on the organizations user guides and also from gathering the information from BSA’s. Involved in generating the reports from Data Browser in Erwin.
• Extensively used Normalization techniques (up to 3NF).
• Involved in the major decision of finalizing the data types.
• Involved in performance tuning which included Indexing and Partitioning.
• Ad-hoc complex SQL queries were extensively used. Involved in creating DB links, roles for the individual users, grants, sequence, and joining the tables.
• Worked on SQL*Loader to load the data from files into the Oracle Client.
• Worked on the Toad Data Modeler and also Erwin, Involved in Data Model Migration from Toad to Erwin.
• Involved in creating the mapping document from Source to target.
• Involved in creating the Canned Reports based on already existing reports in the Cognos Report Studio and also few Ad-hoc reports in the Cognos Query Studio.
• Performed extensive analyzing of the already existing models and also reports.
• Worked on the Mapping Document that are used to develop Cognos Reports.

Environment: Toad Data Modeler v5, Erwin 7.3, Oracle 11g on Solaris and AIX server, Toad 12.0.1.2 for Oracle, Windows, Microsoft Excel, Cognos 10

Confidential, Winston-Salem, NC

Sr. Logical Data Modeler/Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Worked with SME’s and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
• Developed the UML class diagrams for the proposed system using Erwin Software Architect.
• Performed data modeling using data modeling tool Erwin.
• Created the data models for OLTP and Analytical systems.
• Performed in depth data analysis on Oracle and Teradata systems.
• Extensively worked with the Teradata SQL Assistant and Toad.
• Involved in data profiling to integrate the data from different sources.
• Experience in developing Technical and Business Data Quality Checks.
• Extensively performed the gap analysis and impact analysis.
• Created the data mapping document from source to target and the data quality assessments for the source data.
• Worked with DBAs on support needs and provide guidance on architectural issues.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules.
• Good Experience in dealing Data Quality Issues.
• Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.
• Created action plans to track identified open issues and action items related to the project.
• Assisted QA for developing test plans and test cases for Unit Testing, System Testing and Enterprise testing.
• Extensively worked on the naming standards which incorporated the enterprise data modeling standards and generated reports to verify the model against the pre-defined enterprise standards.
• Designed the physical model for implementing the model into oracle 10g physical data base.

Environment: Erwin 8.0, Oracle Database 10g, Teradata 12.0, Windows XP.

Confidential, NY

Data Modeler

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Gathered the requirements document and analyzed the process.
• Translate business requirements into conceptual, logical data models and physical data models.
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using Erwin.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in Erwin to identify GAPs and worked with the naming standards utility.
• Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
• Responsible for data modeling and building a star schema model in Erwin.
• Participated in the tasks of data migration from legacy to new database system.
• Writing complex queries using Teradata SQL.
• Good knowledge of SQL and querying of DB2 database.
• Created Data Definitions and help maintain Metadata repository.
• Developed and maintained data dictionary to create Metadata reports for technical and business purpose in MDR.
• Involved in dimensional modeling, identifying the Facts and Dimensions and different hierarchies.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Worked with the ETL team to document the transformation rules for data migration from source to target systems.
• Developed source to target mapping documents to support ETL design.
• Resolved the data type inconsistencies between the source systems and the target system using the Source-to-Target Mapping Documents.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Defined the data definitions, and create the target tables in the database.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• Provided data modeling support for numerous strategic application development projects.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Created an enterprise data dictionary and maintained standards documentation.

Environment: Erwin 7.3, Erwin 9, DB2, Teradata SQL Assistant, SQL Server 2008, MS Visio, MS Excel, Word and Access.

Confidential, Lakewood, NJ

Data Analyst/Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Conducted extensive requirement analysis using rational requisite pro.
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Developed system flow and data flow diagrams for the proposed system.
• Designed conceptual and logical data models.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering in Erwin tool.
• Normalized the tables up to 3NF.
• Involved in the critical design review of the finalized database model.
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Closely worked with Business Architects and Solution Architects to created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input.
• Created standard report templates for the data definition specification document and mapping documents and implemented standard reporting techniques enterprise wide.
• Conducted design walk through sessions with Business Architects and solution architects team to ensure that reporting requirements are met for the business needs.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Maintained metadata, naming standards and warehouse standards.
• Involved in designing and implementing the security for the databases.
• Validated the model and ran alternate scenarios/sensitivity analysis.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Assisted reporting team (Cognos).
• Created integrity rules and defaults.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL*Loader.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Erwin 7, Oracle Database 10g, SYBASE, MS Office, MS Visio, Erwin Model Manager 7.3.Linux, Windows XP.

Confidential

Data Modeler

Responsibilities:

• Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing system.
• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards. Conducted Design discussions to come out with the appropriate Data Mart.
• Defined and processed the facts, dimensions. Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling methodology using ER Studio.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using ER studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Involved in the integration of data coming from different sources.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts toTeradatadata warehouse.
• Mapped the data between Source and Targets.
• Created data model for the star schema using ER studio, created DDL scripts for static dimensions.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data
• Imported millions of records from .CSV files .TXT files using SQL * LOADER and Test Importer.

Environment: Oracle 9i/10g, SQL, ER Studio, Teradata, HTML, TOAD, SQL * LOADER, MS OFFICE.

Confidential

Data Modeler

Responsibilities:

• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Collected requirements from business users and analyzed based on the requirements.
• Designed and built Data marts by using Star Schema.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Serve as a member of a development team to provide business data requirements analysis services, producing logical and Physical data models using ERwin.
• Maintained current documentation for all primary and backup responsibilities.
• Worked as part of a team of Data Management professionals supporting a Portfolio of development projects both regional and global in scope.
• Applied organizational best practices to enable application project teams to produce data structures that fully meet application needs for accurate, timely, and consistent data that fully meets its intended purposes.
• Conducted peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.

Environment: ERwin 4.0, Power Designer, Sybase12, Windows NT, MS Excel, MS Visio, DB2, Oracle 10g/9i, XML files, Agile SCRUM, Embarcadero, SCRUM/XP, ER studio, Cognos Impromptu and Power Play, Business Objects.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Created ERD and enforced all referential integrity constraints using Oracle Designer.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Created a logical design and physical design of the central relational database.
• Involved in the analysis of how the purchase order process was organized.
• Created integrity rules and defaults.
• Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
• Helped in migration and conversion of data from the Sybase database into Oracle 10g database, preparing mapping documents and developing partial SQL scripts as required.
• Created stored procedures, functions, database triggers and packages as per the business needs for developing ad-hoc and robust reports. Incorporated Dynamic SQL, for generation of the where clauses dynamically based on the lexical parameters passed.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Maintained security and data integrity of the database.

Environment: Erwin r4.0, Oracle 9i/8i, PL/SQL, Oracle Designer and UNIX.