PROFESSIONAL SUMMARY:

• 12+ years of total IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Retail, Aerospace, Manufacturing, Transportation, Banking, Insurance, Hospital, and Finance sectors.
• Experienced in software architecting, leading and development. In - depth knowledge to SAP Products like SAP HANA, BO/ BI, BODS, Xcelsius dashboards, Web Intelligence, Dashboard Designer, Crystal Reports, SLT, SAP BW (BEX), ECC, SAP Design Studio, Data modeling, Tableau, VISIO, Oracle, MS SQL SERVER, SSIS, Data Services.
• Experience of HANA Data provisioning using SLT, Business Object Data Services (BODS).
• Full Lifecycle implementation of SAP HANA 1.0 SPS8 on ECC.
• Expertise in SAP BW (BEX)/BO integration using Business Objects Enterprise Suite of products.
• Worked on the latest version of SAP Business Objects Enterprise (Information Design Tool, Dashboard Designer, Web Intelligence, Crystal Reports Enterprise, and Explorer) on Business Objects BI Platform 4.0.
• Worked on SAP BPC 7.5 NW Planning/Budgeting/Forecasting implementation from Blueprint to implementation and going live.
• Set up the supply chain model (work areas-location, products, resources, PPM, transportation lanes and quota arrangements)
• Led the delivery of various (application development, web application development, 24/7 L1/L2/L3 support, data warehousing, business intelligence and infrastructure setup) "onshore", "offshore" and "hybrid" multi-million dollar engagements at key clients, DELL, Confidential, CitiGroup.
• Data Modeling - Design and Development of InfoCubes, MultiProviders, ODS objects, DSO (BI 7.0) with star schema and multi-dimensional data modeling techniques. Customization of DataSources in SD, MM, FI-CO, APO, CRM, SRM.
• Worked on front end apps like Java, Java script, C#.Net for scripting.
• Worked extensively on integration of Business Objects Data Services with SAP MODULES and Non-SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2005/2000, DB2. Experienced in upgrading/migrating versions of Business Objects to the higher versions.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SAP HANA /BODS Developer/ BI Consultant

Responsibilities:

• Involved in agile methodology which includes everyday scrum meetings with Product ownerDevelopment team, Scrum master, Stakeholders and Managers.
• Involved in full life cycle SAP HANA implementation and ETL tools like (DS) to extract both SAP and Non SAP data, which includes Analysis, Requirements gatheringDevelopment, Testing, Reporting, Go - live and Post Go-live support.
• Designed SAP HANA models for Advance Analytical reporting using Attribute views, Analytic views and Calculation views (both Graphical & SQL scripted based). Worked on information modeling, Table design, Data provisioning, Administration, real-time replication and interpret business requirements into an architectural design in SAP HANA environment.
• Worked on replication server to extract data from SAP by using SLT tool.
• Created Schemas, table definitions, Attributes, Measures & Hierarchies in HANA. Involved SAP HANA security including user management, roles and privileges.
• Developed complex dashboards for integrated risk adjusted forecast of part level demand, providing key insights into drivers of unplanned requirements and informing strategic decision making.
• Developed multiple Webi reports for Predictive metrical availability using BI Launchpad. Created universe’s in IDT for all these new reports by using Design Studio. Wrote scripts to customize the some special columns.
• We used Designer Studio slide panel to promote efficient use of space on the dashboard.
• Created complex jobs, work flows, Data flows and scripts using various transforms (Integrator, Quality and platform) to successfully load data from multiple sources into SAP HANA.
• Worked on deployment process form Dev to QA and Prod. Provided demo to team and business users about our changes and how this helps to the business. Answer all the questions to team and business.

Environment: SAP HANA 1.0 SP8, SAP BI 4.1 (Xcelsius, Webi), SAP Design studio, SAP BODS, EHP7 ECC 6.0, SLT, Oracle 11g, Agile Methodology’s, SQL Server 2012, Version One.

Confidential, Phoenix, AZ

