SUMMARY

• 9+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications.
• 1+ year experience with Tableau 9.0.
• Worked on development of Dashboard reports for key performance indicators for the Top management.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large visually compelling and actionable interactive reports and dashboards.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Developed KPI’s and dashboards based on reports, spreadsheets and charts.
• Worked on data blending and increased the dashboard performance by extracting data.
• Extensive knowledge on various reporting objects like Hierarchies, Filters, Calculated fields, Sets, Groups, Parameters, etc., in Tableau.
• Certified Cognos Professional with 8+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications
• Expertise in Cognos 10.2.1 BI including Framework Manager, Administration Tasks, Report Studio, Query Studio, HTML, Java Scripts, Dashboards.
• 7+ years of experience with Cognos Tools such as Cognos10.2.1, Cognos 8 BI Suite (Framework Manager, Cognos connection, Report Studio, analysis Studio, Query Studio, Metric Studio and Event Studio) Cognos Report net 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x.
• Documented functional and technical requirements for the metadata modeling and BI reports.
• Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages) and Complex Report building with Report Studio.
• Expertise on use of SQL, OLAP and star schemas to achieve accurate and efficient reporting of PeopleSoft data through Cognos.
• Have Knowledge on Cognos functionalities Go office and Go Search.
• Implemented Third Party Security with LDAP and use them in creating Data Level, Object Securities in Framework Manager Models.
• Experience in developing multi - dimensional model design and Power play cube building, security using power play Transformer.
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards using Report Studio.
• Implemented dynamic measures, dynamic column selection in Report Studio.
• Sound Skills in Developing Standard and Complex Dashboard Reports using Report Studio and using Cognos Workspace.
• Strong Experience in developing Custom Portal Tabs and complex Dashboards.
• Sound Skills in developing custom prompt pages using HTML and JavaScript.
• Used Cognos Connection for scheduling and bursting reports across the Business segments.
• Installation of various Cognos tools in Distributed Environment (Development, Test and Production).
• Experienced in performance tuning and optimizing of the reporting solution.
• Expertise in migration from Cognos 7.3 to Cognos 8 BI v4 and Cognos EP Series 7 to Cognos 8 BI latest versions.
• Experience in writing SQL, T-SQL, PL/SQL Packages, Stored procedures as per the business needs.
• Experience in databases like Oracle 10g/9i/8i, MS SQL Server 2005/2000 and DB2.
• Strong knowledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact Analysis).
• Worked effectively on Change Management, Problem Management, Configuration Management and Release Management Processes and developed reports to see the performance of those processes under Business perspective.
• Worked with the business users and provide expertise in problem definition, requirements analysis and the general design of the BI System.Provided support to multiple concurrent projects.
• Participated in design discussion and review session with client solution architect team.
• The ability to work independently as well as collaborate as needed to meet project requirements and deadlines.
• Coordinated with the client representative to resolve any functional and technical issues faced by the project team.
• Excellent written and verbal communication skills and expertise in working with clients and functional teams.

TECHNICAL SKILLS

Reporting Tools: Tableau 9.0, Cognos 10.2.1, 10.1.1, 10.1, 8.1, 8.2, 8.3& 8.4 BI Suite (Framework Manager, Cognos connection, Query Studio, Report Studio and Analysis Studio), CRN 1.1 MR3, Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront)

ETL Tools: Informatica, Data Stage.

Operating Systems: Windows 2003/2008, Enterprise Server, XP, 2000, Windows XP Professional, UNIX-AIX, Linux

Web Servers: IIS, Tomcat and Apache

LDAP Servers: Active Directory, Sun One Directory, Apache Directory.

Programming skills: C, C++, HTML, JavaScript, Visual basic, SQL, PL/SQL.

Databases: MS SQL Server 2000/2005, PeopleSoft 8.9/9.1, Vertica, Netezza, Oracle 8i/ 9i, 10g/11g

PROFESSIONAL EXPERIENCE

Confidential

Lead BI Consultant/Business Analyst

