SKILL SUMMARY

PROGRAMMING LANGUAGES/API S

PROJECT MANAGEMENT

APPLICATION SERVERS

Java 2 J2EE

Visual Basic 6.0 VB .NET

C C Visual C C

Ruby

AJAX HTML DHTML XML XSL

ASP ASP.NET JSP JavaScript

SQL T-SQL PL-SQL

SOAP XOG GEL NSQL

Facebook Graph API

RestFB 1.6.6

JQuery JSON

NIKU CLARITY 7.5.2

NIKU CLARITY 7.5.3

NIKU CLARITY 8.1

CLARITY PPM 12.0 12.1

CLARITY PPM v13

CLARITY PPM ON DEMAND

Microsoft Project

Clarity Workbench

BEA WEBLOGIC 7 8

IBM WEBSPHERE 5.0

ORION 2.02

BLAZIX

SUN ONE APPLICATION SERVER

IIS

Apache Tomcat

DEVELOPMENT TOOLS

NIKU CLARITY Advanced

PERFORMANCE TUNING

SAP Business Objects

Infoview WEBI Designer

Universe Builder CMS

Crystal Reports

MS Visual Studio.NET

Oracle SQL Developer TOAD

Aqua Data Studio

JDK 1.1 1.7

CSH KSH BASH

FrontPage Dreamweaver

XML Spy

RSA Eclipse

PhoneGap for Android

PhoneGap for I-Phone

X-Code

Clarity Studio

Financial Management

Demand Management

Requirement Management

Resource Management

Portfolio Management

Project Management

XOG NSQL GEL

XML XSD WSDL

Query API

InvokeAction API

Object API

Advanced HTML Portlets

Advanced GRID Portlets

Advanced Graph Portlets

Database T-SQL Functions

JSP utilizing Niku API s

HP Performance Center

Mercury Load Runner

Query Analyzer

MSSQL Mgmt Studio

SQL Profiler DTA

Performance Monitor

Top

Glance

Oracle Enterprise Manager

Oracle SQL Developer

Server Manager

RDBMS

NETWORK SECURITY/DIGITAL FORENSICS

OPERATING SYSTEMS

MS SQL Server 2012

ORACLE 9i 10g 11G

SYBASE

IBM DB2

MY SQL

MS ACCESS

INFORMATICA

ARMITAGE

METASPLOIT

WIRESHARK

SETOOLKIT

ETTERCAP

SSLSTRIP

TRUECRYPT

OXIGEN FORENSICS SUITE 2014

OXIGEN FORENSIC EXTRACTOR

TCP/IP V4/V6 OSI DOD

RIP OSPF ARP RARP UDP

TCP FTP IMAP POP SMTP DNS DHCP WINS NETBIOS

WAN FRAME RELAY FDDI Token Ring Ethernet ATM Wireless

Windows 2003 Server - EE

Windows 2000 Advanced Server

Terminal Server

Windows 98 NT 2K Pro Vista

Window 7

MAC Tiger Leopard Lion

HP-Unix

Sun Solaris

Red Hat Linux

Kali Linux

Ubuntu

PROFESSIONAL EXAMPLES

PROFESSIONAL EXPERIENCE confidential

Sr. Solution Architect Winmill Software

Business Function Clarity PPM v12 Technical/Functional development and design. Duties include Custom Portlet Design and Development Database Design Development performance Tuning analysis interface development process development report development architectural assessment solution design and so on.

FDW/CPFM Data Export/Import Interfaces

Business required that interfaces be built to facilitate financial data information flow between Capital Planning Management System and Financial Data Warehouse. Requirements included data for Budget Forecast Actuals Commitments as well a master project detail information. Created the following interfaces

CPFM to FDW Master projects with attributes CPFM to FDW Project Players CPFM to FDW MOD Code CPFM to FDW Cost Plan budget header development CPFM to FDW Cost Plan details budget lines development CPFM to FDW Budget Category CPFM to FDW Budget Entity FDW to CPFM FDW Actual Capital Expense Budget Forecast and Commitments Data

Project Reference Financial Summary Web Services

Business required that web services be created to facilitate the extraction of financial and project detail data for downstream systems via a real-time API. Create the following

