SUMMARY

• 7+ years of IT experience with different phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing and production.
• Extensive experience in the area of Business Intelligence using Cognos as a Analytical tool
• Excellent hands on experience with Business Intelligence tools like Cognos 8, Report studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Cognos ReportNet1.1,Decision Stream, Impromptu Administrator, Impromptu Web Reports (IWR), Powerplay, Transformer, Powerplay Enterprise Server(OLAP), Upfront, Access Manager, Directory Server
• Handled different types of domains like financial, healthcare, pharmaceuticals and banking.
• Extensive experience in installation & configuration of Cognos 8, ReportNet 1.1, EP 7 series, Transformer, Powerplay.
• Extensive experience with the Cognos 8 suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio) on Windows.
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing Database schemas like Star Schema/Snowflake Schema.
• Experience in migration of reports from Impromptu reports using Migration Utilities and mapping to corresponding metadata of ReportNet/Cognos 8.
• Experience in developing various reports like List reports, Crosstab reports, Maps, Dash Boards & Score cards.

• Extensive hands on experience with HTML and scripting languages like Java Script.
• Extensive experience in migration of crystal reports to Cognos(Report Studio and Query Studio)
• Experience in Deployment (Export, Import) using Cognos Connection Portal in Cognos 8 and ReportNet
• Troubleshoot issues with existing reports and cubes, administer application access directory and process requests for new accounts. Expertise on creation & maintenance of catalogs, which involves defining security, model, joins, governor settings, and client server balancing
• Worked on different data sources like Oracle 10g/9i/8i, SQL Server 2000/2005/2008, database access tool TOAD.
• Strong programming and debugging skills in Oracle Data Warehouse, PL/SQL, SQL.
• Developed Impromptu Reports and published into the web for end users using IWR.
• Customization of Cognos connection using System.XML file.
• Worked on Client Server Technologies and Web based solutions.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

Technical Skills

Tools : Cognos 8.4/8.3/8.2(Framework manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Portal Administration) , Cognos ReportNet 1.1(Framework Manager, Report Studio, Query Studio), Cognos Enterprise 7.1 series (Impromptu, Power play, Upfront, transformer, Access Manager, LDAP, Data Manager, Report Administration),Power play Transformer 7.4,Crystal Reports 8.5.
Languages : C++, C, SQL, PL/SQL, PHP, ASP.Net, Java
Data Modeling : Erwin, MS Visio
Web Servers : IIS 4.x/5.x, Apache, Tomcat, IBMIHS
Web Technologies : JavaScript, XML, HTML 4.0, Front Page, ASP.NET, VB Script
Operating Systems : Windows 95/98/2000/XP/NT, LINUX, Unix/AIX
RDBMS : Oracle 10g/9i/8.x, MS-SQL Server 2000/2005/2008, MySQL and MS Access.
ETL Tools : Informatica, Data Manager in Cognos

Work Experience

Confidentail,TX Sep 2008-Till Date
Role : Sr.Cognos Developer

Description:
The University of Texas at El Paso community is promoting partnerships through trust, respect, integrity, and credibility. The mission is to provide excellent customer service in all aspects of human resources. This is accomplished by performing as a team to achieve continuous, positive communication. The Aim of this project provides the Student information based on search criteria though out the University and Financial management of the UTEP. Created Monthly and Yearly reports with Actual and Target metrics based on Management score cards.

Responsibilities:

• Involved in understanding existing Business Model and Customer requirements by participating in the Design Phase and user requirement gathering.
• Retrieved the data from different databases like Oracle and SQL Server 2008 and created a data mart.
• Involved in modeling (star schema / snowflake schema) as for the user requirement using Framework Manager also created models using different hierarchies.
• Implemented Data Level Security through Framework Manager.
• Extensive experience in migration of Crystal Reports to Cognos using corresponding metadata of Cognos 8.4.
• Recreating the Metric Studio score cards to report studio by using Metric Package and provided the report level security.
• Developing complex reports like Drill Down, Drill Through & Dash Boards in report studio
• Developing different kinds of reports using calculations, conditional formatting, Dynamic Grouping, Conditional Blocks, Dynamic level filters on the reports in different formats (PDF, HTML, XML, Excel).
• Designed reports by using HTML, XML and also used JAVASCRIPT for prompt validations
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, Date & Time prompt).
• Designing model for Ad-Hoc report and implemented reports using filters, Drill down/up and provided security on the model.
• Provided different level of authentication and privileges to various user classes and users using LDAP.
• Used IQD files as a data source and Created Cube in transformer and analyzed in Analysis Studio.
• Provided technical assistance, training and mentoring to Users and Business Partners
• Monitoring Audit reporting based on users, reports and packages.
• Providing the graphical representation of reports based on metrics like actual and target in Metric Studio and Report Studio.
• Provided the drill through option to display the Chart in a new window based on metric name and customizing the filter options using JavaScript.
• Based on Crystal Reports functionality created Crosstab reports with Drill Down/Up in Report Studio.
• Involved in designing of Test Plans, Test Cases, and Executed Test Cases.
• Deployment of packages, folders and Reports from Development environment to Production environment using Content Administrator.