Environment: Tableau 9.0, Oracle 11g, TOAD, Sql Developer, MS Visio, Erwin 8.2, SharePoint

RESPONSIBILITIES:

• Involved in creating database objects like tables, views.
• Thorough knowledge on Eligibility, Enrollment etc., data.
• Created action filters, parameters and calculated sets to see trend analysis of Individuals Eligibility, Enrollment in Medicaid and State Based Market Plans.
• Developed Tableau visualizations and dashboards using Tableau Desktop for Open Enrollment.
• Developed Tableau workbooks from multiple data sources using Data Blending and scheduled them to run weekly for Center for Medicare & Medicaid Services (CMS).
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles.
• Built drill down reports to see the detail information of all the aggregate counts of Eligibility and Enrollments break down by age, gender, financial assistance and people who helped in creating the applications.
• Created complex reports which are sourced to Extracts instead of Live to improve the performance.
• Assign necessary security permissions like Site Administrator, Interactor, and Publisher to users under different Sites.
• Responsible for providing fast and timely Development support for production issues.
• Interacts with the customer to gain an understanding of the business environment, technical context, and organizational strategic direction.
• Conducted User Interviews and documented their query, business analysis and reporting needs.
• Validate the data quality scripts used to reconcile data in data warehouse.
• Involved in data modelling design sessions to produce 2NF data models for OLTP designs and Dimensional (Star Schema) data models for Data Warehouse/OLAP applications using data modeling -best practices- modeling skills.
• Validate the Functional Design documents and Technical design documents for data model, and provide the necessary suggestions to be implemented to improve the performance and provide accurate data through DataMart.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Involved in writing the Report Descriptions and How-to-use guides for the reports that were developed.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.

Confidential

Senior Developer

Environment: MS Visio, Rational Clear Quest, SharePoint, Cognos 10.2.1, 8.4, Framework Manager, Report Studio, Cognos Workspace, Cognos Workspace Advanced, Active Reports, Query Studio, PowerPlay Studio, Analysis Studio, Oracle 11g, TOAD, Sql Developer, Cognos SDK

RESPONSIBILITIES:

• A thorough understanding of the Software Development Life cycle (SDLC) including various concepts such as Requirement Gathering, Experience in the development of Client-Server and Web-Based Application. Possess a detailed-oriented nature with excellent communication, interpersonal, problem solving skills, and recognized for being a valued team player.
• Excellent skills in writing Business Requirement Documents & Functional Requirement Documents.
• Involved in Gap Analysis to bridge the gap between business processes.
• Thorough knowledge on Eligibility, Enrollment, Claims, etc., data.
• Developed the mapping specifications from the business requirements and the data model.
• Created and maintained Framework Manager Models and published to server.
• Implemented parameterized security filters, object level security and data level security to FM Models.
• Create OLAP cubes of size more than 2GB using Transformer.
• Improved the performance of cubes, which were taking 40 hours to build to 18 hours.
• Created scheduling jobs to run the cubes on weekly, monthly, quarterly and Yearly.
• Develop complex reports using custom sql, which could not be developed from existing FM Models.
• Created complex dashboard reports and templates using OLAP cubes and HTML scripts.
• Create Ad-hoc reports using Cognos or Oracle basing on the business requirements.
• Involved in Metadata project to help Users to know the meaning of all the contents in Data warehouse.
• Run backend scripts to filter the definitions for the contents in Data Warehouse.
• Create User Groups and Roles and assign necessary security to Users.
• Publish How-To-Use Guides and other report documents to cognos environment using Cognos Go-Office.
• Installed and configured Cognos 10.2.1 on distributed environment.
• Involved in regression testing and performance testing of environment.
• Migrated Users and User classes from Access Manager to Persona a Motio tool.
• Teach Users on how to use Cognos tool using Computer Based Training (CBT) program.
• Created POC dashboard reports using Cognos Workspace.
• Create and modify SDK scripts to calculate the usage of Cognos by Users and use that data to create database tables.

Confidential, Jersey City, NJ