CPFM Master Project Reference Web Service via Clarity Query API and N-SQL CPFM Financial Reference Web Service via Clarity Query API and N-SQL

Budget Transfer Process

Business required that a custom budget transfer portlet be created in order to selectively transfer money from one project to another one project to many many projects to many or many projects to one. Portlet needed to display source projects along with a multitude of filters allow for the selection of capital from one or many periods and allow for the transfer of the total sum to be spread across either one or many projects. Subsequently a series of approvals based upon a routing matrix needed to be utilized to determine the approvals needed based upon specific criteria. Once action items were approved the transfer would then take place.

Created HTML Budget Transfer Portlet utilizing JavaScript N-SQL Query API Object API Three Clarity Objects and one Process with embedded gel scripts.

confidential

Business Function Develop and enhance software applications using technologies such as Java Ruby C and HTML.

Goals and Controls

Business required that changes enhancements and fixes be made to an enterprise wide custom project management application designed to manage tasks. confidential

Business Function Clarity PPM v12 Technical/Functional development and design. Duties include Database Design Development performance Tuning analysis interface development process development report development architectural assessment solution design and so on.

Clarity Remedy Timesheet Gateway

Business required a way to aggregate and import actuals from external Remedy system and migrate that data into Clarity timesheets dynamically adding users to projects and other work categories by defaulting allocations creating the necessary tasks and assignments. Developed tested and successfully deployed Clarity Timesheet Gateway gel script to facilitate requirement. Also architected database framework to capture time transactions via ETL as well as audit users being added to projects and other work categories by the interface. In addition created a multitude of reports which allow various views into both time and status information for gateway resource information. These reports are now sectioned into what is called the Clarity/Remedy Integration portal.

Executive Reporting

Business required a way to collectively view and compare allocation actual availability capacity and demand for all roles and resources throughout the organization by week month quarter and year. Designed and optimized the following reports utilizing parameterized Oracle PL/SQL Pipelined Table Functions to allow for week/month/qtr/yearly options in a single view for each report

1. DoITT Timesheet Report

2. DoITT Resource Utilization Summary

3. DoITT Resource Utilization Detail by Resource and OBS group

4. DoITT Resource Utilization Detail by Project/Other Work

5. DoITT Resource Utilization by Manager and OBS

6. DoITT Availability Variance by Resource

7. DoITT Capacity Variance by Role

Deployed to prod as part of Clarity/Remedy Integration Portal

8. Gateway Resource Management Unassigned and Assigned

9. DoITT Resource Timesheet Summary II

10. DoITT Missing Timesheet Report

11. DoITT Effort Exceeding 24hrs per day

12. Remedy Staging Report confidential

Business Function Clarity PPM v12/v13 Technical/Functional development and design. Duties include interface development performance analysis process development report development architectural assessment solution design and so on.

HP Performance Center Load Testing

Business required a way to test the overall performance of the entire system given projected max concurrent user capacity. Created scripts to XOG in 400 users. Then recorded VUGEN scripts to simulate user actions. Modified scripts to alternate between users via parameters configured monitors load generators test groups plans uploaded scripts and initiated load tests ramping up by two users every 15 seconds. Was able to crash system at right around 200 concurrent users. Also performed testing with JProfiler enabled to test tool capability.

Clarity Documentum Interface

Business required a way to sunset their existing document management system CAMIT . However prior to doing so business needed to recreate projects in Clarity as well as migrate all document content. Migrated file store from Documentum and architected procedures and processes to translate hexadecimal encrypted file names. Created interface process to align documents with appropriate Clarity projects via gel.

Performance Tuning

Business received complaints in regards to speed when navigating through numerous areas within the application. Executed SQL traces for slow performing queries analyzed execution times in milliseconds isolated slow statements profiled and examined explain plans to analyze query costs and worked with DBA s to run statements through STA SQL Tuning Advisor seeing they restricted us from doing this ourselves. The results were astronomical increases in speed. More tuning to continue as well given more development is being done.

Created the following confidential

Business Function Clarity PPM v13 Technical/Functional Architect. Duties include creating training content for Project Mangers Program Managers Resource managers Directors VP s and Finance personnel. Developing solutions in regards to annual planning via Ideation. Creating and Implementing coding solutions for PMO. Engage in architectural discussions in order to implement global solutions for the company.

