SUMMARY

• Over 8 years of IT experience in Data warehousing Business Intelligence reporting, Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications for various industries like Retail, pharmaceutical and healthcare.
• Experience with Cognos Tools such as Cognos 10.x/8.8 BI suite (Framework manager, Cognos connection, Report Studio, Analysis Studio, Query Studio, Metric Studio and Event Studio) Cognos Report net 1.1 and Analysis Tools such as Cognos Power play transformer 8.x, Business Object XIR2,Informatica Powercenter 8.
• Expertise in Framework manager modeling which includes creating relational and dimensional models.(Database layer, Business Layer, presentation layer and Packages)
• Created security groups and implemented data level, object level and package level security.
• Expertise in developing Multidimensional Cubes using Cognos PowerPlay Transformer.
• Created simple to Complex Reports using Report studio (Drill through, Drill down,Master detail, Report level Joins, conditional formatting, scheduling and bursting the reports) and Analyzed data using Analysis Studio.
• Experience in developing standard and complex dashboards and implemented dynamic grouping using Report Studio.
• Experience in migrating reports from Impromptu to Report Net, and upgrading reports from Report Net to Cognos 8 BI and also upgrade previous version to latest versions (Cognos 8.4 to 10)
• Involved in Installation and Configuration of Cognos 8 BI (All components including Power Play and Framework Manager) in Distributed Environment(Development, Test and Production)
• Extensive experience with database languages such as SQL, and PL/SQL which includes writing queries, Stored Procedures, Functions and View Experience in databases like Oracle 10g/9i/8i MS SQL Server 2005/2000.
• Expertise in Business Object reports and Designer. Created various Webi and crystal reports and involved in various support activities.
• Proficient with Informatica Powercenter. Developed Informatica mappings from scratch using Informatica Powercenter 8.
• Strong understanding of Data warehouse concepts (Star schema, snow flake schema, facts and dimensions) and SDLC methodologies.
• Experience in gathering and documenting end - user business requirements.
• Experience in team management(Task allocation and coordination)
• Excellent team player and self-starter with good ability to work independently, proficient at developing& implementing User Training programs and possess good analytical, problem solving and logical skills with ability to meet deadlines, multitasking and flexible in work schedules.
• Excellent in communication skills.

TECHNICAL SKILLS

BI Reporting Tools: Cognos 10.x, Cognos 8.x, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cube Designer, Cognos Report Net 1.1, PowerPlay Transformer, ImpromptuWebeports, Business Objects XIR2.

ETL Tools: Informatica Power Center 8, Data Stage

Operating Systems: Windows 2000/2003 Enterprise Server/Windows XP Professional

Databases: Oracle 8i/ 9i, 10g/11g, MS SQL Server 2000/2005

Database Tools: Toad 8.4, Rockmongo

Software Packages: MS- office 2003, Microsoft word, excel and Power point

Programming skills: C, C++, HTML, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Cognos Lead

Responsibilities:

• Working with users and coordinating with application developers to understand and capture data/reporting requirements, and developing specification documents for reports as per requirements.
• Developed standard Templates, Dashboard Reports, Standard Reports, charts, Drill through Reports, Master-detail and conditional formatting reports using Report Studio.
• Used Framework Manager to build models, packages and published packages to Cognos Connection.
• Deployed reports, packages and folders from DEV to UAT and from UAT to PROD environments and implemented security for reports and packages.
• Used data stage for extraction, transformation and loading of ticketing data from different data sources namely service center, request center and asset center.
• Used Kalido for data modeling and for storing data.
• Created change tickets whenever there was a change request from user and created problem tickets whenever there was a problem with the availability of the cognos portal and contacted the respected team for the closure of the tickets on time.
• Ensured the availability of Cognos portal and contacted the responsible team when the portal went down.
• Monitoring daily data load and running the jobs manually and fixing the issue with the data load.
• Provided reports to the users on daily, weekly and monthly basis.
• Fixed the data related issue with Cognos reports and provided incident resolution to the customer queries.
• Mentoring the team members and allocated task to the team member.
• Continuous coordination with development teams for defect resolution and tracking the defects to closure.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio and models in Framework Manager and development of any new reports.
• Made changes to Cognos reports as per the change request.
• Re-designed existing models & developed new dimensional models in Cognos 10 BI and published.
• Implemented package level, object level and data level security in the reports.
• Fixed the data related issue with Cognos reports and provided incident resolution to the customer queries.
• Trained the end user to effectively use the reporting tool to build and customize their ad-hoc reports.
• Provided daily and weekly status reports.

