SUMMARY:

• Over 11+ years of IT experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations, Testing of Data Warehousing and Database business systems for Telecom, Insurance, Banking, Retail & Manufacturing industries.
• 8+ years of Dimensional Data Modeling experience using Star Schema/Snowflake modeling, Fact & Dimensions, Physical & logical data modeling, Data Mart, OLAP, ROLAP, MOLAP, OLTP, SAP PowerDesigner, Erwin.
• Over 3+ years of strong experience in SAP BI ABAP.
• Extensive experience in creating dash boards, score cards and many Difficult Reports in Cognos and OBIEE
• Extensive experience in complete Software development life cycle (SDLC) for Huge Data ware housing
• Strong experience in gathering requirements like business definition requirements and functional requirements.
• Strong experience in Designing logical & physical data models with Erwin Tool, TeleLogic tool and Visio
• Strong Experience in RALPH KIMBALL star schema methodology.
• Expertise in conceptual modeling, logical modeling and physical modeling
• Extensive Experience in designing Normalized Data Warehouse.
• Experience in SAP BO Data Services (Designer, Repository manager, Job server, Management Console, Job monitoring), SAP BI/BW - Data warehouse (Info Cubes, DSO/ODS Objects, Data Marts, Multi Providers, Info Sources, Transformations), HANA- (HANA Studio modeling, calculation, and analytical view design, SLT replication configuration, Query design & development), Reporting in SAP BOBJ -Business Objects and BEx.
• Experience in Creating Fact Qualifier Matrix as per the business requirements to support Logical Model.
• Extensive Experience in system analysis & design of EDW and source system analysis.
• Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (OLTP) Data Warehouse design.
• Extensive experience in Data base management systems (DBMS)
• Strong experience in designing 2nd and 3rd normal forms and extensive experience in Cube designing
• Data warehouse experience is varied from Data Analysis, Dimensional Data Modeling, Data Extraction Transformation & Loading (ETL), Creating Meta Data layer, Data Mining, End User Reporting; Web based Reporting & Implementation, Creating Test scripts and user signoff documents.
• Experience in Designing, Source to Target Mappings between sources to operational staging targets, using Star Schema, Implemented logic for SCD’s.
• Strong Experience in Developing Mappings with using Transformations like Source Qualifier, Expression, Connected & Unconnected Lookup, Stored Procedure, Java, Sorter, Joiner, Normalizer, Update strategy, Router, Union and Filter etc.
• Being Part of full lifecycle of DW Project, gathered hands on experience on Evaluation, Installation, Development, Maintenance and Implementation of ETL tools such as Informatica, Data Stage & OWB and Business Intelligence Using Cognos, OBIEE & Business Objects
• Assist the end user and testing team in END to END testing the application. Create the documents and deployment packages required for deploying the application in various environments. Ability to write high quality software code and debug difficult issues.
• Extensive Experience in Developing Oracle Database objects like Packages, Stored Procedures, Functions, Triggers, views, and a strong Experience in Tuning the SQL code
• Strong experience in Oracle Query Optimization using utilities like Explain plan, SQL Trace, and TK Prof
• Experience in writing Unix Shell Scripts and Database validation scripts
• Created several scripts in UNIX for data transformations to load the base tables by applying the business rules based on the given data requirements.
• Experienced in working with SAP ABAP Queries, data extracts to SAP BW/BI - field Routines
• Experienced in working with SAP, Denedo, Tableau tools.
• Conduct the frequent code reviews and accepts the responsibility for the quality code review. Work independently when necessary critical issues to be resolved on project.

TECHNICAL SKILLS:

Data Modeling Tools: Dimensional (Star & Snow flake schema Modeling) & ER Modeling usingERWIN 3.5/4/4.1/7, Sybase Power Designer 9/10/11, Rational XDE, MS Visio

OLAP Tools: Cognos 8.1/7x, OBIEE, Crystal Reports, Business Objects XI/X

ETL Tools: Informatica 8.6.1/8.1/7.1.1/6.2, OWB, Data Stage, Trillium