Created the following

Ideation Configuration for AOP/BRW Data capture

Business required a way to perform annual planning as well capture business requirements for potential projects. Configured Ideas to allow for capture of AOP and BRW data along with the development of critical process workflows that mirrored existing business processes and notification flows. VP was extremely happy.

Professional CAPEX and OPEX Rollup Development

Business required a way to calculate costs for professional services as well as CAPEX and OPEX data with extremely strict security considerations that limited what specific individuals could see on an extremely granular level. Business also rejected the use of the team tab cost plans and cost matrices due to the fact that rates were not determined by finance but by the directors themselves. In addition business directors wanted to hide rates for resources within their teams as well as be able to report on their data historically and at a portfolio level. Created Professional Service CAPEX and OPEX objects to allow for user restricted entries by role both for internal and external resources and architected processes to calculate and push cost totals into simple budget project fields for both ideas and projects to allow for portfolio analysis. Created object based reports to provide VP s with complete visibility. Customer was extremely pleased.

Dynamic Historical Status Report

Business was not at all happy with the OOTB status report and requested that a specific status report with extensive window volumes of data be built with built in historical tracking of cost effort and so on. Architected solution utilizing a combination of custom objects processes and object based portlets. Consolidated view with filter portlet. Customer was ecstatic. confidential

Business Function Clarity PPM v12 Technical/Functional Implementation Process Audit Manager. Duties include creating and performing training for Project Program and Resource managers on how to utilize the tool. Developing solutions when requirements are either too difficult or costly for available on-shore/off-shore CA resources. Driving monitoring and providing recommendations on production issues to facilitate resolutions. Coaching mentoring and instructing CA and Internal resources on requirements or issues. Developing communicating internal processes standards and documentation. Monitoring projects for Capital Expense Request deviations in cost. Approving Captial Expense Requests. Instructing PM s and PgM s and where to cut cost as well as negotiating rates for vendor SOW s based on predefined roles. Providing recommendations and architecting resolutions in regards to Clarity PPM usage.

Created the following

SOW Termination Date Solution

Business required a way to perform capacity planning for critical chain resources SME s throughout the company. However due to the fact that many SME s were contractors with valid dates of termination in Clarity no capacity planning could be done for these resources Confidential their date of termination. Created an attribute called SOW Termination Date on the resource object. Created a process to copy the dates of termination for all contractors over into the new field and wiped out the existing date of termination. Created a subsequent process to deactivate users when SOW Termination date was reached and implemented solution as a scheduled job.

Capital Expense Request Manager

Business required a porlet to view archive and retrieve cost plan by resource data dynamically from system the problem being that the current cost plan bundles roles and doesn t show resource data by individual. The previous process was to maintain a manual spreadsheet with resource cost details for every project. Consulted CA with regard to peforming this effort and Global delivery stated that the objective was impossible. Created an html portlet utlizing XOG via xmlhttp to allow users to see resource cost breakdown for actuals and etc s by extracting the prteam etcs and actuals obtaining the resources primary role and rate from rate matrix. To archive the data the portlet reads the output from the html body via getElementsByTagName and xogs in the output html as input to a custom object. The process is then reversed for precise retrieval. Also enhanced the portlet to provide simultaneous creation of cost plan pagination export to excel export to pdf summary by OBS and costs by year. The end result is that if the cost plan is modifed we have a complete snapshot in time of what the project looked like when the Capital Expense Request was submitted. Currently the porlet also extracts retrieves and archives data with sub second timings. Change was approved by CA and was in line with their customization policy.

Created the following suite of reports

SME Allocation/Availability/Demand

SME Skills Listing

Cost Plan by Resource

User group security report

AGS Accelerated Growth Strategy Report

Global Resource Actutals By Project

Remaining Cost/Actuals Fiscal Period Report

Capital Expense By Fiscal Year

Status Link Sync

Business required a way to copy status report attribute fields to the project level in order show them on project list page. Mirrored required attributes at project level and created an autostart process to facilitate this. Also created a link to the latest status report using a virtual field on the project list page. confidential

