SUMMARY

• A versatile and thorough project leader and team player with over 10 years of experience in IT, Business Intelligence (BI), Application Development and Business systems Analysis, software design, configuration, application development, and implementation ofbusinessapplications with core focus in SAP BI and ERP applications.
• Proficient in clarifyingbusinessrequirements, performing gap analysis between goals and existing procedures/skill sets, and designing process and system improvements to increase productivity and reduce costs.
• Current and prior experiences spans in the area of Information Technology coveringbusinessprocess re - engineering, system design, configuration, testing, training, and organizational change management.
• 5 years of experience in Business requirements gathering, developing business cases, use cases, test cases, acceptance criteria, risk assessment and mitigation.
• 5 years of experience in Business Intelligence using SAP Business Objects 3.x and 4.x, with Info view, Web Intelligence, Webi Rich Client, Crystal Reports 9/10/XI/2008, Query as a Web Service, Business Explorer/Polestar XI 3.1.
• Delivered multiple end to end project involving requirements gathering and creating blue prints of both functional and technical requirements, including working with local government through BI and SAP applications.
• Extensive experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
• Managed teams of administrators implementing and maintaining security for over 1000 users in 4.x SAP BI CMC including migration from BOXI to BI 4.1.

TECHNICAL SKILLS

ERP/SAP Modules: CGI Advantage ERP solution, FI/CO, Logistics (SD, MM) CRM

Programming Languages: SQL, PL/SQL

Data Modeling & ERP Packages: Star Schema, Extended Star Schema & SAP R/3 4.6, SAP Netweaver 2004s.

Database: SQL Server 2000/05, Oracle 8i/9i/10g/11g/12c, MySQL, PL/SQL, MS ACCESS

Reporting Tools: BEx Reporting, Web Application Designer, Business Objects 3.1 XI, 4.0, Crystal Reports, Xcelsius 2008, WEBI, Dashboards, MS-Excel.

Project Management: MS Project, JIRA, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Technical Project Manager

Responsibilities:

• Provided Project Management (PM) & Leadership expertise in upgrading the complete suite of Enterprise Resource Planning (ERP) applications (Finance & HR/Payroll)
• Successfully delivered the upgrade project through efficient management of 11 HP resources, stakeholder management of Client and the vendor; and realistic project management deliverables
• Responsible for BI 4.1 reporting project (FIN, HR and Budget) managing offshore and on site team of 8 members including developers, architect and system admins.
• Involved in Requirements gathering, Gap analysis, Solution Design, Development, Testing, End-User Training, and Go-Live Support.
• Responsible for assembling data, analysing performance, identifying problems and developing recommendations to import processes intoBI module and the overall platform.
• Successfully completed migration of reports from BO 3.1 to BI 4.1 including creation of new reports and universes, developing Test Plan, performing Unit testing, Functional Architecture, System Integration testing, and UAT.
• Participated in meetings with SME/Users as part of the requirements gathering process.
• Work directly with stakeholders/Users to secure acceptance and approval of deliverables.
• Liaison between client and Confidential for system enhancements, performance tuning and security and admin setup thatbusinessrequires.
• Support ERP team in upgrade of CGI ERP Advantage applications from 3.7 to 3.10.
• Ensure tight controls and communications related to project management to ensure budget and delivery excellence.
• Supervised and trained the technical staff, developed and maintained the technical task plan, assigned and prioritized tasks and ensured that all deliverable deadlines were met
• Build and maintain strong business relationships across multiple lines of business with competing requirements and facilitating strong project change management
• Coached the team on all 9 knowledge areas (project integration, scope, time, cost, quality, human resource, communication, risk, and procurement management)- recognized by the Project Management Institute’s Project Management Body of Knowledge (PMBOK ®) & Agile methodologies based on guidance from Scrum Alliance
• Focused on scope, time and cost management via collaborative communication and risk management to ensure project delivery within budget and schedule

Confidential - Phoenix, AZ

Technical Project Manager

Responsibilities:

• Lead a diverse project team comprised of system integrators and and internal resources for the implementation of SAP ERP system
• Key member of the team responsible for choosing the Hardware and Software hosting company. Responsibilities included creating the RFP; evaluating the responses and providing input to the Information Technology management into the Statement of Work provided by the vendor
• Key member of the team responsible for choosing the Systems Integrator to implement the project. Responsibilities included creating the RFP and integrator evaluation criteria
• Responsible for assembling the project team, stake holders management, and project budget and financial reporting
• Responsible for reviewing project technical status and making decisions to achieve project goals
• Delivered the project within allocated budget of $1.8M and scheduled timeline of 16 months
• Supervised and trained the technical staff, developed and maintained the technical task plan, assigned and prioritized tasks and ensured that all deliverable deadlines were met

Sr. Business Analyst-ERP

Responsibilities:

• Responsible for detailed business process analysis with customer base to drive software enhancements Provide end of quarter objective report outs for executives and top management.
• Worked with all aspects of SAPERPsystem. This includes sales, purchase orders, accounts payables, accounts receivable, MRP, quality control, shipping and receiving.
• Specialized in the Sales module, but involve in all aspects of the implementation. Other modules include accounting, planning, production, and logistics.
• Configuration of Material master, customer master, warehouses, vendors and shipping ports etc.
• Organized JAD Sessions to resolve issues and conflicts, and to arrive at quick agreements regarding the system architecture design.
• Created process flow diagrams, procedures and training documentation to improve company efficiency. CreatedBusinessWorkflow based on the requirements gathered from theBusiness/Company.
• Participate in design reviews and collaborative system integration planning activities. Work independently and in groups to solve high-complexity system, data andbusinessproblems.
• Plan, coordinate and validate system remediation tasks andbusinessreporting needs.
• Responsible for assembling data, analyzing performance, identifying problems and developing recommendations to import processes intoERPmodule and the overall platform.
• Interacted extensively with the management teams to understand the requirements and to report the status of the testing efforts on their applications.
• Train end-users in specific modules ofERPapplication and support the roll-out and implementation ofERPsoftware solution.
• Customizing ad hocERPreports forBusiness/Management.

Confidential, CA

Business Analyst/Developer

Responsibilities:

• Created blueprint through working with business and technical teams to design and implement HANA reporting solution.
• Created logical design of the HANA database, taking into account the growth in size, scope, and users this database will see in the longer term it connects to other data sources and adds further diverse users.
• Provided guidance for the physical design of the HANA database, accounting for growth in size, concurrency and performance, backup/recovery/failover and other requirements of a mission critical database system.
• Created multiple schemas and table definitions.
• Created information objects (packages, attribute views, analytic views, calculation views graphical and SQL script based)
• Applied analytical privileges and tuned query executions to meet performance expectation.
• Extensively worked on data provisioning (BODS, SLT and DXC) to import data from SAP and no SAP systems including relational and non relational data bases.
• Led unit testing, system integration testing and user accepting testing with SMEs snd power users.

Confidential

SAP BOBJ Developer/Admin

Responsibilities:

• Fulfilled Business requirements by completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to successfully develop Universes meeting user needs and requirements from both technical and strategic views of an organization.
• Involved in establishing SAP BW connectivity with Universe Designer and Business objects Infoview, using SAP integration kit. Also installed java connector to import the roles of the SAP user to Business objects.
• Conducted Study to Build Universe's Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
• Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc, and also Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.
• Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client.
• Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using Webi, Xcelsius 2008.
• Involved in writing scripts and also used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is a initial load or a bulk load.
• Created complex Data flows with inner R/3 data flows and declaring parameters at different levels of Workflow.
• Creation of different data stores to get SAP tables.
• Used Business Objects Data Integrator XI R2 for ETL extraction, transformation and loading data from heterogeneous source system.
• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
• Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Staked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.
• Performed ETL activities using Data Services, by extracting data from various Sources.
• Design, develop, and implement Xcelsius dashboard against SAP BW data sources.

Confidential

SAP BOBJ Developer

Responsibilities:

• Built Xcelsius Dashboards using SAP Web services created from SAP NetWeaver without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard.
• Developed Highly Interactive Dashboard completely based on dynamic user input and varying amount of information to analyze without limitations being provided to the user.
• Various other forms of dashboard development also performed including Data from SAP BW through Bex Queries, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
• Created Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
• Optimized dashboard performance for speed of thought analysis even with large data volumes and simultaneously allowed user customization on the fly.
• Worked Extensively with Flash Variables, web services and made Generic Dashboards to enhance Performance in Situation to Decrease Load on the Parent Dashboard, and Designed Child Dashboards to Distribute Load among Various Child Dashboards to Mitigate the Performance Issues.