Technical Trainer/Service Manager

SATISH PRASAD

***** **** ** 510-***-****(h)

Union City, CA 94587 510-***-****(c)

E-mail: ******.******@*********.***

Technical Career Summary:

Perform Reporting Analytics, User Acceptance testing on new membership plans. Create SQL scripts to capture statistics for all records processed and data load in production.

Use Hyperion to create scripts and validate Eligible Data prior to customer data load in FACETS 4.31. Review HIPAA data files; Perform quality assurance functions, Technical Support Analyst and Project Management. Technical professional with 15+ years in Business and Technology Applications Development using SQL and SAS platforms, business and functional Implementation utilizing Data Modeling techniques.

Prepare Functional specification & Business conversion requirements docs.

United Health Group

Business Systems Analyst Mar 2009 – present

Review and Translate Eligible Benefits and Retirement Plan for BH/EAP/WL PPO/HSA plans for new and existing customer Accounts.

Create / update business specs for all existing accounts. Implement functional test / HIPAA 834 and standard file layout for existing customers. Interface with account managers to incorporate new Group Structure, Packages, Plan codes and prepare business specification for program development.

Perform data validation using HYPERION 8.3 in QA process prior to loading eligible data files into UBH FACETS e 2 4.31 application.

Premier Source Aug 2008 – Feb 2009

Business Systems Analyst

 Develop SQL and SAS macro scripts for reporting requirements, Perform conversion of Patient Plan and pharmaceutical drug Data into SQL .Net.

 Create and Test scripts to ensure Data Validation and Integrity – using Microstrategy. Conversion from MS Access to SQL. Excel Data load into MS SQL tables using ODBC connection.

 Manage and update prod server database and ensure Data Validation from flat files and HIPAA data layout, Data Mapping data code and data migration into production –

 Use MS Excel for Data Analysis, using Patient, payers, pharmacies and insurance data. Create Pivot Table and generate reports per user customization.

 Perform Business Development for Reporting Analytics and track reported issues are resolved from Application and Database perspective.

 Provide technical support on DAQ billing application.

Ameri Source Bergen - Lash group Dec 2007 – Jul 2008

Business Database Analyst

 Develop Conversion Plan, Perform conversion of Patient Plan and Drug Data to SQL .Net Test scripts Data Validation and Integrity - Access to SQL.

 Develop SQL scripts to ensure Data Validation from flat files, GIS member banks data Mapping data code and data migration into production.

 Use MS Excel for Data Analysis, Pivot Table and report customization.

 Perform Business Intelligence Reporting Analytics using MS tool.

Sterling Bank and Trust July 2006 - Sept 2007

Marketing Data Analyst

 Develop design documents for Credit and Marketing analysis, secondary pricing, and enhancement on Mortgage applications.

 Meet with users to discuss the business requirements and write functional specification for project implementation in Credit and Marketing Analysis.

 Assist users in training on the enhancement of the existing financial application – create and test SQL / SAS macro scripts.

 Apply Micro Strategy tools for Credit/ Pricing and business reporting.

 Collaborate testing and update functional / technical documentation.

Wells Fargo Home Mortgage Feb 2005 - May 2006

Business Consultant

 Manage producing Sub-prime mortgage consultants regarding pricing, assist in problem solving and provide workable technical solutions to business issues.

 Use ACT database and MS Excel spreadsheet data analysis for sales and marketing purposes.

 Generate business reports using MS-Tools and ODBC with Oracle 9i database.

 Horizon Financial Associates Jan 2002 - Feb 2005

Mortgage Consultant

 Execute marketing products and establish relationship with clients.

 Provide resource and leverages on Conventional Loan Programs - Adjustable-Rate Mortgages, Reverse Mortgages, 504 and SBA loan programs. Cost and Income approach to Market Value and coordinate funding conditions.

 Analyze Income/Debt Ratios, NOI, TVM, NPV, IRR, CFAT, SPAT & CA

Sun Microsystems Inc, Newark Mar 1997 - Dec 2001

