SUMMARY

• Over 8+ years of experience in IT industry in all phases of software development life cycle developing various Data Warehouse, Business Intelligence applications, Business objects and Client/Server applications.
• Expertise in Cognos 8 BI suite and Cognos 10.2.1 (Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Configuration), Framework Manager, PowerPlay Transformer, PowerPlay client.
• Excellent understanding and hands - on experience of Extraction, Transformation and Loading ETL of data into Data warehouse/Data Marts/ Online Data Stores using tools like Informatica and Data stage.
• Experience in Full Life Cycle Project Development, including design, coding, testing and implementation and ongoing product support.
• Experienced in working with Dynamic Query Mode and compatible Query Mode.
• Expertise in working with Oracle 11g/10g/9i/8i, SQL server databases on UNIX, Linux and Windows enterprise platforms.,
• 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.
• Proven ability to develop and implement Enterprise Planning and Business Intelligence solutions that support wide variety of Business Functions.
• Experience in analyzing business needs and translate them into technical specs and maintain the information flow in the team.
• Expertise in developing standard Reports and Templates, Dashboards, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query studio.
• Expertise in Unit Testing, System Testing, Functional Testing, User Acceptance testing, and Testing Documentation.
• Abreast with latest technologies, Applications, Procedures in the Cognos enterprise planning environment.
• Expertise in installation and configuration of Cognos 10.2.1, Cognos Report Net and EP 7 series suites.
• Team player and self-starter with strong work ethics, excellent communication and development skills, flexible, adaptable to all kinds of stressful environments with ability to work independently.
• Strong design and programming technical skills, ability to learn new emerging technologies and adapt quickly.

TECHNICAL SKILLS

Reporting tools: Cognos 10.1.1 Mobile, Cognos 10 Suite (Cognos Workspace, Cognos Workspace Advanced, Cognos Connection, Business Insight, business Insight Advanced, Life Cycle Manager 10.2, IBM Cognos Administration), Cognos 8 BI suite (Enterprise Planning Analyst, Report studio, Query Studio, Analysis studio, Framework Manager), Power play, Power Play Transformer, Cognos Administration, Access Manager, Report writing, Technical writing.

ETL: Informatica Power Center 8.x, Data stage 8.x, SQL Server Integration Services (SSIS),SQL Server Analysis Services (SSAS)

Databases: Oracle 10g/9i/8i, SQL Server, MS Access 97/00/03Teradata

Languages: C, SQL, PL/SQL, MDX, Shell Scripting

Operating Systems: Windows 95/98/NT/2000/XP/2003, MSDOS, UNIX

Confidential Tools: MS Excel, MS word, MS PowerPoint, MS Visio

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow- Flake Modeling, Fact and Dimension Tables, Physical And Logical Data Modeling

Web servers: IIS, APACHE

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Cognos Developer

Responsibilities:

• Gathered and analyzed end user requirements.
• Develop Metadata models in Framework manager as per the business requirements.
• Build Multidimensional Cubes in Transformer for Analysis.
• Build Dashboard in Cognos for the Management to provide high level overview of the business.
• Developed packages for Adhoc reporting in Query Studio.
• Created complex/standard reports in Report Studio.
• Maintains reports and Documentation related to Cognos Enterprise Planning.
• Set up Powerplay Studio and Analysis Studio reports for multidimensional analysis.
• Created reports in report studio involving Drill through, Conditional formatting, JavaScript, Union queries, Joins and SQL queries.
• Provide support to enterprise planning requirements through the use of Cognos Planning software of all versions.
• Customize prompt pages and report pages using Html, Javascript.
• Migrated content from Cognos 8 to Cognos 10.
• Provided row level security, object security and package access in Framework Manager. And also secured the folders by setting up access permissions in Cognos Connection.
• Involved in Troubleshooting and Performance tuning of the reports and cubes.
• Involved in the upgrade of reports from Cognos 8 to Cognos 10.
• Created Materialized views in the database to improve run time performance of the reports.
• Set up time critical alerts and reports in Event studio.
• Recommended and utilized the Materialized Views in the database to achieve user acceptable level of run-time for the reports.
• Evaluated the performance of the project and analyze the effect of Cognos enterprise planning application.
• Experienced with Dynamic Query Mode (DQM) and Compatible Query Mode (CQM)

Environment: Cognos 10 BI, Cognos 8 BI, SunOne Directory Server, Siteminder, Oracle 9i/10g, SQL Server 2005, Teradata, Windows XP, Toad 8.4 & 10.2.2 Versions: Report Studio, Query Studio, Framework Manager, Powerplay Transformer, Analysis Studio, IBM Cognos Configuration, Cognos Content Store, Cognos Administration.

Confidential