Environment: Cognos 8.2 & 8.4(Framework Manager, Cognos connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Access Manager),LDAP, Decision Stream, Power play Transformer 7.4,Crystal Reports 8.5,Informatica, SQL Server2008,Oracle 10g, SQL, HTML, JavaScript, Windows XP.

Confidentail, NJ Dec 2007 – Sept 2008
Role : Sr.Cognos Developer & Administrator

Description:
Merck. Inc is a global research-driven pharmaceutical company. Merck discovers, develops, manufactures and markets vaccines and medicines to address unmet medical needs.
The aim of this project is to provide numerous computer-generated reports and custom analysis to Merck with actionable conclusions, including demographic breakdowns such as size of vendor and number of contracts negotiated with Merck per year and also created report on stock information, Annual reports, proxy statements, Stock holder services.

Responsibilities:

• Involved in installation and configuration of Cognos 8.1 & 8.3 with Apache web server in AIX Operating System.
• Involved in understanding existing Business Model and Customer requirements by participating in the Design Phase and user requirement gathering.
• Imported data from Different databases Using ETL tool as Data Manager and created new database.
• Extensive experience in migration of reports from Impromptu using Migration Utilities and mapping to corresponding metadata of Cognos 8 and Resolved complex problems like calculations, filters, prompts, conditional styles in migrated reports.
• Upgraded Cognos 8.2 content store and frame work manager models to Cognos 8.3 using content administration.
• Published the multidimensional cubes to framework manager and scheduled power cubes monthly basis in Windows.
• Involved in modeling (star schema / snowflake schema) as for the user requirement using Framework Manager also created models using different hierarchies.
• Enabled the multi lingual feature to generate reports in user specific language.
• Implemented Security through Framework Manager and assigned users to the groups through Cognos connection
• Involved in creating Metadata models using Framework Manager and publishing the packages to Cognos Connection.
• Developed complex reports like Drill Down, Drill Through & Dash Boards in report studio
• Developed different kinds of reports using calculations, conditional formatting, conditional layouts and dynamic actions on the reports in different formats (PDF, HTML, XML, and Excel).
• Set up Security by creating Namespaces and User Classes in Access Manager and LDAP.
• Designed reports by using HTML, XML and also used JAVASCRIPT for prompt validations
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option of bursting of reports.
• Designed model for Ad-Hoc report and implemented security on the model.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.

Environment: Cognos 8.1 & 8.3(Framework Manager, Cognos connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Access Manager),LDAP,Informatica, Power play Transformer 7.4,EP 7 series version 3,SQL Server2005,Oracle 9i, TOAD, Data Manager,ASP.NET, SQL, HTML, JavaScript

Confidentail,NY Feb2007- Nov 2007
Role : Sr.Cognos Developer

Description:

Mellon Financial Corporation was one of the world's largest money management firms. It was in the business of institutional and high-net-worth-individual asset management, including the Dreyfus family of mutual funds. Developed Many Financial statements and Exhibits
Responsibilities:

• Involved in installation & configuration of Cognos 8 with Apache in windows.
• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain Cognos reports.
• Worked with Decision Stream and extracted data from different database and created own database and used that data base in frame work manager as a data source.
• Migrated numerous existing impromptu catalogs to Cognos8 Framework manager. Enhanced the model, Tested and created ‘replacement .IQDs’ using Framework Manager.
• Worked on Framework Manager to import data from heterogeneous data sources and created models & packages.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Created dimension maps and multidimensional cubes using impromptu’s Query Definition in Powerplay Transformer and Analyzed cubes using Analysis Studio.
• Migrated power cubes from Cognos 7.3 to Cognos 8 and updated them on a daily and weekly basis.
• Used JavaScript for customizing the search options and Prompt controls.
• Enhanced existing reports and created interactive reports using prompts.
• Created Master-Detail reports which had parameterized detail query or filtered detail query based on the requirements in report studio.
• Developed procedures & functions using PL/SQL.
• Generated payrolls of every month according to accounts section.
• Deployment of packages, folders and Reports from Development environment to Production environment using Content Administrator.
• Provided different level of authentication and privileges to various user classes and users using Access Manager.
• Involved in monitoring Audit reporting based on users, reports and packages.