IR Systems Engineer / Project Manager

 Managed software applications Configuration Management, product deployment, performed builds using make file PERL CGI scripts, and validate application functionality – Oracle apps and database.

 Install versioned released Supply Chain and Engineering applications into IST, STG and Production environment.

 Maintain security profiles and Middleware vendor license updates Web logic.

 Version controlled releases and code promotion using Clear Case, Clear Quest and Team ware products.

 Debugged PL/SQL, SQL & Java scripts during promotion process.

 Web logic, I planet Web server, MS-SQL server and other 3rd party product application installation configuration and technical support. Generate reports using Hyperion

 Delivered shell scripts for applications implementation and deployment within the strategy and business architecture group for software engineering resulting in savings > 350K as project lead.

 Led project definition and specifications; liaison with business users for functional analysis, user requirements, data flow and applications development and implementation in the areas of Oracle Manufacturing, Supply Chain, Order Management and Financial applications. Data Warehouse cleansing during conversion.

 Defined report groups, managed development of batch scheduling, product testing in a controlled environment and release into production server.

 Provide UNIX systems, Win NT and MS Access, ACT and Oracle database technical support.

 Defined the Multi-Organization structure for ES production database Oracle 10.8 release and configuration.

 Project lead on Items/Bill Of Materials conversion from CAS to Oracle production database.

 Imported Information Highway subscribed Parts/BOM events CAS data into ES Oracle Inventory and BOM applications.

 Provided applications technical support and development of Oracle packages, concurrent programs, procedures, triggers using Pl/SQL and Data Warehousing.

Major Projects

Order Entry / Accounts Receivables Modules:

 Created Play Pick Release and Shipment Confirmation solution document for OFC/PDC(GSP)

 From shipments matrix designed and created table layout for all shipment subscribed data interfacing with Sun's IH published events.

 Managed detailed test activities for Commercial Invoice applications.

 Analyzed the business requirements for Back-door Shipments; created empower scripts; implemented the full life cycle development of the print Commercial Invoice module and Reports for non PDC/OFC shipments.

 The Commercial Invoice Report resulted in expediting of the billing for all Computer Systems customers.

Cost Management:

 Auto Close Work Orders: Developed a concurrent program interfacing with the manufacturing application. Cost Management and WIP applications to close all Discrete Job Work Orders with variances > $5K. Project benefits Cost Management by automating functionality and reducing headcount.

 Cost Sharing between Plants: Implemented concurrent programs, Oracle database triggers interfacing with the Inventory and Cost Management Application.

 Prepared test scripts for each module and conformed results with users prior to production release. Project benefits sharing product costs between Sun Plants.

California School Employees Association, San Jose Aug 1995-Jan 1997

Systems Analyst

 Managed implementation and installation of the Oracle Financial Applications release 10.6. (General Ledger, Accounts Payable, Purchase Order, Accounts Receivables and Order Entry).

 Interacted extensively with users to successfully implement business requirements, provide applications technical support.

 Performed Oracle database tuning & administration functions

 Trained users during post implementation and incorporated enhancements into production.

Bay area Air Quality Management District Apr 1993-Jun 1995

Programming Analyst

 Senior position for applications software development, analysis, design, code debug, testing and implementation.

 Transform existing legacy Databank systems and processing into HP-UX9000 UNIX environment using Ingres and MS-SQL development tools.

 Determine business requirements for users and translate into applications.

 Validate and test application functionality, incorporate business systems requirements in the development and implementation phase.

 Delivered General Billing Accounts project where I developed the following modules: Adjustment Amount Account, Late-fee Override calculation, Adjust Cancelled Fee, Merger Accounts and Material Management.

 Coordinate detailed testing with users per test specification and provided technical support in systems performance & query execution plan

Gensa Corporation, Oakland, CA Apr 1992 - Mar 1993

Programming Analyst

 Delivered applications conversion and enhancement of the existing Worldwide Port Systems (WPS) at Oakland Army Base.

 Project encompassed application analysis; design, coding, testing and production support using Oracle FORMS, REPORTS on HP-UX9000 platform.

EDUCATION

BA Mathematics and Economics

University of the South Pacific, Fiji

Diploma in Applied Statistics and Data Processing

University of the South Pacific, Fiji

Certificate Relational Database Management Systems

Auckland Tech. Institute, Auckland

Financial Analysis CCIM Institute, Illinois

SAS Data Analysis UC Berkeley, Extn

Contact this candidate