PROFESSIONAL SUMMARY:

• Business - focused Information Technology (I/T) professional with over 20 years of experienced in each step of the application building process: Interviewing, Business and Process Modeling, Coding, Testing, and Implementation. Experienced in ERP Projects: From developing the Request for Proposal (RFP) to implementation.
• Skilled in envisioning and understanding complex business processes as well as analyzing detailed work flows. Knowledge of 360 view. Adept at quickly developing fluency in business function-specific terminology and communicating with people at all levels in an organization. Effectively translate business needs to IT personnel and IT concepts to business people in both written and verbal communications.

TECHNICAL SKILLS:

Technical: T - SQL SSIS/SSAS SSRS Sharepoint Ellucian (Datatel) ERP System Oracle Forms and Reports PeopleSoft CRM 8.9 PeopleSoft HR 8.8 8.9 (Benefits, T&L, eRecuirt) PeopleSoft FS 8.4 9.0 (AP, AR, BI, PC, GL, PO, Assets ) PeopleSoft EPM 8.8- 8.9 PeopleSoft PPM 9.0 PeopleSoft SQR, People code & Application Designer Integration Broker Application Engine Crystal Reports nVision Client/Server application developer using: Oracle Developer & Designer 2000 SQL & PL/SQL Help Desk Access97 & Access2000 Visual Basic for Access VBA Visual Studio ( 2005/2010) JCL - IBM-390 - MVS operation system. IMS CICS Query FILEAID XPEDITOR AS/400 Cobol

PROFESSIONAL EXPERIENCE:

Confidential, Cicero, IL

Responsibilities:

• Created WEBI reports for Informational Research department.
• Maintain WEBI system by working with end users.
• Work with Department heads to Designed and Developed Applications on the ERP system.
• Maintained Existing Application on the ERP system.
• Liaison with Ellucian for trouble shooting on the ERP system.
• Designed and Developed Mappings for data migration.
• Developed SSIS packages to update Sequel Server database
• Developed T-SQL procedures for Crystal, SSRS reports
• Performed data validation, reconciliation and error handling in the load process.
• Documented the test cases and results for future understanding and .

Environment: T-SQL, Crystal, Envision Basic, SAP WEBI, Business Objects XI, Flat Files, Datatel Colleague application and SharePoint 2010

BI Specialist

Confidential, Muscatine, IA

Responsibilities:

• Developed a project plan for the Data warehouse
• Designed and Developed Mappings for data migration using Visual Studio
• Load Data from Excel to MS SQL 2010 using SSIS
• Design Data Warehouse using SSAS
• Performed data validation, reconciliation and error handling in the load process.
• Documented the test cases and results for future understanding and .

Environment: T-SQL, SSIS, SSAS, Excel

Consultant

Confidential, Chicago, IL

Responsibilities:

• Covert reports from MS Access to SSRS
• Design and Developed SSRS reports
• Performed data validation, reconciliation and error handling in the load process.
• Documented the test cases and results for future understanding and .

Confidential, California

Businesses Intelligence Analyst

Responsibilities:

• Gathered requirements for the report programs & applications
• Identifying the tables and fields and necessary calculations required for the application
• Interviewing the requestor either face to face or by phone or email.
• Update selected SQL Server database tables based on the requirement gathered from Oracle Database tables using SSIS
• Determined which calculations would be done in T-SQL or in Crystal
• Developed and write T-SQL procedures
• Unit tests the T-SQL procedure by entering predetermines input data making sure the output matches the expected output.
• Crystal Report was created from the front end report based requirements, developed a prototype was sent to the requester to get more refined requirements (based on the input for the refined Crystal Report)
• Format of the Crystal report based on user requirements
• Making sure applications meet all requirements
• Deployed the application to production with the required security access.
• Test the report in production, making sure the transfer went smoothly.
• Once the report tested successfully in production, it is released to the requestor.
• Complete the required documentation for the Crystal report program
• Followed up with the requestor after a couple of weeks, making sure the report is running as expected.
• Submitted Weekly Status reports and timesheets

Confidential

Data Analyst

Responsibilities

• Gathered requirements for the report, identifying the tables and fields and necessary calculations required for the report by interviewing the requestor face to face.
• Determined which calculations would be done in T-SQL or in SSRS
• Wrote the T-SQL procedure
• Unit tests the T-SQL procedures by entering predetermine input data making sure the output matches the expected output.
• Developed SSRS front end report based requirements,
• Peer reviewed SSRS reports making sure it meets the basic requirements
• Developed prototype report for the requester to get more refined requirements (based on the input for the refined SSRS Report)
• Unit test SSRS report by entering predetermine input data, making sure the output matches the expected output.
• Deploy the report including the T-SQL procedure to production with the required security access.
• Test the report in production, making sure the transfer went smoothly.
• Once the report tested successfully in production, released to the requestor.
• Complete the required documentation for the SSRS report program
• Followed with the requestor after a couple of weeks, making sure the report is running as expected.
• Submitted Weekly Status reports and timesheets

