SUMMARY

• Over 8 Years of experience in Data Modeling, Data Reporting, Analysis, Mining, Design, Development, Data Migration, Implementation and Testing of Database and design of OLTP and OLAP systems.
• Experienced in Technologies like E - R Modeling for OLTP & OLAP (Multi-Dimensional) Data Modeling techniques like Star Schema Modeling, Cube-processing, Snow-flake Dimension modeling, Fact and Dimension Modeling using Erwin Tool.
• Having good knowledge in Normalization and De-Normalization 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 in Ralph Kimball and Bill Inmon approaches.
• Extensive experience in Retail Banking( Financial Reporting), Financial services Risk & Finance along with Mortgage, Biotech/ Pharmaceutical,Communications,Manufacturing etc. using Data Modeling, Extraction, Transformation, Loading & reporting processes.
• Work experience with UNIX operating system, Shell scripting and Automation of ETL process.
• Experience in writing, testing, and implementation of the triggers, stored procedures, views, cursors, packages,functions at Database level and form level using PL/SQL.
• Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.
• Experience in performance analysis and created partitions, indexes and Aggregate tables where necessary.
• Knowledge in business intelligent software, Export & Import, Performance Tuning of Database, Backup and Recovery, SQL*Loader.
• Experience in integration of various data sources like Oracle, SQL Server, Oracle, MS Access, and Flat files into the staging area.
• Excellent communication, interpersonal, analytical skills & strong ability to perform as part of a team

TECHNICAL SKILLS

Data modeling: Erwin Data modeler, MS Visio 2007/2010, ER Studio, Star-Schema and Snowflake

Databases: Oracle 10g/9i/8i/7.x, MS SQL Server 2000/7.0, Microsoft Transact SQL, MS Access, SQL Server, DB2 UDB, Teradata, TOAD

Languages: SQL, PL/SQL, Visual Basic, ASP, Java, C, C++, HTML.

OLAP & Reporting: Business Objects XI R3, Crystal Reports 2008/ XI

Environment: MS Windows 2003/2007/NT/XP, UNIX, MSDOS.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Data Modeler

Responsibilities:

• Generated requirements by meeting with Business Information team to design plan for warehouse expansion.
• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Interacted with non-technical end users to understand the business logics
• Modeled the conceptual, logical and physical diagram of the future state, Delivered BRD and the system design document, Discussed the Data model, data flow and data mapping with the application development team
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Involved in business process modeling using UML (class diagrams, object diagrams, use case diagrams) through Rational Rose.
• Create, maintain and follow IRS standards for the data and information definition like naming conventions, data type conventions.
• Explored the cardinality of relationships between entities for design.
• Extraction, Transformation and Loading (ETL) of data from various sources systems like relational sources, XML & flat files
• Worked on slowly changing dimension tables. Broken down the hierarchies from the dimensions to create the roll up dimensions.
• Participate in Data Analyst team meetings to plan, design, and implement initiatives that deliver capabilities on the team roadmap.
• Created various stored procedures, functions, cursors, views to do the reporting with the OLTP transactional database.
• Created SQL scripts for loading the aggregate tables and rollup dimensions.
• Involved in Setup new Data Marts/Data Warehouses andthe related processes.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Performed data analysis on the target tables to make sure the data as per the business needs.
• Created Technical design document from business requirements while consolidating team inputs and provided inputs for test Plan with regards to back-end testing for ETL.
• Performed unit testing, System integrated testing for the aggregate tables.

Environment: ORACLE, Toad for Data Analysts 2.5.1,Toad for Oracle 10,Toad Data Modeler 3.4,SQL Plus, ER Studio, Erwin Data Modeler 8.2, Erwin Model Manager 8.2,Windows XP, Business Objects XI R3.

Confidential, Chesterbrook, PA

Sr. Data Modeler

Responsibilities:

• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Created and maintained the conceptual and logical data models for the Enterprise and other applications
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Implemented Database tuning and Optimizing Stored procedures for better performance.
• Used Erwin’s reverse engineering to connect to existing database and create graphical representation E-R diagram
• Redefined many attributes and relationships in the Reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Extensively used ETL to load data from Oracle database, SQL server database, and Flat files to Oracle.
• Involved in Creating Repository, Creating Users and User Groups and assigned different privileges to them depending on their profile.
• Created mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations.
• Worked on Erwin domains, naming standards for physical data model and provided updates as needed to development teams.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in the data model.
• Worked with QA team to identify the testing logic to test all the possible scenarios.
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Crystal Reports7.5/8.0, Windows 2000, Micro strategy 9.3,Crystal Enterprise8.0, Erwin, power designer, CSV files, XML files, Business Objects,Oracle10g.