Environment: Cognos 8(Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Power play Transformer, Access Manager), Decision Stream, EP7 series version 3, HTML,JavaScript, SQL Server 2005,Oracle 9i,SQL,.NET, PL/SQL, Apache, Windows.

Confidentail,NJ June2006-Jan 2007
Role : Cognos Developer

Responsibilities:

• Installed & configured Cognos Report Net 1.1 in Windows
• Involved in gathering requirements from the business users and analyzed them.
• Imported metadata from various sources like Relational Databases, XML Sources, and Impromptu Catalogs into the Framework Manager.
• Developed projects and packages in Framework Manager, published packages to Cognos Connection.
• Created Data source query subjects, Model query subjects.
• Imported data from flat files and generated transformations and loaded the data in data marts using Cognos data manager.
• Developed reports in various formats like PDF, CSV, and HTML and provided advanced features using JavaScript.
• Creating different type of Professional reports including (Mailing Labels, Web Page Style, Cascading, Linked charts, Drill Through, Production , Ranking etc..) with Complex formatting using Report Studio
• Created Alternate Drill-Down Path, Special Categories & Currency Conversion set up to better suit different user groups.
• Migrated Impromptu Catalogs and reports to ReportNet.
• Developed Scorecards and Dashboard reports using report studio.
• Created multi-dimensional cubes using Powerplay Transformer.
• Provided training to the remote users.
• Writing stored procedures and modifying the existing ones and tuning them for better performance and Worked on performance tuning of the reports.
• Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the Cognos Server.
• Used Tabular SQL for some of the Complex Reports In Report Studio.
• Worked on Cognos Security Administration to restrict the access to the users using LDAP Server.

Environment: Cognos ReportNet 1.1 MR4 (Framework Manager, Report Studio, Query Studio), LDAP, Powerplay Transformer, Powerplay, SQL Server 2000, Oracle 9i, SQL, PL/SQL, JavaScript, Windows XP.

Confidentail,VA Nov 2005 – May 2006
Role : Cognos Developer

Responsibilities:

• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Designed database in Oracle and imported data from different Excel Sheets
• Designed Impromptu catalogs and defined User Classes, Security and Privileges.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using Power Play Transformer.
• Provided security for Cubes of various User Classes.
• Created reports like List, Maps, Charts, Repeaters, Cross-tab using impromptu.
• Developed Impromptu Web Reports and published them using upfront.
• Developed OLAP cubes and templates for users.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts.
• Scheduled various tasks on a set date and time and at recurring intervals using Scheduler.
• Developed PL/SQL packages, Functions, Triggers etc.

Environment: Cognos Series 7(Impromptu, Powerplay, Powerplay Transformer, Scheduler, Upfront, Impromptu Web Reports), Oracle 9i, SQL, PL/SQL, Windows 2000

Confidentail,India Jun 2003-Sept 2005
Role : Cognos Developer

Role & Responsibilities:

• Involved in understanding existing Business Model and Customer Requirements by interacting with clients.
• Created new Catalogs using the Impromptu software and used them for reporting purposes in Cognos Impromptu.
• Customized data by adding calculations, Filters, Prompts and Governor Settings.
• Created time-based reports using Cognos Impromptu and Cognos Powerplay.
• Distributed copies of data in local snapshots, remote snapshots, thumbnails and hot files to improve the performance of reports.

• Generated IQD files to feed Powerplay Transformer Models to create Multidimensional Cubes to generate Powerplay Reports.
• Developed Models based on the dimensions, levels and measures required for the analysis.
• Executed scripts to refresh the cubes on a daily and weekly basis.

Environment: Cognos Impromptu, Powerplay Client, Powerplay Transformer, Powerplay Connect, Powerplay Transformation Server, Powerplay Enterprise Server, Upfront, Cognos IWR, Access Manager, Oracle 8i,Erwin4.0, PL/SQL, Windows 2000.