SUMMARY

Over 12+ years of IT experience in application software analysis, design, development, implementation, maintenance, and documentation of various commercial applications in all phases of project life cycle. Has extensive industry experience in banking and finance, retail, manufacturing, utilities, IT and telecommunications.
Experience in full life-cycle data warehouse (DW) implementations which include solid experience with Business Objects Universe Designer, Report Writer, Xcelsius, User Mentoring and ETL scripting.
Experience in Designing/Developing the user-Interface, developing canned/Ad-hoc Reports and CMC Activities.
Conduct BO upgrade implementation and troubleshoot migration issues.
Experience with BW Reporting using Bex Analyzer, Bex Explorer, Web Application Designer,
Implementing Bex Queries, Calculated and Restricted Key Figures, Variables, Workbooks, Security Roles and Profiles.
Experience in designing interactive dashboards using Crystal Xcelsius 4.5/2008 and Live Office modules.
Experience in creating and managing Information Spaces using Business Objects Explorer for adhoc reporting solutions.
Over 4 years of experience in Data Extraction, Data Migration of Data Marts /Data Warehousing using design, ETL and OLAP Tools.
Experience in Analysis and Design of Logical and Physical Database Models by using ER win tool and good understanding of Dimensional Modeling Methodologies Star Schema and Snowflake Schema.
Experience in developing applications using Visual Basic and Java.
Knowledge in E-commerce and Web related tools like HTML, JavaScript, Applets, Servlets, Java Server Pages, EJB, RMI, CORBA, XML.
Knowledge of Cognos and SSRS reporting modules.
Knowledge of Unix shell scripting for job process automation, Visual Basic Applications (VBA).

PROFESSIONAL EXPERIENCE

Confidential, Camanche, IA May ‘11 Present
BO Lead
Responsibilities:
Participated in requirements gathering process and designing the data model for Rebate processing Project.
Installed Business Objects software on windows environment and created security for multiple clients.
Involved in integrating BO 4.0 with SharePoint portal.
Created universes and canned reports for rebate processing requirements.
Involved in creating Technical and training documents.
Environment: BOXI R3.1 / 4.0, Webi, Data Services ,BOExplorer/Polestar, Xcelsius 2008, SP 2010 and SQL Server 2008.

Confidential,Hoffman Estates, IL Mar ‘11 May’11
BO Consultant
Responsibilities:
Created universes and canned reports for Sales Reporting project.
Created information spaces in business object explorer to facilitate data exploration.
Worked on creating the OLAP universes sourced from Bex queries from SAP BW datasource.
Scheduled information spaces in business object explorer to index and refresh data overnight from universes.
Created dashboard using XCelsius 2008.
Created OLAP universes using SQL Server 2008 Database.
Involved in creating training documents.
Environment: BOXI 3.1, Webi, QAAWS, Xcelsius 2008, Business Objects Explorer/Polestar, SAP BI 7.0 and SQL Server 2008.

Confidential,Chicago, IL Sep ‘09 Dec ‘10
BO Lead
The main objective of the project is to provide Harley Davidson Financial Services team to address enhancements and correction of the current system defects as part of Dealink 1.1.6 release. As part of the engagement, I performed the following tasks.
Created universes for canned reporting needs for Dealink 1.2 and SKU Management projects.
Worked on creating and supporting the OLAP universes sourced from Bex queries in SAP for Connect project.
Created OLAP universe using MSAS on SQL Server Database for PGCR project.
Involved in BO6.5 to BOXI R3.1 migration process.
Involved in documenting the design documents for the project.
Environment: Business Objects BO 6.5 / BOXI R3.1, Webi, Data Services, Oracle 10g, SQL Server, SAP BI 7.0/BW.

Confidential,NY May ’08 July ‘09
BO Lead
The main objective of the project is to provide marketing monitoring team a means to analyze and track through the daily bids within the company. A new data mart is created for analyzing the mitigation, scheduling and supply processes of various Market participants / Bidders. The reporting phases of the project included the validation of the accuracy and completeness of the new Marketing Monitoring Database and generate reports based on daily views.
Created universes and reports for Market Monitoring Group.
As part of DSS team ongoing support duties, involved in creating user groups and security for MMP project including the configuration of customized WebPages.
Involved in documenting the design and use case documents for the project.
Environment: Business Objects XI R2/R3, Webi, Crystal Reports XI, Quality Center,OWB, Oracle 10g and Windows XP.

Confidential,IL June’07 Feb ‘08
Consultant
The reporting phase of the project included the validation of the accuracy and completeness of the new Marketing Database and generate reports based on monthly views.
Involved in creating Technical and training documents.
Involved in designing the data mart as monthly summary views to enable Analytical File creation and Reporting, for Times Series Analysis, Customer Profile Reports, Private Brand Reporting, Marketing Reporting, etc.
Created universe for canned and Adhoc reporting needs.
As a general supervisor/Admin involved in creation of new BO Repository in Oracle.
Involved in managing the user profiles based on WWG security standards.
Environment: Business Objects XI R2, Web Intelligence (Reporter, Info View), SAP BW, Oracle 9i, TOAD

