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 using Forward engineering.
• 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, Data Maker, 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.