SUMMARY:

• 17 years overall IT experience with 13 years SAP, 4+ years on Federal projects.
• 6+ Years experience in BO XI Release 4.1/4.0/3.1 Designing Universes, Developing WEBI, Crystal Reports, and dash boards with Xcelsius, Design Studio, Analysis, SAP BI BO Integration.
• 3 Hands on Experience on HANA Modeling with SLT replication on SAP R3 tables.
• 4+ Yrs in SAP BI Bo Integration and Business Objects Suite of applications, including Bex Query development with BEx Query Designer/Bex Analyzer tools.
• 5+ yrs in data modeling, ETLs. Extensively worked on Data Extraction, Transformation, and Loading (ETL) tools with Flat files. Full lifecycle project implementations with BO Data Services and BO Universe Designer components.
• Exceptional background in analysis, design, development, customization, and implementation and testing of applications and products.
• 4 years of Client/Server and Web Technologies using C/C++, Java/JDK 1.4, J2EE, EJB, JDBC, PL - SQL, SQL, XML, WSDL, SQL Server and Java Web Services.
• Hands on Experience on HANA Modeling with SLT replication on SAP R3 tables.
• Team player with excellent communication and problem solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Tx

Business Objects Consultant

Responsibilities:

• Responsibility: Create Universes and design, Analyze the Business Requirements develop Webi reports on the HD Financial Services ODS
• Create a test plan for the reports.

Confidential

LMP Business Analyst

Responsibilities:

• Created EDW reports for depot management in HR, Project Systems and Inventory. Reports to analyze direct/indirect labor hours, manpower analysis, leave exceptions and depot inventory value.
• Create Webi reports/ Crystal reports based on the Bex Queries.
• Established the best modeling and recommended strategies for BOBJ environment and architecture forSAP HANA.
• Created Technical specifications and standard modeling documents for HANA.
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the restricted and calculation views as final model in HANA Studio.
• Developed data models for theoperations, creating and using hierarchies, CE functions, variables, SQL scripts and procedures.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Gathered and analyzed the requirement to replicate data in HANA usingdata provisioning.
• Migrated HANA content from development, testing environment to Production environment using delivery units

Confidential, Farmers Branch, TX

SAP BI/BO Consultant

Responsibilities:

• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• BOBJ 4.xandBODS 4.0and configured SAP and Windows AD authentication for Business objects enterprise.Create multi source universes.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities.
• Creating materialized views and stored procedures in PL/SQL programs on Oracle database.
• Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMCon Daily, Monthly, Weekly basis. POC Tableau data analytics leveraging Grouping, Sorting, Drill Down and hierarchies, filters, Calculations and Chart features.Business Objects integration with MS. Sharepoint

Environment: SAP Business Objects XI 4.x, Webi 4.1, IDT (Information Design Tool), CMC, Dashboard Designer, Oracle 10g, HANA 1.0 SP6, BODS4.0, MS Sharepoint

Confidential, Amarillo, TX

SAP BI/BO Consultant

Responsibilities:

• Created Universes on top ofHANA calculation viewsand developed the Webi reports usingIDTAnalyzing system functionality requirements, documents and scope of the work and fix the data changes and requirement modifications in Crystal Reports. Developed Dashboard for IE engineers to serve the purpose of board data in the BO portal, Create/Modify WEBI reports, BOBJ reporting from multiple data sources for the IE engineers.Expert in generatingSub Reports, Standard, Mailing Labels, Cross Tab ReportsandGraph Reportsby usingChart expertof Crystal Reports. Create BO reports using BICS connection on BEx Queries.Expert in creating variousPL/SQL stored procedures, views, functionsand temporary tables for data input to the Crystal Reports

Environment: SAP Business Objects 4.0, Crystal Reports, Webi, IDT(Information Design Tool), Design Studio, Analysis editions for OLAP and Office, and Lumira, SAP HANA 1.0, SAP BI7.3

Confidential, Rockwall, TX

SAP BOBJ Principal Consultant

Responsibilities:

• Responsibility: Create Universes and design, develop Webi reports on the Project systems, HR and BPC modules in the EDW,Created Project Systems, HR and BPC Universes.Analyzing system functionality requirements, documents and scope of the work. Work included Developing, Testing and enhancing existing Business Objects Universes; work required modifying, testing and promoting to the Repository, Alerters and Formulas etc using Web intelligence.Create Stored procedures in MS SQL server for checking data.Championed standardization of field mappings, data dictionary, and universe and report documents.Designed, created, implemented, and tested dataflows, workflows, scripts, and jobs.

Environment: SAP Business Objects XI 3.1, Crystal Reports, Webi, Universe Designer, SQL Server, BODS / (BODI) 3.2

Confidential

Professional Services Consultant4

