SUMMARY OF QUALIFICATIONS

• 10 years experience utilizing the systems development life cycle as a Technical Analyst in the manufacturing, banking and finance, aerospace, pharmaceutical, nonprofit, telecommunications and business services industries.
• Demonstrated success managing and collaborating with cross-functional teams in evaluating an organization’s operational processes and reviewing the feasibility of process improvement initiatives.
• Analyzed, designed, implemented and supported enterprise applications and database systems to achieve overall business strategies and trained users on software utilization.
• Proficient in data modeling, database design, query development and optimization strategies, and enforcing data integrity validation rules to support the reporting infrastructure.

TECHNICAL SKILLS

SQL, VB.NET/Visual Basic 6.0, T-SQL, Oracle PL/SQL, VBA, VBScript, JavaScript, HTML, UNIX Shell Scripting

Software:

SQL Server 2005/2000, SQL Server 2005 Management Studio, DTS, Oracle 9i/8i, MS Access 2007/2003, MS Excel 2007/2003, MS Project, Visual Source Safe 2005, Red Gate SQL Data Compare 6/Compare 6/Dependency Tracker 2

Technologies:

Visual Studio 2008/2005/6.0, ASP.NET 3.5/2.0, ADO.NET, IIS, ActiveX, COM+

Systems:

Windows XP/2000/NT, UNIX, Linux

Reporting:

Crystal Reports 11/9/8, SQL Server 2005/2000 Reporting Services, MS Access Reports

Data Modeling:

Visio 2007/2003, Erwin/ERX

WORK EXPERIENCE

Database Developer, March 2008 Present
Confidential,Manhattan, New York

• Facilitate the Finance and Accounting departments by enhancing and supporting E-Z Reports, their loan, grant and program action in-house reporting system that was built using Crystal Reports 11, ASP.NET, SQL Server 2005/2000/7 and T-SQL, in order to monitor LISC’s business operations of securing capital for lending to a Community Development Corporation’s (CDC) program action, a project to economically revitalize distressed neighborhoods.
• Administer and manage Tenrox, a multi-site, online project workforce management software package, by assisting the Human Resources and Payroll departments with T-SQL solutions to customize their ADP data vendor integration to improve their daily time tracking and semi-monthly payroll processing requirements.
• Function as the backup to the DBA on a daily basis by monitoring nightly jobs, checking free space on pertinent drives, enforcing the Database Disaster Recovery Plan and performing ad hoc database backups and restorations.
• Served as the Lead Data Analyst to the Consultants in the Program Action System (CPS) Project that accommodated the monitoring of consultants, in addition to projects financed by loans and grants, in the PA System by collaborating with the Senior .NET Developer on formulating logical data models and database schemas, amending the existing ERD and integrating feasible T-SQL development solutions.
• Designed and implemented the Local Advisory Committee (LAC) Report using SQL Server 2005 Management Studio, T-SQL and Crystal Reports 11 that was used by LISC’s Board of Directors and Senior Management to measure the financial stability of their 30 urban offices and Rural LISC.
• Implemented effective indexing and tuning strategies, utilized SQL Server 2005 Database Engine Tuning Advisor and SQL Server 2005 Profiler, and incorporated Red Gate Data Compare 6 for comparing relevant datasets that increased overall query performance by 35%.

Senior Technical Analyst, Contractor, June 2006 December 2007
Confidential,Illinois

• Assisted the Billing Operations department by automating financial reports for management and designing systems to monitor and support customer account service orders that integrate to OLTP databases.
• Collaborated with Operations Managers in gathering and analyzing business requirements to the Order Consolidation operational data store (ODS) that integrated customer, order and sales data, and financial and billing cycle spreadsheets, and the Order Fulfillment decision support system (DSS) that implemented time-series predictive modeling to perform customer churn trend analysis to assist in developing customer retention strategies.
• Designed and implemented the Order Consolidation ODS and Order Fulfillment DSS data architectures using SQL Server 2000 and T-SQL, integrated web reporting functionality using SQL Server 2000 Reporting Services and Excel Pivot Tables, and instituted the Enterprise Decision Support data dictionary that regulated documentation standards for BI systems.
• Created daily automated DTS packages for the ETL process that cleansed, integrated and loaded operational transactions to the Order Consolidation ODS and developed a nightly automated DTS package that mapped and migrated data between the Order Consolidation ODS and the Order Fulfillment DSS.
• Constructed and managed the Process Documentation Application, a multi-site, on-line document management system, using VB.NET, ASP.NET, SQL Server 2000 and T-SQL that improved IT operations by centralizing the technical documentation repository and streamlining search, retrieval and archival capabilities.
• Redesigned the Accounts Receivable (A/R) Aging Report using SQL Server 2000 and T-SQL and implemented Excel Pivot Tables to allow multi-dimensional views of outstanding balances, charges, payments and adjustments by standard aging intervals and customers to identify an average payment range thereby establishing feasible payment schedules that improved operating budget forecasts and increased operating capital by 25%.

