SUMMARY:

• Highly Technical, decisive, action - oriented and result-focused, Project Management Professional (PMP) offering 17+ years of IT, 15 years of SAP BW Architect/Technical Lead, DB management, with nearly 17 years of experience in Data Modeling, Extraction, Performance tuning, Configuration and reporting in BI/BW (NetWeaver BI 7.3, BW 3.1 / 3.5, BOBJ). Extensive experience with several full SAP life cycle implementations of SAP BW FI/CO/SD.
• 23+ Years of IT 17 Years SAP (BW, R/3 and ABAP) 13 Years of Database Administration (SQL Server 2008/2005/2000/7.0 , Oracle 9i/8.x) 10 Years of Data Warehousing Architecture (Complete BI solutions, using Hyperion, COGNOS-PowerPly, Transformer, Impromptu, Reportnet, BO XI, Informatica-PowerCenter (7.x/6.x/5.x), MSIS/MSAS, DTS, AllFusion/Erwin).
• 6 Year of Project Management (Data Warehouse, Database management, Infrastructure management)
• 6 Years of Database Architect/Designer (Erwin, AllFusion, Designer 2000, Visio 2003/200) 5 Years of Web Designing (ASP, HTML, XML, JavaScript, VBScript, VB, COM, COM+) 5 Years of Reporting (BO XI, Hyperion, OLAP Reporting, Crystal Report 10.0, Active Reports, Cognos ReportNet, Impromptu, BEx Analyzer) 15 years of version control using MS Visual Sourcesafe, Sharepoint 2K+
• 3 upgrades from 3.5 to 7.x
• Especially talented in all aspects of performance tuning.
• Created BO dashboard reports (Xcelcisus, Crystal Reports)
• Developing web based reports HTML, JavaScript, SAP Web Development tools Using third party reporting tools such as Crystal Reports, business Objects, Cognos etc.
• Configured and supported the SAP BI Reporting environment and broadcasting
• Developed and validated reports, Experienced with report validation methodologies and user acceptance testing.
• Good analytical problem solving and communication skills
• Designed and developed data extracts from SAP and non-SAP systems.
• Documented new processes impacting BW and communicate changes to business Unit financial analysts.
• Good business process skills with ERP to include FICO, SD, IM, PP
• Good working knowledge of SAP BI back-end technology includes cube builds, data loads and error handling.
• Excellent understanding of SAP database structures and core functionality.
• Excellent hands on knowledge of developing queries using SAP BI front end tools.
• Worked with business owners to define and analyze reporting and analytic requirements. o
• Experience in working with a diverse and integrated team consisting of application developers, technical business users and business analysts.
• Performed Project management roles.
• Data modeling (Multidimensional Data Model using Extended Star Schema).
• Designed and developed Infocubes, ODS, InfoSource, InfoObjects and DataSources.
• Created Transfer rules and Update rules for InfoSources and InfoCubes.
• Created Data Targets and InfoProviders.
• ETL((Extraction Transformation and Loading) process.
• Creating, tuning and debugging aggregates query specific and cube specific.
• Created Data Mart Interface, Virtual Cubes and MultiProviders.
• Uploaded Master data, Transaction data and Hierarchical data into the SAP BW.
• Performance tuning using Aggregates, Rollups, Partition and Compression.
• Managed User Authorization.
• Archived Data from BasicCubes and ODS Objects.
• Scheduled and Monitored Data loading process within BW
• CRM project analysis and implementation.
• NetWeaver 04S upgrade planning and testing.
• Highly experienced with transport procedures including emergency transport.
• Very good experience on performance tuning on PSA and other parameters.
• Experienced in working on small fast pace project teams.
• Ability to work under pressure and adhere to deadlines.
• Strong analytical, troubleshooting, and problem solving abilities.
• Excellent communication and documentation skills, strong business experience, and outstanding end-user interaction.
• Experienced in managing off-shore resources.
• Dialog Programming and Maintenance (Screen Painter, Menu Painter).
• Interface Programming (File Handling, BDC using either Batch Session or CALL Transaction).
• Developed classical On-line, Interactive and Batch Reports.
• Very good knowledge of ABAP Query, Job creation and Scheduling and Quick Viewer.
• Experience in RFC s, ALE, IDOC’s, SAP Script and SMARTFORMS based layout.
• Experience in extraction of HR, FI/CO, SD and MM into BW

TECHNICAL SKILLS:

SAP R/3 & BWETL TOOLS: SAP R/3 (3.1H, 4.5b, 4.6c), FI/CO,GL Informatica Power-Center (9.x/8.x/7.x/6.x/5.x) BI/BW 7.0/3.5, ABAP, BAPI, BADI, BDC Business Objects (XI/3.x/5.x) EDI/IDOC, Solution Manager, SAP HANA Cognos-Impromptu/Powerply/Transformer BI Docu Performer Cognos ReportNet MS Analysis Services/SSIS/MS DTS/MS Reporting Veritca, Hadoop, Hyperion Business Object Data Services

DATABASESMODELLING METHODOLOGY: MS SQL Server 2008/2005/2K/7.0 Kimball Star schema, Snowflake Schema ORACLE 10g/9.0/8x ASAP, RAPID MS Access, SAP HANA WEB

DEVELOPMENTDESIGNER & MODELING TOOLS: ASP, HTML, XML, JavaScript, VBSCript ERWin, AllFusion, Visio 2003/2000 WAD

REPORTING TOOLSPROJECT MANAGEMENT: BO Dashboard Builder Microsoft Project 2003/2000 BO Web Intelligence/Widgets Visio 2003/2000, MS Office 2003/2000 OLAP Reporting, Active Reports, Cognos PMI, AGILE(SCRUM), SDLC Crystal Reports (10.x, 9.x, 8.x 6.x)

VERSION CONTROL TOOLS: MS Visual Source Safe Sharepoint (2010/2013)

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. SAP BW Architect/Lead

Responsibilities:

• Plan, develop and implement state of the art BI solution for the Confidential enterprise software.
• Manage cross-functional teams with diverse technical backgrounds.
• Properly channeled and managed HPSM ticket system to make sure BI team addresses tickets in an appropriately and timely manner.
• Provide oversight for IT operations, support desk, service calls and escalated problem resolution.
• Responsible for all aspects of SAP BW/BI Technical Manager role of Confidential Enterprise Software. We are heavily integrated with SAP, SAP BW, BO, Salesforce, Informatica, and reporting with Tableau MS BI and SAP BO.
• Responsible for Integrating SAP with SalesForce using Informatica
• Integrated SAP with SalesForce using other tools (MuleSoft)
• SAP BW being the hub for all reporting solutions, created a large repository of clean data within BW for entire enterprise reporting solutions.
• Successfully designed a budget control program to help business to implement fast decision making solution.
• Oversee and evaluate, deployment and administration of all Information Technology software, hardware, database and network systems within the corporation.
• Determine all IT policies and procedures with oversight for administration of user permissions, security levels and technical accountability.
• Involved in the requirement process of all offshore and onsite staff to make sure right candidate is selected and developing teams and leaders to ensure that business value is maximized and IT goals are achieved.
• Plan and design IT systems architecture, operating platform and network systems infrastructure.

Confidential, Alpharetta, GA

BI Technical Manager

Responsibilities:

• Provide all technical support in the BI toolset (SAP/BW/SQL Server/Oracle/Informatica 9.5.1)
• Managing the resources (contractors and employees)
• Aligning the Das/TAs/Bas and developers
• Gathering and reviewing requirements, provide technical supports
• Conduct Architectural review, modeling review etc.,
• Building and maintaining interlocks (cross functional team) to ease the implementation of the projects
• Manage the deployment and setup business training
• Involved in migration of Hadoop/Vertica

Confidential, Dunwoody, GA

Sr. Consultant/BI Lead

Tools: SAP BW 7.3/ECC 6.0

Responsibilities:

• Primarily on the back-end BI design and development, creating, reviewing and approving technical specs/transports, performance tuning, data load monitoring and management, allocating team for prod support, upgrade testing, creating test scripts. Review process chains, Infopacks, DTPs for performance improvements on an ongoing basis.
• Responsible for implementing T & E project using BOBJ DS, SAP BI and SQL Server 2008. Have done entire design and development.
• Responsible for the technical/production support for the Informatica extraction of tax data from and to of archived systems.

Confidential, Charlotte, NC

SAP BI Lead

Responsibilities:

• Provide guidance in the design and development of BI models and reporting solution to the company.
• Provide skills amongst the BW team through mentoring and oversight activities.
• Provide data modeling and detailed requirements analysis to meet business requirements.
• Designing, testing and deploying Dashboard/cockpit reporting solutions.
• Collaborate with developers, users, business owners and operations engineers to ensure creation of best Business Intelligence designs and implementations for the business.
• Guide Management and the team to arrive best reporting solution using up to date SAP BI technology.
• Provide best performance tuning techniques and approaches to the team.
• Provide BASIS/DBA Support to the team as needed.
• Provide guidance to applying service packs and patches to get maximum benefits out of the SAP BI applications.
• Guide the team and the management through the full lifecycle of BI project efforts.
• Research and evaluate software and hardware to enhance the development environment and process.
• Creating best reporting solution for the Enterprise (created Infoproviders, Converted Bex reports to BO reports)

Confidential, Plano, TX

SAP BW TECHNICAL LEAD

Responsibilities:

• Responsible for system administration and support of technical architecture, including Basis support of SAP R/3 and BW platforms, with the goal of providing excellent system reliability, performance, high availability and overall optimized systems.
• Provide SAP Basis administration Support, Performance monitoring & tuning, Problem analysis & resolution, and other activities required to maintain system integrity and maximize uptime.
• Performed trouble shooting on R/3 security problems by using system traces.
• Plan and execute transports.
• Experience in applying Support Packs and Upgrades for SAP modules.
• Setup, schedule and monitor batch jobs and interfaces.
• Leading a team of 5, including 2 off-shore members
• Provide technical support on developments and administration for COPA and FI/GL
• Attending all data load and performance issues in and R/3 and BW team
• Evaluation of the existing processes and reporting solutions
• Impact analysis of the upgrade on the existing applications and interfaces
• Update and/or create functional specification documents
• Create test plan and perform testing unit through integration
• Trouble shooting including OSS management
• Document new processes and procedures
• Perform Go-Live production support
• Providing strategic planning for data storage management
• Building the best data models for the enterprise
• GAP Analysis and Planning the business requirements gathering sessions and processes
• Understanding and implementing the standards and procedures across all environments
• Ensure data integration across all platforms
• Model and develop the best InfoProviders (ODS, Cube, Multicube, InfoSet) for the reporting solution.
• Propose and make use of aggregation at appropriate levels.
• Provide database administration support and basis support to the team.
• Apply performance tuning techniques
• Facilitate Migration and upgrade planning sessions (upgraded from BW 3.5 to BI 7), SQL Server 2000 to 2005.

Confidential, Plano, TX

SAP BW TECHNICAL LEAD

Responsibilities:

• Understanding and translating user requirements into technical documents and GAP Analysis
• Applying RAPID/ASAP methodologies to deliver the solution quickly
• Creating necessary InfoObjects for the BAP Sales Summary reports
• Enabling existing manual reporting of BAP Sales into BW
• Provide the solution of BW as the hub to the hub and spoke model
• Analysis of enabling SQL reporting services to produce reports
• Design and develop reporting models and InfoProviders for BAP Sales.
• Creating custom update rules for conversions and date manipulations.
• Automating data load processes.
• Working with extractors
• Created Bex reports to simulate existing BAP Summary report.
• Developed white papers on DB issues and reporting solutions. developed white papers on performance tuning.
• Manage offshore team, giving directions to the consultants.
• Managing standard and customer extractors
• Analysis and design of extractors for HR, FICO, SD and MM
• Mostly worked on FI-CO/GL
• Upgraded 3.5 to BI 7.0

Confidential, Rockwall, TX

SAP BW TECHNICAL LEAD

Responsibilities:

• Worked on functional configuration and development in FI/CO-FI-GL.
• Designing, implementing and supporting complex reports, layouts, development of planning areas, multi-planning areas, version planning, planning levels, packages and folders and data slices and development of planning functions.
• Provided go-live Production Support, expertise with SAP BW (BI) terminology, structure and functionality.
• Supported a BPS/BCS/CPM environment including accuracy of the data.
• Created FMs and routines needed for BCS/BPS
• Performance tuning and partitioning of COPA, CCA cubes
• Worked on Net Weaver 04s upgrade process
• Implementing alternative solutions on reporting and ETL within the SAP/BW landscape.
• Work with Basis and DBAs
• Upgraded SQL Server 2000 into 2005
• Transporting objects to QA and Production (both R/3 and BW)

Confidential, Raleigh, NC

PROJECT MANAGER

Responsibilities:

• Delivering consulting solutions to the clients
• Understanding existing ETL and reporting model
• Proposing and working with existing resources on Enterprise Data models
• Implementing best DW models for the enterprise
• Team co-ordination and management
• Analysis on third party tools to best fit for the business (clients)
• Delivering DBA duties

Confidential, BlockBuster, TX

PROJECT MANAGER/DW Consultant

Responsibilities:

• Involved in creating Sales, Billing, Shipping, Finance and Profitability Analysis infocubes. Created and maintained CO-PA data sources at SAP OLTP source and extracted data into Consumer, Goods, Industry, and Financial Key Measure infocubes after creating transfer rules, infopackages and update rules.
• Managed & Monitored several data Loadings and optimized the performance by adjusting Packet Size and data Selections.
• Involved in working with FI-SL (Financial - Special Purpose Ledgers) extractors. Created sales ledger and extracted the sales data for a given posting period.
• Extensively involved in customizing and activating standard delivered BW business content in the areas of LO extractors.
• Worked extensively on administration workbench. Analyzed InfoCubes created and maintained aggregates to improve the performance.
• Worked extensively on standard and custom defined LO and LIS extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery billing information.
• Worked extensively on Bex Query Designer. Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Built queries on Monthly Incoming Orders, Top ‘N’ Customers, Order/Delivery/ Sales Quantities, Price trends over the last ‘N’ months and Slow moving Items.
• Created custom queries using variables and structures, Worked on Web Reporting and Web publishing.
• Defined the strategy and architect data structures and processing required to generate and deliver strategic information as well as Key Performance Indicators (KPI).
• Designed and developed Global Business warehouse and extracted data from Financials systems (Both R/3 and Legacy).
• Created, activated and worked on a daily basis with Extractors, Generic Extractors, LIS, Generic Data Sources, Info sources, Transfer Rules, Update Rules, Info packages, Info package Groups, Info objects, ODS, Info cubes, ODS Structures, Queries, Variables, Calculated & Restricted Key Figures.
• Developed Global info cubes, Multi cubes, Transactional Info cubes, ODS objects and extracted Master data and Transaction Based Data in FI/CO Info areas (CO-CCA, CO-PC, EC-CS/EC-PCA, FI-GL).
• Arrange meetings and JAD sessions to analyze and study business requirements.
• Convert the business requirements into different levels of technical diagram.
• Produce prototypes based on the understanding of requirements.
• Produce and follow standards and procedures.
• Understand and follow companywide SDLC standards and procedures.
• Enterprise Business Model using Erwin
• Keep open scope for extensibility
• Identifying and relating business objects
• Design base tables for DW
• Design Star schemas for Data Marts
• Extraction, Transformation and Load was performed using Informatica PowerCenter to build the data warehouse.
• Identify available source system for Atomic Data · Accomplished automated data extraction from various RDBMS/ Heterogeneous via scripts(COM, XML, SPs), ETL processing using Informatica and loading into Oracle Data warehouse.
• Made accessible of data from third parties, creating new VB COMs, modifying existing COMs based on the business requirements.
• Homogenize data while loading
• Design and development of PL/SQL Stored Procedures using dynamic SQL for checking existence of partitions and creating them with appropriate values in the case of their absence.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the Oracle 8 data warehouse.
• Created Repository and User groups Using Repository Manager.
• Performance Tuning of the Data Warehouse.
• Creating and running sessions & Batches using Server Manager to load the data into the Target Database.
• Modeling and creating power play cubes using Transformer.
• Creating Multi-Dimensional reports using Power Play.
• Designing and Developing Catalogs, Query data from different database tables and creating join per the requirements.
• Customizing data by adding calculations, summaries and functions.
• Implementing filters, prompts, sub reports and Formatting.
• Creating List Reports and Cross Tab Reports, standard and free style reports.
• Publishing Cognos ReportNet Reports on Web in HTML format.