Confidential, San Francisco, CA

Sr. Data Modeler

Responsibilities:

• Involved in requirement gathering along with the business analysts group. Documented Technical & Business user requirements.
• Collected requirements from business users and analyzed based on the requirements.
• Conducted JAD sessions, wrote meeting minutes and also documented 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.
• Developed logical data model using Erwin and created physical data models using forward engineering in generating DDL scripts and creating indexing strategies.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Discussed the Data model, data flow and data mapping with the application development team.
• 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.
• Created ftp connections, database connections for the sources and targets.
• Developed several forms & reports using Crystal Reports.
• Worked extensively with the data grid and repeater controls of ASP.NET.

Confidential, TX

Data Modeler

Responsibilities:

• Collected requirements from business users and analyzed based on the requirements.
• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
• Identified the measures and dimensions and organizing these into facts in creating the Dimensional model within the business requirements.
• Designed fact tables, Dimension tables for data warehouse.
• Explored the cardinality of relationships between entities for design.
• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Worked extensively with mappings using expressions, aggregators, routers, lookup and procedures to develop and feed Data Mart.
• De-normalized the database to put them into star schema of the database.
• Serve as a member of a development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin.
• Provide mapping between existing processes and proposed replacement processes.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Maintained current documentation for all primary and backup responsibilities.
• Experience in implementing Data warehousing solutions involving Star schema and Snow flake schema implementation.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.

Environment: DB2, SQL Server 2000, ER studio, Erwin r8, Microsoft Visio, Rational Requisite Pro, Rational Rose, Windows 2003 Server.

Confidential, Chicago, IL

Data Modeler

Responsibilities:

• Working with business users to know the business requirements.
• Gathered the entire detail requirements from business for reporting.
• Involved in creating entity relational and dimensional relational data models using Erwin tool.
• Worked extensively on forward and reverse engineering processes using Erwin.
• Performed data analysis on the target tables to make sure the data as per the business expectations.
• Worked on employed naming standard editor for defining new naming standards for the entities, attributes, domains, columns and tables that applied consistently all over the enterprise.
• Implemented slowly changing dimensions Type2 for accessing history of reference data changes.
• Provided source to target mappings to the ETL team to perform initial, full, and Incremental loads into the Data warehouse.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Used Informatica & SAS to extract transform & load source data from transaction systems
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Performed unit testing, System integrated testing for the aggregate tables

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

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in performance tuning by creating the Indexes, summary tables in place of detailed tables etc.
• Created PL/SQLStored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Involved in monitoring the database performance whenever there is some issue with the database queries by checking the metrics like duration of query session, explain plan etc.
• Involved in creating Backups/Restores, Replication, Complex SQL coding skills
• Worked with internal and external clients for import and normalization of third-party data.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Monitored and provided front-line support of daily processes.
• Involved in Manipulating, cleansing & processing data using Excel, Access and SQL.
• Wrote T-SQL scripts to manipulate data for data loads and extracts.
• Involved in performing daily system checks.
• Perform quality assurance and testing of SQL server environment.

Environment: SQL server 2000, MS SQL server Analysis Manager, SQL Navigator, Erwin, Windows NT, Crystal Reports.

Confidential

SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures, Indexes and views.
• Created reports, custom SQL queries using the Crystal Reports by connecting to the various databases like Oracle, SQL Server, and PeopleSoft databases etc.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in the analysis of data from spreadsheets doing lot of arithmetic functions, creating pivot tables, writing formulas etc.
• Involved in importing the data from MS Excel to MS Access and then created various queries like removing duplicates, creating bar charts and pie-charts.
• Provide database coding to support business applications using Oracle PL/SQL.
• Involved in performance tuning by creating the Indexes, summary tables in place of detailed tables.
• Involved in creating tables, granting permissions to these tables, modifying these tables by using the DML (Data Manipulation Language) statements like Insert, update & delete
• Assisted with integration and data conversion activities.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Documented and maintained database system specifications, diagrams, and connectivity charts.

Environment: SQL Server 2000, Sybase12, Sybase Power Designer, UML, Business Objects 5,Teradata, Windows NT/2000, SSIS, SSRS, Embarcadero, ER studio, Erwin, DB2, Informatica, Query Management Facility (QMF), Data Stage, Clear Case forms, Unix and Shell Scripting.