Professional Summary:

• 7 Years of experience in analysis, design, development, customization, testing, implementation, support and user training of Software applications related to Cognos Reporting Technology.
• Experience in Development of Business Intelligence Solutions using OLAP Tools, COGNOS 10x/8x, Report net, Impromptu, Power Play, Transformer, IWR, Upfront, Access Manager.
• Good experience in Cognos10x/8x, Metric Studio, Cognos Report Net (Cognos connection, Query Studio, Report studio, Framework Manager).
• Experienced in Analysis Studio, Query Studio, Report Studio and Framework Manager to design Complex Reports and to create Models and Packages in Cognos 8 BI.
• Experience with Cognos 10/8 security.
• Extensive experience in using Report Services for developing Dashboards reflecting business performance.
• Experienced in publishing Packages and Reports to Report net portal.
• Experienced in Power Play Transformer to design Models and analyze the Power Cubes.
• Involved in the multiple full Project Life Cycle of the Data Warehouse Project.
• Proficient at analyzing business processes and providing Business Intelligence solutions.
• Involved in Interacting with Business Analysts and Business Users to gather Reporting Requirements.
• Excellent team player with good interpersonal and communication skills and the ability to work in a team or as an individual.
• Transformed projects into successes by completing on time and within budget in difficult circumstances.
• Experience working as Lead, Sr Developer, Onshore and Off Shore coordinator.
• Involved in production support activities and troubleshooting reporting issue.

Technical skills:

OLAP Tools: Cognos 10x/8x (Report Studio, Query Studio, Analysis Studio, Framework Manager) Cognos 7.3 (Impromptu, Power Play, Transformer, IWR, Power Play Enterprise Server, Visualizer, Scheduler, Power Prompts, Notice cast, Cognos Query, Report Net)
Operating Systems: Windows NT/2000, UNIX
Programming skills: SQL, PL SQL, Regular expressions
Databases: SQL Server, Oracle, Teradata, MS Access 97/00/XP/03
Web Servers: Microsoft Internet Information Server (IIS) 4.0/3.0, (MTS), Netscape Directory Server
Modeling Tools: Rational Rose, Visio, Erwin
Microsoft Tools: MS excel, MS word, MS Visio, MS Project, MS PowerPoint, MS SharePoint
Other Tools: Remedy, Quality Center, Lotus Notes, SQL Navigator, Visual Source Safe, Toad, Nexus, Share Point

EDUCATION: Bachelor of Science

Professional Experience:

Confidential,Arlington, TX Feb 11’-Current
Cognos Developer

Confidential,is one of the largest retail stores in south central and southwest part of US. They have wide selection of home electronic products from audio video equipment to personal computers. Focus of the project was to deploy a Cognos BI based solution for reporting needs.
Worked on multiple project such
RUM: Revenue Units Margin Metric Reporting across Product Family across retail store by analyzing POS (Point of Sales) Data
MAD: Market Data Analyzer reporting that compare the sales of various product family by category across various other retailer, we purchased the data of other retailers from IDC or Epsilon.
Product Quality Metric Report: Reporting to track the product quality issue as reported by customer thru return or damages via shipping or handling
Insurance (Warranty) Reporting: Report on revenue and claims on the insurance product sold. This environment is also used to see what all products are also going out of insurance in the next QTR.

• Installed and Configured Cognos 10/8 BI tools (Cognos Configuration, Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio)
• Designed and Developed Framework Manager Models to be deployed as packages on Report Net Server.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Developed Standard Reports, Charts, Drill through Reports, Cross tab Reports, List Reports, Summary Reports and Multi Object Reports using Report Studio.
• Developed Prompt Pages and Conditional Variables, Creating Query Prompts, Calculations, Conditions & Filters in Report Net.
• Created Web-based reporting solution that can address reporting needs using Dashboards.
• Extensively used Report Studio in designing Complex Dashboard Reports.
• Created Catalogs and Reports in Impromptu.
• Assigned various types of Securities like Table Security, Row Security, and Column Security using Governor Settings.
• Tuned performance of Impromptu to decrease the run time for reports.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using Power Play and Transformer.
• Modified existing cubes by slicing and dicing, adding alternate drill-down paths, special categories.
• Migrated existing Impromptu catalogs and Reports to Report net.
• Published Power Cubes to Cognos 10/8.

Environment: Cognos 10/8 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Analysis Studio), Reportnet 1.1 MR2, PowerPlay, Impromptu, SQL, JavaScript, Windows XP.

