SUMMARY

• Highly Skilled professional with over 8+ years of experience in Business Intelligence and DWH/Database Applications on multiple domains. Strong abilities and Hands on experience in analysis, design, testing, development and Deployment.
• Strong Experience with tools like TOAD for Oracle, and data modeling tool Erwin including 3rd normal form, Star schema and groupings. Understanding and analyze entity relationships, physical/logical data models, governance, data normalization/de - normalization.
• Proven Track record of troubleshooting and resolving complex Production and Performance issues
• Have hands on experience with BI architecture of Cognos.
• Strong working experience with Cognos 10.1 including active reports, Business Insight, Business Insight Advanced.
• Strong experience with Cognos 10/8/7/report net versions. Installed, Configured, Secured and Maintained Cognos 10/8/7 versions. Worked with Framework Manager, Cognos BI modeling, Report Studio, Query Studio and Analysis Studio for model design, Ad-hoc reporting and advanced report authoring.
• Interacted with Clients, Customers in the process of gathering and analyze business requirements and working on theirbusinessanalysis. Worked with Clients including Banking, Finance, and Healthcare, Pharmaceuticals, Insurance, Technology and others.
• Attended demo sessions of various products, analyzed the cost benefits, and pioneered the architectural design, development of applications, testing and implementation.
• Mentored and trained with demos and presentations to the Users for the successful execution of the project and build reports using Report Studio and Query Studio.
• Expertise in Migration of Content from Cognos series 8 to Cognos 10 and Upgrading versions.
• Expertise in meeting budget and scheduled tasks while still meeting or exceeding business requirements and goals with best practices.
• Strong experience in Cognos Series (Cognos Impromptu, CognosPower Play Transformer, OLAP Analysis, CognosPower Play, Cognos Scheduler, Cognos Access Manager, Upfront) along with Optimization and Performance Tuning.
• Strong Experience in Oracle 11g/10g/9i/8i/8.x, writing PL/SQL scripts, SQL Queries, TOAD, Stored Procedures, Functions, Triggers, for the database development and maintenance along with Performance Tuning of SQL Queries with good knowledge in XML, HTML,DHTML and Java script.
• Knowledge on working with java code.
• Experience in full life cycle project development (SDLC), including design, coding and development, testing and implementation, ongoing product support and troubleshooting issues.
• Excellent work ethics, well organized, self-motivated, quick learner, performance driven and Team oriented. Continually provided value added services to the clients through thoughtful experience and excellent Communication skills.

TECHNICAL SKILLS

BI TOOLS: Cognos 10.1.1 (Business Insight, Business Insight Advanced, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Framework Manager),Cognos 10.2 ( Cognos Workspace, Cognos Workspace Advance, Query Studio, Analysis Studio, Event Studio) (Impromptu, Power Play windows/web, Transformer Upfront), Access Manager, Report Net 1.1 MR3, MDX

Migration Tools: MigS7,Mig Deploy

Databases: Netezza, MS SQL Server 2005/ 2008, Oracle 11g,10g/9i, DB2, Teradata

Database tools: TOAD, PL/SQL Developer,Netezza

ETL/Data Modeling tools: Informatica Power Mart/ Power Center 8.X

Microsoft BI Tools: SSIS, SSRS,SSAS

PROFESSIONAL EXPERIENCE

Sr Cognos Developer

Confidential, San Antonio, TX

Responsibilities:

• Used Cognos 10.1.1 to develop Dashboards, list reports, Cross tabs, Charts.
• Created prompt pages for users in the report so that can can easily filter the data.
• Gathered the report specifications and created the reports according to the users they wanted
• Actively participated in Business meetings to gather the requirement and develop accordingly.
• Also used SAP crystal reports 2013 version 14 to develop reports
• Migrated all the Reports which are developed in the Actuate Report Designer to Crystal
• Used Rapid SQl 8.6 to validate the crystal reports against the power select database
• Did unit testing after developing the reports and performed all conditional formatting like Sorting, alignment’s, Font’s, suppress functions, suppress editor functions to write logics, Formulas, Prompt pages.
• Wrote Design Documents for the Reports which I have developed

Environment: Cognos10.1 (Cognos Workspace, Cognos Workspace Advance, Query Studio, Analysis Studio, Report Studio, Event Studio,), IBM Cognos Administration, SAP Crystal Reports 2013, Perforce 2014, Rapid SQL 8.6, Actuate Report Designer, Power Select, DB2

Sr Cognos Developer

Confidential, Cambridge, MA

Responsibilities:

• Used Cognos 10.1 to develop all the Financial reports
• Created different types of reports like list reports, chart reports, cross tabs reports, lot of prompt pages, dashboards.
• Only Cognos developer at this place so gathered the requirement by myself and developed the reports accordingly
• Actively participated in all the meeting with the Financial manager and developed the reports according to their requirement
• Acted as a lead in his whole projected as am the only one who was working as a cognos developer
• Configured Security for the clients based on their profile and availability of services
• Worked with the external data files and used these data file in the Cognos report studio by designing the files, data mapping and then publishing these new external files with the existing package in the report studio, means published the new package with the external data file
• Scheduled jobs and created events using the event studios
• Have documented the functional and design level document for the users and the technical team which explains the functionality and the usage of Cognos reports.
• Actively participated in helping and making the financial manager, users to explain how to run the reports and know about how the reports were useful to them.

