SUMMARY

• 9+ years of IT industry experience in analysis, design, and development of Data warehousing applications
• 7+ years of working experience with Business Intelligence tool Cognos 8.X/ 10.1/10.2.1 BI Suite (Framework Manager, Report studio, Query Studio and Analysis Studio), Transformer, Cognos Report Net v1.0/1.1, Cognos 7.3/7.2 series (Impromptu web reports(IWR),Impromptu, PowerPlay Transformer, Access Manager, Upfront, Scheduler)
• Experience working with databases including Oracle, MS SQL Server, DB2, MS Access
• Created Models and published packages for reporting using Cognos Frame Work Manager
• Created Multi - Dimensional Cubes using the Cognos Transformer
• Developed several reports and Cubes in Cognos 8 Bi, Cognos ReportNet, MS-Access, MS-Excel
• Cognos PowerPlay Transformer
• Experience in developing and testing Complex reports (List, Cross tab, Charts, Drill through, Master-Detail, and Cascading) and Dashboards using Report studio
• Strong knowledge of various components within Cognos and how they interact with each other
• Strong Knowledge of Data Warehousing, RDBMS,OLTP, OLAP concepts
• Strong understanding of Dimensional Modelling (Star and Snowflake Schemas)
• Sound knowledge in SQL Queries and databases concepts
• Involved in various activities of the Software Life Cycle
• Self-starter with drive, initiative and a positive attitude
• Strong analytical & good communication skills

TECHNICAL SKILLS

Reporting Tools: Cognos 10.1/10.2.1/8. X Series (Framework Manager, Report Studio, Query Studio and Analysis Studio ), Cognos Transformer, Cognos Report Net 1.0/1.1,Cognos impromptu 7x, Cognos PowerPlay 7x .

Databases: MS SQL Server 7.0/, Oracle 11g/10g/9i/8i,IBM DB2, MS Access, Flat Files

Languages: C, C++, Java, SQL, PL/SQL, UML

Platform: Windows 2000/2003/NT/XP/Vista, UNIX and AIX

Networking & protocols: TCP/IP, DNS, Active Directory, IIS, HTTP, POP3, and SMTP

Web Servers: IIS, Netscape Directory Server, IBM Websphere, Weblogic

Miscellaneous: TOAD, SQL Developer, MS Office Suite, Adobe Photoshop, Web Design tools like Dream weaver

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Cognos Developer

Responsibilities:

• Create reports based on the requirements from the business user’s
• Created Models in Framework Manager and Published to Cognos Portal page for creating reports
• Modelled in 3 layers to hide the business complexity for users/developers
• Designed Model’s Framework with no loops or circular joins between tables
• Applied security on Folder level in a manner that only the relevant users were able to see those packages and reports created
• Created List, Chart, Cross tab, Repeater reports in Cognos Report Studio
• Created Multi- Page reports and multi level Drill thru reports
• Created reports with cascading prompts, conditional formatting, variable expressions (String and Boolean) etc
• Created test scripts/ SQL scripts to unit test the developed reports
• Review the reports with the team members and fix any issues
• Fixed defects in reports after business user’s test the reports
• Trained Business Users in Cognos
• Experience in creating Ad-hoc reports using Cognos Query Studio
• Scheduled reports/Jobs based on user requirement
• Deployed reports from one environment to other
• Migrated reports from Cognos8.4 to Cognos 10.1

Environment: Cognos 8.4/10.2, Report Studio, Query Studio, Framework, Oracle 11g/10g, SQL, PL/SQL, Windows 7, Toad, SQL Developer

Confidential, Richmond, VA

Cognos Developer

Responsibilities:

• Converted 70-80 reports from SQR to Cognos 8.4.1/Cognos 10.1 and also created new reports based on the requirements
• Analyzed the SQR SQL with Oracle SQL developer tool
• Used Framework Manager to model metadata from different data sources and published packages to Cognos Connection
• Created Frame Work Model with 3 layers with tables and joins as specified in SQR code
• Created Frame Work with no loops and minimum outer joins for better performance
• Created list, repeater, crosstab, Multipage reports in Report Studio based on the SQL code in SQR
• Performed unit testing to ensure that the performance of the reports matches the existing SQR reports
• Created Parameter Mapping logic in Framework to route the users to appropriate data source based on the login
• Created Multi-Dimensional Cubes and Reports as per the User Requirements
• Developed Models by using Impromptu Query Definition (IQD) and packages in PowerPlay Transformer
• Created data source connections and Published Cubes Using PowerPlay transformer
• Created Analysis studio reports using power play cubes
• Fixed the defects in reports raised in QC (Quality Center) by working closely with BA’s and users
• Wrote a script in Oracle SQL developer to load all the users’ information from existing database to Cognos LDAP
• Performed admin activities like deployment, creating datasources and scheduling jobs etc
• Worked with Cognos Administrators for setting up the security on the entire system.
• Modified the reports according to the new changes in the Database from time to time without any breaking/errors
• Trained users on Cognos
• Efficient in writing SQL Queries in SQL server 2000/2005/2008
• Attend meetings twice a week with Manager’s and Team lead and shared information

Environment: Cognos BI 8.4.1/ 10.1, Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer, Oracle 11g/10g, MS SQL server 2005/2008, SQL, PL/SQL, ETL (Informatica), Windows 2003/XP, Toad, SQL Developer

Confidential, Washington, DC

Cognos Developer

Responsibilities:

• Involved in the entire project life cycle from analysis, installation, development, testing, production and end user support
• Worked closely with business users while gathering requirements and analyzed System Requirement Specification (SRS) for building the report
• Developed models and published packages in Cognos Connection using Framework Manager
• Used Framework Manager to model metadata from different data sources and published packages to Cognos Connection
• Creating Data Sources in Framework Manager to connect to databases
• Create Models by creating various joins between query subjects and also resolved various types of joins between them
• Involved in solving various data traps like chasm, connection trap etc
• Verified the models using Framework Manager tools like Model Advisor and Verify Model
• Developed model’s in 3 layers in Framework
• Involved in setting up security in Framework Manager and Transformer
• Involved in building Multidimensional Cubes using Transformer
• Published the cube from PPES - Admin and Transformer to Cognos Connection Portal
• Developed Reports like list, chart, cross tab, cascading, burst, Master - Detail, Drill Through in Report Studio
• Developed Dashboards, Complex Reports having many calculations, child reports, HTML items etc. in Report Studio
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
• Experience in creating Ad-hoc reports using Cognos Query Studio
• Developed Scorecards and monitored the organization’s performance using Cognos Metric Studio
• Developed Reports from the cube based Packages using Analysis Studio
• Upgraded Cognos 7 Series Models, Reports and Packages to Cognos 8 BI
• Efficient in writing SQL Queries in SQL server 2000/2005/2008
• Created Database and Tables structures (DDL Scripts with Create, Drop, Insert, Update, Delete, Alter) in MS SQL Server
• Developed and modified Stored Procedures and Functions
• Performed Unit testing and Smoke testing for the reports
• Added security to reports
• Scheduled reports using the Schedule Management tool in Cognos Connection
• Prepared Weekly Status Reports (PSR) and shared with the Managers
• Production Support which involves solving user problems and Provided End User Training and Support
• Prepared User documentation to train users and functionality of each report

Environment: Cognos BI 8.2/8.3/8.4, Framework Manager, Report Studio, Metric Studio, Analysis Studio, Query Studio, Transformer, PPES - Admin, Oracle 11g/10g, MS SQL server 2005/2008, SQL, PL/SQL, Windows 2003/XP, Unix, Toad, SQL Navigator

Confidential, San Diego, CA

Cognos Developer

Responsibilities:

• Involved in Designing the Architecture of Cognos 8.1/8.2/8.3BI
• Participated in requirements gathering to bridge gap between user needs and tool functionalities
• Understanding existing business model and user requirements
• Involved in upgrading Impromptu catalogs, PowerPlay models, cubes, reports and ReportNet reports to Cognos 8 BI series
• Developed models and published packages using Framework Manager
• Analyzed the Cognos models and packages used to build the reports
• Designed star/snow flake schemas and dimensional models using Framework manager
• Worked on the Framework Manager to solve ambiguous relationships in metadata models, and published packages
• Responsible for improving report response time by creating appropriate joins between Query Subjects
• Created manual levels and developed appropriate Models and generated cubes in Transformer
• Published Cubes using Frame work manager and PowerPlay Enterprise Server to Cognos Connection.
• Developed list, chart, burst, master-detail, drill through, repeating, and multi page reports in Report Studio
• Created complex reports that involve query prompts, layout calculations, conditions, and filters in Report Studio
• Created cross tab reports to summarize and compare complex data in Report Studio
• Improved the usability of the reports by creating prompts and filters
• Developed Multi page reports with prompt pages and conditional variables according to the end user requirements
• Deployed Data from one Environment to Another
• Customized Cognos Connection Portal to personalize the homepage
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection
• Administered the security of all the Cognos tools using the Access Manager and LDAP
• Trained business users in Framework Manager, Report Studio, and Query studio

Environment: Cognos 8.1,8.2 BI, Cognos Report Net 1.1, Mr2, Cognos 7 series (Impromptu web reports and PowerPlay Transformer, PP User), Access Manager, Oracle 9i, Transformer, SQL, PL/SQL, Windows NT/2003/XP, Apache, IIS, Toad, SQL Navigator, Humming Bird, Microsoft Visio, LDAP

Confidential, Oklahoma City, OK

Cognos Developer

Responsibilities:

• Installed and Configured Cognos Report Net tools and Cognos 7.2 tools
• Administered the Reporting Environment
• Created Reports Using Cognos Impromptu
• Developed data specific Impromptu reports with various filter conditions
• Developed Several Reports including burst reports using Report Studio and other Cognos 7 tools
• Migrated Cognos 7 series Catalogs and Reports to Report Net1.1
• Configured LDAP namespaces
• Administered tasks such as scheduling, deployment, Dispatchers and security
• Was involved in data merging, transformation and aggregation using Cognos Decision Stream
• Was involved in developing slowly changing dimensions and data marts using Cognos Decision Stream
• Published Impromptu reports to UpFront portal by using IWR Report Administrator
• Responsible for data analysis, design, loading and manipulation
• Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process
• Made the end users comfortable using the centralized upfront server

Environment: Cognos 7.1/7.2 tools, Cognos Report Net 1.1, Cognos Visualizer, Oracle 9i, SQL Server, MS Access, WINDOWS 2000/XP, PL/SQL, SQL Loader, Sunopsis Tool.

Confidential

PL/SQL Developer

Responsibilities:

• Converted standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control
• Designed tables, indexes and constraints using SQL*Plus and loaded data into the database using SQL*Loader
• Used SQL tools like TOAD to run SQL queries and troubleshoot
• Developed Stored Procedures and functions, triggers to accomplish several computations
• Created user-friendly GUI interface and Web pages using HTML
• Developed Servlets and used JDBC for storing and retrieving user data into and from the Oracle database

Environment: SQL Server200, Microsoft.Net, Apache server, Windows NT, and Windows 98