Business Function Architecture Review Interface Development Documentation

Created the following

Enhancments to ATARS/Clarity Interface

Business required enhancements to previous interface developed to enable project closeout synchronization of date and status information from Clarity to ATARS. Developed tested documented and deployed enhancements in Development. Then after sucessful testing and training of staff deployed to production successfully. Click to view code samples and documentation

Project Closeout Process

Business required a process to close out projects based upon project progress atrribute status paired in conjunction with a full suite of completed tasks. Developed auto-start Project Closeout V3 process which triggered upon project progress status change subsequently checked all tasks in the WBS and sent action to Closeout Group with approve reject option. Gel script in conjunction with project attribute was used to store open task count and boundary checks were perfromed to determine subsequent steps in work-flow. Developed tested and deployed and documented enhancements in Development. Then after sucessful testing and training of staff deployed to production successfully. Click to view code samples confidential

Business Function Architecture Review Interface Development Documentation

Created the following

ATARS/Clarity Interface

Business required an interface developed between ATARS Custom Audit Tracking/Reporting Tool and Clarity PPM that dynamically converted audit/recommendation/cap data into Clarity PPM Projects. Business also required that the interface exhibit maximum flexibility in the area of configuration so as to be able to change the ATARS data field to Clarity attribute mappings without making changes to a gel script or utilizing any external files or procedures. Created ATARS Interface Gateway in conjunction with Configuration object that allowed for the manipulation of field mappings sub-queries and table join manipulations without any modifications to gel script code. Tested deployed demoed and documented solution to customer s satisfaction. Click to view code samples confidential

Business Function Architecture Review Custom Portlets and Reports using XOG API N-SQL and HTML portlets PL-SQL Stored Procedures PL-SQL Pipelined Table Functions Views and Tables. Security Analysis of OBS Groups and Instance rights. Also issued recommendations with regard to infrastructure changes that need to be made.

Created the following

Actual Hours Costs

When business objects was determined to be inappropriate for delivering the requirement business requested a custom three fold dynamic report to show Actual Hours Costs for labor resources per WIP table transactions at the project program and portfolio level. In addition business requested that WBS tasks be indented as per task properties and allow for expand collapse features as well. Was also asked to rollup and color code metrics from subprojects and tasks regardless of depth at the project level rollup and color code metrics for subprojects and sub-programs at the program level regardless of depth as well as rollup and color code metrics for child portfolios programs sub-programs and projects at the portfolio level regardless of depth. Export to PDF and Excel with color coded formatted columns far Confidential stock display as well as additional field data was also requested. For instances where a subproject or program was included twice or more in the hierarchy duplicate counting of actuals was to be eliminated. Start and finish dates were also requested as filters to be passed into the queries to pull Actuals for a specific date range. A view mode drop down was to also be created to instantly switch between report modes for project program and portfolio and maintain a single display area. Lookups and labels would dynamically change as well as the mode to allow for instant switching between program portfolio and project. Project level was also to be coded with the option to exclude subprojects from the rollup. All data was to be returned in under three minutes and all authentication credentials were to be AES encrypted.

Successfully created tri-fold report in an html portlet per the above specs utilizing the XOG API in three weeks. Return times were sub-second for each level even with large hierarchies and work breakdown structures. Utilized Oracle pipelined table functions to retrieve portfolio and program hierarchy data with connect by clause. These were then embedded in NSQL queries which were called from the portlet via XMLHTTP through XOG utilizing AES encryption/decryption sequences. Click to view authorized screen shots

Compare Actuals to Baseline

When business objects was determined to be inappropriate for delivering the requirement business requested a custom three fold dynamic report to show Actual Hours Costs in relation to project baseline hours and costs for labor resources per WIP table transactions at the project program and portfolio level. In addition business requested that WBS tasks be indented as per task properties and allow for expand collapse features as well. Was also asked to rollup and color code metrics from subprojects and tasks regardless of depth at the project level rollup and color code metrics for subprojects and sub-programs at the program level regardless of depth as well as rollup and color code metrics for child portfolios programs sub-programs and projects at the portfolio level regardless of depth. Export to PDF and Excel with color coded formatted columns far Confidential stock display as well as additional field data was also requested. For instances where a subproject or program was included twice or more in the hierarchy duplicate counting of actuals was to be eliminated. A view mode drop down was to also be created to instantly switch between report modes for project program and portfolio and maintain a single display area. Lookups and labels would dynamically change as well as the mode was changed to allow for instant switching between program portfolio and project. Data was to be returned in under three minutes and all authentication credentials were to be AES encrypted.

