Professional Summary:

• Over 5 years of experience in IT Industry with experience in Software Analysis, design, testing, development, documentation and implementation.
• 4+ years of experience with Business Intelligence tools like Cognos (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection and Framework Manager).
• Strong knowledge of Metadata models using Framework Manager and Dimensional Modeling.
• Extensively worked on developing and modifying various kinds of reports in Cognos 10.1 and Cognos 8.x Report Studio, Analysis Studio and Query Studio.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source.
• Strong experience in creating and publishing packages to the portal in Framework Manager.
• Strong skills in complex reporting, Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Achieved Drill Up and Drill Down in Report studio reports using DMR modeling.
• Experienced in developing Dashboard Reports in Cognos 8.
• Strong experience in business analysis and requirement gathering.
• Involved in System Integration Testing (SIT) and User Acceptance test (UAT) and coordinated with the Functional testing team and Load performance testing team.
• Knowledge and understanding of Oracle Database Configuration, Support, and User management in the development and production database environment.
• Experience in writing and debugging stored procedures and triggers.
• Possessed excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Self-driven and keen to learn and adopt new technologies and processes.

Technical Skills:

Reporting &Analysis: Cognos 10(Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight Advance) and  Cognos 8.x (Framework Manager, Report Studio, Query Studio, Analysis Studio)
Languages: SQL, PL/SQL Programming, HTML.
Methodologies: Star, Snowflake Schema.
RDBMS (databases): MS SQL Server 2005 and 2008, MS Access.
Operating Systems: Windows 7, Vista, XP, NT/2000/98/95, MS DOS.
Microsoft Tools: MS Excel, MS Word, MS Visio, MS PowerPoint, MS Access.
Multimedia: Flash, Dreamweaver.
Know About: Oracle 9i, ERWIN, Informatica, SSIS, SSRS, Apache Web Server 2.2, IIS 4.x/5.x, Power Play, Impromptu web reports.

PROFESSIONAL EXPERIENCE:

Confidential., Newark, NJ Oct 2011- Present 
Cognos Report Developer

Confidential. is a Newark NJ based financial service leader. It deals in property and casualty insurance, financial services, and real estate brokerage. Claims processing repots were the most critical repots as they were used by the actuarial department to decide the interest rate and the premium, and secondly these reports were submitted to the federal agencies for evaluations and compliance. These repots would mainly contain the information about policy holders, beneficiaries, claims and government flags.

Roles and Responsibility:

• Understanding existing business model and customer requirements.
• Work with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing reports.
• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Developed standard reports and analytics to meet the needs of business analysts.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Demonstrated the Spec Documents and obtained Sign-off from the Users.
• Involved in designing and modifying various projects in Framework Manager.
• Moving applications from one server to other using Deployment Manager.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures.
• Scheduled reports thru Schedule Management and Assigned user privileges using Cognos Connection.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Moved projects from development to QA and then Production servers.
• Involved in System Integration Testing (SIT) and User Acceptance test (UAT).

Environment: Cognos 10.1(Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight Advance), Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio), SQL server 2005, Windows server 2003, XP, Microsoft Office 2010.

Confidential, Bethlehem, PA Oct 2010 – Sept 2011
Cognos BI Developer
Confidential is the leading service provider for Telecommunication industry. Confidential will speed, simplify, and automate the telecom-service fulfillment and order management processes of activating their customers and delivering communications services across interconnected networks, focusing particularly on customers acquired through Internet-based channels. Worked on Local Number Portability project (LNP). Troubleshoot Customer Relations Management Tickets for already existing reports in Production.
Roles and Responsibility:

• Responsible for gathering requirements, writing specifications, developing reports, and coordinating with the production staff to publish the finished product to the production environment.
• Created Multidimensional reports by through DMR models.
• Performed Trend Analysis and GAP Analysis by creating complex reports.
• Configured Cognos 8 BI tool (Cognos Configuration, Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio)
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Created filters, prompts, sub reports, provide drill through capabilities.
• Developed Standard Reports, Charts, Drill through Reports, Cross tab Reports, List Reports, Summary Reports and Multi Object Reports using Report Studio.
• Created Web-based reporting solution that can address reporting needs using Dashboards.
• Extensively used Report Studio in designing Complex Dashboard Reports..

Environment: Cognos 8.4(Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Event studio,) SQL server, Windows 2000, Microsoft Excel, Microsoft Word.

Confidential, Pittsburg, PAFeb 2010- Oct 2010 
Cognos Report Developer

Confidential is a leader in its markets and diversified manufacturer that supplies paints, coatings, optical products, specialty materials, chemicals, glass and fiber glass around the world. Cognos BI reports that we developed targeting for the decisions of various business domains like finance, sales and provide complete analytical solutions. 

Roles and Responsibility:

• Involved in creating an ad-hoc query model for query studio users. Created and published various packages to meet different requirements.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters in Report Studio.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Developed Prompt Pages and Conditional Variables, Creating Query Prompts, Calculations, Conditions & Filters in Report Net.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Created complex reports based on business user requirements.
• Deployed the final product and set the report output requirements.
• Attended User Acceptance sessions, and worked on the feedback from the business users.

Environment:
Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Cognos Report Net 1.1(Framework Manager, Report Studio, Query Studio), Oracle 9i, Windows NT.

ConfidentialDec 2008 – Dec 2009 
Cognos consultant

Roles and Responsibilities:

• Customized Cognos Connection with appropriate reports and security measures.
• Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes.
• Design and developed the Framework Manager models and Published into server.
• Designed & developed reports from the Data warehouse using Cognos 8.4 report studio, Analysis Studio reports.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases. Used filters for efficient data retrieval.
• Trained power users to use Query Studio for Ad-Hoc reporting. Trained professional authors to write complex reports using Report Studio.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Modifying the existing reports based upon the change request by the user.
• Extensively worked with Stored Procedure Query Subjects in FM and Reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Administering the Servers – Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Design and Developed the Framework Manager models from different data sources and Published into server.
• Involved in deployment of applications to production, Troubleshoot the errors during the upgrade process.
• Interacting with the Cognos support team and creating & following-up the cases in the Cognos support site.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Oracle 8i, Windows 2000, MS Office.

Confidential May 2007 - Nov 2008

Responsibilities:

• Installation and configuration of SQL Server 2000 on Window 2000/NT OS.
• Implementing Backups and Restoring when necessary.
• Used BCP utility to publish table output to text files.
• Involved in creatingstored proceduresfor high system performance.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/dB roles and permission on various database objects.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Creation and management of Database Maintenance Plan for various database consistency checks.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Created Power Play cubes using Transformer (Power Play).
• Reporter Operations such as Sum and Average.
• Exception Highlighting, Sorting, Ranking etc.
• Changing filters, layers and measures.
• Created Multi-Dimensional reports using Power Play.
• Created Business Mix reports and Top ten reports.
• Involved in formatting reports and lay outs.
• Designed and developed multi-dimensional cubes.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Generated reports using Cognos Impromptu tools querying database.

Environment: SQL Server 2000, Enterprise Manager, Windows 2K, DTS, BCP, Cognos Impromptu 7.0, Impromptu Web reports (IWR), Power Play and Transformer.

Education: Bachelor of Engineering in Electronics and Communication