SUMMARY

• 10+ years of experience in IT Industry with experience in Software Analysis, design, testing, development, documentation and implementation of client server applications.
• 9+ years of experience with Business Intelligence tools like Cognos 10 & 8 Series, Report studio, Query Studio, Analysis Studio, Framework Manager, Cognos Workspace Advance, Cognos Workspace, Cognos Insight, Cognos ReportNet 1.1 MR1 Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Transformer, PowerPlay Enterprise Server (OLAP), Upfront, Access Manager and Directory Server.
• Extensive Experience on modeling Metadata with Framework Manager using COGNOS modeling recommendations as modeling Strategy.
• Created and published packages using Framework Manager and authored different kinds of reports including templates, list, Cross - tab, Conditional Block List Query Studio & Report studio in Cognos.
• Extensive experience in Designing and Development of OLAP Models using Cognos Powerplay Transformer.
• Hands on experience in migrating the Catalogs, Reports to ReportNet and in creating Crosstab and List Reports in ReportNet.
• Extensive experience in creating Catalogs, Reports and publishing of Impromptu Web Report (IWR) and Powerplay Web Reports.
• Troubleshoot issues with existing reports and cubes, Administer application access directory and process requests for new accounts. Expertise on creation and maintenance of catalogs, which involves defining security, model, joins, governor settings, and client server balancing.
• 6+ years of experience in SAP Business Objects XI R3.2/ R3.1/R2/ R1/ 6.5, Designer, Desktop Intelligence, Web Intelligence Rich Client, Info View, Central Management Console, Crystal Reports, Voyager, Crystal Xcelsius, Query as a Web Service
• Considerable experience in creating Repositories, Folders, Categories, Groups, Users and their privileges using Central Management Server and Business Objects Supervisor.
• Experience Setting up BO Repositories, Universes and Complex Reports using Business Objects Best Practices. Managing Security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using CMS.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server and MS Access.
• Strong programming and debugging skills in PL/SQL, SQL, JavaScript and UNIX shell scripting.
• Hands on Skills with Internet Technologies (EJB, JSP, Servlets, XML, HTML, DHTML and JavaScript) and Application Servers like Jakarta Tomcat 4.x/5.x, Web Sphere 6.0 and Web Logic 5.0/6.0.
• Working Knowledge of ETL Tools. Knowledge in extracting data from source systems (Oracle, MSSQL and DB2) and bringing it into the data warehouse utilizing an ETL tool like Cognos Decision Stream, Informatica, IBM Data Stage.
• Team and Independent player with excellent Organization and Interpersonal skills.
• Good analytical and communication skills and ability to work independently with minimal supervision and also perform as team member.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10 Series, Cognos 8 Series, Report Studio, Query Studio, Metric Studio, Analysis Studio, Framework Manager, Cognos Insight, Cognos Workspace, Cognos Workspace Advanced, Content Manager, Cognos Enterprise Planning Series, Impromptu, Cognos Power Play, Cognos Transformer, Upfront, IWR, Report Administration, Power Play Web, Access Manager.

SAP Business Objects: Business Objects 4.2, Business Objects XI 3.1, 4.0, Designer, Web Intelligence Rich Client, Desktop Intelligence, Query As A Web Service (QAAWS), Universe Builder, Cristal Reports.

ETL Tools: Data Stage, Decision Streams, Informatica.

RDBMS: Oracle 10g, Oracle 9i/8i.7.0, MS - SQL Server 7/2000, MS-ACCESS, IBM-DB2 9.5, DB2 10.5.

Programming Languages: C, C++, Java 2.0, J2EE (EJB, JSP, SERVLETS), SQL, PL/SQL and UNIX Shell Scripts.

Web Technologies: HTML, JSP and XML.

Web Servers & Application Servers: Java Web Server, IIS and Application Servers, Tomcat 4.x/5.x, IBM WebSphere.

Operating Systems: Windows 95/98/2000 Server/ Advanced Server, Windows XP, Windows 7 and Sun Solaris 2.6.

IDE & Test Tools: IBM RAD, SQL Navigator, Toad, Edit Plus, Notepad++, Eclipse 2.1/3.1, JUnit, JTest.

Data Modeling: Erwin Data Modeler 4.1, MS Visio Star Schema Modeling, Snow Flake Modeling, FACT & Dimensions, Toad Data Modeler.

PROFESSIONAL EXPERIENCE

Confidential, Roseland, NJ

Cognos Architect/Lead Developer

Responsibilities:

• Responsible for Cognos Architecture Solutions for the Cognos Projects and analyze the estimates for Cognos Development and Implementation of Projects.
• Reviewing the Business Requirements along with Technical System Analyst and identifying potential issues that would impact development timelines.
• Responsible for Creating the Active Directory Groups to satisfy the Reports Requirement needs for different Projects.
• Worked on Cognos Modeling using Framework Manager and developed different Packages using multiple Data Source Connections.
• Create Reports like complex list, crosstab, multiple page report, Drill thru reports, cascading prompts reports, Active Report and Dashboard reports.
• Developed Active Reports for analysis of Business performances.
• Worked as Deployment Coordinator for all the Cognos Projects and setup of user level Security on Cognos Web Portal by creating Active Directory groups project level.
• Created various Complex Dashboard Reports as per user requirements and implemented the conditional formatting in the reports.
• Implemented Data Level Security on Cognos Framework based on User authentication
• Worked With IBM Cognos Support to resolve the Environment issue and bug fixes of the Cognos 10.2.1 Product bugs.
• Responsible for designing Technical Design Document and the approval process based on the Functional Specification Documents.
• Developed many Proof of Concepts based on the business needs and provided the demo session to the end users to make them understand the functionality and all the Ad-Hoc Report features capabilities using Cognos Workspace Advance.
• Developed unit test/system test and user acceptance test templates and coordinated the testing efforts.
• Trained different user groups (Actuarial, Business Intelligence, Business Analytics) to understand the models and do the analysis of data.

Confidential, New York, NY

Senior Cognos Consultant

Environment: Cognos10, Framework Manager, Report Studio, Query Studio, Analysis Studio, Access Manager, IIS, Microsoft SQL 2008, Toad for SQL Server, Tortoise SVN 6.1, Erwin 7.2 Data Modeler, Visio 2010, Microsoft Office 2010, Windows 7.

Responsibilities:

• Review Business Requirements from a technical perspective and identify potential issues that could impact the development effort.
• Involved in organizing the Framework Manager model into several different business views based on end user requirements.
• Used Framework Manager to build models, packages and publish packages to the Cognos portal used for different reporting purpose.
• Used DMR modeling techniques in Framework Manager, and created Models, packages for Analysis Studio.
• Worked on Level - 2 Production support for Daily and Monthly reports.
• Create Reports like complex list, crosstab, multiple page report, Drill thru reports, cascading prompts reports and Dashboard reports.
• Responsible for creating packages which connect to different data sources, establishing relationships in model, and publishing packages to Cognos Connection.
• Created various dashboard reports as per user requirements and implemented the conditional formatting in the reports.
• Have used conditional variables to do the conditional formatting of measures/metrics, so that user can get better picture of the percentages, measures and metrics.
• Used Query Explorer to create or modify queries and to perform complex tasks, such as defining Union joins and writing SQL statements.
• Created Report studio Drill thru reports from Analysis Studio cube report and mapped the columns in the Cognos connection.
• Worked with Analysis Studio and Analysis Studio to Report studio Drill thru reports.
• Delivered multi stage technical documentation like Business requirement specification document, design documents, multi-level test documents and production support manuals.
• Developed unit test/system test and user acceptance test templates and coordinated the testing efforts.
• Trained different user groups (Sales, Business Intelligence, and Financial) to understand the models and do the analysis of data.

Confidential, Peapack, NJ

Business Objects & Cognos Architect

Environment: Business Objects XI 3.1, Designer, Web Intelligence Rich Client, Business Objects Infoview, Cognos 8.4, Framework Manager, Report Studio, Query Studio, Analysis Studio, Access Manager, IIS, Oracle 10g,Toad for Oracle 9.1,Microsoft SQL 2005, Informatica 9.1, Visual Source Safe (VSS) 6.0, Erwin 7.2 Data Modeler, Visio .0

Responsibilities:

• Interacted with end users regularly for requirements gathering.
• Tasks involved were maintaining the Environment, Universe Design as well as report development to suit the Business Requirements.
• Applied security features of Business Objects like row level in the universe so as to make the sensitive data secure.
• Designed and Created Contexts for resolving Loops as well as traps in the Universes.
• Extensively used Calculations, Break points, Drill down, @Functions and Formulas, Filters & Alerts for creating Complex Web intelligence reports.
• Used Sub-queries at the report level for one of the Business requirement.
• Worked on enhancing the Performance of SQL Queries in Oracle Server.
• Worked directly in the database to fix data issues at the View Level.
• Generated web reports in Info View using Web intelligence with Multiple Data providers.
• Created Schedules for the reports using Enterprise Id in CMC.
• Developed complex reports inWeb intelligence XIfrom multiple data sources as well as using combined queries at the report level.
• Worked with the business directly to make sure reports are meeting the Business requirements.
• Involved in testing for reports that were already developed to make sure the reports contain correct data.
• Modified existing reports based on the user’s requirement changes and successfully pushed them into Production.
• Used Import Wizard to migrate reports from Development Environment through Production.
• Created a Windows batch script to take Back-up of all the existing Universes as well as reports.
• Created Processes and standards to be followed while designing Universe as well as reports.
• Created a wide variety of charts like pie chart, 2d and 3d charts.
• Developed Dashboards with Xcelsius 4.5/2008 components using maps, Pie Charts, Staked Bar, List Views etc. creatively using best Xcelsius components effects for better interaction.
• Used Xcelsius to Visualize and to enhance the data presentation along with developing dynamic charts and graphics.
• Worked on building Xcelsius Dashboards on top of universes.
• Created Xcelsius dashboards for visual understanding of information and publish to BO Enterprise.

Confidential, NYC, NY

Cognos Lead

Environment: Cognos 8.4, Cognos 8.1, Framework Manager, Report Studio, Query Studio, Analysis Studio, Access Manager, IIS, JavaScript, Oracle 9i, SQL Navigator, Windows XP, Unix, Erwin Data Modeler, MS Visio, RAD 7.2, Altova XML Spy, ClearCase, ClearQuest.

Responsibilities:

• Designed and Authored interactive, complex reports sourced from relational and dimensional data using Cognos 8.
• Architecture and developed report templates that include standard report objects, queries and layouts used by report developers to author canned reports.
• Designed and created both relational and dimensional metadata models Using Framework Manager.
• Analyzed the existing model for potential modeling issues and standardized the business use view of the metadata before publishing.
• Implemented multiuser modeling in Framework Manager by branching and merging, using repository control and segmenting and linking.
• Worked on exploring the dimensions such as Drill down, Drill up, Drill down and up on nested categories, filtering the data etc.
• Worked on exploring the measures such as manipulating the measure, showing multiple measures as rows, columns or layers.
• Leaded upgrading of entire reports framework from COGNOS 8.1 to COGNOS 8.4 including model changes, report specifications and custom JavaScript validations.
• Monitored data quality, resolving problem data issues, and ensuring timely updates.
• Created List Reports, Cross-tab Reports, Chart Reports, and Repeaters, using Master Detail Relationships, multiple prompts, tabular set and tabular SQL in Report Studio.
• Designed reports using HTML and JAVASCRIPT for prompt validations, dynamic behavior of the prompts and custom layout of the report output.
• Configured the schedule of frequently used reports for managerial staff using schedule management tool in COGNOS.
• Defined user access and user classes for different user groups, to provide security using Access Manager.
• Trained business users in using the Query Studio to author simple reports, customize the basic layout, perform calculations and format the data used for day to day analysis in Work Force Management
• Interpreted business requirements and prepared technical design documents for numerous Reports with minimal impact to other systems.
• Trained technical and non-technical users on the use of COGNOS tools.

Confidential, NYC, NY

Cognos Lead

Responsibilities:

• Assisted during the RFP development phase (Request for Proposal) for the development of functional requirements and narratives, as well as to consolidate over 1000 RFP requirements.
• Envisioned, designed and developed the CTAP framework that provided dashboards and scorecard with metrics used by agency managerial staff.
• Co-ordinate with Agency Business requirement users to capture the requirements.
• Has created great value to the CityTime Agency users as a quality assurance method, and as a time and cost saving tool that aids in determining the application enhancements.
• Responsible for architecture design, user interface design using COGNOS Report and Analysis Studios.
• Designed and modeled the metal data models to be used in CTAP using Framework Manager.
• Assisted in tuning the Audit DB for improved performance owing to the large amount of data being captured and retrieved.

Confidential, PA

Sr. Cognos Developer

Environment: Cognos 8.2, Framework Manager, Report Studio, Query Studio, Analysis Studio, Access Manager, Oracle 9i, SQL Navigator, Toad Data Modeler, Windows XP, Unix, SAP Business Objects 6.5, Designer, Desktop Intelligence.

Responsibilities:

• Extensively involved in project plan meetings and discussions, for decomposing the reports system into well defined modules.
• Migrated Business Objects Reports to Cognos Reports
• Involved in full life cycle development process of reports development.
• Interacted with the client in system analysis, design and transformation of business requirements into reporting needs.
• Created a proof of concept that integrated the reports into Application with COGNOS URL, extJS to give user a seamless access of reports along with application in a single point of access.
• Assisted in creating a Selenium test Framework for unit testing the developer authored COGNOS canned reports including drill ups, downs and drill through reports.
• Developed and authored new complex reports and enhanced the existing Cognos 8 applications.
• Administered and supported reporting tools to provide reporting, ad-hoc query and dashboard solutions and capabilities to end users.
• Presented forecast Metrics in graphical representation to give user an easy understandability.
• Scheduled Summarized Reports for the use of management to analysis and to retain the credit checks.
• Involved in Model Enhancements for performing better usability Reports in perspective of Risk Management.
• Provided efficient quality assurance and testing of various system applications.

Confidential, NJ

Sr. Cognos Developer

Environment: Cognos 8 MR1, Framework Manager, Report Studio, Query Studio, Analysis Studio, Access Manager, IIS, Impromptu 7.3, Cognos Transformer, Power Play, Impromptu Web Reports, Upfront, Oracle 9i, SQL Navigator, TOAD 7.2, Windows 2000/XP.

Responsibilities:

• Creating and modifying catalogs, developing and analyzing a join strategy.
• Developed Customized Reports using custom conditions and functions
• Developed Power Prompts for Customized Report i.e. Date Prompts, Search prompts, etc
• Creating catalog prompts, filters, conditions, and calculations.
• Created User classes for customized reports and restricting the user access with help of user class privileges.
• Table weighting, query performance (Governor’s settings), Client server balancing.
• Published Impromptu report sets to Impromptu Web Reports servers, managed reports
• Sets and report security using Impromptu Web Reports - Report Administration.
• Planned system-wide security, create or converting users, user classes, access
• Privileges and add auto-access sign on information for data sources using Access Manager Administration.
• Generated reports using Cognos Impromptu tools querying database
• Worked on User Requirements, Design Specification, Unit / Integration Test Scripts, Trace Matrix and executed Installation and Operation Qualification documents.
• Hands on experience in publishing the impromptu reports on to the web.
• Creating charts and formatting the reports.
• Installation, Implementation and configuring Cognos BI server, Framework manager and configuring the Content Store
• Migrated Impromptu Reports to Reportnet.
• Designing, creating and maintaining Models in ReportNet
• Implemented complex repots with dynamic sorting and Grouping.
• Implemented drill through reports on Trouble Ticket Number and Breaker Number.
• Scheduling and busting of reports to have a single data fetch and report format.
• Defined user access and user classes for different user groups, to provide security using Access Manager.
• Created Standard Reports using Power Play.
• Worked on exploring the dimensions such as Drill through, Drill up, Drill down and up on nested categories, filtering the data etc.
• Ranking and sorting the data in reports.
• Drill down, slice and dice and change displays.
• Provided Training for Business Users to understand about the Standard Reports such as toolbar description, customized Report Capabilities, performing calculations and formatting the data etc.

Confidential 

Programmer Analyst

Environment: Eclipse, CVS, Java, JDBC, Servlets, AWT, Beans, JSP, JAKARTA Log4j 1.2.9, MS Access, Html, JavaScript, Windows 98.

Responsibilities:

• Developed a ‘Hospital Management System’ to automate the front office activities of a Premier South Indian Hospital.
• Responsible for developing modules including Patient registration, bed/ward allotment based on occupancy status and patient preferences.
• Configured Tomcat application server for deploying the application.
• Developed JSP pages and Action Servlets for HTML generation and for session management.
• Used JDBC to write DAO classes to retrieve and insert data into the database.
• Coding client side validations in JavaScript.
• Implement the Log 4j for logging events.
• Developed class diagrams for the system using UML and Rational Rose
• Developed reports include Invoice Printings, and Patient profiles. Assigned as lead developer throughout the design, analysis and coding phase of a Claims Processing System.
• Provided day-to-day support especially in developing on-demand reports based on physicians and management request.
• Assists in the coordination of implementation process when installing or upgrading systems and during the testing phase.

Confidential 

Programmer Analyst

Environment: Eclipse, CVS, Java, JDBC, Servlets, AWT, Beans, JSP, JAKARTA Log4j 1.2.9, MS Access, Html, JavaScript, Windows 98.

Responsibilities:

• Understand functional requirements.
• Design and document technical design for the functional specifications.
• Designed XML API for conversion of XML files to business objects.
• Developing JSP’s, Custom tags and Action classes using struts framework.
• Design and development of different applets
• Coded Java Servlets.
• Developed User Interfaces using JSP and HTML.
• Wrote Generic Request Handlers to handle actions performed by a user on a JSP Page.
• Involved in Error Handling using JSP.
• Used JavaScript for validation of JSP pages.
• Supported Maintenance and Bug fixes.