SUMMARY

• 8 years of IT experience in Software Application Design, Development, Testing, Documentation and Maintenance of Business Intelligence solutions, OLAP tools, Data Warehousing (DW), Database, Client/Server applications with expertise in Cognos TM1/BI.
• 6+ years of strong experience in designing and implementing complex reporting solutions using Cognos Series (BI suite), including Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio.
• Data Warehouse/Business Intelligence experience using ETL, OLAP/Cognos 10.2/8.4 Series, Cognos ReportNet, Impromptu, IWR, Power Play, Transformer, Actuate, Decision Stream/Data Manager 10/8.3, Cognos 8 Go - Office, Informatica, Access Manager, Cognos Connection, Upfront on both Windows & UNIX Platforms
• 2+ Years of Migration experience from different environments (like Impromptu, Actuate) to ReportNet Environment and from Cognos 7.x/ReportNet to Cognos 8 BI and from Cognos 8 BI to Cognos 10.x BI.
• Experience inTransformer model design and Power play cube building.
• Expertise in creating Dashboard reports and using JavaScript in Report Studio.
• Designed & Developed TM1 Processes, Dimensions, Cubes and Applications.
• Expert in the development of reports and packages using Framework Manager, Report Studio, Query Studio.
• Strong reporting skills - complex Drill-Through, List, Crosstab, Summary, and Burst Reports.
• Experience with ReportNet/Cognos 8/10.x Software Development Kit (SDK) to customize reports
• Experienced in Auditing, monitoring, troubleshooting and production support for Reporting Applications and infrastructure.
• Knowledge on ETL development using Informatica Power Center for Data Extraction, Transformation and Loading (ETL).
• Strong Knowledge in Planning, Designing, Developing and Deploying Data warehouses/Data Marts by following Star Schema and Snowflake Schema Methodology with experience of both relational & multidimensional database design using Data Modeling tool Erwin (Physical and Logical data models).
• Experienced in User Acceptance Testing (UAT), Unit Testing and Integration Testing.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Highly proficient in Oracle SQL Developer, Oracle PL/SQL, Teradata SQL Assistant, including writing queries, stored procedures, functions and triggers.
• Extensive database experience using Oracle 11/10g/9i/8i, MS SQL Server, DB2, Teradata, MS Access.

TECHNICAL SKILLS

BI Tools: IBM Cognos 10.2.2/10.1/8.4/8.3/8.2/8.1 BI Suite, Go-Office, ReportNet 1.0/1.1 MR2, Impromptu 6.0/7.3, Upfront, Access Manager, SQL Server Reporting Services (SSRS)

OLAP Tools: Cognos TM 1 10.2.2/10.1/9.4 , Turbo Integrator, Perspective, TM1 Web, SQL Server Analysis Services (SSAS)

Operating Systems: Windows Family, UNIX (Sun Solaris), AIX

Prog Languages: C, C++, .NET, SQL, PL/SQL, T-SQL

Databases: Oracle 9i/10g/11.x, MS SQL Server 05/08/10/12, DB2 UDB, MS Access, Teradata 13.x/14.x/V2R6

SQL Query: Editors TOAD, SQL Query Analyzer, Oracle SQL Developer

Web Technologies: HTML, XML, JavaScript, VB Script, Microsoft FrontPage

Microsoft Tools: Microsoft Office, Visio, MS Excel, MS Word, MS PowerPoint

ETL Tools: Data Stage, Informatica Power Center, SSIS

Other BI Tools: Tableau

Job Scheduling Tools: Autosys, Tivoli, Control-M

SDLC Methodologies: Agile, Iterative, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr Cognos BI Developer

Responsibilities:

• Involved in requirement gathering from Business Users and developed Technical Documentation for the Business Team.
• Analyzed the specifications provided by the clients and developed specification documents for reports as per client requirements.
• Installed and configured Cognos 10.2.2 with multi-tier architecture.
• Migrated several reports from Business Objects to Cognos 10.2.
• Fixed issues and bugs that were present in the migration process
• Migrated content from Dev to QA and Prod environments.
• Integrated of the Cognos environments with Enterprise environments such as Proxy, Enterprise Portals, Web Single Sign-on (WSSO), and mobile devices.
• Admin roles involved giving access to users for various groups and roles, monitoring the servers, being present on support calls, etc.
• Implemented Audit and Audit Extension for Cognos 10.2.2.
• Installed Cognos SDK Kit on a computer where IBM Cognos BI is installed.
• Developed and enhanced the Cognos Portal using the Cognos SDK and developed POCs as required.
• Authored numerous reports in Cognos Studios, authored custom JavaScript code to customize prompts/reports and developed several custom Cognos SDK applications
• Worked with stakeholders and the ETL team to formulate the transformation rules for ETL development that best suited the reporting needs.
• Run an pilot upgrade to validate selected reports to see if the expected results are produced.
• Created rules using the rules editor and added Business Rules to Cubes
• Modified existing mappings and Created new ETL mapping (Extract, Transform, and Load) from staging data base and using change tables to be stored in the ODS/EDW: custom mods,Banner baseline tables, external data sources (outsideBanner).
• Created TM1 Application by adding TM1 objects and External files to an application
• Loaded and maintained Data in Cube using Turbo Integrator
• Optimized the Rule Performance by adding SKIPCHECK and FEEDERS. Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio
• Developed Framework Manager Models with Physical layer, Logical Layer and Presentation Layer to cater the various business needs (Folders, Filters, and Macros), appropriate relationship between query subjects and fact tables
• Led a team of 5 members and organized daily status and weekly status call meetings with an offshore team
• Worked on the tickets/incidents opened by users on various issues
• Conducted sessions to help users generate reports to meet their daily reporting needs

Environment: Cognos 10.2.2/8.4/8.3 (Frame Work Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Workspace, Advance), HIPAA, ICD 10, Facets, Health Care Claims, Power play Transformer 10.2/8.4, Informatica Power Center 9.6, Oracle 11.g,), ODS 8.3/8.5, Teradata 13.x/14.x, SQL Server 2010, Business Objects 4.2, Agile, Oracle Apps R12

Confidential, Boston, MA

Sr. Cognos BI Consultant

Responsibilities:

• Participated in meetings with client to understand and gather new technical requirements and conducted feasibility tests for the new requirements
• Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards, etc.
• Managed and assigned work to onshore and offshore resources
• Created various complex List Reports, Grouped Reports, Crosstab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding Prompts, Filters, Calculations, Summaries and Functions
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Delivered advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports) using Cognos 10.1
• Handled Critical situations in QA and Production Support in the final Stages of the project
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis
• Designed and implemented TM1 architecture for the corporate planning system and applications
• Worked extensively in development of Framework Manager Model for development of dashboard style complex reports like Dashboards, Region Enrollment, Division Enrollment, Milestones and Management Reports throughout the project
• Created solutions pertaining to financial budgeting, planning and forecasting, sales and profitability solutions for companywide analysis using Cognos TM1 suite
• Defined and created technical standards, guidelines and quality control measures for enabling and implementing 3rd Party software systems intobannersystem integrations
• Provided technical guidance and solution to junior developers in the team
• Managed data load, batch monitoring, cube refresh schedule and production support activities
• Planned and conducted user sessions for super level user. Trained users on TM1 Perspective, Cognos Query Studio and Event studio.

Environment: Cognos BI 10.1 (Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Business Insight and Event Studio), HIPAA, ICD 10,, Health Care Claims, Operational Data Storage (ODS 8.3) Cognos TM1 10.1.1 (Architect, Contributor, and Perspective), Informatica 8.6.1 and Oracle 10g.

Confidential, Indianapolis, IN

Sr. Cognos BI Developer

Responsibilities:

• Installed and configured Cognos suite including ReportNet, Cognos 8 and Framework Manager 8.2 / 1.1 MR3
• Developed more than 50 reports against the published packages while maintaining/supporting existing reports
• Updated old reports to meet current reporting standards
• Built models, packages and published them using Framework Manager
• Migrated reports from Cognos ReportNet to Cognos Series 8
• Involved in data migration between different versions of Cognos
• Worked extensively on the new features which came with Cognos 8
• Created complex reports using Report Studio including conditional blocks, conditional formatting, stored procedures, and materialized views
• Created Dashboards reports using Report Studio
• Created List and Cross-tab reports, Calculations, Conditions, Prompts based on the Business requirements
• Created Drill Through between Parent (Summary) and Child (Detail) Reports
• Created Multi-Dimensional cubes using PowerPlay Transformer
• Burst the reports and setup the distribution of sub list reports to various people within the Client
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction
• Involved in performance tuning and Production Support

