EXPERIENCE

08/2012 to present – Confidential,Sr Cognos Developer
Responsibilities include creating complex Cognos reports from gathered requirements from customer. Assigned to create Framework Manager models and customized views to publish to the Cognos Portal. Create Star Team attachments for code tracking and future enhancements. Assigned to view and develop web front end applications and create reports based on legacy systems. Create technical documents for upload to Sharepoint. Detail information for peer reviews and code reports according to specifications.

Environment: Cognos 8.4, Framework Manager ver 8.4, Teredata and SQL Assistant ver 13.11, WinSCP/Putty ver 4.3.9 (Build 1817), MS Office (Access, Excel, PowerPoint, Word, Visio, Project, Outlook)
08/2011 to 07/2012 – Confidential,Sr Analyst – Software Engineering (Applications)
Assigned to create Cognos reports generated via the Deltek Costpoint Aplication. Primary responsibilities include gathering user requirements, designing, developing, and creating Cognos reports based on those requirements. Solely responsible for deployment and migration of the reports from the development environment to the Production environment to the Cognos portal and performing User Acceptance Testing and Visual Verification Testing. Assist users with password resets from various systems. Duties include creating ad-hoc reports for the Accounting, Tax, Payroll and HR Depts as needed. Responsible for overall maintenance of the Cognos Application in the development environment. Perform user roles and maintain groups in CRM Financial Application.
Environment: Cognos 8 (DPM) and upgrade to CER, Framework Manager ver 8.4, TOAD 10.6.1.3, Deltek Costpoint, ver 6.1, MS Office (Access, Excel, PowerPoint, Word, Visio), Lotus Notes, Change Management System
06/2010 to 08/2011 – Confidential,Senior Report Developer
Primary responsibilities include designing, developing, and creating Cognos reports based on requirements. Assigned to create SQL code and analyze data from database using TOAD. Responsible to view code for development and deploying and publishing reports via the PeopleSoft Web Application Servers and Framework Manager application to BI portal. Responsible for upgrade from 8.1 to 8.4 and 10. Impact analysis on current and existing legacy reports for the upgrade. Report and portal development include, but not limited to Dashboarding, Metric Manager, complex Drill-Thru reports, Financial and historical cubes, utilizing Query, Report, and Analysis Studio. Duties also include creating views, modifying columns using TOAD and modifying Crystal Reports using ver 10. Ensuring quality via MS Visual Source Safe. Utilize Oracle SQL developer to view and manipulate code and create views and stored procedures. Responsible for writing code on UNIX box (SSH Secure File Transfer tool) in UNIX and view SQR developed in PS. Creating batch processes and ETLs. Using Application Designer to view and manipulate PS tables (vanilla and customized). Create Functional, Technical Requirements, Business Specification requirements, Test Scripts and perform Test cases.
Environment: Cognos 8, Framework Manager ver 8.4, Oracle ver 10g & 11g, TOAD 8.5.3.2, Oracle SQL Developer, 2.1.1.64 (Build Main-64.45), Oracle SQL Plus 9.2.0.1.0, App Designer (PeopleTools 8.48.07), Axure 6.0, Crystal reports v10, Crimson Editor 3.70, SSH Secure File Transfer 3.2.2 (Build 269)
10/09 to 06/2010 – Confidential,Senior Cognos/MS SQL DBA Developer
Assigned to design, develop, and create complex Cognos reports mirroring existing Microsoft Visual Studio reports. Maintain database structures by adding tables, views, and stored procedures in a PeopleSoft environment. Extensive SQL code writing to create reports. Responsible for maintaining Management Console and maintaining change reporting and requests following IT Service Management principles. Assigned to organize, delete, and create tables and datasources using database schema. Load, view, and Query data using MS SQL Server Management to analyze and view code for deploying and publishing reports via the Web Application Servers and Framework Manager application to BI portal.
Environment: Microsoft Visual Studio 2008, ver 9.0.3, Microsoft .Net Framework ver 3.5, Microsoft SQL Server Management Studio ver 10, Framework Manager, Cognos ver 8, Powerplay MS Analysis Services Client Tools, MS Data Access Components (MDAC), MS MSXML ver 2.6.3