Sr. Cognos Developer

Responsibilities:

• Analyzed Business Requirements for Reports, worked closely with business analysts to understand the business needs.
• Worked on Star flake & Snow flake schemas including tables, views and materialized views for the reporting construction.
• Created DB Layer to handle the relationships between query subjects and then Business Layer on top of it with Model Query Subjects.
• Design and developed the Framework Manager Models (Relational/DMR Models) and published the packages to the server.
• Updating the Framework Manager Models from Compatible Query Mode to Dynamic Query Mode
• Implemented Framework manager security at various levels in the model like (Package/Row/Object).
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Built advanced reports like List Reports, Cross Tab Reports, Chart reports, reports with multiple prompts and Filters in Report Studio.
• Created Bar Charts and Cross Tab reports in Analysis Studio.
• Created complex reports such as Dashboard Reports, Master Detail reports, Drill Through reports.
• Applied Model filters, Detail filters and Summary filters to generate user requirements.
• Developed Multi-dimensional Dash Board Reports using Report Studio & adding it to the Portal page using Cognos URL.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Redesigned the existing reports according to the user requirements.
• Created Jobs to Schedule reports in Cognos Connection based on the reports to run daily, weekly basis using Event Studio.
• Actively involved in the administration part of Cognos Connection for organizing, security, scheduling and distributing reports.
• Created simple and Ad hoc reports using Query studio.
• Built Portal pages to replace their existing portals in Java.
• Installed and Configured Cognos 8.4.1 FP3 in windows based environment.
• Upgraded all Packages, Reports and Data source connections from Cognos 8.4 to Cognos 10.2.1 in different environments.
• Troubleshooting and correcting upgraded reports from Cognos 8.4 to Cognos 10.2.1.
• Deployed applications from development to QA and then Production servers using Export/Import functionality in Content administration.
• Passing the Prompt Parameters in Report Studio reports using JavaScript.
• Trained users on navigation and creating simple reports in Query studio.

Environment: Cognos 10.2.1 (Cognos Workspace, Cognos Workspace Advanced, Query Studio, Analysis Studio, Event Studio), Cognos 8.4.1 Fp3 (Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Administration and Cognos Connection), Oracle 10g, JavaScript, HTML, Windows 2003/2008.

Confidential, Issaquah, WA

Sr. Cognos Developer

Responsibilities:

• Creation of Technical Specification for the Report Studio reports.
• Providing BI Report development support to the entire system development lifecycle of IT projects using Cognos 10.2 BI Report Studio.
• To review the database schema changes, stored procedures, SQLs and other database related objects by software developers.
• Working with development team and data modelers to design and develop conceptual data models, logical data models and implement them in physical database.
• Working with development team to develop, troubleshoot and optimize SQLs and Transact-SQL stored procedures.
• Establishing database design conventions in best practice, and assure that design conventions and standards are compiled and documented fully.
• To support database change management and deployment processes.
• Developing and implementing Transact-SQL Stored Procedure verification tools that assist developers in troubleshooting and performance improvement.
• Developing and implementing procedures for the synchronization between different database environments.
• Working with the infrastructure team to design, implement and scale the BI systems architecture.
• Working with business users and analysts to design and develop data requirements.
• Providing advice/recommendations on database architecture, design and implementation.
• Provide training, documentation for knowledge transfer to other database team members, and communicate both to non-technical users and to technical personnel on Database team and Applications teams.

Environment: Cognos 10.2 Report Studio, Query Studio, Analysis Studio, SQL Server 2005, Windows 2000/2003, SSRS, SQL Profiler, MS Excel 2008, Visual Studio 2005 & TOAD.

Confidential, El Segundo, CA

Sr. Cognos Developer

Responsibilities:

• Developed reports, maintained and provided Production support for multiple projects simultaneously.
• Provided end-to-end support, maintenance and enhancements to the Cognos reporting framework (security, data model, packages and reports).
• Created reports primarily focused on providing Yearly and Quarterly Revenue and Profit Accounting.
• Participated in design and development of Cognos Enterprise Planning and Reporting for planning and forecasting systems.
• Wrote Technical Design documents, Supplementary specifications, designed Active Directory Security model, Data Differentiator model, user groups and access request tool changes.
• Presented pre-implementation Cognos reporting sales pitch & post-implementation walk-through to business end-users in collaboration with Business Analyst.
• Proposed and implemented Cognos environment improvements and Cognos reports' performance improvements to increase productivity.
• Evaluated the performance of the project and analyze the effect of Cognos enterprise planning application
• Completely revamped reporting environments for a couple of applications reducing total number of maintained reports by extensive use of parameterized reporting & Report Views to reduce number of maintained reports by 80%.
• Improved Cognos Framework manager model by breaking loops in data model with the use of alias shortcuts.
• Plan, analyze and evaluate solutions for Cognos enterprise planning environment by using the appropriate version of the software
• Improved FM Models from Compatible Query Mode (CQM) to Dynamic Query Mode (DQM).
• Created Active Directory roles to enable folder access and sign-on security permissions in Cognos Connections.
• Migrated reports, packages, and models from IBM Cognos 8.4 to 10.1 and from Test to Production.
• Worked extensively on Conditional Formatting using prompt parameters, Conditional Blocks, conditional styles, render variables, conditional variables and classes.
• Maintained Security via LDAP and Cognos Administration, in assigning roles to the user groups and assigning the same to the Folder Structure in Cognos.
• Experience in using Cognos Connection to organize and schedule reports based on the user requirements.
• Applied row level security on query items to ensure data security using Session Parameters and Security Dimension in Framework Manager.
• Ensure optimum utilization of resources and plan the overall design solution for the enterprise.