SAP BOBJ /BODSLead Consultant

Responsibilities:

• Gathered the functional Requirements from the Business users, Business Process Owners to build the Functional specifications, ensure the accuracy of the reporting specifications.
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Administration tasks like Installation/Configuration of SAP BI 4.x and SAP Business Objects Data Services14.x components (Job Servers, Profiler Servers and Repositories),configuring to handle data in and out of SAP.
• Used Business Objects Data Services to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like Oracle 10g/11g, MySQL and SQL Server.
• Involved in writing the High-level and Detail-level documentation of the project.
• Wrote custom functions to produce the derived fields using the source table fields for each record from source.
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and Data profiling process
• Designed the Universes using Business Objects Designer Module and created number of standard reports and queries based on the existing classes/objects

Environment: SAP Business Objects Data Services 4.0, SAP Business Objects BI platform 4.0, SAP R3, PeopleSoft (Source), SQL Server 2008, MS Access 2007, Windows 7, Windows NT, Information steward 4.0

Confidential, Dallas, TX

SAP BI/BODS Developer / Data Architect

Responsibilities:

• Interacting with users for customized and standard reports, gap analysis and associated solutions.
• Extensively worked on designing process chains. Created HLD/LLD documents and provided Solution Architecture Document. Involved in translating business process into business and technical requirements.
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP HANA Models.
• Worked on POC for SAP HANA with ETL replication method using SAP BO Data Services 4.0
• End to End HANA POC technical activities including loading data into HANA tables from Flat Files using Data Services, Modeling in HANA (Analytic and Calculated Views), creating Universes on top of HANA Views in IDT, Reports in WebI and Dashboards in Dashboard Designer.
• Developed several Attribute, Analytic and Calculation views using ECC Sales, Billing, Delivery and Material Master Tables for COE.
• Worked on Business Objects 4.0 tools suite including Information Design Tool (IDT), Web Intelligence, Crystal Enterprise, Explorer, and Dashboard Designer on BI Platform.
• Created OLAP Universes on SAP data (Infocubes / BEx queries) and Relational Universes on Non-SAP data.
• Created the Local Repositories, Central Repositories and Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3, BI, and CRM.
• Extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 4.0 SP1 as an ETL tool for Data Quality.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Involved in data extraction and conversion between BPC and non-ERP systems with extractors and ETL tools.
• We implemented Blackline integration for Cloud environment and SAP. We automated tools to allow
• Users to send data from their ERP to Blackline as well as Blackline to ERP and Oracle.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Used contexts and aliases to resolve loops and traps, performed processes to check the data integrity by comparing report level data and querying over the underlying data source.
• Created Xcelsius Dashboards using Combo Box, Toggle Button, Radio Button, Graphs, Stacked Area Charts, Combination Charts, etc.

Environment: BI 4.0, SAP HANA 1.0, SAP BW/BI 7.0-IP (Integrated Planning), SAP BPC, SAP ECC, SAP Data Services, ETL, Business Objects, Life Cycle Manager, BOBJ Explorer, Xcelsius 2008, QAAWS, Designer, Live Office, Java, Java script, .NET, Crystal Report, MS SQL Server 2008, SharePoint, Oracle 10g, 11i, Windows 2003 server/XP.

Confidential, TX

Lead SAP BOBJ Developer/ Data Architect

Responsibilities:

• Worked as a HANA Lead on HANA Side Car scenario for Financial Reporting Project.
• Designed and developed information models for Report Card, Balance Sheet, GFER Report, and Restatement.
• Developed complex models using attribute views, Analytic views, Calculation views and script based Calculation views.
• Migration of HANA content using Delivery Packages.
• Involved in SLT configuration for real time replication for ECC PCA, COPA related tables.
• Done advanced SLT customization for GLPCA and COEP tables to add additional column.
• Used BODS to flatten Company code, Profit Center, Account, Cost center and other reporting hierarchies.
• Preparing Dashboards using calculations, parameters in Tableau experience, which includes 11 years of techno - functional expertise in SAP Business Intelligence (BW / BI) and over 6 years of experience in Integrated Planning (IP), Business Objects (BOBJ), and Business Objects Planning and Consolidation.
• Wrote customize the daily routines using Java and Java script.
• Design and development of WEBi report for Balance sheet and PNL summary report.
• Development of Information space for BO Explorer for IAS report analysis.
• Lead a team of 3 Hana Modelers and 2 BO/DS developers
• Worked as a HANA/BO consultant on Performance Management Reporting Project.

