SUMMARY:

• Experienced in all aspects of business technology centralizing in analysis of business processes, requirements gathering, and project implementation. Managed in individual, team lead, and project management roles within the Airline, Banking, Financial, Legal, and Telecommunications industries.
• Experienced in business technology improvement, infrastructure migration, programming, and project management.
• Profitably manage budgeting, strategic forecasting, full - lifecycle product development, as well as staff hiring and .

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, Illinois

Senior Business Analyst\Project Manager

Responsibilities:

• Analyze system and information workflows used for 59 Critical Use Excel Spreadsheets while streamlining the process for migration to a consolidated SQL Server environment.
• Conduct interviews and workshops to elicit business and technical requirements in creating BRDs and design diagrams for use by various technology and operational teams.
• Document current state data flow, mapping fields to future state design as part of standard gap analysis procedures.
• Manage the coordination of manpower and budgeting resources during project onboarding efforts requiring involvement of cross-functional teams within BOA.
• Lead all elements of the testing phases and develop appropriate documentation and status reports.
• Perform trend analysis and model modification to forecast three to five-year payment loss on credit card and loan products.
• Coordinate SYS and UAT testing efforts, validating results against business and operations approved criteria.

Confidential, Itasca, Illinois

Senior Financial Systems Analyst

Responsibilities:

• Directed project activities related to the Corporate Accounting Group reporting and testing functions resulting in the phases completing ahead of schedule and 12% under budget.
• Wrote Technical and Functional requirements necessary to replace 87 ICE and GREAT system reports.
• Utilized Access, Excel, and VBA for data validation and testing.
• Reduced the need for report development by utilizing Tableau and dashboard technology to allow for a more flexible display of instantaneous data updates.
• Led status meetings for upper Management regarding resource needs and progress on the reporting and testing aspects of the project.
• Designed testing strategy, cases, and scripts for the new reconciliation software implementation.
• Developed a comprehensive data dictionary outlining attributes of all elements contained within the inter-division accounts payable systems.

Confidential, Oakbrook, Illinois

Business Analyst\Project Manager

Responsibilities:

• Reconciled three years of mobile phone data, identifying opportunities for over $720,000 in annual cost savings.
• Created onboarding and off-boarding procedures to streamline mobile equipment distribution and recovery resulting in reductions of time and labor.
• Documented necessary requirements for internal and external web portals and mobile procurement procedures.
• Built the internal departmental tracking database for mobile devices, migrating data from ten data sources into one centralized location to become the source of record for the intranet portal.
• Conducted requirements gathering workshops and project meetings.

Confidential, Chicago, Illinois

Senior Business Analyst/Project Manager

Responsibilities:

• Led the project teams in the selection, customization, and implementation of new Legal and Accounts Payable software systems with a combined budget of over $1.3M.
• Wrote Project Charters, design specifications, business and technical requirements, use cases, and testing documentation.
• Planned SCRUM sprints, and conducted daily checkpoint and review meetings.
• Worked with audit team to ensure all applications and processes meet with SOX compliance requirements.
• Served as Administrator for the AVID accounts payable, Sharefile, Insight Reporting, Realogic Budget, and RingCentral Office@Hand telecom systems.
• Negotiated contracts with outside vendors for software and telecom integrations.
• Assisted technical support teams with the tracking and resolution of daily support tasks.

Confidential, Chicago, Illinois

Senior Business Analyst

Responsibilities:

• Create system-flow diagrams outlining the trade information migration through internal and external systems.
• Develop plans and monitor the activities by identifying the stakeholders, and selecting business analysis processes that will be used to manage requirements utilizing Waterfall methodologies.
• Provide comprehensive consulting and leadership to stakeholders in order to identify and understand their needs, concerns, and environment in which they work.
• Generate all levels of project documentation such as Proof of Concept, High Level Business Requirements, Detailed Business Requirements, Status Reports, User Stories, and Installation/Implementation plans.
• Design and implement test plans and scripts utilizing the results to improve upon the requirements, project plan, and run-book.

Confidential, Chicago, Illinois

Business Technology Specialist

Responsibilities:

