Supply Chain/ Sourcing Specialist

Patralika Banerjee

Present Address:

Apt ****, 1255 North Post Oak Road

Houston, Texas 77055.

E–mail: *************@*****.***

Cell #: 650-***-****

EDUCATION AND ACADEMIC ACHIEVEMENTS

• University of Michigan - Ann Arbor, MI, Sept 2008 – Jan 2010

Masters in Operations Engineering, Major – Supply Chain Management GPA: 3.6 /4.0

• National Institute of Technology – Warangal, 2002 – 2006

Bachelor of Technology, Computer Science & Engineering GPA: 7.6 /10.0

RELEVANT WORK EXPERIENCE

Supply Chain/Materials Management Analyst, Cooper Industries, Corporate Headquarters, Present

o Designed spreadsheets, automated reports (excel VBA, SAP reports, BW/BEx) for reporting service metrics for on time to request by division/factory, backlog, past due dollars, delivery data to CEO/VP level management and reduced data processing run time by 50% & errors by 40%.

o Designed spreadsheets & reconciled differences to provide daily trending/visibility to management for inventory worth $200M in Raw, in progress, finished & In-Transit buckets, improved turns & reduced dollars using Hyperion Financial mgmt. system, SAP reports and profit center accounting

o Created ad hoc reports in SAP layouts per business requirements, changed formulas, added variables, characteristics, created extracts, background jobs & report groups including drill-downs.

o Developed 50 queries using BW/Bex Query designer and published them on Bex analyzer & web designer, worked on ROI queries based on real time info cubes, mapped enterprise structure, trading partner, company ID, item master & reporting info cubes to generate business reports.

o Performed cleanup of SAP master data for purchasing groups, purchase requisitions, purchase orders, contracts, material types, valuation classes; reconciled goods movements, goods issues & receipt; used SAP MM/FICO Modules & profit center accounting daily for reporting & analysis.

o Tuned SAP modifications, led report design from business, developed report painter/writer programs, cleaned materials data to standards, created materials in SAP & provided to factories.

o Supported interfaced, conversion programs, reports & interactive applications in JD Edwards modules, trained & maintained interfaces; produced documentation for modifications to comply with Sarbanes-Oxley and modified work order processing for a better selection of bill of materials.

o Enhanced Supply Chain applications in JD Edwards XE 8.10, improved order to cash, quote to cash cycles, redesigned SAP order entry to account for orders on delivery blocks & credit holds; implemented reports for high sales volumes to allow manufacturing to respond appropriately.

o Developed a routine for mass updates to item categories for inventory management, trouble shooted issues in JD Edwards & Visual C++, implemented interfaces to load EDI data into purchase orders, produced reports & updated data for vendors, accounts, material, SKU etc

o Ran interactive reports & nightly batch programs (Financial, Sales, Inventory, Pricing, Purchasing and Manufacturing modules) using JDE CASE driven toolset, was responsible for verifying databases for data on divisions, business units, chart of accounts & daily foreign exchange rates.

o Configured SAP settings for master data - sales doc type/ATP logic, delivery-doc type/pick pack time/GI, credit management, inter-plant stock transfer, returns, consignment & integrated logistics (MM,WM,PP,LE) with Finance (FI/CO) by setting up material, accounts docs & movement types.

o Improved order entry process by implementing EDI solution which interfaced with customers, vendors & managed SAP master data to support order entry, purchasing, accounts payable, cash management, shipping and A/R, activated 1000+ vendors for EDI transmission of orders & resolved discrepancies in SAP POs by checking SAP transactions to improve efficiency of EDI processing.

o Involved in stock handling SAP processes and worked extensively in MM modules of Inventory Management, Forecast Based Planning, Purchasing, Vendor Evaluation & Physical Inventory.

Strategic Sourcing/Contracts Analyst, Materials Mgmt, Kaiser Permanente, March 2010 - June 2011

o Developed reporting tool for auto contract renewal, purchase orders entry, tracking & analysis, designed schema for SQL database, created scripts & procedures for loading data from flat files.

o Designed SQL & Access reporting tools to track $30M spend in contracts & amendments to statements of work, programmed SQL code & designed reports in SSRS, Access & PowerPoint.