Successfully created tri-fold report in an html portlet per the above specs utilizing the XOG API in two days leveraging code from Actual Hours Costs. Return times were sub second for each level. Utilized Oracle pipelined table functions to retrieve portfolio and program hierarchy data with connect by clause. These were then embedded in NSQL queries which were called from the portlet via XMLHTTP through XOG utilizing AES encryption/decryption sequences. Click to view authorized screen shots

AES Data Encryption Portal

When business determined that utilizing a hidden portlet coded to redirect all requests to the main portlet was not enough even in conjunction with Clarity portlet security to conceal usernames and passwords business then asked that all authentication credentials be encrypted using AES encryption.

Successfully implemented javascript AES encryption algorithm via a custom portlet utilizing XOG. Portlet allowed for username and password change and simply xogged over the Soap Config portlet changing the encrypted username password and encryption key along with all other javascript code needed for the SOAP credentials. Reports then extracted the hidden key and decrypted the credentials to access the XML Open Gateway. Technique was then approved by FRB Infrastructure security. Click to view authorized screen shots confidential

Business Function Architecture Review Custom Portlets and Reports using XOG API and HTML portlets Process Development via Clarity Studio Custom Gel Scripts and Procedures Database Analysis of Triggers T-SQL Stored Procedures T-SQL Functions Views and Tables Security Analysis of OBS Groups and Instance rights as well as Interface Analysis and User right automation. Also provided defect resolution for bug ridden processes and deadlock prone procedures by exercising SQL profiler tracing and extracting information via deadlock graphs. Also issued recommendations with regard to infrastructure changes that need to be made.

Created the following

Exodus Migration Portlet

Business requested a point and click drag and drop interface be built to migrate objects portlets processes and other XOG specific components from one environment to another. The intent being that the interface was to be used by someone with very limited knowledge of Clarity. Created a dynamic HTML portlet with underlying NSQL queries to extract the information via SOAP through JavaScript functions utilizing XMLHTTP. Was able to successfully automate an entire build that took hours and reduce the time to mere minutes.

Post Baseline Changes V3 Redesign

Bug ridden process used to baseline projects required rewrite due to a host of complaints and production errors. Analyzed process requirements and decided to start from scratch.

Removed approximately 30 unnecessary hard coded steps.

Made the entire process dynamic so that if we add or remove an additional bank the process can accommodate the change without modification.

Migrated SQL Updates from the process into a stored procedure enhancing performance and eliminating deadlocks. Also incorporated appropriate error handling.

Removed any variables from the scripts that could lock up the process engine as well as modified any queries to use non data locking techniques.

Added a multi-valued lookup called EIC Group Members that is populated upon baseline creation with the EIC group members. This is so we don t have to hard code groups again making this completely dynamic.

Eliminated Duplicate Revision ID error by converting the system action to a project baseline XOG.

Created two additional attributes to capture the EIC and Team lead to later be used as notification points at the conclusion of the work flow.

Process Documentation Script Click to view code samples

With 15 days left with the Booz Allen team the task of documenting the entire implementation was still undone. Since I had only been there a short time and hadn t done any of the previous release work I had to find a quick way to document all the processes in the system. Created a script to query the process related tables and auto generated the documentation in HTML. Documented the entire implementation in less than 7 seconds after executing script.

DB Object Documentation Script Click to view code samples

With 20 days left the task of documenting the entire implementation was still undone. Since I had only been there a short time and hadn t done any of the previous release work I had to find a quick way to document all the database objects in the system. Created a script to query the sys.sql dependency table and auto generated the documentation for the database objects. To differentiate what had been added I used a base release of 8.1 and queried against sys.objects using a NOT IN statement to eliminate stock objects and retrieve only objects that had been added. The entire script took 22 seconds to execute.

ERD For Custom Objects Click to view code samples

