CAREER 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 with 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 with various departments to solve issues.
• Specializes in developing new business processes and comprehensive process research.
• Having more than 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 that include data modeling, technical designing and development, report generation, data extraction, batch scheduling, testing and support. Individual with a very strong understanding of Data Warehousing Concepts. ECC 6 and BW 7.x upgrade experience.
• 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 then 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 the user exits using CMOD and in writing the start routine, end routine, expert routine, and info object routines.
• 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.
• 5 + years working with 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.
• 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 knowledge of TOAD and Erwin and well versed with Best Practices in Data Modeling Techniques.
• Full Life Cycle Implementations and ECC 6.0 Upgrade, BW 3x to BI 7x Migration, BOBJ Enterprise 3x to 4x migration.
• Well versed in using the SolMan tools to enhance, automate, and improve the ERP landscape.
• 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: Confidential Certified EDW Trainer. Instrumental in creating the material and then the trainers in many locations. Taught a full-fledged BI EDW 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 with 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

WORK EXPERIENCE DETAILS:

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 with 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 with 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 the Tech Engineering Team, provided production support in the operation and management of the complex and intricate ETL efforts.
• Carried out the triaging of incidents and coordinated the efforts to prioritize and resolve issues.
• Monitored and managed the 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, RTP, NC

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:

• End to End ownership for requirements gathering, design, UAT, Implementation, and post production support
• Modeling/building/set up of data marts including data cleansing
• Reports and key performance indicators
• Resource management, production support, and user
• Data validation and defect management
• Created reports such as Order Status, Backlog detail, Shipping Detail, Finance and Ledger Reports etc., sourcing data from SAP and non-SAP sources.
• Extensively used HP QC Center for creating test case scenarios and defect management.
• Initiated new measures to track the business transformation metrics and coordinated pre-go live efforts with global partners spread across the globe and situated in different time zones.

Confidential, TN

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 with 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 with 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 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.
• Query Development, Web Application Development, Workbook Development and Business Objects Report Development with WEBI, Crystal Reports and Dashboards.
• Report distribution with Info. Broadcasting, scheduling, and publications in Business Objects
• Enhance data sources with user exits and Logistics cockpit.
• Perform BASIS and ABAP transactions with 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 the 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 the dashboard maintenance and enhancement.
• Extensively worked with 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 with LOV. Designed Crystal Reports with dynamic content and custom UI. Set up the scheduling and broadcasting of business critical reports to hundreds of end users.
• With the 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 the 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 with multiple sub reports. Involved in the maintenance of Universes, Classes and objects... Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Developed the backend solution with DSO, Info Cubes and Multiproviders using ABAP for the data transformations. Provided custom solutions by enhancing extractors.
• Conducted production support activities. Created Process Chains and monitored the loads in BW. Carried out trouble shooting exercises in the 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 the 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 the Daily Sales Analysis (DSA) KPI (Key Performance Indicator) Report which would provide a quick health check on how the organization is performing by presenting parameters such as the Net Revenue, Cost to Sales, Auditable Margin Per Piece, Finance Margin etc. for different time slices such as WTD, MTD, QTD, YTD etc.
• The reports were sourced from SAP Business One and some underlying SQL commands had to be enhanced and tweaked to accomplish the 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 the Back End.
• Developed the backend solution with DSO, Info Cubes and Multiproviders using ABAP for the data transformations.
• Added the sales planning piece utilizing the IP component, comprising of: Planning Sequences, Planning Functions, Characteristic Relationships aggregation levels, data slices etc. The report output was developed using BEX Query Designer and the dashboard was built with the Business Objects Component.
• Developed several business critical reports utilizing 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 the dashboard maintenance and enhancement.

Confidential, Rock Island

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:

• Conducted BI EDW /Provided Site support on LMP EDW at various Confidential across the country and assisted the LMP users in creating Ad-hoc queries, creating Triage Tickets etc., and performed reporting gap analysis. and helping the G6 and onsite TCSC resources regarding EDW Questions and EDW Architecture.
• Extensively worked with 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 with 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 with a strategy to create and customize some KPI’s which will guide their business policies in the future.
• Assisted the command center in resolving LMP EDW issues by interacting with End Users and coordinating with Team Confidential members.
• Created many documents such as the workarounds, DTP’s, SOP’s etc., to guide and assist the End Users in all the Confidential .
• Created several business process models spanning across many functional areas as a part of the Business Process Modeling Group. Also linked the workarounds, DTP’s, and SOP’s to the affected models in a graphically representative and visually useful manner.
• Published EDW Reports onto the LMP Portal for consumption by Enterprise Users across the world.
• Assisted in developing updated policies and procedures manual that included new ways for employees to approach several significant business processes.
• Assisted in creating presentations that were used to persuade management to consider more efficient business methods.

Confidential, Marlton, NJ

Senior SAP Consultant

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

Responsibilities:

• Conducted /Provided Site support on LMP EDW at various Confidential across the country and assisted the 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 the successful implementation of the EDW Sales Increment and developed 18 reports and 5 KPI’s. Provided the post go-live user /support and handled production support issues.
• As a part of D3 PDIT (Process and Data Integration Test) group, represented the BI team in performing duties such as: Data Loading, Conducting Budget and Finance Report Demos etc.
• Assisted the ‘CR 26060 CATS timesheet approval in upgrade’ process by closely working with the team, performing data analysis, data loads, data monitoring etc. and performing the unit tests, integration tests etc. in several environments.
• As a member of the D2 Regulatory Reports Team, performed requirements gathering, created the CRD’s, CDD’s, Tech and Functional Specs and did the developmental work. Participated in ARB Reviews and in inter-group meetings.
• ECC 6.0 Upgrade Project: Encompassed testing more than 1240 extractors in the 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 the unit tests, integration tests etc. in several environments. Participated in the Cutover activities and managed to successfully complete it, within the stipulated time period.
• Performed iDoc Monitoring, Analysis, and Processing using various transactions such as WE02, BD87 in conjunction with VA03, VA05, MB03, MB51, MD04, MM03, ZMMBE etc., throughout the course of the project.
• As a member of the Budgeting and Finance increment (CRDB24642), performed requirements gathering, created the CRD’s, CDD’s, Tech and Functional Specs and did the 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 the 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 the 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 the standard web template and implemented it in all the relevant landscapes for the entire EDW.
• The Enhancement and Configuration process, though strenuous, was successfully implemented after applying some OSS Notes and coordinated the effort with SAP International Tech Support group. The enhanced web template is the basis of 90% of LMP EDW standard and Ad-hoc reports. As a SAP BI consultant worked on the Forecast Accuracy Increment building a SAP BI 7.0 solution for the Forecast Accuracy KPI and Metrics reports.
• Designed and developed the solution for the Federal Government Funds Management reports with data feeds from Funds Management, Special Ledger, and Controlling.
• Created standard and Aging reports to fulfill the requirements. Assisted in analyzing business process data and creating reports that were presented directly to management. Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
• Developed the backend solution with DSO, Info Cubes and Multiproviders using ABAP for the data transformations.
• The report output was developed using BEX Query Designer and Web Application Designer through the SAP Enterprise Portal.
• Also involved in mentoring team members on using the SAP BI 7.0 new techniques like DTPs and Transformations, also involved in the end users and power users in using the applications at different locations.