Summary:

• 9 years of experience in Business Intelligence - developing complex reports using Business Objects (5.x, 6.x, XIR2, XIR3), designing universes with Business Objects Designer and supervision of users using CMC. Experience in Universe design including Star Schema and Snowflake.
• Over 7 years of experience in providing production support.
• Over 4 years of experience as an ETL developer using Informatica (8.x,7.x, 6.x), designing and developing jobs using the Mapping Designer, Workflow Designer and Workflow Monitor modules. Experience in SQL query optimization.
• Performed various roles, like Software Engineer, Module lead, Team Lead, Onsite Coordinator, Business Analyst and Technical Architect
• Strong background in Data Warehousing, Software Development, Change Management and Scheduling.
• Experience in writing system specifications, translating Business User requirements to technical specifications.
• Excellent interpersonal / communication skills and thoroughly conversant with software development project life cycle (analysis, design, development, testing and deployment), estimation and documentation.
• Good aptitude for problem solving and logical analysis.
• Excellent team player. Experience in executing turn-key projects comprising of over 16 team members.
• Strong industry experience in both development and maintenance projects as an onshore technical lead and working with teams at offshore.
• Industry IT experience in Retail and Utilities in major turn-key projects.
• Experience in creating KPI dashboards for the projects.

Professional Experience:

• Confidential, December 2003 – Oct 2011

• Confidential, Oct 2011 – Till Date

Certification: Business Objects Certified Professional

Project Summary:

Confidential, HBO(Dec 2011 – Current)
New York City, NY
Senior BO Developer (Team Size: 7 members)Confidential is being designed to rewrite existing systems as well to introduce new technologies to improve performance and convert Standard Definition (SD) products to High Definition (HD) wherever possible. This project also helps in retiring legacy systems.

Responsibilities:

• Developed and managed complex reports and universes for users from different groups.
• Directly responsible to manage and migrate 2000 plus business objects reports and universes using Version Manager.
• Developed and supported large number of Free Hand Sql Business Objects reports.
• Resolve all kind of issues that arise from Business Objects components including performance.
• Worked with JIRA to manage new enhancements and non-production requests/issues.
• Experience in Infoburst Business Objects reports scheduling system.
• Experience with Version Manager tool for tracking, updating and exporting all Business Objects components.
• knowledge in client specific applications like product, contract tracking, Linear and Non Linear Scheduling as well as right management systems that helped in resolving production issues as well as delivering enhancements to the existing reports and universes.
• Experience with Infolytik MetaMiner for performing auditing as well as Universe and Reports Impact Analysis.
• Worked with users directly for UAT as well as production issues.
• Performed SQL tuning for all the Free Hand Sql reports.

Environment: 
Business Objects XI R3, Infolytik Metaminer, Oracle 10g/11g, SQL, HEAT ticket tracing system, TOAD, Version Manager, VDI and Infoburst and JIRA

Confidential, PepsiCo(Jan 2010 – Dec 2011)
Valhalla, NY
Onsite lead/Coordinator (Team Size: 8 members)

Confidential is primarily into the Fountain Pepsi products business. Food service reporting baseline comprises of more than six reporting applications like Sales and Invoice processing system, Enterprise promotional manager system, Trade contract Management system, Upfront payment module etc. All these reporting applications have been developed with the help of Business objects and Informatica. Entire baseline project has more than 250 Business Objects reports. Business users of these applications are provided with added functionalities such as: Interactive reporting, ad-hoc reporting, download to excel, etc.
Responsibilities:

• Expertise in working with monthly code release as well as emergency migrations.
• Developed and managed complex reports for users and business managers based on the level of details needed.
• Reviewed end to end code and documents sent from offshore and logging into logs and trackers.
• Responsible for requirements gathering from Business and passing it on to offshore to start the development.
• Logging/updating all kind of change requirements on StarTeam and keep track of the change requests involved in releases.
• Business prioritization meetings and customers status meetings every week
• Coordinated with Business Intelligence team for all kind of migration activities like database/Business objects/Informatica changes.
• Worked with the client managers and other business users / analysts to understand the current business process.
• Assigned tasks to team members, provided day-to-day technical direction, and managed assigned work deliverables to defined target dates and assure quality, documented and production ready work deliverables.
• Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
• Provided production implementation support and provided infrastructure recommendations.
• Actively participated in end to end Integration and Functional system testing between multiple application teams.
• Informatica and Business Objects job monitoring every day.
• Experience in preparing project efforts and KPI dashboards for the managers.
• Also worked with BOXIR3 reports and actively participated in testing of XIR2 to XIR3 conversion.

Environment: 
Business Objects XI R2, XIR3, Informatica, Oracle 9i, SQL, PL/SQL, Quality Center, StarTeam, SM7.

Confidential , PepsiCo (May 2007 – Dec 2009)
Purchase, NY
Senior developer/Technical Architect (Team Size: 15 members)Confidential is the extension of STAR1 Reporting Project of PepsiCo . This project is one of the largest projects among PepsiCo where in the system gets huge amount of Invoice data from different Bottlers. This data is then loaded into Oracle and Teradata database tables using ETL tool called Informatica. Business Objects picks this data from database and presents it to users and business managers in the form of reports for the analysis.Responsibilities:

• Developed simple to complex Business Objects reports and universes following project life cycle model.
• Have maintained CMC and controlled user addition and permissions to the system.
• Co ordinated with Client’s Business Intelligence team for all kind of migration activities through StarTeam.
• Worked with the client managers and other business users / analysts to understand the current business process.
• Developed documentation for business requirements, estimations, transformation logic, process descriptions / flow charts, detailed design specification, test plan and implementation plan.
• Assigned tasks to team members, provided day-to-day technical direction, and managed assigned work deliverables to defined target dates and assure quality, documented and production ready work deliverables.
• Worked as the design lead and reviewed the technical competencies of work deliverables.
• Reviewed deliverables and ensured compliance with coding standards and source code version control
• Assisted in identifying current and future reporting requirements utilizing current successful strategies and developing business use cases.
• Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
• Provided production implementation support and provided infrastructure recommendations.
• Actively participated in Integration and Functional system testing for all end to end project releases.

Environment: 
Business Objects XI R2, Oracle 9i, SQL, PL/SQL, Teradata, Quality Center, StarTeam, Peregrine.

Confidential, PepsiCo (Sep 2006 - May 2007) 
Team Lead (Team Size: 16 members)Legacy Integration is a project of converting the data from Legacy systems to the forms that can be used by midware team to put it in SAP systems.Responsibilities:

• Developed documentation for business requirements, estimations, transformation logic, process descriptions / flow charts, detailed design specification, test plan and implementation plan.
• Assigned tasks to offshore ETL developers, provided day-to-day technical direction, and managed assigned work deliverables to defined target dates and assure quality, documented and production ready work deliverables.
• Worked as the design lead and reviewed the technical competencies of work deliverables.
• Wrote sub-queries, procedures and reusable code in Informatica.
• Reviewed deliverables and ensured compliance with coding standards, source code version control, build procedures and deployment procedures.
• Assisted in identifying current and future ETL requirements utilizing current successful strategies and developing business use cases.
• Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
• Developed Informatica Extract/Transform/Load jobs using STAR Schema and followed development standard into different projects.

Environment:
Informatica 8.5, Oracle 9i, SQL, PL/SQL, Quality Center, StarTeam and Peregrine.

Confidential, (Mar 2006 - Sep 2006)
Valhalla, NY
Onsite Coordinator (Team Size: 8 members)Confidential system provides PepsiCo sales information for analysis and improvement of sales to Wal*Mart. It is a Business Objects based reporting environment for National Accounts Sales Managers (NASM), Bottlers and the Category Managers.Responsibilities:

• Worked with the Financial Analysts and other business users to understand the business process and collect the requirements from them and document it.
• Developed documentation for business requirements, estimations, transformation logic, process descriptions / flow charts, detailed design specification, test plan, implementation plan, timelines for implementation and project plan.
• Managed all code migrations which involved frequent interactions with the PepsiCo infrastructure, Autosys, Control-M and database teams.
• Single point contact for the business team for all business intelligence requirements.
• Coordination on a daily basis with an offshore development team comprising of 6 members.
• Assigned tasks to offshore Business Objects developers and provided day-to-day technical direction, and managed assigned work deliverables to defined target dates and assure quality, documented and production ready work deliverables.
• Lead the design process and reviewed the technical competencies of work deliverables.
• Handled over 20 key business users on a day-to-day basis.
• Reviewed deliverables and ensured compliance with coding standards, source code version control, build procedures and deployment procedures.
• Assisted in identifying current and future reporting requirements utilizing current successful strategies and developing business use cases.
• Created and maintained BO Universe to model various Datamarts.
• Developed Business Objects reports mapping to the business requirements.
• Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
• Provided production support and provided infrastructure recommendations.
• Created and managed users in the Business Objects Supervisor making sure data is secure between user groups

Environment: 
Business Objects 5.1, 6.5, Oracle 9i, Control - M,PL/SQL, SQL*Plus, Peregrine.

Confidential (Oct 2005 - Mar 2006) 
Module Leader (Team Size: 15 members)Client company pays the bottler for the service done and in turn charges the customer for this service based on service contracts. In order to improve the customer satisfaction, client focuses on providing better service to their customers. Equipment Service Reporting is one of the several applications and reporting systems supporting the focus on customer service.Responsibilities:

• Identified project requirements in discussions with Business Users and onshore coordinator.
• Developed documentation for business requirements, transformation logic, process descriptions / flow charts, detailed design specification, test plan and implementation plan.
• Created complex reports using Business Objects Reporter module by creating complex grids, graphs and VB code.
• Completed test and validation of data from Business Objects reports against source system.
• Ensured compliance with coding standards, source code version control (Visual Source Safe)
• Participated in Functional and system testing of reports with Business team.
• Provided support in User Acceptance Testing from onshore.

Environment: 
Business Objects 6.5, Informatica 6.2, StarTeam, Oracle 9i, Toad 8.0.0.47, Microsoft Visual Source Safe.

Confidential (Dec 2003 - Sep 2005)
Project Engineer / Developer (Team Size: 10 members)Sales Invoicing & Processing System (SIPS) system processes the sales and ticket information for computing invoices and Bottler remittances.Responsibilities:

• Created the transformation document specifying the source and the target tables and also the logic that will be used in the transformation.
• Developed documentation for business requirements, transformation logic, process descriptions / flow charts, detailed design specification, test plan and implementation plan. Created Mappings using Informatica.
• Built Business Objects reports and completed test and validation of data against source system ensuring compliance with coding standards.

Environment: 
Business Objects 5.1.7, Informatica Power Mart 6.2, Oracle 9i, SQL, PL/SQL, Microsoft Visual Source Safe 6.0, UNIX Shell scripts, XSL, XML, Aventail, Oracle Warehouse Builder, BCA

Education: 
BE in Electronics and Communications from