With 7 days left a need arose for an ERD to be created with regard to the custom objects that the PCG and Booz Allen Hamilton developers had created. Queried the information schema.columns table for column names of the objects as well as sys.sql modules to see how they were being used. Referenced previously generated process documentation to see if they were being used there as well. Created ERD based on this information.

Architectural Analysis Doc

After a thorough walk through of the implementation discovered that a SOAP service was created on top of XOG to communicate with XOG to XOG changes in. Recommended that this interface be removed and provided information on how the interface should be built based on objects and processes as well as sample code.

Provided information and instructions on how to use processes html portlets and the XML open gateway to properly bring about business requirements.

Also examined security for custom JSP portlets and found that JSP pages were accessible allowing direct access to the system without authentication due to the fact that the sessionID cookie was not being validated. In addition parameters were not validated either opening room for buffer overflow operations as well as possible SQL injection. Communicated way to properly develop solution using HTML portlets without JSP s and triggers.

User Migration Portlet Click to view code samples

Business needed a way to migrate users from one set of groups to another without giving the Business System Administrators access to Clarity studio. Created cross browser compliant html portlet with embedded JavaScript functions to XOG user changes in as well as parameterized N-SQL queries to retrieve user and group related data.

Requisition Sync Process Click to view code samples

Business needed a way to grant visibility into projects for resources in a resource requisition s OBS. Created process which worked with out of the box requisition creation. However rewrote this as a T-SQL procedure based on a SQL-Trace of the application when I found that the out of the box requisition process had been circumvented by a suite of triggers and unsecured jsp pages. confidential

Business Function Web Site Development using JavaScript XML AJAX ASP CSS Advanced T-SQL Programming Google Adsense Integration. Also responsible for completing SOW Development Design Documentation Code Review Testing Implementation

Completed the following

This is a Christian web site that features online bible search live chat forums via AJAX music video jukebox Christian News Feeds Google News Feeds and user registration. The site facilitates cross browser chat and instant messaging via AJAX and allows for communication through firewalls over port 80. confidential

Business Function SQL Performance Tuning Clarity Studio Advanced Portlet development using Portlet Pages Advanced NSQL Queries JavaScript/JSP/Gel/Processes/XOG/WSDL Design Documentation Advanced T-SQL Programming Code Review XOG XML Open Gateway Interfacing for read write Clarity portlets and Interfaces Performance Analysis Correction Custom code development Scripting Testing Implementation Training Instructor/Coordinator

Created the following

ISD Percent Complete Rollup Company needed a way to automate rollup of the complete fields at the summary level for any given WBS at every depth as well as allocate a weighted for tasks based on effort in relation to those summary tasks. Ultimately the goal was to determine the overall complete of the entire project saving countless man hours with regard to manual administration as well as giving VP s and higher ups greater visibility with regard to project progress throughout the division. Originally the requirement spent seven months with CA before being reassigned to me for evaluation. I was able to complete the assessment design coding and testing in approximately five days. Senior management was so happy with the result that after CA requested a review of the code they decided to consult the legal department with regard to securing the code as Competitive Advantage . The code has since been reviewed and certified by CA.

FTE Report Optimization After being consulted to write a scheduling tool for some poorly performing Actuate reports I requested to see the SQL behind the reports. Identified locking issues missing indexes and extremely poor SQL practices. Recommended to management that the report be rewritten. However was only given leeway to tweak the report due to other outstanding efforts. Was able to reduce response time from 1 hour down to 1 minute and 45 seconds. Advised management that a rewrite would deliver sub second response times. However was advised to move on and revisit at a later date.

SQL Server Index Tuning Optimization Due to scalability issues with security functions in SQL Server users were experiencing wait times in excess of 45 seconds per click. After internal employees spent a month investigating the issue and consulting every expert at their disposal I was asked to join a War-room effort to determine the cause of the problem. Worked with Josh Leonne from CA and alerted him to the fact that there was a missing column in one of the core indexes causing the query to induce a table scan. Added the column to the index and the response time fell from 17 seconds to sub second response times.

ISD Project Deliverable Checklist Company needed a way in order to track required documents associated with projects within Clarity. Due to out of the box limitations on objects as well as subpages developed a custom solution utilizing XOG API s in conjunction with XMLHTTP JavaScript HTML and NSQL.

