Summary of Experience

• 8 years of IT experience in various stages of Software Development Life Cycle SDLC including analysis, requirement engineering, development, enhancements, testing, and maintenance of various JAVA, Data warehouse ETL/OBIEE applications.
• Currently working as a Technical Lead for a team of 5 offshore, with direct client interaction for requirement gathering, design, and solution delivery.
• Single point of contact for the business users and internal teams for BI requests and solutions.
• OBIEE 10G/11G/BI Publisher expertise with overall 7 years of IT experience in Software Design, Development, Requirements Gathering, Customization, Maintenance and Testing of various Business Applications.
• Datastage 7.5/8.0/8.1 expertise with 7 years of experience in ETL end to end implementation of data warehousing projects
• 6 years of experience in Data Warehousing/Business Intelligence solutions primarily using OBIEE for implementing Decision Support Systems.
• Worked extensively on OBIEE Admin tool on Physical, Business and Presentation layers of RPD
• Worked on multi user RPD development environments
• Very good experience in OBIEE Answers, Dashboards, Prompts, iBots
• Very good experience in OBIEE Functions, Measures, Aggregates, Dimension hierarchies
• Extensively worked on building Interactive dashboards and iBot schedules for business users.
• Worked extensively on OBIEE security requirements.
• Work experience in different phases of Data Warehousing life cycle involving Analysis, Design, Development, Testing and Production Support.
• Around 6 years of experience in ETL using Datastage in different phases involving requirement gathering, development, testing, deployment, maintenance and support.
• Worked extensively on Datastage ETL Code development, testing, deployment, performance tuning and production support.
• Extensively worked on ETL Incremental loads and high availability data warehouses.
• Around 1 years in AGILE lifecycle and processes
• Recognized Team Player with the ability to perform well in a group/as an individual.
• Around 4 years of experience in UNIX scripting, JAVA and DOTNET
• Worked on end to end implementation of OBIEE projects
• Worked on Data modelling Star and Snow flake schemas and schema creations
• Currently leading a team of 5 resources.
• Very good client interfacing skills
• Very good problem solving skills
• Very good ability in coordinating with multiple teams
• Very good knowledge on Version Control

Technology:

Tools: OBIEE 11G/10G,BI Publisher 11g, Datastage v7.5/v8.0/v8.1, ERWIN

Databases: Oracle, Teradata, Informix, Netezza, Exadata

Web Technologies: HTML, CSS, ASP, JSP, PHP

Programming languages: Java, DOTNET, Unix, PERL, C, C , PL/SQL

Database utilities: SQL Developer, Toad, Queryman, SQL Assistant

Microsoft applications: Word, Excel, PowerPoint, Access, Visio, Sharepoint

Version control tools: Teamforge, POWER, Visual Source Safe

Others: CA7, JIRA, Remedy 7

Professional Experience

Confidential

Project Description: The BI project at JC Penney is initiated to provide the business users, store associates and auditors with operational and analytical reporting

Role: As a Technology Analyst and Lead, the following key activities/responsibilities were performed

Lead a team of 6

• Worked as a lead in Analysis, Requirements gathering, Design and Implementation of OBIEE Technical solutions to business users especially on the operational and auditing front. This implementation provided the business users especially the auditors with valuable information on stores, their transactions, missing financials etc.
• Understood various business needs and provided solutions and implementations via ETL and OBIEE 11g and BI Publisher 11g
• Conducted knowledge sharing sessions to business users on the architecture, design and usage of the BI publisher 11g.
• Provided many workarounds to the BI Publisher tool limitations especially with prompt validations and linked/drill down reporting.
• Implemented a unified security model in the RPD to provide all BI projects, a security framework to implement both object and data level security depending on the project needs.
• Worked on performance improvement of BI reporting in OBIEE 11g by optimizing the existing design of the RPD business models which are ported from OBIEE 10g
• Provided timely and reliable solutions to the clients which are recognized and appreciated by the clients.
• Worked on PL/SQL queries for providing operational reporting on stores to the store associates and auditors.
• Proactively notified the issues/limitations with the BI tools and provided workarounds to the business users which are focused on improving the user experience for the report users who are new to the platform

