SUMMARY OF EXPERIENCE:

• Co - ordinated and collaborated with project stakeholders to clearly define project objectives including functionality, timelines, and resource requirements
• Lead development of project plan inclusive of definition of key gates, checkpoints and quality audits.
• Presenting monthly reports and resolutions to teh director of development and marketing.
• Acquired customer projects, delivered case studies, and created and presented project proposals in teh area of SAP BI
• Defined resource requirements and work with department counterparts to validate capacity availability.
• Managing changes to teh project scope, project schedule, and project costs using appropriate verification techniques in order to keep teh project plan accurate, updated, reflective of authorized project changes as defined in teh change management plan, and facilitate customer acceptance.
• Obtain project plan approval from teh customer in order to formalize teh project management approach.
• Ensure a common understanding by setting expectations in accordance with teh Project Plan, in order to align teh stakeholders and team members.
• Measure project performance using appropriate tools and techniques in order to monitor teh progress of teh project, identify and quantify any variances, perform any required corrective actions, and communicate to all stakeholders.
• Implement teh approved actions and workarounds required to mitigate project risk events in order to minimize teh impact of teh risks on teh project.
• Execute teh tasks as defined in teh project plan in order to achieve teh project goals.
• Record detailed customer requirements, constraints, and assumptions with stakeholders in order to establish teh project deliverables, using requirement-gathering techniques (planning sessions, brainstorming, focus groups) and teh project charter.
• Created Work Breakdown Structure (WBS) with teh team using appropriate tools and techniques in order to develop teh 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 teh organization; represents teh 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 noledge in star schema and extended star schema.
• Good noledge 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 teh 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 teh 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 teh Web application wizard of Web Application designer.
• Customized teh InfoCubes (Basic Cube, Multi Cube, and Transactional Cube & Remote Cube), InfoSource and InfoObjects.
• Extensive experience in Performance Tuning and Creating Process chains.
• Sound noledge in extending teh 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 teh team using appropriate tools and techniques in order to develop teh 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 teh organization; represents teh 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 teh director of development and marketing.
• Acquired customer projects, delivered case studies, and created and presented project proposals in teh area of SAP BI
• Defined resource requirements and work with department counterparts to validate capacity availability.
• Managing changes to teh project scope, project schedule, and project costs using appropriate verification techniques in order to keep teh project plan accurate, updated, reflective of authorized project changes as defined in teh 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 teh overall design of teh data warehouse to ensure teh data model supports information requirements, meets performance expectations and has teh necessary flexibility to manage change.
• Lead teh technical delivery of teh data model, providing support to other consultants and client resources as necessary.
• Ensured teh integrity, consistency and accuracy of teh data supported by teh business intelligence solution.
• Ensured functional and technical documentation is provided to secure a successful handover of teh solution where appropriate.
• Ensured teh 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 teh project scope, project schedule, and project costs using appropriate verification techniques in order to keep teh project plan accurate, updated, reflective of authorized project changes as defined in teh change management plan, and facilitate customer acceptance.
• Obtain project plan approval from teh customer in order to formalize teh project management approach.
• Ensure a common understanding by setting expectations in accordance with teh Project Plan, in order to align teh stakeholders and team members.
• Measure project performance using appropriate tools and techniques in order to monitor teh progress of teh project, identify and quantify any variances, perform any required corrective actions, and communicate to all stakeholders.
• Implement teh approved actions and workarounds required to mitigate project risk events in order to minimize teh impact of teh risks on teh project.
• Execute teh tasks as defined in teh project plan in order to achieve teh project goals.
• Record detailed customer requirements, constraints, and assumptions with stakeholders in order to establish teh project deliverables, using requirement-gathering techniques (planning sessions, brainstorming, focus groups) and teh project charter.
• Created Work Breakdown Structure (WBS) with teh team using appropriate tools and techniques in order to develop teh 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 teh project scope, project schedule, and project costs using appropriate verification techniques in order to keep teh project plan accurate, updated, reflective of authorized project changes as defined in teh change management plan, and facilitate customer acceptance.
• Obtain project plan approval from teh customer in order to formalize teh project management approach.
• Ensure a common understanding by setting expectations in accordance with teh Project Plan, in order to align teh stakeholders and team members.
• Measure project performance using appropriate tools and techniques in order to monitor teh progress of teh project, identify and quantify any variances, perform any required corrective actions, and communicate to all stakeholders.
• Implement teh approved actions and workarounds required to mitigate project risk events in order to minimize teh impact of teh risks on teh project.
• Execute teh tasks as defined in teh project plan in order to achieve teh project goals.
• Record detailed customer requirements, constraints, and assumptions with stakeholders in order to establish teh project deliverables, using requirement-gathering techniques (planning sessions, brainstorming, focus groups) and teh project charter.
• Created Work Breakdown Structure (WBS) with teh team using appropriate tools and techniques in order to develop teh 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 teh whole system and identified teh bottle necks in delay for loads
• Analyzed teh objects and their dependencies for loading and data lookups in teh system
• Analyzed teh system utilization and analyzed teh to-be design through prototypes
• Designed teh new process chains based on teh dependency and analyzed teh system performance and compared teh major advantage.
• Identified teh DSO’s with SID selection and are not used in reporting to deactivate teh check.
• Redesigned teh data model with a DSO layer where their are full loads to avoid teh full loads to load till through teh up line
• Developed a Run book for teh system maintenance and system house keeping
• Created an internal wiki with all teh relevant information of teh system and relative fundamentals for reference
• Introduced routine for infopackages selection where their is a manual changes periodically to reduce teh maintenance
• Minimize risk of re-load coz of you're logic issues
• Separate daily loads from weekly, monthly, annual and ad-hoc loads
• Within each frequency group, identify teh critical path, and remove non-essential loads
• Documented teh Data Flow Diagrams
• Minimize parallel updates to BWA
• Maximized teh parallel loads to finish teh loads earlier
• Achieved a 30% betterment in teh complete data load process
• Analyzed, Defined, Designed and Managed teh Product
• Analyzed teh market requirements in order to achieve teh product ability of teh OTC Dashboard for teh C level executives
• Defined teh features and functionalities required to be part of teh first release
• Prioritized teh requirements and defined teh release dates for teh versions
• Designed teh Joins
• Designed teh Dashboard look and feel
• Defined teh Project Management plan
• Executed teh project plan assigning teh tasks to different team members
• Designed information models (Attribute Views, Analytical Views, Calculation Views, and Procedures).
• Developed teh Objects - Attribute Views, Analytical Views, Calculation Views, Procedures
• Achieved teh delivery of teh product with zero deviation on time and quality

