SYSTEMS APPLICATION ENGINEER ENTERPRISE-WIDE TECHNOLOGY DEPLOYMENTS

• Over twenty years of experience in providing proven solutions in application development / implementation and technology project management, primarily within the banking, automotive, payroll, human resources and financial service space.
• Proficient in multiple technologies, but specialties include PeopleSoft HCM, PeopleTools, PeopleCode, Autosys, PL/SQL, T-SQL, SAS, SSIS, DTS, Unix Shell Scripting, ksh shell scripting Korn Shell Scripting, Perl Shell Scripting, Awk Shell Scripting, Toad, Autosys, Application Engine, SQLPlus, SQR, SQL in various platforms, including DB2, SQL Server and UNIX / Oracle environments.
• Consultative systems analyst with track record of cross-functional training, system development and enhancements, monitoring and performance metrics for better transition and alignment with client deliverables. This also includes activities in the space of designing, developing, testing, documenting, implementing and maintaining software applications.

CORE COMPETENCIES

SQL Server 2005 PL/SQL Autosys SQL Server Integration Services SSIS Data Transformation Services DTS SQL Server Management Studio Unix Shell Scripting ksh shell scripting Korn Shell Scripting Perl Shell Scripting Awk Shell Scripting Transact-SQL T-SQL Subversion SVN and TortoiseSVN Visual Studio 2005 Implementation / Migrations Knowledge Service Deliverables Client Service Solutions Client/Vendor Management SAS Systems Design Specifications SDS Disaster Recovery Planning NA/Global Payroll Deployment Infrastructure Stability Technical System Specification TSD Upgrades Cost/Benefits Analysis Internal/External Deployment Management Deliverable Capacity

TECHNOLOGY IMPLEMENTATION CORE COMPETENCIES

PeopleSoft Oracle Service Deliverables PL/SQL Unix Shell Scripting ksh shell scripting Korn Shell Scripting Perl Shell Scripting Awk Shell Scripting Oracle 10g Oracle 11i Unix AIX Unix/Sun Solaris Solutions PeopleTools I/II PeopleCode Autosys Client Management TOAD Remedy Ticket Solutions Application Engine Visio PeopleSoft Financials 9.0 General Ledger GL Asset Management AM TCP/IP Solutions Data Mover PS/Query Disaster Recovery Planning Process Scheduler Process Monitor UAT Solutions Software Problem/Resolution Management Software Development Lifecycle SDLC Systems Engineering V Diagram SQR Unix Shell Scripting Crystal Report MS SQL Server

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst Consultant

• Constructs high priority projects for the Michigan Department of Treasury DTMB which typically requires complex schedules, and integration with other systems, and utilizing vendor participation.
• Collaborates with DTMB clients to develop system requirements, perform analysis activities, make recommendations for process and business flows, and develop consensus on both business and systems requirements.
• Plans and forecasts of projects and documenting and gathering business, functional or technical requirements for software projects.
• Prepares needs assessment.
• Validates resource requirements and develops cost estimate models.
• Conducts and coordinates financial, product, market, operational, and related research to support strategic and business planning within the various departments and programs of the client group.
• Interprets, evaluates, and interrelates research data, and develops integrated business analysis and projections for incorporation into strategic decision-making.
• Plans and coordinates the development of primary and secondary market research studies in support of strategic planning and specific marketing initiatives, as required, and presents findings of studies to client committees.

Confidential

Application / Automation Engineer Consultant

• Conducted capacity analysis and planning to determine insight specific to application development, installation, troubleshooting, and problem resolution for an Oracle upgrade to 11g. Consultative assignment to develop, implement and interpret business requirements for application developers and quality testers. Locate suitable data sources to meet business functional, technical requirements and configuration solutions to the environmental practice EH S entity of Duke Energy.
• Participated in fact finding and implementation discussions with business partners, developers and quality testers.
• Provided specific insights towards the development and deployment of Oracle Upgrade to 11g from 10g along with problem resolutions and documentation.
• Participated in troubleshooting and resolution of operational problems and issues for on call rotation Periodic on-call support 24x7 .
• Successfully developed, implemented and deployment enhanced version of SSRS Report Services of KMS Knowledge Mgt System being used at several of the Nuclear plants.
• Collaborated and developed enhancements to working with EH S compliance data Federally mandated by the US Gov't or applications such as Essential Suite.
• Successfully participated in supporting vendor applications and configuration as well as performing production installations and bundled releases.

Confidential

Sr. IT Business Analyst Consultant a

