Experience

Catamaran

• United States
• Hospitals and Health Care
• 500 - 600 Employee

• Business Analyst II

  • 2010 - Present



Walgreens

• United States
• Retail
• 700 & Above Employee

• Senior Business Systems Analyst

  • 2008 - Aug 2010

  Worked in development and maintenance of web-based rebate management system (RMS). Worked closely with PBM data warehouse during client contact project to integrate clients, plan details with RMS. Evaluated and created touch point documents between RMS and PBM data warehouse for DSS 2.0 migration. Directed deployment and fallback plan as well as component list during implementation of RMS projects. Completed requirement gathering, use case, database design, system and regression… Show more Worked in development and maintenance of web-based rebate management system (RMS). Worked closely with PBM data warehouse during client contact project to integrate clients, plan details with RMS. Evaluated and created touch point documents between RMS and PBM data warehouse for DSS 2.0 migration. Directed deployment and fallback plan as well as component list during implementation of RMS projects. Completed requirement gathering, use case, database design, system and regression testing, as well as implementation for over 20 successful production releases. Managed complete SDLC process of projects with Java, JSP, PL/SQL procedures, Perl, Shell and Abinito graph components. Automated batch ETL jobs for data processing and system interface with Lawson AP system. Created ETL graphs to load data for system testing and verified results using SQL. Worked closely with DBAs for capacity planning of CDE environment for RMS. Directed quality aspects of client contract project, which saved business 40 hours per week. Created process flow diagrams, data mapping document, logical and physical data model, data transfer and loading design for interface between vendor and company for pharma billing outsourcing project. Contributed to stability and compliance project to automate batch ETL jobs for reporting, data processing and system interface. Saved 40 hours per week of support time. Provided leadership in rapid development environment to support quick enhancement projects. Analyzed existing and future reporting requirements using Business Objects XI. Supplied leadership in RAD meetings and contributed to root cause analysis, identifying and resolving operational issues. Collaborated with DBAs, network and server administrators and security during critical implementation of RMS projects as well as directed quality aspect of projects by managing system, regression and user testing. Show less



MASCON

• Consultant

  • 2008 - 2008

  Served as consultant in design of new benefit administration system for third-party benefit administration company. Analyzed existing and future systems as well as created workflow and process flow diagrams. Gathered business, regulatory, user and functional requirements for new system and documented interfaces for bank ACH, A/R and G/L.



HSBC

• United Kingdom
• Financial Services
• 700 & Above Employee

• Senior Business Analyst

  • 2001 - 2007

  Partnered as business analyst in development of GUI-based customer service application to support private-label credit card operation of HSBC Bank. Managed SLDC of many projects for customer service application CHAMPS and collection department, completing on time and within budget. Oversaw backend view information for CHAMPS application development. Developed ES framework architecture standards for new enhancement, policies and procedures to implement. Completed business… Show more Partnered as business analyst in development of GUI-based customer service application to support private-label credit card operation of HSBC Bank. Managed SLDC of many projects for customer service application CHAMPS and collection department, completing on time and within budget. Oversaw backend view information for CHAMPS application development. Developed ES framework architecture standards for new enhancement, policies and procedures to implement. Completed business requirement gathering, process flow diagram, use case, functional and technical design, logical and physical data modeling using ERwin as well as design for collection cross-sell and customer service offer prompts projects. Oversaw GUI changes for projects related to merchant credit card launches. Converted customer service application to J2EE platform. Contributed to version upgrade projects, ORM, SMG3 implementation and backend conversion project from WHIRL 2.5 to 8.0. Completed six sigma late fee waiver process improvement project which reduced waivers by 20%. Led automation of interface with credit bureau for credit line increase and reinstatement process for credit department. Reduced call handling time. Developed credit card collections application with dialer option which improved call handling time significantly. Created commercial credit card application, growing business significantly. Implemented ORM software which contributed to monitor credit card operation risks. Implemented web-based operational risk management software with Oracle as backend. Collaborated with customer service, collections, Canada operations, commercial card operations and IT team to manage various CHAMPS releases. Designed interface between CHAMPS and data warehouse of HSBC customer accounts called Mars. Contributed to projects involving VRU, Davox Dialer and FileNet interface to retrieve archived credit card statement. Led disaster recovery and system stress test projects. Show less



MASCON

• Senior Systems Analyst

  • 1990 - 2001

  in design, development, support and implementation of first Windows-based commercial ERP software package for plastic processors, AIMS. Worked extensively on financial modules accounts receivable, accounts payable, budgeting, fixed assets and general ledger. Worked on supply chain and MRP modules. Created barcode interface for production tracking, which increased accuracy and productivity. Contributed to database design and implementation of consolidated financial data warehouse for… Show more in design, development, support and implementation of first Windows-based commercial ERP software package for plastic processors, AIMS. Worked extensively on financial modules accounts receivable, accounts payable, budgeting, fixed assets and general ledger. Worked on supply chain and MRP modules. Created barcode interface for production tracking, which increased accuracy and productivity. Contributed to database design and implementation of consolidated financial data warehouse for customers with multiple companies. Completed data mapping, conversion and loading projects during implementation of ERP package. Gathered requirements from customers for enhancements to ERP package and created customer reports using Crystal report. Led design and conversion of backend database from SQL server to Oracle and DB2. Advised customers on application security configuration, database archive and backup procedures. Developed web interface for order entry, order tracking, RMA management, customer balance inquiry, customer part price inquiry, as well as quotation system. Show less



Bharat Electronics Ltd

• Systems Analyst/Programmer

  • 1986 - 1990

  Worked in development and of a MRP system and developed BOM, Purchasing, Accounts Receivable and Scheduling modules.