o Extracted Medical Centers’, healthcare & administrative expenses using A/P data, crystal reports, & SAP business analytics tools, categorized data using oracle financial analytics, statistical tools & reported performance of categories, vendors, purchase orders, cost centers, expense & locations.

o Identified & saved $15M in national contracts non compliance, $10M in product standardization, vendor consolidation opportunities & semi-automated spend analysis to reduce effort by 35%.

o Provided financial planning, budgeting & management support, reconciled budget & expenditure trends utilizing standard accounting & reporting systems, ensured timely reporting of accurate financial data, drafted spreadsheets and presentations for spend justification and tracking funding.

o Tracked dollars, statistics & aging in inventory reconciliation process, matched and assessed variances in warehouses for 5M units and reduced average error volumes & aging period by 20%.

o Researched spend, job profile, hours & hourly wage data (Excel) for contingent workforce (spend $10M/yr), optimized employee scheduling, reduced temp workforce by 5% and saved $1.2M/yr.

o Executed industry/market analysis of commercial print industry, developed Supplier Balanced Scorecard spreadsheet & strategies to deliver superior service, optimized price & contract terms.

o Integrated regional - global FDA database, drafted requirements, specifications & training, programmed sponsor name & dollars lookup to reduce labor effort in contracting process by 20%.

o Prepared quarterly forecasts, variance analyses, established financial benchmarks, generated cost-savings assessments, produced financial reports including metrics, actual/estimated/variance figures using SAP analytics and created financial/operational reports for CFO level management.

o Redesigned budget & reporting processes, identified process & compliance issues to generate savings of $1.5M, assisted in budget development, tracked P&L, reported quarterly financials and realized $100k in annual savings by semi-automating reporting in PeopleSoft, Hyperion and SAP.

o Automated data transformation across platforms, designed, built and maintained data marts and performed ETL, reporting & analytics using SAP financial analytics, Hyperion and crystal reports.

o Used advanced dashboard functions to forecast inventory & SKU levels, analyzed historical data, trends & risks to produce annual demand forecasts and optimized purchase order volumes by 30%.

o Investigated best practices in technology, security, maintainability & reusability; was involved in vendor relations, product proposal, proofs of concept & implementation for contracts up to $5 M.

o Created order fulfillment reports using Crystal Reports 8.5, complex T-SQL queries for senior management to aggregate data of sales order, manufacturing details & purchase order information.

o Achieved optimal pricing for buying construction materials through market analysis, RFXs, competitive bidding, rate reduction negotiations & vendor management inventory for $40M/yr.

o Executed industry/market analysis of commercial print industry, developed Supplier Balanced Scorecard spreadsheet & strategies to deliver superior service, optimized price & contract terms.

o Built SQL server databases, performed data migrations, supported applications, implemented security, backed up and recovered databases, designed, built and maintained data marts and performed ETL, reporting & analytics using SAP financial analytics, Hyperion and crystal reports.

o Performed requirements gap analysis, generated traceability matrix for vendor & contracting systems, created best practices in mapping & documentation, documented data flows, reconciled discrepancies in logical, physical data models & collaborated to model entities and relationships.

o Administered changes in data models & database changes, led requirements gathering sessions with business/technical users, conducted review sessions to secure signoff, developed ETL jobs, resolved data integrity issues, used SQL server to debug scripts & improve performance/security.

o Enhanced suite of C#, VB.Net applications, used MS Visual Studio to add functionality, used Sql Server import/export utilities, T-SQL & PL/SQL to implement fixes, reconciled differences in versions, database schemas, & developed version management for databases and application code.

o Enhanced application integration, interviewed end users, documented business processes to facilitate understanding of work flows, identified opportunities for streamlining & process reengineering and assisted with integrating Accounts Payable / Receivable information from Order Fulfillment systems to enterprise accounting systems (SAP, MS SQL Server 2000 databases).

o Evaluated approaches to select feeder data mart to integrate with enterprise data warehouse, identified ad-hoc reporting requirements in business discussions, defined & diagrammed elements of proposed systems, including database dictionary, OLAP, ETL, data models & assessed impact.

o Designed data synchronization, used Microsoft DTS for ETL, programmed VB 6.0 applications to match requirements, created order fulfillment reports in Crystal 8.5, T-SQL queries & sub reports for management to aggregate sales order, manufacturing & purchase order information.