04/09 to 10/09 – Confidential,Senior Cognos Data Manager Developer
Responsible for design, develop and create Cognos Reports via Transformer and publishing to Cognos Connection using Framework Manager. Assigned to interface reports with internal PeopleSoft application and tracking system. Load, view, and Query data using TOAD and Ascential to map corresponding fields for ETL loads for IMPACT database and usage for GIS Mapping for DEA Agents. The use of Framework Manager to create datasources from SQL sources and import to Cognos Transformer. Extract configuration verification data to publish and run in various reporting tools.
Environment: Windows Server 2003 Enterprise Edition, Visual Basic,.net capabilities, Cognos ver 8, Framework Manager, Cognos PowerPlay, Oracle 10g, IBM Rational and Clearquest Advanced Query Tool MS Access & Excel, Cognos Transformer, Framework Manager, Ascential, TOAD
12/07 to 04/09 – Confidential,EPM Cognos and PeopleSoft Applications and Data Manager Developer
Primary responsibilities included design and maintain the infrastructure of Cognos and creating reports, design, development, and testing of Cognos Connection within the PeopleSoft application and perform upgrade from Cognos v 8 to 8.1. The use of Framework Manager to create IQDs and import to Cognos Transformer as well as publishing report to Cognos Connection. Extract data to publish and run in various reporting tools. Published various Cognos and Actuate reports to BI portals and PeopleSoft portal pages. Responsible for structuring data in PeopleSoft application using various schema (HRMS, EPM, etc). Also assigned to create and maintain ETL within Ascential and datamart using PeopleSoft HCM, Financials as it relates to Global Payroll and benefits using App Designer. Maintained processes for entering financial data and creating change reporting based on ITIL requirements for capturing, recording and maintaining product configuration information to ensure that current and historical configuration information can be accurately determined through the product life cycle and GIS Mapping for Participation Reports (AR & NG). Assigned to, Actuate, and XML Publisher from SQL tables on the DIMHRS project. Monitor data loads through the EPM database, create schema to load tables. Created CSRs for migration via STAT technology.
Environment: Windows Server 2003 Enterprise Edition, Citrix, PeopleSoft 8, Visual Basic,.net capabilities, Cognos ver 8, Framework Manager, Cognos PowerPlay, Actuate ver 8, SQL Query Analyzer version 8, Aqua Studio, Ultra Edit-32, WincSCP, IBM Clear Quest, Advanced Query Tool MS Access & Excel, Microsoft SQL Server 2005, Cognos Transformer, Framework Manager, Right Now, STAT (Quest Software ver 5.4.2), DB2, Ascential. Serena ChangeMan, Remedy
4/07 to 11/07 – Confidential,Informatica & SQL Data Manager Developer
Assigned to map financial data using Informatica encompassing over 500 fields names from one banking institution to another. Produced financial and statistical data to effectively monitor business processes. Developed process schedules and security measures for customer data elements utilizing ITIL technologies. Created reports based on the data found to submit to various departments for current and future analysis. Report designed and developed in MS SQL (2005).
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic,.net capabilities, Crystal 6, Informatica, PeopleSoft, Actuate ver 6, Siebel ver 7.5, SQL Query Analyzer version 8, MS Access & Excel, Microsoft SQL Server 2000 and 2005
1/07 to 3/07 – Confidential,Actuate & SQL Data Manager Developer
Responsible for creating Actuate and Crystal Reports from SQL tables.. Published various Crystal and Actuate reports to PeopleSoft portals and maintaining business objects.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic,.net capabilities, Crystal 6, PeopleSoft, Actuate ver 6, Siebel ver 7.5, SQL Query Analyzer version 8, MS Access & Excel, Microsoft SQL Server 2000 and 2005
11/06 to 1/07– Confidential,Crystal and Actuate Developer
Responsible for creating Actuate and Crystal Reports from SQL tables. Siebel development using Siebel Tools and creating Actuate reports and extensive use of Siebel Analytics. Published various Crystal and Actuate reports to portals.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic,.net capabilities, Crystal 6, Actuate ver 6, Siebel ver 7.5, SQL Query Analyzer version 8, MS Access & Excel, Microsoft SQL Server 2000 and 2005
10/06 to 11/06 – Confidential,Cognos Developer
Assigned to convert reports created in Crystal Reports to Cognos Reports. Designed and created front end dashboard for user as they entered the Cognos Connection BI Portal. Framework Manager models used to create and maintain data modeling. Extensive use of SQL and Oracle technologies to extract data for reports.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic,.net capabilities, Crystal 6, Cognos ver 7, Framework Manager, SQL Query Analyzer version 8, MS Access & Excel, Microsoft SQL Server 2000 and 2005
07/06 – 09/06 – Confidential,Cognos Developer and Trainer
Duties include training users in Cognos 8 and Reportnet for users currently familiar and working with Cognos Powerplay and other company supported reporting tools (Crystal and Actuate). Worked collaboratively with team members as a resource for converting current PowerPlay, Crystal, and Actuate reports to Cognos Reports using Query, Report, and Analysis Studio reports. Created multi-dimensional cubes to use for Analysis Studio reports for power users and published reports via Framework Manager to be view in the BI portal. Extensive use of SQL and creating reports from base tables.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic, Cognos PowerPlay version 7.3, PowerPlay Transformer (Windows) version 7.3, Cognos ver 8 (Report.net), .net capabilities, Framework Manager, Crystal 6, Actuate ver 6, SQL Query Analyzer version 8, Report Studio, Query Studio, Report.net, MS Access & Excel, Microsoft SQL Server
9/05 to 7/06 - Confidential,Cognos/SQL Developer
Responsible for creating multi-dimensional cubes linking to the SQL database using PowerPlay and Transformer and publishing cubes to Cognos Connection via set up in Cognos Configuration and Powerplay Enterprise Server to read in Report, Query, and Analysis Studio with (Report).net technologies. Duties include writing complex queries from base tables and SQL using SQL Server Enterprise Manager and Query Analyzer to extract data. Maintained Framework Manager models used to view report via the BI Portal.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic, UNIX, Cognos PowerPlay version 7.3, PowerPlay Transformer (Windows) version 7.3, Framework Manager, SQL Query Analyzer version 8, Report Studio, Query Studio, Analysis Studio, Report.net, MS Access & Excel, Microsoft SQL Server
02/05– 04/05 Confidential,Senior SQL Developer
Assigned to write, develop, and create SQL tables, views, stored procedures, and link multiple servers using DTS packages. Via SQL, created MS Access and MS Excel databases to link data and channel data sources within application. Insured proper connectivity through ODBC/DSN and created and documented complex SQL queries developed.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic, Oracle, SQL Query Analyzer version 8, MS Access & Excel, Microsoft SQL Server
09/04– 01/05 Confidential,Senior Applications Database Analyst (Lawson Financial/Payroll)
Duties include reporting and responsible for the day-to-day coordination, implementation, and maintenance of the Lawson HR/Payroll system, API Time and Attendance system and applicant tracking system in a retail store environment. Responsible for supporting other team members institutional and departmental initiatives. Works collaboratively with system users and serves as a technical resource for converting old Crystal and Actuate reports to Lawson reports. Participate in the design, development, implementation, evaluation and maintenance of new and legacy systems. Extensive use of OLAP, writing and reviewing SQL code, to creating multi-dimensional data cubes, reviewing data set and data modeling. Extensive use of statistical software packages, Lawson Financial and Payroll systems and an extensive use of MS Access, by building complex reports and importing data and designing tables. Also utilizing MS Excel to review data and importing data and creating Pivot tables to create graphs and extensive use of formulas within Excel.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Lawson 7.3.3.0, Crystal ver 6, Actuate ver 5 (e.Reporting), Visual Basic, (Windows) version 7, SQL Query Analyzer version 8, MS Access & Excel, Microsoft SQL Server
05/04– 10/04 Confidential,Senior Cognos Database Analyst
Responsibilities include reporting and trending of client’s business, such as, sales, market penetration, customer cancellation and lead flow. Duties also include, working closely with the account service team to compile analytical information as it relates to retention, reinstatement, revenue, payment cycles, etc. Extensive use of Cognos OLAP, writing and reviewing SQL code, to creating multi-dimensional data cubes, reviewing data set and data modeling, leading and managing the development of a comprehensive marketing and sales database at the market/DMA level. Extensive use of statistical software packages, SPSS and SAS, and extensive use of MS Access and Crystal and Actuate Reporting, by building complex reports and importing data and designing tables. Also utilizing MS Excel to review data and importing data and creating Pivot tables to create graphs and extensive use of formulas within Excel.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Visual Basic, Oracle, Cognos PowerPlay version 7, PowerPlay Transformer (Windows) version 7, Crystal Reports ver 8.5, Actuate ver 6, SQL Query Analyzer version 8, MS Access & Excel, Microsoft SQL Server
10/03– 04/04 Confidential,Siebel & Actuate Report Writer/Dev & Configurator
Assigned to maintain and develop from the Siebel 6.3 and migrating to the 7.5 and Siebel Analytics applications, designing and modifying screens, views, and applets, in a multi-tier environment. Duties also include installing and developing complex Actuate report via ver 4.1.0 and generating Actuate reports from Siebel Tools and conversion from Lawson database and Crystal Reports. Develop, configure, implement, and maintain functionality of the Siebel application. Data included synchronization, database management, encompassing technologies such as MS Excel to import into application associated with the CRM Practice, Service, Field Sales/Service, Help Desk, Sales Force Automation, Workflow and Assignment Manager. Maintain functional and technical design documents and tracking via TeamTrack for unit testing. Utilize MS Access to maintain and develop Siebel Quote Reports populated from the Siebel application with extensive Visual Basic, C++, and JAVA programming to ensure proper linkage to various reports containing tables and forms. Consistently executed the Enterprise Intergration Manager (EIM) mechanism to properly demonstrate connectivity to remote users and real-time response. Assigned to create *.srf files for changes made through Siebel Tools.
Environment: Windows 2000 Professional, Microsoft Windows NT Service Pack 6, Actuate e.Reporting & Workbench version 4.1.0, Actuate Basic, Lawson (Healthcare), Crystal Reports ver 8, Visual Basic, Oracle, Siebel 6.3 & 7, Siebel Tools, Siebel Analytics, TeamTrack 5.61 (Build 56103), MS Access & Excel, Microsoft SQL Server
01/03 – 10/03 Confidential,Senior Software Certification Analyst
Duties included gathering user requirements and preparing functional specifications; developing and consolidating test cases for user acceptance testing and validation. Assigned to design, implement, and document software certification processes for domestic and international billing and remittance for system changes. Documented and revised test scripts and data matrices for research and training purposes and project management utilizing MS Project and creating reports from MS Excel, importing and exporting data. Documented and reported user acceptance test results for software certification. Assisted in identifying service enhancements and cost reduction opportunities in an AS/400 mainframe environment. Involved in the development and maintenance of Web interfacing database for resource management using MS Front Page for ASP enhancements with extensive use of Visual Basic, C++, and Java scripting to populate date on Web pages. Utilized SQL Navigator and Word for queries via based tables using TOAD. Participates in the total design of global software certification processes. Assisted with project planning and performance reporting. Assisted in systems solutions implementation, as directed. Supported user acceptance testing and reporting.
Environment: Windows XP/NT4, Oracle 8, Oracle Designer2000, Oracle Developer2000 (Forms 5.0, Reports 3.0), Forms 3.0, MS Visio, Visual Basic, TOAD, SQL-Navigator, SQL Word, Reflection for IBM mainframe, MS Front Page
09/02– 12/02 Confidential,Siebel & Actuate Report Writer/Dev & Configurator
Duties included maintanence and development of the Siebel 6.3 and migrating to the 7.5 applications, designing and modifying screens, views, and applets, in a multi-tier environment. Assigned to install and develop complex Actuate report via ver 5 upgrading to 6 in an Oracle environment from Crystal Reports ver 6. Also assigned to create base table queries for reports via ISQL55 and develop and populate information through ASP using Visual Basic and Java Script. Creating SQL documents to execute queries for reports. Web Development and front-end architecture to ensure proper linkage to Siebel application using EIM, CTI, EAI, eScripting, and TCP/IP technologies. Responsible for reviewing code and manipulating data to populate the appropriate fields for the ASP. Develop and maintain functional and technical design for unit testing. Duties include writing unit scripts for test deployment. Assigned to create *.srf files for changes made through Siebel Tools.
Environment: Windows 95/NT4, Oracle 8, Unix, Oracle Designer2000, Oracle Developer2000 (Forms 5.0, Reports 3.0), Forms 3.0, Actuate e.Reporting & Workbench version 5 & 6, Actuate Basic, Crystal Report ver 6, Visual Basic, Siebel 6.3 & 7, Siebel Tools, SQL Tools, SQL Word
06/01 – 08/02 Confidential,Senior Actuate Report Writer/Dev & Configurator
Assigned to install and implement the Actuate e.Reporting Suite 5 in an Oracle environment and on a UNIX platform. Compile business requirements for generating reports via Web interfacing, TCP/IP, and other networking capabilities. Utilized the MS Word Templates stored and created in the Actuate Library upon initial opening. Duties also included passing and appropriating data for queries in SQL via web, internet portal capabilities, and modification to DHTML screens and downloading reports to CSV files. Develop application software using client/server technologies, ERP applications, and Visual Basic coding JAVA Scripting. Development front end architecture to ensure proper linkage to the AS/400, PeopleSoft, Crystal, Siebel, Cognos, Lawson, and SAP, applications and databases utilizing the SQL Server. Assigned to code, review, and manipulate stored procedures to call data for appropriate fields in the Actuate application.
Environment: Windows 95/NT4, Oracle 7.3, Oracle Designer2000, Oracle Developer2000 (Forms 5.0, Reports 3.0), PeopleSoft 8, Lawson (Finance), Forms 3.0, Crystal Reports ver 6, Actuate e.Reporting Suite 5, Actuate Basic, Visual Basic, Unix, Siebel 6 & 7, Siebel Tools, SQL Tools, SQL Word
03/01 - 06/01 Confidential,Senior Siebel Consultant
Responsible for Visual Basic and C++ coding in an Oracle/SQL 7.0 database and AS/400 server environment and UNIX platform, construction, design, and testing, systems analysis, software selection, and implementation, planning and execution of the Siebel client application using Siebel Tools, eScript, and Thin Client. Develop application software using client/server technologies. Following and accurately interpreting various specification, design, and requirement documents to build business applications related to designing screens, views, and applets. Web Development, eFinance, and front end architecture to ensure proper linkage to Siebel application using EIM, CTI, EAI, and TCP/IP, and Visual Basic coding and technologies. Other duties include being responsible for providing overall technical leadership for client\'s Siebel 2000 deployment and ensuring the technical and architectural requirements are fulfilled properly and efficiently.
Environment: Windows NT4, Oracle 7.1, SQL Loader, Visual Basic, Siebel 2000, Siebel Tools

