SUMMARY:

• 7 plus years of diversified experience in Information Technology.
• Over 5 years of experience in Business Intelligence (Cognos) using wide range of tools.
• Experience in working in all the phases of Software Development Life Cycle (SDLC).
• Experienced in various SDLC methodologies like Agile, Waterfall and iterative.
• Involved in Installation & Configuration ofCognos in distributed environments on Solaris.
• Expertise in Cognos 10.x/8.x BI suite (Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Configuration), Framework Manager, PowerPlay Transformer, PowerPlay client.
• Experience in publishing PowerPlay cubes to Cognos 8 and reporting using Analysis Studio and Report Studio.
• Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts.
• Good experience in reviewing Business Requirement Specifications (BRD), Software Requirement Specifications, unit test cases and system test cases.
• Experience in Transformer model design and Power play cube building.
• Experienced in building Dashboard and Multidimensional reports.
• Experience in dimensionally modeling relational data sources (DMR) using Cognos 8 Framework Manager.
• Extensive experience in working with databases like Oracle, Sybase and SQL Server.
• Excellent SQL writing skills.
• Strong Knowledge of different ETL Tools like Informatica, Oracle Data Integrator.
• Excellent Web Technology skills such as XML, Servlets, JSP, JavaScript, HTML, VB Script.
• Ability to prioritize multiple tasks while meeting deadlines.
• Ability to adapt and learn new technologies and get proficient in them very quickly.
• Good communication skills to maintain productive work relationships with management, clients, team members and other groups.

Technical Skills:

Data Reporting Tools: Cognos 8.2/8.3/8.4/10.1.1 Reporting Suite (Framework Manager, Report Studio,
Query Studio, Analysis Studio, Event Studio and Transformer), Cognos 8
CPM (Metric Designer, Metric Studio), Access Manager, Cognos Series7
Operating Systems: Windows 95/98/2000/2005/XP/NT, Sun Solaris, Linux
Languages: C, C++, Java, PL/SQL
Web Technologies: HTML, XML, CSS
Scripting Languages: Java script, VB script, SQL
Server-side Technologies: Servlets, JSP
Framework: Struts 1.1, JFP 4.0
MS Office/Tools: Word, Excel, PowerPoint, Outlook, Visio, SharePoint
Databases: Oracle 11g/10g/9i/8i, SQL Server 2005, MS Access, Sybase
Configuration Management: Rational Clear Case, Motio CI

PROFESSIONAL EXPERIENCE:

Confidential, East Hanover, NJ June'12- Present
Sr. Cognos Developer

The purpose of US Reporting Project is to build a system for users (Field Level Managers/Directors/Analysts) to provide actionable information and insights rather than providing volumes of raw data. The system uses a guided analysis framework to assist the users in their daily and weekly activities. The reporting tool was developed for the field force using reports and dashboards with summary information, lists, graphs, alerts and various drill-downs

Responsibilities:

• Review and Analyze Business requirements.
• Developing and modifying reports using Query Studio and Report Studio.
• Build models/packages in Framework Manager to support canned and adhoc Reporting.
• Validating report results against database.
• Providing support to users for adhoc (Query Studio) reports.
• Tuning report queries for better performance.
• Design and Build Reports/Dashboards reports using ActiveReports.
• Onshore and Offshore coordination to assign tasks and status tracking.
• Involved in code migrations from environment to environment.
• Involved in creating user guides for Adhoc reporting.
• Created Reports with Drill through functionality, advanced conditional formatting , advanced prompts and master Detail relationships.
• Created Javascripts for implementing custom functionality and client side validations.

Environment: Cognos 10.1.1 Framework Manager, Report Studio, Query Studio, Oracle 11g, SQL Developer, HP Quality Center, Integrated Control Suite.

Confidential, Tampa, FL
Sr. Cognos Developer Oct'11-May'12
Risk Support Systems is a global unit member of Citi Risk Architecture and Mission is to provide support of excellence globally to all users or various credit and operational systems. Global Risk Reporting provides monthly information to support credit risk reporting for Citi.

Responsibilities:

• Review and Analyze Business requirements.
• Developing and modifying reports using Report Studio.
• Providing support to users for Query Studio reports.
• Create and modify models using Framework Manager
• Unit Testing reports built using Report Studio and Query Studio
• Migrating reports from legacy system.
• Tuning report queries for better performance
• Created Reports with Bursting functionality.
• Provided best practices for Framework and Report Design.
• Created scripts for client side validations for Canned reports using Java Script
• Created Active Reports in Cognos 10 as Proof of Concepts for offline
  reporting