• Consultative assignment to conduct, develop and interpret business requirements for programmers, developers and quality testers. Locate suitable data sources to meet business functional and technical requirements. Analyzed data documentation and research complex database content to validate data and map data to the business requirements.
• Successfully participated in supporting vendor applications and configuration as well as performing production installations and bundled releases.
• Participate in fact finding and data mapping discussions with business partners, developers, data source experts and quality testers.
• Team lead on projects entailing the business requirements and functionality. Documentation and problem resolutions were created daily during the ticketing system.
• Led projects, allocated and managed resources and managed the work of other team members. Drove efforts during fact finding engagements, including matrices, facilitating meetings, utilizing best practices and interfacing with the business partners to quickly resolution production and non-production issues at Bank of America.

Confidential

SQL Application Developer / DB Analyst Consultant

• Conduct capacity analysis and planning assignment involving creating database solutions. Created and Deployed various application processes for continued support of the Foreclosure Review and Remediation project.
• Designed high quality and robust data access layers, which includes the design specification of the Stored Procedures and/or database services detailed within Systems Design Specifications SDS and Technical System Specification TSD phases.
• Deployed Standards based development methodology utilizing Team Foundation Server TFS , MS Visual Studio 2010. Also provided coding and environmental support for the Development Deployment team.
• Participated and contributed in systems design sessions and contribute to Technical System Specifications TSD documents for the database components using T-SQL, ETL experience.
• Assisted Lead Database Developers Physical Database Designs.

Confidential

DB Application Developer / Analyst Consultant

• Consultative assignment involving developing database table solutions and various application processes for continued support of the device network systems of Bank of America. Ensure service level and customer satisfaction metrics and maintained and build collaborative client
• Performed planning and testing associated as a database developer with SIT / UAT infrastructure code System Integration / Unit Test cases testing of our devices throughout Bank of America network of Workstations, Monitors and Printers. Debugs, supports, and maintains Workstation upgrades and printers.
• Maintained workflow and deployed updates using SQL tables, Data modeling experience, ETL experience, MS SQL Server 2005, and DTS Data Transformation Services Packages in Production. The core workflow system is used to manage the deployment of BAND devices. Group administration and procurement activities are facilitated here.
• Troubleshoot and debug resources necessary to analyze preparedness manage remedial activities and plan for the deployment of product to our business partners. Some of our data sources includes: Asset Center, Tivoli, Foundstone, Active Directory, Corporate Directory, QIP / FindPort

Confidential

Senior Database Engineer / Analyst Consultant

• Created architecture interface for client during first phase of project, which includes: configuring, implementing, managing, batch monitoring and support for global defense products and services conducted through Boeing systems. Supervised and authorized development of more junior level Developers / Analysts to accomplish tasks and serve as the technical lead during the first phase of the project. Ensured service level and customer satisfaction metrics are met and build collaborative customer relationships with client.
• Transitioned products and services from Boeing Inc. defense , as part of the compliance of critical International Traffic and Arms Regulations ITAR accounting functionalities for the U.S. government US Treasury Department with PeopleSoft Financials, 9.0 and documentation.
• Involved in data processing by utilizing Autosys, ksh shell, Unix, Data modeling experience, SAS, PS/Query, PS Monitor and Autosys protocols, to determine the best optimized performance for over 143 Million transactions / records daily. Analyze systems, design, and implementation Systems Design Specifications SDS phases for products and services for the US Dept of Defense.
• Created and maintained the network integrity into Boeing's system utilizing ksh shell scripting, Unix scripting and Autosys.
• Transformed application and all pertinent information pertaining to re-engineer Boeing product process monitoring systems by optimizing and fine tuning their tables, redeploying jobs to process at different timetables, and increasing system integrity for their defense products and services, performing these duties for such systems as PeopleSoft GL, Asset Mgt AM , PS Monitor, PS Query and PS Monitor.
• Maintained and supported as a database developer system integrity/security protocols in over 8 different systems space: ksh shell scripting, Unix scripting, Autosys / Peoplesoft environments, including PeopleSoft Core Financials: GL, AR, BI and AM, along with fine-tuning of the database, functionality tests and performance metrics.
• Accountable for application requirements, design, testing and delivery with coordination with Boeing employees
• Coordinated with senior level Boeing management in processing over 300 million records as part of the data load and collections during Year End processing and Financial cycles.

Confidential

Software Engineer / Sr. Developer Analyst Consultant

• Consultative assignment involving developing Financial solutions and various application processes for continued support of the State of Michigan Financial Child Support Division. Review functional and technical designs with key senior level technical team.
• Responsible for developing, building and testing new, customized or modifications made to existing Michigan Child Support Enforcement System MiCSES module programs for deployment assignments for over 12,000 case workers and 15 million families on assistance.
• Troubleshoot various technical, Functional, Setup Issues and successfully ensured solutions created were modular and have the appropriate level of scalability for each of the given architecture using PL/SQL, SAS, SQL Plus, Java, Perl, SQR and Crystal reporting. All screens developed using PL/SQL, Forms 9i, 10i, under the Oracle 10g platform. Additional Financial systems maintained production system using Autosys and upgraded by Oracle 9, 10g, 11g.
• Ensured cross-impacted areas are identified and engaged with business customers. Developed Case screens for Caseworkers using SQL Plus, Forms, PL/SQL and Java.
• Code Changes for System and Code changes for Unit Test cases made successfully and integrated a debit card system for the State and County Level Management systems, which after being implemented, saving the State of Michigan close to 15 million a year in processing food stamp purchases.
• Developed and customized production support using ksh shell scripting, Unix shell and Autosys by way of jil files. The ksh shells included file watchers, workflow maintenance and system integrity jils in order to optimize the system.