Environment: Cognos10.1 (Cognos Workspace, Cognos Workspace Advance, Query Studio, Analysis Studio, Report Studio, Event Studio,), IBM Cognos Administration.

Sr Cognos Developer

Confidential

Responsibilities:

• Developed Reports by using Cognos Report Studio 10.2, Created Lot of List, Crosstabs, Active repots
• For the Dashboard Project Developed Dashboard Reports with minimum of 6 to 7 Prompt pages in a single Dashboard Report
• Validated the Reports against the data base by writing SQl Queries, as we were using two logical separators to separate the data for dashboard data and non- dashboard data.
• Rectified errors in the old package and Published new packages as there were some errors in the old package regarding the data
• Scheduled jobs and created events using the event studios
• Helped the business owners and the business users to know how to run the reports and how can they can run the report in different formats
• Gathered the report specifications and created the reports according to the users they wanted
• Created permissions like who can look the report, who can edit and who can just read the reports
• Was responsible for migrating the reports from dev to test and to production
• Documents all issues and suggestions reported by business users during UAT'sand unit testing

Environment: Cognos10.2 (Cognos Workspace, Cognos Workspace Advance, Query Studio, Analysis Studio, Report Studio, Event Studio,), IBM Cognos Administration,SQL server 2008 R2,MS Excel 2002,2007

Senior Cognos Developer

Responsibilities:

• Analyze current reporting architecture, use cases and design a new BI reporting solutions using Cognos10.1 on aDB2 environment
• Worked with business users to understand their reporting needs and explain/provide Cognos solutions
• Provided alternative solutions to overcome requirements vs. data issues/product limitations
• Worked extensively on cognos 10.1.1 VVM in Publishing data sources, transformations, views, SQL scripts, parameterized queries, packaged queries, definition sets, triggers, Virtual View Manager databases, and Web services
• Involved in development, performance management, and administration of database using Toad.
• Extensively worked with DW architects and ETL developers to design a data mart to support reporting requirements and created report specs (RS), data definition specifications(DDS), functional specs (FS) and Cognos framework manager specs (FMS)
• Worked with DBA and ETL team to explain the reporting requirements and design the data mart
• Created Cognos Framework Manager (10.1)models including data layers, business layers and presentation layers following Nike’s global business intelligence GBI standards and Teradata standards
• Developed Cognos Portal integration &Cognos portal design.
• Extensively worked with DW team to create indexes, consolidate multiple objected in to views to improve the FM model performances and reduce load and processing time on Cognos servers
• Created model query subjects, shortcuts, calculated fields, namespaces, folders and filters in appropriate layers in model to make it simple and more user friendly
• Analyzed and recreated more than 50 Brio and SSRS reports in to Cognos 8 BI using reports studio
• Created complex graph reports with multi select cascading prompts and drill through option to analyze purchase order information by regions, models categories
• Created complex trending reports to analyze Comerica's divisions operating over/under their capacities.
• Used dynamic data item / dynamic series (in graphs) and static prompts to consolidated similar reports/graphs to make those user friendly and reduce future maintenances
• Used unions to combined actual and projected data from multiple database objected in reports studio to create complex demand forecastinggraphs
• Created reports to analyze demand projections for future seasons based on previousfinancial data.
• Used tree prompts with in relational data to avoid having cascade prompts, conditional rendering techniques to give user the option to hide/display report columns and java scripts to modify the prompt pages
• Documents all issues and suggestions reported by business users during UAT'sand unit testing

Environment: Cognos 10.1, Cognos 8.2 (Report Studio, Query Studio, Framework Manager, Analysis Studio, Metrics Manager), SQL Server 2000, DB2, Query Analyzer, Toad 11.6

Senior Cognos Developer

Responsibilities:

• Study the current IWR reports to be replicated in Report Net.
• Gathered requirements by meeting with the Sales admins, Supply Chain Managers and Tech Services.
• Created different Data sources and Createdmetamodel using Framework Manager and created packages and published to the Cognos portal.
• Prepared a template for the report.
• Developed list reports, Drill through reports, Chart reports in Report Studio and Cognos 8.
• Reports were designed using Multiple Prompts and Filters and multiple queries.
• Unit tested the reports.
• Validated the reports using SQL queries against the database.
• Responsible for migrating the reports from DEV to TEST and TEST to PROD.
• Created groups and gave them access permission to the reports.
• Developed Scorecards using Metrics Studio for trending Analysis
• Used Cognos Analysis Studio 8 to allow multidimensional analysis and organized data in logical categories such as fiscal periods, sales regions and product groups
• Created Drill down through increasing levels of detail and view by different dimensions such as sales per region or by product to view and analyze data relationships graphically
• Provide solutions to existing Cognos Report migrations from Impromptu 7.3 to Cognos 8 using Migration utilities supported by Cognos.
• Created Metadata Models using Framework Manager for reporting
• Created custom prompted reports in Cognos Report Studio 8, and used Bursting to send reports to different user groups
• Documented the migration and portal customization.
• Worked with Cognos support on reporting software bugs and interim solutions.