03/00 – 3/01 Confidential,Senior Siebel & Actuate Report Writer/VB Programmer
Assigned to conduct internal installation, project management, workflow process, and implementation of the Siebel Thin Client. Provided support and monitored daily maintenance of critical data. Data included synchronization, database management, encompassing technologies such as MS Excel to import into application associated with the CRM Practice, Service, Field Sales/Service, Help Desk, Sales Force Automation, Workflow and Assignment Manager, JD Edwards, eBusiness, eCommerce, eFinance, ePharma, and Plumtree & Gadget experience to remote and desktop users, through PC Anywhere, Siebel Anywhere, Configurations for EIM, EAI, CTI, Smart scripts, eScripting, and pop up screens that contain data about prospective customers, used primarily with the Sales and Marketing Teams. Actuate, Crystal, Cognos PowerPlay, Lawson, and PeopleSoft report-writing tool used to design and implement reports directly related to Siebel. Assigned to create, design, and develop new reports based on product requirements from an Oracle database and Oracle 7 environment on an AS/400, Windows NT, and UNIX platforms servicing multiple users. Modify existing C++, JAVA Scripting, and Visual Basic code as needed to support higher performance, stability, and bug fixes, including MS ODBC for network connectivity. Duties also include passing, importing, and exporting for appropriating data via web, internet portal capabilities, and modification to DHTML screens and downloading reports and migrating Crystal reports into Actuate Report functionality. Develop application software using client/server technologies and Ad hoc queries and Noetix technologies. Following and accurately interpreting various specification, design, and requirement documents to build business applications related to designing screens, views, and applets, including Actuate reporting from previously used Crystal Reports for a Call Center environment and Siebel application. TCP/IP, Web Development and front end architecture to ensure proper linkage to the Siebel and SAP systems. Other duties include being responsible for providing overall technical leadership for client’s Siebel 99 and 2000 including version. 6.0 deployment and ensuring the technical and architectural requirements were fulfilled properly and efficiently.
Environment: Windows 95/NT4, Oracle 7.1, SQL Loader, Siebel 2000, Siebel Tools, Visual Basic 5, Actuate Report Writer 4, Actuate Basic, Crystal Reports ver 5, Lawson (Finance/Healthcare) Visual Basic 5.0, MS Access, Microsoft Excel
09/99 – 03/00 – Confidential,Siebel & Actuate Programmer,
Duties include Siebel 99 installation of Siebel Thin Client. Develop application and design and implement the architecture of screens, views, and applets. Assigned to analyze Visual Basic, C++, JAVA Scripting and coding for existing macros created in MS Excel and MS Access to the Time Reporting system in an SQL 6.0 server in a Windows NT/95 environment controlled on the AS/400 and UNIX platforms and using TCP/IP. Dual (Magic Boot) booting laptop to ensure server connectivity and database administration duties, as it relates to the internal Siebel and various applications. Microsoft Visio 6 and Visual FoxPro used to accomplish visual basic and C++ architecture and compilation and coding of data. Actuate Report writing tool used and installed to link to Siebel application to build and design reports. Duties also include interfacing with various ERP applications and Noetix technologies, such as PeopleSoft and JD Edwards to design and convert to Actuate reports. Revenue reports completed and time function managed to insure proper billing and daily coding as it relates to dates and orders.
Environment: Windows 95/NT4, Oracle 7.1, SQL Loader, Siebel 2000, Siebel Tools, Visio Studio, Visual Basic 5, Actuate 4
TECHNICAL SKILLS