Confidential

Project Description: Project Sams Dotcom BI was initiated to set-up a Data warehouse to cater to the reporting needs in Finance, Logistics, Merchandise and Operations areas

Role: As a Technology Analyst and Lead, the following key activities/responsibilities were performed:

• Lead a team of 5 offshore
• Worked as a lead in Analysis, Requirements gathering, Design and Implementation of OBIEE Technical solutions to business users especially on the financial auditing front. This implementation provided business with greater visibility to financials data which are posted as journal entries to SAP financial systems on the BI application in a user friendly manner.
• Understood various business needs and provided solutions and implementations via ETL and OBIEE
• Conducted knowledge sharing sessions to business users on the architecture, design and usage of the BI application
• Conducted knowledge sharing sessions to business users on the Data model, relationships between various entities, data granularities and data loads
• Worked in Data modelling, Star Schema design for the project
• Provided timely and reliable solutions to the clients which are recognized and appreciated by the clients.
• Prepared High level and Technical Design documents
• Prepared mapping documents for OBIEE implementation
• Prepared optimized SQL queries for source data extraction
• Optimized various existing SQLs for better performance
• Worked on determining key indexes to improve overall query run times and reducing the result retrieval times in the BI application reports/dashboards
• Developed and tested various RPD and Web cat changes which include Physical Layer, Business Layer and Presentation Layer changes
• Worked on implementation of security to different set of users using AD Groups
• Created Year/Month/Week and Quarter to Date metrics in business layer or RPD
• Created various dimension hierarchies for drill down capability to business users
• Developed and tested various simple and complex reports and dashboards to business users in various areas including Finance, Logistics, Merchandise and Operational
• Worked on development of important dashboards to provide business users with week on week and day on day sales compared with last year sales. This dashboard is used by the business users in aiding the business decisions and also provides visibility to the sales performance.
• Worked on various reports for Memberships, Returns and Refunds
• Worked on various tax reporting needs for the business to provide visibility to the tax which is used in financials auditing for the company.
• Worked on hourly sales reporting to provide high visibility to hourly sales data for business which is compared with previous years' data for performance analysis in each of the various business functional areas.
• Setup various automated deliveries iBots to business users on critical club reports and daily sales reports.
• Worked in the entire project life cycle from Requirements to Implementation and Warranty Support
• Prepared source to target mapping documents
• Prepared various help documentation to aid business users in using the BI application
• Worked on configuration of security for various web catalog objects to restrict or grant specific privileges to specific set of users.
• Migration of Datastage code from v8.0 to v8.1 on Enterprise servers
• Determined, developed and implemented key metrics for business reporting in providing high visibility to critical logistics data
• Worked on daily file archival and application maintenance via UNIX/PERL scripting
• Worked on creating alerts and monitors automation using JAVA/ Javascript
• Worked on CA7 Scheduling for ETL Daily Loads to load incremental data to the warehouse
• Worked on Troubleshooting and Production Support for various issues/ business questions
• Performed extracts of data from the Sterling systems and load to Teradata Warehouses
• Regular interactions with Business Users/Clients to gather requirements for new reporting needs or enhancements
• Other deliverables included -
• Extensive performance optimizations via usage of caching and also via ETL code and database optimizations

Technical Environment: Database - Oracle 10g, Teradata Reporting Tool OBIEE 10.x ETL- IBM Datastage 8.1 Scripting UNIX, PERL Alerts and Monitoring JAVA, Javascript, HTML Tools JIRA, Queryman, SQL Developer, CA7

Confidential