Environment: Enterprise DWOracle 10g, Windows Vista, Cognos BI 8.3Deployed - Report Studio, Query Studio, Analysis Studio and Metric Studio. Cognos Data Manager, Cognos Access Manager.

Confidential, Pittsburgh, PA

Cognos Developer

Responsibilities:

• Participated in the SRS review meetings, prepared Technical Design Documents based on SRS and implemented complex business requirements using BI Tools
• Created Executive level Dashboards in Cognos showing various high level key performance indicators.
• Created reports in report studio involving Drill through, Conditional formatting, JavaScript, Union queries, Joins and SQL queries.
• Built Multidimensional Cubes using Transformer.
• Implemented cube groups, incremental updates and time based partitioning to improve the performance of the Powerplay cubes.
• Automated the cube builds using windows batch scripts.
• Responsible for the cube performance tuning and reducing cube build time.
• Created metadata models against relational databases for creating OLTP reports and also created DMR models in Framework Manager for OLAP reports against live data.
• Utilized HTML & JavaScript to customize Cognos reports as per the business requirements.
• Set up alerts using event studio.
• Created report mockups to set user expectations.
• Worked extensively with ETL team.
• Performed deployments across different cognos environments.

Environment: Cognos 8.4/8.2 BI, SunOne Directory Server, Access Manager, Oracle 9i/10 g, Windows 2000/XP/2008, Oracle Sql Developer.

Confidential, Phoenix, AZ

Cognos Developer/ Administrator

Responsibilities:

• Involved in Preparing the design requirements, system configuration and Performance tuning.
• Administered installation, configuration, and software upgrades of Cognos applications.
• Created Construction Variance Report, Variance Explanation Report for finance.
• Created Capital Budget Variance Summary Report, Variance Summary Departmental Report.
• Created Overtime Hours Report, Construction Overhead Report for Finance.
• Optimized the Oracle data mart databases, performance tuning, backup, and recovery.
• Created a Summary Report, UG cable report, Forecast vs. Actual Report.
• Created a Dashboard Navigation for T&D Reliability using Report Studio, Dashboard for displaying all the metric details in T&D reliability.
• Created a Framework Manager Model for Reliability indices, and a DMR model.
• Created and maintained Database, Users, Tables, Views, PL/SQL Stored Procedures and Macros.
• Created Cubes based on the business requirements and created the related drill through reports.
• Involved in Creating query prompts, cascading prompts, developed prompt pages and conditional variables.
• Developed necessary project documentation such as scope documents, requirement documents, and technical documents.

Environment: Cognos 8.3/8.4.1 BI (Report Studio, Query Studio, Analysis Studio, Metric studio), Informatica 8.1, IIS, UDB, Teradata, and Windows XP

Confidential

Programmer Analyst

Responsibilities:

• Involved in Business Analysis, Design and Development
• Performed Normalization and Logical Database Design
• Created Stored Procedures, Functions, and Packages to manipulate the database and to apply the business logic according to the user specifications.
• Involved in hard coding of SQL & PL/SQL scripts.
• I did Performance tuning for rapid execution of SQL & PL/SQL Scripts.
• Developed GUI interface in Java using Applets, HTML, JDBC and JavaScript.
• Created Stored Procedures, Functions, Packages, Triggers, Tables, Views and Synonyms
• Accessed data from the database using RDO Controls and Remote Data objects
• Created the VB Forms for Data Capturing using Active X Data Objects.
• Created Active X DLL's using Class Builder Utility and generated different Crystal Reports.
• Generated lot of Crystal Reports.

Environment: Oracle 7.3/8.0, PL/SQL 8.0, SQL Server, Sybase, Visual Basic 5.0/ 6.0, JAVA, JSP, Crystal Reports and Windows NT