Collaboration Sync Company needed a process to automate the assignment of project managers to collaboration managers when a new project manager was selected. Additionally they wanted to have the member added as a participant and team member. Created clarity process utilizing a Gel Script that would extract data utilizing gelObjectInstanceId via the tag. Return values were placed in variables and utilized in XOG routines and Stored procedure calls to bring about requirement.

Labor Capitalization Query Company needed a report in order to track hours worked in conjunction with the users who worked them and the tasked they worked on. They also wanted a way to see what WBS tasks were the parent tasks for the labor tasks in question and identify whether this should be expensed or not. Create parameterized T-SQL Table Function to retrieve data by USER ID and Time Period.

ISD Job Monitor Company needed a way in order to monitor long running jobs and send an alert when a given threshold was exceeded. In conjunction they also wanted to send a pager alert whenever there was a change in the execution status of a job. Created ISD job monitor utilizing advanced T-SQL queries Jobs Tables Active-X CDONTS script for SMTP relay and a Database Trigger.

Global Security Report Company desired to view all rights allocated to all users within Clarity by be it by Group Instance OBS or Global Assignment. Ran several sql traces to examine what system was doing behind the scenes. Created query and broke report down into alphabetic segments seeing records returned were in the millions.

Trained Contract/Internal personnel on the following

WSDL

XML Open Gateway

XMLHTTP

MSXMLDOM

Advanced HTML Portlets

JavaScript

NSQL

SOAP

Struts Framework confidential

Business Function Configure develop Test and Support Clarity solutions using application toolset with heavy focus on PL/SQL and J2EE Customizations. Mentor Train Offshore and Onshore resources as well as manage team deliverables. Develop and implement coding standards with regard to Clarity PL/SQL and Java Development. Required to function as central point of escalation for technical issues as well as translate triage technical information to and from the business. Perform in depth system analysis of overall architecture and thoroughly document technical specifications. Proactively communicate project road blocks to upper management. confidential

Business Function Configure develop Test and deploy Clarity solutions using application toolset XML Open Gateway XOG Business Process Manager Clarity Studio and Actuate. Convert customer business requirements into functional and technical design specifications Mentor offshore and onshore developers and Perform Clarity Software installation and configuration confidential

Business Function SQL Performance Tuning Clarity Studio Advanced Portlet development using Portlet Pages Advanced NSQL Queries JavaScript/JSP/Gel/Processes/XOG/WSDL Load Testing Design Documentation Advanced T-SQL Programming Code Review DB2 Stored Procedure Development XOG XML Open Gateway Interfacing for read write Clarity portlets and Interfaces Performance Analysis Correction Custom code development Scripting Testing Implementation

Created the following Advanced NSQL Linkable Portlets utilizing advanced user defined database functions indexed table variables custom Clarity Objects and Java Server Pages

Accept Reject Proposed Date Changes VP s Directors and Project Managers required this Custom JSP portlet to be able to mass manage proposed dates to specific tasks within the WBS for Construction Design Real Estate users. PM s could accept or reject proposed date changes and simultaneously notify task assignees of status changes across multiple tasks and projects saving countless hours of time and money.

Upcoming 14 Days Late VP s Directors PM s and Associates required a portlet to display tasks specific to users that were upcoming 14 days or late. The original query written by a CA partner performed poorly and would take almost 30 seconds to retrieve the associated metrics. Rewrote utilizing T-SQL function with memory based indexes and table variables and brought query down to a 2 second response time.

Checklist Items Customer wanted a way to provide a hyperlinked checklist specific to task completion. Created URL attribute for checklist JSP Page and utilized JavaScript to dynamically construct URL specific to environment. Hard coding URL would not work in this case because many different URL s would point to the same server. Used a combination of JavaScript JSP to achieve objective.

Pod Report This portlet has almost 100 columns. These types of reports were originally created as overnight Jobs on the legacy system. The original report written by a CA partner performed so slowly the idea was almost canned. I assumed responsibility and was able to produce the report in 3 seconds.

