PROFESSIONAL SUMMARY:

• A long - time Cognos professional, I provide innovative and timely solutions for business applications and have:
• 8+ years of solid technical and functional experience as Cognos Developer which includes experience in Data Warehousing, Data Modeling, Business Intelligence (BI), OLAP, ETL tools, Product Development and Reports Generation, Business Objects/Crystal Reports, Oracle Applications (Manufacturing, Financials), with 20+ years overall Accounting experience
• Experience in various business sectors such as Accounting, Telecom, Workforce Management and Healthcare.
• Experience in developing and testing Complex reports (Multi-chart, Cross tab, Maps, Drill-through, Master- Detail, Multi-prompt and Bursting) using Report Studio.
• 10+ years of instructional design and professional business skills training
• Strong analysis, design, and communication skills

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/XP/2003/Vista/2007; Windows 2000/2003/2008 Server, MS Dos

RDBMS: Oracle 8i/9i/10g/11g, MS Access, SQL Server 2000/2005/2008

Languages: VBA, XML, JAVA, HTML, SQL

Tools: IBM Cognos 7 Series, Cognos 8.4, Cognos 10.1 and Cognos 10.2 (Data Manager, Framework Manager, Transformer, Mobile, Business Insight Advanced, Business Insight, Life Cycle Manager, Analysis Studio, Powerplay, Report Studio, Event Studio, Query Studio, Reportnet, Access Manager, Go Office, Go Dashboard, Cognos Analysis for Excel), Oracle 11i/R12 Suite (GL/AR/AP/FA/CRM), Oracle APEX, Oracle Business Intelligence Enterprise Edition (OBIEE 10g), Business Objects XI/Crystal Reports XI, MS Excel, MS Access, MS Project, MS Visio, Adobe Dreamweaver CS5, SQL Plus, SQL Developer, TOAD, Oracle Financials, SAP, PeopleSoft, JD Edwards, Peachtree, QuickBooks, Hyperion, BSP Metamanager, MotioCI and MotioPI.

Web Servers: Tomcat, Microsoft Internet Information Server

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

IBM Cognos BI Developer/Administrator

Responsibilities:

• Design distributed infrastructure for Cognos 10.2.1 environment.
• Upgrade from Cognos 8.4.1 to 10.2.1 including patch and release management.
• Installation and configuration of Cognos BI Server in a distributed architecture with load-balancing on multiple Web Servers, Application Servers and Content Management Servers. Including the following applications: Mobile gateway, Mobile client components, Insight BI integration gateway, Metrics Manager, Framework Manager, Transformer, Map Manager, Metrics Designer, Life Cycle Manager and Insight BI integration with provisioning of desk top client from webserver.
• Provide troubleshooting and diagnostic support for Cognos application issues that might be caused by operating system and/or the application itself.
• Manage and deploy framework packages and reports between different environments using MotioCI.
• Monitor IBM Cognos Servers for performance tuning optimization.
• Worked on securing Cognos Connection and setup security by assigning users to the groups and roles defined in Cognos Namespace.
• Responsible in gathering User-Requirements from the End-Users and documenting end to end process.
• Modified Existing Framework Model.
• Created and modified various reports using report studio.
• Built complex reports using multiple charts with drill-up and drill-down functionality, list, cross-tabs, prompts, calculations, conditions and filters.
• Created drill through reports and associated with the reports having Master-Detail relationship.
• Utilized the burst capability in Cognos to distribute the report to end users.
• Responsible for training the end-users in using Report Studio, Query Studio, Cognos Connection.

Cognos Developer

Confidential, RTP, NC

Responsibilities:

• Installed and configured Cognos 8.4.1 and Cognos 10.1 business intelligence software with single sign on using LDAP and Microsoft SQL Server data base.
• Analyze reporting requests and work directly with business owners to define requirements.
• Deploying packages/folders from one environment to another (DEV to QA to PROD) using BSP Metamanager.
• Managing user access and Cognos capability mapping through AD groups.
• Performed unit testing of all models, cubes, reports, scorecards, dashboards etc developed.
• Conducted detail UAT (User Acceptance Testing) before deploying solutions in production.
• Monitor Cognos Production Servers, taking backups and batch processing of the user requests.

