Software Engineer Sql Server

Professional Summary:

• Over * Years of Professional experience in IT Industry.

• Diversified experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence Systems, Data Warehouse (DW) Systems, OLAP, ETL, SQL, PL/SQL and ERP solutions.

• Certified “Oracle Fusion Middleware 11g Business Intelligence Foundation Certified Implementation Specialist”.

• Extensively worked on DW/BI Projects for Fortune 500 clients in Sales, Marketing and Financial subject areas with a team of OBIEE 11g, Oracle Business Intelligence 10.1.3.x and Cognos 10.

• Business Intelligent Solutions using Data Warehouse and OLAP Techniques.

• Experience on many Data Warehouse / Business Intelligence projects in USA and India, Design and Implementation of DWH/Data Mart, Gathering Business Requirements, System Analysis & Design and Data modeling.

• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series & Caching.

• Designing and Building the Repository (Physical, Business Model and Presentation Layer), Catalog Manager, Configuring iBots (distributing the reports and building Alerts) and designing the Dashboards, Answers for canned and ad-hoc reporting.

• Extensive knowledge in various web reporting platforms with specialization in OBIEE Administration Tool, OBIEE Dashboard, Answers, BI Publisher, Cognos Framework Manager, Cognos (Report Studio, Query Studio, Analysis Studio, Event Studio), HTML, JavaScript.

• Expertise in Oracle 10g- design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL.

• Good hands on experience in using BI Publisher to create reports from BI Answers, BI server.

• Experience in Implementing MUD (Multi User Development) Environment.

• Good Knowledge in Performance Tuning of Dashboards and on database side.

• Energetic, highly motivated individual, with good analytical and communication skills.

Technical Skill:

Packages and Tools

OBIEE 11g, OBIEE 10.1.3.x,

Cognos 10,

Oracle Forms and Reports,

SQL Server Integration Services (SSIS).

Database

Oracle 9i/10g/Exadata, SQL Server 2000

Languages

C, C++, SQL, PL/SQL, HTML, JavaScript

Tools/Utilities:

TOAD, SQL Developer, SQL Loader, Erwin

Web Technologies

XML Spy, RAD

Operating System

Solaris, Windows XP/Server 2003 & 2008

Job Summary:

Working as Lead Consultant with Headstrong, New York since Feb-10.

Worked as Team Lead/BI Consultant with Wipro Technologies Ltd from Nov-07 to Feb-10.

Worked as Associate Consultant with I-flex Solution Ltd, Bangalore from Sep-06 to Nov-07.

Worked as Software Engineer with Eastern Software Systems Ltd, Mumbai from Aug-05 to Sep-06.

Professional Experience

JP Morgan Chase, New York

BI Lead Consultant

Dec 11 – Till Date

Contribution / Highlights:

Gather Information regarding the OBIEE Reports/ Dashboards requirements and to define business and functional specifications.

Data modeling and technical documents for OBIEE implementation.

OBI Repository creation (the Physical layer, Business layer, Presentation layer) from scratch.

OBI Reports & dashboards creation.

BI Publisher Reports and iBot (Delivers) creation.

Implementation of security and setting privileges & permissions for users and groups in Web Administration & OBI Repository.

Multi-user development environment configuration and execution.

Dashboards/Reports verification and data validation against source systems.

Object and Data level security in Oracle Administration Tool to set up groups also manages security for groups in BI Answers.

Document creation production support and end user training.

Customization of Pre-built OBI Repository and BI reports to accommodate the new requirements.

Data Loading, Monitoring and Scheduling for Data Warehouse.

Provided wide range of Ad-hoc analysis capability.

Performance tuning of Reports and made changes to database by implementing materialized views and partitions, optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes and report changes

Client, Project and resource management and control activities.

Platform: OBIEE 10.1.3.4.1, Oracle 11g Exadata, Solaris environment

MF GLOBAL, New York

Sr OBIEE Consultant

Feb 10 – Nov 11

Core Foundation Services (CFS), CFS System Engineering, IR Swaps

Contribution / Highlights:

Gather requirement for the reports to be developed.

Designing functional and technical documents for OBIEE implementation.

Data modeling.

OBI Repository & Reports & dashboards creation from scratch.

BI Publisher Reports and iBot (Delivers) creation.

Implementation of security and setting privileges & permissions for users and groups in Web Administration & OBI Repository.

Dashboards/Reports verification and data validation against source systems.

