SKILLS PROFILE

• Strong Project Management Skills. Have led numerous projects from inception to installation
• Strong Business Analyst Skill. Have spent over 20 years in a client facing position.
• Strong Data Analysis and Data Validation skills.
• Strong experience in Data base design, Data normalization, data integrity, and data conversion.
• Many years' experience with data migration, ETL processes using Informatica as well as other ETL tools.
• Strong Finance background. Well versed in Accounting philosophy including GL, AP, and AR.
• Strong health care background, working on and implementing claims system for a major health care company.
• Strong knowledge of the SDLC and PDLC as well as project management.
• Strong communication skills. Get along well with everyone. Able to handle highly stressful situations.
• Many years of experience with testing, use cases, and system support
• Able to learn new applications and processes quickly.
• Very strong SQL Server skills. Have written hundreds of reports using SSRS and have used SSIS for numerous file conversions from other platforms including Oracle and the Mainframe.
• SQL Server 2005, 2008, and 2012, SSIS, and SSRS. Stored procedures, scripts,
• Very strong SQL skills, strong T-SQL.
• Strong MS-Office skills. Very familiar with MS-Word, Excel, MS-Project, MS-Access, and MS-Visio
• Cognos Impromptu for data warehouse reporting. Very experienced writing queries and supporting clients
• Microstrategy Several years experience in writing queries and supporting client requests.
• PeopleSoft, PeopleCode, as well as SQR and Crystal Reports in support of HR and Payroll applications
• Mainframe, DB2, CICS, VSAM, IMS, UNIX, COBOL, Xpediter, Intertest, BMC tools, Platinum tools, Oracle, JCL Check, DFSort, SyncSort, MQSeries,File-Aid, Dyl280, SAS, Easytrieve, Stored Procedures, MQ Series, IBM utilities such as IEBGENER, IEBCOPY, IEFBR14, and IDCAMS.
• Strong RACF skills. Able to maintain system security
• Functioned as a DBA in the past
• Functioned as RACF administrator
• HTML, JavaScript, Java, and other web applications such as NET.DATA.
• Beginning level ASP.NET and .NET skills

EMPLOYMENT HISTORY

Confidential Perform as a Business/Data Analyst.

• Setting up a Data Warehouse for Television Distribution consisting of data from several sources and several platforms
• Instrumental in the data base design and structure. Provided documentation and direct input into the Data Warehouse design and implementation.
• One feeding system is a legacy AS400 system that used DB2, that contains Royalty, Subledger, Contract, and Deal information.
• Another is a Automated Royalty Upload management system that runs on a SQL Server platform. This system allows the various TV and Movie content providers such as Hulu, to package their review data into an Excel format that is then converted using SSIS to a format that the clients and manipulate and post into the above legacy system.
• Another is the product master system that contains all of the Deal and Product information . This system runs on a windows GUI front end and a SQL Server back end. Developed and designed the data structure used to process data from this system into the TV Data Warehouse.
• Another input to the Data Warehouse is a cloud based system that uses Sales Force. This system contains budgeted information which is then brought into the TV Data Warehouse.
• The TV Data Warehouse lays on a Teradata database. This allows for millions of rows of data and easy access.
• The front end reporting tool used is MicroStategy. We have developed numerous canned reports for the clients as well as many that allow for the clients to pick and choose which attributes they want and which filters they would like.
• Have created numerous ETL processes from one of the feeder systems to send data to our Data Warehouse.
• Have worked extensively writing SQL in the various environments to populate data, clean up data, and to validate that data sent is data received.

Consultant Business Analyst Confidential

• In the initial phase of documenting the existing Legacy system, Tigres, that encompasses parts of Residuals, Participations, Air Dates, Accounts Receivable, billing, and General Ledger. The system also receives and sends data to the SAP systems as Sony
• Once documented, then will work on putting together a migration plan to move off of the current platform to an as yet to be named platform.
• As part of the migration will also be determining which data needs to be kept and converted to either the new application or to some type of reporting system such as SSRS.

Consultant Business Analyst Technical Lead Confidential