Project Description: The project Sams Club is a warehousing project. This project involved creation of data warehouse.The current implementation is for the US. The current build is an enhancement build which involved in creation of new metrics in Logistics area to provide better visibility on Shipping and Carriers to the Business.

Role: As a Technology Analyst the following key activities listed below were performed:

• Lead a team of 4 offshore
• Worked as a lead for design, development and implementation of BI solution using OBIEE for reporting and Datastage for ETL.
• Worked on Requirements gathering from Business users on the enhancements.
• Worked on understanding the business requirements regarding the visibility of data and created high level requirements and design documents
• Worked on the creation of detailed technical design documents to implement the BI solution as per the business needs
• Worked on Data modelling to incorporate new changes to the existing star schema
• Worked on the mapping sheet documents for the requirements
• Worked on creation of new metrics sales tax calculations based on state codes, membership benefits in RPD business layer.
• Worked on providing the visibility to metrics to logistics subject area by mapping them to the presentation layer
• Worked on creation of new reports and dashboards to provide visibility to business users in Logistics area
• Worked on Datastag code modifications to ETL to accommodate the new business metrics
• Development, Unit testing and Deployment of ETL changes and OBIEE reports.
• Trouble shooting and Warranty Support

Technical Environment: Reporting Tool - OBIEE 10.1.3.2 Database Oracle 10g, Teradata v12 Tools: SQL Developer ETL- Datastage 8.0 Scripting UNIX, PERL

Confidential

Project Description: Warehouse build and ETL implementation for Transportation

Role: Requirements gathering, warehouse build and ETL for Transportation related data extraction, transformation and load. This data helped in optimizing the Transportation operational costs for the business. Main tasks performed are mentioned below:

• Worked on requirements gathering for ETL implementation for Walmart transportation department
• Prepared High Level and Technical design documentation
• Prepared Functional design documentation
• Worked on creation of mapping documents
• Worked on complex requirement of loading data to 16 servers at once based on their availability and also ensuring that the data is synced up across the servers
• Worked on Data modelling and Schema creation
• Worked on the mockup data insertion to the warehouse schema and generate mock up reports to the client to help them visualize their business needs
• Worked on ETL Development, Unit Testing and Deployment
• Worked extensively in trouble shooting and warranty support
• Worked in production support and maintenance post warranty support

Technical Environment: Database Informix Scripting UNIX Programming language JAVA, DOTNET

Confidential

Project Description: The project was known as 'Lane Network Utilities and Optimization'. As part of this program, Business needed ETL to load Logistics data to the Warehouse on which business reports are built which are used to optimize the network utilizations in Logistics area.

Role: As a sole ETL Analyst in the project, following tasks were carried out:

• Worked directly with the client in understanding the current Logistics architecture and the development of Datawarehouse and ETL for the business needs
• Prepared High Level and Technical Design documentation
• Prepared mapping documents between source and target systems
• Prepared SQL queries/stored procedures for source data extraction
• Single handedly worked on Design and development of ETL via Datastage for the project
• Worked throughout the project life cycle from Analysis to Support post deployment
• Worked on the implementation of very complex business rules and transformations on data which involved more than 60 business transformations in a dynamic fashion
• Successfully implemented the ETL solution for the client which eventually provided in depth visibility to the Lanes and Networks areas in their Logistics department. This data is used extensively by the business users in optimizing the Lanes and networks for the carriers effectively reducing the operational costs to the client
• Worked on setting up schedules for the ETL to do incremental data loads to the warehouse.
• Worked on collaborating with other teams in the project to integrate ETL data with JAVA and DotNet web applications which are used to provide operational reporting to business.

Technical Environment: Database Informix Programming languages JAVA,DOTNET ETL Datastage 8.1 Scripting UNIX

Confidential

Project Description: ETL and OBIEE Implementation for Business reporting

Role: As an ETL/OBIEE Senior Software Developer the following tasks were performed.