Confidential,Chicago, IL Sep’06 June ‘07
Reporting Architect
The Objective of Risk Reporting project is to build an Enterprise Data warehouse for various patterns to produce the accurate metrics information for all material business units of the Northern Trust Company, including international units. The reported data will cover all operational risks, including compliance, fiduciary, operating, and transaction risks. New Business objects universes are designed in order to support the Daily/Quarterly loss details for both Dashboard and Adhoc reporting. Reporting families are organized based on the detailed drill through analysis and contains a standard set of reports on the web required to perform said analysis.
Participated in requirements gathering and designing the data model for Operational Risk Reporting Project.
Involved in tool evaluation (BOXI vs. Cognos and Xcelsius vs. Dashboard Manager) process to provide reporting solution for the project.
Designed universes and reports for Operational Risk Project.
Involved in redesigning the old Cognos reports to BO web reports.
Involved in creating crystal reports for Product Risk Group.
Involved in documenting the design, Use case and knowledge transfer documents for the project.
Environment: Business Objects XI R2, Webi, Crystal Reports XI, Xcelsius , Cognos Oracle 10g DW, Oracle Warehouse Builder10.2,

Confidential,Lexington, KY Apr ’06 Sep’06
Sr BO Consultant
Lexconnect Project is developed for the marketing team to increase product, supplies positioning, Loyalty and profitable customers. The systems automates the process of gathering product usage and survey information and enable a robust, standardized query solution for Printer usage, cartridge use, and demographics as a part of enterprise data warehouse reporting solution.
Participated in requirements gathering and designing the data model for Lexconnect Project.
Designed universe and created reports for Lexconnect and CDR projects.
Involved in creating and testing ETL jobs using Data Stage tool.
Involved in documenting the design and knowledge transfer documents
Environment: Business Objects XI R2, Webi, Crystal Reports 10/XI, Oracle 9i DW, Data Stage 6.0.1, TOAD, Windows XP.

Confidential,IL Sep ’05 Feb’06
Sr BO Consultant
The main objective of the project is to provide marketing team means to track through the details for the Learning Management System (LMS). The reporting phase of the project included generating reports based on the data mart used for analyzing the Course information for various departments.
Created universe and reports for Learning Management System project.
Coordinated with business and generated canned reports.
Involved in fixing the production issues.
Used Import Wizard Tool and Conversion Tool to convert full client reports to webi reports.
Involved in documenting the design and knowledge transfer documents.
Environment: Business Objects 6.5/Xi, Web Intelligence (Reporter, Info View), Quality Center, Oracle 9i DW, TOAD, Windows 2k.

Confidential, WA Mar’05 Aug ‘05
Sr BO Consultant
The reporting phase of the project included generating reports based on the True Comp data mart used for calculating commissions at Cingular. Callidus True Comp manager is an application package developed to calculate the commissions in various Billing systems.
Involved in designing the data mart and modify the mappings to add attributes based upon True Comp repository.
Created universe for Commissions project.
Generated reports for calculating Measurements, Incentives, Deposits and Payments for various participants.
Coordinated with business and generated canned reports for calculating the credits.
Environment: Business Objects 5.1.6/6.5,Webi, Callidus True Comp, Oracle 9i DW, TOAD, Windows XP.

Confidential,Dulles, VA May‘04 Feb’05
BO Consultant
The main objective of the projects was to provide marketing team means to track new registrations, sales and ala carte purchases of music and games through third party vendors. The primary focus was to create adhoc universes and reports, which in turn were published to Infoview for broader range of users. Goal of marketing analysis projects was to provide and enterprise performance reporting developed as per requirement.
Analyzed the specifications and involved in designing the dimensional data models for AOL Optimized Program, Wholesale Infrastructure and Partner Interface, Digital Media Platform, On Ramp Re- Arch projects.
Prepared the system design documents for WIPIT, AOP, DMP and MA projects based on BO best practices.
Designed universes and reports for WIPIT, AOP, DMP and Marketing Analysis projects.
Created Dash Boards using Application Foundation and made the environment an End User friendly interface.
Involved in interacting with users by training them on Universes and generating reports.
Fixed the production issues for AOP universe and reports.
Environment: Business Objects 6.1b/X1, Webi, Application Foundation 2.5/3.0.1, AbInitio (GDE 1.13.1), Netezza 2.1, RedBrick6.2, Sybase 12.5, SQL Server, Win SQL 4.5.31, Oracle 9i.

