Summary:

• Senior software consultant with 8 years experience in Business Intelligence, Database design, development and performance tuning on Transactional and Data warehouse systems.
• Extensive experience on Cognos BI tools( version 10 and 8.4) – Framework Manager,Report Studio,Analysis Studio,Event Studio,Transformer,Metric Studio,Business Insight and Cognos Connection.
• Expertise in building data models using Cognos Framework Manager.
• Experience in Administering Cognos Environments (Deployment, User Groups privileges, Server settings, Security, Report Bursting,and Scheduling).
• Complex Report building experience with Report studio,Analysis Studio and Event Studio.
• Strong experience in building Multi Dimensional Models using Transformer.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, and developed Star Schema & Snowflake Schemas in data warehouses.
• Used Cognos SDK to customize the report objects.
• Excellent skills in writing SQL Queries, PL/SQL objects - Stored Procedure, Functions,Triggers,Cursors,Packages, and in Performance tuning techniques.
• Designed and developed business requirement documents and Technical specifications.
• Experienced in leading teams and mentoring the junior members.
• Worked in a full cycle implementation of a Point of Sale system, and has 4 years of experience in the Architecture and functionality of Retail Point of sale systems.
• Worked in 2 full cycle Cognos solution implementations.
• Good understanding of the SDLC process, and quality standards.
• Excellent communication skills - Written and Verbal.

Work Experience:

Confidential,Louisville, KY.
Senior BI Consultant and Team Lead. April 2009 till Date.

The project scope is to create a new master data management system on Oracle database,and develop reporting applications on Oracle ERP,Point of Sale,Master data management system,and the Data warehouse. A new point of sales system was also implemented during the project duration.The Oracle database and Cognos BI were also migrated to new versions during the project duration.

Responsibilities:

• Report and Dashboard development using Cognos BI – Report Studio, Query Studio,Event studio,Analysis Studio and Business Insight (versions 8 and 10).
• Data model development – Relational and Dimensionally modeled Relational models(DMR) - as a Layered Architecture (Database, Logical, Reporting) using Framework Manager.
• Administer the security settings for the various Cognos user groups, control the configuration settings, and manage production promotes – content management - as the SBU BI lead.
• Power play Transformer models design and cubes development.
• Reporting application migration from cognos8.4 to cognos10.1.
• Report bursting, scheduling, query tuning, and deployment.
• Third Party Security Implementation with LDAP and creating Data Level, Object level, Package level and Row level Securities in Framework Manager Models.
• Customize the functionality in prompt page, Master detail Relationships, Drill through in Report page, Customized Prompts and Conditional Formatting.
• Database design and Development for a Master Data management System – Customer, Item, Employee and Sales data Objects and the Data warehouse.
• Performance tuning of the reporting applications.
• Data Integration development between POS,MDS,and Oracle using Oracle Data Integrator(ODI).
• Ad hoc data extraction on a large Oracle database using SQL and PL/SQL.
• Development of Oracle database stored procedures, packages,and triggers.
• Requirement gathering and analysis.
• Transformation of Business Requirements into BI Reporting specifications and test case documentation to forward to the offshore team.
• Lead the contract BI development team,Production support and training to end users.

Environment: Cognos 10.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio and Business Insight), Cognos Connection, Oracle 11g/10g, SQL Server 2008.

Confidential,Pittsburgh,PA.
Cognos BI Consultant. Sep 2007 – Mar 2009.

The project scope was to provide PPG users a set of reports so that they can have a quick overview of their Sales,Payments,Customers and taxes information.The reports had been running on a Mainframe Application and are re-built in Cognos BI and Oracle 10g.

Responsibilities:

• Gathering, analyzing and documenting business requirements.
• Cognos data model development using Layered Architecture (Database, Logical, Reporting) in Framework Manager.
• Power play Transformer models design and cubes development.
• Security Implementation (Package, Object, and Data level) in Framework Manager.
• Report Development using List, Crosstab, Chart, and Repeater objects in Report Studio.
• Report development using cubes in Analysis Studio.
• Report Bursting and Scheduling.
• Creation of DMR models.
• Development of Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Unit and User Acceptance test case development.
• Oracle database Packages/Stored Procedure development.

Environment: Cognos 8 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight, and Analysis Studio), Cognos Connection, Oracle 10g, SQL Server 2005.

Confidential,Pittsburgh,PA.
ETL,Reports,and Oracle Plsql Developer. Mar 2007 - Aug 2007.

The scope of the Invoicing project is to develop a solution to deliver the charge invoices online to a vendor contracted to mail them to the customers depending on their preferences. In addition, an online solution was developed wherein invoices from the retail stores are archived daily,and customers can login to a portal and access the invoices as in Oracle E-billing.

The scope of the second project, P & A conversion, is to port the physical inventory count process to a custom Inventory management system from a legacy system used by the Parts and Accessories business of the client.

Responsibilities:

• Responsible for the all the phases of the project life cycle from requirements gathering,design,coding ,testing to the rollout – was a single resource project.
• Oracle Plsql objects development - packages, triggers and stored procedures.
• Oracle Sql reporting solution development from the Mainframe programs written in Cobol, JCL and EasyTrev.
• Unix based scripting solution development to archive the invoice pdf files.
• Adhoc report development on large data sets.
• Oracle and Unix systems support.

• Work with the external Vendors to understand their systems, and develop the programs
• meeting their requirements.
• Unit and User Acceptance test case development.
• End User Training.
• Coordinate meetings will the stakeholders.

Environment: Oracle 10g,HP Unix,Mainframes.

Confidential,CA.
ETL Developer and Team Lead. Nov 2005 – Feb 2007.

As part of the client’s engagement with my Company, they outsourced the application development and systems Support work. The scope involves development and enhancements to custom applications, and support of data interfaces between packaged applications and Oracle ERP Our team is involved in the data interface development between Oracle ERP and the
Packaged Apps – Steelwedge,Manugistics, and in the enhancements to the existing functionality
of the Manufacturing and sales Custom Applications using Oracle PL/SQL.

Responsibilities:

• PL/SQL packages and stored procedure development as part of interface creation between Oracle ERP and other applications - Steelwedge, Manugistics and SCMC.
• Unix shell script, batch script, and Cron Job development.
• Database and Unix script support.
• Team Lead for three modules.
• Adhoc sql query development on large data sets.
• Support ticket queue owner and task assignment.
• Unit and User Acceptance test case execution.
• End User Training document creation.
• Coordinate meetings will the stakeholders.

Environment: Oracle 9i, Sun OS 5.8/5.9.