SUMMARY

• Professional with over 8+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications.
• Cognos certified and expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS 10.2.1, COGNOS 10.1,Cognos 8 suite.
• Expertise in Cognos 10/8 BI Suite (Framework Manager, Cognos connection, Report Studio, Business insight, Business insight advanced, Event Studio and Query Studio).
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and report building with Report Studio.
• Expert in using SQL for various data sources (like Oracle, SQL server) in development of reports, analyzing data in tables, cardinality between tables and joining tables.
• Good experience in relational, dimensional (DMR) and DQM (Dynamic query mode) modeling in Framework Manager.
• Good experience in creating and managing Conceptual, Logical, Physical Data Models, Data Mapping, Data Normalization, OLTP and OLAP databases and data warehouse.
• Customized the Cognos portal (Cognos Branding) working with CSS and XML files.
• Created queries and worked with PL/SQL Materialized view, Views, Stored Procedures, Functions, Indexes, Cursors and Triggers.
• Strong complex reporting skills - Complex Drill-Through, Cascading Prompts, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Have working experience on building the Active Reports, Business Insight Advanced reporting and Dashboards.
• Worked with Cognos problems and troubleshooting. Cognos Performance Tuning (JVM settings, Cognos Configuration settings), Security (Site minder) settings.
• Involved in migrating and upgrading Cognos reports from Cognos 8 to Cognos 10 Environment.
• Experience working with data load, creating workflow charts in SSIS and creating reports using parameterized queries, drill through reports and formatted SQL server Reports in SSRS.
• Worked with databases such as Oracle 8i/9i/10g/, SQL SERVER 2000/2005.
• Hands on experience with JavaScript.
• Experience with Cognos 8 Installations & Configuration.
• Experience with Scrum and Agile software development (SDLC) concepts and practices.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.2.1(Report Studio, Workspace Advanced), Cognos 10.1.1 (Report Studio, Cognos Connection, Active reports, Business insight, Business insight advanced), Cognos 8.1/8.2/8.3/8.4 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio).

ETL: SSIS, Informatica

Databases: Oracle 8i/9i/10g/11g/12c, PL/SQL, SQL Server 2000/5.0.

Operating Systems: Windows 2003 Enterprise Server, XP, Windows 2000, Windows 7,MS-DOS,UNIX, LINUX

Servers: Application Servers (WAS, Tomcat), IIS server.

PROFESSIONAL EXPERIENCE

BI Developer/SQL Developer

Confidential, OH

Environment: Cognos 10.2.1, Oracle 11g/12c Database, SQL Developer 3.2.2, Windows 7 Professional, HP ALM - Quality Center 11.00, Cognos Framework, Cognos Transformer, Share point, HPQC.

Responsibilities:

• Hosted, participated in meetings, working with users to understanding the business requirement.
• Creating Business Design document (functional document) and Business Analysis document (Technical requirement), get approvals from the business for development of the report.
• Creating Framework models and updating models to support enhancements or based on the client requirements. Publishing the package.
• Production support for the reports and resolve issues as per the tickets assigned.
• Developing Cognos reports as per the user requirements.
• Performance Tuning of reports and Framework models.
• Troubleshooting, fixed defects and documented Root cause analysis (RCA) of the defects.
• Created customized reports and enhancements for existing reports.
• Created complex SQL queries for Adhoc reporting-creating tables, indexes on compliance tickets with strict deadlines.
• Assisted customers in extracting and analyzing large complex data.
• Updated the DBA team on any configuration, data conversion issues and bad data.
• Validating, Debugging and troubleshooting the reports and the SQL.
• Coordinated with Cognos admin and Change Control team in deploying Cognosfolders and Reports from a development environment to Testing and Production environment.
• Updated windows batch files and FTP files to shared drive for users to access.
• Create batch jobs, scheduling, bursting of reports in Cognos connection.
• Developed test scenarios, test cases, test data to be used in testing based on business and user requirements.
• Created Development checklist for Quality Assurance before delivering to the end users.
• Coordinated with off-site team and assisting other team members.

Cognos Developer

Confidential, WI

Environment: Cognos 10.2.1, Cognos connection Report Studio, Oracle Customer Care and Billing Application, Oracle 11g Database, SQL Developer 3.2.2, Windows 7 Professional, Control-M.

Responsibilities:

• Hosted, participated in meetings, working closely with report owner and business users to understand the system.
• Understanding the utilities system and CCB application using functional, integration documents.
• Created technical specifications based on the user requirement.
• Gathered and analysis of information required for technical design, including the identification and evaluation of configuration items in the database required for reporting.
• Worked with dataware house team in datamodelling.
• Works closely with other teams to define configuration items required for reporting.
• Created List Reports, Crosstab reports, Multiquery reports, Standard prompts, Conditional prompts, Cascading Prompts, Drill through reports, Summary and Detailed Reports.
• Created reports using Unions, joins, filters, calculations, prompts and conditions.
• Wrote SQL queries for individual reports for testing and validation of reports.
• Formatting and Troubleshooting the reports.
• Creating Scenarios in the application for testing and data validation.
• Developed test cases and performed testing for the reports and assisted analysts in testing reports.

