SUMMARY

• Around seven years of experience in the Information Technology industry, which includes demonstrated work experience as the DATA MODELER, data analyst and ETL/Report Developer.
• Expertise in gathering business requirements and decision support, strategic analysis which plays a key role in software development life cycle (SDLC).
• Expertise in developing the Conceptual, Logical and Physical data models for OLTP and OLAP systems using ERWIN, POWER DESIGNER and ER STUDIO data modeling tools.
• Proficient in data analysis, design using ER modeling and implementing RDBMS specific features.
• Experience with Kimball and Inmon methodologies.
• Extensive work experience in designing ER models, Dimensional models using Star schema and Snow flake schema.
• Expertise in implementing Normalization to 3NF/ Denormalization techniques for effective performance in OLTP and OLAP environments.
• Expertise in forward engineering, reverse engineering and designing the facts and dimension tables.
• Efficient in Extraction, Transformation and Loading (ETL) data from spread sheets, database tables using Microsoft data transformation service (DTS).
• Expertise in dealing with Slowly Changing Dimensions (SCD), conformed dimensions, junk dimensions, status dimensions and role playing dimensions.
• Experience in working environments involving consolidation of multiple application and databases like Oracle, SQL Server, Teradata and DB2.
• Good working knowledge of Meta - data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Having experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.
• Building reports usingSSRS, SSIS and Crystal Reports.
• Proficient in Agile and Water fall Methods.
• Experience in carrying out the entire Software Development Life Cycle (SDLC).
• Expertise in development and maintenance of mainframe applications using COBOL, CICS, JCL, DB2.
• Expertise in interactive SQL and embedded SQL. Proficient with both DDL and DML including Joins, Functions, Indexes, Views, Constraints, Primary Keys and Foreign Keys.
• Experience in data transformation and data mapping from source to target schemas, data cleansing procedures.
• Quick learner, self-motivating and enthusiastic to work with new technologies. Good team player and have strong ability to work under high stress environments.

TECHNICAL SKILLS

Data modeling tools: Erwin r7.1/7.2/8.0, Embarcadero ER/Studio Power Designer and Oracle Designer.

OLAP Tools: Microsoft Analysis Services, TPUMP and Crystal Reports.

ETL Tools: Microsoft DTS/SSIS, Data Stage 7.5, TOAD and Informatica 6x, Cognos.

Operating platforms: Windows NT, 2000 & XP, Vista, AIX, UNIX.

Languages: C, .NET, PL/SQL, SQL.

Databases: Oracle7/8i/10g/11g, Microsoft SQL Server2000/2005, MS Access 2000, Teradata, DB2 and MySQL.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Sr. Data Modeler/Data Analyst

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Transformed project data requirements into project data models.
• Responsible as a member of development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin r7.0.
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model (LDM) using Forward engineering and Physical Data Model.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Involved in designing built Data marts by using Star Schema and Snowflake schema.
• Closely worked with ETL process development team.
• Experienced in designing the Data warehouse.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Generated the first cut physical design.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.

Environment: Erwin r7.0, Metadata, Data Maker, Teradata, Model Manager, Oracle 11g, Informatica Power Center, Windows XP, Unix.

Confidential, Raleigh, NC

Data Modeler/Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in the redesign of the existing OLTP system.
• Acted as a Strong Data Analyst analyzing the data from low level.
• Worked with DBAs to recreate a best fit physical data model from the logical data model. Performed logical and physical data modeling with Erwin and Model Manager.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user.
• Performed Data modeling using Erwin.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering Erwin tool.
• Created databases, tables, views & schemas.
• Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Involved in the Database design and application development to support the creation and management of online business units for business users and customers usage.
• Used Erwin to transform data requirements into data models.
• Involved in extensive Analysis on the Teradata Systems.
• Helped in migration and conversion of data from legacy system to oracle database.
• Widely used Normalization methods and have done different normalizations (3NF).
• Good experience in data analysis querying and writing in SQL and TOAD.
• Analyzed the performance of the jobs during the project. Utilized standard techniques for enhancing the performance.
• Performed tuning of SQL Queries to improve the response time.

Environment: Erwin, Teradata SQL Assistant, SQL, PL/SQL, TOAD, SQL * LOADER, UNIX, MS OFFICE.

Confidential, Houston, TX

Data Modeler

Responsibilities:

• Participated in a numerous meetings with the business, DBA and business analysts to understand the scope and the requirements of the project.
• Participated in JAD sessions and other meetings to clarify the naming conventions followed with the Business Analysts.
• Reviewed the Business Requirement Documents (BRDs).
• Performed Data Profiling to understand the operational data.
• Created a high level dimensional model and produced several attributes list based on the requirements.
• Very good experience in generating reports using crystal reports and used to maintain and keep track of the various documents.
• Used ER Studio to create the logical and physical models.
• Created and used Source-to-target document to record how the data is moved from source to target databases.
• Understood the need for the different fact tables and the dimension tables.
• Good experience with slowly changing dimensions and mini dimensions.
• Used several conformed dimensions across different star schemas or data marts.
• Accumulating snapshots
• Degenerate dimensions/Role-playing dimensions/junk dimensions
• Used TPUMP for loading data from source into Teradata tables
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks
• Building reports using SSRS.

Environment: Teradata, ER Studio, TPUMP, SQL Server, MS Access, MS Office, SSRS.

Confidential

BI Developer

Responsibilities:

• Involved in gathering business requirements by conducting a series of meetings and brain storming sessions with the business users.
• Gathered and translated business requirements into detailed, production-level technical specifications, new Features, and enhancements to existing technical business functionality.
• Involved in identifying the process flow, the work flow and data flows of the core systems.
• Worked extensively on user requirements gathering and gap analysis.
• Created Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Embarcadero ER Studio.
• Involved in designing the data warehouse for the company to store the data from the OLTP systems.
• Involved in implementing and testing of the developed application data standards.
• Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
• Data Warehouse - Designed and programmed ETL and aggregation of data in target database, working with staging, de-normalized and start schemas and dimensional reporting.

Environment: SQL Server 2000, PL/SQL, UNIX, Windows NT, Informatica6x.

Confidential

Report Developer

Responsibilities:

• Gathered data into PL/SQL tables for validating and loaded into oracle tables using bulk loader utility.
• Responsible for gathering business requirements, creation of technical design documents and user documents.
• Used SQL* LOADER, PL/SQL procedures to facilitate data import to staging tables, interface tables and then base tables.
• Designed and developed oracle monthly reports.
• Wrote queries to retrieve data in XML format from the tables.
• Involved in supporting java web development team.
• Developed reports using SQL Server reporting services and resolving the complex SQL queries.
• Created triggers to track the changes to the tables made.
• Gathered statistics on large tables and redesigned Indexes.
• Designed and developed the databases
• Written Stored Procedures and Triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Done analysis of live site issues related to database and resolved the same

Environment: Oracle database 9i, SQL Developer, Toad.