SUMMARY

• 8+ years of experience as Project Manager and Business Analyst in planning,analyzing, designing, documenting, supporting and delivering project implementations with understanding of the architecture, scope, requirements, project deliverables and functionality.
• Maximize productivity by setting clear expectations and proactively communicating project status, issues and risks to internal stakeholders and top management.
• Accomplished professional with 5 years of experience inSAPECC 6.0 modules of OTSC, MGMS, CAS, PRTP, RTR and SCP and have in - depth business process knowledge.
• Experienced in mapping legacy business processes toSAPprocesses, AS IS / TO BE reporting, prototyping, detailed configuration, reconfiguration, testing, mapping legacy data toSAPmaster data, analyzing report requirements.
• Experienced in full life cycle implementation experience with ASAP methodology - Scoping, Project Preparation, Business Blue Printing, Realization, Final Preparation, Go-Live and continuous support
• Experienced in leading Internal Audit & Compliance projects including governance, policies, procedures, and reporting.
• Experienced in interfacing with internal stakeholders (Business Risk, Interest Rate Risk, Operational Risk, Liquidity Risk, Credit Risk, Market Risk) and federal regulators (OCC, Federal Reserve)
• Experienced Application Security professional with detailed understanding of Access Control, Process Control and Risk Management.
• Experienced in change request, security standards, conventions and overall security solution.
• Possess strong written and oral communication skills, strong ability to understand business and functional requirement documents.
• Attention to detail and ability to work in tighter schedules and on different applications concurrently.
• Excellent Analytical skills to understand the Business process and Functionality Requirements and to translate them to system requirement specifications.
• Very good organizational, interpersonal, communications, teamwork and leadership skills with proven skill to interact across multiple levels of organization.Business Intelligence & Reporting:
• 6+ years of Business Intelligence & Web Intelligence experience.
• Experienced in working with multiple projects encompassing multi-cultural teams from diverse geographical regions including offshore and lead a team of developers that performed project design, development, testing, deployment and post deployment support.
• Experienced in developing new analytic models and matrices that supports business decisions and improve process efficiency.
• Experienced in completing and maintaining Technical Design Documents and Business Requirement Document.
• Developed and maintained dynamic KPI's reports that are critical for the overall success of the departments.
• Executes BW queries to generateWebireports using BI Launch Pad in Business Object to meet user requirements.
• DevelopedWebi reports on SAP BEx queries using BICS inWebiRich Client.
• Developed Interactive reports anddashboardsusing Xcelsius and WebI reports.
• Extensively used Infoview to test Dashboards and Webi reports.
• Created Universe based on two different data sources.
• Experienced in advance analytic solution and solving complex problems business and technical issues.
• Excelled in written and verbal communications. Exceptional in developing inter-personal rapport with business partners, both internal and external.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, MN

Role & Responsibilities:

• Lead the design and implementation of business process changes in Cargill Stabilization Initiative
• Maintained and modified existing business processes to enhance proficiency using business intelligence reports and models.
• Performed quarterly review of existing process and made recommendation based on new requirements, new compliance rules and regulations.
• Responsible for managing new projects with complex cross functional requirements and outside vendor relationship.
• Provided critical procurement support via business intelligence reports and analysis.
• Trained business super-users on SAP WEBI environment for Ad hoc Report Build.
• Represented the Incident & Resolution in weekly RCAB (Release/Change Advisory Board) Meetings for Work & Release Approval.
• Managed the work queue with a clear understanding of priorities and milestones.
• Supported the ongoing continuous process improvement efforts and worked closely with stakeholders to analyze and understand metrics and reporting from business perspective and translate into actionable processes.
• Responsible for documentation of processes, requirements, and standard operating procedures to facilitated communications with stakeholders.
• Adopted and implemented industry standards in alignment with Global IT BI team to optimize and maintain efficient reporting architecture and strategy.
• Implemented best practices for version management, report enhancement, report infrastructure, architecture, and security.
• Utilized requirements to define both functional and technical requirements to facilitate design, development, testing, implementation and ongoing support.
• Worked with the Global IT process teams to understand, document, and implement usability requirements to support the end to end processes.
• Ensured changes to existing and new reports are supported with robust test cases and subsequent testing.