Cognos Developer

Confidential, CT

Environment: Cognos 10.1.1, Framework manager, Cognos connection Report Studio, Oracle 10g, SQLServer, SQL developer, Windows server 2000.

Responsibilities:

• Created technical specifications based on the user requirement.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source.
• Fixed the Framework Model for reporting.
• Tested report and database scripts using PL/SQL and query builder.
• Worked with the TM1 team for TM1 based reporting on Budgeting and Off Invoice reports.
• Created Complex List Reports, Crosstab reports, Multiquery reports, Cascading Prompts. Macro prompts, Summary Reports.
• Designed budget, forecast and actual reports using Conditional Formatting, Conditional Page layout, Sections, prompts, page Breaks, Drill Through.
• Created reports using joins, filters, calculations, prompts and conditions.
• Scheduling reports and Bursting of reports.
• Granted permissions and access to the reports based on the User.
• Formatting and Troubleshooting the reports.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.

Web Application/Cognos Developer

Confidential, NJ

Environment: Cognos 10.1.1, Framework manager, Cognos connection Report Studio, Business insight, Business insight advanced, Putty, Filezilla, SSIS, SSRS, Oracle 10g, SQLServer, SQL developer, AIX, UNIX, LINUX, Windows server 2000, Visual Studio 2010.

Responsibilities:

• Developed and Published Packages in Framework Manager - Connecting and testing the data source on Kimbal data warehouse system.
• Created Materialized views, Views and Stored Procedures, tested database scripts using PL/SQL.
• Worked with Drill- through Definitions to drill through in report studio reports.
• Discuss and generate reports according to business requirement.
• Created List Reports, Crosstab reports, Charts reports and Dashboards.
• Customized Cognos portal (Cognos Branding), using cognos XML and CSS files.
• Carried out Cognos Deployment of packages, folders, Reports and content store from a Development environment to Test and then to Production environments using AIX.
• Performance tuning of servers by Organizing dispatchers, setting processing capacity, JVM settings, Tomcat setting, config settings and Security Settings (Siteminder).
• Optimized the number of threads in Dispatcher for concurrent users.
• Worked with HTML/Java Script in Cognos report studio reports as per the requirements.
• Hands on experience in making changes in HTML and CSS and XML files for user interface changes using Visual Studio.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Created reports using parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Understanding and working with Key Performance Indicators (KPIs).
• Created, documented, and implemented unit test plans, scripts, Smoke testing, Performance testing and test harnesses.
• Experience working with IIS server and cognos integration to web.
• Strong complex reporting skills-Complex Drill-Through, Cascading Prompts, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Worked with Cognos problems and troubleshooting. Performed maintenance programming and correction of identified defects by trouble shooting.
• Worked and coordinated with the operate team for deployment and release.
• Experience with IBM request center (PMR) and customer care for resolving defects and issues.

Cognos Developer

Confidential, NY

Environment: Cognos 10.1/8.4/8.2 , Powerplay Transformer, Powerplay Windows, Oracle 10g, SQLServer 2000,Informatica, Windows server 2000.

Responsibilities:

• Analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements
• Installed & configured the Cognos 10.1 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Design and Developed the Framework Manager models using Stored procedures, Relational tables and published in to server .
• Created cubes in Transformer using Framework Manager IQD’s, packages and report studio reports as a source.
• Created DMR cubes using compatibility mode (DQM) functionality in cognos.
• Creating data sources using ODBC connections and generating the hierarchy for the dimensions.
• Worked with ETL team for developing various Mappings and Workflows in Informatica as required by the Design specifications.
• Customizing Cognos Connection Portal based on user specifications.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, prompts, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.
• Upgraded reports from cognos 8.4 to 10.1 version.
• Identified anomalies during upgrade, troubleshoot and fixed the reports.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Developed Dash Board reports in Report Studio.
• Involved in creating Oracle PL/SQL Stored Procedures, Functions, and Cursors for use by Framework Manager Packages and Report Studio reports.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.

Cognos Developer

Confidential, Bethesda,MD

Environment: Cognos 8.2/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer),Oracle 10g, Cognos Access Manger, Windows 2003 Server.

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Design and Developed the Framework Manager models on Kimball datawarehouse and Published into server.
• Design & development of the reports using Cognos 8 Report Studio, Query Studio reports
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Created Filters, Prompts, Calculations both at package level and report level.
• Developing Prompt pages and Conditional Variables
• Performance tuning by analyzing and comparing SQL and Cognos.
• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Experience in Migrating reports from Cognos EP Series 7 to Cognos 8 Environment.
• Involved into move to Deployment to UAT and Production.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Assurance before delivering to the end users.