SUMMARY

• 7+ years of experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Financial, Banking, Manufacturing, Retail, Insurance, and Pharmaceutical industries.
• Proven experience at building, motivating and leading professional teams, managing projects and supporting client relationships.
• Worked on Cognos 8 and Cognos 10 BI environment to support high concurrency.
• Handling complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Good experience in working with web servers like IIS, Apache, IHS etc.
• Good experience on Cognos Tools - Cognos 8.0/8.1/8.2/8.3/8.4/10/10.1/10.1.1 Suite (Report Studio, Analysis Studio, Query Studio, Metric Studio, Event studio and Cognos Connection), Cognos Reportnet 1.1 Mr3, Cognos EP Series 7.3(Impromptu, IWR, Power Play Transformer and Power Play Windows/Web, upfront).
• Sound Knowledge on Cognos 8.3/8.4 and, Cognos 10.x BI Suite(framework Manager, Cognos connection, Report Studio, Metric Studio, analysis Studio and Query Studio).
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and ComplexReportbuilding with Report Studio.
• Sound Skills in Report Development, Modeling (Relational, DMR) in Cognos 8 and Cognos 10.
• Sound Skills on Developing Score Card Applications using Metric Manger and Metric Studio.
• Sound Skills on Dash Board Report building using Report Studio and Analysis Studio against Multi- dimensional sources (mdx).
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications.
• Experience in implementation of the Cognos Series 8 and Cognos 10 Business Intelligence Software and migration from Cognos Series 8.x to 10.x.
• Experience in development and customization of Cognos reports, cubes, and decision support applications using Cognos Series 8 business intelligence tools.
• Experience in 4 enterprise implementations of Cognos 8 and 10.
• Basic understanding of ETL tools like Informatica, Decision Stream and data warehousing concepts
• Experience in Troubleshooting Cognos problems and tunes for performance.
• Extensive experiencein Multiple Relational Databases including SQL SERVER, ORACLE, TERADATA and DB2.
• Experience with Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.
• Experience with Cognos Software Development Kit (SDK) to customize reports using JAVA.
• Expertise in OLTP/OLAP/OOAD System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.x/8.x Suite (Framework manager,Report Studio, Analysis Studio, CognosConnection, Event Studio, Query Studio) Cognos EP Series 7.4, Business Objects 5.1, Cognos Impromptu 7.4, Power Play 7.4, IWR, Upfront.

Databases: Oracle 8i/9i, MS SQL Server 2000/2008, DB2, Teradata.

Data Modeling: Erwin, Microsoft Visio.

Oracle Tools: SQL*Plus, Toad, SQL*Loader, PL/SQL Developer, WinSql.

Languages: C, C++, DOT NET, SQL, PL/SQL Programming, Visual Basic.

Operating Systems: Windows98/2000/NT/XP, Unix/Linux, Sun-Solaris, Mac OS

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Sr. Cognos Developer/ FM Analyst

Responsibilities:

• Analyzed Business requirements and using the existed excel Reports developed Cognos Report Specification.
• Gathered report requirements from Business Users and converted them in to technical documents.
• Developed Financial Reports such as Comparative Balance sheet, P&L Trend analysis, Statement of activity, and Cash Flow reports using Report Studio.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Employed Customized cascading prompts, drill-through, HTML Script and sub-reports.
• Created Executive Dashboards, complex reports using Report Studio
• Dashboards incorporated list reports and charts and also provided Dynamic drill through.
• Used Analysis Studio for analyzing the sales trend by ranking the performance of Area and its associated Branches
• Developed Reports in query studio to meet the ad-hoc reporting requirements and later trained the users on how to develop their own reports
• Created Drill through and Master Detail reports using Report Studio for sales analysis and summary reports for current year and previous year.
• Created complex Dashboard Reports likeTrend over Time Reports, Variance Reports and Forecast Reports.
• Developed reports involving Multi Query, Multi page, Discontinuous cross tab, Graphical, Repeater, Union queries, Dashboard reports with a very high level of detail and formatting.
• Createdmodels in Framework Manager.
• Solved issues in existing model and created, published packages using Framework Manager.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models
• Created Query Prompts, calculations, Conditions and Filters.
• Developed Prompt pages and Conditional Variables.
• Created stored procedures query subjects in framework manager and resolved related issues.
• Created Test Cases unit testing for Reports, Framework Models and Stored Procedures.
• Created complex Active reports like data tab, data radio button, data checkbox, dropdown list etc.
• Provided lab books/guides for the end users on Business Insight Advanced practice. Worked on Performance tuning of the reports both from reports & database side
• Published packages in Cognos Connection and gave required security privileges to end users
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• Created New Jobs and Scheduled reports using Cognos connection.
• Customized the Cognos portal, edited the system.xml and the default.css files to have a better user interface.
• Worked extensively with ETL team to analyze and build data warehouse for reporting requirement.
• Created project documentation for the complete project life cycle.
• Trained and supported the end users. Hands on training to generate reports in Analysis Studio.
• Trained End users in using business Insight for creating their own dashboards using the existing canned reports.
• Worked with PL/SQL to develop stored procedures and functions to improve performance.
• Involved in writing Stored Procedures and functions in Oracle Pl/SQL.
• Deploying (import and export) the reports developed on the customer environment by arranging the Webex Sessions.
• Involved in creating User groups, Roles and implementing security across the organization.

Environment: Cognos 10.x (Framework Manager, Report Studio, Query Studio, Analysis Studio, business insight and business insight advanced ), Oracle 10g, Microsoft SQL server 2005, Excel, Access, Informatica Power Center, Windows 2003 Server, UNIX, Erwin, oracle.

Confidential, Newport, New Jersey

Sr. Cognos Developer

Responsibilities:

• Administration involved Installation and configuration ofCOGNOSservers, implementing security, managing users, user groups and roles in the organization and providedBI Orientation.
• Design & development of multiple reports using various templates likelist reports, cross-tab reports and chart reports using Report studio
• DevelopedDash Board reportsinReport StudiousingMDX Functions
• Designed&developedreportsfrom theData warehouseusingCognos8.4 report studio,AnalysisStudio reports.
• Trainedpower usersto useQuery StudioforAd-Hoc reporting.Trainedprofessional authorsto writecomplex reports using Report Studio.
• Created different types of prompts are value prompt, textbox prompts and select search prompts and multi select cascading prompt.
• Designed National Dashboard reportson the critical performance metrics in the path toward Best Quality, Best Service, Most Affordable and the Best Place to Work which make upthe KP Value Compass
• UpgradedFramework ManagerModels, Transformer Cubes and reports fromCognosVersion 8.3 to 8.4
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Used enhanced Cognos 8.4functionality in creating cube reports.
• Created Model procedures query subjects in framework manager and resolved related issues
• Design and Developed the Framework Manager modelsfrommultiple data sourcesand Published into server.
• Created, refreshed and supported CognosTransformer OLAP models and Power Play cubes
• Created Nested packages.
• TM1 Dimension and Cube Development Using architect, Perspective
• Tm1 Reports Development (Slice, Snapshot, Active Reports, Inspread sheet Browser reports)
• Integrating Tm1 with Bi
• Creating What if analysis reports using Cognos Insight and Cognos BI Workspace
• Providing Training to Business on Cognos Tm1 Reports and Insight Usage
• Created TI process and Loaded data into Cubes
• Written Rules in cubes
• Provided Securities.
• Created Reports using TM1 web.
• Interacting with theEnd userson a regular basis for resolving issues pertaining to the reports.
• Performance tuningby analyzing and comparing the turnaround times betweenSQL andCognos.
• Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Deployed Cubes and Reports on Power Play Enterprise Server and also Published to Upfront.
• Co-facilitate client workshops and training, typically small to medium group of clients
• Coordinating with Development Team tasks&Deliverables andworking on high priority issues.
• Installed and ConfiguredCognos8.4BIin multi-tier Environment.
• Testing and improving Report Performance.