Environment: Cognos 8.1/8.2 BI, Report Net 1.1,8.0, Framework Manger1.1,8.0 Query Studio, Report Studio 1.1,8.0, Analysis Studio 8.0,Event Studio 8.0 Cognos Connection 1.1, 8.0, Cognos ReportNet, Power Play 7.3, Power Play Enterprise Server, Transformer, PL/SQL, Oracle 10g,, SQL Server, Toad, Data Manager 8.0, UNIX, windows XP.

Confidential, San Francisco, CA

Sr. Cognos BI Developer

Responsibilities:

• Responsible for working with Business Analysts and Business Users to gather report specifications
• Installed and configured Cognos Suite of Tools.
• Prepared functional and technical specifications for the development of query subjects in Framework Manager, created different joins in the model to meet the client requirements
• Imported metadata from Oracle data warehouse
• Edited Governor settings to reduce resource requirements and improve performance in SQL execution
• Implemented data-level, object-level and package level security for restricting access to metadata and data across Cognos Report Net
• Assigned users, roles and groups for authentication and authorization
• Externalized query subjects for use in Cognos Series 7 transformer, created Impromptu Query Definition (IQD) files using Framework Manager
• Created and published packages in Framework Manager and deployed them on ReportNet Server.
• Created filter, prompts and calculations to customize the package for different report authors
• Created drill-through reports, master-detail reports, list reports, grouped list, cross-tab reports in Report Studio
• Indexed reports using HTML items in Report Studio
• Indexed reports in Report Studio using prompts and conditional blocks
• Implemented conditional formatting in the reports based on report layout and format
• Involved in the scheduling and bursting of reports
• Created prompt pages using text prompts, date prompts, cascading prompts and value prompts
• Used different charts formats i.e. graphical representation of data and repeaters as per client requirements
• Experience with parameter maps and session parameters in creation of multi-lingual reports
• Developed multidimensional power cubes in Cognos PowerPlay Transformer using different data sources
• Created user class view to provide user specific and relevant information
• Created PowerPlay reports in both explorer and reporter model
• Drill down to PowerPlay report through increasing levels of detail, then slice and dice to get different views of reports
• Implemented security by creating Namespaces and User Classes using Access Manager
• Provided technical assistance, and mentoring to Users and Business partners
• Data Modeling using Star Schema in Erwin.

Environment: Cognos 8.3 BI (Report Studio, Query Studio, Framework Manager, Connection), PowerPlay Transformer, Repot Net 1.1, Tableau 8.0.1, PowerPlay Windows, Access Manager, Oracle 10g/9i, Erwin 4.0, 7.3, SQL Server 2008, Flat Files, Clear Quest, Windows NT

Confidential, Novi, MI

Cognos Developer / Data Analyst

Responsibilities:

• Worked on Cognos 8.1 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Worked in Scheduling and Deploying (Staging to Production) Reports.
• Administering the business users in the portal based on the requirements.
• Production Support, which involves solving user problems.

Environment: Cognos 8.1 BI Suite, Cognos Report net 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Power Play Enterprise Server 7.3, Transformer 7.3, Oracle 9i.

Confidential, Minneapolis, MN

Cognos Developer

Responsibilities:

• Involved in the System Analysis, Design and Development of the project
• Created List, Group Report, Master and Detail, Cross Tab Drill-Through
• Created Cascade prompt
• Involved in creating Reports using Cognos Report Studio/Query Studio
• Created the reports daily, weekly and monthly basis
• Provided client reporting (Batch), Scheduling & On-Demand Scheduling
• Created weekly, monthly, quarterly and yearly reports
• Utilized Reporter Operations such as Sum and Average
• Made use of exception highlighting, sorting, ranking
• Used SQL tools like TOAD, Oracle SQL Developer, SQL*PLUS to run SQL queries and troubleshoot
• Created Database and Table structures for storing user information in SQL Server 2005
• Developed stored procedures and functions to accomplish several computations
• Involved in Testing and Debugging
• Involved in designing of Test Plans, Test Cases, and execution of Test Cases
• Created and managed Jobs and schedules

Environment: Cognos 8 BI, Report Net 1.1MR2, Framework Manger1.1MR2, Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Cognos Power Play 7.3, Power Play Enterprise Server Transformer, Scheduler, PL/SQL, Oracle 9i, DB2, Windows 2000/XP, UNIX.