SUMMARY:

• Over sixteen years of software development, testing, and support following the SDLC.
• Two years of experience at PROS, Price Optimizer
• Legacy system integration.
• Approval workflow, Security/Privileges, Price Methods, Fixed Defects
• Custom Dashboards
• : PROS Pricing Solution Suite - Scientific Analytics Configuration Basics.
• Proficient at PL/SQL, SQL queries, stored procedures, functions, packages, exception handlers, synonyms, triggers, cursors, and pl/sql tables under Oracle 8i, Oracle 9i, and Oracle 10g.
• Experience with creating Oracle tables, partitioned tables, views, indexes, partitioned indexes, synonyms, constraints, sequences, and database links.
• Extensive experience at writing scripts in PERL and KORN Shell under Unix for scheduling stored procedure executing, adhoc SQL queries, and processing of corrupted EDI files.
• Consistent use of TOAD for Oracle database analysis, stored procedure updates, and performance tuning.
• SFTP for automated or manual transfer of files.
• Performance tuning of SQL queries and stored procedures by adding indexes where needed, using explain plan to identify the bottlenecks, adding Oracle Hints where needed, and breaking up an SQL via temp tables.
• Experience using Oracle data migration utilities such as SQL*Loader, datapump, impdp, expdp.
• Assisted in database administration of remote servers during implementations and to troubleshoot support issues. This would consist of lists of alter table commands, new synonyms, stored procedure updates, creation of new table and index partitions, and adjusting table-space sizes for what is needed.
• ETL tools, Informatica, Business Objects
• Assisted Informatica team in development and troubleshooting of interfaces between SAP, JDA/Manugistics and Red Prairie.
• Supply chain processes and solutions as it pertains to logistics (TMS, WMS, OMS, SAP).
• Expertise in data modeling and data mining of large data sets up to 950 million rows.
• Business intelligence, data warehousing, and extensive reporting experience.
• Systems integration for complex software architecture topologies.
• Managed communications with multiple remote teams for support and development.
• Proficient at C++ coding, under Microsoft Visual C++ with MFC. Redesigned simple dialogs and complex applications. Implemented a matrix class and integral calculus algorithms with extensive performance tuning. Created heuristic C++ algorithms for analysis of DNA data from a lab.
• MS in Physics. BS in Computer Science and Biology. Experience in Bioinformatics, and theoretical physics.
• Easily learn new information systems and programming skills. Actively involved in programming since 1983.

TECHNICAL SKILLS:

Languages: PL/SQL (12), ksh(14), C (8), C++ (8), csh(14), Pro*C/C++(4), Perl(10), VB(6)Javascript (5), VBScript (5), ASP (5), CSP (4), Java (1), Assembler (4), Pascal (2), Fortran (4), COBOL (1), JCL (1), ASP.NET (1), C# (2)

Operating Systems: Windows 7/XP/NT/98/95, Linux, Unix(Solaris/AIX/HP), DOS, Unicos, MacOS

User interfaces: Window, MFC, X-windows, Motif, Xt lntrinsics, OpenLook

Databases: Oracle 11g, Oracle 10g, Oracle 9.2, Oracle 8.1.7, SQL Server, RedBrick, SyBaseOLAP cubes, dimension, dashboards and measures.

Misc Software: Visual Studio 8.0, Visual C++ 8.0, Visual Studio .NET and v 6.0,Crystal Enterprise 8.0 / 8.5 / 10, MicroCal Origin, 3d Studio MaxSupply Chain:SAP-BW, SAP-EDI, SAP-OMS, JDA /Manugistics, McHugh, Red Prairie,PROS 3.13.4, PROS 3.8.8

Other: Informatica, Install Shield, OCX, ActiveX, ATL, STL, COM, DCOM, Toad, PVCS, Source Safe, MS PowerPoint, Microsoft Word, Microsoft Excel, Microsoft Access, Business Objects

WORK EXPERIENCE:

Confidential, Chicago, IL

Sr. Consultant

Responsibilities:

• Leading a small team of consultants for implementation for retail clients.
• Setting up complex Perl modules that use XML to store settings and a sequence of execution.
• Processing and cleaning up of hierarchical data via perl from SAP to transportation system.
• Database access via Perl for execution of packages and procedure and retrieval of results into variables.
• Responsible for the Perl based integration modules with applications, deployment, release management, performance tuning of the Oracle based applications.
• Co-ordination of project tasks and deliverables for the progress of the project. Working with SMEs from China, Asia-Pacific and support teams.
• Worked on Oracle based product for packages, procedures, triggers and data integration.
• Worked with User reports on the frontend to provide analytics reports to business users.
• Implemented several performance improvement measures for DEV, QA and PROD environments for the applications.
• Worked with DBA teams to co-ordinate database migrations, upgrades, patches.
• Designed and implemented Control-M based schedules for QA and PROD environments.
• Responsible for the performance of the Oracle based databases.
• Redesigned tables for better performance using de-normalization, Partitions, indexes, hints, parallelism, AWR reports, block sizes, buffer and cache pools, StatsPack.
• Developed modules to load data from flat files into tables using Java, Spring Batch and hibernate mapping.

