SUMMARY:

• Accomplished and Certified Senior IT professional with a 8+ years of background in business intelligence, reporting systems, data quality (including ETL), software design and full life - cycle development. Capable of managing numerous projects while leading cross-functional teams to meet and exceed overall IT initiatives.
• Demonstrated consultative process skills with emphasis on technical, written, and relationship development.
• Business Intelligence using SAP Business Objects Suite and Tableau.
• ETL (Data Services -- BODI / BODS, SSIS)
• Reporting (Tableau, Web Intelligence, Lumira, Crystal Reports), Dashboard (Xcelsius, Dashboard designer)
• Data Warehousing, ETL, Staging and persistence layers.
• Process Improvement and Implementation, Team Leadership & Effectiveness

TECHNICAL SKILLS:

Tools: Tableau 81./9.0, Business Objects 4.1/4.0, XI r3, r2, r1, 6.5, Web Intelligence 4, XI, 6.5,UDT/IDT, Data Services 4, XI 3.2, 4,DQM,SAP HANA Studio, SSIS, BEx Query Designer, Crystal Reports Enterprise/2011/2013,Dashbaord Designer4.1/4.0/Xcelsius 2008, Lumira 1.13/1.29, Visio.

Languages: Basic 6; PL/SQL, SQL, JavaScript; VBScript; HTML, DHTML, Ajax, JQuery, CSS, JSON, XML,C++,JAVA.

Databases: SQL Server 2012/2008/2005, Oracle 11g/10g/9i Teradata 12/13, SAP HANA SP5/SP9, MS Access, IM DB2, SAP BW 7.0/7.3/7.4. EPIC2012, 2014, 2015.

Business Applications: SAP ECC 5.0/6.0,EPIC 2012/2015 Oracle ERP.

SAP: MM, GM, FM, MDM, FICO, SD, PP, CRM, QM, PM, WM, HCM, SCM.

Operating Systems: Windows Server 2012/2008/2003/7/ Vista/XP/2000/NT/98/95/NT; Unix/Linux; Mac OS; Mainframe.

Other: OLTP, OLAP, ODBC, OLE DB, SOAP, SSL, SAP Bank Analyzer, Forecasting, Trend Analysis, Star and Snowflake Schemas, Executive Dashboards, CDC (change data capture),TCP/ IP, FTP, HTTP, ISO, LDAP, SSO, RPC.

Methodologies: Agile, Scrum, Waterfall, Inmon, Kimball, object oriented programming (OOD), rapid application development (RAD), Accelerated SAP (ASAP).

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr. SAP Business Intelligence Consultant

Responsibilities:

• Gathering information (specs) from the user regarding the report, providing Estimation, developing reports and performing the testing.
• DevelopedMultiproviders, Infosets, Cubes, Aggregates DSO objects, Custom InfoObject Catalogues, Characteristics and Key figures info objects, info sources, Transformations, routines(start, end expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP's, Process chains.
• Migrated reports and dashboards from Business Objects 4.0 to BOBJ 4.2 and created distributed environment for Business Object 4.2.
• Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the premigration of BW on HANA implementation. Optimized BW cubes for HANA purpose.
• Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA. Interacted with the Business Analysts on a daily basis for their KPI & report
• Created Patient Satisfaction, HACs & PSI, Patient, and Meaningful Use Dashboard using Design Studio against Healthcare and Patient count KPI’s.
• Migrated MS SQL Database into SAP HAN
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Developmen
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created Crystal reports, Lumira, and Webi reports including linked and unlinked sub reports. Created formulas, parameters, applied calculations and suppressions.

Environment: - BODS 4.2, Design Studio 1.6,BOBJ4.2, SAP ECC 6.0, Lumira 1.29, SAP HANA SP9, SAP BW 7.4, ECC6.0, SQL Server 2012, Apache Tomcat 7.0, and MS Outlook.

Confidential, Chicago, IL

SAP Business Intelligence Lead

Responsibilities:

• Integrated BOBJ 4.1 and BODS 4.2 with SAP HANA1.0 and created Technical specifications and standard modeling documents for HANA.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID’s for developers, super users, and end users.
• Involved in SAP HANA Security design for User management, Roles, and Privileges.
• Worked on variousJava sdk scripts to configure authentications, SSO, and web servers for HANA, SAP BW7.3, BODS4.0 and BOBJ4.0
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio againstHCM and Payroll Kpi’s.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• IntegratedSAP Net weaver portal to Business objects content using Knowledge management, Iviews, work sets, portal roles.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.1 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Developed Webi reports and dashboards for different Human resource and finance KPI’S likeFinance and controlling, HR, HCM.
• Created Universes on top ofHANA calculation viewsand developed the Webi reports and dashboards usingIDT(Information design tool).

Environment: - BODS 4.0, BOBJ4.0, HANA 1.0 SP2, SAP BW 7.4, SAP ECC 6.0, Linux,MS office, Visio, MS Outlook.

Confidential, Denver, CO

Sr. HANA/BW/BO Consultant

Responsibilities:

• Performed sizing and created Architecture for Dev, test, and Clustered Production environment for BOBJ 4.1
• Work directly with senior leadership in providing roadmap and guidance on global rollout strategy to over 10,000 users across the firm.
• Installed and configured BOBJ 4.1,BODS 4.1, BOBJ Explorer 4.1, BI Mobility 4.1 on Windows platform
• Created Registration, Backlog & Billing reporting using SAP and legacy data. This involved the integration of Sales, Billing, and Profitability Analysis and Project Systems data integration.
• Implemented BW-HR reporting for HR users. Created report for Headcount, Payroll and Benefits BEX & WEB Intelligence reports.
• Developed calculation views, Attribute and Analytical views in HANA and created Lumira reports against it.
• Used SOLMAN for ticket tracking and transport purpose and created technical specs for the reporting projects.
• Configured DMZ, APS services, Webi session timeout, Windows AD, Webserver, CTS, Load Balancer, and SSO Authentication.
• Customized JAVA BI Launchpad for user p and landing page appearance.
• Defined BEx queries as per the report requirement. Defined best practices on BW and BO data services integration.

Environment: - BODS 4.1, BOBJ4.1, SAP ECC 6.0, SAP BW 7.3, SAP HANA SP5, SQL Server 2012, Apache Tomcat 7.0, and MS Outlook.

Confidential, San Jose, CA

Sr. SAP Business Objects Developer

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Experience in creating reports against BICS connectivity 4.1 and also connecting to multiple data sources.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad with Bex as source.
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
• Created complex dashboards on Bex Queries using Query Browser in Dash board designer 4.0
• Created Dashboards for FP&A using BIWS and QAAWS in Dashboard Designer 4.0.
• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports and by selecting the filter option changing with refresh on trigger option to pick from the latest instance.Created Dynamic Dashboards using SAP BI data/ BEx Queries. Have Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: SAP BO 4.0, NetWeaver 2004S, SAP BW 7.3, ECC 6.0 Business Areas: MM (Purchasing), SD, BEx, WEBI, IDT, and Dashboard Design Tool

Confidential, Atlanta, GA

Business Objects Administrator

Responsibilities:

• Involved in complete life cycle implementation of with SAP BW team in SD, MM, PS and FI modules.
• Imported SAP rolesintoBusiness Objects Enterprise, for allowing role members to log onto Business Objects Enterprise with their usual SAP credentials.
• DevelopedMultiproviders, Infosets, Cubes, Aggregates DSO objects, Custom InfoObject Catalogues, Characteristics and Key figures info objects, infosources, Transformations, routines(start, end expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP's, Process chains.
• Data extraction from R/3 and Flat files, Creating Info Packages, DTP's, and Process chains Scheduled loads.
• Worked with BEx Analyzer to generate Queries and embedding them into Workbooks.
• Designed Maintained and Modified Universes against the Bex queries and relation universes against the oracle views using UDT Tool for adhoc reporting.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Created complex Webi and Crystal reports by linking data from multiple data providers and applying filters on report level and query level.
• Extensively used functions and features like alert, Force merge, Merge Dimensions, drill-down, prompt and hyper linking in Webi reports.
• Developed 3 complex HR (Time management, Payroll, Recruiting), and Backlog Dashboards using Xcelsius and used BICS connectivity to populate data in dashboard.
• Used complex excel logics like Index, match, ifelse etc and drill down, dynamic visibility components in dashboard for optimize performance. Created Webi reports and performed functional testing in HP QC and data testing against Bex queries results.
• Created Webi and crystal reports on HR Kpi’s and business Metrics. Extensively worked on integrating BOE( business objects enterprise ) with BI/BW 7.0
• Migrated dashboards, Universes, and Webi reports across BI4.0 Environments using promotion management.
• Scheduled reports to BI Inbox, email destinations, and File systems.

Environment: Business Objects 3.1 SP5, CMC,Web Intelligence, Xcelsius, Crystal Reports, SAP BW7.3, Oracle 11g.

Confidential

Business Objects 4.0 Developer

Responsibilities:

• Designed the architecture for BOBJ 4.0 and configured BOBJ 4.0 in clustered environment.
• Designed the security model and integrated authentications with Windows AD and SAP Aliases.
• Worked with SAP Basis for firewall ports, Windows domain controller, and configuring Java environment variables for Business Objects.
• Conducted POC of Business Objects by developing webi reports and a Dashboard and pushed to production environment.
• Extract Data out ofSAPand moving into Datamart and then moved to Excel Spreadsheet for a planning tool for Supply Chain.
• Extensively worked on integrating BOE (business objects enterprise) with BI/BW 7.0.
• Configures JAVA SDK files for Single sign on, Web servers, authentications for BOBJ environment.
• Worked on blue printing, requirement gathering and implementation of SAP HANA.
• Extensively worked on datamarts for SAP BODI/ BODS.
• Trained IT developers and Business analysts over the different client tools of Business Objects including the ad hoc capabilities of reports, universes and recommended SAP methodologies and strategies for development.

Environment: Business Objects 4.0 SP5, IDT, CMC, Web Intelligence, Xcelsius, Crystal Reports, SAP BW7.3, Oracle 11g.

Confidential, Nashville, TN

Business Objects developer

Responsibilities:

• Responsible for gathering requirements, analysis and structured Business Intelligence platform based on user requirements.
• Installation & Configuration of Business Objects 3.1 Enterprise Suite of Products.
• Created user profiles and folders in CMC module with varying security profiles for each user.
• Creating new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R2 and followed the SDLC for designing new component.
• Resolved Migration issues both in Designer, Reporter and created test cases to check the Migrated Reports.
• Created Derived Tables in the universes. Resolved Chasm traps, Fan Traps & Loop problems to reduce the complexity of the universes.
• Applied User and Group Restrictions in selected objects in universe level.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end functions, procedures, tables, views required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Implemented Row Level Securities and Object level security in the database level, which helps the universe to in corporate security for sensitive information.
• Designed complex BEx queries and built reports using BEx analyzer & BEx web.
• Used Variables (Variable offset, Customer exit, and User exit, Authorization) to meet the report requirements.
• Created Structures, Selections, Restricted Key figures, Calculated Key figures, formulae and if-else conditions according to the requirements.
• Designed and built Universe, reports using Web Intelligence, Crystal Reports 2008 on the top of the SAP BEx queries.
• Trained Interns & IT staff on working with Xcelsius 2008.
• Extensively worked on Crystal reports and generated various types of reports based on user requirement.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Webi

Environment: Business Objects 3.1, SQL Server 2000 Oracle 10g/9i, Tomcat 4.0, Apache server 1.3, Window 2003 Server/XP. Crystal Reports XI/10.0, SAP BI 3.5, GL Rapid Marts.