Confidential, Kansas City, MO

Tax Examiner Clerk

Responsibilities:

• Examine X tax returns for accuracy
• Correct X tax returns

Confidential, Kansas City, Kansas

Data Analysis

Responsibilities:

• Plans and schedule projects to ensure efficiency of resources.
• Provide analysis of performance and variance
• Provide analysis of marketing events. Designs and implements accurate, secure, and efficient databases using T-SQL, SSIS, SSAS and SSRS.
• Also utilizing Oracle SQL and Microsoft Visual Studio.
• Interview End users for requirements

Confidential, Odessa, MO

Enumerator

Responsibilities:

• Collecting Data for the 10 year Census.
• Plan the work day
• Locate Address to make sure it is valid
• Conduct interviews

Confidential

PeopleSoft Programmer Analyst

Responsibilities:

• Independently gathering requirements for PeopleSoft Programs
• Wrote and modified 60+ programs for PeopleSoft.
• Designed, Wrote and Tested SQR programs using PS Application Designer for PeopleSoft Financials 8.9, People Soft HR 8.9, PeopleSoft Financials 8.4 and People Soft HR 8.8, CRM 8.9, EPM 9.0
• Wrote programs for PS Financial modules, Accounts Receivables, Accounts Payable, Purchase Orders, Project Cost and General Ledger
• Working with the City’s Internal Auditors to produce report programs in PeopleSoft Financials of the City’s Finances
• Writing programs for PeopleSoft HR modules, Benefits, Payroll and
• Wrote and Tested SQR programs using Application Designer for PeopleSoft HR 8.8 -8.9 Module
• Wrote and Tested SQR programs using Application Designer for PeopleSoft Enterprise Project Management, EPM 8.9 Module
• Provide Consultation with other developer on more complex assignments
• Use Integration Broker, PeopleCode to write PeopleSoft Programs
• Use PeopleSoft Tools 8.49: Application Designer, Process Scheduler and Cube Manager to write PeopleSoft Programs
• Wrote and Tested Crystal Report programs for PeopleSoft CRM 8.9, HRM 8.8, HRM 8.9 and FSM 8.4

Confidential

P eopleSoft Programmer Analyst

Responsibilities:

• Assisted in developing the requirement for the ERP project including the project plan
• Assisted in developing and reviewing the RFP
• Assisted in reviewing vendor proposals
• Lead in developing test scripts for RFP packages
• Lead in vendor check
• Wrote extract programs and data extractions programs
• Wrote ETL programs from ERP Legacy system (Oracle) to PeopleSoft
• Wrote ETL programs from mainframe to PeopleSoft
• Worked on data analysis and data mapping
• Use PeopleSoft Integration Broker, PeopleCode
• Researched PeopleSoft Asset module to determine if it fit the city’s needs.
• Use PeopleSoft Tools: Application Designer, Process Scheduler and Cube Manager

Confidential

Oracle Report Writer/Consultant

Responsibilities:

• Assisted in implementing an Oracle Financial package for the Aviation Department (AIRS)
• Wrote ETL programs from Legacy AS/400 to Oracle Financial
• Liaison with Oracle help desk to solve Aviation Department’s questions and issues with Oracle Financials
• Wrote and Test Form and Oracle Report for AIRS system

Confidential

Aviation Department

Responsibilities:

• Developed the Y2K project plan
• Developed Y2K testing and responds plans for the Aviation Department
• Audit programs and embedded chips to make that the Aviation Department was Y2K compliant
• Coordinated Aviation Department’s Y2k efforts with the rest of Confidential
• Coordinated Aviation Department’s Y2K efforts with the airlines and the Confidential .

Confidential

Programmer Analysts

Responsibilities:

• Interview end users for design and development of programs
• Wrote and Test Programs based on MS/Access with SQL Server as the back end
• Wrote and Tested Cobol programs on the AS/400

Confidential

Computer Programmer

Responsibilities

• Interview end users for design and development of programs
• Wrote and Test Programs based on MS/Access
• Wrote and Tested Cobol programs on the AS/400

Confidential

Business Intelligence Master Program

Responsibilities:

• Implemented a Labor Analysis Business Intelligence solution for a fictitious national construction company.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005/2008 database. ETL capabilities of SSIS were used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Created a number of cubes, dimensions and business critical KPIs using SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Created several MDX queries according to business requirements.