Systems Developer, Contractor, March 2004 May 2006
Confidential,Chicago, Illinois

• Assisted the Market Risk Analysts and Portfolio Managers by generating daily risk management reports that monitor derivative securities to analyze the market risk of financial instruments, developing analytical models to measure equity risk exposure of portfolios and supporting the Macgregor Financial Trading Platform (MFTP) trade order management system by maintaining automated DTS packages to ensure reconciliation between order management and reporting databases and designing data integration solutions to financial tools and platforms.
• Built data and process workflow models using Visio and created ETL tools by designing a master DTS package that spawns sub-packages that parses flat files and extracts source data to interim staging tables, performs data validation and loads validated staged data to an ODS thereby rebuilding required ODS indexes to optimize query performance and minimize server disk contention.
• Developed the Stress Test Modeling Application using VB.NET, Excel 2000, VBA, SQL Server 2000 and T-SQL that measured the change in value of the portfolio composition by monitoring its effects on changes in equity prices, implied volatility and interest rates thereby improving management contingency plans to mitigate adverse market movements.
• Designed the Equity VaR Limits Performance Report using SQL Server 2000 Reporting Services, VB.NET, Excel 2000, SQL Server 2000 and T-SQL that analyzed the accuracy and validity of current VaR limits by examining the cumulative variations of VaR against 6-month backtest of P&L values and the VaR limits thereby providing senior management with policies to monitor and enforce setting risk limits and improving capital allocation strategies.

Data/Report Analyst, Contractor, February 2003 February 2004
Confidential,Chicago, Illinois

• Served as the Capital Markets Risk IT (CMRIT) Data/Report Analyst to the Market Risk Management (MRM) team for the Bank One Capital Markets business unit by gathering business requirements, profiling disparate source files, supporting and implementing customized financial Excel spreadsheets that measure and analyze the market risk across line of business risk groups, and maintaining the web reporting infrastructure.
• Administered the MRM web reporting infrastructure by defining a service level agreement (SLA) between the MRM team and CMRIT for promoting the accurate and on-time service delivery of on-line market risk web reports by close of business each day.
• Developed the File Load Automation Application using VB.NET, Excel 2000, VBA, Oracle 9i and Oracle PL/SQL that improved root cause analysis by identifying defective source file transmissions in a timely manner that benefited the MRM team by optimizing their operational workflow.
• Created and integrated the File Load Status schema to the existing database architecture to generate metadata and track operational metrics using Oracle 9i and Oracle PL/SQL.
• Designed and deployed the Value-at-Risk (VaR) Summary Report and Quarterly Backtesting Report using Excel 2000, VBA, Oracle 9i and Oracle PL/SQL by establishing VaR limits and calculating VaR using historical simulation to monitor trends in market risk exposure across investment portfolios thereby streamlining the MRM team’s response time to sudden increases in volatility risk causing positions to exceed their estimated VaR limits.
• Redesigned the Equity Derivatives Report using Excel 2000, VBA, Oracle 9i and Oracle PL/SQL that measured the price sensitivities of equity derivatives by tracking the profit and loss of equity indexes, single stock options and equity swaps on a daily, monthly and annual basis to accurately monitor the risk of option trading strategies.
• Developed the Daily Equity VaR Calculator Application by factoring a 2 year LIBOR, implied volatility and price sensitivity that were based on a 2 year historical time-series using a Bloomberg API, Excel 2000, VBA, Oracle 9i and Oracle PL/SQL that improved managing day-to-day trading exposures.
• Instructed the MRM team on simple and complex query building techniques and optimization strategies using Oracle 9i at the weekly Lunch and Learn workshops thereby improving CPU utilization on the server and empowering business users with ad hoc querying capabilities.

Data Analyst, Contractor, August 2002 December 2002
Confidential,Louisville, Kentucky