Environment: SAP HANA, SAP BW 7.3

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 teh steps to be followed for achieving teh OS/DB migration for SAP BW without disrupting teh Business.
• Identified risk and proposed mitigation steps
• Developed test scripts in order to validate teh data is fine in teh production after migration
• Defined and Executed teh Pre and Post Migration Checks for teh Quality of teh migration and teh server at every step
• Developed teh test strategy, test plan, test files, and scripts for data warehouse testing, unit testing and integration testing.
• Cookbooks for step by step running of teh tests,
• Developed Standard templates for capturing teh outputs and compare to teh expected output
• Reviewed teh work done by teh team and corrected / directed them when required.
• Handled teh technical issues while doing teh testing for Migration
• Managed teh team and coordinated teh onsite and offshore teams with change in teh plans and delays with in teh other processes.
• Understood teh existing product
• Defined teh AS-IS and to-Be features in teh product.
• Developed a detailed Resource plan, Risk assessment, product roll out plan.
• Executed teh Releases of Product versions as per teh developed product/project plan.
• Identified teh gaps in teh product and teh market requirement
• Designed information models (Attribute Views, Analytical Views, Calculation Views, Procedures) required for teh changes
• Managed a team of 6 Developers and Leads for different releases of teh product.

Environment: SAP HANA, SAP ECC 6.0

SAP BW/BI-BOBJ, Architect

Confidential, New York City, New York

Responsibilities:

• Teh scope of teh data warehouse is only teh 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 teh 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 teh 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 teh accurate development of reporting solutions.
• Maintain library of model documents, templates, or other reusable noledge 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 halp 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 teh work of systems analysts, programmers, and other computer-related workers.
• Evaluate teh organization's technology use and needs and recommend improvements, such as hardware and software upgrades.
• Prepare and review operational reports or project progress reports.
• Initial requirement gathering, understanding teh requirements and teh gaps between teh information provided and information required by doing gap analysis .
• Teh Technical Architect is responsible for developing and maintaining teh 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 teh company on information availability and appropriate tools and Solutions.
• Designing teh template by differentiating teh 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

SAP BI, Architect

Confidential

Responsibilities:

• Initial requirement gathering, understanding teh requirements and teh gaps between teh information provided and information required by doing gap analysis .
• Effort estimation based on teh requirements and been an active part of teh resourcing and budgeting.
• Conversion of teh functional specifications to teh initial mockup.
• Understanding teh complete data requirement to fulfill teh requirements. Designing teh Data warehouse Architecture and developed teh conceptual and physical Data Models.
• conversion of teh functional specifications to Technical Specifications
• Handling a team of 16 developers to develop teh 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 teh right information to teh right people at teh right time
• As a BI Architect, have been a coach and advised other BI team members and analysts in teh company on information availability and appropriate tools and Solutions.
• Handling teh deliveries from Onsite, conducting workshops on teh developed reports for signing off teh requirements and also teh user training sessions.
• Worked within business line to gather teh needs and translated them into a Data Warehouse solution and been teh key in defining teh data warehouse Architecture.
• Designed teh Data warehouse Architecture and developed teh 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.
• Teh whole Data warehouse Architecture has been built following teh extended start Schema and understanding of teh data required and their relation using Bubble model and ER Models.
• Worked within business line and teh IT team to define BI reporting solution
• Provided strategies and teh Data Warehousing Best Practices.
• Provided teh ETL team with teh strategy load for teh confirmed and slowly changing dimensions.
• Served as teh data technical strategy expert and lead teh creation of all ETL specifications
• Reviewed teh ETL code and tuned mappings and workflows for better performance.
• Performance tuning of teh InfoCubes for T&E implementation and has achieved a remarkable difference in Dimensional space utilization from 98% to 22% by redoing teh dimensional modeling.
• Been part and owner for few objects for Change Management and control.
• Worked extensively on creating Info Objects, Info Sources and Extraction.
• Experienced in working with Business Explorer (BEx) and publishing teh reports on web using Web Reporting tools.
• Uploaded Master and Transactional data from flat files and SAP R/3.
• Extracted data using flat files for raw materials in order to track inventory.
• Used Business content Extractor for MM master data sources 0PLANT, 0MATSALES.
• Performed Data extraction from R/3 (LO Extraction) and Flat files.
• Stored data from R/3 tables into ODS objects through PSA to perform detailed level reporting.
• Worked on job schedules for loading data and monitoring Process Chains to run periodic loads (Daily, Weekly and Bi-Monthly).
• Created Multi providers to enhance teh reporting base.
• Used BEx analyzer to develop Sales Analysis and ABC Classification reports and facilitate data analysis using filters, navigational attributes, calculated and restricted key figures.