SUMMARY:

• 8+ years of IT experience with sound knowledge and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production. Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions, Cognos 10.2.2, Cognos 10.1, 8.4, 8.3,Cognos 8.2, Cognos 8, Cognos ReportNet, Cognos Impromptu, Framework Manager, Access Manager, Transformer, Power Play, Cognos Visualizer, Cognos Scheduler, IWR, Cognos Query, Cognos Upfront.
• Experience with Cognos Analytics 11 (Report, Dashboard, Data Module and Stories).
• Experience in installation and configuration of Cognos 10.2.2, Cognos 10.1, 8.4, 8.3.
• Experience in designing models with Framework Manager involving Relational Models and Dimensional models.
• Deployed packages and reports from one environment to another environment (Dev, QA and Prod).
• Experience in converting MS Access Reports to Cognos Reporting from MS Access Database.
• Experience in Security Implementation in Cognos8, ReportNet, on various levels such as User level, Object Level, Row Level Security Implementation.
• Experience in installation, configuration and customization of different Cognos Environments especially Cognos TM1
• Expertise in Building Cube, Dimensions using TM1 Turbo Integrator processes.
• Expertise in building Executive Viewer and TM1 9.4 reports over a web environment
• Good experience with Data warehouse concepts, Star Schema, Snow Flake Schema
• Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Developed reports using System Development Kit (SDK) by java scripts and Eclipse at the back end.
• Used Cognos SDK to integrate the reports and java script.
• Experience on Running the SDK Scripts on Security.
• Experience with IBM Cognos SDK development and Business Intelligence Technologies
• Published IWR reports and Power Play Cubes on the portal using Cognos IWR report administrator and Power Play Enterprise Server.
• Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.
• Experience with Water Fall and Agile Methodologies.
• Involved in migrating Cubes, Power Play Reports from Cognos Series 7 to Cognos 8.
• Good understanding of RDBMS concepts and experienced in writing queries etc using Oracle, MS SQL Server, Teradata and IBM DB2 UDB.
• Developed PL/SQL database stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.
• Proficient in using best practices to support the reporting activities.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS:

BI Tools: Cognos Analytics 11.0.6/11.0.9, COGNOS Series 10.2.2/10.1/8.4/8.3/8.2/8.1 BI Suite, Go - Office, Report Net 1.0/1.1 MR2, Impromptu6.0/7.3, Upfront, Access Manager, Cognos Scheduler

OLAP Tools: Cognos TM 1 10.2.2/10.1/9.4, Architect, Turbo Integrator, Perspective, TM1 Web

Operating Systems: Windows 95/98/NT/2000/XP7/8, UNIX (Sun Solaris), AIX

Languages: C, C++, SQL, PL/SQL

Databases: Oracle8i/9i/10g/11.x,MS SQL server 2000/05/10/12, DB2 UDB, MSAccessTeradata 13.x/14.x/V2R6

Development Tools: TOAD, SQL Query Analyzer

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

Microsoft Tools: Microsoft Office, Visio, MS Excel, MS Word, MS Power Point

BI Tools: Data Manager 10/8.3/8.2, Data Stage 11.3 /8/7.5, Informatica 8/9

Other BI Tools: Tableau 9.03, Microstrategy, Business Objects 5.1

Methodologies: Ralph Kimball s Data Modeling, Star and Snowflake Schema Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Lewisvillie, TX

Sr. Cognos BI Developer/Administrator

Responsibilities:

• Involved in requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Involved in requirement gathering from Business Users and Developed Technical Documentation for the Business and Team. Analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.
• Installed and configured Cognos 10.2.2 with multi-tier architecture.
• Migrated reports and packages from Cognos 8.4 to Cognos 10.2.2
• Fixed the issues and bugs in migration process.
• Migrated content from Dev to QA and Prod.
• Troubleshoot and resolve the applications or integrations issues.
• Admin roles involve giving access to users for various groups and roles, monitoring the servers, on support calls etc.
• Installed fix packs for Cognos 10.2.2 on Dev, QA and Prod.
• Implemented Audit and Audit Extension for Cognos 10.2.2.
• Worked on the tickets open by users on various issues.
• Followed agile methodology for both the projects. Worked as FM modeler for Biostim and Biologics projects.
• Developed Cognos Framework Manager Model and packages for metadata layer using Cognos best practices.
• Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages
• Added business rules to the Cognos Framework models by creating calculations, filters, prompts, session parameters and parameter maps, cardinalities.
• Implemented object/row/package level security in Cognos Framework Manager models
• Created POC in Cognos Analytics 11 for Finance department.
• Migrated Biostim department all Cognos 10 reports to Cognos 11.
• Conducted training session on new features on Cognos 11.
• Created complex dashboards Biostim Stats with area charts, pie charts, crosstab and multi prompts in Report Studio.
• Used HTML items and Java scripts in the Dashboards and reports to make them every interactive and show more content during layering functionality.
• Created drill through reports for the pie charts created in the interactive dashboard as per the requirement.
• Developed Daily Auth Report, Daily Cash report for Sales Admin team.
• Created Active reports for Othofix direct to replace APPX manual functionality vs Automated system
• Created SSIS packages for Biostim tables. Converted some reports from SSRS to Cognos 10.