Environment: Oracle 11g/10g, HP-UX 11, Linux, SQL, PL/SQL, Perl5, Shell Scripts, Toad 10, SQLDeveloper, Control-M 7, Putty, SVN, MS Windows 7, Jira, MS Sharepoint.

Confidential, Rosemont, IL

Senior Analyst / Developer

Responsibilities:

• Oracle 10g which was used to store Dimension information and Sales and Procurement fact data.
• Toad 9.0.1 to access the oracle databases for DEV, QA, and Production.
• UltraEdit-32 Version 12.20+4 used for editing large XML files and files compares.
• Remote desktop to maintain the remote PROS application servers.
• Developed SQL queries to help align Procurement data with the equivalent data in the source legacy database.
• Helped in troubleshooting Unix Korn Shell scripts called by Control-M. These scripts were used to run the weekend processing of data.
• Participated in the implementation of PROS software (Phase 2 - Price Optimizer) project. It involved the implementation of the Price Optimizer module for PROS and performance improvements to stored procedures.
• Assisted with technical requirements documentations after requirement gathering and analysis. Fine details were drawn out in meetings with the software vendor and meetings with business users.
• Extensive use of PL/SQL, SQL queries, stored procedures, functions, packages, exception handlers, synonyms, triggers, cursors, Pro*C and pl/sql tables under Oracle 10g as ETL process.
• Used Oracle data migration utilities such as SQL*Loader, datapump, impdp, expdp.
• Created Oracle tables, partitioned tables, views, indexes, partitioned indexes, synonyms, constraints, and sequences.
• Created C++ application using Visual C++ 8.0 to import data into Oracle. We received the data in many different formats. Simple heuristic algorithms were used to resolve the inconsistent data formats.
• Completely re - designed how sales fact table aggregations were performed. This to take into account as many possible queries that the PROS 3.8.8 application may request without their Mondrian engine hitting the fact tables. The initial aggregate was partitioned by week and then all other aggregates were based on it. Updates to dimension data were performed on the initial aggregate by looping through each partition in turn. Stored procedures processed the aggregates on the weekends.
• Created stored procedures to process custom aggregations used by the business users to evaluate the proper way to price products. It required extensive use of temporary tables to help improve performance.
• Wrote Perl scripts to execute stored procedure on the weekend with email feedback on status.
• Provided weekend support for the production environment ensuring that processing of new data aggregates completes and troubleshooting any problems that may arise.
• Assisted in database administration of remote servers during implementations and to troubleshoot support issues. This would consist of lists of alter table commands, new synonyms, stored procedure updates, creation of new table and index partition, and adjusting tablespace sizes for what is needed.
• Completed documentation of weekend job support information including job flow, run times, and possible solutions.
• Created stored procedures and Unix scripts required to add new pricing strategies to the PROS 3.13.4 Price Optimizer module.
• Extensive testing in our DEV and QA environments for faster deployment of the newer version of the application. Test plans documents created as testing proceeded.
• SDLC followed throughout all phases with DEV, QA, and Production environments in place.
• PROS Pricing Solution Suite - Scientific Analytics Configuration Basics. Which covers setting up OLAP information in XML files for design of Dashboards.

Confidential, Bannockburn, IL

Senior Analyst Applications Development

Responsibilities:

• Participated in the EPPM Project. This stands for Enterprise Project Portfolio Management. It consisted of migrating resource and project information from two different project management software packages to the CA (Niku) Clarity project management web based tools.
• Visual Studio .NET 2005 C#, C++.
• Aqua Data Studio v4.7.2 to access the remote Oracle Clarity database.
• Oracle to access the underlying data tables within Clarity
• SQL Server to Heat and Planview tables
• Access 2003 SP2 in Parte extract
• XMLSpy to analyze the validity of the XML data generated.
• UltraEdit v9.0 to sort the final XML file correctly.
• Several data interfaces were created to facilitate the near real time transfer of requests from Heat. This resulted in the creation of Incidents in Clarity along with assignment and status updates to these Incidents from either end. C++ was used for the interface. Analyzed COBOL code to retrieve logic for default values when transferring data from Heat to Clarity.
• Convert 1400 resources from Planview and Parte to resources in Clarity. Downloaded entire LDAP directory to extract user information that matches new Clarity resources. Extensive name matching on data between these three systems and PeopleSoft.
• Analyzed the data structures and table of projects and resources in a Planview project management database. Mapped how these data items relate to the data attributes within Clarity. The method of transfer of data into Clarity is XML via Clarity’s XML Open Gateway or XOG. A combination of SQL queries and Microsoft Visual Studio .NET were used to generate the XML files required to transfer data to Clarity. The data was hierarchical and required an SQL with 11 self joins to format the data for XML output. 706 Planview projects were converted to Clarity projects.
• Similar analysis was required for the Parte. This was a home grown project management database. Many custom attributes were required for Clarity to absorb these projects as well. There was a total of 4919 project convert to Clarity.
• Analyzed Lotus Notes scripts for old Work Request system to determine how to communicate between it and Clarity for creation of Incidents. Later I advised that it would be better to replace this system with Incidents that is built in to Clarity.
• Converted 409 project to Clarity for their 2007 Plan from an Access database call Cupid.