• Worked as a lead for a team of 5 in the ETL implementation involving design, development, testing and deployment.
• Worked in the entire life cycle of the project starting from Analysis to Deployment and Warranty support for ETL and BI implementations
• Worked on Data modelling for creating warehouse for Sams Dotcom operations
• Prepared high level and technical design documentation
• Prepared source to target mapping documents
• Worked on design, development and testing of ETL via datastage.
• Worked on various complex ETL development
• Worked on preparing optimized SQL queries for source extracts
• Worked on scheduling the ETL jobs to perform daily incremental data loads to the warehouse
• Extensively worked on the initial data validations to provide accurate data to the client as this is the first implementation of ETL and reporting for the client
• Worked on Test Case documentation
• Worked on the history data loads to the data warehouse using complex mapping to provide visibility to previous years' data for business comparisons for sales, returns, refunds etc
• Worked on physical layer of RPD in creating the Physical schema
• Worked on creation of business model
• Worked on creation of various business metrics
• Worked on creation of dimension hierarchies to provide report drill down functionality to business users
• Worked on creation of various subject areas in presentation layer for Finance, Tax, Logistics, Merchandise and operations
• Worked on the creation of reports and dashboards for the business users providing business critical information
• Worked on setting up of automated report delivery for critical business reports which included sales reports, club managers' performance reports by department etc
• Worked on preparing help documentation for business users which enabled users to use BI for their reporting needs with ease
• Conducted various training sessions to the team on technical and functional aspects of the project
• Conducted knowledge transfer sessions to hand over the project to the support team and also provided documentation for trouble shooting
• Worked on trouble shooting documentation which served as a reference to the new resources to the project to resolve common issues encountered during support and maintenance phase with ease. Documented all the issues encountered during various phases of the project with resolution details.

Technical Environment: Database Oracle 10g, Teradata ETL Datastage 8.0 Scripting UNIX

Confidential

Project Description: This project was started to enable operational reporting on various metrics in various areas

Role: As an ETL developer, the following key tasks were implemented

• Worked on ETL Datastage development, design and unit testing.
• Prepared source to target mapping documents
• Prepared high level and technical design documents
• Prepared test case documents
• Worked on preparing optimized SQL queries for source data extraction
• Worked on the development of Sequences, ETL Datastage jobs to implement various business requirements by loading data to the tables.
• Worked extensively on performance optimizations of daily ETL loads reducing the overall run time by hours
• Worked on the development of aggregate table loads
• Worked on the scheduling and monitoring of daily incremental data loads
• Worked on data validations to provide accurate data to the client
• Worked in Production Go Live and Support and Maintenance after go live.

Technical Environment: Database Oracle 10g ETL Datastage

Confidential

Project Description: This project was started to enable operational reporting on various metrics in various areas

Role: As an ETL developer, the following key tasks were implemented

• Worked on ETL Datastage development, design and unit testing.
• Prepared source to target mapping documents
• Prepared High level and technical design documents
• Optimized the performance of daily ETL loads
• Developed aggregate table loads via ETL
• Worked on complex ETL developments involving aggregate table loads and incremental data loads
• Worked on scheduling and monitoring of daily incremental data loads
• Worked on extensive data validations to ensure high accuracy of business data for reporting
• Production Go Live
• Support and Maintenance after go live.

Technical Environment: Database Oracle 10g, Netezza ETL Datastage

Confidential

Project Description: This was an in-house project developed using HTML, JAVA and PL/SQL

Role: As a JAVA/PL/SQL developer, the following key tasks were implemented

• Worked on development, design and unit testing the JAVA application.
• Prepared High level and technical design documents
• Worked on creating application front end screens using HTML, CSS and JAVASCRIPT
• Worked on creating JSP pages for the application
• Worked on creating Store procedures, triggers for the backend processing of data on Oracle
• Worked on Deployment to test environment and end to end validation

Technical Environment: Database Oracle 10g, JAVA, HTML, CSS, JAVASCRIPT, PL/SQL