SUMMARY

• Six+ years of IT experience in design, architecture, development, implementation and maintenance to support standard databases and data warehousing environments.
• Experienced in Insurance, Finance, Banking and Healthcare domains with full life cycle implementation of database development and reporting needs.
• 6+ years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimising the model.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
• Extensive experience in using ER modeling tools such as ERwin and ER/Studio.
• 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.
• Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Involved in the maintenance of therepositories for the metadata
• Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• 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 data migration strategies.
• Proficient in Data Cleansing and Data Profiling based on standards.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good interpersonal and human relation skills to interact with clients and co - workers
• Involved in the preparation of Detailed Design Documentation

TECHNICAL SKILLS:

Analysis and Modeling Tools: ERwin 4.1/7.2/7.0/8.0 , Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio

ETL Tools: Informatica Power Center 8.6.1/8.1/7.1 , Data Stage 7.5, Ab Initio

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos Powerplay

Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C++

Databases: MS SQL Server 2008/2005/2000 , Oracle11g/10g/9i/8i, DB2 V9.5, Teradata V2R6.1, MS Access 2000

Operating Systems: Windows XP/2000/98, UNIX (Sun Solaris 10)

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP),Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Data Modeler/Analyst

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• 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.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Conducted logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Used ModelMart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Extracted data from the databases (Oracle and SQL Server) using Informatica to load it into a single data warehouse repository of Teradata
• Created data mapping documents from source to target systems.
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
• Created logical and physical design of the centralized Relational Data base
• Normalization to 3NF/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Provided Database Normalization upto 3NF for the database schemas.
• Developed Conceptual, Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Identified and processed the facts and dimension tables.
• Exhaustively collected business and technical Metadata and maintained naming standards
• Participated in the tasks of data migration from legacy to new database system
• 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.
• Worked with report developers for building OLAP CUBEs for ad hoc reporting.
• Worked with Data Stage Administrator to create/modify/delete projects and cleanup projects
• Developed job control routines for batch processing in DataStage BASIC
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase
• Assisted end users, operations and testing teams by providing them with the necessary documents

Environment: Erwin r8.0, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000, SQL Server 2000/2005, SQL, Oracle 8i, MS Excel, MS Visio, Rational Rose, Requisite Pro

Confidential, Pittsburgh PA

Data Modeler

Responsibilities:

• Involvedwith the Business Analysts’ team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Performed the data source mapping.
• Utilized Power Designer’s forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Used ModelMart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created logical and physical modeling in Relational database and normalized with 3NF to remove redundancy
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering.
• Review the data model with functional and technical team.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Assistdevelopers,ETL, BI team and end users to understand the data model.

Environment: s: ERWIN r7.0, DB2 Version 9.0, Teradata 6.2, Oracle 10g, Microsoft Visio, Rochade Metadata Repository

Confidential, Huston TX

Data Modeler/Data Analyst

Responsibilities:

• Interviewed the end users for gathering information to determine requirements, data, report requirements, Analysis, meta data, Performance and Data Quality.
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
• Developed Logical and Physical Data models for the loan Systems by using ERWin 7.2.
• Conversed with Business Analyst and developers to gather information about the data models (Data Definition) to place the data dictionary in place.
• Extensively used Agile methodology as the Organization Standard to implement the data Models
• Redesigned some of the subject areas and introduced some new entities and attributes as per the requirements and also Supported database modifications.
• Designed different type of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
• Interacted with Business analysts and Developers to gather the Data Definitions for the Data Models to get the Data Dictionaries in place.
• Supported the DBA to physically implement the tables in both oracle and db2 databases.
• Analyzed the physical data model to understand the relationship between existing tables. Cleansed the unwanted tables and columns as per the requirements as part of the duty being a Data Analyst.
• Established process on the work flow to create Work flow diagrams using Microsoft Visio.
• Trained the team members on ERwin 7.2.
• Created DMR mapping spreadsheets, Source to Target mapping documents including the transformation rules
• Transformed requirements into data structures which can be used efficiently to store, manipulate and retrieve information.
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.

Environment: Data Stage 7.5, ERwin 7.2, PowerDesigner, Sybase12, Windows NT, MS Excel, MS Visio, DB2, Oracle 10g/9i, TOAD, CSV files, XML files, Cognos, UNIX

Confidential, Lincoln RI

Data Modeler

Responsibilities:

• Worked with business analyst to gather information on requirements
• Documented Technical & Business User Requirements during requirements gathering sessions.
• Analyzed conceptual into logical data and had JAD sessions and also communicated data related issues and standards.
• Involved in modeling business processes through UML diagrams.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Conducted model walkthroughs and validation sessions.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Participated in the tasks of data migration from legacy to new database system
• Worked on Metadata exchange among various proprietary systems using XML
• Handled performance requirements for databases in OLTP and OLAP models.
• Developed Cleansing and data migration rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Used Crystal Reports to generate Ad-Hoc Reports

Environment: Power Designer, Data Maker, Model Manager, SQL-Server, Teradata, Oracle, SSIS, Informatica Power Center, Cognos, Windows XP, Sun Solaris, Unix

Confidential

Data Modeler/ Analyst

Responsibilities:

• Analysed existing data model and documented suspected design affecting performance of the system.
• Involved in gathering user requirements along with business analysts.
• Used UML for Business process modeling
• Documented technical requirements and business user requirements using Rational Requisite Pro
• Worked on conceptual model to derive logical model and later conversion into physical model
• Created Dimensional Data models by using star and snowflake schemas
• Applied second and third NFR to normalize existing ER data model of OLTP system.
• Created summary tables and improved complex Join operation using denormalization methods
• Redesigned indexes and maintained large tables.
• Maintained and supported reports developed in Crystal Reports/ASP.
• Analyzed various issues pertaining to database and strategically resolved them

Environment: Windows NT servers, Oracle databases, SQL Server, DB2, Microsoft Transaction Server, ERwin, Crystal Reports, Informatica, MS-SQL server analysis manager.

Confidential

Data Modeler

Responsibilities:

• Collection of requirements from business users and analyzed based on the requirements.
• Worked in logical and physical designs and transforming logical models into physical implementations.
• Used Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Developed mappings, sessions and batches for relational & flat file sources and targets.
• Loaded data into target database from sources using Workflow Manager.
• Worked on stored procedures for processing business logic in the database.
• Performance query tuning to improve the performance along with index maintenance.
• Worked on the reporting requirements for the data warehouse.
• Had good communication with production and testing team and created support documentation.

Environment: s: SQL, MS Office Suite, MS Visio, Windows XP/NT, HTML, XML, SQL Server 2000, Oracle 9i, Business Objects, Teradata V2R5.0, ER/Studio, UNIX.