Research Analyst, Health Education, School of Public Health, Univ of Michigan, May-Dec 2009

o Created budget mgmt user interface and database (Access, VBA, Excel and ADO) for research staff, identified cost-saving opportunities & system improvements, leading to $70k savings.

o Eliminated duplicate records by 25%, reduced processing time (50%) & replaced Excel tool.

o Programmed datasets using SAS Base, Macros, Graph, Proc, Summary, Means, Freq & Chart to help researchers in statistical analysis, modeling & graphical presentation of National Program Office-cross site evaluation survey results and created models & data structures for administration.

o Designed survey questionnaires using Access database, performed analysis using SQL queries, investigated missing data and data anomalies in data sets and used SAS for pre-processing data.

o Collected, cleaned & aggregated HCPCS, ICD9 and CPT billing codes for creating SAS formats.

o Developed SAS code to extract data from Patient financial systems to Oracle for analysis, analyzed treatment patterns by correlating data in payments/adjustments & medical record tables.

o Mined 20 databases & created reports to aid business owners identify revenue sources, measure variations in patient attitudes, administrative policies and discover reimbursement opportunities.

o Elicited, analyzed, documented, communicated requirements & implemented claims analysis system for National Program office project, drafted scope of project, project plan, led stakeholder analysis, interviews, created vendor-RFQs/RFIs & modeled process in Visio, Rational & UML.

o Designed simpler workflows in SharePoint and implemented agile SDLC for school research website & online course modules, created logical models to map business requirements, data flow, & functional decomposition diagrams, requirements matrix & mapped test cases to matrix.

o Organized requirements for patient/caregiver survey system with use cases and UML classes, developed feasibility analysis, project risk analysis, wrote use cases descriptions including preconditions, post conditions, assumptions, and scenarios, employed use cases to develop requirements with stakeholders, wrote pseudo code for system and developed testing scripts.

o Worked in teams to extract requirements for MS SQL server databases for asthma management survey system, conducted stakeholder analysis, used interviews to deliver high level business requirements documentation, facilitated JAD with stakeholders, elicited & communicated requirements, translated into deliverables & managed upgrade and maintenance of server systems.

o Build new queries from existing queries in Business Objects, Teradata SQL Assistant, SQL server reporting services to support ongoing changes in production and Enterprise Data Warehouse.

Research Assistant (Pharmaceutical Industry - Excel/ Stata), Ross School of Business, Jan – Dec 2009

o Researched patent applications, FDA approvals & blockbuster drug sales (7000 manufacturers & 10000 scientists) to prove correlation, analyzed data using Access, Excel & STATA, ran descriptive/multivariate analysis using t-tests, regression, chi-square & multi-level modeling.

o Assisted in development of data analysis plans for professors & senior statisticians, selected statistical methods & assisted in programming tasks to ensure timely & high quality deliverables.

Business Analyst/Technical Developer, Amdocs Inc., India & USA, June 2006 – July 2008

o Streamlined strategy incorporating current & future requirements, collaborated with clients & database architects, designed data schemas & developed business intelligence dashboards.

o Participated in reduction of annual audit costs by bringing IT SOX compliance, created sustainable processes, eliminated IT deficiencies and achieved estimated cost reduction of $1 million.

o Programmed PL/SQL scripts for resolving 200+ production issues, corrected data to save revenue dollars, generated adjustment for affected accounts & reported statistics on new services/products.

o Tuned data warehouse applications using partitioning & indexing, used advanced SQL (rollups, cubes) and coded process that extracts, transforms & loads multi tera bytes data per minute.

o Created PowerPoint presentations for sales, products, customers, disconnects & revenue by region, using Toad, modeler, Business Objects, Visual Studio, VBA, Dashboards, Reports & SQL.

o Implemented business intelligence & predictive analysis - Hyperion System 9 application, using Hyperion planning, financial reporting, Essbase analytics, created Hyperion reports which resulted in 80% decrease in reporting process time, & designed dashboards for scenario driven planning.

o Designed, implemented & tested 5 software change requests in CRM application for leading U.S telecommunication service provider using C/C++/Java, Oracle warehouse & led testing approach.

