SUMMARY

• Over 15+ years of experience in Analysis, Design, Development, Testing and Implementation of Large Web Portal, Data warehousing and Business Intelligence Projects which includes 8+ years of project leadership and management of teams
• Strong Expertise NGOSS standards, ITIL, eTOM & SID models
• Strong expertise in creating Architecture Strategic Planning using various principles Zachman, Gartner etc.
• Expertise in building Sales and Finance business processes for Banking, Telecom and Retail industries
• Hands on experience in data analysis, cleansing data and data health checkup using the excel sheets and database queries
• Skilled in managing, monitoring, estimating Project Cost and Time
• Highly proficient in creating Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Detailed Design Documents
• Expertise in Data Warehouse Architecture, including Ralph Kimball and Bill Inmon approaches
• Adept at Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata database environments
• Strong expertise in Data modeling using Confidential Schema, Snowflake Schema and 3NF for Data warehousing / OLTP systems
• Hands on experience with data modeling tools ER Win, MS Visio and Designer 2000
• Expertise in design and implementation of punch in/punch out architectures
• Strong expertise in Oracle SQL Loader, Export/Import, Data Pump and Teradata loading tools FastExport, Multiload and TPump
• Experienced in Oracle SQL Performance Tuning with Oracle tools
• Strong expertise in design and implementation of extraction and transformation process
• Hands - on expertise on BI tools Oracle Business Intelligence (Siebel Analytics) and Business Objects
• Active team player and self starter with immense ability to grasp and apply new concepts
• Very strong expertise in Informatica Power Center, Mapping Designer and Workflow Manager
• Solid analytical, presentation, verbal and communication skills, and can easily establish rapport to influence management and multiple levels of the organization
• Experienced in working with global teams (off-shore / On Site model)

TECHNICAL SKILLS

Project Management/Leadership: MS Project Planning, QualityCenter, MS Shared Server

Business Analysis: Front page, Rational Rose, QualityCenter

Database: Oracle 8i, 9i, 10G, Teradata, MS SQL

Data warehousing: Confidential or Data Mart Architecture/ Data Modeling, Ralph Kimball & Bill Inmon methodologies

BI Tools: Siebel Analytics 7.x,Business Objects

ETL: Informatica 7.x, Code based, Siebel DAC, OWB

Job Scheduling: Autosys, $Universe

Application development: PL/SQL, Java, J2EE, TOAD, Benthic, JDeveloper, Textpad, Eclipse, Perl

Unix Systems: HP, Solaris, Linux

Software Configuration tools: CVS, ClearCase

E Business Suite: Oracle Applications (AR), Siebel CRM

Data modeling tools: ER Win, MS Visio, Designer 2000

Data modeling techniques: 3NF, Confidential /Snowflake schema

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Modular

Responsibilities:

• Working with Technical PM on consolidating requirements for enhancements
• Working with DBA team to collect the poorly performed queries and provide suggestions
• Working on new technical roadmap with management and implementation
• Providing status reports to managements on development of enhancements
• Working with offshore team for development activities

Confidential

Teradata Architect

Responsibilities:

• Working with Project managers and business team to gather requirements
• Design E2E data preparation for Score Card specific data
• Data Modeling for Incentive Data mart
• Coordinate QA team in preparation and execution of test cases
• Instituted standard principles and practices to optimize the effectiveness of data integrity and cleansing
• Established Teradata performance tuning procedures for data migration and ongoing reporting activities; synchronized function of the QA and Development Team to ensure 100% success in implementing the process
• Designed views in Teradata that mirror BI Application requirements
• Led the implementation of custom-built End-to-End ETL solutions from sources to TDW environment

Confidential, Boston, MA

Solution Architect / Business Analyst

Responsibilities:

• Meet with Product marketing people to collect the product details
• Setting up JAD sessions/ participating in JAD
• Creating SRS, Analysis and Design documents, ETL mappings documents for global development teams
• Data modeling of the product details based on the Ordering and quoting systems
• Working with marketing teams to design product bundles, packages
• Design and develop interface between source systems, provisioning and billing systems
• Design and develop the automation process to keep the product details in sync with the sources
• Design Catalog Interchange Format(CIF) to support product enablement in Ariba Platform
• Design and implementation of Punch in and Punch Out mechanisms
• Working with QA teams to get the scenarios created and implemented
• Resource allocation and monitoring the development process in different GEO locations (offshore/onsite model)
• Working with business teams to get the User acceptance
• Participating in GO/NO GO calls
• Help the team in production deployment and production sanity check with business and QA community

Environment: Oracle 10g, OWB, Teradata, Informatica 7.x, ClearCase, MS Share server

Confidential, San Jose, CA

Data Architect

Responsibilities:

• Collect the Business Requirements from the Stake Holders and Partners
• Creating Project estimations (Cost and Time estimates) and Project Plans
• Creating Conceptual model to represent the high level entities required for this requirements
• Design of Operational Data Store to fit to the data synchronization
• Create Logical and Physical data models with Confidential / Snowflake models
• Create Analysis and design documents with data model, ETL Mappings, transformation rules, dimension and fact table population criteria and sequencing
• Work with DBA and Development team in creating the data mart
• Work with Infrastructure groups with data space requirements and BI portal requirements
• Working with Business Intelligence (BI) team to create metadata for OBIEE physical, logical and presentation layers
• Work with Business objects team to create universe using the data mart
• Help BI teams to debug issues, provide queries for standard reports and performance tuning
• Monitoring Project Development and provide suggestions to development team
• Design the Database and Application Security and Implementation
• Production support and enhancements required based on the business requirements

