PROFESSIONAL SUMMARY

• IBM Certified Cognos10 BI Author.
• Over7 years of extensive experience in software industry focusing on data warehouse reporting environment such as design, development and deployment.
• Over 7 years of working experience with Cognos 8(8.4/8.3/8.2) (Report Studio, Analysis Studio, Query Studio, Cognos Connection, Framework Manager and Transformer), Cognos series 7 suite (Cognos Impromptu Administrator, Impromptu Web Reports (IWR), Power Play Transformer, Power Play Enterprise Server (PPES) and Access Manager.
• Experience in Migration from Cognos 7 series, ReportNet to Cognos 8 BI series. Experience in Installing and Configuration of Cognos8.4 on client-server architecture.
• Expertin Designing and developing Complex Reports (List Reports, Cross Tab Reports, Chart, Maps and Dash board) using Report Studio.
• Experience in creating Prompts, Cascading Prompts, Conditional Variables and Bookmarks with multiple Report pages and multiple Prompt pages in Report Studio.
• Created Complex Reports with advanced features such as Master Detailed sections, Conditional formatting, Render variables, Drill-trough, Page set, Cognos Functions and Bursting using Report Studio.
• Sound Skills in Developing Standard and Complex Dashboard Reports using Report Studio.
• Expertise in building analytical queries and reports to meet business requirements.
• Expertise in OLTP/ OLAP System Study, Analysis and E-R modeling, Developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in developing and publishing packages, managed security issues, designed metadata models created consolidated views and presentation views using Framework Manager.
• Proficient in Meta data modeling with Framework Manager and experienced in layered approach such as Physical Layer, Business Layer and Presentation Layer.
• Sound knowledge of developing Relational metadata models and Dimensional metadata models in Framework Manager using different data source.
• Expertise providing different levels of security such as data level, Object level and package level security in Framework Manager.
• Sound knowledge of designing and developing OLAP Cubes using Transformer.
• Experience on building and publishing customized cubesand optimize cubesaccording to business requirements.
• Knowledge of provide cube security according to technical specification.
• Sound knowledge of Cognos connection and its components.
• Experience in developing SQL queries, PL/SQL, Stored Procedures, Functions, Views and Triggers in Oracle (Toad, 9i,10g) and SQL Server (SQL Server 2005 & SQL Server 2008 R2).
• Sound Knowledge and experience in ETL tools such as SQL Server Integration Service (SSIS) and Infomatica 8.6.
• Experience in Retail, Financial/Banking/Mortgage, Healthcare, Insurance and Food & Beverage Industries environments.
• Self-motivated and excellent critical thinking ability, good interpersonal and communication skills.

Reporting Tools

Cognos BI 7 and 8 series(Report studio, Analysis Studio, Metric Studio, Event Studio,andQuery Studio, Cognos Impromptu) and SQL Server Reporting Services(SSRS).

Modeling Tools

Cognos Framework Manager and Cognos Transformer

Operating Systems

Windows 7/Vista/XP/ NT /98/95, MS-DOS, UNIX and Windows Server 2008 R2.

Languages

C/C++, SQL, PL/SQL, HTML, XML, Java Script and Visual Basic.

Databases

Oracle Toad/9i/10g, Microsoft SQL Server 2000/2005/2008and MS Access.

Web Application Servers

Apache Web Server, Tomcat 6

ETL Tools

Microsoft Integration Services (SSIS), Infomatica 8.6

Confidential,
Mooresville,NC Feb 12- Present
Sr. /Lead Congos Developer
Domain: Retail Services

Description: AMS Retail Solution, founded in 1999, is vendor representative team dedicated to increase sales of its clients. AMS has professional field staffs in US and Canada. The project’s primary objective was to create R.M. (Regional Managers) Dashboard and its main clients Bissell and Electrolux Dashboard. These Dashboards help management to allocate its resources effectively and efficiently to meet clients and AMS’s objectives in timely manner.

Responsibilities:

• Lead & Managed Cognos BI developer team to fulfill users’ requirements and request.
• Prioritized projects consulting with Upper level management and Users.
• Worked closely with Clients, Regional Managers and Business Analyst (BA) to gather business requirements and specifications for Dashboard.
• Worked closely with Clients, Regional Managers and Business Analyst (BA) to gather business requirements and specificationsfor Dashboard.
• Built prototype of each dashboard within short time frame to demonstrate and provide conceptual visualization and workflow of Dashboard to Users.
• Worked closely with DBA (Database Administrator) to identify relationship between required dataand used it in efficient manners.
• Designed and Developed metadata models in Framework Manager based on technical design specificationsto meet Users’ dashboards requirements.
• Created relationships between tables from different data sources consulting with DBA.
• Used Framework Manager to build new projects, relational models and packagesbased on business requirements and publish packages to the IBM Cognos connection.
• Designed and implemented security in metadata models as per Users’ and AMS’s requirementsin Framework Manager using row level security.
• Designed & developed complex Dashboardsusing Cognos 8.4 Report Studiobased on Users’ requirements.
• Developed Dashboards using lists reports, crosstab reports, chart reports and map reportsusing conditional formatting, drill through, filters, prompt, Cognos built in functions, SQL functions, HTML and JavaScript.
• Developed summary and detail reports for Dashboard to view Regional Managers’ (RM) and Merchandisers’ performance by Regions.
• Developed project completiondetail reports for Dashboard from TSER (Transition Survey Expert Reports) to view detail of each projects.
• Scheduled Dashboards and related reports and saved outputs for faster access.
• Worked closely with Cognos Administrator, DBA and System Administrator to ensure Dashboard and related reports security.
• Provided necessary permission for Dashboard users based on their requirements and roles.
• Involved in testing RMs’, Clients Cognos login to make sure no security is compromised.
• DevelopedCognos Portal pages foreach Dashboard and tested for integration and security.

Environment: Cognos 8.4(Report Studio, Framework Manager, Cognos Connection),SQL Server 2008 R2, Windows Server 2008 R2, Tomcat 6, Windows 7 Professional and Active Directory.

Confidential,
San Francisco,CA Sept10-Feb 12
Sr. Congos Developer
Domain: Financial Services

Description:Visa Inc., is a global payments technology company that connects consumers, businesses, banks and governments in more than 200 countries and territories, enabling them to use digital currency instead of cash and checks.The project’s primary objective was to support merchant card analysis teamin decision making process by providing variety of reports based on merchant segments, geographies, spending trends, loyalties and cards fee.Designed and developed variety reports in Cognos 8.4 according to Merchant card analysis team’s requirement and specification.

Responsibilities:

• Worked closely with Merchant card analysis teamto gatherbusiness requirements and specifications.
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions.
• Worked on technical design specifications for Framework manager, and reporting per the requirements.
• Used Framework Manager to build projects, packages based on business requirements and publish packages to the Cognos connection. Created relational models and dimensional models in Framework manager according to requirements.
• Designed projects in Framework manager based on two tier model (Physical view and Presentation view). Improved long running reports performance thruwriting SQL queries, resolving complex joins in framework manager, filters, and importing only necessary query subjects.
• Implemented package level security and object levelsecurity while creating models in Framework manager.
• Developed cubes in Transformer from IQD files and packages.
• Designed & developed reports using Cognos 8 Report Studio, Query Studio and Analysis Studio.
• Created various List Reports, Grouped Reports, Cross Tab Reports, Charts and Drill- through Reports using Conditional Formatting, multiple Prompts, Queries, Filters, Slicers,master-detail relationship, aggregation function and Cognos complex Functions.
• Created reports in Analysis Studio by using cubes and multi dimension models.
• Developed Dashboards and created Drill through reports from Dashboard to all summaryreports and Summary to Detail reports.
• Developed and maintained customized cubes and optimized cubes using Transformer to meet business requirement.
• Worked with cubes security issues and maintain security as technical specifications.
• Scheduled and distributed reports to the end users by schedule management in Cognos connection. Implemented bursting and event trigger function when it’s needed.
• DevelopedCognos Portal integration & Cognosportal design.
• Customized Cognos Connection with appropriate reports and security measures.
• Created user groups and roles in Cognos Connection and applied data level and group level security for various entries.
• Provided technical assistance and training to Users.

Environment:Cognos 8.4(Report Studio, Query Studio, Metric Studio, Analysis Studio, Framework Manager, Cognos Connection,Transformer 8.4), Informatica 8.6, PeopleSoft,SQL Server 2008 R2,Apache webserver, Windows XP and Linux.

Confidential,
Dedham, MA Feb 09- Aug 10
Sr. Congos Developer
Domain: Food & Beverages

Description: Papa Gino’s Inc.,based in Dedham, Massachusetts with more than 275 franchised and more than 5,000 employees, is one of New England\'s leading quick service Italian restaurant chain and the premier regional sub sandwich chain. The project involved developing company’s new standard operational, financial reports and statistics based on current and historical data for different groups of business user in near real time resulting improved financial planning, budgeting, optimizing labor cost and better customer service.

Responsibilities:

• Involved in building models using Framework Manager and creating simple to complex reports in Report Studio. Installed, configured and upgraded Cognos server.
• Created Database layer and Business layer inFramework Manager defining appropriate relationship between query subjects.
• Worked on Framework Relational models, (DMR) Dimensional, importing tables, views and store procedures.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Involved working in Power Play Transformer models using Flat Files, IQD files and packages as data sources.
• Designed Power Cubes, adding security to the Cubes and published Cubes and reports to Cognos connection.
• Extensively used dashboards with prompts, filters, conditional formatting, drill through and master detail relationshipsto meet business requirements.
• Worked onAnalysis Studio to develop multi-dimensional reporting.
• Participated in Technical Designing of Reports, developing Framework models migrating impromptu catalogs to Cognos connections.
• Performance Tuning of all Cognos Environments including Production, Development and Testing.
• Providedsupport for resolving technical issues for reports in report studio and query studio.
• Created indexes on the tables to extract the data quickly for the reports and developed PL/SQL Packages, Functions and Stored Procedures using Dynamic SQL.
• Created or maintained SSIS packages and used a visual development tool and worked on editingSSIS packagesusing a drag-and-drop user interface.
• Created the Event Triggers in Event Studio to run the Job sets.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Environment:Cognos 8.3/8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio, Transformer 8.4), Oracle10g (SQL, PL/SQL),SQL Server 2005, SSIS, Apache webserver, and Windows 2003 server.