Responsibilities:

• Assist P&G staff and system integration partners in deploying Business Objects (“BOBJ”) accessing data from Teradata.As Semantic Layer Consultant work with P&G and SI Business Analysts to determine use cases and usage patterns of data access from the BOBJ Universe(s)

Environment: SAP Business Objects XI 3.1, Crystal Reports, Webi, Universe Designer.

Confidential, Michigan

Consultant

Responsibilities:

• The DLA (Defense Logistics Agency) is the Department of Defense's largest logistics combat support agency, providing a variety of logistics, acquisition and technical services. The Agency sources and provides the consumable items America's military forces need to operate from food, fuel and energy, to uniforms, medical supplies, and construction and barrier equipment. DLA also supplies military's spare parts. In addition, the Agency manages the reutilization of military equipment, provides catalogs and other logistics information products, and offers document automation and production services.
• Gather user requirements and identify universe scope. Universe designing, developing and generating complex reports, Crystal Reports-xi to create reports and publishing them to users.Create Webi Reports for the MIDAS, DAISY legacy systems, Creating complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.Designed and developed queries to generate reports in BEx Analyzer.

Environment: SAP Business Objects XI 3.1, Crystal Reports, Webi, Qaaws, SAP BI7.0, Xcelsius, SAP BW7.0, Bex QD/QA,ABAP, SAP FI/CO, SD/MM

Confidential, Irving, TX

Consultant

Responsibilities:

• TXU is decommissioned project requires several reports on their legacy systems LCIS, ATLAS and Cordaptix. These applications are no more active and users occasionally go to these to verify the history of records. These applications were replaced with Crystal Reports, where users will schedule to see the reports like Bill History, Financial History, Address and Name search, Search by SSN or DL to find the customer details.
• Gather user requirements and develop the reports based on the requirement.Universe designing, developing and generating complex, dashboard Reports.Extensively worked with Crystal Reports to create reports and publishing them to users.Create User Roles/ Privileges in BOBJ. Schedule the Reports and publish them to the end users.Create Webi Reports for the legacy systems.

Environment: SAP Business Objects XI 3.1, Crystal Reports-2008, Webi, Xcelsius 2008, Microsoft Live Office, Qaaws, SAP BI7.0, Bex QD/QA, WAD

Confidential, Dallas, TX

Technical Analyst

Responsibilities:

• Sales Analytic applications are to optimize sales and to provide the competitive edge a company needs to survive and prosper.
• Create Monthly Sales Dashboard.Create Crystal Reports for Sales by multiple dimensions - Under-performing sales reps, Ship Centers, products, and Customers.
• Generate Reports for Effectiveness of discounts, special offers, sale incentives on revenue.Universe designing, developing and generating complex, Adhoc, dashboard Reports.Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Environment: Business Objects XI 3.0, InfoView, Xcelsius2008, Crystal Reports, Webi, Deski, Oracle10g, Toad

Confidential

Senior Programmer Analyst

Responsibilities:

• It is a stand-alone tool to provide an integrated way to administer components, create solutions and manage profitability pricing and pricing adjustments. Actively involved in different stages of SDLC including in gathering of User Requirement and System Specification.Slice and dice data and analysis results, create charts, drill down from summary views to detailed cost data, and link to related models.Perform on-demand queries and what-if analysis using reliable, Web accessible data.Maintain data in a central repository for greater efficiency and control.Universe designing, developing and generating complex,
• Adhoc, dashboard Reports, List of values along with User Acceptance Test and data accuracy test. Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.Worked on Web Intelligence reports to leverage the data from Data Mart.

Environment: Business Objects XI/2.0, PL-SQL, Web Intelligence and Desktop Intelligence, and Crystal Reports

Confidential

Technical Analyst

Responsibilities:

• The EAS is a document authorization system for engineering department of Confidential to authorize and evaluate the progress of engineering documents.

Environment: Java, J2EE, EJB, log4J, Oracle 9i, SQL, WebLogic 8.1.4, CVS, Jbuilder7.0

Confidential

Sr. Programmer Analyst

Responsibilities:

• Point of Sale Point of Sale is an enterprise wide application and a solution to the Confidential shipping needs, deployed internationally and also across nationwide

Environment: Java Swing, UML, Web-services, XML, Log4J, CVS, ANT

Confidential

Sr. Programmer Analyst

Responsibilities:

• Truck Operations Planning System is a stand-alone application used for route planning for the truck operations and movements of the Confidential freight nationwide. This application is used to create route, delete/ modify/ add and split routes and to calculate mileage for the trucks and generate the costs associated with the route and analyze the best route for the truck.

Environment: C/C++, T-SQL, Sybase8.0, Tuxedo Middleware, Visi-Broker, PL/SQL