SUMMARY:

• 7+ years of Professional experience in IT Industry in Analysis, Design, Testing, Development, and Implementation of Business Intelligence.
• 7 years of experience in developing Cognos Applications wif expertise in Cognos tools such as ReportNet (Report Studio, Query Studio, Framework Manager), Powerplay, Transformer, Impromptu, Impromptu Web Reports (IWR), PPES, Upfront, Access Manager, and Scheduler.
• Created Business Intelligence Reports using Cognos 8.x/10.x, Cognos ReportNet, PowerPlay and Impromptu.
• Extensively used SQL programming to generate complicated reports.
• Hands on experience in creating Active Reports.
• Experience in Implementing Security at various levels in Cognos connection as well as in Framework Manager.
• Worked extensively in publishing the Cubes and reports on the Upfront through Power Play Enterprise Server.
• Involved in Metadata modeling using Framework Manager, creating Projects, Models, Packages, Security, Parameter mapping and developing Dashboards in Report studio
• Developed reports using Query Studio & Report Studio and creating Models in Framework Manager and publishing the packages on Cognos Connection.
• Worked extensively in publishing the Cubes and reports on the Upfront through Power Play Enterprise Server.
• Good Experience wif MDX Functions in Report Studio using Multi - dimensional Sources.
• Involved in full life-cycle Data Warehouse activities, including defining project roles and responsibilities, detailing project plans, requirements gathering and specification, logical and physical database design in both relational and dimensional, reporting requirements specification, and implementation / ongoing support tasks.
• Expertise in Data warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Hands on experience in Creating/Modifying/Managing the reports, users and user profiles and deploying the reports on the web.
• Proficient wif different databases like Oracle 12g/11g/10g/9i/8i/, MS-Access, MS-SQL, PL/SQL.
• Proficiency in administering and publishing Impromptu Web Reports (IWR) using Cognos Server Administration.
• Experience in different industry verticals like Healthcare, Retail, Insurance, Financial services and Technology
• Worked in a dynamic development environment, Strong Team Player wif a individual development capability.

TECHNICAL SKILLS:

BI Tools: ReportNet 1.0/1.1(Report Studio, Query Studio, Framework Manager) Cognos 8.x/10.x, (Power play, Transformer, Access Manager, IWR, Upfront, PPES and Scheduler), Cognos Lifecycle manager

ETL Tools: Cognos Data Manager V 10.2, Datastage V8.x/9.x, Informatica 8.6/8.1, OWG (Oracle Warehouse Builder)

Databases: Oracle 12g/11g/10g/8i/9i, DB2, Teradata 12.0, MS SQL Server, and MS Access 97/00/XP/03

Database Tools: Toad V 9.5/12.1, SQL server Management studio 2008/2012, SQL server

Web Servers: Microsoft Internet Information Server (IIS) 3.0/4.0

Programming Skills: C, C++, SQL, HTML, XML, JAVA scripting.

Microsoft Tools: MS Excel, MS Word, MS PowerPoint, MS project, MS Front page

Operating Systems: Windows 7x//XP/NT/2000/98, UNIX, LINUX, DOS

PROFESSIONAL EXPERIENCE

Confidential, CA

Cognos Developer

Responsibilities:

• Installed and Configured IBM Cognos Data manager V 10.2 on Windows 2008 R2.
• Created Cognos Databases/Schemas and Updated Schemas using Data Manager
• Created Data builds and Jobs inside Cognos Data Manager to Daily update Cognos Databases
• Worked on Windows Batch files to daily update cubes in Production Environment
• Worked Extensively on Cognos Workspace Advanced to Build Dashboards
• Scheduled Various reports on Daily/Weekly or monthly basis to send to different users inside the Organization
• Granted Permission/Access to different Cognos report authors inside the organization
• Provided Production Support and resolved regular issues in various reports and closed BI Team Tickets.
• Worked on Oracle Database tool Toad for SQL development and tuning.
• Created Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Worked wif Marketing, sales and Operations teams inside organization to discuss and analyze the report Requirements
• Deployed Models, Packages, Folders, Reports, Cubes and Data Sources from Development environment to production environment.
• Developed Balanced Scorecard and executive dashboards, as means for measuring activities and outcomes for effective performance management.
• Involved in review sessions and demos wif business users and draft design/solution.
• Responsible for various tasks including user communication, follow ups, reports and Power cubes Development, Testing and Document Preparation
• Used JavaScript’s in Cognos Report Studio to achieve complex and accurate dashboards and reports.

