SUMMARY

• 10.2 + years of experience in RPA Development, Data Analysis, Vb6 and VBA Macros Programming.
• Expertise in Business Requirements Documents (BRD), SAP BEx reports, Change Management, Business Process modeling, data analysis and SDLC methodologies.
• Experience with IT Project Analysis Support & product development lifecycle management agile and waterfall and experience in strategy and innovation in a top tier consulting firm.
• Experience with use cases development.
• Well versed with Excel, macros, MS Project, MS Office, MS PowerPoint, RPA and creating reports and analyzing data.
• Proficient in statistical measures and analysis.
• Advanced knowledge of accounting, reporting, and budgeting systems.
• Expert knowledge and understanding of financial concepts and accounting principles.
• Coordinate all Financial Planning activities for the company including: the Annual Operating Plan, the Quarterly Forecast Process, and latest view of the next month’s performance.
• All daily, weekly, and month - end reporting requirements. That includes but is not limited to; Daily Sales Reporting, weekly Inventory reports, month-end financial package and executive summary. In addition, have developed the reporting requirements for Corporate Partners, the Private Equity ownership group.
• Worked on ERP systems.
• Knowledge of project management methodologies.
• Proficient as long time liaison between business and technology with competence in Full development Life Cycle of System (SDLC) development with Waterfall and Agile with Scrum methodologies.
• Manage the Change Control process and update the Change Log and Project Plan Management (MS Project expertise).
• Adapt at reducing development costs and providing traceability of project.
• Creative and Strategic approach to problem solving.

TECHNICAL SKILLS

Domain knowledge: Robotic Process Automation, Business Analyst Data Analysis, Manual Testing

RPA Automation Tools: Automation Anywhere, Blue Prism v5.0.24

Programming Languages: Visual Basic 6, VB Script and VBA

Database Systems: MS SQL Server 2008, MySQL, MS Access

Platforms: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

RPA developer

Responsibilities:

• Working with the business to identify Robotic Process Automation opportunities, by analyzing new processes and assessing feasibility
• Analyzing, understanding and documenting the business processes in detail where required
• Designing & configuring automation (Blue Prism v5.0.24) process solutions
• Creating and maintaining solution documentation
• Supporting existing processes and implementing change requirements as part of a structured change control process

Confidential

Business Consultant/RPA developer

Responsibilities:

• Working with the business to identify Robotic Process Automation opportunities, by analyzing new processes and assessing feasibility
• Analyzing, understanding and documenting the business processes in detail where required
• Identifying and communicating the technical infrastructure requirements
• Designing & configuring automation (Automation Anywhere) process solutions
• Creating and maintaining solution documentation
• Supporting existing processes and implementing change requirements as part of a structured change control process
• Problem solving issues that arise in day to day running of automation processes and providing timely responses and solutions as required
• Working in a project environment, communicating any identified risks and issues to the project manager accordingly and providing inputs to the change control process
• Working with QA to create and document test procedures and scenarios for the pre-UAT phases
• Supporting the Operational Teams during the UAT and rollout phases

Environment: MS ACCESS, MS EXCEL/VBA, RPA(Automation Anywhere).

Confidential

Senior Business Analyst/VBA Consultant

Responsibilities:

• Working user groups to understand the user stories and prepare product backlog for agile sprint.
• Product backlog grooming and sprint planning meetings and assigning sprint tasks to the team
• Report Development for Confidential Apparel End Accounting Users.
• Category Financial Reporting to help identifying the Sales and displaying the net Profit and Loss.
• Buyer Rack Allocation Reporting to preview the Forecast for the Rack Availability in the Stores by analyzing the inventory availability.
• Analyzing business results using financial reports.
• Supporting cross-channel and company initiatives to achieve global strategic multi-channel plans by providing input on multi-channel strategy; executing against category level strategies; and partnering with store counterparts to develop multi-channel assortment and customer experience.

Environment: MS SQL SERVER 2008, MS EXCEL/VBA, Team Forge, MS Power BI.

Confidential, Burbank, CA

Senior VBA Programmer

Responsibilities:

• Updating of Detail reporting requirements, Dataflow Design, Technical Specifications and Unit Test Documents.
• Functional Design Specification and Technical Design Specifications creation.
• Hands on creation of BEx queries using Restricted and Calculated Key Figures, Variables (Standard and Customer Exits), Exceptions and Conditions for Finance and Billing.
• SAP and VBA integration with Front end reporting development with primary skill set of SAP BEx Analyzer, MS Excel and VBA.
• Advanced Excel (V - Look UP, H-Look UP, Name Ranges, Pivot table, Cell Referencing and advanced EXCEL formulas)
• Worked on creation of SAP BI BEx Workbook Reports using multiple BI queries and views.
• Responsible for defect assignment and resolution during SIT and UAT in HP Quality Centre.
• Worked with QA team to design test plan and creation of test cases for User Acceptance Testing (UAT) and HP Quality center.
• Involved in workbook development based on BEx Query and did various customizing like inserting Radio Button, Drop down menu, Macros, building Workbook based on 2 or more queries in same or different sheets of the workbook.
• Performed test cases, UAT testing, Regression testing.

Environment: SAP BI, SAP BEx, MS EXCEL-VBA, HPQC, Team Forge.