SUMMARY:

• Over 10 years of experience in analysis, design, program developing, implementation and support of business applications, including 4 years of experience in SQL Server Reporting Services 2005, Crystal Reports10, QA analysis & testing on Microsoft SQL Server, with experience in testing on Data Warehousing front and SAP ERP implementation projects and 4 years of Sap Master Data.
• Consumer Goods: Processed and Packaged goods.
• Financial Institutions: Auto & Credit card loan processing.

EXPERTISE AREA:

• Strong knowledge of Software Development Life cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing
• Experienced in SAP implementation on SD, MM, PP, PM, QM, FI, and CO modules
• Experience in conversion of CrystalReports10 to SQL Server Reporting Services
• Good organizational skills and ability to multi task well
• Expertise in developing, organizing and executing test scripts using Test Director.
• Experienced in documenting test results and defects encountered using Test Director
• Experienced in Backend Testing using SQL queries
• Experience in Relational Data Modeling with very good focus on creating ER Diagrams and Dimensional Data Modeling
• Excellent leadership qualities demonstrated in variety of projects by taking the initiative, coordinating activities, and monitoring progress.

TECHNICAL SKILLS:

Databases: MS SQL Server 7.0/2000/2005, Access

Software: SQL Server 2005 Reporting Services, Crystal 10, Transact SQL, PL/SQL, ABAP, Adage Infor ERP, SAP ERP, Winshutte

Languages and special Software: Microsoft Project 2007, SQL 2000/2005, HTML 4.0, Business Object 6.5, SAP ERP System, ABAP, SAP LSMW

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Population Health Analyst

• Analyze clinical, financial, and claims data
• Create analytics for quality metrics, and scorecards
• Create BI reports as needed for users
• Work with CMS claims data to analyze beneficiary spend
• Analyze potential client data and provide them with analytical data and graphs to show them where they currently stand and provide suggestions on areas for improvement and savings
• Analyze Medicare data and provide analysis to providers

Confidential, Kansas City, MO

Business Analyst - SAP Master Data

• 10+ SAP implementation projects
• Data cleansing project across all DFA plants for material master
• Develop SAP query reports for masterdata team members and end users
• Create/Modify Winshuttle scripts and LSMWs for mass data loads
• Develop SAP queries to assist in data cleansing
• Develop business intelligence (BI) reports from masterdata cubes built by the BI team
• Troubleshoot transactional errors end users have in SAP
• Create access tables and queries for legacy data loads into SAP
• Pull material master, bom, and recipe data from SAP for data cleansing project, this project involves creating standardization across DFA and insuring all materials follow the new standardization process and reducing duplicate data.
• 10+ SAP implementation projects from Adage ERP System to SAP ERP System as well as AS400 legacy system to SAP ERP System. These tasks include but not limited to configuration setup, data mapping for legacy data fields to SAP data fields, pull data from legacy systems and load into sap, and SAP query report development for end user for regulatory and state requirements
• Lead project in fluid milk implementation from AS400 legacy system to SAP, this data includes materials, producers, vendors, customers, hauler, field representatives, and intermediary stations.
• Lead project in MRO material data cleansing and removing duplicate materials, this involved pulling data from SAP and analyzing the data for duplicates.

Confidential, Atchison, KS

Data Analyst/SAP Support

• 2 SAP implementation projects
• Make enhancements to reports that a business user requests
• Work with end users to ensure requirements for reports are as expected
• Move existing crystal reports to SQL Server Reporting Services 2005
• Creation of stored procedure and views for reports
• Modify existing triggers and jobs
• Define and analyze software-related problems and recommend solutions
• 2 implementations projects from Adage ERP System to SAP ERP System. These tasks included but not limited to configuration setup, master data setup, report development and modifications on SAP Scripts, Smart Forms, and Adobe Interactive Forms using ABAP programming, and SAP system support.
• Implementation from Alcohol Microsoft Access Database to Adage ERP system for all alcohol and fuel transactions. These tasks included the creation of Crystal and SQL Server Reporting Services reports used for alcohol transactions, shipments, inventory, government reporting, federal reporting, and export shipments.
• Developed reporting for Monthly TTB Alcohol reporting in SSRS.
• Developed new reports for daily, monthly, quarterly, and annual Renewable Fuel Standard RIN reporting in SSRS.
• Lead and created the reporting request process and documentation that is required for new or enhanced reporting.

Confidential, Saint Joseph, MO

QA Analyst/Tester

• Assisted and participated in all phases of the business process and technology deployment life cycle, including business process design and requirements identification, functional design, development, quality assurance, training program design and delivery, and user acceptance activities
• Assisted Test Lead, Testers understanding business process and help them successful completion of Unit Testing, Integration Testing and Requirements Testing.
• Help develop use cases, project plans and to manage project scope.
• Perform Impact Analysis to estimate the effects involved with changes in requirements, evaluating their impact on the project as a whole.
• Collect information and data from other departments regarding inputs/outputs, triggers, dependencies and process interfaces.
• Provide strategic support in development of detailed project plans, work assignments, target dates etc.
• Projects involved are:--
• Testing of the remote Delphi based front end for the auto & credit card data processing for the transactional systems & validation of the data against the tsys mainframes...
• Testing of the calling list generation & the integration with the cti interface of genesys for the dialer
• TRS (Tempest recovery system) website testing.
• CUNA web testing.
• Assisted in designing the test cases, test plans & strategy during the different credit card portfolio deals.
• Design the test plan, test cases, and conditions for the Data Warehouse testing for the phase1 & 2. Help define and create auditable processes and documentation for all DWP2 activities.
• Identification of SST business processes, applications and data sources that will feed the SST EDW from the testing perspective.
• Testing of the ODS for the 800000 credit cards account loans for phase1 & integration of the same with auto loan accounts in the phase2 with Sql server 2000 oltp as source & operation data store (ODS) / Datamart set up on sql server 2005 as target environment.
• Design/implement strategy for the testing of numerous backend processes on sql server 2000/2005 servers in stored procedures/dts & SSIS packages for the Remote transactional & ODS/Datamart loads.
• Design/implement strategy for the testing of numerous etl processes designed in Informatica for the nightly transactions batch processing. Excellent experience in testing of the informatica workflows/mappings in informatica 6.1/7.1
• Use of the parameter files for the configuration of the informatica workflows in different environment.
• Testing of the complex DTS package with embedded FTP tasks, pgp encryption through the batch files for the data import through the excel/ascii/ebcdc files to sql server & export from db to excel/ascii/ebcdc files for the TSYS uploads.