Senior Lead Cognos Developer

Environment: Cognos 10.1.1, Framework Manager, Report Studio, Business Insight, Business Insight Advanced, Active Reports, Query Studio, Oracle 11g, Vertica, Sql Server 2008, TOAD, Sql Developer, Cognos SDK

RESPONSIBILITIES:

• Managed a team of 4 developers, 4 being in offshore
• Developed the mapping specifications from the business requirements and the data model.
• Involved in gathering the business requirements for ADHOC reporting purposes.
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
• Used Star Schema modeling technique to develop models
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Built complex/summary query subjects, reusable filters and calculations based on relational data sources.
• Created Dashboard reports using Cognos 10.1.1 &Cognos Insight.
• Created dashboards, charts/ graphs, drill-through reports, master-detail reports to meet the required specifications.
• Created simple list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations and conditions.
• Developed Reports using Conditional Formatting, Cascading Prompts, and optional prompts. Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Developed compliance reports, staffer reports, heatmap reports and bursted them across several regions, business unit level and integrated them in a Cognos dashboard.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Scheduled reports using Cognos scheduler and emailed to various recipients when required.
• Worked on TOAD, SQL Server 2008, and Vertica for database systems for creation of adhoc queries and for improving various performance issues.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports
• Trained End users (Bankers, Staffers, Executive Directors, Vice Presidents, Etc.,) to operate the reports.
• Tuned performance of Reports for large data
• Created dashboards to integrate into the SharePoint.
• Created an SDK that will call the Burst report with securities implemented.

Confidential .Kent, WA

Senior Cognos Developer/Modeler/Admin

Environment: Cognos 10.1.1 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Business Insight, Business Insight Advanced), Netezza, Cognos AD, Sterling, Linux, MotioPI.

RESPONSIBILITIES:

• Consulted with user management and staff throughout all stages of the development cycle to ensure that systems achieve the user’s business objectives.
• Installation & Configuring the Cognos 10.1.1 on Linux Environment.
• Customized Cognos portal and worked on some XML files to build the customized cognos portal.
• Implemented Third Party Security with AD and created users and user roles.
• Created and maintained Cognos jobs.
• Worked on Cognos Administration in assigning Users, Groups, and User roles with access permissions.
• Created and maintained Cognos packages in Framework Manager.
• Developed Business view of the data (Metadata Models) with Namespaces, Folders, Query Subjects and Query Items in Framework Manager.
• Expertise in deploying packages and reports to Production environment and handling production issues.
• Involved in gathering the business requirements for ADHOC reporting purposes.
• Documentation of the gathered requirements and creation of functional design documents.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Built complex/summary query subjects, reusable filters and calculations based on relational data sources.
• Created securities in Framework Manager using data level, object level and package level securities.
• Created Repository, performed backup and recovery of metadata, developed user security model.
• Developed Complex Dashboard Reports in Report Studio, ad hoc reports in Query Studio as per the requirements.
• Created dashboards, charts/ graphs, drill-through reports, master-detail reports to meet the required specifications.
• Used Java scripts for developing/customizing-advanced techniques in reports.
• Created Dashboard Reports using Business Insight.
• Created Active Reports for the Business Users.
• Developed various reports - MTD, QTD, YTD reports
• Created simple list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations and conditions.
• Developed Reports using Conditional Formatting, Cascading Prompts, and optional prompts.
• Used Conditional blocks/variables and associated them with queries to show data only when the conditions were satisfied.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.

Confidential, Fort Worth TX

Lead Cognos Developer

Environment: Cognos 10.1, 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer), Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront), DB2, Cognos LDAP, Windows-XP, Unix.

RESPONSIBILITIES:

• Involved in gathering the business requirements for ADHOC reporting purposes.
• Documentation of the gathered requirements and creation of functional design documents.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Developed Business view of the data (Metadata Models) with Namespaces, Folders, Query Subjects and Query Items in Framework Manager.
• Built complex/summary query subjects, reusable filters and calculations based on relational data sources.
• Documenting and understanding the existing system designs and then building the PowerPlay Cubes.
• Created cubes in Transformers using the data source and externalized query subject from Framework Manager.
• Created securities in Framework Manager using data level, object level and package level securities.
• Created Repository, performed backup and recovery of metadata, developed user security model.
• Developed Complex Dashboard Reports in Report Studio, ad hoc reports in Query Studio as per the requirements.
• Created dashboards, charts/ graphs, drill-through reports, master-detail reports to meet the required specifications.
• Created Dashboard Reports using Business Insight and Go Office.
• Created Active Reports for the Business Users.
• Created simple list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations and conditions.
• Developed Reports using Conditional Formatting, Cascading Prompts, and optional prompts.
• Used Tabular SQL for some of the Complex Reports In Report Studio.
• Used Conditional blocks/variables and associated them with queries to show data only when the conditions were satisfied.
• Developed multidimensional reports based on Cognos cubes and third party OLAP sources.
• Deployed packages and reports to production environment.

Confidential IL

Lead Cognos Developer/Business Analyst

Environment: Cognos 10.1.1, 10.1, 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer),Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront), SPSS, Oracle 11i, PeopleSoft 9.1, Sql Developer, Cognos LDAP, WindowsXP, SAS.

RESPONSIBILITIES:

• Identify the Business requirements from understand record them in the format that can be reviewed and understood by both Business and Technical Users.
• Gathered & analyzed the end-user business requirements.
• Interacts with the customer to gain an understanding of the business environment, technical context, and organizational strategic direction.
• Review the Business requirements document (BRD) with Business Users and Subject Matter Experts (SME’s) and include representations from Technical Team as well.
• Defines scope, plans, and deliverables for assigned projects.
• Worked effectively on Change Management, Problem Management, Configuration Management and Release Management Processes and developed reports to see the performance of those processes under Business perspective.
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
• Developed technical specifications and deployed efficient Business Intelligence solutions
• Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic with reporting viewpoint.
• Used Snow flake Schema modeling technique to develop models
• Added some new Geography tables to Existing model and fixed Data Issues in the Framework manager.
• Experience in integration of various data sources like Oracle, SQL server and MS access into staging area.
• Implemented Third Party Security with Active Directory and use those in creating Data Level, Object Securities in Framework Manager Models.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Developed dynamic drill down, expand collapse, on-click sort using Java Scripts.
• Implemented dynamic measures, dynamic column selection in Report Studio.
• Used Cognos Transformer to build multidimensional cubes and used it in Dashboards.
• Analyzing all reports and standardize these reports or redesign them and improve the performance using Power Prompts and Charts.
• Created Reports using PeopleSoft data for payroll implementation.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports
• Performance Tuning and load balancing of complex reports.
• Used Union, Intersection, Joins, Except for creating queries.
• Developed various reports - MTD, QTD, YTD reports.
• Design and creation of Multi-Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed.
• Migrated Cubes from Version 7.4 to 8.4 and from 8.4 to 10.1.
• Created Dashboard reports using Cognos 8.4 &Cognos Insight.
• Developed and modified Power Play reports and graphs with different layouts according user requirements.
• Documenting and understanding the existing system designs and then building the PowerPlay Cubes.
• Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.
• Worked on import and export utility in Cognos connection to move all the packages and content store into production environment.
• Involved in migrating reports from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.
• Wrote and executed the test cases for various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Involved in writing the Report Descriptions and How-to-use guides for the reports that were developed.

Confidential MA