Environment: Cognos 10, Cognos 8.4-Framework Manager, Cube Designer, Report Studio, Query Studio, Analysis Studio, Oracle 10 g, Data stage, Kalido.

Confidential, NYC, New York

Sr. Cognos Developer

Responsibilities:

• Developed List, Cross tab, Drill through, Master-detail, Chart & Conditional formatting reports which involved multiple prompts in Report Studio & Burst them to General Managers.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• Refreshed daily data by running the scripts in Toad.
• Implemented dynamic grouping in Report Studio and security in Cognos Connection Portal.
• Enhanced the existing Meta data models with the desired changes in Cognos 10 Framework Manager and published packages.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Worked with development and project management team for early defect fixes.
• Provided Cognos reports as per user request.
• Modeled meta data from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Provided dashboard reports to the users on weekly basis and involved running SQL Scrips in Toad to refresh the dashboard on weekly and monthly basis.

Environment: Cognos 10 Framework Manager, Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Oracle 10 g, Windows XP, SQL, TOAD.

Confidential, Portland, Oregon

Cognos developer

Responsibilities:

• Created various List Reports, Cross tab Reports and Drill through Report in Cognos Report Studio. Created model files in Framework manager.
• Created dimensional cubes using Powerplay Transformer.
• Implemented Framework Manager Security for Data access, Object level access and Package access based on the Organization Level.
• Designed models & cubes in Cognos Transformer using existing IQD’s from Framework Manager and Power play transformer.
• Modeled Meta data from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down and Drill Up).
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Created Database Layer, Business layer and Presentation layer defining appropriate relationship between query subjects and Fact tables in Framework Manager.
• Done complete testing of Cognos Reports and validated data using Toad.
• Modified the existing report as per user request and provided support to the user.
• Fixed the issues with Cognos reports and cubes.
• Move the Cognos Framework Manager Models and reports from development, test environment to production environment.
• Documented functional and technical requirements for the meta data modeling and BI reports

Environment: Windows XP, SQL Server 2005, Cognos 8(Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Powerplay Transformer

Confidential

Cognos developer

Responsibilities:

• Modified existing Cognos reports and model files in Framework manager.
• Implemented parameter maps to the existing Framework model.
• Added additional columns and new filters to the existing Cognos reports as per the request.
• Created conditional blocks and conditional formatting in the reports.
• Implemented Governor Settings and published the packages using Framework Manager.
• Involved in bug fixing and created few complex calculations in the report.
• Done complete testing of Cognos Reports and validated data using Database.
• Move the Cognos Framework Manager Models and reports from development, test environment to production environment.
• Documented functional and technical requirements for the meta data modeling and BI reports

Environment: Windows XP, Oracle 10g,Cognos 8( Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio.

Confidential

BO Developer

Responsibilities:

• Developed Business Object web I and crystal reports for various business needs using BOXIR2.
• Developed Informatica mappings using Informatica Powercenter 8.
• Implemented Slice and Dice and Drill down functionality in the reports.
• Modified the existing BO Reports and Universe as per user request.
• Involved in Bug fixing of BO Reports and the Designer.
• Providing reports to the users on Daily, Weekly and monthly Basis.
• Modified the existing report by adding additional columns and filters.

Environment: Windows XP, Oracle 10g, Business Object XIR2, Informatica Power Center 8.