SUMMARY

• Over 15+ Years of diversified experience in Software Development, Design, Analysis, Testing and Implementation of Projects.
• 14+ Years of very strong experience in Business Intelligence Platform.
• Extensive experience in Business Objects 4.0/XI R3.1/XIR2 as a Team Lead/ Senior BOBJ Architect and as a Senior Business Objects Administrator .
• Hands on experience in SAP BOBJ Architecture proposing system landscapes and providing complete BI Solution and deploying common framework for all the reporting needs.
• Experience in Adobe Site Catalyst Analytics and B2Bi Architecture implementation.
• Good experience in Full Life Cycle Projects implementing the SDLC Methodologies and preparing SLA's for the projects.
• Hands on experience in developing SAP Business Objects Universes like SAP BO 4.0 IDT and migrating them from Development to higher environments.
• Strong experience in SAP BW 7.3, SAP BW Accelerator, SAP HANA.
• Experience in Business Intelligence Reporting tools like Desktop Intelligence, Web Intelligence, Bex Reports, Crystal Reports XI.
• Conducted Workshops and submitted Whitepapers regarding the best practices in development and design of BO reports and universes and identifying the right BI Tools for the client.
• Migrated Business Objects Reports, Universes and BI content from the prior versions of Business Objects to BO XI R3.1/ BO XIR2.
• Developed various Dashboards like Speedometer, Scorecards, Charts and Time Graphs using BOBJ Xcelsius.
• Strong experience in Oracle 11g/10g, SQL Server, IBM DB2, and PL/SQL.
• Strong analytical and communication skills coupled with very positive user interaction as a Tech Team Lead and a solid team player.

TECHNICAL SKILLS

BI Tools: BOBJ 4.0/ BOXIR 3.1 /BO XIR2, WEBI Reports, Crystal Reports XI, Xcelsius 3.0/2008, Cognos, Bex Reports, SAP BW 7.3, SAP Accelerator, Adobe Site Catalyst, Analytics.

ETL Tools: Informatica Power Center/Power Mart 5.1, BOBJ Data Integrator

RDBMS: Oracle 11g/10g, IBM DB2, MS Access, SQL Server 2005, Informix

CASE Tools: Erwin, MS Visio, Toad, ClearQuest, Remedy, Apache Tomcat, CVS.

Languages: HTML, Java script, Asp, Java, Cold Fusion, PowerBuilder

Operating Systems: Windows 2003/XP, UNIX, MVS/ESA Mainframes

Application Software: MS Office 2000, MS Visio 2000, Excel

Technologies: Data Mining and Data Warehousing and Business Intelligence Tools

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Senior SAP BI Architect

Responsibilities:

• Responsible for developing functional and design document prior to development of Business Objects Reports.
• Working with the Database group in the development of a Schema design and the ETL processes for the FHWA project.
• Developing the FMIS application in SAP Business Objects using Information Design Tool, Web Intelligence, BW 7.3 and HANA.
• Leading the current BI Team and providing technical expertise and white paper presentations related to the scope of the project for the DOT officials.
• Very good knowledge in various SDLC Processes like Waterfall, Spiral and Agile methodologies.
• Hands on experience working on completed Life Cycle Process starting from Initiation Stage to the Construction Phase and Implementation.
• Manage deployments of new code base or reports to production. Seek to continually improve the process via automation and repeatability.
• Created Dashboards and BO Adhoc Reports for the FHWA Business community and the DOT upper management.
• Hands on experience building data models for OLAP/OLTP applications and very good knowledge in data design concepts.

Environment: BOBJ XI 4.1, Crystal Reports, SQL Server, Oracle 11g, Web Intelligence, SAP HANA.

Confidential, Vienna, VA

Senior SAP BO Architect / Tech Lead

Responsibilities:

• Worked on the implementation of Back Office Analytics Project including Analysis, Design, Development and Configuration of the entire project.
• Responsible for implementation of the Back office Project from the scratch including Analysis, working with the business in getting the technical aspects of the project and implementing them in the form of design and development.
• Responsible for implementing the B2Bi Architecture transferring the data feeds from Adobe Data warehouse to NFCU internal site.
• Design and development of DESKI Reports and WEBI Reports and exporting them to the Repository and maintained in the Production environment.
• Very good experience in various SDLC Processes like Waterfall, Spiral and object oriented methodologies.
• Worked on the completed Life Cycle Projects starting from Initiation Stage to the Construction Phase and Implementation.
• Manage deployments and migration of reports and universes to integration and production.
• Responsible for providing technical expertise and lead junior engineers and train them with technical expertise as required.

Environment: BOBJ XI 4.1, Adobe Analytics, Cognos, SQL Server, DB2, Oracle, Bex Reports, Hana, Dimension, HP Service Manager.

Confidential, Herndon VA

Senior Business Objects Architect

Responsibilities:

• Capability to apply strong architectural skills in designing new reporting systems.
• Designed and developed DESKI Reports, Web Intelligence Reports, SAP BEX Reports and exported to the Repository and maintained in the Production environment.
• Designed the complete framework and architected the CLM model using the SAP Tools.
• Manage deployments of new code base or reports to production. Seek to continually improve the process via automation and repeatability.
• Created Dashboards like scorecards, speedometers and charts using Xcelsius for Remedy group.
• Responsible for providing technical expertise and lead junior engineers and train them with tech technical expertise as required.
• Extensive experience in developing Universes using Information Design Tool(SAP IDT 4.0) and migration.
• Extensively handled multi - tasking and provided expertise for multiple related efforts across concurrent project tasks.
• Worked on the complete Life Cycle Project for CLM Project in defining the SDLC Process and writing SLA's for this project.

Environment: BOBJ XI 4.0/BOXI R3.1/XIR 2, WEBI, Oracle 11g/10g, SAP BW 7.3, SAP Accelerator, SAP BEX Reports, Xcelsius, Remedy, CVS, Clear Quest.

Confidential, Washington DC

Senior Business Objects Architect

Responsibilities:

• Assessment of Security Model for the existing Business Objects Model.
• Presentation of Security Access Document after clear Analysis and implementation.
• Requirement gathering, converting the requirements into documents and presenting it to the client for approval and engineered activities associated with designing, coding, integrating and testing pilots.
• Responsible for the maintenance of production release, troubleshooting and correcting production problems as and when needed.
• Development of Business Objects Reports based on approved templates and requirement from the client.
• Implemented the EO/EP Group Hierarchy Security and applied row level data restrictions on the Universe for the IRS BO users.
• Worked with business users to gather and finalize requirements for EO and EP reports.
• Worked on migration of reports/ universes across the environments.
• Addressed defects and change requests using Clear Quest and maintained version control using Clear Case.

Environment: Business Objects XIR3.1, Web Intelligence XIR3.1, OracleSqlServer, Xcelsius, Web sphere, Rational Tools.

Confidential, Washington DC

Team Lead / Senior Business Administrator

Responsibilities:

• Responsible for leading a Team and providing the Technical expertise to the users of the program areas in terms of Development, Design, Migration and support.
• Involved in the complete migration of Business Objects 6.5 to BOXIR2 and also in clustering the Production, Dev and Test servers.
• Managed a Team of 7 SME's and implemented the BOBJ Excellence Project successfully starting from Analysis, Testing and Implementation.
• Defined, Documented and Implemented Business Objects Center of Excellence.
• Provided extensive training, mentoring to the Team and coordinated with their technical needs for the successful completion of the assignments
• Responsible for providing the complete security assessment for BOXIR2 center of excellence project.
• Worked on the implementation of BO XI 3.1 in the current environment and as part of test phase creating canned reports and universes in Test environment.
• Provided 24/7 Production support for the users under various programs nationwide which comes under ESA/DOL.
• Created Dashboards, Scorecards and Wage Hour Analysis calculator for the Wage Hour program using Xcelsius 2008.
• Demonstrated the ability to work as Tech Lead and Senior Architect.
• Worked independently and as part of the team and took care of the all the technical needs of the project.
• Organized weekly Status meetings and provided status to the Management about the progress of the Project and important updates.

Environment: Business Objects XIR3.1/XI R2, Web Intelligence XIR2/6.5, DB2, Web Sphere, BO Dashboard Manager, XCelsius 2008, Toad, Clearquest, Netcool, Heat System.