• Created Reports using Business Insight Advanced and Dashboards using
  Business Insight
• Created Reports with advanced prompting, filters and Conditional Formatting, and

Master Detailed Relationship.

Environment:Cognos 10 Framework Manager, Report Studio, Query Studio, Sybase IQ

Confidential, Herndon, VA Jun'11-Sep'11
Cognos Developer
Confidential, is a private for profit educational institution in United States. Strayer University offers undergraduate and graduate programs in accounting, acquisition and contract management, business, criminal justice, economics, education, health services, administration, education, and more. Strayer University offers a wide range of degrees, programs and certificates to meet the varied needs of its students. CRM Module at Strayer University supports the marketing strategy to plan the business and analyze the performance.

Responsibilities:

• Reviewed and Analyzed Business requirements.
• Created reports in Report Studio using Relational and Dimensional Models.
• Created reports with advanced prompting using tokens, filters and Conditional Formatting.
• Create Dimensional and Relational Models in Framework Manager
• Generated IQD's for cube models in Framework Manager
• Created cube models using PowerPlay Transformer
• Created agentsusing Event Studio to enable event based scheduling.
• Created Multi dimensional Analysis reports using Analysis Studio
• Created drill through definitions for Cube packages and Relational Packages
• Created reports with drill through functionality in Report Studio
• Created reports with Master Detailed Relationships.
• Created reports with Multiple queries.
• Unit testing Reports against the DB by writing SQL queries

Environment:Cognos 8.4, Cognos Transformer 8.4, Active Directory , Oracle 11g, Windows Server 2005,SQL developer, IIS, Tomcat, Data Stage 7.5 .

Confidential, Secaucus, NJ May'09-May'11
Cognos Developer/Administrator

• The Management Information Systems (MIS) project at NYK Line supports the management personnel to plan the business, to analyze the performance, and to make informed business decisions based on results from the analysis. The MIS application for NYK Line focus on the data coming from source application, and the Cognos is used as BI tool to present this data to management users in a standardized, summarized format.

Responsibilities:

• Involved in Installation & Configuration of Cognos in distributed environments on Solaris
• Involved in business requirement discussions and reviewed business requirement documents with the business team to understand the architecture and functionality of the application
• Created Framework Manager projects using XML's generated by Erwin Models as data sources
• Create ROLAP/DMR (Dimensionally Modeled Relational) models using Framework Manager
• Created reports from DMR models using Dimensional Functions.
• Generated IQD's for cube models in Framework Manager
• Created cube models using PowerPlay Transformer
• Created Event Studio agents to enable event based notifications
• Created adhoc reports using Query Studio and Report Studio
• Created Analysis style reports using Analysis Studio
• Created Reports with advanced prompting, filters and Conditional Formatting and Master Detailed Relationship
• Designed and Developed Analysis Type reports using Multi Dimensional data sources
• Created drill through definitions for Cube packages and relational packages
• Created reports using Multi Dimensional data sources
• Involved in migration of cubes from series 7 to cognos 8.4
• Performed basic administrative tasks such as adding users, scheduling reports etc.
• Developed shellscripts to build Power Cubes on server in batch mode
• Developed JavaScript snippets as part of conditional formatting
• Troubleshoot Cognos Server Environment for the better performance
• Unit testing of cube Analysis and Reports against the DB using SQL.
• Managing the dispatchers and services in distributed Environment
• Created SQL scripts to provide raw data to users.
• Troubleshoot the server Environment by using logs

Environment:Cognos 8.2/8.3/8.4/10.1, Cognos Transformer 7.4/7.5/8.4/10.1, iPlanet, Oracle 10g, Sybase, Solaris 10,SQL developer, Toad, Tomcat 4.0, Apache Webserver 2.0.55,Erwin.

Confidential, Malden, MA Dec'07-Apr'09
Cognos Developer
Adult and Community Learning Services (ACLS),a unit of the Massachusetts department of elementary and Secondary education,funds programs in Massachusetts to provide educational services to adults with academic skill levels below 12th grade, and/or adults who need English language skills to succeed in our communities. Through both federal and state grants, ACLS funds a broad network of education providers/programs, including local school systems, community-based agencies, community colleges, libraries, volunteer organizations, correctional facilities, and others. To manage and be accountable to funds received, the department has internally developed a system called 'SMARTT' or the 'System for Managing Accountability and results through technology'.

Responsibilities:

• Analyzed and Reviewed business requirements with users
• Created Business Requirement Document (BRD) and Function Specification Document (FSD).
• Built Models in Framework Manager, Imported metadata from different data sources into these models
• Developed Complex list reports, crosstab reports and customized reports using Report Studio
• Developed ad-hoc reports in Query Studio
• Worked with dimensional modeling of relational data sources (DMR) using Cognos 8 Framework Manager and create cubes using Framework Manager.
• Designed and Developed Analysis Type reports using Multi Dimensional data sources
• Created Analysis reports from Cubes using Analysis Studio
• Created Batch scripts to schedule cube builds
• Created Jobs to schedule reports
• Created Reports with bursting functionality
• Administered Security using Cognos Access Manager
• Created drill through reports/drill through definitions and implemented conditional formatting in reports
• Designed Power Cubes using Cognos Transformer
• Wrote SQL queries to validate data in Cognos reports with database
• Responsible for documenting all the processes and provide training manuals

Environment: Cognos 8.2, Framework Manager, Report Studio, Query Studio, Analysis Studio, Toad, Event Studio, Oracle 9i/10g, Windows NT/2000, IIS, Web Logic Application server, Cognos Transformer 7.3/7.4.

Confidential, Bellevue, WA Jun'07-Nov'07
Cognos Developer
Confidential, is parent company to some of the world's leading travel companies, providing travel products and services. They own and operate a diversified portfolio of well-recognized brands - including Expedia.com, Hotels.com, Hotwire.com, Trip Advisor, Expedia Corporate Travel, Classic Vacations®, and a range of other US-based and international businesses. Together, these popular brands and innovative businesses make Expedia, Inc. the largest online travel agency in the world, the third largest travel company in the US.

Responsibilities:

• Reviewed Business requirement documents with the business team to understand the architecture and functionality of the application
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements
• Business view and published the packages using Framework Manager onto Cognos Connection.
• Implemented Security with LDAP and group level security in Cognos Connection Portal
• Created Jobs to Schedule multiple reports in Cognos Connection
• Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill trough reports and conditional formatting to highlight the business needs
• Reporting Powerplay cubes in Analysis Studio and Conditional formatting of cube reports in Report Studio
• Used different objects like Conditional Blocks, Tables, HTML item, Hyperlink etc to create complex reports
• Extensively worked on scheduling and deployments
• Involved in designing and developing cognos power cubes in Transformer
• Created procedures, views, tables and functions to support reporting needs
• Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation

Environment: Cognos 8 Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Series 7 Transformer, Toad, JavaScript, Oracle 9i/10g, MS SQL Server 2005, Windows NT/2000.

Confidential, Hyderabad, India May'06-May'07
Citi Project
Java Developer
Web Vision is a multi-year initiative designed to transform online offering to cardholders and prospects through multi-generational delivery of best-in-class sales / servicing capabilities and new methods to drive key business metrics such as market share, acquisitions, activation, usage, retention, cross sell, and cost savings (CPA, elimination of some paper mailings, processing and call centers).

Responsibilities:

• Responsible in design and development of Click-to-pay Services in Visual IDE Tool Software (Rational Application Developer) with Java Struts framework using Unified process development methodology
• Designed and developed software user interfaces with Java Swing components and software code using Rational Application Developer
• Designed and developed software saved data format in XML
• Designed class objects hierarchy and relationship, state and process UML model using Borland Together J modeling tool
• Responsible for Release management and tracked using Clear case
• Worked with project managers in implementing the UP process of the software development life cycle
• Worked with QA team in producing development test-cases and test-plan

Environment: Java/J2EE, Struts1.1, JFP4.0, Oracle8i, Websphere6.0.2.15, Rational Application Developer v6.0, Clear Case, SVN.

Confidential, Hyderabad, India Apr'05-May'06
Confidential
Java Developer
Confidential, is a leading world class financial services that offers a unique combination of services to protect, preserve, and enhance the assets of individuals, companies and institutions worldwide. Citco intends to develop a "Next Generation Application for Custodial Services" that can cater to the growing demands of the online banking and custodial services industry.

Responsibilities:

• Designed, developed and maintained Cerner Health Facts web application using Java Servlets
• Developed data access object with ODBC, JDBC and Oracle PL SQL
• Implementation of the code from JSF to struts framework
• Unit tested the application code
• Fixed and resolved code defects in the application
• Wrote technical design documentation

Environment: Oracle 8i, RAD, Java, Struts1.1, JSF, Solaris, Windows XP.

EDUCATION:
Bachelors in Computer Science Engineering