SUMMARY:

• Over twenty years of experience in Information Technology
• Thorough understanding of Software Development Life Cycle
• Expertise in System Analysis, requirements gathering and technical writing
• Thorough understanding of Relational Databases - Oracle, SQL Server & MS Access
• Excellent knowledge of Business Analysis principles
• Proficient in traditional Waterfall and Scrum Agile Project Management methodologies
• Excellent analytical, trouble shooting and communication skills
• Certified Information Mapping Professional and a Certified Scrum Master

PROFESSIONAL EXPERIENCE:

Jan Information Systems Supervisor/ Analyst

Confidential - Ft Lauderdale FL

Responsibilities:

• As a Project Manager, managed projects from initiating to closure. Responsible for identifying and documenting project scope, creating business case justifications, analyzing, documenting and managing customer requirements, managing stakeholder expectations throughout the project, creating and distributing status reports and negotiating resource allocation and time commitments for the following projects.
• Damage Assessment Native Mobile App (Scrum Agile): A native Mobile App to be available to public on iOS and Android markets to report home damage during a natural disaster for Emergency Management Division.
• Commission Response System 2.0: Application to enable requests from constituents, via Confidential Commissioners’ office, to be addressed. Questions/requests will be submitted by Commission Aides on behalf of their district, seeking response from respective departments to various issues. Departments will use the system to review and provide appropriate responses, which are then routed to County Administration personnel for approval, prior to the response being routed to the original requestor.
• Board Book: Maintains list of board members and vacancies to all Confidential Boards and creates timely and accurate reporting of Commission Boards and their members. Also includes an application where citizens can request to be part of a board.
• Ethics Opinions Search: Implemented for regulatory compliance a new Search functionality on Broward.org Legal site. This new Search feature lets people search Confidential Ethics Code Advisory Opinions based on many criteria.
• Arts Directory (Scrum Agile): Online Directory of artists (approved/certified upon submitting an application through an online vendor system) and the services provided where public can search artists, request services and provide feedback upon completion of the requested services.
• External Collaboration SharePoint site: External SharePoint site for external collaboration site for Emergency Management division with automated electronic Enhanced Local Mitigation Strategy Program Proposal Forms with Flood and Wind cost effectiveness templates. The site is used for collaborating with the technical steering committee members on local mitigation programs.
• Disparity Study Reporting: The purpose of the study is to assist the County in evaluating whether its current race- and gender-neutral programs have eliminated discrimination and to determine whether the County’s prior program to assist minority-owned and women-owned business enterprises (M/WBEs) reduced discrimination. Responsible for the data collection to support various inquiries and enhancements of process tracking related to, goal setting and monthly utilization reporting and payment verifications.
• Data warehouse Reporting: The Small Business Data Warehouse project to consolidate the data from the various systems used by the agency into a warehouse
• As a Business Analyst, responsible for identifying and documenting project scope, creating business case justifications, analyzing, documenting and managing customer requirements, creating user guides and users.
• Special needs Registry: The Special Needs Registry (SpNS) is a web-based application that maintains registrations of people with special needs who need to be transported to a shelter or hospital in case of a natural or man-made disaster.
• County Admin Strategic Plan: Automates the process of tracking and reporting the progress of agency assigned tasks and activities and related to the Commission values and goals.
• Agency Security Questionnaire Automation: Automation of the Agency Security Questionnaire (ASQ) from a paper form to an online electronic form that provides routing capabilities for the approval process. Based on how the submitter answers key qualifying questions, the questionnaire is routed to the appropriate person for review, approval, and submission to purchasing as part of the procurement process.
• Go-solar Kiosks: The Kiosk is a touchscreen computer which will have public access restricted to only the specified destinations on the touchscreen. The project scope involved configuring the PCs and establish necessary controls to access the Go-Solar permitting application. The Kiosks were presented Confidential the Broward Convention center for the GoSolar fest.
• Kronos Data Collection: Employee Data Collection portal for data collection incorporating all the business rules for various union and employee status combinations to facilitate the employee data for the Kronos time and attendance system. Incorporated various Kronos work rules to improve the accuracy of collected data.
• ADA Transition Plan Application: The ADA Transition Plan Update is prepared according to federal regulations. The project includes department’s report and respond to the recommended changes using the online form. It also includes facility/ program/ recommendation maintenance.
• As an Application Developer, responsible for the configuration of POSSE jobs for Highway Construction and Engineering, data conversions, application and database maintenance, enhancing their interfaces, process improvement initiatives and user .
• POSSE Performance Tuning: Responsible troubleshooting performance issues with POSSE jobs, scripts and reports for the Highway Construction and Engineering division and the Environmental Protection department. Performed code review and optimized the code, scripts and reports in order to bring the execution time to acceptable level using latest Oracle tools and techniques.
• Property Appraiser Parcel Interface: Worked as a team lead for a team of 5 in the analysis of the Parcel interface which synchronizes the parcel information between Property Appraiser and POSSE. Responsible for the modifications of the PL/SQL packages, identifying the objects to be created and the scripts to be run to set up the interface in a test environment.
• Data Extraction and Web Publishing: Worked as a team lead in creating a file which is refreshed on a daily basis with the contaminated sites information from POSSE and published on the web where public have access to the contaminated sites information and also can down load the info to an Excel spread sheet. Created the script and coordinated with the Database Group, EPD, Server Group, PIO.
• Process Automation - Contaminated Sites Websearch: Implemented a solution to automate a manual process where data is downloaded from approach and copied on to an ftp server from where it is loaded into a SQL database and is available for the web search application. This provides public the capability to search the most accurate information on Contaminated Sites. Created the necessary code and coordinated with the groups involved in obtaining necessary privileges for Implementation.
• GIS Interface for Environmental Protection Department: Involved in the Analysis and Design of an interface between EPD and GIS systems. Worked extensively with the DBA group creating materialized views and database links to accomplish the task. Also involved in automating several manual processes using Oracle tools there by improving efficiency within the Department.
• POSSE for Highway Construction and Engineering Division: Involved in the analysis, design and configuration of several jobs for HCED in a workflow application called POSSE. Also involved in the data conversion from a SQL server database into Oracle. Involved in an interface project related to Parcel updates between HCED and Property Appraiser.
• Cashier for Windows User: Cashier for Windows is a GUI tool from System Innovators used by Permitting Agencies to collect revenue. Responsible for cashiers to use Cashier For Windows application.

