SUMMARY:

Self - Starter, Fast learner, Optimistic, Team player are a few words to describe myself. Over the last several years I’ve played different roles within IT as a developer, Business Analyst, Project Manager, with focus on Business Intelligence, Reporting and Analytics in the last five years. Seeking role as Analytics Lead/Manager, Business Intelligence Engineer, Data Engineer, Data Scientist or a Data Analyst.

SKILLS:

Technical: OBIEE 11g, SQL, Java, .Net, Python, Informatica, R, Octave

Business Areas: Finance, Accounting, Procurement, Sales, Marketing, Merchandising, Supply Chain,Order Management, Manufacturing

Domains: Manufacturing, Logistics, Consumer Packaged Goods, Retail, Oil and Gas

Others: Requirements gathering and analysis, Process Improvement, Automation, Project Management, Cross Functional Team Leadership, Requirements gatherings Leadership

PROFESSIONAL EXPERIENCE:

Confidential, Monroe, NC

Sr. Business Intelligence Solutions analyst

Responsibilities:

• Gathering requirements for several initiatives- Billings, Bookings and Backlog reporting; Sales order lifecycle reporting for field sales; Batch/Lot status reporting for Inventory management; Manufacturing reporting; Supply chain reporting; On time performance metrics, Inventory reporting; Real time reporting; Quote metrics; Multi-Currency
• Spearheading process improvements to develop subject areas that are well documented and meet needs of multiple departments and users
• Deeply involved in data architecture decisions, business and technical design solutions
• Solid understanding of Order Management, Inventory, GL, Manufacturing modules within EBS
• Built front end reports using Advanced SQL queries, drill-ins and other advanced features
• Analyzed fact grain, dimensions, informatica mappings to develop precise requirements

Confidential, Charlotte, NC

Project Manager/ Lead Business Analyst

Responsibilities:

• Project Manager for OBIEE implementation for back office business areas (HR, Procurement and Finance)
• Managed team of business analysts, functional area experts, technical architects, developers to deliver results in a timely manner
• Facilitated deep dive sessions with external consultants to define roadmap, identify requirements that can be met using Out of box functionality. Customization requirements broken down into Priority and level of effort
• Created Jira to track project deliverables and maintain change control. Represented Jiras for releases in change control meetings.
• Gathered requirements for implementation of customizations and out of box metrics
• Well versed in analyzing source data from Oracle EBS R12, Informatica mappings for BI Apps, data warehouse tables, RPD and Catalog.
• Involved with technical team to troubleshoot load failures and monitoring using DAC
• Well versed with configuring security roles on Catalog and recommending security options to business users
• Built reports for business users and configured alerts using out of the box subject areas and custom subject areas
• Worked as a project analyst in the Program Governance Office (PGO) for 20 million dollar Program
• Responsible for analyzing, gathering and identifying information for communication to genesis work streams, PGO, Steering Committee, Executive steering committee and IT leadership
• Proactively identified Issues and Risks from different work streams
• Facilitated meetings and discussions to resolve outstanding issues, risks, decisions and key activities
• Partnered with change management work stream for successful execution to help PGO effectively deliver communication related change and business transformation
• Conducted 3 month system and business process impact to implement multi level pricing at stores
• Identified 3 solutions: Quick win, Short term and Long term based on cost, duration and margin impact
• Conducted interviews with business teams (Ad planning, Pricing, Marketing, Visual merchandising, Global sourcing, Store operations, Finance) to understand requirements and identify business rules
• Assessed system impacts (intellisense, retek, SAP POS, Enterprise data warehouse, sales audit) by communicating business process changes to IT teams
• Presented findings and options with cost, timeline, impact on People, Process and Technology to senior leadership, business teams and IT teams
• Created functional specifications implement changes in Buy one get one type offer behavior in Pont-of-sale system
• Conduct smoke tests and data analysis to understand system behavior

Confidential, Charlotte, NC

Business Analyst

Responsibilities:

• Gathered high-level requirements and pre-analysis to build Enterprise Operational Data Store ( Confidential ) to help senior level management in Business Intelligence and Data warehousing department to define priorities and project plan for 2013. Analysts across multiple divisions have built ad-hoc queries, reports and mini data stores to extract transactional data directly from the source systems causing the following issues
• Performance issues across source systems due to heavy analysis and direct reporting
• No single version of truth, due to multiple sources and different extraction times
• Source data is fully transformed before it is housed in data warehouse, untransformed data for analysis and reporting is not available in the data warehouse
• Defined requirements gathering framework and strategy to approach subject matter experts across multiple departments like Sales, Marketing, Finance, Customer Care etc. across East, West and Corporate divisions.
• Interviewed 45+ stakeholders to identify source systems and reporting across multiple departments
• Analyzed and ranked source systems by criticality, number of sub reporting systems, users and several other factors.
• Presented findings to senior level management. Findings used to plan projects and budget.
• Built an inventory of source systems used across multiple divisions for reporting and analysis purposes. These source systems would be suitable candidates for enterprise Confidential .

Confidential, Greensboro, NC

Business Analyst

Responsibilities:

• Part of IT client support team for Fortune 100 client
• Accountable for requirement gathering, system development, functional testing, and implementation support
• Supported client’s Warehouse Management Systems using shared inventory model between Retail and Direct-to-Consumer businesses.
• Served as primary liaison between Client and teams from Warehouse Operations and IT Development.
• Performed extensive functional testing and develop detailed documentations such as user manuals, process flows, and interface mapping documents for every change before release to production.
• Spearheaded process improvements through identifying requirements and root cause analysis of issues
• Built store order maintenance screen to allow business users to update order information without IT support
• Automated daily reconciliation process
• Reduced manual updates of tables with codes etc. by maximizing the use of interfaces
• Automated Excel based manually generated system reconciliation reports, designed system interfaces to extract files to be stored in database, and created SQL queries to generate automated reports.
• Led business analysis, end user training, testing changes, and provided post go-live support for Client’s Direct to Consumer Systems used during peak holiday order seasons (i.e., created new pick faces and verification stations for ease of implementation process).
• Enhanced warehouse operations through introduction of softlines and set-up of 24/7 Help Desk support for documentations and hand-off.

Confidential, Clark, NJ

Strategic Sourcing Consultant

Responsibilities:

• Information Management department was facing resentment from various business units for their prior poor selection of existing Business Intelligence Reporting platform. Goal of the project was finding replacement for the existing platform at best price with consensus from 19 functional departments.
• Tasks involved were conducting extensive market research to create a shortlist of five vendors, interviewing users and project managers while designing RFP and coordinating vendor presentations.
• Made vendor selection process transparent by developing an extensive scorecard process to capture input from various departments.
• Shortlisted final tools based on user requirements, technical requirements, and cost and company overview.
• Analyzed Total cost of ownership (TCO) based on Licenses, Annual Maintenance, Hardware, Training and Software costs including strong Fact based negotiations.
• Savings of over $750,000 were realized (Reduction of $150,000 every year for over 5 years in Annual maintenance cost compared to the previous reporting tool, scalability of 100 concurrent users at no extra cost, serving at least 1000 extra users)
• Similarly led several sourcing initiatives related IT Hardware disposal, ITO Contractual benchmarking, Support Services and upgrades for various solutions, IT Project Compliance and Configuration Management at the client location.
• Approximate savings of about $5,000,000 achieved were achieved across multiple projects.
• Trade marketing department of the client company was initiating a program with Wal-Mart stores to provide quarterly coverage to all their products across stores. The challenge at hand was to find a third party vendor who could provide coverage for client products at Wal-Mart.
• Spearheaded the five step strategic sourcing process to identify vendor based on the following criteria: Current presence in Wal-Mart, location of warehouse where point-of-sale could be received, all inclusive rates, financial stability.
• Client’s trade marketing department has 25 regions managed each managed by a different Regional Execution Managers.
• Allocating budget, tracking work completed by Third Party Installation companies across the country was becoming difficult.
• Led collaborative effort with Senior Managers to improve procurement business processes by developing training material, improved budget, invoice, and purchase order tracking systems by leveraging Sharepoint.
• Involved in analyzing spend with different third party companies in different regions to negotiate and standardize price across regions and vendors.
• Improved business processes by developing Purchase Order Change Requests forms and Blocked Invoice Tracker on Sharepoint for the benefit of offshore team’s transactional activities.
• Trained and assisted change management process both for Client and the offshore team.
• Designed and implemented Vendor Performance Management System to ensure Quality, Service, Cost from suppliers providing strategic goods and services are in compliance with the contractual agreements, business requirements and thus improving the Total Value Management
• Developed ‘New Hire Training Program’ to train junior members and training material for Information Management, Marketing Services, Marketing Materials and MRO with the help of other senior team members.
• The procure to pay process (P2P) was inefficient, cumbersome and was not the strategic focus of the client’s procurement organization, led the effort to outsource P2P process to GEP’s offshore team by conducting a business process re-engineering, creating standard operating procedures, SLA creation & reporting and training thereby achieving significant reduction in aging and blocked invoices, timely payment to suppliers, customer service focus in answering client’s questions and supplier’s payment queries
• Negotiated and executed contract types like Non-disclosure Agreements, Master Professional Service’s agreements, Job assignments/Statement of work and Amendments. Contract Management also involved heavy interaction with legal, audit, Finance and Risk Management Departments.
• Guided and mentored offshore team and junior team members on blocked invoice resolution, purchase orders and other transactional activities.
• Spearheaded GEP Social Initiative at Client Location, to boost employee morale and improve community involvement.