Environment: TM 1 9.5.2 architect, Perspective, TM 1 Web, Cognos8.4/8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio and Event Studio),Cognos,Teradata data sources.

Confidential, Illinois

Cognos Developer

Responsibilities:

• Gathered report requirements from Business Users and converted them in to technical documents.
• Architected Cognos environment to meet end-client growth and usage needs.
• Involved in creating User groups, Roles and implementing security across the organization.
• Experience in meeting the availability numbers and Performance tuning all the Cognos environments.
• Created Database view and Business view for better understating of the model and help users with Ad-hoc reporting.
• Created Embedded and standalone filters and calculated columns.
• Implemented Package level Object level and Data Level Securities in the models.
• Developed reports involving Multi Query, Multi page, Discontinuous cross tab, Graphical, Repeater, Union queries, Dashboard reports with a very high level of detail and formatting.
• Built financial reports of other Cognos Applications like Analyst, Contributor and Performance Applications.
• Experience in setting job services and monitoring the performance of the applications
• Developing Framework manager packages and modifying the existing ones for use in building various reports.
• Developed Dimensional models to overcome the reporting difficulties of relational reporting for Balance sheets and Income statements.
• Involved in training users on Report studio, Cognos Connection.
• Installed and Administered Cognos 8.3/8.2 BI/EP multi server, medium user environment.
• Created documentation of installations and developments at all stages of the project.
• Testing and improving Report Performance.

Environment: Cognos 8.3/8.2 /8.1 BI, Series 8 Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric designer, Metric Studio, Event Studio, Power Play Transformer, Cognos Decision Stream Analyst, TOAD, Oracle 9i,MS SQL server, Windows 2003 Server, IIS, Active Directory.

Confidential, Portland, OR

Cognos Developer

Responsibilities:

• Involved in Designing models using Framework Manager and deployed packages.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager in ReportNet.
• Creating the Oracle 10g views as per the business and reporting requirement.
• Importing the Oracle 10g Views to the model and creating the relation between the views.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Created custom templates and custom toolboxes for the use of reporting.
• Customized Cognos Connection with appropriate reports and security measures.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Moved projects from development to QA and then Production servers.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in the Testing of the reports and updating the Bug Tracking Tool.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.

Environment: Cognos 8.2 BI Suite, Cognos FrameworkManager8.2, Cognos Impromptu 7.3, Cognos Power Play 7.3, Cognos Transformer 7.3,SQL Server 2005, Oracle 10g, Windows 2003 Server

Confidential

Cognos Developer/ Admin

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Installed & configured Cognos component such as the ReportNet.
• Administered and maintained Cognos IWR and Query applications in Windows NT and 2003 environment.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Migrated and deployed catalogs and impromptu reports to Cognos ReportNet.
• Building models and publishing packages in FrameworkManager to the ReportNet server.
• Development of filters, calculations, prompts, conditions, and created various reports, using CognosReport Studio.
• Writing the complex ETL queries using joins, unions, filters and variables in Decision Stream.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio and Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Used Tabular SQL for some of the Complex Reports In Report Studio.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Involved in Migrating catalogs, reports into report net using migration utility tool.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Portable Reports, Impromptu reports and ReportNet reports.
• Used Transformer with a variety of sources and combined them into Multi-DimensionalCube.
• Configured access manager namespace in Cognos connection and created new users and user groups in access manager
• Provided technical assistance, training and mentoring to Users and Business Partners.

Environment: Cognos ReportNet 1.1 MR3 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL Server 2000, SQL, PL/SQL, Decision Stream, EP7 series version 3, Windows XP/NT.