Solutions Architect Resume
Richmond, VA
SUMMARY:
Dynamic leader with 15+ years’ IT experience in the United States seeks to helm a team of motivated Oracle application developers and Automation Anywhere and WorkFusion(RPA) developers to create groundbreaking new software functionality and business capabilities for clients who demand quality results with on - time delivery.
SKILLS:
- Leadership of development teams
- Identified Task where RPA can be implemented.
- Lead the design and implementation of RPA with WorkFusion and Automation Anywhere
- Managed full lifecycle implementations of RPA
- Extensive Software Development Life Cycle experience in all phases (Requirement Capturing, Data Modeling and Designing, Developing, Testing, Quality Assurance, Implementing, Documenting and User Training)
- Oracle Database (8,8i,9i,10g)
- SQL on different platforms like SUN Solaris, Unix, Windows NT/2000/98/95
- Oracle Forms/Report 6.0/6i/9i/10g
- Inbound/outbound interfaces for Oracle Apps with APIs
- Data conversions from legacy systems to Oracle 11i and R12
- Oracle 9i Application Server deployments
- Conversions from COBOL to PL/SQL
- Reports Server deployments
- Conducted POCs with Vendors for selection of RPA tool.
- Lead the design and implementation for Unique Supplier id Project.
- Troubleshooting report security
- Creating business areas in Oracle DB via Discoverer
- Internet applications development in Java
- SQL tuning and performance enhancement with tools such as EXPLAIN PLAN, SQL*Trace and Auto Trace
- Server-side programming with Procedures, Functions, Database Triggers, and Packages using PL/SQL and SQL.
- Data loads via SQL Loader
- Oracle DB data migrations and upgrades
- Report development in XML Publisher
- Oracle 11i (GL, AP, AR, Inv, OM)
- Oracle R12 P2P - AP
TECHNICAL SKILLS:
Software: Oracle(8/8i/9i/10g/11i/R12) Forms/ Reports(6/6i/9i/10g) SQL, PLSQL
Platforms: Windows 95/98/NT/7, UNIX modules AP, AR, GL, Inv, OM
RPA: Automation anywhere, workfusion.
Languages: java
RDBMS: Oracle 8 / 8i / 9i / 10g /11g
ETL: Oracle Data Warehouse Builder 10g (Release 1), Datastage
Middle Tier: Report Server 6i, 9i, 10g, Forms 6i Server, EJB, OC4J, Oracle App. Server 9i, 10g
Front End: Forms/Reports Developer 6.0/6i/9i/10g/11g, XML publisher, Workflow
Other Apps: WorkFusion, Toad, SQL Navigator, ERWIN, PVCS, JDeveloper, Discoverer 4i
PROFESSIONAL EXPERIENCE:
Solutions architect
Confidential, Richmond, VA
Responsibilities:
- Lead 2 separate teams of 4 developers at Capital One for implementation of Automation Anywhere for RPA.
- Acted as a liaison between the Testing team, Development team and Base Application team.
- Provide support for Migration of BOTS to Production.
- Created Roles for Various support for RPA.
- Designed and created Teams for RPA Support.
- Acted as Liaison between the Functional Team, business and development team.
- Estimated level of Expertise, support required by various teams.
- Estimate and plan the number of BOTs required for the process.
- Coordinate with Project teams for go-live and support.
- Acted as Liaison for signoff of BRD.
- Created a WIKI for RPA.
- Created Various Solution Documents for RPA.
- Take part in solution design and implementation meetings for RPA.
Technical Team Lead - Solutions architect
Confidential, Tampa FL
Technical Environment: Oracle Apps 12.2, Oracle Developer 10g, TOAD
Responsibilities:
- Create comparative analysis with POCs for RPA tools for Automation Anywhere, WorkFusion and Cortex and suggest different tools for different use cases.
- Lead a team of 6 developers at Citi for implementation of WorkFusion and Automation Anywhere for enhancement requests/change requests and bug fixes.
- Lead discussions with Business and Ops team for creation of Process rules.
- Create Solution Design Document for the process to be automated.
- Build prototypes for RPA and provide technical downloads to developers
- Create process flow diagrams RPA BOT.
- Conduct 1 on 1 and team status meetings.
- Perform root cause analysis as to why the RPA BOT did not process the invoice.
- Triage Production issues and roll back enhancement deployments when needed
- Ensure customer deadlines are met for enhancements and change requests
- Create the Requestor Add/Modify Script for WorkSpace access.
- Create Qualification and Tagging Task for Users in WorkSpace
- Create Qualifications for Users access in WorkSpace.
- Create Roles in WorkFusion for Various user access in WorkFusion
- Create users feed for EERS from WorkFusion Database.
- Take a lead role in upgrade of WorkFusion 7.4 to 8.2.
- Create inbound feeds to WorkFusion Database and Business process.
- Create queries for WorkFusion Master Data access.
- Create and estimated server architecture.
- Work with DEV and Migration team to migrate Business process to UAT and PROD environements.
- Estimate Levels Of Effort and Durations for project management team
- Investigate business requirements with Business Analysts, seek clarifications, and provide feedback on functionality and technical solutions
- Review code for standards and evaluate performance, modularity and reusability
- Tune code using SQL queries, PLSQL, etc.
- Review, create, and modify Reports RDF or Forms in Oracle R12
- Design and review the process for data cleanup
- Collaborate with customers to obtain approvals and signoffs
- Ensure quality and efficiency for first-run Production cycles
Sr. Oracle Developer
Confidential, Long beach CA
Technical Environment: Oracle Apps 11.5, Oracle Developer 10g, TOAD
Responsibilities:
- Developed programs, queries, reports, forms, and UNIX scripts for Oracle Financials 11.5
Team Lead
Confidential, Clearwater, FL
Technical Environment: Oracle Apps R12, Oracle Developer 10g, TOAD
Responsibilities:
- Managed offshore development team and assign work
- Liaised with client and BAs to gather requirements
- Converted SAP to Oracle Apps
- Created and upgraded custom Forms and Reports from 6i to 10g/11g
- Wrote technical design documents for Manufacturing VC++ process
- Created and modified Procedures, Functions and Triggers
Database Engineer
Confidential, Carlsbad CA
Technical Environment: Oracle Apps R12, Oracle Developer 10g, TOAD
Responsibilities:
- Created and modified Procedures, Functions and Triggers
- Tuned PLSQL and SQL code for improved performance
- Coordinated work for DBA and Middleware teams for application change controls and system performance issues
- Built databases and develop/customize SQL scripts
- Maintained the Replication system (YURI) across databases
Senior Application Developer
Confidential, Bristol, CT
Technical Environment: Oracle Database 9i, Oracle Forms 10g and Reports 6i in an UNIX Environment and Oracle 10g Application Server
Responsibilities:
- Led a team of 5 developers
- Estimated Levels Of Effort and Durations for project management team
- Investigated business requirements with Business Analysts, sought clarifications, and provided feedback on functionality and technical solutions
- Built prototypes and provide technical downloads to developers
- Tuned code using SQL queries, PLSQL, etc.
- Reviewed, created, and modified Reports RDF or Forms in Oracle 10g
Software Developer
Confidential, Bristol CT
Technical Environment: Oracle Database 9i, Oracle Forms and Reports in an UNIX Environment and Oracle 10g Application Server
Responsibilities:
- Led a team of 5 developers
- Estimated Levels Of Effort and Durations for project management team
- Investigated business requirements with Business Analysts, sought clarifications, and provided feedback on functionality and technical solutions
- Built prototypes and provide technical downloads to developers
- Reviewed, created, and modified Reports RDF or Forms in Oracle 10g
- Ensured customer deadlines are met for enhancements and change requests
- Collaborated with customers to obtain approvals and signoffs
Technical Team Lead
Confidential, Hartford CT
Technical Environment: Oracle Database 9i release 2, Oracle Forms/Reports 6i/10g in Unix Environment and Oracle 10g Application Server
Responsibilities:
- Led a team of 2 developers
- Estimated Levels Of Effort and Durations for project management team
- Reviewed code
- Converted Forms and Report RDFs from 6i to 10g
- Performed comparison testing and delivered finished code to customer
Senior Software Engineer
Confidential, Lansing, MI
Technical Environment: Oracle Database 10g, Discoverer 10g, PL/SQL and SQL, Crystal Reports, PowerBuilder (9)
Responsibilities:
- Gathered business requirements from the customer and developed functional and technical specifications
- Designed Data Warehouse tables, views, dimensions and cubes
- Developed Oracle mappings and process flows and built Oracle Workflow
- Built Crystal reports and converted Crystal reports to Power Builder reports
- Created technical specifications for Power Builder developers
- Created and reviewed PLSQL processes, data cleanup scripts, and Procedures, Functions and Triggers
- Migrated COBOL to Oracle 10g
Senior Software Engineer
Confidential, Tallahassee, FL
Technical Environment: Oracle 9i Application Server, Apache Web Server, Oracle 8i Database Server, Rational Rose Enterprise 2000 for UML Design and code generation, Rational Test Suite for Functional & load testing
Responsibilities:
- Led a team of 4 developers
- Gathered business requirements from the customer and developed functional and technical specifications
- Created and reviewed PLSQL processes, Procedures, Functions and Triggers, and database tables, views, and indexes
- Developed application reports using Reports 6.0/6i/9i/10g, PL/SQL and SQL
- Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
- Tuned SQL for performance improvement using EXPLAIN PLAN and SQL*Trace
