SUMMARY:

• Developed automation workflows and sequences utilizing UiPath Studio and UiPath Orchestrator. Proficient in try - catch, debugging, selector modifications, queue creation, trace and log messages, waits, delays, read and write functions, keyboard and mouse clicks, get attributes, object recorder and executing windows controls as a background process.
• Implementation of Robotic Process Automation (RPA) of UiPath Studio and Orchestrator in production and test environments.
• Developed end-to-end automation solutions that convert business logic and requirements in to automation solution to accelerate business processes.
• Solution processes included feasibility studies, designs, development, testing, process flow charts, deployment and scalability.
• Implemented end-to-end Robotic Process Automation (RPA) for 88 processes in the Healthcare sector using UiPath. Resulting in ≈$2.7 million savings last year.
• Developed and modified complex stored procedures, jobs, queries, functions, unions and joins utilizing SQL Server.
• Established and deployed global code development library to provide an 80% reduction automation script development time from requirements gathering to job deployment. Resulting in an 45% reduction in script maintenance.
• Knowledge of Object Oriented Programming (OOP) concepts for C#, C++, Python and Java.
• Analyze and monitor systems to determine if enhancements are necessary to increase productivity, mitigate risk and optimize revenue.
• Technical liaison to business units, developed predictive modeling tools, determined requirements definitions, perform data analysis, demonstrate applications and training.
• Lead the expansion of tools and methodologies; implemented new core systems to address complex customer or product issues; performed user acceptance testing; guide creation; validation of best practice, compliance, and organizational strategic vision. Increased productivity and efficiencies by developing guides and streamlining procedures. Served as a consultant to implementation teams.
• Lead multiple projects concurrently in a fast paced environment. Participated in internal and external ISO audit compliance, participated in ISO PPQA internal and external audits with zero noncompliance findings. Adept on delivering projects on time and within scope.

PROFESSIONAL EXPERIENCE:

Confidential, Southfield, MI

Senior System Programmer

Responsibilities:

• Lead team of 17 for Ui Path Orchestrator Implementation project. Project budget was $3 million. The team included 15 developers and 2 administrators. The development team provided robotic processing assistance (RPA) for automation jobs utilizing 50 Robots. Projects included automation jobs to prevent revenue leakage, replace manual processing, aide budgeting and forecasting, automate reorganization of departments, and Business Process Outsourcing (BPO) Claims processing. Cost savings in excess of ≈$2.7 million. Established and deployed global code development library to provide an 80% reduction automation script development time from requirements gathering to job deployment. Resulting in an 45% reduction in script maintenance. Implementation included a rollout of best practices, training, mentoring, and consulting for internal and external product users. Established quality assurance processes, virtual machine, robot and server maintenance.
• Developed an automation solution to replace a manual data refresh of global Project Online reports. Automation solution provided annual cost savings of ≈$37,000. Performed analysis on the automated solution and identified an opportunity for additional cost savings. Implemented Microsoft PowerBi reporting solution to replace previous automation script. The PowerBi solution provided an additional cost savings of ≈$5,200 annually and increased the refresh frequency from 2 times per day to 7 times per day.
• Managed high priority projects and product implementations. Identified and coordinated cross functional global team workflows and end-user training. Lead or consulted on complex customer and product issues when necessary engaged third party vendors and contractors.
• Developed custom excel reports, charts and graphs utilizing external data sources, enhanced data and desktop analytics, macros and connections for data mining. Designed refreshable Key Performance Indicator report with multiple external data sources which included an accompanying custom PowerPoint presentation containing charts, graphs and animations. Ensured systems with correlating data maintain data integrity between applications. Developed custom excel reports for budgeting and forecasting, resulting in a cost savings of ≈$530,000 annually.

Technical Application Consultant

Responsibilities:

• Microsoft Project Online/Azure Reporting Server/ Microsoft Project Professional Online Implementation Azure reporting solution technical liaison. This $5.4 Million project supported 212 users, and was developed in conjunction with a certified Microsoft partner, Wicresoft (Formerly DeltaBahn). Developed custom Azure SQL Server Reporting Solution. Instrumental in starting up Office 365 to support Microsoft Project Online. Functioned as system administrator for Office 365 and Microsoft Project Online. Participated in development of cloud analytics and reporting. Created reporting tools and project management strategies for predictive modeling, revenue forecasting, balancing supply and demand. Responsible for managing workflows. Preformed system analysis, resulting in enhancements to increase productivity, revenue optimization and automation opportunities.
• Developed database queries, stored procedures, SSIS packages and imports. Performed analysis for database optimization, server jobs and performance tuning. Monitored and responded to job failures. Completed server updates and maintenance. Lead system integration testing. Developed custom reports, charts and graphs utilizing internal and external data sources for executives, finance, and demand managers. Served as technical liaison to business units provided training, support and requirements definition for multiple applications. Provided system administration for multiple applications including Microsoft Project Online and Ui Path.
• Lead a team of 5 for Ui Path Studio implementation project. Project budget was $1.2 Million. The team included 3 developers and 2 administrators. The development team provided robotic processing assistance (RPA) for automation jobs utilizing 13 Robots. Projects included automation jobs to develop workflows to replace manual processing, prevent revenue leakage, perform system data integrity audits, and document repository updates for custom reporting fields.
• Developed custom executive status reports for implementation projects utilizing multiple external data sources. Ultimately reducing manual processing from 10 hours to 2 hours. This solution contains functionality for external data sources and advanced excel formulas that resulted in a cost savings of ≈$65,000 annually.

project management

Responsibilities:

• Managed software development releases with a multi-million dollar budgets. Lead approximately 10 releases per year utilizing waterfall (SDLC) and agile development processes. Participated in ISO PPQA internal and external audits with zero noncompliance findings.
• Lead multiple projects with cross functional global teams concurrently for healthcare compliance, business optimization, product planning, assessment, release and upgrade management. Ensured client satisfaction and expectations with regard to project goals, deliverables, and requirements. Created tools for scope size and forecasting, variance reports, budget worksheets, enhancement tracking reports, status reporting and estimation tools. Analyzed project related reports and metrics. Notified and escalated project issues and risks to clients, team, stakeholders and upper management when appropriate.
• Major contributor for the launch of an offshore Project Administrator group with a cost savings of $1.1 million annually. Lead the expansion of project management tools and methodologies. Implemented new core systems for complex customer or product issues. Performed user acceptance testing, guide creation, validation of best practice, compliance and organizational strategic vision.