Confidential,Austin, TX Mar’10-Feb’11
Cognos Developer
Confidential,is one of the largest Telecommunication industries in the world Providing wireless as well as wired services to consumers and business. Focus was mainly on creating reports and analyzing future as well as projected sales.
Wireless Number Portability:

• Created Lists, Groups and Cross-tab reports with Drill-Through functionality.
• Implemented Folder Level and User Class Level Security to the Catalogs.
• Developed sub-reports and various reports using different types of Prompts like Catalog Pick List, File Pick List, Type-in, and Cascading Prompts using Conditional Formatting.
• Create Model in the Framework Manager.
• Migration from Crystal to Cognos 8.
• Created standard and Adhoc reports.
• Created and publishing several packages in Framework Manager.
• Developed List Reports, Charts, Drill Thru Reports, Master Detail Reports, and Multilingual Reports using Report Studio and Query Studio.
• Created calculations, filters and prompts in Report Studio.
• Created users and user classes through Access manager.
• Worked with QA teams and Change

Environment: Cognos 8x, Framework Manager PowerPlay, PowerPlay Transformer, Access Manager, Windows XP, Windows 2003 Server, Quality Center, Remedy, .

Confidential,Sunrise, Fl Oct’09 – Mar’10
Cognos Developer
The project focus was to create a state of the art BI solution that will address Pediatrix reporting needs from internal and external clients.

• Worked with various user groups and gathered Business Requirements.
• Worked with architects to develop POCs.
• Developed various types of reports per user requirements.
• Developed Framework Manager Metadata model – relational and dimensional.
• Modified, Created, published, and modified several packages in Framework manager according to the business needs.
• Developed Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Creating user groups in Cognos Connection from Active Directory groups.
• Worked on Cognos Servers issues.
• Supported the Cognos Development and Production environment.

Environment: Cognos 8, Cognos Report Net 1.1MR2 (Frame work manager, Cognos Connection, Report Studio, Query Studio), Active Directory, SQL Server, Oracle.

Cognos Developer
Confidential,is a leading U.S based multinational insurance organization focusing on profitability, distribution and claim processing. Focus of the project was to deploy a Cognos BI based solution for reporting needs.

• Worked with business analysts and end users to understand business rules and interpret data.
• Developed Framework Manager Design documentation and Report Net Report documentation.
• Created Packages which includes Query Subjects, Joins, Filters, Prompts in Framework Manager.
• Published the Packages to Cognos Connection.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Developed ad-hoc reports in Query Studio.
• Used Analysis Studio to build Multidimensional Reports.
• Developed List, Crosstab, Drill through, Master-Detail, and Charts which involved Multiple Prompts, Multiple Frames, Filters, Multi-page, Multi-query reports against different data sources in Report Studio.
• Created the Reports in different formats like PDF, XML, HTML, Excel and CSV.
• Involved in Bursting Report Studio reports and sending reports via Email to several business users.
• Involved in scheduling Report Studio and Query Studio reports in Cognos Connection.

Environment:Cognos 8 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Analysis Studio), Report net 1.1 MR2, Oracle 9i, SQL, Windows XP.

• Confidential,Atlanta, GA Mar’05 – Jan’07
• Cognos Developer
• To create model, and generate reports from ORACLE data warehouse.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Designed the Reports and Catalogs using Impromptu as per the requirements.
• Assigned Weightage to the table and resolved loop problems in the joins.
• Created Multi-Dimensional Cubes and Reports in PowerPlay Transformer.
• Modified Power Cubes by adding new Dimensions, alternate drill-down paths, Special Categories.
• Created Drilling down, Slice and Dice Reports in PowerPlay.
• Created reports providing summarized and detail data via Drill-Through in PowerPlay.
• Configured LDAP and Access Manger 7.3 for the Security of Cognos Products.
• Installed Reportnet 1.1 MR2, Framework Manager and setting Cognos Configuration.
• Migrated several existing Impromptu Catalogs into XML files and importing them into Reportnet.
• Developed PowerPlay Cubes and published them using Cognos Connection.
• Designed Models and Packages using Framework Manager and deployed Packages to the Reportnet Servers.
• Developed Templates, Standard Reports, Master Detail Reports, Drill Through Reports, Bursting Reports and Multilingual Reports using Report Studio and Query Studio.
• Created dashboards to present critical data in easy-to-understand format.
• Developed reports using Cascading and Range Prompts and Calculations in Report Studio.

Environment: CRN 1.1 MR2, Cognos Connection, Report Studio, Query Studio, Framework Manager, PowerPlay 7.3, Transformer 7.3, PowerPlay Enterprise Server, Impromptu, Access Manager, Windows XP