• Performed as the Business Analyst/Tech Lead on the conversion of data from the mainframe to SQL Server using SSIS and wrote numerous reports and queries to allow the clients to access the legacy data using SSRS and wrote hundreds of complex reports using SSRS.
• Converted Data from Oracle to SQL Server using SSIS and wrote hundreds of complex reports using SSRS
• Assisted with Residuals conversion to Paris, which is an ASP.Net application.
• Supported the GL and AP systems on a mainframe platform which use DB2, CICS, and VSAM.
• Used Xpediter, Intertest, File-Aid, BMC catalog manager, and Platinum.
• Support the Cognos Impromptu data warehouse system.
• Wrote hundreds of queries in Impromptu and supported client requests.
• Installed and supported the ODBC connections for all version of Cognos Impromptu
• Supported Microstrategy for the data warehouse.
• Wrote hundreds of queries in Microstrategy and supported client requests.
• Converted numerous queries from Cognos Impromptu tto Microstrategy
• Created queries against a variety of relational databases including Oracle, SQL Server, DB2, and Sybase. Very familiar with T-SQL and have used PL/SQL.
• Developed user training and use cases for the newly migrated data
• Taught numerous training classes for the clients to familiarize them with the new applications
• Performed as a DBA as there is no on site DBA for the mainframe.
• Performed as the RACF administrator as there was no RACF support
• Technical lead, assigning work, gathering requirements from the client.
• Key IT resource in designing and developing the migration of the above systems to SAP.
• Made several key enhancements including adding multiple currency functions to the GL system and adding logic to all the clients to control inter-company logic within a journal.

Senior Application Developer/Project Lead/Business Analyst Confidential

• Performed as the project manager for the conversion of the legacy timekeeping system to the vendor selected package.
• Gathered requirements, met with clients, proposed new platform choices, reviewed several of those options with the clients. And finally led the effect to convert the existing system to the new platform
• Supported the Payroll and timekeeping systems
• Payroll system was COBOL, CICS, and DB2.
• Supported the A/R system. In house system that invoice Accounts Receivable.
• Timekeeping system was HTML, JavaScript, Java, and SQL Server.
• Supported conversion to the new Kronos timekeeping system.
• Ran numerous queries against SQL Server and Oracle tables. Created numerous reports for the clients.
• Wrote numerous reports using Crystal Reports. Very experienced with Crystal Reports
• Made numerous enhancements and provided general support for both systems.

Senior Application Developer/Project Lead/Manager Confidential

• Project Manager/Business Analyst for the Web interface to both the payroll and HR systems.
• Met with the clients to gather requirements. Documented those requirements and then led the project to develop an in house solution to communicate with both systems thru a WEB application.
• Manager for the Payroll and HR systems as well as their related offshoots.
• HR system was in PeopleSoft, made numerous customizations. Lead a team in the upgrade from 4.0 to 7.0 and lead the team in support of the upgrade from 7.0 to 8.03. Very familiar with PeopleCode and PeopleTools.
• Payroll system consisted of a mainframe portion which was CICS, COBOL and DB2, and the web application used DB2 Stored Procedures, Java, JavaScript, and Net. Data.
• Used MQ Series for data transfer and manipulation from one platform to another.
• Used PGP encryption to secure data transfers to the various unions and Federal Government.
• Created and supported the LDAP / Single Sign-on application that used SQL Server and Java as well as HTML and JavaScript.
• Assigned work, wrote reviews and managed 5 people in addition to performing the technical duties listed above.

Consultant/Business Analyst/TechLead Confidential

• Gathered requirements and wrote requirements documents for client sign-off as well as wrote technical specifications for developers to code modifications to the existing systems to make them Y2K compliant.
• Lead developer in the conversion of GL system from non Y2K compliant system to Y2K compliant. Included numerous customizations as well as installing and running multi-mill.
• Led a staff of 10 developers for the above conversion. Assigned work, tracked progress, tracked costs and reported status to upper management in both IT and on the client side.
• Supported the conversion of GL and AP systems from non Y2K compliant version to Y2K compliant.
• Technical lead for the implementation of latest GL system.

Consultant/Technical Lead Confidential

• Implemented the individual and small group version of the claims system . System was coded in IMS using conversational IMS.
• Met will clients, gathered requirements and implemented changes to the system
• Technical lead for several other applications using my knowledge of DB2 to assist in the implementation of the small group and individual membership system

Senior Programmer/Tech Lead Confidential

• Performed the conversion of the Facilities Management system to Oracle using Oracle Loader.
• Converted millions of rows of data for the above project so that the problem and change reporting system could use as reference. An IBM system, INFOMAN.
• Supported version updates to INFOMAN and database conversions.
• Supported the Sales Order systems. Using CICS, IMS, COBOL and DB2. Main tech lead for all assignments.
• Created numerous adhoc reports using SAS and FOCUS.
• Supported the AP and GL systems.
• Strong QMF, DB2, VSAM, and IMS usage.

Manager Production Control Confidential

• Started as a computer operator, promoted over 2 years to Grave Shift supervisor
• Promoted to Production Control Manager
• Managed a staff of 3 shift supervisors and 15 employees.
• Managed all change control and job scheduling functions for Mattel Toys, using CA-7, CA-1, and Panvalet