Confidential,
New York City, NY Mar08- Jan09
CongosDeveloper
Domain: Financial Services

Description: American Express,headquartered in New York City, provides diversified global financial services best known for its credit cards, charge cards and travelers check. The project primarily focused on providing information about customers’ and businesses’ spending trends and habits to different management teams. Developed and utilized varieties of complex packages, reports and cubes from different data sources to meet the project requirements.

Responsibilities:

• Involved in Installation & Configurationof Cognos 8 tools in client server environment on Windows.
• Involved in requirement gathering and Developed technical specification documents based on functional requirements.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Design and developed metadata models inFramework Manager and Published into Cognos connection.
• Added Data Security, Object and Row level Security according to the requirements.
• Design & development of the reports using Cognos 8 Report Studio, Query Studio and Analysis Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed submission reports using List, cross tab, master-detail, chart, multiple Prompts, Filters, multi-page, multi-query reports against multiple databases
• Created Special Categories, User Class Views, Securities.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Developed complex Dashboardreports andDrill through to the multiple reports.
• Understanding the existing security structure of the company and implemented organizational security for Cognos environment (Folders, Models and Reports).
• Worked as a team towards finishing the tasks and achieving project deadlines.

Environment:Cognos 8.2 BI Suite(Query Studio, Report Studio, Analysis Studio, Framework Manager, Transformer7.4),UNIX, Oracle Toad, JavaScript, SQL, PL/SQL.

