SUMMARY:

• Co - ordinated and collaborated with project stakeholders to clearly define project objectives including functionality, timelines, and resource requirements
• Created and managed team work plan
• Lead development of project plan inclusive of definition of key gates, checkpoints and quality audits.
• Presenting monthly reports and resolutions to the director of development and marketing.
• Acquired customer projects, delivered case studies, and created and presented project proposals in the area of SAP BI
• Defined resource requirements and work with department counterparts to validate capacity availability.
• Managing changes to the project scope, project schedule, and project costs using appropriate verification techniques in order to keep the project plan accurate, updated, reflective of authorized project changes as defined in the change management plan, and facilitate customer acceptance.
• Obtain project plan approval from the customer in order to formalize the project management approach.
• Ensure a common understanding by setting expectations in accordance with the Project Plan, in order to align the stakeholders and team members.
• Measure project performance using appropriate tools and techniques in order to monitor the progress of the project, identify and quantify any variances, perform any required corrective actions, and communicate to all stakeholders.
• Implement the approved actions and workarounds required to mitigate project risk events in order to minimize the impact of the risks on the project.
• Execute the tasks as defined in the project plan in order to achieve the project goals.
• Record detailed customer requirements, constraints, and assumptions with stakeholders in order to establish the project deliverables, using requirement-gathering techniques (planning sessions, brainstorming, focus groups) and the project charter.
• Created Work Breakdown Structure (WBS) with the team using appropriate tools and techniques in order to develop the cost, schedule, resource, quality, and procurement plans.
• Established and maintained interpersonal relationships.
• Managed cost, schedule, and technical performance requirements of project teams through all phases from inception to completion (e.g., proposal review, planning, scheduling, installation, system acceptance, etc.).
• Performed risk/issue assessment, tracking, resolution and escalation to ensure project delivery.
• Provided direction and sets priorities to deliver to plans/budget and resolve day-to-day project issues.
• Reported budget status to project stakeholders
• Managed and maintained metrics and related processes for project teams
• Identified and secure resources and skills required to meet project plan and outcome.
• Provided information to others both internal and external to the organization; represents the organization to customers and other stakeholders. Demonstrates excellent written skills. Possesses good listening skills.
• Works with Business Unit business and technical staff and other cross-functional teams to ensure effective and timely execution projects.
• Extensive experience in designing Data Warehouse.
• Good knowledge in star schema and extended star schema.
• Good knowledge in ASAP Methodology.
• Sound experience and expertise in 6 complete life cycle Implementation of BW 7.3/7.4, 7.0,3.5 and 3.1, which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Info-cubes, Info-Source, Infoset, LO Cockpit, Multi-Cubes, Remote Cubes, DSO’s, BEx- Analyzer, BEx Query, Work books & Web reporting/ publishing in the functional areas extensively on FI-CO, CO-PA,FI-GL, Asset Accounting, Financial Planning and Analysis.
• Exposed to full software life cycle right from analysis, design specification, development, performance tuning, testing, documentation, maintenance, trouble-shooting, end user training etc.
• Maintained InfoPackages and monitored data load (Daily, Weekly and Bi-Monthly) depending on the requirements.
• Experience in Administrator Workbench (Modeling, Monitoring, Reporting Agent and Business Content.
• Successfully done version upgrade from BW 3.5 to BI 7.0
• Creating Web Reports using the Web application wizard of Web Application designer.
• Customized the InfoCubes (Basic Cube, Multi Cube, and Transactional Cube & Remote Cube), InfoSource and InfoObjects.
• Extensive experience in Performance Tuning and Creating Process chains.
• Sound knowledge in extending the Business content based on requirements
• Creation of metadata structures (Transfer and communication structure)
• Maintained Update and transfer rules and developed Routines at each level (InfoObject, Transfer structure, Update Rules, At Scheduler)
• Data Upload using flat files and SAP source system.
• Good understanding of Data Modeling for BPC
• Good understanding SAP-BW and SAP-BPC integration experience
• Have a better understanding and wide exposure to functional areas on SD, FI, CO and MM functional areas for implementing BW/BI data warehouse.
• Expert in building queries using filters, RKF, CKF, formulas in BEx Query Designer.
• Sound experience in Academy training.
• Expert in SAP BW, BOBJ BI4.0, Data Modeling, ETL and HANA Appliance.
• Proficient in SAP HANA 1.0 SP4 (configuration, Data provisioning, Information Modeling and BOBJ BI4 reporting tools).
• Worked on Data Provisioning tools like SAP landscape trigger based replication (SLT), Direct Extractor connection (DXC) and Business objects DS4 data services and developed several information models (Attribute Views, Analytical Views, Calculation Views, Procedures).
• Good exposure to ERP on HANA and also BW on HANA
• Solid expertise in developing reports with complex calculations using BEx Analyzer, Web Application Designer and Business Objects 4.0 tools like Crystal Reports, WEBI and Dashboard designer.

TECHNICAL SKILLS:

Software & Tools: SAP BW 7.3/7.4, SAP BW on HANA,SAP BI 7.0,BW3.x,SAP BOBJ,ABAP,VBA, Visio, MS Projects, Excel, Apache Hive, Apache SparkDatabases Oracle 9i/8i/8.0.5/7.x, FoxPro, NoSQL, MongoDB, CouchDB, NewSQL

Operating System: Windows, UNIX, Linux

Languages: Java, C++, C, C#, Python, R, Perl, MapReduce, Pig

Front-End Tools: Visual Basic

Other: HTML, Forms, Reports

PROFESSIONAL EXPERIENCE:

Sr Architect/PM

Confidential, Turlock, CA

Responsibilities:

• Created Work Breakdown Structure (WBS) with the team using appropriate tools and techniques in order to develop the cost, schedule, resource, quality, and procurement plans.
• Established and maintained interpersonal relationships.
• Managed cost, schedule, and technical performance requirements of project teams through all phases from inception to completion (e.g., proposal review, planning, scheduling, installation, system acceptance, etc.).
• Performed risk/issue assessment, tracking, resolution and escalation to ensure project delivery.
• Provided direction and sets priorities to deliver to plans/budget and resolve day-to-day project issues.
• Reported budget status to project stakeholders
• Managed and maintained metrics and related processes for project teams
• Identified and secure resources and skills required to meet project plan and outcome.
• Provided information to others both internal and external to the organization; represents the organization to customers and other stakeholders. Demonstrates excellent written skills. Possesses good listening skills.
• Works with Business Unit business and technical staff and other cross-functional teams to ensure effective and timely execution projects.
• Lead development of project plan inclusive of definition of key gates, checkpoints and quality audits.
• Presenting monthly reports and resolutions to the director of development and marketing.
• Acquired customer projects, delivered case studies, and created and presented project proposals in the area of SAP BI
• Defined resource requirements and work with department counterparts to validate capacity availability.
• Managing changes to the project scope, project schedule, and project costs using appropriate verification techniques in order to keep the project plan accurate, updated, reflective of authorized project changes as defined in the change management plan, and facilitate customer acceptance.
• Engaged with clients as SAP BI subject matter expert and successfully deployed business intelligence solutions to satisfy information requirements.
• Evangelized and advocated technical solutions.
• Delivered solutions within agreed timelines, costs and quality.
• Prepared and lead requirements gathering workshops.
• Lead the overall design of the data warehouse to ensure the data model supports information requirements, meets performance expectations and has the necessary flexibility to manage change.
• Lead the technical delivery of the data model, providing support to other consultants and client resources as necessary.
• Ensured the integrity, consistency and accuracy of the data supported by the business intelligence solution.
• Ensured functional and technical documentation is provided to secure a successful handover of the solution where appropriate.
• Ensured the BI solution supports ongoing business requirements/strategy.
• Driven ‘continuous improvement’ through evaluation of advances in SAP and complementary technologies.

Sr Project Manager/ Sr Architect

Confidential, Atlanta, GA

Responsibilities:

• Managing changes to the project scope, project schedule, and project costs using appropriate verification techniques in order to keep the project plan accurate, updated, reflective of authorized project changes as defined in the change management plan, and facilitate customer acceptance.
• Obtain project plan approval from the customer in order to formalize the project management approach.
• Ensure a common understanding by setting expectations in accordance with the Project Plan, in order to align the stakeholders and team members.
• Measure project performance using appropriate tools and techniques in order to monitor the progress of the project, identify and quantify any variances, perform any required corrective actions, and communicate to all stakeholders.
• Implement the approved actions and workarounds required to mitigate project risk events in order to minimize the impact of the risks on the project.
• Execute the tasks as defined in the project plan in order to achieve the project goals.
• Record detailed customer requirements, constraints, and assumptions with stakeholders in order to establish the project deliverables, using requirement-gathering techniques (planning sessions, brainstorming, focus groups) and the project charter.
• Created Work Breakdown Structure (WBS) with the team using appropriate tools and techniques in order to develop the cost, schedule, resource, quality, and procurement plans.
• Engaged with clients as a SAP BI subject matter expert and successfully deployed business intelligence solutions to satisfy information requirements.
• Evangelized and advocated technical solutions.
• Delivered solutions within agreed timelines, costs and quality.
• Prepared and lead requirements gathering workshops.

SAP BW, Architect/PM

Confidential, Pleasanton, CA

Responsibilities:

• Defined resource requirements and work with department counterparts to validate capacity availability.
• Managing changes to the project scope, project schedule, and project costs using appropriate verification techniques in order to keep the project plan accurate, updated, reflective of authorized project changes as defined in the change management plan, and facilitate customer acceptance.
• Obtain project plan approval from the customer in order to formalize the project management approach.
• Ensure a common understanding by setting expectations in accordance with the Project Plan, in order to align the stakeholders and team members.
• Measure project performance using appropriate tools and techniques in order to monitor the progress of the project, identify and quantify any variances, perform any required corrective actions, and communicate to all stakeholders.
• Implement the approved actions and workarounds required to mitigate project risk events in order to minimize the impact of the risks on the project.
• Execute the tasks as defined in the project plan in order to achieve the project goals.
• Record detailed customer requirements, constraints, and assumptions with stakeholders in order to establish the project deliverables, using requirement-gathering techniques (planning sessions, brainstorming, focus groups) and the project charter.
• Created Work Breakdown Structure (WBS) with the team using appropriate tools and techniques in order to develop the cost, schedule, resource, quality, and procurement plans.
• Established and maintained interpersonal relationships.
• Managed cost, schedule, and technical performance requirements of project teams through all phases from inception to completion (e.g., proposal review, planning, scheduling, installation, system acceptance, etc.).
• Analyzed the whole system and identified the bottle necks in delay for loads
• Analyzed the objects and their dependencies for loading and data lookups in the system
• Analyzed the system utilization and analyzed the to-be design through prototypes
• Designed the new process chains based on the dependency and analyzed the system performance and compared the major advantage.
• Identified the DSO’s with SID selection and are not used in reporting to deactivate the check.
• Redesigned the data model with a DSO layer where there are full loads to avoid the full loads to load till through the up line
• Developed a Run book for the system maintenance and system house keeping
• Created an internal wiki with all the relevant information of the system and relative fundamentals for reference
• Introduced routine for infopackages selection where there is a manual changes periodically to reduce the maintenance
• Minimize risk of re-load because of your logic issues
• Separate daily loads from weekly, monthly, annual and ad-hoc loads
• Within each frequency group, identify the critical path, and remove non-essential loads
• Documented the Data Flow Diagrams
• Minimize parallel updates to BWA
• Maximized the parallel loads to finish the loads earlier
• Achieved a 30% betterment in the complete data load process

Environment: SAP BI 7.0

Business Areas: SCM

Confidential, Milpitas, CA

SAP BW/HANA, Architect

Responsibilities:

• Analyzed, Defined, Designed and Managed the Product
• Analyzed the market requirements in order to achieve the product ability of the OTC Dashboard for the C level executives
• Defined the features and functionalities required to be part of the first release
• Prioritized the requirements and defined the release dates for the versions
• Designed the Joins
• Designed the Dashboard look and feel
• Defined the Project Management plan
• Executed the project plan assigning the tasks to different team members
• Designed information models (Attribute Views, Analytical Views, Calculation Views, and Procedures).
• Developed the Objects - Attribute Views, Analytical Views, Calculation Views, Procedures
• Achieved the delivery of the product with zero deviation on time and quality

Environment: SAP HANA, SAP BW 7.3

Business Areas: SCM

SAP BW, Architect/PM

Confidential, Pleasanton, CA

Responsibilities:

• Lead a team of 7 BI resources, both onsite and offshore as Tech Lead
• Analyzed, Defined, and developed the steps to be followed for achieving the OS/DB migration for SAP BW without disrupting the Business.
• Identified risk and proposed mitigation steps
• Developed test scripts in order to validate the data is fine in the production after migration
• Defined and Executed the Pre and Post Migration Checks for the Quality of the migration and the server at every step
• Developed the test strategy, test plan, test files, and scripts for data warehouse testing, unit testing and integration testing.
• Cookbooks for step by step running of the tests,
• Developed Standard templates for capturing the outputs and compare to the expected output
• Reviewed the work done by the team and corrected / directed them when required.
• Handled the technical issues while doing the testing for Migration
• Managed the team and coordinated the onsite and offshore teams with change in the plans and delays with in the other processes.

Environment: SAP BI 7.0

Business Areas: SCM

Confidential, Milpitas, CA

SAP HANA, Architect

Responsibilities:

• Understood the existing product
• Defined the AS-IS and to-Be features in the product.
• Developed a detailed Resource plan, Risk assessment, product roll out plan.
• Executed the Releases of Product versions as per the developed product/project plan.
• Identified the gaps in the product and the market requirement
• Designed information models (Attribute Views, Analytical Views, Calculation Views, Procedures) required for the changes
• Managed a team of 6 Developers and Leads for different releases of the product.

Environment: SAP HANA, SAP ECC 6.0

Business Areas: SCM

SAP BW/BI-BOBJ, Architect

Confidential, New York City, New York

Responsibilities:

• The scope of the data warehouse is only the functional areas of FI-GL, FI-CO and FI-AA.
• Design, implement, and operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
• Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
• Create or implement metadata processes and frameworks.
• Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
• Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Design and implement warehouse database structures.
• Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
• Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
• Map data between source systems, data warehouses, and data marts.
• Select methods, techniques, or criteria for data warehousing evaluative procedures.
• Verify the structure, accuracy, or quality of warehouse data.
• Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
• Prepare functional or technical documentation for data warehouses.
• Provide or coordinate troubleshooting support for data warehouses.
• Review designs, codes, test plans, or documentation to ensure quality.
• Test software systems or applications for software enhancements or new products.
• Generate standard and custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
• Synthesize current warehouse or trend data to support recommendations for action.
• Analyze technology trends to identify markets for future product development or to improve sales of existing products.
• Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.
• Manage timely flow of business intelligence information to users.
• Communicate with customers, competitors, suppliers, professional organizations, and others to stay abreast of industry or business trends.
• Create or review technical design documentation to ensure the accurate development of reporting solutions.
• Maintain library of model documents, templates, or other reusable knowledge assets.
• Provide technical support for existing reports, dashboards, or other tools.
• Review project plans to plan and coordinate project activity.
• Manage backup, security and user help systems.
• Meet with department heads, managers, supervisors, vendors, and others, to solicit cooperation and resolve problems.
• Provide users with technical support for computer problems.
• Recruit, hire, train and supervise staff, or participate in staffing decisions.
• Evaluate data processing proposals to assess project feasibility and requirements.
• Review and approve all systems charts and programs prior to their implementation.
• Direct daily operations of department, analyzing workflow, establishing priorities, developing standards and setting deadlines.
• Assign and review the work of systems analysts, programmers, and other computer-related workers.
• Evaluate the organization's technology use and needs and recommend improvements, such as hardware and software upgrades.
• Prepare and review operational reports or project progress reports.

Environment: SAP BW 7.3/7.4, BI 7.0, SAP BW on HANA, SAP ECC 6.0

Business Areas: FI, CO, AA

SAP BI, Architect

Confidential

Responsibilities:

• Initial requirement gathering, understanding the requirements and the gaps between the information provided and information required by doing gap analysis .
• The Technical Architect is responsible for developing and maintaining the overall technical architecture
• Responsible for providing leadership and management of all technical activities System Change Management, Performance Monitoring, Performance Tuning, Transport Management, Data Management, Data Archiving, system Administration & Monitoring, User administration, Security, Development and Testing, troubleshooting,Problem Analysisand Problem Resolution.
• As a BI Architect, have been a coach and advised other BI team members and analysts in the company on information availability and appropriate tools and Solutions.
• Designing the template by differentiating the global template and local template.
• Handling a team of 16 developers and senior consultants.
• Design, develop and implement extensions of global SAP BW reporting architecture.

Environment: SAP BI 7.0, SAP ECC 6.0

Business Areas: FI, PP, QM

SAP BI, Architect

Confidential, Parsippany, New Jersey

Responsibilities:

• Initial requirement gathering, understanding the requirements and the gaps between the information provided and information required by doing gap analysis .
• Effort estimation based on the requirements and been an active part of the resourcing and budgeting.
• Conversion of the functional specifications to the initial mockup.
• Understanding the complete data requirement to fulfill the requirements. Designing the Data warehouse Architecture and developed the conceptual and physical Data Models. conversion of the functional specifications to Technical Specifications
• Handling a team of 16 developers to develop the reports in an onsite-offshore model.
• Design, develop and implement extensions of global SAP BW reporting architecture, including process chains and creation of multi-providers extracting data from SAP ECC and other applications.
• Design and develop business intelligence applications utilizing SAP BI (BEx and WAD).
• Support implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
• Add value to business each day by providing the right information to the right people at the right time
• As a BI Architect, have been a coach and advised other BI team members and analysts in the company on information availability and appropriate tools and Solutions.
• Handling the deliveries from Onsite, conducting workshops on the developed reports for signing off the requirements and also the user training sessions.
• Worked within business line to gather the needs and translated them into a Data Warehouse solution and been the key in defining the data warehouse Architecture.
• Designed the Data warehouse Architecture and developed the conceptual and physical Data Models.
• Delivered around 80 reports on different functional areas like, Cost Center Accounting, Profit center Accounting, T&E, Procurement, Inventory Analysis, and SD.
• The whole Data warehouse Architecture has been built following the extended start Schema and understanding of the data required and their relation using Bubble model and ER Models.
• Worked within business line and the IT team to define BI reporting solution
• Provided strategies and the Data Warehousing Best Practices.
• Provided the ETL team with the strategy load for the confirmed and slowly changing dimensions.
• Served as the data technical strategy expert and lead the creation of all ETL specifications
• Reviewed the ETL code and tuned mappings and workflows for better performance.
• Performance tuning of the InfoCubes for T&E implementation and has achieved a remarkable difference in Dimensional space utilization from 98% to 22% by redoing the dimensional modeling.
• Been part and owner for few objects for Change Management and control.

Environment: SAP BI 7.0, SAP ECC 6.0

Business Areas: FI, CO, PP, SD,MM, QM