Business / BI Analyst

Confidential, MN

Responsibilities:

• Served as a team lead that was responsible for gathering and documenting functional requirements for sales and finance projects.
• Worked closely with business finance,projectmanagersand technical developers to aid with the delivery of solutions that will improve users’ efficiencies, user experience and productivity.
• Coordinate activities in developing test plans and scripts, generate test data and coordinate efforts for BAT and UAT testing.
• Lead project activities in the design, testing, and deployment phases for software/systems affecting the sales and finance department.
• Leadprojectdelivery activities by producing and reviewing deliverables on requirements gathering, implementation and testing.
• Developed and maintainedprojectplans, including timelines, resource plans, training plans and any otherprojectrelated plans.
• Coordinated the testing activities with the Quality Assurance and User Acceptance groups
• Performing post implementation reviews to gather continuous feedback and recommendproject management process improvements.
• Manage business partnersKPI reportingin sales and distribution departments.
• Developed Interactive reports anddashboardsusing Xcelsius and WebI reports.
• Tested and validated Reports and Dashboards and migrated reports to Xcelsius for advance analysis.
• Extensively used Infoview to test Dashboards and Webi reports.
• Created Universe based on two different data sources.
• Debugging critical data related and report related issues

Sr. Business Intelligence / Business Analyst

Confidential, MN

Role & Responsibilities:

• Managed a group of 2 onshore and 4 offshore technical developers in administrating the implementations monthly / quarterly change releases and subsequent process of post-deployment review, analysis and documentations for audit.
• Documented requirements, defined scope and objectives and formulated systems to parallel overall business strategies.
• Set deadlines, assigns responsibilities, and monitors and summarizes progress ofproject
• Worked closely withITManagers, and vendors to manage company’s expectations with regard to resources, budget and schedule.
• Lead securityanalystforIntegrated Card System (ICS & TRIAD 8.1) Consumer & Commercial Credit Management & Oracle 4.0 implementations.
• Reviewed change request and upheld security standards, conventions and overall security solution.
• Managed IT Audit and Compliance Process by developing and maintaining ALL federally mandated compliance processes and reports. Established procedure for audit control on monthly change/release process and audit reports.
• Implemented Sarbanes-Oxley regulation by establishing new rules and procedures on maintaining audit logs, reports, compliance and sign-off on all pre & post change/release projects. Also established new procedure in Credit Risk to provide an Independent Oversight and Compliance within internal audit rules.
• Provided friendly, comprehensive, timely customer service to IT support, managers and end users.
• Created Complex reports using diverse Business Object functions such as Slice and Dice, Master/Detail, crosstab, user responses, formulas, multiple dataproviders and Combined Queries.
• Used natural and customized hierarchies in the universe to build reports with drill down and drill through functionality
• Created ad hoc reports on product distribution by region and merchant using desktop intelligence functionalities like Sections, Breaks, Filters, Alters, drill down functions and formulas.
• Used Stored Procedures to create different types of reports with the help of command object.
• Export and Manage reports on the server. Schedule the reports in various formats in Info view for recurring reports.
• Performed documentation for the Business Object Enterprise System, design, development, test plan, implementation and maintenance.
• Schedule the reports in various formats in Infoview for recurring reports.
• Performed Unit, System and Regression testing of monthly change request projects, maintained artifacts and securing sign-off
• Executed ad-hoc reports for compliance and audit and review these reports periodically to ensure they continue to serve the business purpose.
• Key point-of-contact for the senior management on implementation schedule, milestones and project documents and update.
• Responsible for conducting project meeting with stakeholders for project requirements, scope, delivery, implementation and support.
• Tracked and published projects implementation reports, highlighting key findings and any discrepancies found and steps to address the issues.
• Participated in monthly group meeting to present critical KPIs to the senior management, summarizingportfolios trends, and performances.

Business Analyst

Confidential, MN

Role & Responsibilities:

• Involved in designing, developing, coding, testing and debugging highly complex newUniverse and reports and make enhancements to existing universe and reports.
• Translated user requirements into specific reporting solutions.
• Used Xcelsius to develop dashboards for better visualization for complex business logic.
• Created technical specs for universes and Webi reports.
• Involved in the designing and Building of Universes, Classes and objects.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Set up the security levels to the Business Object (BO) users in universe module like row level and object level security.
• Involved in Installation and Configuration of all Components of Business Objects.
• Involved in design of conceptual, logical and physical schema of databases.
• Involved in identifying Functional and Non-Functional requirements and created the Functional System Design document.
• Partnered with the technical team in research and resolution of system development issues and process problems.
• Conducted User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues
• Gathered and documented functional and technical requirements for software improvements, patches and upgrades

Confidential

Analyst - Confidential, MN

Responsibilities:

• Interacted with Subject Matter Experts such as WM advisor group, underwriters, and Process Analyststo gather requirements and goals through interviews and surveys to understand thebusiness process.
• DevelopedBusinessRequirement Document and detailed Functional Specification Document
• Involved in gathering and synthesizingbusinessrequirements and translated into functional and non-functional requirements to be used as input to the functional design specifications.
• Interacted with technical Architects to identify and analyze the given information, procedures and decision flows and evaluated existing procedures.
• Prepared Use Cases, Use Case Scenarios and elaborated those using UML diagrams like Use Case Diagrams, Activity Diagrams and use case narratives.
• Performed requirement impact analysis for change requests related to new enhancements, updates for the application.
• Performed peer review for Test Cases created and test results with the QA team.
• Worked as a team with Developers and ProcessAnalystsin preparing the requirements, writing workflows, process flows, and Interacted with system developers to resolve questions and discrepancies in BRD.

Supply Chain Analyst

Confidential, MN

Responsibilities:

• Member of the team that monitoring, troubleshooting and executing system updates during multiple Oracle AdvancedSupplyChainPlanning (ASCP) implementations across the country
• Utilized Oracle ASCP for Material Requirements Planning (MRP), forecasting, scheduling, and purchase of several inventory items worth up to $700,000
• Worked with Material Managers to plan and monitor JIT inventorysupplies, adjusted schedules to achieve complex technical requirements such as narrow turnaround times and capacities
• Supported re-engineering and implementation initiatives for inventory management solutions, materials management, and plan-to-make for multiple sites during the Oracle ASCP implementation process.
• Performed statistical analysis and supply chain planning and forecasting.
• Identified improvement opportunities as a result of data analysis and market intelligence.
• Researched and provided ad hoc competitor data analyses within clients’ industry using specific application products to improve business processes in Logistics, Procurement, Inventory Management andSupplyChainPlanning.
• Ad hoc reporting and analysis as needed on inventory, transactions and cash supplies

Transportation Analyst

Confidential, Mankato, MN

Responsibilities:

• Assisted in implementation oftransportationmanagement system.
• Actively participated in the development carrier scorecard initiative.
• Coordinated and scheduled for all inbound raw material.
• Negotiated contracts for private railcar fleetand measured equipment utilization for tank car fleet.
• Generatedtransportationreports for operating and purchasing teams.
• Analyzed 3PL contracts fortransportationproviders.
• Awarded and created purchase orders based on competitive bidding process.
• Experienced temporary Purchasing Buyer assignments for the MRO team

TECHNICAL SKILLS:

ERP System: SAP ECC 6.0, Epicor 2.0

Operating System: Windows 95/98/NT/2000/XP/Vista

Microsoft Office Applications: MS Word, MS Excel, MS Access, MS Power Point, MS VisioMS Project, MS SharePoint

BO Tools: SAP Business Objects XI Web Intelligence, Universe Designer, Xcelsius 2008

Languages: UML 2.0, HTML, XML, PL/SQL, SQL,SAS 9.3

ETL tools: Oracle Data Integrator & OWBEE

Databases: Oracle 10g, Oracle 9iSQL server 2003

Database Tools: Toad