SUMMARY

• Experienced Systems Analyst/Programmer Analyst with 15 yrs experience in rdms, data warehouse development and reporting, revenue and quality assurance, project management, enterprise system conversions, database administration, PL/SQL database programming.
• Application development and report writing with Crystal reports 8.5, Crystal Reports 11, Xcelsius, WEBi, Oracle w/Visual basic, Access, SSRS, SSIS,Excel, Cognos Series 7, ReportNet, Cognos 8, Cognos 10.1, Cognos 10.2,PeopleSoft 8 & 9, Ellucian Banner for Higher Education, WebFocus 4.3.6/5.0,and Focus for Unix

PROFESSIONAL EXPERIENCE

Confidential, Atlanta,GA

Sr.Cognos Consultant/Admin Consultant

Responsibilities:

• Cognos 10 administrator lead support resource.
• Worked with business users to design and develop correct and well - performing Cognos reports and cubes using Report Studio with data drill-down and slice and dice options.
• Developed and scheduled complex reports using Event Studio.
• Supported relational and multidimensional models and translated them into the development of the metadata layer in Framework Manager in conjunction with the logical and physical data models.
• Developed SQL scripts for investigating, researching and verifying results of queries and reports. Supported users in problem resolution including troubleshooting of operational, data and performance issues.
• Provided analytical and decision support for the implantation and on-going enhancement of existing reports and cubes.
• Administered Cognos Portal objects, deployments, data source creation, user security, folder/object level security, scheduling, event/agent creation and scheduling.

Environment: s included but not limited to Cognos 10.1.1, Motio CI, Cognos Series 7.

Confidential, South Orange,NJ

Banner/Sr.Cognos Report Developer Consultant

Responsibilities:

• Cognos 10 report development project.
• Responsible for converting PeopleSoft 9/Oracle 11G reports to Cognos 10.2 reports.
• Review Oracle .rdf file and re-engineer Cognos report to return same results.
• Work with Data Steward to ensure reports reconcile to Oracle report, and also implement modifications made by business.
• Involved in JAD sessions with Data Steward and Business to gather requirements and new modifications.
• Extensive use of Banner ODS as well as Banner application.
• Perform analysis and development utilizing EDW to create reports and dashboards in order to demonstrate trends, KPI’s amongst Programs/Curriculums, Colleges, and Majors. Involved heavily in Student module, Student Services, HR, High school Recruitment, as well as others.

Confidential, Alpharetta,GA

SQL Developer/Systems Analyst/Sr. Cognos Report Developer Consultant

Responsibilities:

• Daily activities included writing SQL scripts to ensure data validity, sql scripts to reconcile Cognos report again Exadata data.
• Work closely with ETL team to ensure timeliness of data loads reflected in reports.
• Responsible for changing report SQL syntax to Oracle 11g for report validity.
• Made modifications to reports to ensure reports matched existing production reports.
• Ensured report events, jobs with Event Studio, and schedules matched production environment.
• Ensured Java File Migration utility worked for converted reports.
• Cognos 10.2, Cognos 10.1, Neoview, Oracle.

Confidential

SQL Server Developer/Cognos Architect/Lead Developer Consultant

Responsibilities:

• Cognos 10.2 Implementation for Property and Casualty business.
• Project tasks include requirements gathering, create technical specifications, design data architecture, assist in ETL design, security design, involved in datamart architect design.
• Involved in SSIS design, scheduling, and ensuring loads were successful.
• Involved in SSRS report specifications and development
• Converted SSRS reports to Cognos 10 reports
• Wrote embedded SQL in Cognos Framework for complex queries not obtainable using FM.
• Responsible for Framework Manager development, report and dashboard development with Report studio and Business Insight,
• Assist in Cognos administration
• Performed software upgrade from Cognos 10.1 to 10.2.
• Trained business users on how to use Report Studio, Query Studio, Business Insight, and Analysis Studio.