Projects By Type VP required portlets to gather metrics for stores nationwide. The portlet linked to a breakdown summary portlet called Filtered Project Summary.

Construction Percentages Construction Management required a portlets to gather metrics for construction nationwide. Assumed responsibility when developers could not create it to meet business performance specs. Created a SQL Server function using indexed table variables. Response was instantaneous. Portlet has almost 60 columns.

Real Estate Trip Schedule Portlet to retrieve projects having reached a particular milestone.

Real Estate Committee Schedule Portlet to retrieve metrics to projects with a particular milestone in addition to task breakdown

Projects by Phase Program Year Portlet to calculate store construction metrics. Links to store project breakdown

Out To Bid Portlet to display milestone related data for critical business processes. Replaces previous DB2 legacy reports. Custom requires real-time data

Hot Swap This application was requested due to a Clarity limitation. It allows the assignment of resources across multiple projects instantaneously saving hours of tedious individual assignments.

Filtered Project Summary This portlet provides a project breakdown for nationwide stores detailing store type project type region city state program year etc. The portlet is used frequently as a link to provide additional detail.

Analyzed database queries reports configuration in conjunction with projected load and created appropriate indexes for all reports. Saw 80 increases in response time for all reports. Instructed Wal-mart DBA s on the correct indexes to apply and how to apply them.

After respectfully declining the opportunity to work directly for Wal-mart I was asked to train employees as well as Clarity contractors on the following

JSP

JavaScript

HTML

XOG

Performance Tuning

J2EE

NSQL Queries

SQL T-SQL

Clarity Grid HTML Portlets

Database Indexes and Indexed views

Developed Stored procedures for Clarity to ACRE Legacy System Daily update Integration and new project interfaces. Procedures Read Data from clarity Via Java through SQL Stored Procedure and wrote data to ACRE system via java calls to DB2 Stored procedures. This process will replace the current one running in production and help allow Wal-Mart to ultimately migrate from their current legacy system to Clarity as a way of managing their entire business infrastructure. Also advised WM that this process could have been automated through DTS but design was already approved and java was chosen as a means of scheduling and data transformation.

Assigned task to review SQL code written by CA developers. Due to the complex nature of the queries involved in interfaces reports and processes used in conjunction with base functionally I was requested to rewrite code written by other developers for performance. Conducted tests to see whether queries could be written better and found that many could. Implemented satisfactory solutions by utilizing a combination of database functions stored procedures indexed views and query syntax changes.

CLIENT DETAIL confidential

Created Time Management Portal Application

Assisted with installs and configurations for IBM WebSphere 5.1 On Win 2k Platform

Assisted with Clarity Studio development using HTML GRID and Graph based clarity portlets to deliver business related data to P3 customers per Mitesh Patel s Request confidential

Application support/development for Sun Solaris C and Win 2k applications

Web Development using JavaScript JSP and SQL

Project Management

New hire training confidential

Citrix Metaframe application development/deployment

Web development using ASP JavaScript SQL Server Macromedia Flash and Fireworks

Draft and finalize SOW s confidential

SR. SOFTWARE ENGINEER

Business Function Heavy Web development using JavaScript/ASP/SQL VB Application Development Deployment Firewall/VPN Support Data Storage Management UNIX/WIN2K System Administration Citrix Metaframe Application Installation Deployment Hardware Support Proactive System Analysis Network Management Messaging and Disaster Recovery Management confidential

SR. SOFTWARE ENGINEER

TIER III

Business Function UNIX/NT/WIN2K System Administration Web Development with Java/ASP/HTML Cluster Administration Hardware Diagnostic testing Application Development Java/VB/C Unix Shell Scripting SQL Server Database Administration Conduct Training Seminars and Data Center Management confidential

WEB DEVELOPER

ITSC

Business Function Project Management Training Unix/NT/Novell/AS400 System Administration Citrix MetaFrame Support Web development with Java/ASP/VB/HTML/SQL Shell Scripting Project Management Remote Access Management Policy/Procedure implementation confidential

GE CAPITAL GE POWER LUCENT TECHNOLOGIES EMORY AMERICAN RED CROSS

Business Function Windows NT Domain Administration UNIX Application Support Custom Application support Messaging Network Support and Phone Support Desktop Support