SUMMARY

• Data Modeler/ Analyst with 9+ years of IT professional experience in Data Modeling, Data Architecture, designing and data analysis with Conceptual, Logical and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP) systems.
• Strong experience on Systems Integration, Data warehouse architecture, Database Design, ETL Design, Report Design, ETL Optimization, Data Profiling, Data quality process design, Best practice implementation, ETL Development, Production support and team co - ordination.
• Data modeling experience using Erwin tool involving Dimensional and Fact tables in Operational Data Store and Enterprise Datawarehouse.
• Extensive experience in reverse engineering databases, Complete compare using ERwin.
• Worked extensively with Erwin, Visio and ER Studio, Power Designer for Relational, Dimensional Modeling and Data Migration projects.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Knowledge in designing Dimensional models for Data Mart and Staging Database using star schema and snowflake models.
• Worked on both approaches to Datawarehousing - Dr. Ralph Kimball and Bill Inmon Methodologies.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files, COBOL Mainframe files.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Developed OLAP applications using Cognos 8BI and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units.
• Good knowledge and extensive experience in PL/SQL such as developing Functions, Database Triggers, Stored Procedures and Packages.
• Experience in working in Agile environment

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1, Mapping Designer, Warehouse Designer, Advantage Data Transformer (Info pump),Pentaho

Programming Languages: PL/SQL, SQL, T-SQL, PERL, Shell Scripts, Korn Shell

Databases: SQL Server, MS Access, MySQL, Oracle, Sybase, DB2

BI Tools: Actuate Reporting Suite 7/6/5, COGNOS 8.3/8.4/10.1 , Crystal Reports.

Other Tools: SQL Loader, SQL Navigator, TOAD, Embarcadero, DB Ignite, ERWIN, VISIO, Teradata SQL Assistant 7.1.0

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Modeler/Analyst/Architect

Responsibilities:

• Performed interviews to gather the requirements from them and to convert those requirements into Requirements document for the development and testing teams.
• Analyzed the business requirements to get a thorough understanding of the testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of the requirements during testing.
• Designed Logical/Physical and Conceptual models of database using ERwin and VISIO
• Did extensive reverse engineering of databases using ERwin.
• Worked with the developers to understand the ERD (Entity Relationship Diagram) and thus create comprehensive test plans, following the RUP model, for the applications and also gather test data for the data driven test cases.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Involved in identifying Primary Keys and the candidates for partitioning tables, handling natural key duplicates.
• Architecting & implementing enterprise & business segment OLTP solutions.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Used Kimball and Inmon methodologies to create the dimensional data models.
• Ensured the feasibility of the logical and physical design models.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• As part of improving performance involved in denormalization of data.
• Involved in test data management, in identifying the columns where the data masking need to be applied and provide data subsets to the testing teams.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
• Worked closely with the ETL Developers to explain the complex Data Transformation using Logic
• Created ETL Jobs and Custom Transfer Components to move data using Informatica.

Environment: ERwin, VISIO, Microsoft Word, Excel, PowerPoint, Oracle 11g, Informatica Power Center 9.1, IBM Cognos 10.2.1 BI Server, TOAD, Quality Center, SQLPLUSMortgage Banking External Reporting Sep 2011 - Dec 2013

Confidential

Senior Data Architect

Responsibilities:

• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design
• Developed the required data warehouse model using Star schema for the generalized model
• Used forward engineering approach for designing and creating databases for OLAP model
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Wrote SQL scripts to Insert/Update and Delete data in Teradata database.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Worked with the Business Objects developers to provide input for generating automated and adhoc Business reports.

Environment: Oracle 11g, Teradata, Informatica Power Center 9.1, Pentaho, Business Objects, UNIX, Microsoft Word, Excel.

Confidential

Senior Data Modeler/Data Architect

Responsibilities:

• Worked with Requirement Analysts and Stakeholders in Requirements Development sessions to gather requirements for the Data warehouse to be developed
• Developed aConceptual modelusing Erwin based on requirements analysis
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for the nurses.
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r7.1
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Involved in the design of the tables based on requirements.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities
• Created primary keys and foreign keys and other constraints for the tables to maintain referential integrity.
• Work with the data warehouse team to formulate the data flow from the database to the data warehouse which is used for reporting.
• Tuned queries using EXPLAIN plan, SQL Trace, Oracle Hints, Optimizers and Indexes for better query performance.
• Used Informatica Power Center 9.1 to load data from flat file to staging tables.

Environment: Informatica Power Center 9.1, SQL, Oracle 11g, SQL Server, SQL Developer, UNIX, SQLPLUS, SQL LOADER, Crystal Reports, Erwin, VISIO.

Confidential

Senior Data Modeler/Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Extensively used Star Schema methodology in building and designing the logical data model.
• Used ERwin to transform data requirements into data models.
• Performed Reverse Engineering of the current application using ERwin, and developed Logical and Physical data models for Central Model consolidation.
• Normalized the tables up to 3NF.
• Involved in the critical design review of the finalized database model.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models;
• Created stored procedures, functions, database triggers and packages as per the business needs for developing adhoc and robust reports.

Environment: Informatica Power Center 8.6.1, UNIX, Oracle 10g, PL/SQL, SQL Server, TOAD, Dreamweaver, Crystal Reports.

Confidential

Senior Developer/Modeler

Responsibilities:

• Identified high-level requirements for developing and documenting detailed business requirements
• Involved in meetings with SME (subject matter experts) and users for requirements gathering.
• Revised and updated the technical feasibility documents and created sequence diagrams.
• Utilized RUP (Rational Unified Process) to create use cases, activity, class diagrams and workflow process diagrams.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Tuned queries using EXPLAIN plan, SQL Trace, Oracle Hints, Optimizers and Indexes for better query performance.

Environment: Informatica 8.1.1 Power Center, UNIX, Oracle 10g, PL/SQL, SQL Server, PL/SQL Developer, Quality Center, SQLPLUS, SQL LOADER, ACCESS, Sub-Version, MS SQL server 2005/2008

Confidential

Senior Developer

Responsibilities:

• Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data.
• Provided suitable access to users in the database depending upon their job functions
• Developed Shell Scripts for scheduling start up and shut down of systems.
• Created ad-hoc reports depending on the requirements given by business analysts.
• Wrote and tested SQL Server T-SQL stored procedures and Oracle PL/SQL to implement business logic
• Worked with developers to tune the SQL queries using SQL profiler.
• Created partitions on tables and Indexes as part of performance improvement.
• Performance Tuning for long running queries using analyze, DBMS STATS, SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required.
• Gather stats for tables, Indexes to help with performance improvement.

Environment: UNIX, Oracle 9i, Sybase, PL/SQL, SQL, Embarcadero, Quality Center, Peregrine, Sub-Version, MS SQL server 2005/2008

Confidential

Software Engineer

Responsibilities:

• Involved in Database design according to the requirements gathered from the business side.
• Involved in designing the Entity relationship diagram (ERD) for the database
• Developed code using SQL and PL/SQL.
• Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data from data-mart based on specifications given by the accounting team.
• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance.
• Developed Views to enhance user restrictions.
• Involved in generating reports using Oracle Reports according to the request from upper management.
• Involved in technical documentation for the applications
• Used Unix KORN Shell Scripting for running nightly and monthly jobs.

Environment: UNIX, Oracle 9i, SQL Server, PL/SQL, TOAD, File-Aid, CA7, Quality Center, VISIO, SDSF.

Confidential

Software Programmer

Responsibilities:

• Worked on analysis, design of the Order Processing System.
• Created tables for the system in Oracle 8i.
• Involved in coding using SQL queries.
• Wrote SQL queries to retrieve and access data from MS Access.
• Developed the test documentation for the testing team based on the specifications of the system.
• Developed supporting documentation and help system.
• Involved in reviewing of project specifications.
• Involved in customer support.

Environment: Oracle 8.0.5, 8i, SYBASE, PL/SQL, SQL Plus, TOAD, Windows 2000 and UNIX