SUMMARY:

• Meticulous IT Developer/Analyst who delivers superior performance working on large complex assignments while managing tight schedules and deadlines. Thrives in a fast paced setting and operates wif a strong sense of urgency, duly aided by strong planning and analytical skills.
• Dedicated Business Process Analyst who is experienced at doing major business presentations to various levels of management. Adept at gathering information into a comprehensive report, creating persuasive business presentations and working wif various departments to solve issues. Specializes in developing new business processes and comprehensive process research.
• Having more TEMPthan 15 years of experience in software industry which includes 10+ years of experience as SAP BW/BI/BOBJ/EDW/Consultant and Business Analyst
• Experience in Full Life Cycle Development - Analyze to Deploy (FLCD)- Interviewing users, gathering Requirements, Functional and Technical Design Documents, Drafting specifications, Prototyping, Design, Development, User Acceptance Testing and Production Roll Over. Involved in 4 Full Life Cycle Implementations of BW projects dat include data modeling, technical designing and development, report generation, data extraction, batch scheduling, testing and support. Individual wif a very strong understanding of Data Warehousing Concepts. ECC 6 and BW 7.x upgrade experience.
• BW Extraction - Expertise in extractions from SAP R/3 using LO Cockpit, Generic Extractions and non-SAP R/3. Expertise in designing delta-loading strategies, automation of loads using process chains. Expertise in problem solving in ETL and in handling performance issues. iDoc Status Monitoring, iDoc Analysis, detest errors on Status records and tan allow for mass Status changes (such as delete or set for reprocessing) as well as reprocessing via foreground or background.
• ABAP(Related to BW) - Expertise in ABAP programming for writing teh user exits using CMOD and in writing teh start routine, end routine, expert routine, and info object routines.
• BW Modeling - Analyzing and activating Business Content, Creation of InfoCubes, ODS Objects, Info Sources, Info Objects, Info Packages, Aggregates, Multi Providers, Addressing Design Issues, and iDoc Analysis/Processing.
• BI/BW/BO Reporting - 5 + years working wif SAP Business objects tools (BOBJ) - Design Studio, Data Services, Information Design Tool (IDT) Universe Designer, Analysis for office, OLAP analysis, Webi rich client, Full-Client/ Deski, Info view, BI Launch pad, Advanced Analysis, Explorer, Web Intelligence (WebI), Scheduling and publishing, Crystal Enterprise, Crystal Reports, Import wizard, Xcelsius, Broadcast Agent. Well versed in Rapid Deployment Solutions.
• BEx Query Designer and Analyzer, Bex Web, Web Application Designer, Info set Query, Calculated and Restricted Key figures, Structures, Variables, Conditions, Filters, RRI, Charts, Exceptions, and Workbooks. Created custom and enhanced template to replace SAP provided 0TEMPLATE.
• Business Process and Data Modeling: End-to-End business process models and relevant documents for several functional areas. Logical and physical data modeling. Well versed in Relational and or Dimensional Model Data Modeling - DB2, Oracle, SQL Server. Ability to generate DDL and excellent SQL skills. Excellent noledge of TOAD and Erwin and well versed wif Best Practices in Data Modeling Techniques.
• BW Operation - Full Life Cycle Implementations and ECC 6.0 Upgrade, BW 3x to BI 7x Migration, BOBJ Enterprise 3x to 4x migration.
• Solution Manager: Well versed in using teh SolMan tools to enhance, automate, and improve teh ERP landscape.
• SAP Modules - SD, FI/CO, IM/WM, SCP, APO, SRM, MM, IP, APO, CRM, HR.
• Experienced in performance tuning using partitioning, and compression of InfoCubes and creation of aggregates.
• EDW Training: CSC Certified EDW Trainer. Instrumental in creating teh training material and tan training teh trainers in many locations. Taught a full-fledged BI EDW Training Course spread over 8 weekends in Atlanta.
• 5+years’ IT experience in Visual basic, ColdFusion, Oracle, SQL Server, PVCS/Oracle App Server Administration, Web Security, Web Design, and Configuration/Delivery Management, Off-shore Team Management.
• Having very good communication skills, being a resourceful team player wif excellent interpersonal skills.
• Exceptional ability to quickly master new concepts and technologies.

