SUMMARY

• Over 7 years of Professional experience in IT Industry in Analysis, Design, Testing, Development, and Implementation of Business Intelligence.
• 6 + years of experience in developing Cognos Applications with 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 (Report Net 1.1) 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.
• Hands on experience in Creating/Modifying/Managing the reports, users and user profiles and deploying the reports on the web.
• Proficient with different databases like Oracle 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 Insurance, Financial services and Technology
• Worked in a dynamic development environment, Strong Team Player with 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: Datastage V8.x/9.x, Informatica 8.6/8.1, OWG (Oracle Warehouse Builder)

Databases: Oracle 11g/10g/8i/9i, DB2, Teradata 12.0, MS SQL Server, and MS Access 97/00/XP/03, Oracle E-Business Suite r12 application

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, 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 with 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 with 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 with 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 with 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 with 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 with 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, Pasadena, 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 with 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 within Framework Manager.
• Created various packages within 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 with 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 with 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).