Confidential, Washington DC

Senior Business Objects Architect

Responsibilities:

• Responsible for creating User Groups and users for various Groups inside the Agency.
• Installed Business Objects XI in Development, Test and Production Servers.
• Configured Central Management Server and set the access rights and granted Privileges on Central Management Console.
• Clustered the CMS Repository on Test and Pre - Production Servers so that both share the same Repository.
• Created Canned Reports using Desktop Intelligence, for various Departments inside the Mayor s office and published them to various groups inside.
• Migrated Business Objects 6.5 to Business Objects Release 2 and imported all the Reports, and Universes.
• Trained users in Business Objects, and made sure they can access various components in Business Objects and create Ad-hoc Reports.
• Created Dashboards for Dcstat, which gave detailed information to the users about the Crime Rate and statistics in DC.
• Made lot of Presentations in Business Objects and other Technical aspects to the user Community and to the Officials in various Departments inside the Agency.

Environment: Business Objects XI R2, Crystal Reports XI, Xcelsius, Web sphere, Performance Manager, Visio, WebI, Oracle 9i.

Confidential, Maryland

Senior Business Objects Developer

Responsibilities:

• Designed a new Universe for DARRTS System with 145 tables, which give information about clinical investigation and market submission for human drugs and therapeutics biologics.
• Created 16 Canned Reports to support the DARRTS system like, Application for a specified Drug Report, PDUFA Procedure Report, Ind s Goal Report.
• Used to interact with FDA Project Managers and Business Analysts to get a detailed Requirement for the Universe and Reports.
• Presented a Universe Design Document and Report Requirements Document, which gives very detailed information about the Universe, and Reports.
• Created complex reports by linking data from multiple sources, using different functionalities that included using combined queries, master detail and cross tabs
• Used various functions Like User Response Functions, @ prompt and @ variable functions

Environment: Business Objects 6.5 (Designer, Reporter, Info view) Visio Professional, Crystal Reports, WebI 6.5 and Oracle 9i.

Confidential, Herndon, Virginia

Senior Programmer Analyst

Responsibilities:

• Analyzed the existing system and presented a Detailed Analysis Document to combine the all 5 systems into a Master Universe.
• Created a detailed Design with SDM standard in merging all the Universes into one Universe to provide a uniform Data warehouse environment.
• Worked on a module namely Perform which is built on Informix Database.
• Re engineered all the Informix code to Oracle Database creating DDL Statements from Informix to Oracle Database.
• Used Erwin and Visio Professional to create Entity Relationship Diagrams for all the modules in EDW like Perform, Cell track, TBS.
• Written Stored Procedures, Triggers and functions.
• Responsible for supervisor activities of Business Objects Supervisor module such as creating users, user groups and categories, granting, revoking access to resources, customizing settings using the command restriction box.

Environment: Business Objects 6.1/5.1.7 (Designer, Reporter, Info view, Supervisor), Erwin, Visio Professional, Data stage, Informix, Webi 2.6, Windows XP, Oracle 9i

Confidential, Maryland

Business Objects Developer

Responsibilities:

• Gathering requirements and writing specifications for generation of Business Objects reports.
• Extensive experience in Building and Designing Universes using Universe Designer.
• Used alerter, filters, sorts and rankings in the reports.
• Used multiple data providers such as universes and personal data files in generating reports.
• Scheduling of reports using Broadcast Agent (BCA).
• Analyzed Data by working in slice and dice Mode, drill Mode, using hierarchies and also formatting reports.

Environment: Business Objects 6.1/5.1.3 (Designer, Reporter, Info view, Supervisor), Webi 2.6, Windows 2000, IIS 4.0, Power builder, Oracle 9i

Confidential

Programmer Analyst

Responsibilities:

• Generated attributes and relations of sourcebooks using Expediter.
• Identified the Date fields by normal naming conventions and PIC clauses.
• Prepared unit test modules for the year 2000 compliance and ensuring accuracy of modification.

Environment: S390, MVS/ESA, VS COBOL II, CICS, JCL, VSAM, DB2