SUMMARY

• Over seven years of progressive IT experience in the field of Business Requirement Analysis, Data Analysis, Testing of Data warehousing & Database, ETL Development, and Data Modeling.
• Extensive work experience on Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) system environment.
• Proficient in Microsoft SQL database management, Software Development Life Cycle (SDLC) and Project Management using methodologies like Relational Unified Process (RUP), Agile and Waterfall.
• Extensive knowledge and expertise in Metadata Management System, Data Integration, Data Mapping, Information Gathering, Data Cleansing, Data Manipulation and Performance Tuning techniques for finest performance in dimensional and relational database environments.
• Proficient in designing Conceptual, Logical and Physical Data Models for various environments and business processes.
• Well versed in designing and working on bases of Ralph Kimball and Bill Inmon approaches.
• Experience in Extract, Transform and Load (ETL) data from spreadsheets, database tables and other sources using SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS) for managers and executives.
• Strong understanding and usage of various type of dimensions like Junk Dimensions, Slowly Changing Dimensions, Role Playing and Degenerate Dimensions.
• Experienced in working with RDBMS like Oracle 10g/ 9i/ 8i, Microsoft SQL Server 2008 R2 and Teradata.
• Proficient in designing of Star and Snowflake schemas with a very good understanding of fact and dimensional tables.
• Applied Referential Integrity constraint to Entity Data Model (EDM) to maintain the relations to be valid throughout the process.
• A very good knowledge with dealing different types of data sources such as flat files, Excel, Oracle, Sybase, and SQL Server.
• Expertise on forward and reverse engineering using tools like ERWIN, ER Studio and Data Architect.
• A very good command over SQL queries, SQL Plus, PL/SQL Packages, Procedures, Functions and performance analysis, indexes, creating partitions, aggregating tables when required.
• Experience in data analysis to track data quality and for detecting/correcting inaccurate data from the databases.
• Working closely with ETL/ Report Developers, Database administrators, Business Analysts and support teams.
• Impressive presentation as well as communications skills with very good leadership qualities.

TECHNICAL SKILLS

Data Modeling Tools: Erwin Data modeler r 7.1/7.2/7.3/8.2 , ER Studio 9.1/9.5, Power Designer 11.0/12.0/12.5/15 , Toad data modeler

Reporting Tools: Business Objects XI, Crystal Reports

OLAP Tools: SSAS

ETL Tools: Data Stage, SSIS, SSRS, Informatica 7.1.3/8

Databases: MSSQL servers 2000/2005/2008 , Oracle 9g/10g/11g, Teradata V2R5/V2R6/12, DB2,TOAD 9, MS Access 2003/2007/2010

Programming Languages: SQL, C, C++, Java, MATLAB

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Data Modeler

Responsibilities:

• Designed and implemented Company’s Enterprise Conceptual Data Model as an architecture migration target and eventually developed the physical data model of strategic customer and product databases through the logical data model to ensure high data quality and reduced redundancy.
• Conducted team meetings and JAD sessions for the requirements clarifications and to translate the business needs into data models supporting long - term solutions.
• Responsible and accountable for design sessions with Business Analyst, Finance, Development and the ETL SQL Server Integration Services (SSIS) Developers team together to optimize the business needs.
• Rearranged all the existing data dictionaries and data models into a MetaData Repository.
• Implemented different types of data strategies, Data Cleansing rules, Data Profiling and validity, built data flows.
• Worked with the various teams to identify and analyze the Orphan/duplicate objects from the Database and performed appropriate action over it.
• Worked with the Application Development Team, Model Manager and multiple data marts to decide and implement naming Standards, domains, multiple subject areas.
• Implemented forward Engineering on DB2 databases to transform them into SQL Server 2008 using ERWIN.
• Designed OLAP & OLTP system environment.
• Ensured the ease of accessing history of reference data changes by implementing Slowly Changing Dimensions Type 2 & Type 3 of reference data.
• Developed best practices for stored procedures, functions, shell scripts to implement alerts and data integrity after each ETL process to maintain a balance between target and source tables.
• Worked on Dimensional Modeling techniques to develop the data marts using Erwin.
• Developed a star schema data warehouse model for the proposed central model.
• Designed and maintained various data models using Erwin Design Tool and Erwin Model Manager.
• Involved in creating and updating System Design Specification (SDS) document.
• Taking the business rules and requirements into considerations; developed the specifications document for the Informatica ETL mappings to load the data into target database.
• Prepared ad-hoc reports with the use of Crystal Reports 9.

Environment: Erwin Data Modeler 8.0, Informatica, Bids 2008, MS Management Studio, MS Excel, SSIS, SQL, Microsoft Windows Vista/ Unix, Metadata Repository.

Confidential, Bethpage, NY

Data Modeler

Responsibilities:

• Developed OLTP system by designing Logical and eventually Physical Data Model from the Conceptual Data Model.
• Arranged various guiding sessions for Programmers, Engineers, System Analysts and others for clarification of performance requirements, interfaces project capabilities and limitations.
• Analyzed and presented the gathered information in graphical format for the ease of business managers.
• Produced Source to target data mapping by developing the mapping spreadsheets.
• Performed extensive Teradata validation and analysis.
• Identified required dimensions and Facts using Erwin tool for the Dimensional Model.
• Validated business data objects to ensure the accuracy and completeness of the database.
• Represented existing business models by UML diagrams.
• Extensively used the Erwin tool to develop a Conceptual Model based on business requirements analysis.
• Implemented Snow-flak schema to ensure no redundancy in the database.
• Implemented Forward Engineering by using DDL scripts and generating indexing strategies to develop the logical data model using Erwin.
• Reverse Engineered physical data models from SQL Scripts and databases.
• Optimized and updated UML Models (Visio) and Relational Data Models for various applications.
• Implemented ETL techniques for Data Conversion, Data Extraction and Data Mapping for different processes as well as applications.
• Introduced foreign keys and normalized the existing data structure to maintain Referential Integrity.
• Worked with the ETL team to provide source to target mapping to implement incremental, full and initial loads into the target data mart.
• Data Consistency were maintained by evaluating and updating logical and physical data models to support new and existing projects.
• Reviewed different codes, tests and designs to ensure no bottlenecks in the systems and to recommend required update if any.
• Generated various reports using SQL Server Report Services (SSRS) for business analysts and the management team.
• Maintained documentation of Metadata while designing OLTP system environment.
• Well experienced in documenting data relationships, business rules, allowed rules, evolved glossary and codes.

Environment: Teradata, Oracle 9i, TOAD 9.7, SSRS, Erwin Data Modeler 7.3, Erwin Model Manager 7.3, MS Visio, Windows XP, QC Explorer.

Confidential, WI

Data Modeler

Responsibilities:

• Performed Data Modeling, Database Design, and Data Analysis with the extensive use of Power Designer.
• Conducted meetings, design discussions and JAD sessions with Subject Matter Experts (SME) to gather various business requirements from Business Analysts and Data Analysts.
• Analyzed the gathered information and represented it to develop the Conceptual Model.
• Data-related system integration challenges were analyzed and proposed appropriate solutions for that.
• Extensively worked on spiral and waterfall methodologies of Software Development Life Cycle (SDLC).
• Played key role as a part of data analysis in optimizing the database by cleansing the redundant data. Reverse Engineered by redefining various attributes and their relationships.
• Worked closely with SMEs to come up with enhanced specifications and to resolve the issues generated.
• Identified Facts and Dimensions involved in dimensional modeling.
• Extensively worked on Data Governance rules for the Master Data Management Architecture.
• Ensured data model consistency by developing best practices for coding and standard naming conventions.
• Performed Data Manipulation as a part of the application process.
• Developed new training modules and conducted knowledge sharing sessions for engineer trainees.
• Developed Logical and the Physical Model from the Conceptual Model with the use of ER Studio.
• Worked on Rational Unified Process (RUP).
• Executed Test Scripts to verify the expected result.
• Developed the star schema of the data warehouse by De-normalizing the existing Database.
• Developed OLAP data model with enforced Referential Data Integrity and produced an efficient database design.
• Developed various UML diagrams such as class sequence using Rational Rose Model.
• Hands on experience in using PL SQL for Oracle 8i, 9i database programming.
• Expertise in GUI, Relational Database Model (RDBMS), designing of OLAP system environment as well as Report Development.

Environment: Oracle 8i, 9i, PL/SQL Packages, Power Designer 9.0, RDBMS, UML Class Model.

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Used ER Studio to develop logical model of the online processing system for a large financial institution.
• Involved in gathering user requirements along with the Business Analyst.
• Understood the company standards and developed the data models accordingly.
• Worked with DBAs to generate physical model.
• Ensured company code standardization rule in the modeling.
• Hands on experience on slowly changing dimensions (SCD) and hierarchical dimensions.
• Dealt with the data sources like flat files, Excel sheets, Teradata and performed the conversions into oracle tables.
• Involved in Data Analysis for the data warehouse and data mart system.
• Optimized and updated the existing data models to support the new as well as existing database environment.
• Developed database backup and restore policy.
• Created Summary tables by designing SQL functions, procedures and packages.
• Developed SQL queries to verify that data has been moved from transactional system to DSS.
• Worked on data warehouse, data mart reporting system in accordance with requirement.
• Hands on Experience in creating ETL Packages using SQL Server 2005 Integration Services (SSIS).
• Worked with analysts to create reporting universes in Business Objects.
• Maintained technical documentations for tables, views, procedures and SQL scripts and mapping.
• Expertise in creating report models for building Ad-hoc Reports Using SSRS, Crystal Reports9 and Excel Spreadsheet.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.

Environment: SQL Server, SSIS, SSRS, ER Studio(8.0), HTML, Crystalreports9, MS OFFICE, Windows XP, MS Office packages Word, Excel, Power point.

Confidential

Data Analyst

Responsibilities:

• Developed the logical and physical model from the conceptual model developed using a tool Erwin by understanding and analyzing business requirements.
• Worked closely the team of business analysts, quality analysts to understand the business requirements and developed the Business Object Model (BOM).
• Assisted for the development of Interface Design Model (IDM).
• Validated the modifications to be performed on the existing database to ensure the efficiency and its performance.
• Recommended required corrections by examining the new application proposal.
• Assigned different roles, granted/revoked permissions to the database users.
• Expertise in creating triggers, stored procedures, views and SQL-Scripts.
• Maintained documentation using Crystal Reports.

Environment: Erwin 4.1, MS Excel, DB2, Windows XP, Test Director 7.x, Load Runner 7.0, Oracle 10g, PERL, Shell Scripting.