Environment: included but not limited to SQL Server 2008, DB2, QlickView, Mainframe, Cognos 10.2, Cognos Finance, SSIS, SSRS, SSAS, .NET.

Confidential

SQL Developer/Sr. Cognos Report Developer Consultant

Responsibilities:

• IS reporting for Customer Support Group which supports Finance division.
• Cognos 8.4 development, support, administration, architecture.
• Involved in requirement gathering and definition, signoff, and technical delivery.
• Designed and developed Scorecarding application for Support team, Finance and Planning teams.
• Involved in upgrade to Cognos 10.1
• Enhanced dashboard applications using Business Insight to develop and enhance existing reports and charts.
• Responsible for developing Finance Planning reports and cubes which retrieve data from SAP stored in Data Warehouse.
• Responsible for developing external customer ad-hoc reports which retrieve data from Nativa and Teradata data warehouses.
• SQL development included but not limited to PL/SQL temp table creation, packages, stored procedures, and etc.

Environment: includes Oracle 10g, SQL Developer, Remedy, Clarity, HP Quality Center, Perforce Source Control, Cognos 8.4 BI Report, Query, Metric, Analysis, Powerplay, Event Studio, Framework, Metric Designer, Cognos 10.1, SAP, SAP BW, Informatica, Nativa database, Teradata, Neoview.

Confidential, Atlanta,GA.

Banner /Cognos Report Developer Consultant

Responsibilities:

• Analyst involved in developing reports for Office of President, Budget, Grants, Advancement, Recruitment, and Students Module.
• Analyst also assisted in supporting ODS jobs and refreshes.
• Administered Cognos user accounts, package, folder, data level security.
• Trained business users to develop reports from simple list to complex crosstab reports using Query Studio and Report Studio.
• Created several dashboard style reports, decreasing need to develop/maintain several stand-alone reports.
• Environments included by not limited to Ellucian Banner, PeopleSoft 8, Oracle 8, and Cognos 8.4.

Confidential, Hagerstown,MD

Systems Analyst/Cognos Report Developer Consultant

Responsibilities:

• Analyst involved with BI application migration from Cognos 7 to Cognos 8.4.
• Analyst responsible for troubleshooting and improving cube optimization, query tuning, and creating drill through definitions for PowerPlay Studio reports.
• Tasks involved but not limited to creating and deploying framework manager packages to production
• Facilitating knowledge transfer sessions with client, training and mentoring staff members, troubleshooting Cognos environment issues.

Environment: includes Cognos 8.4 studios, SQL Server 2008, CAFÉ, Metadata manager, Metric designer, Framework manager, Powerplay Transformer, windows server, TOAD.

Confidential, Alpharetta,GA.

SQL Developer/System Analyst/Cognos Report Developer Consultant

Responsibilities:

• Analyst involved in IS reporting for Customer Support Group which supports Finance division.
• Analyst creates, debugs, modifies reports, dashboards, cubes, and adhoc pl/sql scripts that provide data extracts for Customer Support.
• Analyst also develops and maitains Framework data model, security access in Cognos portal, and source control versioning for files.
• Analyst also involved with developing ad-hoc reports with Crystal Reports 11.
• Analyst created PL/SQL temp tables as source for Crystal reports.

Environment: s include but not limited to Cognos Report Studio 8.4, Cognos ePlanning, Controller Query Studio, Analysis Studio, Event Studio, Transformer, Powerplay Client, Oracle 10g, SQL Developer, Remedy, Clarity, HP Quality Center, Perforce Source Control.

Confidential

Banner / Cognos Report Developer Consultant

Responsibilities:

• Consultant responsible for migrating reports for Admissions, Student Records, Accounts Receivable, Recruitement, and HR.
• Consultant responsible for converting reports from Legacy SIS system to Cognos 8.4 reports.
• Consultant also responsible for converting Accounts Receivables reports from PeopleSoft/Crystal Reports 8.5 to Cognos 8.4.
• Primary analyst for creating and developing reporting metadata logical and presentation layers in Framework manager.
• Reports developed with 8.4 Report Studio and Query Studio.
• Responsible for training IT staff in Report Studioand Query studio.