Lead Cognos Developer

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
• Developed technical specifications and deployed efficient Business Intelligence solutions
• Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic with reporting viewpoint.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models
• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Developed dynamic drill down, expand collapse, on-click sort using Java Scripts.
• Implemented dynamic measures, dynamic column selection in Report Studio.
• Used Cognos Transformer to build multidimensional cubes and used it in Dashboards.
• Developing Analysis Studio views of analysis from dimensional modeled packages.
• Designed and developed dashboard report using PeopleSoft data to develop a customized interface of HR to Financial.
• Validated reports by writing sql in PeopleSoft database and also to verify the data from PeopleSoft database to the Data warehouse.
• Create the scorecard reports using the Metric Studio.
• Analyzing all reports and Standardize these reports using Power Prompts and Charts
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports
• Design and creation of Multi-Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed.
• Documenting and understanding the existing system designs and then building the PowerPlay Cubes.
• Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.
• Implemented developing and deploying Stored Procedures, Triggers, DTS Packages, SQL Jobs, Data Imports and Transformations. Involved in the integration and conversion of applications using SSIS.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Involved in Informatica administrative work such as creating Informatica folders, repositories and managing folder permissions. Involved in installation of the patches for Informatica power center.
• Involved in migrating reports from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.

Environment: Cognos 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Power Play 7.2, Cognos Transformer 7.2, SQL Server 2005/2008, MySQL, SSAS, PeopleSoft 9.1, Informatica Power Center/Power Exchange 8x, Flat files, Toad, SQL Developer

Confidential NJ

Cognos BI Report Author/Admin

Responsibilities:

• Analyzed Business requirements from the analysts.
• Involved to analyze and map data from source systems to target operational data stores and data marts (Data warehouse).
• Designated Enterprise-wide Data Warehouse.
• Installation of various Cognos tools in distributed environment (Development, Test and Production).
• The work related to finalizing and testing/debugging IQDs, appropriate documentation and functional training in designing, building, and maintaining cubes in Cognos 8 BI v8.4.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Developed Various SAS reports in Cognos environment.
• Developed Cognos Portal integration &Cognosportal design.
• Deployment of reports from one environment to another environment.
• Cognos trigger to start the building of cubes once the database is refreshed for each month.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Reviewed the Cognos Framework Manager model developed in development environment by other team members. Upgraded reports from 8.2 to 8.4.
• Deployed reports into servers in Cognos connection.
• Migrated reports from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI (8.2 and 8.4)
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production

Environment: Cognos 8.4(Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), JavaScript and HTML, Oracle Data Integrator(ODI),Oracle Database 10g,Impromptu 7.4,Argus Safety 4,CognosPowerPlay 7.3, Cognos Transformer 8.4,Windows XP Professional, SAS, Unix, VB Script, T-SQL, XML and HTML.

Confidential VA

Cognos Developer

Responsibilities:

• Customized Cognos Connection with appropriate reports and security measures
• Worked on Analysis Studio to develop multi-dimensional reporting
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in Designing models using Framework Manager and deployed packages to the Report Servers
• Implemented Star Schema Grouping and Dimensional Hierarchy in Framework Manager Model.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Developed models in Cognos 8.4 Framework manager and 8.4 Transformer.
• Created Dash board reports to get all the information from other reports.
• Developed Cognos Portal integration &Cognosportal design.
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager in Report Net
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio
• Involved in assess and analyze large data sets for completeness and quality
• Built Power Play Reports based on the cubes and published to Report Net Server

Environment:Cognos8.2/8.3 BI Suite, Cognos Report Net 1.1 MR3 (Framework Manager, Report Studio, Transformer and Query Studio),DB2, Impromptu 7.4,Cognos Power Play 7.4, Cognos Transformer 7.4,Informatica 7.0,T-SQL, XML and HTML.

Confidential

Oracle Developer

Responsibilities:

• Created database for Dev/ Test environment in Oracle.
• Created users, roles and privileges on the Oracle databases.
• Created user groups, roles, privileges using Business Objects Supervisor.
• Created and configured database for development and production environments in SQL Server.
• Developed SQL Scripts in Oracle to validate data quality.
• Developed stored procedures and database triggers using PL/SQL.
• Performance monitoring and tuning of SQL Scripts in Oracle using Explain Plan.
• Developed Business Relationship Diagrams (BRD) and E- R diagrams.

Environment: SQL Server 2000, Visual Basic 5.0/6.0, Developer 2000, SQL* Plus, PL/SQL Oracle 7i, Windows, and Windows NT 4.0