RDBMS: Oracle 10g/9i/8i, SQL Server 2008/2005, Teradata V2R5/V4R4, DB2, Sybase

DW Methodologies: Star & Snowflake Schema Design, Data Modeling,Data Warehousing Design and Implementation

Programming Languages: SQL, PL/SQL, C, C++, Java, UNIX shell scripting, XML, HTML.

Database Skills: Stored Procedures, Database Triggers, Functions, Packages.

ERP: Oracle Applications 11i, People soft 8.9, SAP

Operating Systems: Windows NT, Windows 2003/2000, XP and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. Data Architect/Data Modeler

Responsibilities:

• Involved in data analysis, designing, and development of data warehouse environment.
• Analyzing business requirements, understanding the Entity Relations and translating business requirements into Conceptual & Logical Data Models.
• Identifying the Source Systems, possible Fact tables and Dimension Tables.
• Created Conceptual design as per requirements before designing logical and physical models
• Designed logical & physical data models with SAP PowerDesigner Tool.
• Designed and tuned Source to Target mapping for PARTY Model.
• Read the Employee data from SAP-BAPI’s/Web services to Denodo and implemented business logic in Denodo and exposed the final business views in Tableau.
• Experience in utilizing Teradata utilities like Bteq /Fast Load /T pump, Multi load script for loading Data
• Involved in Testing like Unit testing, System integration and regression testing
• Created Public and Private Views in TD using SAP PowerDesigner.

Sr.Data Architect/Modeler.

Responsibilities:

• Involved in data analysis, designing, and development of data warehouse environment.
• Involved in converting Embarq legacy CRB (Billing system) Customers in to Finance (Billing System) and worked on various Data warehouse projects
• Analyzing business requirements, understanding the Entity Relations and translating business requirements into Conceptual & Logical Data Models.
• Involved in complete soft ware development life cycle (SDLC)
• Identifying the Source Systems, possible Fact tables and Dimension Tables.
• Utilized Data Modeling tool (ERWIN) while designing the Logical & Physical models /Dimensional models for OLTP & OLAP databases.
• Maintaining the Model Versions in Model Repository, and documenting data model modification change logs
• Designed the complex Logical Data Model for E-BAY HRMS in 3NF using Erwin
• Designed and Implemented Dimensional Data Model for end users reporting needs.
• Conducting and participating in model reviews to validate data model according to business requirements.
• Reviewed Data Model with functional team and technical team for accuracy.
• Implemented Ralph Kimball star schema approach with OLAP multi dimensional model.
• Created DDL scripts from Data Model and co-ordinate with DBA to execute in the data base.
• Identified hierarchies in source database to build Dimensions in the Presentation Layer
• Designed slowly Changing dimensions (SCD’s) as per business needs.
• Designed staging area and populated from different sources after data cleansing, data mining.
• Developing the application based on the above designs using the latest tools like Informatica 8.6.1, Oracle 10g, HP-UX11, PL/SQL Developer, Core FTP.
• Worked with XML’s and XSD’s to load the data in to XML targets from different sources
• Conduct the frequent code reviews and accepts the responsibility for the quality code review. Work independently when necessary critical issues to be resolved on project.
• Design the ETL solution to extract the data from application’s database and prepared the required DDL's and the supporting SQL queries
• Extensively Involving in Developing Database Objects Like Stored Procedures, Triggers, Functions, Packages and Views using Oracle Pl/SQL.
• Extensively integrated Oracle and DB2 data sources in Staging area.
• Implemented partitioning and Query Optimization for performance enhancements.
• Implemented code migration from development to testing and Production
• Tuned sources, targets, mappings and sessions to improve the performance of data load into Oracle database
• Experience in utilizing Teradata utilities like Bteq /Fast Load /T pump, Multi load script for loading Data.
• Developed many list, chart, Crosstab, drill through, Master-detail and Dashboard Reports in Report Studio and developed Ad hoc Reports Using Query Studio
• Involved in generating dashboards, score cards and cubes using COGNOS tools
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Involved in assigning securities like Object level, Data level and Package level
• Involved in Testing like Unit testing, System integration and regression testing
• Worked as a lead and managed the Off shore and Onsite to assign the work to the data modelers and developers.
• Worked in Production environment for customizing the existing mappings, sessions and workflows

