PROFESSIONAL SUMMARY:

• Business Analyst with 17 years of diverse experience in Information Technology with focus on Business Analysis, Business Modeling, Requirement Gathering, Technical Documentation, Project Management and Web Application Services. More than 10 years of successful, progressive experience in all phases of the Software Development Life Cycle SDLC .
• Experience in gathering user functional requirements using reverse engineering modeling and UML tools including MS Visio and wireframes.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing, Use Case Diagrams, Software Development Life Cycle SDLC processes, Object Oriented Programming and Design OOP/D , Risk Analysis, Screen Mockups.
• Extensive experience in Project Management, Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Delegating and Conflict Management.
• Experience in facilitating Joint Requirement Planning JRP sessions with Business User Groups and conducting Joint Application Development JAD .
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business, Military and Technical Environments.
• Expertise in Data Extraction, Table Management, Query Management, and Data Integrity.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Oracle, Basecamp, and MS Projectwhich helped in controlling numerous changes produced by the teams across the deliverables for a project.
• Involved in Test Planning, Test Preparation, Test Execution, User Acceptance Testing UAT , Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Liaison with various business units from Executives, Operations, Marketing, Sales, Technologies, and Outside Clients and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Communication, Organizational, Analytical, Mentoring Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Programming Languages : SQL, PLSQL, JavaScript, AJAX, CSS, HTML5, VB, ASP.NET, XML

Operating Systems : Windows 95/98/NT/2000/XP, Linux, UNIX

Databases : Oracle, MySQL, SQL Server, MS-Access

Application Servers : Oracle, ColdFusion, Actuate, Maximo

Project Management Tools : MS Visio, MS Project, Basecamp, Adobe Photoshop

Bug Tracking Tools:MANTIS, Mercury, Spiceworks

Reporting Tools : Crystal Reports, TOAD, Actuate, MS Office

Data warehousing Tools : Oracle, MySql, Business Objects, Erwin

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Maintain Oracle database for 19 branches throughout Southeast Iowa. Develop high-level reporting through Open Solutions application and cView with PL/SQL. Extensive programming and database modeling.

Responsibilities

• Working through business model and identifying areas of need within the organization to streamline workflow processes of the main departments.
• Collaborate with the outer branches to enhance efficiency in systems and day to day business.

IT Manager, Project Manager

Barclayhedge.com is a client website whereinternational alternative investors login to update fund performance, list additional accounts, and update registered firm information.Worked as a BA/PM to streamline existing business processes, design develop a new web UI for client data input, restructured the legacy UI from business requirements. Responsible for heading a team of Developers, QA Tester, and Department Leads in design and functionality.

Responsibilities

• Performed analysis on existing systems, recommended enhancements, and implemented strategies to streamline current processes using UML.
• Used Business process modeling to streamline the existing processes, channels through which customers contact BarclayHedge like phone, web, email,etc . The email communication required a standard voice for the company, therefore designed and implemented email templates for account managers to select from internal portal dashboard.
• Similar process modeling was done for identifying the manual process of adding investor accounts and translating into a web user interface, removing the pain points bottlenecks resulting in a significant improvement in user experience with BarclayHedge. Through this restructuring, system performance was highly improved.
• Involved with all the phases of SDLCthroughout the project life cycle. Developed MySQL reports, Perl scripts to integrate with internal portal dashboard.
• Prepared Logical Data Models and Business Requirement Documents supporting documents containing the essential business elements, detailed definitions, and also created the functional requirements of the project.
• Assisted with user testing of systems, developing and maintaining quality procedures, and conducted User Acceptance Testing UAT .

Project Manager, Web Systems Analyst

Confidential is a customer based website structured for international marathon athletes. The core concentration is on the photography products offered by Marathonfoto for these athletic accomplishments. The projectsareweb based applications developed for multi-country races customized for each major sponsor. Consistent communication was required between various international key sponsors in developing the pages for their community pages. Geared toward social networking and integrated with ordering large volumes of products for their event.

Responsibilities:

.

• Performed 6 months pre-planning phases with each international race sponsor for marketing material, UI design and layout, ad links, and content management.Utilized Basecamp to track and record project status of 20 international races on a rolling 6 month period.
• Documented business requirements for new products based on international specifications ie. paper size, metric measurements, lab location, points of contacts . Gathered appropriate sign-off on completed product development. Facilitated FTP integration on various department levels.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues. Resolving customer service inquiries of damage products, and reworking code, database functionality to correct image errors.
• Designing and customizing data models for multiple databases supporting data from multiple sources. Implementation, testing for web page language translations of products, content and special characters in athlete's names.
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.Suggested measures and recommendations to improve the current application performance.

Project Manager, Business Analyst, Programmer Analyst

Confidential is a highly established international company building agricultural and drilling products. It encompasses commercial, agricultural, individual, and international clients. I worked in various roles to build order entry systems from the production warehouse, designed and developed the asset warranty management system, developed high level business reporting on the Oracle portal platform system, and programmed on the Glovia application.

Responsibilities:

• Reverse engineered existing projects and gathered business requirements to design workflow process.Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Facilitated JAD sessions with SMEs and business analysts from other plants for a detailed analysis and a better understanding of impact of various projects on each other.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Created project plan from conceptualization to completion to include: ERD, Queries, Milestones, Risk Analysis, WBS, and Departmental sign-offs.
• Responsible for preparing Business Requirement Document BRD and then translating into functional specifications and test plans. Closely coordinated with various business users and developers for arriving at a mutually acceptable solution.

supply warehouse, sensitive items, and classified materials with Top Secret Clearance classification. Mentored junior military members, and provided logistical plans and procedures for training missions nationally. Distinguished Honor Graduate, Army Achievement Medal Award

Oracle DBA