PROFESSIONAL EXPERIENCE

• Over 7+ years of experience in providing Business intelligence solutions such as Analysis, Design, Development, Deployment, upgradation, Testing, and Relational /Dimension Modeling.
• Strong Experience in Data warehousing project life cycle such as Data modeling, Data extraction, Reporting and Dash boarding.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies, worked on ETL Tools informatica and Data Stage.
• Strong in SQL, PL/SQL, T - SQL, Stored Procedures, Database Triggers and SQL * Loader.
• Experience in gathering Business requirements, Analysis, Design, Development, Testing and Implementation of Cognos applications and End-user training.
• Proficient in Cognos 10/8 BI software Installations, Configuration and Administering the Cognos Connection for security.
• Client facing / consulting skills, such as the ability to work with the business partners to translate business requirements into potentially complex technical solutions that meet or exceed those business needs.
• Strong understanding of Dimensional Modeling concepts and have Experience in dimensional modeling using Star Schema and Snow-Flake Schema
• Strong Knowledge in using TM1, Java, HTML, MS Visio 2003, MS Excel 2003.
• Proficient with accessing data in TOAD, Teradata SQL Assistant, MS SQL Server 2005 and implementing data solutions utilizing PL/SQL.
• Good knowledge in UNIX Shell scripting
• Excellent Verbal and Written Communication Skills have proven to be highly effective in interfacing across business and technical groups.
• Strong knowledge in Retail, Finance, Marketing and Human Resources.
• Proficient in RDBMS concepts, dimensional modeling, relational databases such as Oracle and MS SQL Server.
• Highly motivated, innovative, ability to adapt quickly to change, reliable & responsible.

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos 10.1/10.2.1/10.2.2, Cognos workspace, Cognos 8,8.2/8.4, Cognos ReportNet, Cognos Series 7 - Active reports, Business Insight Advanced, Report Studio, Query Studio, Analysis Studio, Business Objects, Hyperion, Crystal Reports, Metrics Studio, Framework Manager, Event Studio, Map Manager, Cognos Impromptu 7.x/6.x, Impromptu Web Reports (IWR), PowerPlay Transformer 7.x/6.0, PowerPlay Enterprise Server, Actuate Reporting 7.x/8.0, Tableau, Qlikview

ETL Tools: Decision Stream, Data Manager, Informatica PS 8.x/7.x/6.x,DTS,SSISRDBMSOracle 10g/9i/8.x, SQL Server7/2000/2005, DB2 and MS Access.

Operating Systems: Windows 95/98/2000/XP/NT, UNIX and Solaris

Design Tools: Erwin, VSD (Visio soft diagram)

Languages: C++, C, SQL, MDX, PL/SQL

Web ServersIIS 4.x/5.x:

Web Technologies: Java Script, XML, HTML 4.0, ASP, VBScript

ERPJD: Edwards, Oracle Financials, SAP R/3, SIEBEL

PROFESSIONAL EXPERIENCE

Confidential, Virginia beach, VA

Senior Cognos Developer / Admin

Responsibilities:

• Assisting the client, through analysis of their existing Data systems, challenges, and business needs. Documented the reporting requirements and interacted with Business users and collected business information and their requirements for developing the project.
• Analyzed the data needs and accuracy of the data for the report purposes.
• Acted as a bridge between the business users and technical users, translating the technical terms to business users and vice versa.
• Developed and maintained the technical design specifications of Meta Data Layer presentation and Report specifications documents with best practices
• Scaled the production environment from a single server to a multi-tiered architecture that included 4 application servers and 1 web gateway server to allow more concurrent users
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments. Crete/Maintain Cognos User classes and groups with Windows Role Based Structure and user account provisioning. Administered the Content Management - Created the Data source connections, maintained the migration of the content from DEV to TEST to PROD.
• Install/setup Cognos 10.1 software. Upgraded the Models, Reports and cognos 8.4 content from Cognos 8.4 to Cognos 10.1 Troubleshoot upgrade problems/fix issuesSecurity & Meta Data Modeling:
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis.
• Published IQD’s which are used as Datasources in Cognos Transformer to build a cube, by prepraring the Meta data in Frame work manager and externalizing the query subjects.
• Implemented Cognos independent row level security based on the Geography and Business units, from the database security tables.
• Implemented the Data level, row level and object level security and also administred the permissions given to the packages, Cubes, folders and reports.
• Enhanced the Framework Models and Transformer Model to suit the user requirements.
• Validated the Data Loads in the Cube using Analysis StudioReport Development and Adhoc report Support:
• Developed numerous multi tab, multi page, Mulit-Query, dashboard reports and regular reports based on the existing remedy database incident management system, with drill through functionality to the detail reports.
• Developed the dashboard reports and active reports with aggregate data metrics utilizing the 2D and 3D graphical UI.
• Added the Dashboard reports to the portal page and specified the order of the tabs that appear in the dashboard report portal. Converted the dashboards to Active reports in Cognos 10.2.
• Developed various dashboards with KPI using the latest cognos RTM (Real Time Monitoring) features.
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and Java scipts for the custom functionality.
• Created and managed agents, events and tasks using Event studio, which monitors the CMB data and performs the task when an event occur.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues and performance issues.
• Performed Unit testing on Dev and supported the users on UAT and Production
• Developed and Maintained technical documentation of the implementation.
• Assisted the users on Production for the latest enhancements and production fixes.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.

Environment: Cognos 10.1 & 10.2.2 (Framework Manger, Report Studio, Active Reports, Event Studio, Dashboard reports, Business Insight, Business Insight Advanced), Oracle 10g, Sybase IQ, Abinitio.

Confidential, Newark, NJ

Senior Cognos Developer

Responsibilities:

• Worked closely with the users, Business Analyst in gathering requirements, developing prototypes, getting the BRD approval and participated in project meetings.
• Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
• Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
• Built models containing query subjects, query items, namespaces and folders.
• Worked on integrating Cognos with java application using SDK for running and archiving reports for different submissions.
• Removed loop joins by creating shortcuts.
• Created model based calculations, filters and relationships to make it feasible for the report authors.
• Created complex reports using Report Studio, Analysis studio.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts (Pie Charts, Column Charts, Bar Charts, and Line Charts), Drill through Reports and Master Detail Reports using Report Studio.
• Built Customized Charts like age analysis and trending, Enhanced Report Layouts
• Created prompts, Calculations, Conditions, Filters using Report Studio.
• Created Query Prompts, Developed Prompt pages and Conditional Variables.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Scheduled and Bursted Reports on weekly, monthly basis.
• Worked on JavaScript in implementing various functionality
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Have used SQL Server 2005 Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Fine tuned SQL queries and reports for performance.
• Exposed to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for Oracle9i/8i, SQL Server2k databases.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.

Environment: Cognos TM1/9.5, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Java, Java Script, HTML, SQL, SSIS, PL/SQL, Oracle 11g, SQL Server 2K, Linux 5.4,Data Stage.

Confidential, New York City, NY

Senior Cognos Developer

Responsibilities:

• Cognos 8.4 installation and configured IIS, content store (SQL server database), security (namespaces), WebServer setup. Followed best practices in configuring the server and setting up the environment.
• Involved in requirements gathering from business users, report design, report development, and support of all client/server layers and components of the data warehouse.
• Planned an approach for functional documenting, categorizing and packaging the requirements.
• Involved in Designing and creating various models and Publishing packages in Framework Manager.
• Design & development of the reports using Cognos Report studio, Analysis Studio, Query studio, and Event Studio.
• Developed advanced reports using Report Studio.
• Developed active reports using Cognos 8.4 version in various environments.
• Created Dashboards in Report Studio to display the data interactively to the end users as per the business requirement.
• Added Prompts, Cascading prompts, filters, Conditional style, Drill Through to the reports using report studio.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed Burst reports, Drill through reports, Master Detail reports, in Report Studio based on the business requirements
• Developed Complex dashboard reports for various reporting requirements and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Tested and validated the report output against the database to measure performance of reports.
• Created Scorecards and metrics by using metric studio.
• Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
• Identified various dimensions and measures required for the generation of a cube.
• Published the Cubes to Cognos 8 and using Analysis Studio to analyze the data and creating the reports in Analysis Studio and Report Studio based on the published cubes.
• Involved in the Installation of Cognos components in various environments and also involved in Go Office Installation.
• Customization of Cognos connection using SDK.
• Maintained Roles and Groups in Cognos 8.4 and scheduled reports to publish, and managed Cognos Connection.
• Developed cube models in Power Play transformer, creating cubes and publishing the cubes to Power Play web and Cognos 8.
• Developed various HR reports - MTD, QTD, YTD, last fiscal year, current fiscal year reports.
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Involved in move the developed reports from Dev to UAT and UAT to production.

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection), Power Play Transformer 10, Informatica 8.1 power center, SSRS, Oracle10g (SQL, PL/SQL), DB2 v8, HP-Unix.

Confidential, Cleveland, OH

Cognos Developer

Responsibilities:

• Gathered end user requirements
• Created metadata model using Framework Manager and published packages in the Cognos 8.2
• Created calculation and filters in the metadata model to improve performance.
• Migrated Catalogs and Reports to Cognos 8 environment.
• Provided data security, object security and package security in Framework Manager
• Created complex report using Report Studio and ad hoc reports using Query Studio
• Worked on Drill Through from Report Studio to Report Studio in Cognos 8.2
• Perform validation of reports by using Query Analyzer
• Created dashboard reports in Report Studio and burst them to the Cognos Connection web portal
• Carried out bursting of reports to distribute reports to different end users
• Used IQD’s to create cubes and created reports in report studio
• Used Access Manager to provide security for transformer models.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos Connection in Cognos 8.2
• Worked on knowledge transfer and end user training.

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio), PowerPlay Transformer, Oracle9.0, Cognos Series 7.x, SQL Server2000, Windows2003

Confidential, Vernon Hills, IL

Cognos Developer

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3.
• Upgrading of reports from series 7.1 to series 7.3
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments (development, testing and production)
• Deployed the reports from development to QA and QA to production using deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 port lets.
• Administer user access protocols and created user accounts and access privileges

Environment: Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler, XML and Windows NT/4.0

Confidential

Cognos Developer

Responsibilities:

• Created Framework Manger Models and created and published packages into the portal.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created Impromptu Web Reports and published them on the web server and later on upfront.
• Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index Admin

Environment: Oracle 9i, Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, Cognos Connection, Query Studio, Report Studio), Cognos Impromptu Admin/User, Power play Transformer, Power play for Web/Windows, PPES, Cognos Reportnet 1.1, PL/SQL, Windows 2000

Confidential

Cognos Developer

Responsibilities:

• Created Packages and Folders in Framework Manager1.1 and published them to Cognos Connection.
• Gathered and analyzed business requirements from users and business community.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio 1.1
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating Adhoc Reports using Query Studio1.1.
• Catalogs were Optimized by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.
• Created filters, prompts, sub reports, provide drill through capabilities
• Creating User Classes and Restricting the user access with the help of User Class Privileges in the Governor settings.
• Worked on Star Schema Database Design.

Environment: Cognos Report Net 1.1MR2, Cognos Connection, Report Studio, Framework Manager1.1 MR2, Cognos Impromptu 7.1 MR3, Cognos Access Manager, Cognos Scheduler, SQL, PL/SQL, Oracle 8i, Windows XP.