Environment: Oracle 9i, Teradata, Oracle Business Intelligence (Siebel Analytics) 7.8, Informatica 7.x (ETL), CVS, Siebel CRM

Confidential

Responsibilities:

• Data Modeler and Developer working with Confidential team on migration strategies and analyzing the existing Confidential Teradata platform
• Gap analysis of data model from existing Oracle environment to proposed teradata model 3NF
• Analysis of BI impacts based on teradata implimentation
• Creating Logical(LDM), Extended Logical (ELDM) and Physical Data Model (PDM) with respect to Teradata based on the existing data model
• Creating Analysis and design documents with data models and approaches required to get the data population
• Creating ETL Mappings with Source systems Ordering, Customer profiles, Partner Profiles etc… to the destination data mart
• Creating Database Objects and PL/SQL scripts for preparation of data according to the Business requirements
• Extensively used SQL Loader, Export and Import utilities and Teradata FastExport, MultiLoad, Tpump in Data Migration with Informatica Power Center
• Develop Views/indexing strategies for Tables / Materialized Views in Teradata environment

Environment: Oracle 9i, Teradata 6.0, Informatica 7.x,, CVS

Confidential

Data Modeler

Responsibilities:

• Work with requirements team to collect the enhancements
• Create design and analysis documents with the changes required for existing data model and additional report requirements
• Design and Implementations of ETL Logic and Batch Job Scheduling for extraction of Dimensions and Facts with minimum downtime to the Reporting Tool
• Creating Database Objects and PL/SQL scripts for preparation of data according to the Business requirements
• Performance tuning of Queries, Database using Explain Plan and TKPROF Oracle Utilities
• Design and develop the indexing strategies for Oracle Tables / Materialized Views
• Work with BO team to implementation BO Universes changes and BO Reports

Environment: Oracle 9i, BO 6.5, Informatica 7.1

Confidential

Technical Lead

Responsibilities:

• Design and implement Logical and Physical data model with Confidential / Snowflake models/schemas
• Design and Implementations of ETL Logic and Batch Job Scheduling for extraction of Dimensions and Facts with minimum downtime to the Reporting Tool
• Helping Development in Performance Tuning and any changes in the process of implementation
• Creating Database Objects and PL/SQL scripts for preparation of data according to the Business requirements
• Performance tuning of Queries, Database using Explain Plan and TKPROF Oracle Utilities
• Design and develop the indexing strategies for Oracle Tables / Materialized Views
• Design the data population or preparation with minimum/no downtime of the application
• Design Application Security and Implementation with BO Supervisor
• Design and implementation BO Universes with BO Designer

Environment: Oracle 9i, BO 6.5, Informatica 7.1

Confidential

Responsibilities:

• As Technical Lead, responsible for interacting with Business team to collect the requirements and template for compensation plan
• Design and develop the Oracle schema to implement the requirements
• Developed PL/SQL packages to populate the reference data required and to interface utilities required for UI
• Extensively used CLOB, DBMS XMLGEN, XMLTransform utilities to provide the xml, xslt formats to UI
• Preparation of data migration procedures and working on deployment of objects on SIT, UAT and Production
• Working with QA team to get the testing scenarios done and executing. Working on issues raised by QA team

Environment: Oracle 9i, EJB, JSP, J2EE, JSP, PL/SQL, XML, XSLT e-Customer - Confidential Integration with Customer Registry

Confidential

Responsibilities:

• Served as Tech Lead on this project and was responsible for gathering requirements from the Business Users
• GAP Analysis of Current system with respect to the TCA Model
• Design Data flow diagrams and database structures according to the TCA model
• Extensively used the Oracle 11i TCA APIs like Create Party, Create Organization, Create Relationships, etc.
• Performance Tuning
• Design of Concurrent Programs and implementation for every day Change Management
• Extensively used Oracle Tools SQL Loader, Export and Imports

Environment: Oracle Applications 11i TCA Model, Oracle 9i, EJB, JSP, J2EE, JSP

Confidential

Responsibilities:

• As Senior Programmer/Analyst, collected and analyzed the user requirements
• Design database schema based on the requirements
• Create Informatica mappings from source to targets
• Design the Batch Job Schedules and implement using Autosys Scheduler

Environment: Oracle 8i, Informatica

Confidential

Sr. Programmer Analyst

Responsibilities:

• Design and implementation of Database Objects
• Design and Implementation of extraction of file extraction and Load to current database
• Design the Batch process for every day extraction of files from other Servers
• Create Objects required for the User Interface
• Performance Tuning

Environment: Oracle 8i, Pro C, PL/SQL, Perl

Confidential

Consultant

Responsibilities:

• Served as Database Administrator on the CBI-Computerization Project.
• Project Design and Implementation in all branches of CBI in India. Led the implementation effort in all Metros.

Environment: SCO Unix, Pentium Pro 200, Perl, C, C++, Oracle 8.0, PL/SQL, Developer 2000, ERWin

Confidential

Responsibilities:

• Generated out Entity relationship diagrams, functional flow diagrams, dataflow rams and generated the DDL script for the physical database design.
• Extensively Used Oracle DBMS SQL package for executing dynamic SQL.
• Prepared System Specification, Functional Specification, Program Specification and Test plans for the system.
• Developed Entity Relationship diagrams, Process Flow diagrams, Functional Flow, Data Flow diagrams and generated the DDL scripts for Tables and integrity constrains using Designer 2000.
• Testing the Validity of data entry and Functional requirements
• Design and Creation of Users, Roles and their privileges exclusively for this module

Environment: Oracle 7.3, Perl, C, C++, Developer 2000, PL/SQL, Turbo Analyst (Case Tool)