Business Intelligence Analyst

Confidential, Morrisville, NC

Responsibilities:

• Installed and configured Cognos 8.4.1 and Cognos 10.1 business intelligence software in large distributed SOA environment. Installation consisted of two physical and four virtual machine (VM) servers. Implementation supports 900 users running Analysis Studio, Report Studio and Query Studio.
• Performed data extraction, transformation and loading from multiple sources, updating of tables and data cubes, and restructuring data to Data Warehouse architecture for use with front-end tools.
• Developed and prepared process to move Oracle data to Data Warehouse with Data Manager ETL tool for Oracle GL, Accounts Payable, Service Contracts, Accounts Receivable, Materials Management and CRM.
• Designed, Developed, Built and Supported metadata models and cubes utilizing Framework Manager and Transformer.
• Monitor Cognos Production Servers, taking backups and batch processing of the user requests.
• Develop SQL queries for reporting and analysis using Oracle 10g/11g for reports.
• Assess technical requirements, existing infrastructure and data sources.
• Created, delivered and presented end-user training materials for Cognos Report Studio and Query Studio.
• Gathered/Designed report requirements and built sophisticated reports/dashboards/scorecards, analysis and queries.
• Created/Maintained BI Dev, Test and Production environments, user creations and management, license management, application deployments between servers, change management.
• Performed unit testing of all models, cubes, reports, scorecards, dashboards etc developed.
• Conducted detail UAT (User Acceptance Testing) before deploying solutions in production.
• Analyzed reporting data requirements, data mapping and data source analysis and design, identify ETL, model issues, missing data etc and work with IT to resolve them.

Senior Financial Analyst

Confidential, Morrisville, NC

Responsibilities:

• Prepared detailed reports including actual vs. budget/forecast analysis for expenses and analysis.
• Received the budget input from various departments of the organization and critically examined them for correctness, accuracy and completeness before preparing the corporate budget.
• Suggested suitable amendments in the budget to the managerial staff of the concerned department.
• Monitored the budget throughout the year, approving all purchases including capital acquisitions.
• Reviewed financial transactions, sales contracts and in charge of day-to-day, quarter end and month end closing activities.

Senior Financial Analyst

Confidential, Durham, NC

Responsibilities:

• Leading a team of 2 developers to design, build and streamline denial management processes for the hospitals; these critical functions worked well and were found to be quite intuitive.
• Writing the functional design and technical design for all customizations (forms, concurrent programs), so that business users and technical developers had a common understanding of the solution.
• Analyzing reporting requirements to identify root causes to prevent denials; improve cash & efficiency and writing specifications (high-level, detailed functional, detailed technical) for the reports. Led a team to quickly develop a number of crucial reports for the largest facility.
• Analyzing the complex reporting needs for the hospitals and designing appropriate reports. Prepared and coordinated distribution of various financial reports and analyses for senior management and external agencies to include financial analysis of individual unit operations.
• Maintained liaison with hospital financial managers and administrative staff in the preparation and analysis of financial reports, to provide information and to resolve problems concerning variances from approved budget, insurance claims and denials.
• Set up the metadata models using Framework Manager and built data cubes using BI Transformer.
• Designed and developed interactive Dashboards and KPI (Key Performance Indicators) with drill down and drill through capabilities.
• Identified and developed metrics, measures, and dimensions.
• Designed and developed ETL procedures using Cognos Decision Stream.

Senior Financial Analyst

Confidential, RTP, NC

Responsibilities:

• Provide research, modeling, analysis, and documentation related to design and implementation of commission programs that are competitive, cost effective and consistent with goals and compensation philosophy.
• Calculation/review of monthly/quarterly/annual sales commissions, including running reports in Salesforce.com, HR data validation, compilation of data and performing all calculations.
• Stay abreast of federal, state and local compensation regulations to ensure company compliance.
• Preparing and maintaining the annual commission policy and various written commission plans, including managing commission plan acknowledgement forms.
• Consult with HR Business Partners and leaders on all compensation programs and practices that pertain to the respective business groups.
• Assist the Sales organization in resolving any Compensation-related issues or discrepancies.