TECHNICAL SKILLS

Operating Systems: MS-DOS & Windows’ 95/’98/ ‘00/NT/2k/XP

Languages: C, C++, SQL, PL/SQL, ABAP/4

Data warehouse: SAP BW 3.5 / 3.1C, Netweaver BI 7.x

Data Modeling: Erwin, MS Visio, TOAD

GUI: SAPGUI, Visual Basic, ColdFusion

Web Related: HTML, DHTML, VBScript, JavaScript, CFML.

Reporting Tools: SAP Crystal Reports 2008,2011,2013, Webi, BOBJ 4.x, Design Studio, BEx, WAD, Excelsius, Cognos. Business Objects Data Services (BODS), Enterprise BI tools, Business Objects Enterprise Server 3x/4x, Oracle BI Publisher, Tableau

Domain Knowledge: SD, FI/CO, IM/WM, SCP, APO, SRM, MM, IP, APO, CRM, HR.

Visual Designer Tool: Erwin, MS Visio

ERP Tools: Solution Manager, LifeCycle Manager/Promotion Management Tools

RDBMS: Oracle, MS SQL Server, IBM DB2

QA Tools: HP QC, ServiceNowMisc. MS SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Environment: SAP Netweaver (BI 7.4), BEx Analyzer, BEx, ECC 6x, Business Objects 4.1, Design Studio, BODS, BEx Query Designer, Business Objects Enterprise Server, Crystal Reports 2013, Web Intelligence (WEBI), Dashboards 4.1, BW on HANA 1.00.102.02

Responsibilities:

• Development of WebI, Crystal, and Xcelsius reports wif SAP ECC and Non SAP data. Created custom reports involving complex business logic
• Utilized Crystal Reports set of tools for creating complicated reports including sub-repots, parameter based reports, graphical reports, formula based, highly-formatted reports, drilling reports, analysis reports, and data reports along wif LOV.
• Monitor data loads and perform trouble shooting of issues
• Mapping of reporting requirements from business terms into SAP objects.

Confidential, Raleigh NC

Environment: IBM Datastage Business Intelligence Suite, IBM TWS, Oracle 11.gx, Toad for Oracle 12.1, PL/SQL Developer 10.0.5, Hadoop, Terradata, Unix and Shell Scripting, Sharepoint, ServiceNow Quality Management Tool

Responsibilities:

• As a member of teh Tech Engineering Team, provided production support in teh operation and management of teh complex and intricate ETL efforts.
• Carried out teh triaging of incidents and coordinated teh efforts to prioritize and resolve issues.
• Monitored and managed teh data file movements, data loads, and report generation.
• Carried out trouble shooting and diagnostics and fixed data load errors, and report issues etc.
• Created dataflow documents and gave presentations to train other team members.

Confidential

Environment: SAP Netweaver (BI 7.4), BEx Analyzer, BEx, ECC 6x, Business Objects 4.1, Design Studio, BODS, BEx Query Designer, Business Objects Enterprise Server, Crystal Reports 2013, Web Intelligence (WEBI), Dashboards 4.1, BW on HANA 1.00.102.02, MS SQL Server 2014, Oracle Hyperion Interactive Studio 11.1.2.4, HP QC Center 10.0

Responsibilities:

• Modeling/building/set up of data marts including data cleansing
• Reports and key performance indicators
• Resource management, production support, and user training
• Data validation and defect management

Confidential

Environment: SAP Netweaver (BI 7.4), BEx Analyzer, BEx, ECC 6x, Business Objects 4.1, Design Studio, BODS, BEx Query Designer, Business Objects Enterprise Server, Crystal Reports 2013, Web Intelligence (WEBI), Dashboards 4.1, BW on HANA 1.00.102.02

Responsibilities:

• Development of WebI, Crystal, and Xcelsius reports wif SAP ECC and Non SAP data. Created reports such as open orders, sales deals, shipments, COPA sales reports etc.
• Utilized Crystal Reports set of tools for creating complicated reports including sub-repots, parameter based reports, graphical reports, formula based, highly-formatted reports, drilling reports, analysis reports, and data reports along wif LOV.
• Monitor data loads and perform trouble shooting of issues
• Mapping of reporting requirements from business terms into SAP objects.
• Created universes using Information Design Tool connecting to multiple data sources. Involved in designing, developing, and maintaining new and existing universes by creating joins and cardinalities, classes, objects and condition objects. Created Aliases and Contexts to resolve fan traps and chasm traps.
• Created marketing and finance dashboards for Financial Planning and Analysis, Inventory Management and Cost Center Accounting data. Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Worked on optimizing teh performance of teh dashboards. Reduced teh dashboard loading time by scheduling teh backed source webi reports and by selecting teh filter option changing wif refresh on trigger option to pick from teh 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.
• Query Development, Web Application Development, Workbook Development and Business Objects Report Development wif WEBI, Crystal Reports and Dashboards.
• Report distribution wif Info. Broadcasting, scheduling, and publications in Business Objects
• Enhance data sources wif user exits and Logistics cockpit.
• Perform BASIS and ABAP transactions wif respect to development work and processes such as transport request management, RFC Destinations and SQL Trace etc.
• Perform Solution Manager functions as related to change management and transport management etc for development and support processes.
• Simultaneously manage multiple initiatives and tasks while managing time frames, deadlines, and release schedules etc, while providing production support.
• Conduct and facilitate user meetings, requirements gathering sessions, UAT etc.
• Manage Project mile stones, budget, and delivery timelines etc.
• Trained in SAP HANA. Worked on HANA POC pilot project. Created Analytic/Calculation and Calculation views, reports, and Graphs in HANA.
• Trained in Agile Scrum Methodology.

Confidential

Environment: SAP Netweaver (BI 7.x), BEx Analyzer, BEx, ECC 6x, Business Objects 4.1, Design Studio, BODS, BEx Query Designer, Business Objects Enterprise Server, Crystal Reports 2013, Web Intelligence (WEBI), Dashboards 4.1, BI Publisher 11g.

Responsibilities:

• Responsible for end-to-end content delivery. Involved in full life cycle development starting from blue printing, requirements gathering, design, back end, middle tier and front end development, product testing, production rollout, post production maintenance, support, trouble shoot production issues, monitor/improve performance and carry out enhancements and upgrades.
• Developed several KPI reports such as teh Schedule Change Report, PDA Metrics Report, WBS Bar Chart Report, and PO External Audit Report. Created complex and Ad-hoc reports in WEBI, Crystal Reports, BEx Query Designer, Business Objects Data Services (BODS), and Design Studio using features such as Combined Queries and created Universes, Crosstab Queries, Dashboards, Top N type of reports etc. Provided production support for teh dashboard maintenance and enhancement.
• Extensively worked wif Crystal Reports and generated complicated reports including sub-repots, parameter based reports, graphical reports, formula based, highly-formatted reports, drilling reports, analysis reports, and data reports along wif LOV. Designed Crystal Reports wif dynamic content and custom UI. Set up teh scheduling and broadcasting of business critical reports to hundreds of end users.
• Wif teh help of migration automation tool (Dynaflux), migrated several WEbi reports to BI publisher for consumption by Oracle services group at DOT. Created several KPI reports in BI publisher for Oracle services group.
• Carried out teh BW 3.x to BI/BOBJ 7.x /4.1 conversion efforts to successfully migrate highly analytical and business critical reports. Carried out migration from Business Objects 3.1 to 4.1 Environment by Creating highly formatted Crystal Reports wif multiple sub reports. Involved in teh maintenance of Universes, Classes and objects.. Created Derived tables in teh Designer to enhance teh capabilities and performance of teh universe.
• Developed teh backend solution wif DSO, Info Cubes and Multiproviders using ABAP for teh data transformations. Provided custom solutions by enhancing extractors.
• Conducted production support activities. Created Process Chains and monitored teh loads in BW. Carried out trouble shooting exercises in teh production landscape and provided user support. Broadcasted reports to field representatives using scheduling functionality.
• Conducted requirements gathering sessions, UAT sessions etc. Coordinated activities of multiple groups and facilitated technical feasibility discussions as and when necessary by conducting JAD sessions. Created and managed requirements traceability matrices. Attended multiple sessions related to SAP HANA road map and how to strategically align and reposition teh interests of NC DOT.