Confidential,Minneapolis, MN Oct’03 Apr’ 04
BO Consultant
Wells Fargo\'s SMART project entails developing the campaign management approach to ensure strategically aligned customer contact with the right messages and products, to the right customers, at the right opportunity. DAR a sub-project effort covers the data and reporting requirements for the other sub-projects as well as the development of a "Customer Mart" - the central repository for the customer insight / data required. Lastly, the reporting tools, capabilities, and packaging needed for end-users to ultimately access these insights is included.
Involved in analyzing and designing the data mart for SMART project.
Modified the universe design based upon the requirements from Business teams for various projects.
Involved in upgrading the Business Objects v6.1 (b).
As a general supervisor/Admin Involved in managing the user profiles based on WFSC security standards.
Involved in up gradation process of webi 2.7.2 to 2.7.3.
Involved in testing the Business Objects reports v5.1.3 and v5.1.5 reports on BO v6.0 against Sybase repository.
Responsible for Creating Complex reports (Sub Reports, Drill-down, dynamic grouping, Master/Detail, Cross-Tab, graphical, aging reports etc)
Worked on building metrics using Application Foundation and dashboard manager.
Involved in fixing the performance issues on production box for ongoing support issues.
Environment: Oracle 9i, IBM DB2 v8.1, Sybase v12.5, Business Objects 5.1.3/5.1.8/6.1 (b), Webi, Full client, Data Integrator, Oracle ERP, Crystal Reports, Application Foundation, Info view, BCA, Remedy Pac, UNIX (Solaris) AIX, Windows 95/2k

Confidential, Chicago, IL June’02- Aug’ 03
BO Consultant
The EPS (Exelon Performance Solution) Program is designed to provide a single common financial system replacing multiple legacy systems currently in place. EPS will provide a common platform to generate core financials, simplify performance management reporting, and improve finance processes. The ComEd PI Reporting application has been developed to design the detailed reports associated with each performance indicator using Business objects. The system also incorporates the booklet creation process using Java to bind individual PI reports into one PDF booklet.
Analyzed the specifications and designed the data model based on the existing relational model for ComEd adhoc reporting.
Designed Universe for Adhoc reporting with Classes, Objects and Condition objects for ComEd users.
Modified the existing relational data model and the relevant universe for implementing the Tier 2&3 enhancements in ComEd PI reporting.
Designed and developed various mappings in Mapping designer and sessions and workflows in Workflow manager.
Worked with Filter, Aggregator, Expression, Lookup, Update Strategy transformations.
Involved in coordinating, Bug tracking/fixing, testing, performance tuning and migration of the production defects as a team member of the ongoing support team.
As a general supervisor involved in migration of reports and the Universes into different environments Viz. Development, test and Production. Handled different modules on the administrative side of business objects.
Involved in setting up the environment for migrating the linked Universes and Documents into different environments using Noad Quality Manager.
Involved in customization and portal enhancements using webi SDK and JSP.
Involved in documenting the designing and Knowledge transfer documents.
Environment: Business Objects 5.1.3, Broadcast Agent, Web Intelligence 2.6.3/2.7.2, webi SDK, PeopleSoft EPM, Informatica 6.2.1 ,Crystal Reports 7, Oracle 8.1, TOAD, Test director, JSP, Web Sphere Studio, UNIX (Sun Solaris).

Confidential,Richmond, VA Mar ’01 - May ‘02
Data Warehouse Developer
The system is primarily data driven and Import and Export technologies are incorporated into the application. The data input was from the client and is connected to the client systems through a FTP site. This raw data exported by the client is processed for system and inventory analysis. The system is also designed and developed to manage and supervise individual aspects of assets including purchase and sale of assets, depreciation and investment management.
Used Informatica designer to create complex mappings using different transformations to move data to a data warehouse.
A data warehouse is being developed to provide enhanced reporting capability for global customer core data.
Involved in Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
Worked with aggregator, expression, filter, joiner, lookup, sequences Generator were implemented to load data from ODS to data warehouse.
Designed reports using Business Objects Full Client.
Customized Web Intelligence front page by using webi SDK and JSP.
Environment: Windows NT 4.0, Oracle, Business Objects 5.1.2, Webi, Full client, Informatica Power Mart (Designer, Server Manager, Repository Manager) Web Intelligence 2.6, Info View, Broad Cast Agent, webi SDK, JSP, IIS 4.0,UNIX (Sun Solaris).

EDUCATION / TRAINING

Completed BS in Electrical and Electronics Engineering.
Microsoft Certified Professional in Visual Basic
Business Objects Advanced Training -
Underwent training in SAP BI/BW -
Underwent training in SAP BPC (Business Objects Planning and Consolidation) module

SKILLS (Software/Technical):

Data Bases : Oracle, MS SQL Server, MS Access, DB2, Teradata, Sybase, Red Brick 6.x,
Netezza 2.1 and SAP BI/BW 3.5/7.0.
Reporting Tools : BO 5.x/6.x/ X1 3.1/4.0, BO Explorer, Xcelsius4.5/2008, CrystalReports9/10/XI Live Office and QM2.1, Cognos
ETL Tools : Informatica-Power Mart 4.5 / 5.1.1, 5.1.2, 6.0, Power Center1.6/ 5.1.1
AbInitio 2.10, Data Stage, Callidus True Comp, Oracle warehouse Builder.
DBA Tools : Export/Import, SQL*DBA, Server Manager, SQL*Loader, Oracle DBAstudio
Languages :SQL, PL/SQL, C++.Java, .Net, Shell scripting, Visual Basic
OS : Solaris, AIX, Windows 95/98/2000/NT/XP/7, Solaris and Linux
Data Modeling Tools : Erwin 3.5/4.0, Oracle Designer 2000
Internet Tools : HTML, DHTML, JavaScript, VBScript, JSP, Servlets, Applets and XML