Confidential,
Portland, ME Oct 06- Dec 07
Congos Developer
Domain: Healthcare

Description: Martin’s Point Healthcare,a non-profit organization founded in 1981 and headquartered in Portland, Maine, Martin’s Point Health Care serves approximately 88,000 members and patients. Martin’s Point strives to keep people healthy, provide excellent service and find innovative ways to make the health care system more efficient and effective.The project involved providingvariety of reports to different users according to their requirements in timely manner for maintaining excellent healthcare service.

Responsibilities:

• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 connection.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Cognos Connection Portal.
• Implemented Framework manager security for Data access, Object level access and Package access based on the requirements.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Involved in Creating IQD filesusing framework manager and used those IQD files in Transformer to create varieties of Cubes according to organization’s requirement specification.
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Worked in Scheduling and Deploying (Staging to Production) Reports.
• Production Support, which involves solving user problems.

Environment:Cognos 8.2 BI Suite (Query Studio, Report Studio, Analysis Studio, Framework Manager, Transformer 8.0), Windows XP, Oracle 9i, JavaScript, SQL and PL/SQL.

Confidential,
OH Jan06- Sept 06
Congos Developer
Domain: Banking

Description: Fifth Third Bank,headquartered in Cincinnati, Ohio, is a diversified financial services company, with 1,232 full-service Banking Centers in Midwest. The objective of the project was to support HR managers by providing employees’ performance information reports. Created and distributed reports based on HR managers’ requirements.

