SUMMARY:

• I am an expert in financial analysis and information technology both functional and technical.
• I supported budget financial planning includes budgeting, forecasting, variance analysis, decision analysis, and long - term planning initiatives.
• I developed and maintained different financial reports, supported department user training, involved in many internal and external audits and project implementations involve Software Development Lifecycle (SDLC).
• I was a problem solver includes improve overall systems functionalities and troubleshoot System’s issues.
• I was involved in requirement gathering, testing, data analysis, security administration, production support.
• I am liaises between business units, technology and vendors.
• I have worked on many projects including Enterprise Resources Planning (ERP): Oracle, PeopleSoft, Hyperion, Essbase, Siebel-CRM and Lawson.

TECHNICAL SKILLS:

Languages: C, Visual Basic, Java, SQL, PL/SQL, SQL plus, HTML, JavaScript, Siebeland Webfocus

Database: Oracle, MS SQL, Access

OS: MS-DOS, UNIX, and Windows 9x, NT, 2000, 2003 and Windows 7

Applications: Microsoft Suites, Outlook, Access, DreamWeaver, Photoshop, Visio, MS Project and SharePoint, MainFrame Environment, Peoplesoft HRMS, CRM-Siebel, Lawson, SAP-BPC, Hyperion, Essbase

PROFESSIONAL EXPERIENCE:

Confidential

Financial Systems Administrator

Responsibilities:

• Managed and maintained day to day operation of Hyperion application to support budget financial planning including budgeting, forecasting, variance analysis, decision analysis, long-term planning and accounting initiatives throughout the organization.
• Acted as liaison between business units, technology and vendors to provide technical support for users within Capital and Budget department and other departments such as Payroll, Accounting, Human Resources and Technology.
• Administered system applications, databases and security for Hyperion.
• Provided support on month end and year end closeouts, forecast, human capital planning, expense and revenue analysis in Oracle general ledger, Human Resources and Hyperion application.
• Provided support in annual budget submissions to City of Chicago, Monthly and year end load data from source environment Oracle General Ledger, Human Resources to target Hyperion environment thru FDMEE and ODI.
• Evaluated, enhanced and improved system functionalities and efficiencies. Troubleshooted technical and functional issues.
• Assisted with budget preparation by creating new and modify financial reports via Hyperion Smartview, FR studio and batch reporting.
• Completed implementation of Hyperion system upgrades to 11.1.2.3 and patches. Evaluated system modifications and user enhancement requests. Updates metadata and performs data updates, and data validation.
• Maintained system security and grants user access to system. Migrated data between various environments (Production, Test and Development). Reviews and updates business rules and calculation scripts.
• Managed task list with Oracle cloud/host management and created Oracle service request and request to change tickets.
• Worked on integration project Oracle EBS R12 and Hyperion. Successfully integrated Oracle Human Resources and Oracle General Ledger to Hyperion.
• Ran SQL queries for position data, inventory files, overtime file and audit information.
• Worked with both internal and external auditors to audit overall systems and financial data.
• Conducted training on Hyperion planning workspace, SmartView and overall annual budget process to department users and onboard new user training as needed.
• Created, managed and performed system/integration, user testing activities for releases, upgrades and patches.
• Created technical and functional documentations for user reference and training.
• Updated and managed SharePoint website documents for the Capital and Budget department.

Confidential, Chicago, IL

Financial Systems Analyst

Responsibilities:

• Supported various accounting teams including Tax, Accounts Receivable, Accounts Payable, Revenue, Sales Incentive, Financial Planning and forecasting, and International finance and accounting.
• Maintained and troubleshot applications such as Lawson financial, SAP-BPC10, ImageNow, Document Express, SharePoint, and Velocity. Worked with vendors to resolve issues.
• A key participant in system implementations and upgrades; Developed and lead UAT activities with end users to support release of new versions or functionality, such as upgrade SAP from BPC7 to BPC10 and update to Lawson LSO.
• Wrote database queries Microsoft SQL and Microsoft SSRS reports.
• Prepared for periodic security review quarterly audit by Confidential and Confidential . Responsible for systems security and audit requests for Sarbanes-Oxley compliance. Sent management financial systems reports to ensure up-to-date security access for users and groups.
• Developed and maintained Finance SharePoint sites such as developed new wiki libraries, pages and maintain user security access.
• Provide financial system support during month-end close.
• Investigated and identified root causes of errors. Re-engineer processes using lean methodology to ensure that client needs are met.

Confidential, Chicago, IL

Data Engineer

Responsibilities:

• Setup financial credit data information to financial institutions in a timely production environment by executing in batch fulfillment systems in both a mainframe and web based environment.
• Collaborated with Technical Consultants on translating system designs into system configurations. Reviewed specifications, interpreted and coded criteria and backend using JCL, SynSort and others data systems to furnish credit data to customers.
• Developed and executed test plans, and validated batch fulfillment system setup and output data, developed and validated reporting output, audit forms, final static and make sure data flow and data accuracy.
• Analyzed data during all steps of the setup to ensure integrity, troubleshooted and resolved issues that occur.
• Wrote up summaries and sent email notification of marketing promotions to customers.
• Ensured data are ready for customer download in timely manner as indication in customer order specification letter.
• Audited test results, and ensure desired output is attained and validate data accuracy.

Confidential, Chicago, IL

Technical Support Specialist

Responsibilities:

• Managed and supported PeopleSoft HRMS system, was the liaison between IT, HR, Finance, Payroll and external Venders such as ADP, Northern Trust and others.
• Documented requirements, created test plans and scoped documents for various projects such as PeopleSoft upgrade implementation team from version 8.8 to 9.0.
• Ensured PeopleSoft HRMS systems met customer satisfaction by creating queries, reports, and analysis and researched production issues, logged Oracle cases, logged
• Cleared Quest defects and assisted various functions in both business and technical aspects through support and technical related inquiries.
• Supported PeopleSoft Time and Labor and North American Payroll, biweekly payroll for over 16,000 exempt, nonexempt and union employees in production and various environments.
• Lead tester and support person for projects such as W-2, Tax Updates, Time and Labor bundle update, Union bonus, Payroll releases and other projects in various environments before project migrate to production.
• Followed SDM methodologies for project implementation for all projects test life cycles, made sure project deliver on time within budget.

Confidential, Schaumburg, IL

PeopleSoft Application Developer

Responsibilities:

• Developed PeopleSoft applications using PeopleTools, Application Designer including projects such as Holiday Alerts, Update Delivery on Off-Week Orders, Product Alerts for Same Size Orders, Customer Order Minimums and Product Promotions.
• Created and maintained views and tables in Oracle and PeopleSoft databases and served as administrator to grant access to views and tables.
• Provided technical support on all PeopleSoft technical issues supports all daily run application engine jobs and SQR Reports.
• Supported clients in call center for all promotions and marketing of new product launch.
• Supported and maintained development, test, conversion and production environments.
• Developed technical and functional documentations, PeopleSoft security, project migration and other documents on projects, and present to Change Control Group for major project migration.
• Worked with individuals from various functions/levels includes business partners, users, IT teams and business analysts to make sure projects are successful deliver on time on budget.
• Provided unit and system testing on applications, enhancements to existing applications and fix bugs and errors.

Confidential, Northlake, IL

Process Improvement Analyst

Responsibilities:

• Gathered requirements for large-scale Siebel Analytic reports for various business functions including Order Management, Service Order, Cash Management, Order Fulfillment and Incentive Compensations. Identified Standard Operating Procedures, current and future process maps to improve business processes for Human ResourcesPayroll and Company.

Confidential, Northbrook, IL

Application Developer

Responsibilities:

• Worked on Siebel CRM application developments, technical documentations, unit and system testing, fixing product defects and maintaining and developing Actuate reports and Webfocus reports.
• Implemented Siebel projects such as Allstate Recovery System, Risk Management Business Center, Call Centers, Campaign Management Siebel upgrades and other projects for various departments and Agencies.
• Provided technical and functional inputs of unit test plans, requirements, and project estimations, project risks to testers, business analysts, project managements, end users and fellow teammates on project implementations. Responsible for the functionality of applications in various environments such as development, system test, performance, and production.
• Ensured accurate project estimation through resource allocation and project costs by meeting milestones and delivery dates.
• Worked as configuration manager to ensure all projects are Capability Maturity Model (CMM) level two compliance by meeting customer satisfactions and enable project process improvement.
• Served as main coordinator in the team to maintain and implement disaster recovery planning and business continuity planning. Document backup plans, softwares and hardwares and contact list and test emergency call trees in Confidential application.

Confidential

Data and Reporting Specialist

Responsibilities:

• Worked in Personal Line Finance department to develop financial reports such as agency revenue, expense and forecast reports for management, financial analysts and field agents by using applications such as Web Focus, Microsoft SQL, HTML, Javascript and Essbase.
• Modified and manipulated data on Microsoft SQL, Access, Excel, Essbase and DTS.
• Assisted in troubleshooting, supporting and solving problems on reports.
• Effectively interacted with individuals from various functions/levels. Interviewed clients to gather requirements. Transformed business needs into technical specifications.
• Tested data and applications to ensure accuracy delivery of data and information for analyst.
• Created documentations and help files on developed applications.
• Managed reporting projects from the beginning to the end of the project life cycle.
• Diagnosed issues and analyzed trends to explain and strengthen understanding of financial results.

Confidential, Chicago, IL

Staff2 Consultant

Responsibilities:

• Developed a Service Tracking Database in PeopleSoft 8.12 using PeopleTools, Application Designer, PeopleCode and Crystal Reports to track technical and client Request problems.
• Helped to win a multi-million dollar client project by helping debug SQR’s and SQC’s in PeopleSoft 8.12 demo before presenting to client.
• Researched PeopleSoft technical infrastructure, test cases, technical tools, security usage in client project.
• Completed HRMS 8.12 Manager, Employee, and External Applicants eRecruit test cases for client demonstration and documented all test cases for client use.
• Helped client develop standard Dunning Letter Crystal Reports for aging AR Billing.
• Assisted clients in developing standard documentation and troubleshooting technical issues relate to SQL, Data Mover Script, import manager, application designer, and application engine.
• Developed and revised the application to increase the performance of the Payroll SQR. Confidential (PeopleSoft HRMS and Finance Implementation) PeopleSoft 7.5
• Developed aging Crystal Reports and SQR Customer Account Sales reports to track billing inquiries of international clients.
• Assisted clients on troubleshooting on technical issues and application development in relates to PeopleSoft PeopleTools, application engines, PeopleCodes, Panels, crystal reports and SQRs.
• Debug PeopleCodes in PeopleSoft debugger to make sure is bug free before signing to production.
• Completed technical specification for wage verification and wage statement reporting.
• Performed as a Project Management Analyst role to assist with the project Kick-Off