Data Loading, Monitoring and Scheduling for Data Warehouse.

Provided wide range of Ad-hoc analysis capability.

Client, Project and resource management and control activities.

Platform: OBIEE 10.1.3.4.1, Oracle 11g Exadata, Solaris environment

WAL-MART STORES, INC. Bentonville, AR

OBIEE Consultant

Aug 08 – Feb 10

Multi-Tenant E-Commerce Platform (MTEP)

Development and Implementation of OBI reporting solution for Multi-Tenant E-Commerce Platform (MTEP) The project is to integrate UK based ASDA’s (a Wal-Mart family) Multi-Tenant E-Commerce Platform (MTEP) with Wal-Mart’s Proprietary systems. The project comprises of design, development, testing and deployment of 31 interfaces using Web Sphere product suite.

Contribution / Highlights:

Involved in Database side - Creating Stored Procedure, Materialized View and Views for Real Time Reports.

Validating the source and target tables data.

Identified Facts, Dimensions and Dimension Hierarchies for modeling.

Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.

Involved in the technical design of the reports.

Involved in Reports and Dashboard creation.

Scheduling and delivering the reports.

Defining the security at report and group level.

Integration Testing.

Platform: OBIEE 10.1.3.4.1, Oracle 10g, Solaris environment

WAL-MART STORES, INC., USA - Enterprise Information System (EIS)

OBIEE Consultant

Dec 07 – Aug 08

This Enterprise information system (EIS) dashboard developed for the retail giant in US, it has lots of branches in Benton, Brisbane California and also it has branches in UK. Dashboard shows the Organization hierarchy and track the performance of the Employees, Technology and Process.

Contribution / Highlights:

Worked in database side - Create stored procedures for transposing the data from stage2 tables to fact tables and views for showing the data in dashboard based on the requirement of the project.

Used Answers to customize reports for additional views and interactive/ drillable charts.

Developed different kinds of reports using pivots, charts and global and local filters using Siebel Answers.

Customized the repository and created new requests using Answers.

Created package in SSIS (SQL Server Integration Services) for populating into stage1 tables from source database including validations.

Created reports in OBIEE based on the requirement of the project.

Created different types of dash board prompts and also implemented cascading prompt functionality in dashboards

Provide production/warranty support for Divisional Dashboard.

Platform: OBIEE 10.1.3.4.1, SQL Server 2005 Integration Services (SSIS), Oracle 10g, Sun Solaris environment

I-flex Solution Ltd, Bangalore

Associate Consultant

Sep 06 – Nov 07

Flexcube-CL (Consumer Lending)

Development, Enhancements and Offshore Support for Consumer Lending Module

Clients:

Sicredi – Brazil

Banco de Chile – Chile

Platform: Oracle Forms 6i, Oracle, PL/SQL, SQL, XML Spy, RAD

Contribution / Highlights:

Analyzing the technical scope of the system.

Development, Enhancements and Offshore Support.

Coordinating with the onsite team to ensure the smooth functioning of the package.

Debugging.

Designing and Preparation of Functional & Technical Specifications for new releases.

Preparation, Review and Consolidation of documents like Program Specification & Unit Test Plan.

Worked on the Interface operations required by various banks for uploading data from their third-party tools to our banking product.

Unit Testing.

Eastern Software Systems Ltd, Mumbai

Software Engineer

Aug 05 – Sep 06

ERP package “Ebizframe”

Implement Development, Enhancement and Support the ERP packages at client side along with internal up gradation.

Clients:

Shrenuj & Company Ltd., Mumbai,

Sociedade de fomento Industrial Pvt. Ltd., Goa,

Recon Oil India Pvt. Ltd., Mumbai

Platform: Oracle Forms 6i & Reports 6i, Oracle 9i, Oracle – PL/SQL, SQL and Windows environment.

Contribution / Highlights:

Involved in requirements gathering and customization of different modules like HR, Purchase, Sales, Finance etc. being implemented at the client-side which includes developing forms and designing reports and backend changes.

Developed the Supply Chain Management Module.

Implementation, Development and Customization at client-side

Qualification/Certification

Master in Computer Application, Kurukshetra University, India

Bachelor in Computer Application, Kurukshetra University, India

Certified by Oracle Corporation as “Oracle Fusion Middleware 11g Business Intelligence Foundation Certified Implementation Specialist”.

Certified by NCFM as “Beginners in Financial Market”.

Contact this candidate