Environment: Cognos 8.2 (Report Studio, Query Studio, Framework Manager, Analysis Studio, Metrics Manager), CognosReport Net 1.1 (Report Studio, Query Studio, Framework Manager), Impromptu 7.3, SQL Server 2000, Query Analyzer

Senior Cognos Developer

Responsibilities:

• Communicated with the business users to gather the requirements and analyzed the data
• Installed and Configured Cognos 8.3 BI in single server Environment.
• Involved in Dimensional Data Modeling using Erwin 3.5.2 Data Modeler
• Used Framework Manager to build metadata model, which could be used by Report Developers in the group
• Created and published several packages in Framework Manager
• Created and managed securities in Framework Manager.
• Involved in the entire project of migrating reports and cubes from Cognos 7 to Cognos 8.3 and creating project documentation for future use
• Developed Reports using Report Studio including conditional blocks, conditional formatting and Static Variables.
• Implementing the HTML items in the Reports to get the Dynamic Reports.
• Analyzed the reports to check if the data in the reports was accurate.
• Designed models by mapping business needs using Power play Transformer and created multi-dimensional cubes, Power Play reports.
• Involved in the performance tuning of SQL queries.
• Extensively used Cognos 8 Query Studio, Report Studio
• Implemented security and granted privileges according to user classes using Access Manager (Used LDAP Directory Server)
• Worked closely with requirements team and QA team in order to deliver the Reports
• Involved in the System Development and Administration Process.

Environment: Cognos 8.3(Framework Manager, Query Studio, Report Studio), Cognos Power play Transformer, Erwin 3.5.2, SQL Server 2005,Oracle 10g, MS Excel 2002, MS Access, Access Manager, LDAP (Directory Server).

Cognos developer

Responsibilities:

• Worked with Cognos 8 BI modeling, and web-based tools Report Studio and Analysis Studio.
• Installed CognosReport Net Migration Tool and migrated Impromptu catalogs using impcat2xml command.
• Migrated Impromptu reports to Report Net using migratetocrn command and deployed migrated reports to Report Net using deploytocrn command.
• Involved in migration/upgrade of Cognos 7.3 series content to Cognos 8 environment.
• Involved in Creating Content store, Installation and Configuration of the Report Net.
• Created Projects, Models, and Packages using CognosFramework Manager and deployed packages on Cognos Connection and tuned queries.
• Developed Scorecards & Dashboards using Metric Studio.
• Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization. Worked on bursting reports for the web users.
• Developed various dimensions, measures and calculation in Cognos Transformer, enhanced reports and cubes, solved query and cube build performance.
• Used Cognos Macros to maintain Cubes for their performance.
• Implementation of Impromptu reports and Power Play cubes using multiple queries.
• Optimized Catalogs using Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification, and Governors Settings.
• Imported power cubes from the Power Play enterprise server to Report NetCognos connection server.
• Scheduled Impromptu and Power Play reports to run on a monthly, weekly, and daily basis using Cognos Scheduler.
• For the Data Warehouse, we have used Informatica Repository Manager for creating repository users and groups, assigning privileges and permissions, managing folders and locks, and importing and exporting ODBC Data Sources.

Environment: Cognos 8BI, CognosReport Net 1.1MR2(Framework Manager, Report Studio, Query Studio, and Cognos configuration), Cognos Impromptu 7.3, Impromptu Web Reports 7.3, Cognos Transformer 7.3, CognosPower Play 7.3, PPES, Cognos Access Manager, Upfront, Informatica, PL/SQL, Oracle 9i,DB2,Ms-Access, Erwin, Windows NT/2000, Linux.

Cognos Developer

Responsibilities:

• Involved in requirement gathering from Business users and prepared documentations.
• Implemented modeling in Framework manager
• Implemented Relational modeling in Framework Manager and created query subjects, relationships, filters and calculations in the model.
• Setting up the security in frame work manager at package level, Query subject level.
• Involved in Migrating reports from Impromptu to CognosReportNet.
• Created various Reports based on Technical Specification.
• Created drill thru reports and enabled the drill-thru feature on the current master reports to manage more complex business reporting requirements.
• Developed Stored Procedures and Database Triggers in T-SQL
• Involved in the design and development of reports in Report Studio
• Published cubes and created Power play Reports for the web users.
• Implemented security using Access Manager
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Worked on securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace.
• Involved in testing of reports with the existing live data via VPN

Environment: CognosReportNet 1.1 Report Studio, Framework Manager, Query Studio, Cognos Connection Oracle 9i, Windows 2000 Server, MS Excel 2000