SUMMARY:

Results - oriented professional with 15+ years of experience and a proven knowledge of configuration management, systems acquisition, and application development. Specializes primarily within the banking, automotive, payroll, human resources and financial service environments. Solid track record in cross-functional, system development and enhancements, monitoring and performance metrics for better transitions and alignment with client deliverables. Aiming to leverage my skills to successfully fill a Systems/Application Engineer role at your organization. served on multiple roles on PwC’s Financial Services Oracle ERP practice

ADDITIONAL SKILLS:

• SQL Development, SQLplus, PL/SQL, Transact-SQL (T-SQL)
• Oracle 12c, PeopleSoft HCM, People Code, People Tools
• Autosys v 3.7, 5.5, 11.3, Unix Shell Scripting, Korn Shell Scripting
• SAS, Toad, DB2, Server Integration Services (SSIS)
• Upgrades Cost/Benefits Analysis, NA/Global Payroll Deployment
• SQL Server Management Studio
• Infrastructure Stability, Deliverables Capacity, Disaster Recovery Planning

WORK EXPERIENCE:

Confidential, Irving, TX

Software Engineer

Responsibilities:

• Facilitate and provide analysis then strategically position 12 teams to streamline and resolve daily issues, which involves configuring servers, implementations, deployment. daily updates and re-positioning of files on a SAN and NAS servers. Some of the industry include Confidential Card, Experian, Bank of Amer and internal clients.
• Participate with Testing Teams in supporting Integrated / Independent releases.
• Resolve problems for clients requesting updates on 4 servers for file movement using Unix, Linux, Hadoop and Autosys operations and internal entities of the company.
• Troubleshoot and analyze cost reduction and streamline procedures within 12 teams to achieve faster and more efficient turnaround thus reducing cost to the company.
• Maintain server maintenance and coordination with leadership for any anomalies within the system and correct defects and have problem resolutions.
• Consult with customers or other departments on project status, proposals, or technical issues, such as software system design or maintenance.
• Store, retrieve, and manipulate data for analysis of system capabilities and requirements.

Confidential, Irving, TX

Application Engineer / Production Analyst

Responsibilities:

• Performed reporting metrics and monitoring tools: PL/SQL, Unix, Linux, SQL to continue execution of SQL scripts for deployment into the production environment.
• Demonstrated life cycle experience (SDLC / Waterfall / Agile).
• Experienced in troubleshooting, analysis, research and resolution for back end mortgage related issues and conduct root cause analysis.
• Investigated new/unknown/existing issues and defects in mortgage lending systems. Tracking and Clearly document all findings for future s for team members.
• Resolved problems for clients during the project, which includes: configuring, implementing, deployment, execution of scripts, creation of scripts, monitoring and support for mortgage industry, including Prime Lending, US Bank, PNC, Fifth-Third and Confidential to name a few. Ensured service level and customer satisfaction metrics are met and build collaborative customer relationships with clients. Utilize issue tracking system (JIRA) daily as well as JETS.

Confidential, Plano, TX

Application Engineer (Consultant)

Responsibilities:

• Created architecture for client during the project, which includes configuring, implementing, deployment, batch monitoring and support for consumer and small business enterprises throughout Confidential .
• Ensured service level and customer satisfaction metrics are met and build collaborative customer relationships with client.
• Utilized reporting and monitoring tools: Autosys, TeraData, DB2, to continue my deployment into the production environment.
• Demonstrated relevant IT experience (SDLC- Waterfall / Agile, post Go-Live warranty support, Autosys) Proven expertise: DB2/SQL/Oracle, Unix/Linux Shell Scripting and Unix Server experience.
• Experienced in troubleshooting, analysis, research and resolution using advanced query, programming developer skills, conduct root cause analysis
• Led to assess initial severity, gather impacts, creates tickets (REMEDY), engage necessary support teams, and escalate as necessary to ensure timely restoration.

Confidential, Portage, MI

Data Engineer - SQL (Consultant)

Responsibilities:

• Created architecture for client during the project, which includes configuring, implementing, deployment and resolution of land related surveys for the State of Minnesota.
• Ensured service level and customer satisfaction metrics are met and build collaborative customer relationships with different entities of the state government
• Assisted Technology Teams, Other Development & Testing Teams in supporting Integrated / Independent metrics using T-SQL, SQL Server Management Studio (SSMS- 2014) and TFS
• Created and management queries from the State of Minnesota government involved in land acquisitions and data governance metrics.

Confidential, Dearborn, MI

BI Technical -Peoplesoft Finance (Consultant)

Responsibilities:

• Consultative to provide expert advice, guidance, leadership and counsel to team members of one or more Business Transformation / IT related projects.
• SLM has upgraded their PeopleSoft financial system from 9.0 to 9.2 (PUM 21)
• Developed report mock-ups/wire frames with current technology like PeopleSoft, SQL, Oracle Bi like dimensions and emerging technologies like Hadoop and Cloud technologies and projects.
• Identified project objectives and requirements and evaluated alternatives to present to management.
• Assisted management in the development of project objectives, requirements and benefits as projects are initiated.
• Recognized project impacts on business and modified project design as necessary.
• Also, coordinated, developed and defined test strategies/approaches.
• Utilized reporting tools (Oracle OBI/BIP), Kendal, Snowflake, STAR schemas, PeopleSoft, Informatica, Oracle BI, Dimension modules.
• Led team of consultants in delivering a cloud ERP solution for financials and procurement

Confidential, East Confidential, MI

Technical Consultant

Responsibilities:

• Constructed high priority projects for the Confidential which typically required complex schedules, and integration with other systems, and utilized vendor participation.
• Partnered with Confidential clients to develop system requirements, performed analysis activities, made recommendations for processing and business flows, and developed consensus on both business and systems requirements.
• Planned and forecasted projects and documenting and gathering business, functional or technical requirements for software projects.

Confidential, Detroit, MI

IT Consultant

Responsibilities:

• Analyzed and designed operations that improved work flow, handle equipment layout, and help ensure accident prevention with Onstar Services.
• Monitored process changes after full implementation, made changes and offered additional suggestions for improvement as required.
• Identified operational problems by observing and studying system functioning and performance results; investigating complaints; interviewing process supervisors and operators; completing troubleshooting procedures.

Confidential, Charlotte, NC

Application Consultant

Responsibilities:

• Conducted capacity analysis and planning to determine insight specific to application development, installation, troubleshooting, and problem resolution for an Oracle upgrade from 10g to 11g.
• Developed, implemented and interpreted business requirements for application developers and quality testers.
• Improved configuration solutions to the environmental practice (EH&S) entity of Confidential .
• Collaborated and developed enhancements to working with EH&S compliance data (Federally mandated by the US Gov’t) or applications such as Essential Suite.
• Introduced series of verification files using jils, SSIS and SSRS on the front end along with T-SQL, Mgt-Studio and TFS.

Confidential, Charlotte, NC

Sr. IT Consultant

Responsibilities:

• Consultative assignment to conduct, develop and interpret business requirements for programmers, developers and quality testers.
• Located 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.
• Drove efforts during fact finding engagements, included matrices, facilitated meetings, utilized best practices and collaborated with the business partners to quick resolutions, production and non-production issues at Confidential .

Confidential, Charlotte, NC

SQL Application Developer / Software Analyst

Responsibilities:

• Conducted 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.
• 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.
• Coordinated with corporate departments to create a streamline approach for Foreclosure Review and government regulations on mortgage lending practices.
• Participated and contributed in systems design sessions and contributed to Technical System Specifications (TSD) documents for the database components using T-SQL, ETL experience.
• Maintained the network integrity utilizing Korn (ksh) shell scripting and Unix scripting.

Confidential, Charlotte, NC

DB Application Developer / Analyst

Responsibilities:

• Consultative assignment involving developing database table solutions and various application processes for continued support of the device network systems of Confidential .
• Ensured service level and customer satisfaction metrics and maintained and build collaborative client.
• 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.
• Provided a core workflow system used to manage the deployment of BAND devices. Also facilitated group administration and procurement activities.

Confidential, Cary, NC

Senior Database Engineer / Analyst

Responsibilities:

• Created architecture interface for client during first phase of project, which included: configuring, implementing, managing, batch monitoring and support for global defense products and services conducted through Confidential systems.
• Transitioned products and services from Confidential 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 / US Dept of Defense) with PeopleSoft Financials, 9.0 and Analyze systems.
• Preformed 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.
• Coordinated with senior level Confidential management in processing over 400 million records as part of the data load and collections during Year End processing and Financial cycles.

Confidential, MI

Software Engineer / Sr. Developer Analyst

Responsibilities:

• Assessed system performance standards.
• Archived Code Changes for system and integrated a debit card system for the State and County Level Management systems, which after being implemented, saved the Confidential close to $18 million a year in processing food stamp purchases.
• Consultative assignment involved developing Financial solutions and various application processes for continued support 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.
• Reviewed functional and technical designs with key senior level technical team.

Confidential, Schenectady, NY

Senior System Specialist

Responsibilities:

• Consultative in a leadership capacity to translate new business requirements into functional design specifications while supporting testing of new functionalities.
• Successfully developed, implemented and broker collaboration with external senior level managers in support of functionality of PeopleSoft (ver 8.9), PeopleCode, T&L, T&A, App Engine, SQR and Oracle applications with legacy systems among different practices within GE ( Corporate, GE Power, GE Energy, GE Capital, GE Money, NBC, etc.).
• Implemented solutions to other GE practices, hence a decreased in redundancy of payroll cycle errors and saving the company over 9 million in budgetary fees.
• Played a vital role in the life cycle of an implementation of IPSAS Project in PeopleSoft Financials 9.0