• Served as the Solectron Global Services (SGS) Data Analyst to the Production Line Managers who coordinated the warranty repair of cell phones for several leading wireless companies including Verizon, Alltel and Nextel.
• Interacted regularly with business users to analyze and troubleshoot Excel spreadsheets containing cost accounting and operational metrics, and supported the SGS Crystal Reports 8 web reporting infrastructure thereby facilitating formal and ad hoc data requests.
• Developed and supported automated DTS packages that monitored source files, cleansed and rectified data in the staging area and notified the IT support team of data anomalies throughout the data migration process thereby coordinating remediation efforts and reducing latency.
• Led the SGS project team in developing the Solectron Staffing Administrator using KRONOS, a web-based workforce management system that measures employee attendance, Visual Basic 6.0, Excel 2000, VBA, SQL Server 2000 and T-SQL to optimize staffing levels by forecasting the required allocation of staffing resources to meet daily, weekly and monthly production levels that resulted in a 30% increase in overall productivity.
• Coordinated with the project lead on determining projected completion dates, solutions to project bottlenecks and project prioritization tasks.

Systems Integration Analyst, January 2000 June 2002
Confidential, Pennsylvania

• Served as the CompassCONTRACT System Administrator, an MRP II software package, that assists the Materials Management Systems (MMS) team with material requirements planning, inventory control and production scheduling for the Lockheed Martin Management and Data Systems (M&DS) business unit.
• Managed, supported and debugged QuickTrack, a multi-suite, in-house Visual Basic 6.0 application that handles material receiving, identification and tracking for MMS.
• Developed logical data models using Erwin/ERX and Visio to facilitate data analysis and created data integrity validation modules using Oracle 8i and Oracle PL/SQL to ensure data accuracy and reliability from the source IBM legacy systems before migrating to the production environment.
• Directed and managed the MMS reporting infrastructure upgrade from Crystal Reports 7 to Crystal Reports 8 to improve reporting functionality and maintain departmental standards for web reporting.
• Led the MMS project team on building and documenting the Bulk Issue and Bulk Transfer Application using Oracle SQL*Loader, Oracle 8i, Oracle PL/SQL and Korn shell scripting that identified and categorized residual materials that were to be either scrapped or returned to inventory thereby increasing material utilization by 20%.
• Designed and integrated the Bulk Issue and Bulk Transfer Reports to the preliminary web interfaces that prohibited unauthorized users from accessing proprietary data using Crystal Reports 8, VBScript and ASP.
• Assisted the project lead on efficiently managing multiple projects and resolved critical path issues in a collective, timely manner.

Database Developer, January 1999 January 2000
Confidential,West Lafayette, Indiana

• Assisted Krannert graduate students and employees of the Krannert Graduate School of Management in the development and implementation of Access 97/2000 databases to support their data management requirements.
• Collaborated with users in defining business requirements, developed ERDs using Visio, implemented the physical database design using Access 97/2000 and VBA, provided ongoing database support and trained users on software utilization.
• Incorporated Access Reports functionality to the Master of Science Grades Database using Access 2000 and VBA that aided admissions personnel in screening Krannert applicants thereby expediting formal and ad hoc report requests, developing a consistent reporting format and familiarizing business users to Access Reports.
• Redesigned the Krannert Donations Database that categorized donors and generated customized letterheads per designated club membership using Access 2000 and VBA by adding GUIs to streamline the data load and extraction process.

Web Programmer, Co-Op Student, January 1998 June 1998
Confidential,Skokie, Illinois

• Served as an intern to the Scientific and Management Information Systems (SMIS) business unit for Searle, Monsanto’s pharmaceutical subsidiary.
• Designed and implemented the SMIS homepage and the Problem-Notification website using ASP and JavaScript that supported laboratory personnel in receiving timely responses to operation bottlenecks associated with the Sample Labeling System.
• Collaborated with business users on gathering process and design requirements for the Problem-Notification website and instituted the Problem-Notification Remediation Process thereby increasing workflow efficiency and operational control.
• Integrated the Problem-Notification schema to the existing database architecture to facilitate metadata collection and internal, operational reporting using Oracle 7.3 and Oracle PL/SQL.
• Normalized and deployed the Searle R&D Inventory of Computer Systems Database using Access 97 and VBA that improved tracking of quarterly hardware/software procurements and developed the ERD using Visio.

EDUCATION

B.S. Computer information Systems
Business Management Minor