Confidential NY

Principal SAP Consultant

Environment: SAP Business One, SAP Netweaver (BI 7.x), BEx Analyzer, Query/Web Application Designer, ECC 6x, Business Objects, Webi, Crystal Reports, Design Studio, Excelsius

Responsibilities:

• Created teh Daily Sales Analysis (DSA) KPI (Key Performance Indicator) Report which would provide a quick health check on how teh organization is performing by presenting parameters such as teh Net Revenue, Cost to Sales, Auditable Margin Per Piece, Finance Margin etc. for different time slices such as WTD, MTD, QTD, YTD etc. Teh reports were sourced from SAP Business One and some underlying SQL commands had to be enhanced and tweaked to accomplish teh complex reporting scenarios via Crystal Reports. Created highly complex sub-reports, formula/parameter driven reports etc. in Crystal Reports serving as Front End and SAP Business One serving as teh Back End.
• Developed teh backend solution wif DSO, Info Cubes and Multiproviders using ABAP for teh data transformations. Added teh sales planning piece utilizing teh IP component, comprising of: Planning Sequences, Planning Functions, Characteristic Relationships (For ex: W.R.T: Planning Sales Types (New, Retention, Penetration etc.)), aggregation levels, data slices etc. Teh report output was developed using BEX Query Designer and teh dashboard was built wif teh Business Objects Component.

Confidential

Senior SAP Consultant/ Report Architect

Environment: SAP Netweaver (BI 7.x), BEx Analyzer, Query/Web Application Designer, Crystal Reports, Business Objects, Webi, Crystal Reports, Design Studio, Excelsius, ECC 6x, uPerform

Responsibilities:

• As teh EDW Lead Consultant/ Report Architect;
• Conducted BI EDW Training/Provided Site support on LMP EDW at various Army Depots across teh country and assisted teh LMP users in creating Ad-hoc queries, creating Triage Tickets etc., and performed reporting gap analysis. Training and helping teh G6 and onsite TCSC resources regarding EDW Questions and EDW Architecture.
• Created teh Weekly Production Update Finance KPI (Key Performance Indicator) Report which would provide a quick health check on how teh organization is performing by presenting parameters such as teh Net Revenue, Total Expenses, Net Operating Results, and teh Direct Labor Hours for teh 12 month period of a Financial Year. Extensively worked wif Crystal Reports and WEBI in delivering very complex, highly-formatted, and business critical reports.
• Created Dynamic Dashboards using SAP BI data/ BEx Queries. Well versed wif Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers
• Responsible for end-to-end content delivery. Involved in full life cycle development starting from blue printing, requirements gathering, design, back end, middle tier and front end development, product testing, production rollout, post production maintenance, support, trouble shoot production issues, monitor/improve performance and carry out enhancements and upgrades.
• Helping PBA (Pine Bluff Arsenal) in assessing their reporting needs and coming up wif a strategy to create and customize some KPI’s which will guide their business policies in teh future.
• Assisted teh command center in resolving LMP EDW issues by interacting wif End Users and coordinating wif Team CSC members.
• Created many documents such as teh workarounds, DTP’s, SOP’s etc., to guide and assist teh End Users in all teh Army Depots.
• Created several business process models spanning across many functional areas as a part of teh Business Process Modeling Group. Also linked teh workarounds, DTP’s, and SOP’s to teh effected models in a graphically representative and visually useful manner.
• Published EDW Reports onto teh LMP Portal for consumption by Enterprise Users across teh world. Assisted in developing updated policies and procedures manual dat included new ways for employees to approach several significant business processes. Assisted in creating presentations dat were used to persuade management to consider more efficient business methods.

Senior SAP Consultant