Environment: Cognos 10.2.1/10.2 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric studio Cognos Office Connection), Cognos Data Manger 10.2 Transformer 10, SQL, PL/SQL, Toad 12.1, Oracle 12g

Confidential, San Francisco, CA

Cognos Admin/ Developer

Responsibilities:

• Migrated cognos 8.4 reports to cognos 10.2
• Fixed all the reports which showed error during migration.
• Worked extensively on Cognos Lifecycle Manager to validate reports.
• Provided Production Support and resolved regular issues in various reports and closed BI Team Tickets.
• Generated various reports including List, Grouped, Cross tab, Chart and Drill -Through Reports.
• Develop various reports consisting of Complex charts and involving various filters.
• Created Saved versions for some of the reports (Report views) and scheduled jobs to run accordingly.
• Created and modified stored procedures in sql server management studio.
• Followed Step by Step approach of Upgrade Process for all the Dev, Test, Staging and Production
• Configuring Backup and Restore strategies for Content Store Databases and Cognos Configuration.
• Supported and Monitored the existing 8.4 environments in Production, Dev and Test Environments
• Reviewing User requirements from a technical perspective and identifying potential issues.
• Installed all the components of Cognos 10 suite products in Dev environment wif Application and Gateway on a single server and dispatcher in a another server
• Experience in installing Cognos 10 on multiple server environment, cloning the dispatcher.
• Extensively worked on performance tuning for the reports previously developed in Report Studio, Testing, improving Report Performance and performing Query optimization.
• Deployment of Models, Packages, Folders, Reports, Cubes, Data Sources from Development environment to production environment.
• Created List Reports, Cross-tab Reports, Dashboards, Chart Reports, Drill-Thru and Master Detail query Reports using Report Studio.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.

Environment: Cognos 10.2.1/10.2 , Cognos 8.4 Suite, (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric studio Cognos Office Connection) Transformer 8.4, SQL, PL/SQL, Cognos Lifecycle Manager, Sql server management studio 2012, Sql Server 2012.

Confidential, Washington, DC

Cognos Admin/ Developer

Responsibilities:

• Gathered, analyzed and mapped user requirements.
• Closely worked wif business users to understand the flow of business and cultivate a better understanding between the business and the reporting team.
• Used Framework Manager to model metadata from different data sources.
• Optimized the cube performance and involved in Performance tuning of the reports.
• Handling Development, Customization and testing of reports using Cognos BI Tools.
• Granting Permissions and implementing security to various users and report authors in Cognos Connection as well as in Framework manager.
• Worked wif SME’S (Subject Matter Experts) to determine functional report requirements.
• Writing functional specifications to provide design and development workflow.
• Worked on OLAP Cubes and also Dimensional-Relational Reports.
• Develop, document and maintain SQL Procedures.
• Maintained Development, UAT and Production Server.
• Worked extensively on Database Access tool TOAD to verify the data present in the reports.
• Stored the reports in iframes and the call them using JavaScript.
• Developed JavaScript to create tabs and Submenu options inside the Dashboard.
• Used HTML Tags inside Cognos Report Studio to Design various Objects.
• Extensively used edit SQL, main and base report concept, summary filters, detail filters and other available functionalities to efficiently report using Cognos Report Studio.
• Involved in complete Installation and configuration of Cognos 10.2 and setting up content store database and Active directory Configuration.
• Involved in the lower level testing of the data populated in the generated reports
• Provided post-production Support along wif enhancement and modification.

Environment: Cognos 10.2/10.1, Cognos 8.4 Suite, (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric studio Cognos Office Connection) Transformer 8.4, SQL, PL/SQL, Cognos Data manager, Java script, XML, HTML, Oracle 11g/10g/9i.

Confidential, Atlanta, GA

Cognos Developer