Environment: ERwin 7.2, Oracle 10g,SQL, PL/SQL, DB2, Teradata v2r5,Autosys,, TOAD, PL/SQL Developer, Cognos 8.1, WINDOWS XP, UNIX Shell Scripting, UNIX

SAP BI Consultant/Modeler

Responsibilities:

• Monitoring periodic data loads from R/3 to multiple data targets of BI system using transactions RSPC, RSPCM and SM37.
• Involved in solving the tickets regarding extractions, Performance Issues and also load failures.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Resolved Performance Issues like Creation of aggregates, Roll Up and Compressed the Info cube to improve the query response.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Scheduled data loads from R/3 to BI and optimize the load performance by data selections, data packet size adjustment.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Data Loads, and PSA Errors.
• Debugging the routines during route cause analysis and changes are made to meet the business requirement.
• Created routines as a part of enhancing the business functionality.
• Worked on data dictionary objects
• Created BEx Reports for the entire solution
• Involved in pre Go-live and Post go-live activities

Data Architect/Data Modeler

Responsibilities:

• Involved in requirements gathering, analysis and creation of the various reports and the logic to be implemented by involving in different meetings with the business analysts and the business users
• Identifying the source systems, data analysis, defining data standards, preparing conceptual models
• Designed conceptual model, logical model and physical model to satisfy business needs.
• Transforming business requirements into Dimensional (star schema) data models.
• Created Logical & Dimensional models using STAR SCHEMA with multiple fact & Dimension tables for the data marts.
• Involved in Full Life Cycle Development
• Involved in designing data models for Large Data warehouse
• Involved in OLAP Data modeling to develop the database design using Erwin
• Implemented INMON’S approach for DWH and Designed Normalized database.
• Designed and Implemented Dimensional Data Model to satisfy end users reporting needs.
• Developing, maintaining, and applying standards for data mart modeling, and naming conventions
• Designing the Logical & Physical models for the Data marts using ERWin.
• Designed OLAP data models with star schema Ralph Kimball approach involved in creating cubes for huge Data warehouse
• Involved in designing Dimensional structures for data ware house
• Performed Impact Analysis on existing database in order to create Functional Data Requirements and Design documents.
• Producing system documentation - primarily data models and data dictionary definitions
• Creating tables, relationships, triggers and indexes for enforcing business rules.
• Designed ETL mapping documents to populate the data from source systems to target.
• Design the ETL solution to extract the data from application’s database and prepared the required DDL's and the supporting SQL queries
• Developing the application based on the above designs using the latest tools like Informatica 8.6.1, Oracle 10g, HP-UX11, Control M, PL/SQL Developer
• Involved in Query Optimization for improving query performance for that involved in developing Indexes and Materialized views
• Managing the deliverables and integration with the overall project plans. Coordinating the tasks across database team members and managing changes during the development cycle.
• Create mappings accessing data from db2, SQL Server 2005, Oracle using Informatica Power Connect.
• Extensively involved in designing Change data Capture (CDC) For Incremental Data loading purpose
• Migrated repository from Informatica 7.1 to 8.1.1
• Created mappings with retrieving data from SQL server and Oracle data bases, designing the Logical and Physical data models for the data warehouse
• Extensively Involved in Developing Data objects Like Stored Procedures, Functions, Packages, Triggers In SQL Server
• Involved in Developing Dashboards and Score cards using Analysis studio
• Involved in scheduling and migrating the reports in Cognos, knowledge transfers to the junior developers, Unit, Integration, system, and performance testing levels.
• As a senior member involved in Assigning the work to data modelers and Developers
• Train users on usage of the Informatica and Cognos tool and its different module

