SUMMARY

• 8+ years of IT experience with strong 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 indepth 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, SnowFlake 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/12x, MS SQL server 2000/05/10/12, DB2 UDB, MS AccessTeradata 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, Sacramento, CA

Sr. Cognos BI Developer/TM1 Developer

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/Cognos11 with multi-tier architecture.
• Migrated reports and packages from Cognos 8.4 to Cognos 10.2.2
• Used Access manager administration to set up and maintain user classes/groups, users, server connection information and access to data sources.
• 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.
• Automated project requests by writing Perl and Unix Shell scripts.
• Develop batch processes for financial reporting applications and modules using Perl and Korn shell scripts on AIX interacting with Oracle database.
• Good knowledge on Shell Scripting.
• Installed fix packs for Cognos 10.2.2 on Dev, QA and Prod.
• Implemented Audit and Audit Extension for Cognos 10.2.2.
• Followed agile methodology for both the projects. Worked as FM modeler for Biostim and Biologics projects.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurate.
• Co-ordinate with ETL & support team to perform full refresh and manage database operations on Tableau server.
• Developed Cognos Framework Manager Model and packages for metadata layer using Cognos best practices.
• 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.
• 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
• Installed and Configured Cognos TM1 and various components.
• Creation of dimensions cubes and processors using TM1 architect for Finance department
• Developed User Interfaces, Reports, Rules and Turbo Integrator processes using Cognos TM1for Expenses, Revenues, Salary and Compensation, Headcount, Budget Variance and Summary.
• Worked with creating Business Rules that perform calculations, such as average price, currency conversions, and price/earnings ratios in TM1
• Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
• Solved most of the Complex part in TM1 and Cognos BI integration.
• Training resources on TM1 and Cognos.
• 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.
• Developed most of the reports along with the team, made them understand the requirements and deliverables.
• 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.
• Responsible for conducting pre sales presentations before C-level executives and winning an account
• Responsible for lead generation via user group presentations
• Created solutions pertaining to financial budgeting and costing, sales and profitability solutions for a big retail company using Cognos TM1 suite
• Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.
• Loading and Maintain Data in Cube using Turbo Integrator. Optimize 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.

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, Cognos TM1 10.2, 10.1, Turbo Integrator, Architect, TM1 Web, Oracle 11x/12, Teradata 13.x/14.x, SQL Server 2010, Business Objects, Oracle Apps R12

Confidential, Sacramento, 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
• 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.
• Pharmaceutical regulations across the world play an important role in ensuring the safety and efficacy of the approved drugs.
• Pharmaceutical regulations not only regulate the pricing of drugs but the quality as well.
• The regulations are required both for new innovations and already existing products, in order to improve health status.

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, Chicago, IL

Sr. Cognos BI Consultant

Responsibilities:

• Created Projects, Models, and Packages using CognosFramework 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, Framework 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

Cognos BI Developer

Responsibilities:

• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer.
• Used some advanced features likeConditional Formatting, Conditional blocksinReport Studioin generating multipage Reports.
• Implemented Star Schema grouping methodology and 2 layer/3-layer approach in Framework Manager.
• Worked on performance tuning of existing reports and models.
• Implemented report bursting to distribute reports effectively.
• Regular interaction with users and intensive user requirement gatherings.
• Developed more than 2000 reports including Active reports, Dashboard reports, dimensional reports using Report Studio, Query Studio, Business Insight, Analysis Studio.
• Designed and Implemented 40 Relational and DMR (dimensional) metadata models in Cognos Framework Manager using Cognos Best Practices.
• Developed reports using Power Play Studio, Drill down, slice and dice and change displays, Analysis of Power Play cubes in Analysis Studio.
• Successfully designed and implemented security on different levels including object and row level security.
• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication technique.
• Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
• Created Dynamic cubes using IBM Cube Designer 10.2.
• Developed advanced dashboards in business insight for commercial sales department which includes Activity, Alignment, Sales and Prescriber data.

Environment: Cognos 10.1, Cognos 10.2, Cognos 8x (Framework Manager 10.2, Cognos Connection 10.2, Powerplay Transformer 10.1, Dynamic Cubes, Business Insight 10.1, Business Insight Advanced 10.1, Report Studio 10.2, Query Studio 10.2, Dynamic Query Mode (DQM), Analysis Studio, Teradata 12, Netezza 7.2.0, Netezza 7.1.0, Motio.

Confidential

Cognos Developer

Responsibilities:

• Creating reports (Report/query studio) which cater to different employees at different levels.
• Report includes all types such ascharts(bar, bubble, line, lists etc).
• Analyzing the requirement and building complex SQL Quries.
• Dashboards andDrill-throughreports for the complete management hierarchy.
• Interacting with the user to get the detailed information about the issues.
• Preparing and testing the code to fix the issues in Development and QA environment.
• Involved in preparing Test scripts and validating the data based on the Scenarios.
• Performed thorough analysis of relational, multi-dimensional, and other data sources for business analysis, reporting, and presentation efforts
• Participated in IT implementation projects which intend to improve the day-to-day operations of the organization
• Created, designed and published reports using Cognos Report Studio, SSRS and Excel services
• Collaborated with project team, effectively managed the delivery of reports and accommodated any changes and new business requirements
• Created SharePoint Server 2007 User Guide for strategic management analysis and reporting technologies trainings
• 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.

Environment: Cognos 8.3, Framework Manager, Report Studio, Cognos Connection, Query studio, Analysis studio, Power play Transformer, Cube Report, Oracle 9i.