Application Development Analyst Resume HERNDON, VIRGINIA - Hire IT People

SUMMARY:

Business Analyst and Data Modeler with MS in Computer Science and 20 years of experience in the development of commercial software. Excellent skills in requirements gathering, analysis, design, development, testing, troubleshooting, production support, documentation, mentoring and vendor management. Proven record of delivering cost effective and flexible solutions to meet challenging business demands. Committed team player on projects, driven by new challenges and a constant desire to excel in all endeavors.

TECHNICAL SKILLS:

Advanced Skills: Access, Solaris, Windows NT, Java, C++, Eclipse, Oracle, SQL, Visio, JSP, Toad, RapidSQL

Intermediate Skills: Excel, XML, XSL, HTML, Sybase, Weblogic, HP Quality Center, Junit, HttpUnit, Ant, Visual Basic, PL / SQL, EJB, Bloomberg RequestBuilder, Orbix, Struts, PVCS, SVN, Netezza, ER Studio, Agile methodology

Novice Skills: MS Project, Requisite PRO, Ab Initio, MMG Cap, Crystal Reports, TopLink, Rational ClearCase, SelectOMT, Rendezvous, DBTools++, Tools++ and Threads++, Rally, Aginity Workbench

PROFESSIONAL EXPERIENCE:

Confidential, HERNDON, VIRGINIA

Application Development Analyst

Responsibilities:

Analyzed LAI reporting requirements, different data sources and data volumes and designed parts of the data model for reporting data mart. Specifically tasked with analyzing the Disclosure, Management, Accounting and Validation reports to model the complex BTL and Derived tier in LAI data mart.
Assumed responsibility for timely delivery of the LAI Engine logical and physical data models on a periodic basis. Delivered over 100 incremental data model releases across multiple database branches to support parallel development.
Successfully maintained parallel database branches for eventual merger into production trunk.
Mentored a junior developer on overall LAI design, building scripts and publishing database releases to serve as a contingency resource
Aligned the delivery of logical data model and physical database scripts to support an Agile development model (Sprints) for the LAI Non - Performing Loans (NPL) project.
Coordinated the design and implementation of contingency servers for the different components of LAI infrastructure in the local region.

Confidential, MCLEAN, VIRGINIA

Business Analyst

Responsibilities:

Elicited and documented business requirements for corrective, steady state and DME issues for iREMS
Analyzed business requirements, determined data model requirements and documented them
Created preliminary user interface design from business requirements using MS Access
Facilitated meetings with HUD business users to both gather initial requirements and liaised with users regarding follow-up clarifications from development
Conducted walkthroughs of detailed requirements for development team
Wrote System test plans and UAT test plans for assigned CR issues in a release
Performed analysis and prototyping for the iBFM predictive analytical model using Excel
Gathered requirements and performed analysis for enhancements to the iBFM Transaction Funding and PBRA Forecasting modules.
Reviewed test scripts written by tester and provided relevant business and technical mentorship to tester
Performed System Testing for CR issues assigned in a release
Captured results of System Testing (including screen snapshots) and documented the test details
Reviewed updated User Guide and provided input related to assigned CR issues

Technologies Used: Access, Excel, Solaris, Windows NT, Oracle, Sybase, Toad, Microstrategy, Serena Dimensions, PVCS, WebLogic, Oracle SQL Developer, Sybase ASE

Confidential, LANSDOWNE, VIRGINIA

Sr. Business Analyst/Liaison

Responsibilities:

Conducted user sessions to elicit requirements using questionnaires and internal client team interviews
As a vendor liaison, led meetings with external vendors on a weekly basis to manage operational issues related to all the EMDEx data retrievals
Reconciled vendor invoices with system-generated invoices and estimated monthly client allocations. Led meetings with Accounting, Procurement and Finance to ensure prompt resolution of invoice related issues
As a key contributor to the EMDEx analysis effort, helped streamline market data requests so that the project would save costs of about 10 million per year for Confidential . As an analyst, recommended the use of packaged products in a second phase of the project that reduced costs by an additional 700K annually
Managed a project to identify all under-utilized and unutilized Bloomberg Terminals within company using a third party software that resulted in savings of 600K annually

Technologies Used: Solaris, Windows NT, Oracle, Toad, MS Access, Bloomberg RequestBuilder, MMG Cap, SQL, Visio, Requisite PRO, HP Quality Center

Confidential, LANSDOWNE, VIRGINIA

Analyst/Manager

Responsibilities:

Planned and managed the execution of the Accounting (GL) module for Confidential 's Restatement (2002-2004), Catch-up (2005 - Sep 2007) and Get-Current (Oct 2007 onwards) projects
Was instrumental in building an integrated dataset to test scenarios across the SCBSL work streams
Helped reduce number of defects by developing a slew of validation queries
Responsible for analyzing Data Corrections applied in production, planning for operational readiness, and the project plan for the transition of SCBSL to support 11-day accounting close.

Technologies Used: Solaris, Windows NT, Oracle, Ab Initio, RapidSQL, MS Project, SQL, PL / SQL, Visio

Confidential, MCLEAN, VIRGINIA

Senior Developer

Responsibilities:

Performed analysis of reporting requirements for the TradeSupport stream
Developed a web-based application for accessing TradeSupport restatement reports
In charge of configuration/deployment scripts for the web based application
Developed Crystal reports for the sub-system

Technologies Used: NT, WebLogic 8.2, Struts 1.1, JSP, Junit, Sybase, Crystal Reports, SQL, Ant, Eclipse

Confidential, MCLEAN, VIRGINIA

Senior Developer

Responsibilities:

Gather Use Case requirements for the SAM sub-system and documented them
Involved in analysis, design, development and testing of the SAM modules written in Java using EJB component architecture
Mentored junior developers that were part of the team
Was a key team member in the troubleshooting effort post-deployment
Wrote FAQ and User Interface guides for the SAM module

Technologies Used: NT, WebLogic 8.2, Oracle, EJB2.0, Struts 1.1, JSP, XML, Junit, EasyMock, SQL, RequisitePro, Rational ClearCase, Eclipse