• Engage stakeholders toward constructing details for software development changes through comprehensive JAD and RAD sessions.
• Create technical requirements and oversee the design implementation process within the AGILE framework.
• Develop functional specifications, use cases, process workflow, and interface specifications.
• Document workflows and business processes utilizing Visio and Snagit workflow management tools.
• Assist Bond Sales through technical and vendor support coordination for systems such as Bloomberg, CRM, Ipreo, Peoplesoft, and Salesforce systems.
• Perform business and systems analysis, including current and future state to determine requirements and construct features into user stories, for nearly twenty separate applications.
• Design automated solutions for time sensitive FINRA and MSRB compliance reporting.
• Coordinate with vendors and suppliers during the facilitation of production issues and software changes involving interagency cooperation.
• Recommend technical and procedural improvements in order to optimize regulatory reporting and enhance market opportunities.

Confidential, Chicago, Illinois

Systems Analyst

Responsibilities:

• Assist in the development of the project plan and technical requirements on cross-divisional PED project as part of the effort to merge five programs into an enterprise level application.
• Coordinate requirements gathering and testing procedures for Anti-Money Laundering in-house software solution.
• Design Crystal Reports and responsible for installation of vended software along with required SDLC documentation for the Fundlinx project.
• Communicate status and quality of releases to appropriate Development teams, Architects, senior leadership, vendors, and other relevant stakeholders.
• Manage existing Oracle and Access applications providing necessary upgrades and docket fulfillment in conjunction with overall enterprise plan.
• Evaluated and assessed business process change impacts and recommend appropriate change mitigation activities to match client requirements for Private Equity division.
• Analyze current processes, procedures, and workflow in order to identify gaps and areas where technology could enhance efficiency.

Confidential, Hoffman Estates, Illinois

DBA/Analyst

Responsibilities:

• Transformed Access/Excel/EDW based systems into SQL Server based applications with Access/VB user-friendly front ends.
• Evaluate business processes for the development of Data Warehousing systems, and technical software specifications.
• Responsible for migration and administration of applications in SQL Server utilizing DTS, roles, stored procedures, triggers, and maintenance plans.
• Created customized reporting solutions for federal and state reporting agencies, as well as executive management.
• Wrote technical documentation for both new and existing business/software systems.

Confidential, Carpentersville, Illinois

Owner

Responsibilities:

• Develop network, Access and SQL Databases, and web based programs for the purpose of consolidating workflow into more efficient and productive activities.
• Analyze client technical needs for integrated applications, design and implement full life-cycle solution based upon requirement development.
• Formulate solutions for Fortune 500 companies such as WMI, Confidential, and Caremark along with several mid-level companies in a variety of industries.
• Write .NET web and windows based programs utilizing ADO, ASP.NET, VB.NET, and Object Oriented Programming technologies.

Confidential, Chicago, Illinois

Vice President of Applications Development

Responsibilities:

• Designed and launched multi-tiered client applications across LAN and WAN networks, integrating information from multiple programs and platforms.
• Created a cutting-edge Tax Payment Access/VBA/SQL database application for a Fortune 100 firm, resulting in realized savings of over $2 million yearly through more time-effective operations.
• Trained company and client technical support personnel in application usage, design, and maintenance/debugging techniques in a Visual Basic/VBA environment.
• Developed and implemented all databases for in-house purposes, and for clients in the Legal, Financial, Pharmaceutical, and Real Estate Management Industries.
• Consolidated and upgraded databases as part of an XP environment initiative, making modifications and recommendations when necessary to keep applications compatible with other software and work-flow processes.

Confidential, Elk Grove Village, Illinois

Software Developer/Support

Responsibilities:

• Directed the FATC division effort to upgrade office applications from Windows95/Office97 environment to Windows2000/Office2000 for Y2K compliance.
• Responsible for building and maintenance of Access/VBA databases, Visual Basic, and Office applications.
• Provided support and troubleshooting for the network and associated software.
• Wrote new queries, reports, forms, and modules for already existing Access programs.
• Redesigned the Flight Attendant Data Processing program into VB/Access/SQL resulting in $30 thousand annual cost savings through database consolidation and computer automation.