Consultant

Confidential - Boca Raton, FL

Responsibilities:

• Generic e-Commerce application for order processing Confidential Rexall: Worked with inPowerSuite which is a turn-key self-service software for deploying powerful e-commerce solutions on the web. Worked on several modules of inPowerSuitelike order entry, order fulfillment, global commissions and some of the financial packages. Developed several reports for the distributors to use on the internet with oracle mod PL/SQL.
• Oracle Financials Module Support Confidential Rexall: Responsible for providing technicaland functional programming support for the Oracle Financial Modules including Accounts Payable, General Ledger, Purchasing, Inventory, Order Management, Bills of Materials and Work Flow. Developed interfaces between home grown application and General Ledger, Inventory, Accounts Payables and Advanced Supply Chain planner using PL/SQL. Customized Oracle Financial Applications using Oracle Forms /Reports/PL*SQL to accommodate different banks check formats and develop necessary programs in Oracle Financials to print pay checks.
• Financial, HR and Payroll system Confidential Proudfoot: Involved in the migration of a custom financial system developed using Oracle Developer 2000 from UNIX to Windows NT Oracle 7.3 environment and building an interface between a custom system and Oracle Applications. Also involved in several customizations to oracle General Ledger, Account Payables & Accounts Receivables. Customized the check writer program to print checks for US and Foreign companies.

IS consultant

Confidential, Weston, FL

Responsibilities:

• Passport Confidential Rexall Showcase International: Involved in the development of a generic, multi - national Order Entry and Order Processing System designed for high speed, High volume data capture. Order Entry is an integrated component in the suite of custom modules including global commissioning and direct marketing.

Programmer/Analyst

Confidential, Miami, FL

Responsibilities:

• Clarify Confidential RACAL DataCom: Performed data conversion for a several modules in Clarify to upload the information from a Paradox database to Oracle. SQL loader was used to extract the information from ASCII data files into Oracle temp tables and PL/SQL was used to upload the information from the temp tables to Oracle tables. Wrote several shell scripts in Unix for running the conversion process in batch.

Programmer/ Analyst

Confidential, Miami, FL

Responsibilities:

• Online Transaction Processing system: Responsible for the architecture, design, implementation, and delivery of Confidential &T Direct Mail application. Developed ASPs for login functionality, and reporting.
• Online customer order tracking/Transaction Processing system: Involved in the design, development and implementation of a telemarketing database system for the promotional programs of Philip Morris. Designed complex master-detail forms and used VBX controls. Developed daily and weekly management reports using Reports 2.5.
• Online customer order / transaction processing system: An Oracle*Forms based system was developed for Confidential, Inc. to handle customer service oriented calls for hardware and subscription sales. Used PL/SQL extensively to develop several backend procedures for order enquiry and transaction processing.
• Client query access system: This system was designed to provide clients an easy access to their data in the database. It contains several features that allow the client to lookup individual customers, selectively download a set of customer records. Involved in the database design and development of the application.

Programmer/ Analyst

Confidential, Miami, FL

Responsibilities:

• Job tracking system: A user friendly graphical interface was developed in Visual Basic to be used as a job tracking system for the employees to capture the time spent against each project by task. Involved in database design, design of Forms and Reports.
• Telemarketing user system: Developed a generic outbound telemarketing system in Oracle*Forms 4.0 to provide an interactive tool to dynamically display messages depending on customers’ input.