o Reengineered legacy billing suite, production databases using Hyperion Essbase Application Manager, created batch scripts, automated runs, designed cubes in Hyperion using rule files, analyzed billing data, performed DBA roles like filter creation, creation of users/groups & responsible for performance monitoring, warehouse tuning, backup/recovery & production on call.

o Drafted requirements as use cases, used Rational Unified Process for functionality implementation, used UML for gathering requirements, created use case & class diagrams, identified changes from legacy systems & defined ETL for extracting data from 3rd party systems.

o Incorporated Unified Change Management in compliance with Configuration Management, managed requirements in Rational RequisitePro, involved in Functional and User Acceptance Testing, reviewed system level test cases, prepared test cases for testing using Rational Test Manager, tracked bugs using Rational Clear Quest & maintained version control with Clear Case.

o Led requirements extraction/documentation for tool to implement customer marketing communication opt-in or opt-out preference changes on the front end, used SQL Server Integration Services for ETL, drafted technical documents, conducted presentations & secured approval.

o Performed analysis on source data, created database sizing estimates for customer and billing account databases, gathered update frequencies/volumes from systems, generated data flow size estimates, ETL data structures, lookups, batch jobs, metadata management & error notification.

Operations Analyst Intern, BSP, Steel Authority of India Limited, INDIA, June 2003 – Aug 2004

o Created financial tools (Crystal reports) for forecasting of revenues, expenses and operating profit, participated in completion of expansion, capital & strategic plans for manufacturing and technology divisions and drafted departmental presentations for scenario based cost savings.

o Created a process map with expenses, resources & identified 5 areas for improvement, resulting in efficient order processing, reduction of manual efforts and improvement in material traceability.

o Studied initiatives that saved $10 Million per yr through redesign of warehousing & transportation models, using excel solver, optimization software, discounted purchasing & service agreements.

o Proposed increasing volume by 40% in distribution centers to allow consolidation of 2 warehouses, developed excel models to calculate inventory consolidation and product line elimination that resulted in disposal of $750K of excess, obsolete and slow moving inventory.

o Created sales reports for global materials manager to improve sales tracking, developed daily labor cost efficiency report for plant managers to improve tracking of supervisors under direct control.

o Conducted spend analysis (MS access, business objects, Excel) with commodity classification, leveraged national contracts, achieved 20% net savings & improved customer service levels.

o Analyzed $6M cable/phone/Internet service demand, analyzed provider quotes, queried databases (SQL server, SSIS, SSRS, SQL) and performed forecasting & budgeting to optimize savings.

o Participated in implementation of PP module in a make-to-Stock and make-to-order environment, involved in Sales & Operation Planning, Demand Management, Long Term Planning, MPS, MRP, Production Orders, Capacity Planning, configuration of Master Data - Material Master, Work Centers, BOM, Routing, CAPP, analyzed business requirements, did fit-gap analysis, design, customization & fixing of bugs - improved service by 30% & reduced inventory levels by 20%.

o Used risk analysis (Hyperion Solutions, Excel) for capacity planning / manufacturing, optimized flow during order fulfillment & improved demand/sales forecast by 15% using planning models.

o Performed competitive benchmarking analysis (Hyperion) by measuring key metrics, achieved reduction in working capital, increased profit margins per rolling tons, reduced freight & storage costs, minimized inventory write-offs and improved inventory turns, gross margins and EBITDA.

o Participated in development, consolidation & reporting of technology business services’ business plans, annual operating, capital budgets and quarterly forecasts, provided analytical and financial support services, coordinated with decision support team in reviewing and reporting of budget variances, forecast updates, variance analysis and yearly trending analyses for line of business.

o Programmed accrual logic, partnered with electric, gas, coal & transmission companies to provide variance insights, researched improvements in budget preparation, forecasting, cost control, performance measurement & operational metrics and participated in process improvements to ensure Hyperion modifications were incorporated on a timely basis into business plan budgets.

o Worked as business analyst to segment customers by revenue, product mix, frequency of purchase, customer loyalty & participation in promotions, classified product pricing by premium/discount to standardize price, analyzed price history, regional /market variability, transaction volumes & developed pricing system to apply price adjustment per customer & meet revenue targets.

Contact this candidate