Coursework in Mathematics and Computer Science Program
Completed AS Accounting & Business Administration, Minor Computer Science

Databases/DB Tools:

Proficient in: Siebel/Thin Client 6 & 7 (Certified), Siebel Tools eBusiness 2000, eScript, Siebel Enterprise Analytics Platform, MS Access, Quickbooks, MS Front Page, JD Edwards, Lawson Financial, Cognos PowerPlay ver. 7and 8, Cognos Reportnet, SQL Query Analyzer ver. 8, Cognos Configuration, PowerPlay Enterprise Server, Framework Manager, Lotus Notes, SQL 7.0, Cold Fusion, Sybase, Oracle, FoxPro, PeopleSoft, PowerBuilder, DB2, CICS, Application Servers, ASP, Peachtree, Citrix, Crystal Reports ver 4, 5, 6, 8 & 8.5, Actuate Reporting, ver. 4, 5, 6, & 8, Plumtree, MAZU Profiler Discovery for BMC Atrium CMDB

Application Development Languages:

Proficient in: C, C++, Visual Basic & Tools 6.0, COBOL, Ada, RoboHelp, Pascal, Turbo Pascal, CA-Clipper, HTML, JAVA Script, SQL Analyzer and Enterprise Manager 8, Aqua Studio, TOAD

Operating Systems:

Proficient in: AS/400, OS/390, DOS, OS/2, AT&T, UNIX, Linux, Windows 3.1, 95, 98, 2000, NT, XP, ME, 7, Solaris

Training:

Siebel Training for versions 99 & 2000, Actuate Training 4 & 5, e.Reporting Suite, and Plumtree Training ver 4s, Deltek Costpoint Training (Billing w/workshop, Advanced Billing Concepts, Fixed Assets), Cognos 10