Confidential

SQL Developer/Systems Analyst/Cognos Report Developer Consultant

Responsibilities:

• Healthcare data systems industry.
• Responsible for custom enhancements to enterprise wide Cognos dashboard interface.
• Development including but not limited to drill-thru reports, conditional formatting, security design, SSIS ETL design, relational and DMR modeling with Framework.
• Framework manager and report development including creating stored procedures (SQL Server), java scripting, html scripting, and customizations.
• Assists in debugging defects, testing, and migrating reports to production.
• Created detailed documentation guide which illustrated code syntax, java/html scripts, hyperlinks to reference guides/white papers, “how-to” examples, and best practices for BI team to reference going forward.

Confidential

Systems Analyst/Cognos Report Developer Consultant

Responsibilities:

• International help desk industry.
• Extensive Cognos 8.3 report development including but not limited to crosstab, lists, charts, master-detail reports.
• Responsible for upgrading over 400 CRN 1.1 reports to Cognos 8.3, debugging, adding HTML items, fixing upgrade issues.
• Created high level summary reports with drill-thru functionality for Confidential external customers.
• Assisted in testing and transition of development knowledge to staff.
• Oracle 9i environment, Maximo.

Confidential

Systems Analyst/Cognos Report Developer Consultant

Responsibilities:

• Assist in Cognos 8.4 migration from Series 7 Powerplay/Impromptu reporting.
• Fixed and debugged several reports for Property/Casualty, Ocean Marine, Inland Marine, Excess Liability, Trucking, and SHS(Specialty Human Services) business divisions.
• Responsible for fixing and debugging complex reports such as list, crosstab, IWR’s, Powerplay cubes that contained MDX language
• Set up reports for bursting using OLAP datasource.
• Assisted in making modifications to relational Framework model (Oracle 10g), redefined hierarchies and levels in DMR model, and OLAP framework datasource.
• Extensive report development using MDX language.
• Trained and mentored full-time staff, interns, and team leads in regards to advanced reporting techniques and best practices.

Confidential

SQL Server Developer/Cognos Report Developer Consultant

Responsibilities:

• Cognos Impromptu data modeling, report development, catalog creation with SQL Server database.
• Catalog developed as front end application for Lawson ERP healthcare system that supports six different hospitals.
• Created catalog solely from Lawson application documentation.
• Created ERD, catalog design, and catalog security documentation for BI Manager.
• Cognos administration duties including catalog with Access Manager, folder security, filters, prompts, SQL Server DTS.

Confidential

Sr Cognos Consultant/Project Analyst Consultant

Responsibilities:

• Primary Cognos consultant and Project Manager responsible for upgrade and planning scalability for upgrades for all CRN 1.1 environments to Cognos 8.1 and user class security.
• Responsible for installation, configuration, and testing of Cognos 8.1 reports.
• Installation performed on Unix Solaris 8 platform. Web server configurations performed on SunOne web server.
• Configured content store to communicate with Teradata ODBC driver.
• Content store utilized Teradata 8.0, UTF - 8 Oracle 10g database.
• Upgraded and republished DMR framework models
• Upgraded and optimized existing Powerplay cubes.
• Imported Powerplay series 7 cubes into Framework and Cognos Connection
• Upgraded and republished cubes for Analysis studio compatibility.
• Integrated Powerplay 7.3 Powecubes within Cognos Connection 8.1 .
• Rebranded Cognos Connection portal page for Confidential customization.
• Project manager tasks include but not limited to developing project plan with Microsoft Project, driving initiatives and milestones.

Confidential, Columbus,OH.

Systems Analyst/Cognos Report Developer Consultant

Responsibilities:

• Interactive JAD sessions with business managers and report end users to gather reporting needs and drive new project initiatives.
• Primary Cognos analyst responsible for Cognos report development, data modeling, administration, configuration, and support of Global Finance Data mart project with PeopleSoft 9.0.
• Responsible for steering project from requirements gathering stage thru production support.
• Report development and Informatica ETL extraction from PeopleSoft AR, AP, GL, Journal Entries, Invoicing modules.
• Primary consultant responsible for development, data modeling, administration, configuration, and support of Global Customer Support Data mart with PeopleSoft 9.0.
• Analyst responsible for wearing various hats including but not limited to business analyst, developer, administrator, facilitating training classes to end user community, production support.
• Extensive development with Cognos 8.2 Report Studio, Query Studio, CRN ReportNet 1.2, DMR Framework Modeling, Cognos 8 Transformer, DB2, PeopleSoft, WMS, scorecarding, dashboards.
• Imported Powerplay series 7 cubes into Framework, upgraded and republished, for Analysis studio compatibility.
• Developed cubes with Cognos 8 BI Modeling, published cube to Analysis studio for business users. Created drill through definitions for cube drill thru to Report Studio reports.
• Oracle 10g environment.

Confidential, Orlando,FL.

Systems Analyst/Cognos Report Developer Contractor

Responsibilities:

• Cognos resource for Siebel CRM 8.0 system reporting.
• Cognos development tools consist of Cognos Series 7.3 Impromptu, Access Manager, and Upfront.
• Resource responsible for developing release 2 and 3 reports .
• Resource responsible for promoting reports to test, quality assurance, and production.
• Resource also responsible for back end development including but not limited to creating views, redefining catalog joins, report and sql tuning.

Confidential, Duluth,GA.

Sr. Consultant Employee

Responsibilities:

• Cognos report development tools includes but not limited to Cognos ReportNet, Cognos 8, Decision Stream, PowerPlay/Transformer, DMR with Framework Manager.
• Implemented third-party portal (WebSphere).
• Application development includes but not limited to Oracle 9i PL/SQL,SQL Server, Teradata, DTS Packages, JDEdwards, and PeopleSoft.
• Cognos Administration includes but not limited to Framework package security, Access Manager security, Cognos Connection portal, and Oracle 9i tables/materialized views.

Confidential, Charlotte,NC.

Systems Analyst/Cognos Report Developer Contractor

Responsibilities:

• Primary Analyst involved in analysis and report development for Marketing Campaign Project.
• Project initiative to recognize Confidential key performer indicators, strategic marketing campaign positions, campaign responsiveness, and customer retention rates.
• Cognos development consists of PowerPlay/Transformer cubes, report studio reports.
• Designed PL/SQL aggregate table for reporting purposes in Oracle 9i environment, TOAD,PL/SQL developer, ETL exposure to Oracle Warehouse Builder and Informatica.
• Developed Unix korn shell script to automate table load and cube build.
• Migrated cubes from development, QA, to production environment.
• Responsible for production support to business end users.

Confidential

Banner/Cognos Report Developer Contractor

Responsibilities:

• Primary report developer for PeopleSoft Finance module.
• Direct report to Wake Forest Univ. accountant and controller.
• Primary developer responsible for SCT ODS (Operational Data Store),EDW view enhancements and modifications catering to WFU's Finance reporting requirements.
• Facilitate Cognos Reportnet (Query Studio) training sessions with Financial report users.
• Involved in implementing folder access and row-level security between Banner and Cognos finance users.

Confidential

Cognos Report Developer Contractor

Responsibilities:

• Primary Developer for DB2 Operational Data Store (ODS), utilizing Cognos ReportNet. This Proof-of-Concept was aimed Confidential replacing a Lotus Notes production Lease Management reporting system that did not provide agents with an overall look Confidential strategic advantages and complete business intelligence.
• Participated in multiple design reviews of logical data models to make sure appropriate design methodologies were utilized, so that efficient/reliable designs were provided for use in future BI reporting by customers.
• Created Db2 version 8 MQT’s for primary reporting environment.
• Developed and maintained reporting packages, folders, routines, and other server related issues surrounding day to day reporting.
• Presented UAT documentation that demonstrated proven analysis of developer and end user unit acceptance testing.
• Heavy interaction with Business Analyst.