Environment: SAP HANA 1.0 SP6, SAP BI 4.0 (Xcelsius, Webi), SAP BODS, ECC 6.0, SLT, SAN/NASOracle 11g, Tableau, Java, Java script, C+, SQL Server 2012.

Confidential, Dallas, TX

Sr. Business Objects Developer

Responsibilities:

• Involved in all phases of Software Development Life Cycle, Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Worked on the HR Master Data implementation.
• Installed Business objects Data services and configured different repositories (Local, Central, and Profiler) and job server.
• Utilizing SAP BW IP we enable to map our company's strategic plans with minimal configuration effort and quickly realize them in operative implementations
• Performed analysis, development and implementation of customized Info Cubes and ODS Objects for HR Payroll, Personnel Time Management
• Analyzed business reporting requirements that satisfy with SAP Business Content and installed the necessary objects for Business Content payroll data cube (0PY C02), Time and Labor cube (0PT C01) and the HR Multicube (0PY MC02).
• Developed and modified InfoCubes, MultiProviders, and DSOs.
• Worked in designed & modification of the Universes as per the requirements adding new classes and objects as required
• Developed a scripting routine within Data Services to gather profiled statistics results, created a universe on top of the data and created custom report to reflect the profiling done at the table and column level.
• Worked in converting SAP reports to BO using Web Intelligence & Crystal Reports
• Enhanced performance of the queries using Aggregates, Compression and Partitioning

Environment: Business Objects Enterprise XI, SAP BI 7.0 - IP, Xcelsius. BW 3.5, ECC 6.0, Crystal, Crystal Reports, Oracle, DB2, BODI, ETL, SQL Server, SharePoint.

Confidential, Dallas, TX

SAP BO Technical Developer/ Data Architect

Responsibilities:

• Migrated the Environment (Reports & Universes) from E 6.5.1 to Business Objects - Desktop Intelligence Reports, Web Intelligence using the Manual and the Import Wizard.
• Participated in meeting with SAP functional team and Legacy team for getting the mapping to load the data into Customer Master IDOC (DEBMAS06).
• Created the Local Repositories, Secured Central Repositories, Profiler Repositories using Sql server 2008 database and configured the Local, Profiler repositories with Job server and Management console.
• Universes for both Adhoc & Canned Reporting users of BOE XI 3.1 - Deski & Webi.
• Defined classes, objects, Hierarchies, access restrictions, Conditions, joins, Alias, Contexts.
• Used Business Objects Crystal Xcelsius and Query as a Web Services (QAAWS) for data access.
• Programmed QAAWS links from dashboard for additional functionality
• Created multiple Xcelsius models using QAAWS to publish in Dashboards.
• Worked on creating star schema cubes using SSAS with hierarchies.

Environment: Business Objects, Desktop Intelligence, CMC, CMS, Web Intelligence XI, 6.5,2.x, Designer, Reporter, Business Objects E 6.5.1, Java, .NET, Admin Console, Info view, SAN, SQL. MS SQL Server 2005

Confidential, Austin, TX

Lead SAP BI Technical Consultant

Responsibilities:

• Involved in complete life cycle implementation of SAP BI.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
• Integration of interactive planning, supply chain cockpit, master data in SNP, heuristic, capable-to-match, supply and demand propagation, Optimizer, deployment, and transport load builder.
• Involved in translating business process into business and technical requirements.
• Created Generic extractors/Cubes/ODS/objects in BI.
• Used the platform and data integrator transforms as a part of mapping.
• Involved in creating Data Sources, Info sources, and Transformation.
• Extensively worked on extracting the data from SAP R/3 and Flat Files to SAP BI.
• Extracted data from different modules in SAP R/3 like FICO, COPA and SD.
• Involved in activating various Business Content objects for extracting Master Data and Transactional Data from SAP R/3 into SAP BI.
• Implemented data load from Legacy System in SAP ECC for Customer Master, Vendor Master and Material Master.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to the required level of information.
• Involved in consistency check in aggregates and Attribute Change run.
• Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Involved in debugging the user exit code in RSRT and worked on the performance tuning of reports.

Environnent: SAP BW 3.5, Bex Analyser, ETL, Loading and Monitoring data, Initial load, Deltaload, Oracle, MS SQL Server, .NET, Crystal Reports, SAN/ NAS.

Confidential, Dallas, TX

Business Objects Consultant/DBA

Responsibilities:

• Responsible for requirements gathering and writing specifications.
• Involved in designing, developing & testing the universe for report generation.
• Created & tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the end-user requirements.
• Developed PL/SQL stored procedures to process and store the information in the oracle database.
• Testing of Universe and Reports, which includes database connectivity.
• Tested resolved loops and contexts to ensure the correct results from the query.
• Created and utilized Dash boards which were exported into flash files, used for presentation of real time data.
• Deployment of Crystal Reports via various methodologies Central Management Console (CMC), Publishing Wizard, Infoview, Import Wizard.
• Involved in creating user roles, security access, server administration, password management using the Central Management Console (CMC).
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.

Environment: Business Objects 5.1.2/5.1.6/6.1 a/XI R2/R3, Designer, Web Intelligence, Desk I, Info view, Xcelsius, Crystal Reports 9.0/10.0, Business Objects Data Integrator, SQL Server 2005, Oracle 9.0/10g, PL/SQL, Windows NT, HTML.

Confidential, Dallas, TX

Sr. Developer/ Architect

Responsibilities:

• Developed database objects such as DTS packages, procedures, functions, tables, triggers, and indexes
• Used joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases
• Monitored the SQL profiler and tuned queries and procedures to boost database performance.
• Developed complex stored procedures and views to generate various drill-through reports, parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS and Dundas Charts. Wrote complex expressions and calculations for SSRS reports with conditional formatting.
• Performed Data Analytics, Root / Cause Analysis on data using Crystal Reports, Excel, and MiniTab

Environment: MS SQL Server, Crystal Reports 9i, Business Objects, Phyton , Data Modeling, Siebel, Visio, ER Win, UNIX, Oracle 8i, DB2, XML, SQL Navigator, Rapid SQL and TOAD, ClearCase, PVCS (Packages, Stored Procedures, Triggers, etc)

Confidential, Dallas, TX

Database Programmer/ ETL Developer

Responsibilities:

• Developed IVR System using SQL SERVER, Oracle, TOAD for Mortgage prescreen purpose to save Loan office’s time
• Worked as Web Developer and a Database Programmer
• We used EDI to data transport from one location to other location. We used EDI codes. This is integrated with .net application
• Created DLL for database access and created components for different functionality
• Responsible for analyzing Oracle database, tuning and normalization
• Reading, update and transmit XML pages
• Designed new screens for existing Delphi allocation and supported this project
• Wrote stored procedures to update millions of records from one database to another database in MS SQL Server 2000
• Debugged procedures using TOAD tool, fixing errors, creating indexes, reducing table extends
• Designed and created database using Oracle 8i, PL SQL, SQL Navigator, Rapid SQL, TOAD
• Worked on Oracle Reports for daily process purpose using Business Objects
• Used Erwin tool to design database tables
• Used Visio for design requirements

Environment: MS SQL Server 2000, MS Access, Business Objects, Visio, ER Win, Oracle Reports, Oracle 8I, PL SQL, TOAD, SQL Navigator, VB Script, FTP, TCP / IP