PROFESSIONAL SUMMARY:

• Over 9 years of experience in development, design, testing, and implementation with major focus in Data Warehousing and Business Intelligence applications
• Extensive IT experience in Financial domain such as Institutional/Commercial, Consumer risk banking and implementation of Basel systems.
• Strong administrative and development knowledge of Cognos environment and tools IBM Cognos 10.2.1/10.1/8.4 BI Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio , Report Net.
• Experience in Installation and Configuration of various Cognos products on Windows and Unix platforms.
• Proficient in Meta data modeling with Framework Manager and experienced in layered approach such as Physical Layer, Business Layer and Presentation Layer.
• Created Complex Reports with advanced features such as Master Detailed sections, Conditional formatting, Render variables, Drill-trough, Page set and bursting using Report Studio.
• Worked on Security Access to client using Access Manager and Reportnet with LDAP . Also worked with data level, Object level and package level security in Framework Manager.
• Expertise in OLTP/ OLAP System Study, Analysis and Developing Database Schema like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Expertise in developing SQL, PL/SQL, Stored Procedures, Functions, Materialized views and Packages in Oracle and SQL Server database.
• Executed multitasking skills to work on multiple projects and thrive in a fast-paced, deadline-based environment.

SKILLS/TOOLS:

BI Tools: Cognos 10/8 BI Series, Cognos Metrics Manager, MicroStrategy, Tableau

ETL Tools: Informatica PowerCenter, Cognos Decision Stream, OWB, Ab-Initio

Programming: VB, Java, C, Pro C, SQL/SQR, PLSQL, C

Internet Technologies: HTML 4.0, VB.NET, JavaScript, ASP

Java Technologies: EJB, RMI, CORBA, JSP

Front End: Developer 2000, Visual Interdev, and Visual Basic

Databases: Oracle 8i, 9i, 10g , Sybase, DB2, SQL Server

Operating Systems: Windows 95/98/00/NT 4.0, UNIX Solaris, HP , Windows XP

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Cognos Admin/BI Developer

• 1 Bargaining: Enhancements to the current Benefit Data Mart, which includes adding dependent information and improving the performance. This also includes the development of Benefits at a Glance reporting, and automation of select National Employee Benefits reports.
• 2 Succession Management: Integration of SM data with Total Performance, Recruitment, Employee Demographic, and Employment data. The other objective is to capture historic talent profile and future role information annually.
• 3 Total Performance: Streamlining current standard summary reports and addition of Trends Graphs for core metrics reports. This also includes Reporting Chain / Organizational Hierarchy reporting functionality for all Critical Reporting reports.
• Supported end user reporting requirements by developing reporting solutions on the Cognos BI platform.
• Work within the Corporate IT department and support day to day reporting needs for multiple business users.
• Design, Develop and Support Cognos BI content including Reports, Cubes, Packages, Dashboards, Presentation portals etc.
• Co-ordinate, Assist and Develop Cognos Framework Manager models, adjustments to accommodate new and existing business requirements.
• Assist in business requirements gathering process, including working with end users to interpret functional requirements into Report specifications.
• Developed and Performed tests on various enterprises, provide Dashboard solutions with the help of Cognos software and assist all end users.
• Monitor work and ensure optimal utilization of all SQL scripts documentation of all database requirements and analyze data anomalies.
• Perform troubleshoot on all Cognos helpdesk tickets and resolve all queries for content prepare standard reports and ensure accuracy of the same.
• Provide support to all Cognos issues and maintain knowledge on all new techniques and prepare reports for all warehouse functions.

Environment: Cognos 10.2.1 - Report Studio, Metric Studio, Query Studio, Cognos Workspaces, Framework Manager, Transformer, HTML, Java Script, C , PeopleSoft, SAS, DB2, Windows 7.

Confidential

Sr. Cognos Admin/ Developer

• Developed and maintained over 85 reports on the Metrics and Insights website, serving about 1500 users every month.
• Used SAS to extract and transform data from the Enterprise Data Warehouse EDW .
• Trained end users to use Report Studio, Query Studio, Workspace Advanced and Metrics Studio.
• Conducted post implementation feedback analysis to analyze the cognos reports usage by the end users.
• Built various Segment Trend reports, which are used to analyze the current and future market trends by the Executive Management.
• Developed reports MDX queries using Cube based packages.
• Built variety of Executive Dashboards for a quick glance of various attributes/KPIs for Executive management.
• Migrated and validated Essbase cubes in each environment DEV, UAT and PROD during a move on to the new Essbase servers.
• Upgraded all DEV, UAT and PROD servers with the latest Cognos 10.2 software.
• Utilized a separate Cognos IST environment to test each of the server environment upgrades.
• Developed various complex reports using List, Crosstab and Chart objects.
• Used HTML and JavaScript to improve the look and feel of the reports.
• Migrated Reports, Packages, Cubes and folders from one environment to other DEV, UAT PROD upon BICC user requests.
• Created Data Connections in Cognos Administration, to connect various cubes through Framework Manager.
• Developed new Essbase cubes for internal clients.
• Created various roles to access the reports for different levels of users.
• Gathered software and implemented Firewall Internal External securities to start development on Mobile reporting, to use our existing reports remotely over tablets and smart phones.

Environment: Cognos 10.2.1 Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio , Java Script, HTML, Java, SAS, Essbase v11.1, DB2, Windows XP, Oracle 11g, Unix

Confidential

Sr. Cognos Developer/Administrator

• Installed IBM Cognos 10.1.1 on a Multi-Server environment Dev /QA /Prod .
• Implemented multiple metadata models Relational / DMR and OLAP in Framework Manager while following best practices and specific corporate standards.
• Implemented complex Row Level Security in the FM and Implemented Cognos Security folders, user groups and roles.
• Enhanced the existing cognos environment using Cognos software development kit SDK .
• Involved in writing Stored Procedures and imported into Framework Manager to create complex reports.
• Implemented Cognos SDK code for extracting the report schedules defined by power users.
• Created Database Layer, Business Layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Authored extremely complex List, Crosstab, Graphical Chart, Dashboard and Active reports which included Conditional Formatting, Cascading Prompts/Filters, Master Child Relationships, Multiple report displays, Drill-Through, Dynamic Sorting and Grouping, Multi Page and Executive Dashboards.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10.1
• Created cubes in Transformer using various data sources.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Environment: Cognos 10 Framework Manager, Report Studio, Analysis Studio, Query Studio , Cognos SDK, Java Script, HTML, Java, Shell Script, IBM Neteeza v6.0.2, Oracle 11g, Linux v5.4