Responsibilities:

• Involved in meetings with the user groups and designed Business Requirement Documents (BRD).
• Build up security both at package level, query subject level in Framework Manager, object level in the portal and also at the cube level.
• Developed IQD\'s in Framework manager and used them as data sources for building cubes in Transformer.
• Involved in Creating packages which connect to oracle database, establishing relationships in model, and publishing packages to Report Net server.
• Design and developed various reports using drill through, cascaded prompts, conditional formatting and master detail relationship.
• Generated Filters, Prompts, Calculations both at package level and report level.
• Worked on Migrating Impromptu catalogs to Framework Manager Models.
• Involved in Deployment and Administrative maintenance of the cubes, packages and reports in development, test and production environment.
• Implemented Impromptu Catalogs for various organizational cubes as well as detail drill-through reporting in Impromptu Web Reports (IWR).
• Worked with Cognos Connection for security, organizing, scheduling and distributing reports.

Environment: Cognos Report Net, Cognos Impromptu 7.1, Impromptu Web Reports 7.1(IWR), Cognos Power Play 7.1, Power Play Transformer 7.1, Power Play Enterprise Server 7.1, Cognos Upfront 7.1, Access Manager 7.1, Configuration Manager 7.1, SQL Server 2000, UNIX and Windows NT/2000.

Confidential,
IL Oct 04 – Dec05
Jr. Cognos Developer
Domain: Insurance

Zurich Financial Services, founded in 1872 and headquartered in Zurich, Switzerland, is an insurance-based financial services provider with a global network that focuses its activities on its key markets in North America and Europe. Through its offices in more than 50 countries, approximately 60,000Zurich employees serve clients in more than 170 countries.Createdconsolidated risk reports under supervision of Sr. Cognos developer to support risk management team and senior management.

Responsibilities

• Involved creating reports using Cognos Report Net to support the TEAM to meet the business requirements and time deadline.
• Created standard and Ad hoc reports using Cognos Impromptu toolto support Sr. Cognos developer’s requirements.
• DevelopedList Reports,Cross Tab Reports and Drill through reportsfor different risk analysis purpose.
• Created Dash board reports to get all the information from other reports.
• Developed chart and complex reports which involved Multiple Prompts, Filters, multi-page and multi-query reports.
• Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Worked in Scheduling and Deploying Reports according to risk management requests.
• Developed Cognos Portal integration&CognosPortal designaccording to different users’ requirements.

Environment: Cognos Report Net 1.1 MR1 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Access Manager, Cognos 7.1), Windows NT/2000, SQL andSql Server 2000

• Bachelor of Computer Application
• Master of Business Administration

References:

• Available upon request