Responsibilities:

• Worked on Cognos Security Administration to restrict the Users.
• Extensively involved in customer support.
• Upgraded to Cognos 10.0 from 8.4.
• Created Cubes using Cognos Transformer, to do analysis.
• Created User Classes and Users in Access manager.
• Maintain the Cube Security using User Class Views.
• Implemented query optimization techniques to optimize the existing reports.
• Worked extensively to optimize the ETL process used for reporting.
• Performed analysis on the data model to find ways to optimize it for efficient reporting.
• Closely worked wif DBA for database tuning, implementing indexes to make sure that the reports are running fast and smooth.
• Drill through reports to drill down to the smallest factor, or key performance indicator.
• Member of the change management team.
• Used PL/SQL to analyze Queries.

Environment: Cognos 10.0/8.4, Transformer, Framework Manager, SQL Server, MS Access and Windows NT

Confidential, Wilmington, DE

Cognos Developer

Responsibilities:

• Used to interact wif users for requirement gathering
• Installed and Configured Cognos 8.3
• Involved in analysis, and design the technical specifications to create models.
• Defined governor settings in Framework Manager to tune the performance.
• Designed the 3 layer architecture for the FM model.
• Define join conditions, table aliases and views for the user requirement.
• Created and developed various reports like Business Mix Reports, Variance Reports, and Trend over Time Reports.
• Worked on Cross tab reports, drill-thru, linked-sub reports and sub reports (Complex reports).
• Worked on ERP applications (Oracle E-business Suite r12) on Oracle relational database management system.
• Created drill-through from Cube to relational and relational to relational
• Organized accessed data sources into Transformer models, Dimensional maps and developed Power-Cubes, which can be changed in many ways to Slice and Dice and drill-through data for further multi dimensional analysis.
• Used to write macros for scheduling reports.

Environment: Cognos BI Suite 8.3, Power play Transformer, Power play for Windows/Excel, Power Play Enterprise Server (PPES), Access Manager, Oracle8i, SQLserver2008, Windows XP.

Confidential, CA

Cognos Developer

Responsibilities:

• Replicated Cognos Report Net Security to Cognos Series 8.
• Maintained Security in Cognos Connection by controlling privileges for users, groups and roles.
• Involved in administration of servers using Cognos connection.
• Setup users wif security using Access Manager Administration.
• Involved in setting up User Groups/Roles in Access Manager to secure the Models, Packages and Reports.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Deployed the entire content store from development to test environment.
• Developed a Framework Manager model involving four schemas/databases called Loanstar, Appro, Empower and B2B.
• Resolved ambiguous, hierarchical and recursive relationships in the Framework Manager Model.
• Involved in design and development of filters, calculations and session parameters in Packages wifin Framework Manager.
• Created various packages wifin the same Framework Model.
• Developed List Reports, Cross-tab Reports and also some complex Reports using Master Detail Relationships and conditional formatting.
• Testing and improving Report Performance and performing Query optimization.
• Extensive unit and performance testing for the reports and fixing report bugs.
• Trained End users on Query Studio.

Environment: Cognos Reportnet1.1/8.3, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Scheduler, Access Manager, Facets, Oracle 8i/9i, PL/SQL, SQL Server, HTML, MS-Access, MS- Excel.

Confidential

Network Engineer/ Cognos Report Developer

Responsibilities:

• Interacted wif the customer to Gather and analyze user requirements.
• Designing, installation, and troubleshooting of networks.
• Installation of lease line Modems on HDSL (High Speed Digital Subscriber Line), ADSL (Asymmetric Digital Subscriber Line) and SDSL (Symmetric Digital Subscriber Line) Technologies.
• Configuration of CISCO Routers (800, 1600, 2600 and 3600 series) and switches.
• Created reports in Cognos Impromptu and PowerPlay related wif the sales department.
• Used filters, prompts, grouping, summaries and drill-through features of impromptu to generate efficient and user-friendly reports.
• Published reports to the upfront web portal to provide accessibility to the staff.

Environment: Windows NT, Exchange Server, Router (Cisco, D-Link), Cognos EP Series 8.0 (Impromptu, PowerPlay, Transformer).