Confidential

Senior System Specialist - Finance Interfaces Consultant

• Consultative in a leadership capacity to translate new business requirements into functional design specifications while supporting testing of new functionalities. Act as a key liaison to internal and external business entities, e.g corporate, global affiliates, and internal financial customers, on payroll accounting metrics across various business spaces within General Electric Corporation.
• Successfully developed, implemented and broker collaboration with external senior level managers in support of functionality of PeopleSoft ver 8.9 , PeopleCode, App Engine, SQR and Oracle applications with legacy systems amongst different practices within GE Corporate, GE Power, GE Energy, GE Capital, GE Money, NBC, etc.
• Collaborated and developed enhancements using PeopleCode, PeopleTools, App Engine, with Finance, Time and Labor, Accounting and Payroll Departments regarding Payroll and earning/deduction-code related issues to gather solutions during NA Payroll cycle executions.
• Understood business client needs and effectively manage expectations. Additionally provided production support using Autosys and created series of verification files using jils, SQL Plus, Autosys file watchers and PeopleSoft.
• Provided and developed software code using Perl / Awk scripts, ksh shell scripting, Unix shell scripting, Autosys what language as a developer for the primary responsibility during bridging client server and legacy systems due to the new payroll system and Ensured cross-impacted areas are identified and engaged.
• Significantly improved stability amongst the Payroll processing cycles by identifying issues within the production process T L, T A, pension.. and implementing solutions to other GE practices, hence a decreased in redundancy of payroll cycle errors and saving the company over 9 million in budgetary fees.

Confidential

Senior Systems Analyst Consultant

• Supervised to provide analysis and implement upgrades in the deployment of configuring, managing, monitoring solutions and support of global human resources and payroll systems serving critical HR functions for Ford Motor Company space in Argentina, Brazil, Canada and US users North America Payroll .
• Programmed and developed upgrades for Peoplesoft ver 8.3 , PeopleTools, Oracle 9, 10g, Unix shell scripting, ksh shell scripting for updates in the Oracle environments and Autosys. A collaboration of four 4 departments serving one project manager during the development phase using SQL, SQR deployment. This initiative saved the company 2.7M in cost overhead and maintenance.
• Adapted SDLC Ford Motor Standards to high-profile projects involving significant revenue reducing initiatives. After deploying the Pension Retirement Fund project, Ford Motor saved over 10M in claims.
• Created and maintained system integrity by creating scripts for Autosys file watchers during the Payroll systems at Ford, using Unix Shell scripting, ksh shell scripting, Awk in the Autosys / Oracle environments. This was instrumental during the upgrades of all systems as it helped with optimizing all system functionality.
• Programmed complex programming techniques in the Oracle, Unix and Autosys environments while maintaining over 36 different environments.
• Applied, developed and maintained program version control systems PVCS and Health Insurance Portability and Accountable Act HIPAA compliance with the company as Ford Motor Company became the only company in the country at the time to have been awarded this compliance.

Confidential

Sr PeopleSoft Application / Business Analyst Consultant

• Conducted capacity analysis and planning to determine future projections of hardware requirements and configuration solutions with Ford's Motor Company's Compensation Planning Team.
• Facilitated and performed FIT-GAP risk assessment analysis on the conversion of .Net application to PeopleSoft e-App solutions using SDLC procedures, ran SQL queries, setup peer reviews for deliverables and coordinated work effort with team leads during each phase of the implementation, saving Ford Motor Company 3M a year in Compensation and Stock Planning.
• Performed system level analysis, design, and documentation for the newly created system with senior level approval of coordination.

Confidential

Senior Business Analyst Consultant

• Consultative in a lead analyst capacity on a team of technical and functional consultants brought in to oversee the delivery, design, test and deploy PeopleSoft initiatives for Payroll and Benefit modules for business clients throughout the Bronson Healthcare System.
• Organized a complex profitability model and collaborated with technical staff, HR managers and consultant team to deploy PeopleSoft e-App services, include creating SIT / Unit Test cases and scripts using jil files via Autosys production environment. Performing this initiative build collaborative customer relationship in the HR community and served as a technical lead and/or a resource.
• Ensured solution designs meet the agreed functional and technical requirements from our business partners and their needs and effectively manage expectations.
• Identified and documented best practices for a technology area and post project lessons learned