Environment: ERwin 4, Oracle 10g, SQL Server 2005/2008, Teradata, Management studio, Cognos 8.1, Toad, WINDOWS XP, Trillium, J2EE, Autosys, Informatica 8.1/7.1, Unix Shell Scripting, HP UNIX

Data Architect/Data Modeler

Responsibilities:

• Involved in requirements gathering, analysis and creation of the various reports and the logic to be implemented by involving in different meetings with the business analysts and the business users
• Conducted sessions with business user to understand business rules and data structures.
• Implemented Ralph Kimball star schema approach with OLAP multi dimensional model.
• Creating Conceptual Models and developing Naming Standards for Data models.
• Involved in designing of Entity Relationship Diagrams, defining sub-type relationships between entities, identifying cardinalities and resolving many- to - many relationships.
• Created Logical & Entity Relationship Physical data models using ERWIN tool for the OLTP databases.
• Identifying the Fact and Dimension tables and Preparing Warehouse Matrix
• Design the ETL solution to extract the data from application’s database and prepared the required DDL's and the supporting SQL queries
• Enhancing / Designing the data Model using ERWIN to support the current reporting needs
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users
• Designing and developing Informatica mappings, sessions, worklets and workflows.
• Loading data from Flat Files into the Staging area using Informatica PowerCenter 7.1.2
• Worked on Informatica PowerCenter 7.1 tool - Source Analyzer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Extensively used Router, Lookup, Aggregator, Expression, Lookup and Update Strategy Transformations.
• Worked with SQL Server for loading data into target data warehouse
• Worked with Business objects for developing various types of complex reports and dashboard based on the user requirements
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the tasks to be run using the Workflow Manager.

Environment: Erwin 3.5.2, Informatica 7.1.1, Oracle 9i, SQL, PL/SQL, Toad, Discoverer, Ab Initio, Sybase, Power Designer, Power center, Cognos, Unix Shell Scripting, Business objects, UNIX, Windows XP

SAP Technical Consultant

Responsibilities:

• Developed a Report and a Dialog program for C.C Documentation for editing the shipping details.
• Developed a Report is to provide a tracking tool to the Logistics expediter for exports.
• Developed a Report for Exemption unit at SMO to give the detailed list of Exemptions. Developed a Smartform for Bank Guarantee Request.
• Validating the Payroll data for Asia sub-continent by comparing the Delta files with the data in XI Server.
• Developed a program to upload mass learning data from flat file to R/3 using transaction PVD0.
• Developed a program which validates the Termination and retirement dates and in turn sends Email to the employee and to the superiors

SAP ABAP Developer

Responsibilities:

• Developed an ALV output report to Output the List of shipments/Nominations with Non-zero stock balances.
• Involved during SECess Budget ’07 and VAT ‘07. Major responsibilities where applying SAP - Notes For the Standard Reports, Module Pool Programs Function modules & Includes and Analyzing, & Testing those reports.
• Developed New stock inventory Reports for both Raw materials & Finished goods, VAT returns Report
• Developed VAT returns reports for both purchases and sales.
• Developed User-Exit for Availing Ordinary leave, Sick Leave, Casual Leave & Coffs for H.R.
• Developed Reports in H.R for Monthly Man Power report for determining Total Head Count and Wage type details Report to list total number of Employees in TPL.
• Developed programs for migrating Sales Order Data from legacy system to the SAP system using BDC CALL Transaction method.
• Uploaded HR Master Data from legacy file into mySAP database using CALL Transaction Method.
• Developed LSMW using Custom ABAP program for Create Project, WBS Eléments.
• Developed ALV report to show what are the put away and picking strategies are handled for the goods movements.
• Developed Report that displays all the late shipments in a period.
• Developed daily shipping status report to display quantity shipped, quantity released but not shipped, during the current month and during the current business day.
• BDC program for up loading data for depreciation amount for transaction AS02.
• Created BDC’s for uploading customer master data, pricing conditions and other data related to enquiry, quotation, sales order, and billing from the legacy system using both Call Transaction and Session method.
• Modified layout set SHIPMENT DOC and corresponding print program.