Confidential

Cognos QA Analyst / Cognos Report Developer Contractor

Responsibilities:

• Created test plan and test scripts for Db2 Version 8 database migration.
• Migrated reports to new production server.
• Performed Cognos upgrade from 7.1 to 7.2.
• Developed ReportNet reports for new production database. HMO insurance and pharmaceutical data.

Confidential

Cognos Report Developer Contractor

Responsibilities:

• Migrating enterprise wide Crystal Reports to Cognos ReportNet version 1.1.
• Remedy ticket support.
• Framework Manager development, query studio development, and report studio development.
• Developed on demand reports accessible via Cognos Connection web portal.
• Packages modeled from SQL Server database.
• Created package filters/calculations, and datamart views.

Confidential

Project Analyst/Developer Contractor

Responsibilities:

• Implemented reports via Cognos Suite 7.1 MR2.
• Phase I - Project Analyst responsible for gathering business requirements, developing functional and technical specifications, and creating Cognos report design standards.
• Involved in JAD sessions with regional analysts, users, and business owners to discuss functional business operations, report objectives, and process improvement for new reports.
• Phase II - Cognos Impromptu IWR report and cube development.
• Heavily involved with client's DBA to ensure data integrity in seed files from Atlas Billing System.
• Developed materialized views (Oracle 9i) for consistent reporting.
• Administrative duties such as catalog maintenance, re-create joins, set-up user classes, catalog prompts/pick lists, and Power Prompts for geographical purposes.
• Developed complex reports for Finance/Accounting team such as Accounting Analysis which displayed balance sheet revenue and expenses for Confidential .
• Developed and replicated Power Cubes for new data warehouse.
• Phase III - provided production support to end users post test and development. Tracked and created issues using Remedy Manager software.

Confidential

Systems Analyst/Programmer II

Responsibilities:

• Extensively involved in providing business intelligence by reporting from data warehouse using sql and pl/sql scripts.
• Provided follow-up to data warehouse back-end team to ensure end-user data integrity.
• Also heavily involved in regression quality assurance test cases with Amdocs billing system.
• Proficient in Focus language, Cognos Impromptu 6.0 & 7.0, and Crystal reports web reporting tools.
• Provided end-user training and support for pre-defined WebFocus 5.0 (via Internet Explorer) reports, self-service applications.
• Developed business intelligence reports with Focus/WebFocus and Cognos PowerPlay as front-end application to Oracle 9i database.
• Developed WebFocus reports and Cognos cubes to provide end-users with market/product/ specific analysis, ability to import/export data, and ability to link to data sources. Online applications were used to automate recurring ad-hoc reports/lists. Automation included but not limited to scheduling jobs using WebFocus report caster functionality, bursting reports for different groups, running jobs in deferred status, using parameters and setting/passing variables globally.
• Developed WebFocus reports with detail reporting, aggregation, calculated expressions, conditional styling, and OLAP drill-downs.
• Developed Cognos cubes with similar functionality, with more OLAP capability.
• Developed and managed WebFocus reports via Managed Reports Environment and Developer Studio.
• Coordinated with administrator to publish WebFocus reports and Cognos cubes from development to production environment with optimum usability and minimum latency.
• Created PL/SQL stored procedures, functions, cursors, triggers, and tables for ad-hoc reporting. Analyst also involved in tuning extensive reports using SQL LabVision.
• Analyst also used Crystal report functionalities for automated report distribution, local online analysis, and as an ODBC for end user development environment.
• Daily application tools consist of but not limited to Oracle 8i, 9i, 11i,10g, PL/SQL Developer, ETL, WMS,SQL Loader, SQL LabVision, Cognos Impromptu, Transformer, FTP Scripting, Access VBA Applications, Crystal reports 8.5, Focus for Unix, WebFocus Developer Studio 4.3.6.

Confidential

Business Systems Analyst Contractor

Responsibilities:

• BA acted as liaison between Conversion, IT set-up, Data Mapping, and Business Site Integration Management for conversion to new Billing system.
• Analyst major role involved solving system requirements via Convergys programmers. Analyst major responsibility included providing end user support and training auditors.
• Business Analyst served as lead of auditors, and coordinated and managed auditing activities performed by auditing team.
• High familiarity with system design lifecycle with emphasis on testing phase.
• Analyst daily responsibilities included but not limited to 24 X 7 on-call support, 24 X 7 on-call auditing support, and system regression testing.
• Analyst managed and updated audit issues database, compiled daily audit totals, FTP files transfers, and assisted in final executive summary of market.
• Analyst also coordinated and facilitated daily meetings with other system conversion teams.
• Daily application tools consist of but not limited to MS Access VBA Applications, Excel, and Mainframe (RPG environment).

Confidential

Finance Revenue Assurance Analyst II Contractor

Responsibilities:

• Analyst trained small level classes on Cognos Impromptu query development, scheduling reports, SQL, and exporting data to external files.
• Analyst major role was to mentor other Impromptu developers and provide proactive billing solutions to various sales campaigns introduce by Wireless Reseller division.
• Analyst maintained and managed reports that demonstrated financial impacts of Reseller business.
• Analyst was responsible for production of various reports such as Market Specific, Tax, KPI’s, as well on-demand Financial AdHoc reporting for Business Development team.
• Analyst was also involved in conversion of billing systems. Some of analyst major duties were to analyze and prepare reports for new billing system operational platform.
• Analyst utilized Crystal reports functionalities to run and publish multiple reports simultaneously. Analyst also used crystal report functionality to automate report distribution to various customers.
• Analyst worked closely with the Conversion team, Prepaid Accounts team (Amdocs software), and Business Development.

Confidential, Overland Park, KS.

Finance Revenue Assurance Analyst I Contractor

Responsibilities:

• Received special acknowledgement for developing campaign review tool (via Access Database and Reporting Application Tool).
• Analyst was responsible for production of reports through automated Cognos Impromptu tool.
• Analyst produced supportive automated tools to improve the process of daily business operations.
• Extensive query development in order to track and forecast billing issues.
• Analyst assisted Automated Billing Verification team by proactively validating large amounts of data through programmatic tools set in place.
• Analyst trained small level classes on Cognos Impromptu query development.
• Primary Analyst responsible for maintaining and developing databases associated with multiple queries that report economical and financial impact of cycle billing operations.

Confidential

Data Integrity Analyst/Associate Financial Systems Analyst

Responsibilities:

• Tasked with solving revenue loss due to non-returned goods.
• Daily interaction with Accounting team and IT.
• Analyst reported financial impacts of RGM receivables and payables.
• Analyst produced various revenue assurance reports that help sustain a standard operating procedure implemented during training.
• Analyst conducted financial and economical analysis of operations and projects. Includes fact gathering and review analysis of cost and operations.
• Performed auditing, reconciliation, and reviewed integrity of data through spreadsheets and Access databases.
• Analyst managed charts and tracked trends to forecast future business.
• Managed and modified auditing application tools developed with Microsoft Access 97.
• Application development with VBA, macros, DAO,ADO,ODBC, and crosstabs spreadsheet files.

Confidential, Eden Prairie, MN.

Accounting Sr.Accounting Associate/Team Lead

Responsibilities:

• Team achieved department goal by reconciling 20,000 invoices within a given amount of time.
• Associate responsible for leadership and production of Reconciliation team of up to eight employees.
• Associate maintained and developed spreadsheets supporting purchases and returns of parts used by Service Department.
• Associate used problem-solving skills to solve billing disputes and account activity.

Confidential

Finance Associate Contractor

Responsibilities:

• Finance associate was responsible for a wide variety of accounting functions that would support of all accounting operations of Ovation.
• Associate responsible for reports that provided preparation of company-wide audit.
• Developed spreadsheets and documents that accounted for capital expenditures of various business partners.