Confidential, San Antonio, TX

SAP Analyst

Responsibilities:

• Valero’s plant operations department was using archaic Excel worksheets to monitor the plant’s key metrics. All plant supervisors had ‘Morning Meeting’ to discuss about any anomalies and production capacities of various plants.
• Developed Refinery Operations application consisting of Dashboards, Daily shift Report and Daily shift planner on SAP Netweaver landscape. This application was directly linked to the plant units through SAP MII interface
• Daily shift report was configured to automatically print on designated printers before the morning meeting with the ability to be exported in excel and PDF formats allowing users to further analyze the data and convenience of sharing and presenting the reports respectively
• User interface allowed users to modify information and add comments; this led to unified view of data and reduced dependency on spreadsheets.
• Built Business Objects reports for various departments using WebIntelligence and XCelcius.
• Mentored and trained new hires and interns on the technologies used at Valero.

Confidential, Raleigh, NC

Software Engineer

Responsibilities:

• Proposed and utilized Windows services for workflow automations based on business need to minimize manual data entry and reduce processing time via .NET framework.
• Worked on Windows Communication Foundation based background payment processing applications for automatic posting of payments.
• Created XML and XSLT based reporting system for Customer Service Application that monitored call events and follow-up actions.
• Designed user interfaces and prototypes with extensive usage of keyboard shortcuts to ease the data entry process.
• Monitored software installations to ensure systems functionality as designed.
• Managed changes to the configuration of all source code by following appropriate check-in/check-out procedures and ensuring controlled releases of versioned objects from source-code control systems.
• Ensured sustained client satisfaction through frequent communications on all project progress, applied corrective actions as warranted, and consistently met all technical project deliverables and timelines.
• Stayed abreast of industry news and read frequent publications for continuous expertise in IT software development field.

Confidential, Chicago, IL

Software Developer

Responsibilities:

• Designed, Developed and Delivered On-demand web application on Coghead platform.
• Gained good understanding of Web 2.0 projects and SaaS (Software as a Service) applications.
• Created Scenarios, Prototypes and Use Cases to accurately represent user requirements.
• Worked in small agile teams to manage, schedule and deploy services by configuring customer’s environment properly.
• Involved in Training, Coaching and Mentoring Business partners and IT team about SaaS technology.

Confidential, Chicago, IL

Business Analyst Intern

Responsibilities:

• Worked with the Customer Relations team.
• Provided recommendations and insights based on analysis of Confidential ’s Global Response Survey data and improved the customer satisfaction rates by 3%.
• Formulated “Touch” strategy and framed modes of communication like phone, email, field visit based on customer industry, product offering, and purchase volume.
• Extensively used MS Excel Pivot Tables to analyze data and offer best practices and recommendations.
• Gained experience related to Marketing, Project Management and Data Analysis.

Confidential, Chicago, IL

Business Analyst Intern

Responsibilities:

• Created application usage matrix categorizing software applications based on technology and function it serves.
• The categorization helped in identifying the right vendors for a given technology and helped in eliminating redundant applications.
• Strategic recommendations helped in reducing the maintenance cost due to standardization of applications and elimination of redundancy.
• Gained knowledge in areas of Vendor Management, IT Outsourcing.