Environment: Cognos Analyitcs 11.0.6/11.0.9 , Cognos 10.2.2/8.4/8.3 (Frame Work Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Workspace, Advance), Power Play Transformer 10.2/8.4, Informatica 9.6, Oracle 11.x/10g, Teradata 13.x/14.x, SQL Server 2010, Business Objects, Oracle Apps R12

Confidential, Los Angeles, CA

Sr. Cognos BI Consultant/TM1 Developer

Responsibilities:

• Participated in meetings with client to understand and gather new technical requirement 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, Cross tab 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.
• 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 training 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), Cognos TM1 10.1.1 (Architect, Contributor, and Perspective), Informatica 8.6.1 and Oracle 10g.

Confidential, Atlanta, GA

Sr. Cognos BI Consultant

Responsibilities:

• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Designed Relational in Framework Manager.
• Used Determinants to join multi fact tables.
• Leveraged the functionality of Cognos Business Insight Advanced.
• Created Jobs and schedules reports and alerts for Sales team.
• Developed Event Studio reports to trigger emails based on success and failures of reports.
• Replaced the EZX functionality reports in BIA.
• Developed some BIA reports to test the functionality of Cognos 10 BIA.
• Developed Conditional Block Reports, Drill-Through Reports, Master-Detail Reports, Burst reports using Report Studio and Query Studio
• Created dashboard for Revenue department using Tableau desktop.
• Given training to users on Business Insight Advanced for query reporting.
• To improve the performance of the queries collected statistics in Teradata.

Environment: Cognos 10.1.1 (Business Insight, BIA, Report Studio, Query Studio, Analysis Studio and Event Studio), Cognos Connection, Frame Work Manager, Data Stage 7.5.3, Tableau 8.1, Windows Server, Teradata 12(Teradata View Point and Teradata SQL Assistant), Data Stage 8, Windows Server, Oracle 10g, Toad

Confidential, Wakefield, Boston

Sr. Cognos Developer/Administrator

Responsibilities:

• Worked with Business Analysts and gathered requirements for different clients and prepared the technical documents.
• Installed and Configured Cognos 8.4 on single and multiple servers on Windows platform for Bank, P&G, Kaiser
• Used IIS and Apache as the web servers.
• Implemented security, managing users, user groups and roles in the organization
• Provided security to the Cognos 8.4 using Active Directory
• Upgraded from Cognos 8.3 to Cognos 8.4 for Confidential and P&G.
• Production support includes monitoring all the client servers, rebooting the servers, troubleshooting, and load balancing.
• Opened tickets with helpdesk to create new user accounts and password reset for all the clients.
• Installed and Configured Cognos GO Dashboard for P&G.
• Created Audit database, set up the database connectivity and imported the sample Audit package and reports for all the clients.
• Created audit reports to view the information in a logging database about user and report activity.
• Designed models using Framework Manager and deployed packages to the Cognos8.4 server.
• Imported various sources such as Relational Databases into Framework Manager from Oracle 10g Database.
• Implemented row level security using Session Parameters.
• Created Dimensional Model Relational (DMR) and Relational Models for different clients.
• Developed 2 Tier models (Business Layer and Physical layers) for all the clients.
• Deployed packages from one environment to another (Dev to QA and Prod)
• Used various functionalities in report studio like drill through, conditional formatting, parameter displays, Conditional blocks, book marks, HTML items, Component layout reference, Rendering variables.
• Created Dashboards using various functionalities in Report Studio.
• Developed complex reports-Expand and Collapse report, Conditional Block Reports, Drill-Through Reports, Advance Sorting Reports, Dashboard Reports, Master-Detail Reports, Burst reports using Report Studio.
• Created reports in Event studio to monitor up and running of the servers.
• Created Audit database, set up the database connectivity and imported the sample Audit package and reports for all the clients.
• Created audit reports to view the information in a logging database about user and report activity.

Environment: Cognos 8.4 (Report Studio, Query Studio, Analysis Studio and Event Studio), MDX, Cognos Connection, Frame Work Manager, Power Play 8.4, Transformer 8.4, Go Dashboard, IIS, Apache, UNIX, Informatica 8.1, ERP-SAP BW, IBM Data Stage, Teradata V12, Teradata SQL Assistance, Oracle Streams,Oracle 10g, SQL Server 2005/2008, SSRS, SSAS, DB2 UDB, Aquadata Studio