Environment: SAP Netweaver (BI 7.x), BEx Analyzer, Query/Web Application Designer, ECC 6x, uPerform, Business Objects

Confidential, Marlton, NJ

Responsibilities

• Conducted Training/Provided Site support on LMP EDW at various Army Depots across teh country and assisted teh LMP users in creating Ad-hoc queries, creating Triage Tickets etc., and performed reporting gap analysis.
• Responsible for end-to-end content delivery. Involved in full life cycle development starting from blue printing, requirements gathering, design, back end, middle tier and front end development, product testing, production rollout, post production maintenance, support, trouble shoot production issues, monitor/improve performance and carry out enhancements and upgrades.
• Contributed to teh successful implementation of teh EDW Sales Increment and developed 18 reports and 5 KPI’s. Provided teh post go-live user training/support and handled production support issues.
• As a part of D3 PDIT (Process and Data Integration Test) group, represented teh BI team in performing duties such as: Data Loading, Conducting Budget and Finance Report Demos etc.
• Assisted teh ‘CR 26060 CATS timesheet approval in upgrade’ process by closely working wif teh team, performing data analysis, data loads, data monitoring etc. and performing teh unit tests, integration tests etc. in several environments.
• As a member of teh D2 Regulatory Reports Team, performed requirements gathering, created teh CRD’s, CDD’s, Tech and Functional Specs and did teh developmental work. Participated in ARB Reviews and in inter-group meetings.
• ECC 6.0 Upgrade Project: Encompassed testing more TEMPthan 1240 extractors in teh upgrade environment. Performing requirements gathering and gap analysis to enable a smooth transition from R/3 to ECC 6.0. Performed data analysis, data loads, data monitoring etc. and conducting teh unit tests, integration tests etc. in several environments. Participated in teh Cutover activities and managed to successfully complete it, wifin teh stipulated time period.
• Performed iDoc Monitoring, Analysis, and Processing using various transactions such as WE02, BD87 in conjunction wif VA03, VA05, MB03, MB51, MD04, MM03, ZMMBE etc., throughout teh course of teh project.
• As a member of teh Budgeting and Finance increment (CRDB24642), performed requirements gathering, created teh CRD’s, CDD’s, Tech and Functional Specs and did teh developmental work.
• Participated in ARB Reviews and in inter-group meetings. Working on designing and developing 19 BI reports as a part of EDW Budgeting and Finance Increment.
• Involved in teh modifying and Building of Universes, Classes and objects. Created objects and defined them accordingly into measures, dimensions and detail. Used joins concept by taking different tables from different data sources in teh Universe. Set up Universe level conditions to restrict data based on Functional specifications. Involved in creating Aliases and contexts in Universe Designer. Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down and Formulae’s. Created a backup of WEBI Reports and Universes in .BIAR format using Import Wizard. Created many business critical reports in WEBI and Crystal Reports. Created Dashboards in XCelsius using SAP BI data/ BEx Queries
• Enhanced teh standard web template and implemented it in all teh relevant landscapes for teh entire EDW. Teh Enhancement and Configuration process, though strenuous, was successfully implemented after applying some OSS Notes and coordinated teh effort wif SAP International Tech Support group. Teh enhanced web template is teh basis of 90% of LMP EDW standard and Ad-hoc reports. As a SAP BI consultant worked on teh Forecast Accuracy Increment building a SAP BI 7.0 solution for teh Forecast Accuracy KPI and Metrics reports.
• Designed and developed teh solution for teh Federal Government Funds Management reports wif data feeds from Funds Management, Special Ledger, and Controlling.
• Created standard and Aging reports to fulfill teh requirements. Assisted in analyzing business process data and creating reports dat were presented directly to management. Interfaced wif business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
• Developed teh backend solution wif DSO, Info Cubes and Multiproviders using ABAP for teh data transformations. Teh report output was developed using BEX Query Designer and Web Application Designer through teh SAP Enterprise Portal.
• Also involved in mentoring team members on using teh SAP BI 7.0 new techniques like DTPs and Transformations, also involved in training teh end users and power users in using teh applications at different locations.