Confidential, Deerfield, IL

Senior Systems Engineer

Responsibilities:

• Updated 22 stored procedures to handle the new table layouts in Oracle 9.2.Updated 7 more stored procedures to handle character-set issues between a WMS system, Red Prairie and Manugistics.
• Wrote custom perl scripts with a ksh wrapper to load accrual and allocation flat files into Oracle tables for the purpose of comparing the data accuracies before and after input to a Walker system from Manugistics.
• Updated perl and ksh scripts that executed jobs and distributed data to other systems.
• On call for production support. This includes failed jobs, incorrect data, missing shipments or orders.
• Part of the transition team to transfer their Schaumberg office to Omaha.
• Taking in requests through Clarify to fix problems with data translation in Informatica and coordinating with the coders to develop an appropriate solution. These Informatica interfaces translate data between SAP, Red Prairie, Manugistics, and other system.
• Writing Perl scripts or Pro*C++ programs to extract data that we need from multiple historical flat files. Sometimes for analysis and other times so that the correct extracted record blocks can be modified and reprocessed.
• Creating custom Oracle PL/SQL stored procedures that query the underlying tables in Manugistics and/or Red Prairie. Up to as many as 42 temporary tables were needed within the stored procedures in order to keep total processing time to a minimum for complicated queries. The front end to this is a Crystal Report, using version 8.5 and now 9.0. These are published to the Crystal Enterprise server. Approximately 25% of the reports have sub-reports as well.
• Extensive use of PL/SQL, SQL queries, stored procedures, functions, packages, exception handlers, synonyms, triggers, and cursors under Oracle 9i.
• Created Oracle tables, views, indexes, synonyms, constraints, sequences, and database links.
• Assisted in database administration of remote servers during implementations and to troubleshoot support issues. This would consist of lists of alter table commands, new synonyms, stored procedure updates, creation of new indexes, and adjusting tablespace sizes for what is needed.
• Designing ASP, CSP, and Javascript pages to override the default page setup in Crystal Enterprise 8.0 / 8.5 / 9.0 for ConAgra. Including parameter screen replacement and instance viewer. Data was accessed from an Oracle 8.1.7 test database that I managed.

Confidential, Chicago, IL

Researcher

Responsibilities:

• Research towards master degree in collaboration with Professor Dirk K. Morr.
• Research on defects and impurities in strongly correlated electron systems, such as s-wave and d-wave superconductors. Calculation of Green’s functions and Density of States. Used Visual C++ for all calculations.
• Visual Studio .NET used to advance programs with GUI interface.

Confidential, Sunnyvale, California

Software Engineer

Responsibilities:

• HYSEQ, a biotech firm, acquired the core group from Argonne’s (see below) human genome project.
• Added 10,000 lines of C code to previous data analysis software package (SCORES).
• Created 15,000-line data analysis package (SUPERCHIP) for a process technology currently being developed.
• 50-100 lines of C code are added to these programs daily.
• Set up network of Sun Microsystems Spare 20 workstations using Solaris 2.x.
• Installed operating system patches. Gcc, X-windows, Motif, DNS, E-mail, accounts, groups, specialized account initialization files, etc.
• Attached five external hard drives to server and created directory structure.
• Fixed memory and hard drive problems of the server.
• Configured my home office computer to run Linux and communicate via ISDN.

Confidential, Argonne, IL

Computer Programmer

Responsibilities:

• Created software in C for the reconstruction of DNA sequences from oligomer hybridization data. The software analyzed, charted, and graphed the data in order to evaluate the success of experiments and searched for similarities to known sequences in the Genbank database. Custom database created for storage of analyzed data. Edited and debugged on Solaris based Sun Microsystems machines
• User interface using X-windows and Motif
• Largest package (SCORES) is 10,000 lines long with 50 lines added daily
• System administration functions:
• Compiled and installed Gcc, X-windows, Motif, etc.
• Located and corrected causes of system crashes
• Set up LAN using 3Com EtherLink II cards and PC-NFS software