SUMMARY

• 5 years of Business Intelligence experience as a Tableau Developer and Tableau Administrator using Tableau 9.3,9.2,9.1, 8.1,8.2, 7(Tableau Desktop and Tableau Server)
• Experience in configuration of backgrounds jobs, scheduling of teh extract refresh activity, troubleshooting failed refresh activity, monitoring dashboards performance on tableau server.
• Extensive knowledge in design of Tableau Architecture.
• Designed teh architecture of Tableau security by customizing teh access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt's, Bubbles, Histograms, Heat maps and Highlight tables.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating wif other platforms and also monitoring critical tableau parameters of tableau server.
• Installed and Monitored of Tableau Server (Dev and Prod) on AWS Environment.
• Implemented AWS security features in Tableau Server to enable a single report or dashboard to securely serve teh needs of a broad and diverse user base, including both internal and external users
• Used performance monitoring tool of Tableau desktop to analyze teh performance of data heavy dashboards and implemented teh best practices to improve teh end user experience
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Managed cross-functional teams through Software Development Life Cycle.
• Around 7 years of experience Cognos Series 7, Series 8 and Series 10 - Impromptu 7.1/6.6/6.x, PowerPlay, Transformer, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server, CognosDecisionStream, Scripting, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Map Manager, Business Insight, Business Insight Advanced, Active Reports.
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms. Expertise in defining teh multi-tiered Cognos Architecture, Performance tuning, Security infrastructure and Deployment work flows from Prod, Dev and Test environments. Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
• Sound Skills in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8/10.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 and from Cognos 8.x to 10.x. Complete understanding of key & important milestones associated wif migration from Cognos Series 7 and Reportnet or Cognos 8.x.
• Experience in OLTP Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star and SnowFlake) using ERWin (Conceptual, logical and physical data models).
• Knowledge of tools such as Erwin and MS Visio Professional.
• 8 years of experience using Oracle 8i/7.x, Developer 2000, DB2, PL/SQL, SQL*Plus, Win NT 4.0, Linux. Experience in Oracle PL/SQL programming (Collections: Nested tables/VARRAY, Functions, Procedures, Packages, Triggers, Indices and database objects) and Shell Scripting (C Shell, K Shell, Bourne Shell). Posses advanced MS Excel and MS Access skills.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually. Proven experience at building, training, motivating and leading professional teams, managing projects and supporting client relationship.

TECHNICAL SKILLS

BI TOOLS: Tableau 10x, 9x, 8x (Desktop, Tableau server and Tableau Online), Cognos(v10.2,v10.1,v8,ReportNet1.1/1.0x,Cognos Impromptu 7x/6x, Impromptu Web Reports (IWR), Power Play, Power Play Transformer 7x/6x, Cognos Administration, Upfront, Power Play Enterprise Server, Scheduler, Business Insight, Business Insight Advanced, Active Reports, Report Studio, Framework Manager, Cognos Mobile, Cognos for MS Office), Planview 10

DATABASE: Oracle 8i/9i/10g/11g, Teradata, MS SQL Server 2005/2008/2012, DB2, Netezza

DATAMODELING: Erwin, Microsoft Visio.

ORACLE TOOLS: SQL*Plus, Toad, SQL*Loader, PL/SQL Developer.

LANGUAGES: SQL, PL/SQL Programming, C,C#, Python.

ETL TOOLS: Informatica

OPERATING SYSTEMS: MS Windows NT/2003/XP/ME/95/98, Windows 7, Windows 8, UNIX.

WEB: HTML, XML, and JAVASCRIPT

WEB SERVERS: IIS, Netscape Enterprise Server, IE

APPLICATION SERVERS: Apache Tomcat, Web sphere application server(WAS 6.0)

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Sr. Tableau Consultant/ Site Administrator

Responsibilities:

• Involved in Technical decisions for Business requirements, Interaction wif Business Analysts, Client team, Development team, Capacity planning and upgrading of Tableau Servers.
• Worked extensively on various Tableau projects also worked as a Tableau Server Admin in maintaining and managing several business requests & POCs.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand teh data on teh fly wif teh usage of quick filters for on demand, needed information.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Used SQL to pull complex data from teh backend systems wif a goal of presenting and visualizing them in Tableau.
• Provide future forecast analysis and identify past trends for different investments and market segments.
• Developing and maintaining high level overview of teh project and design flows using MS Visio.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views in Cisco information Server.
• Improving Database query performance by using Assuming Referential Integrity option or other techniques for better and accurate outcome of reports.
• Worked on drill through reports by creating HTML references.
• Core member for integration of Tableau Reports wif Asp.Net web application and usage of JavaScript API.
• Implemented Company wide user security filters for different department heads wifin teh company in teh Tableau workbooks.
• Published Tableau data source, workbooks wif extracts and live connections to teh Tableau server based on teh user requests.
• Created ETL (Informatica) mappings and workflows to fetch data from multiple data sources and load it into teh data warehouse.
• Followed Landing and Dimension/Facts model structure for data cleansing and transformations on teh data.
• Migrated teh objects from Informatica lower environments to higher environments using labeling option through Deployment groups.
• Configured variables in teh mappings and workflows and passing teh values through a parameter file defined and placed in teh server box.

Environment: Tableau 9.3(Tableau Desktop, Tableau Reader, Tableau Online and Tableau Server), SQL Server, Cisco Information Server. MS Excel, MS Visio, Informatica

Confidential, Lexington, MA

Tableau Admin/ Tableau Developer

Responsibilities:

• Worked wif business stakeholders in requirement gathering sessions to understand teh business needs and data model design documents to come up wif teh Tableau Mockups and Templates.
• Leverage strong analytical and problem-solving skills to identify and deliver actionable insights to relevant decision makers.
• Maintained and Installed Tableau Server and also Configured teh Tableau Server
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups Tableau repository and also worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine.
• Setup trusted autantication Tableau server and pass requests from Web server.
• Setup Distributed Server Environments for optimum Load Balancing and used efficient load balance techniques to manage teh load on teh concurrent users.
• Experience wif Tableau maintenance tools and Tableau Server monitor to Start/Stop services and maintain statuses.
• Created different KPI’s using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations and aggregation options).
• Migrated reports from Hyperion to Tableau 9.3.
• Developed reports from Hyperion Interactive reports and SQR reports to Tableau dashboards.
• Created complex dashboards using filters, calculations based on requirements, drill-through and Linked reports.
• Used SQL to pull complex data from teh backend systems wif a goal of presenting and visualizing them in Tableau.
• Worked extensively wif Advance analytics like Reference Lines and Bands, Trend Lines and created various graph reports like bars, Bar stacked, side-by-side, pie charts, Gantt charts, area graphs, line graphs, Scatter plot, Bubble charts, Whisker plots, Pareto charts, Dual axis graphs, Waterfall model.
• Developed Donut charts for analyzing for different types of deviations in all projects and Gantt Charts for Project time line status.
• Involved in creating compound and dynamic reports wif sets, groups and hierarchies.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Improving Database query performance by using Assuming Referential Integrity option or other techniques for better and accurate outcome of reports.
• Expert level capability in Tableau calculations, applying complex and compound calculations to large data sets.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9.3desktop/Server.
• Actively participated wif Architect in decision and moving to Cloudera from Tabular models.
• Worked on merging multiple tableau workbooks to create a single workbook.
• Implemented user security filters in teh Tableau workbooks.
• Published Tableau data source, workbooks wif extracts and live connections to teh Tableau server based on teh user requests.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure dat teh views and dashboards were displaying teh changed data accurately.
• Involved in Upgrade of Tableau Server from one version to another and also Created Users Groups Projects Workbooks and assigned Access levels in Server
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand teh data on teh fly.
• Worked wif Off shore team to connect for data points in order to satisfy our reporting requirements.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling and server related issues.

Environment: Tableau 9.3, Tableau v9.1 (Tableau Desktop, Tableau Reader, Tableau Online and Tableau Server), Cloudera Hadoop (Hive, Impala). MS Excel.

Confidential, New York City, NY

Tableau Developer/Admin

Responsibilities:

• Worked on teh development of Dashboard reports for teh Key Performance Indicators for teh top management.
• Involved in discussing Requirement Clarifications wif multiple technical and Business teams and created Technical Design Document from teh functional specification documents.
• Utilized Tableau Analytics to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies dat drive value.
• Designed a Tableau Architecture and installed Tableau on Cloud based on number of Business Users.
• Generated visuals in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Design and deployed rich Graphic visualizations wif Drill Down and Drop down menu option and Parameterized using Tableau and provided these visuals in Tableau online and Reader to Stake Holders.
• Generated context filters and used performance actions while handling huge volume of data.
• Created multiple Adhoc dashboards in Tableau in order to represent teh status like strength and weakness etc. for teh business users at a glance.
• Created dashboards for financial department such as accounts payable, accounts receivables, Cash management and Asset management for Finance Team.
• Developed dashboard related to Asset management department for asset category and subcategory, depreciation and asset retirement.
• Created Data Extracts (.tde) for Tableau Desktop and Server using Python language.
• Involved in reviewing business requirements and analyzing data sources Apache Hive, Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects wifin Tableau Desktop.
• Worked on Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).
• Created tables, views, materialized views wif indexes in SQL Server to tune teh performance.
• Installed and Monitored of Tableau Server (Dev and Prod) on AWS Environment.
• Installed teh Tableau Server on teh EC2 instances and configure teh instances, VPC setup, Auto Scaling for availability of EC2 instances as primary and worker servers.
• Designed and setup User security for teh entire Landscape to facilitate Windows AD login.
• Implemented AWS security features in Tableau Server to enable a single report or dashboard to securely serve teh needs of a broad and diverse user base, including both internal and external users
• Created incremental refreshes for data sources on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created report schedules, data connections, projects, groups in Tableau server.
• Administered users, user groups, and scheduled instances for reports in Tableau.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Used Java Script API to customize teh views, selects, filters, date and time.
• Modeled, optimized and normalized teh CRM data mart; led teh development of teh ETL process.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Salesforce and MS-SQL Server.
• Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, DDL, DML and User Defined Functions to implement teh business logic and also has knowledge in creation of clustered and non-clustered indexes.
• Modified teh existing SSIS packages to meet teh changes specified by teh users.
• Scheduled Jobs for executing teh stored SSIS packages, which were developed to update teh database on Daily basis
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: Tableau 9.0, Tableau v8.2 (Tableau Desktop, Tableau Reader, Tableau Online and Tableau Server), Oracle12g (SQL, PL/SQL), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Python 2.7.

Confidential, Pittsburgh, PA

BI Tableau Developer / Cognos Developer

Responsibilities:

• Worked on Tableau Dashboards in Tableau 8.1 and Demonstrated knowledge in dealing wif various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy teh end users.
• Developed dashboards, reports as per teh requirements wif appropriate guided navigation.
• Created Data Connections, published on Tableau Server for usage wif Operational/Monitoring Dashboards.
• Develop, organize, manage and maintain graph, table, slide and document templates dat will allow for efficient creation of reports.
• Created and assisted users in Tableau dashboard development.
• Created Tableau worksheet which involves Schema Import, Implementing teh business logic by customization.
• Extensively used advanced filtering capabilities and created calculated fields for Analysis depending on teh user requirements in Dashboards.
• Created contextual filter for improving teh performance.
• Worked on Developing a Data mart for dealer sales connect and developed SQL views on teh mart to facilitate BI reporting on teh same.
• Installed and Configured Cognos 10.2.1 BI in single server Environment.
• Design and Developed teh Framework Manager models using Stored procedures, Relational tables and published in to server.
• Used data blending options of tableaufor different datasources to create a consolidated view.
• Involved in Upgrading Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10.2.1 and solved teh issues in teh existing model.
• Developed Interactive Active/Mobile Reports for browsing and exploring data offline.
• Worked wif Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Extensively worked in Scheduling and Deploying (Staging to Production) Reports.
• Created reports wif Optional filters and custom prompt pages (using HTML and Prompt API) in Report Studio.
• Developed summary and detailed level dashboard to enable drill down option. This features helps business to deep dive into teh data whenever required.
• Upgraded Reports prompt pages wif Prompt API by replacing embedded JavaScript.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developing teh Dashboard reports using MDX Functions.
• Developed Dashboard reports to display all teh information related to environment using Summary reports.
• Created Complex, multipage reports using teh reporting features like Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, and Drill Up
• Used Slice & Dice and Drill through techniques in Standard Reports and Business trend Reports using Multidimensional cubes.
• Build various interfaces to integrate Planview data wif organization other applications data.
• Involved in Planview BO Universe, BO reports development for new business enhancements and has to assist business ad hoc report developers.
• Understand, explain business requirements and direct them in right direction in implementation phase.
• Designed and implemented 10.2 Dynamic Cube instead of migrating teh cube using Transformer 10.2 from 8.4.
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports
• Developed all teh mappings according to teh design document and mapping specs provided and performed unit testing.
• Involved in loading data between Netezza tables using NZSQL utility.

Environment: Tableau Server v7/8, Tableau Desktop v7/8,Cognos 10.2.1,Cognos 8.4(Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced Cognos Transformer 8.3/8.4/10, Cognos Transformer 7.4, Cognos Mobile, Cognos for MS Office, Netezza 5, Oracle11g (SQL, PL/SQL)

Confidential, Scranton, PA

Sr. Cognos Developer / Lead

Responsibilities:

• Assisting teh client, through analysis of their existing system, challenges, and business needs. Documented teh reporting requirements and interacted wif Business users and collected business information and their requirements for developing teh project.
• Analyzed teh functionality and business requirement and transformed teh Functional Design Document into Technical Design Document
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments. Crete/Maintain Cognos User classes and groups wif Windows Role Based Structure and user account provisioning
• Developed Active Reports target on me pads and Mobiles.
• Built an reports for Blackberry, Apple using IBM Business Intelligence.
• Developed sophisticated interactive dashboards by using Business Insight Advanced.
• Developed Cognos reports, dashboards, metrics, analysis using Cognos Mobile.
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and connecting to teh Enterprise Data warehouse (EDW).
• Also built Framework Manager Models for Ad hoc Reports and building Dashboards.
• Involved in ETL process by requesting teh ETL team for custom calculation columns and complex logics to be implemented at teh database level, in order to improve teh performance of teh report, while fetch and load data to Various Target Tables
• Created star schema groupings in Framework Manager Models to meet teh reporting requirements, Created Import View, Business View and Star schema grouping Dimensional Views in Framework Manager.
• Implemented Complex row level security apart from teh data level, object level security in teh Framework manager, using teh sessions parameters and security tables.
• Designed and developed numerous list, crosstab, multi-query, multi-page reports utilizing teh master-detail relationship, conditional blocks, conditional formatting, unions, etc.
• Extensively worked on Powerplay Transformer for Data Modeling of teh Rx data, building Multidimensional Cubes. Created numerous power play reports and analysis studio reports using teh multidimensional power play cube. Experienced wif trouble shooting and optimizing cube performance
• Upgraded Framework Manager Models, Transformer Cubes and reports from Cognos Version 8.4 to 10.
• Install/setup Cognos 10.1 software. Upgraded teh Cognos 8.x reports. Troubleshoot upgrade problems/fix issues. Created and managed agents using Event studio, which monitors teh data and performs teh task when an event occur
• Administered teh Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups
• Customized Cognos Connection wif appropriate reports and security measures.
• Created Executive Dashboards, using Business Insight and Business Insight advanced.
• Created and managed agents using Event studio, which monitors teh sales one data and performs teh task when an event occur.
• Design & development of multiple reports using various templates likelist reports, cross-tab reports and chart reports.
• Trained power users to use Business Insight, Business Insight Advanced and Query Studio for Ad-Hoc reporting. Trained professional authors to write complex reports using Report Studio.
• Acted as teh primary contact for cognos support issues from users. Actively interacted and resolved teh issues wif IBM support team on various cognos bugs and defects.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
• Administering teh Servers - Installation, configuration, roles, Privileges and Performance Tuning of teh Servers.
• Developed Custom Portal Tabs and Custom User Interfaces for Reports based on UAT Feedback. Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes.
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Coordinating wif Development Team tasks & Deliverables and working on high priority issues.

Environment: Cognos 10.1, Cognos 8.3/8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced Cognos Transformer 8.3/8.4/10, Cognos Transformer 7.4, Cognos Mobile, Cognos for MS Office, Oracle10g (SQL, PL/SQL), Teradata.

Confidential, Jersey City, NJ

Cognos Admin / Senior Cognos Developer

Responsibilities:

• Understand user requirements and Data Model defined and developed by teh business analysts and data architects in Erwin Data Modeler to understand teh underlying relationships between teh tables.
• Installed and configured Sun One LDAP directory server, IIS server and migrated all teh security from teh old to teh new servers. Migrated Cognos 7 Upfront, IWR reports, PPES, Cubes, automation scripts and all teh scheduled jobs over to teh new data center. Migrated all Cognos 8.4 related content including Cognos Content Store and data source connections.
• Installation of various Cognos tools in distributed environment (Development, Test and Production).
• Customized Cognos Connection wif appropriate reports and security measures.
• Implemented Single sign on Security wif LDAP and Group level security in Cognos Connection Portal.
• Involved in Designing DMR models wif Relational Data using Framework Manager and deployed packages to teh Report Servers, reporting of enterprise data warehouse (EDW). Implemented Framework manager security for Data access, Object level access and Package access based on teh 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.
• Lead and implemented teh migration of impromptu reports and cubes from Cognos series 7 to Cognos8.2. Developed teh few model and packages from scratch based on teh existing catalog and migrated 100+ reports into reportnet, using report studio, based on teh existing impromptu report
• Developed List, cross tab, drill through, master-detail, chart and complex reports, which involved Multiple Prompts in Report Studio.
• Created reports wif 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 Cognos Portal integration &Cognosportal design.
• Reviewed teh Cognos Framework Manager model developed in development environment by other team members. Upgraded reports from 8.2 to 8.4.
• Migrated reports from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI (8.2 and 8.4).
• Trained teh end users to effectively use teh reporting tool to build and customize their ad-hoc reports.

Environment: Cognos 8.2,Reportnet1.1 MR2, Cognos Series 7 (Cognos Power Play 7.3, Cognos Transformer7.3, PPES, Access manager, Impromptu Administrator, IWR), (Impcat2xml, Migratetoc8, Deploytoc8), Informatica 8.6, Oracle 9i/10g,SQL Server 2000/2005, windows 2000, UNIX 5.0.

Confidential, Warren, NJ

Cognos Developer

Responsibilities:

• Installed Cognos Report Net and Framework Manager in an interim environment as a proof of concept.
• Migrating reports from Cognos EP Series 7 (Impromptu reports and catalogues) to CognosReoportNet. Complete understanding of key & important milestones associated wif migration to Cognos Series 7 and Reportnet.
• Imported Meta Data from Multiple Sources like Oracle 8i, Flat files in to Framework Manger.
• Created different projects in Framework manager for data coming from Modules like General ledger to create different types of reports like current assets, fixed assets, liabilities, revenue and expenses.
• Created Business Views and added business values, specific to reporting requirements
• Created, modified and Published Framework Manager Packages on ReportNet Server
• Implemented security using Framework Manager on Package Level, Object Level, Data Access Level For Groups, Roles and Specific Users.
• Generated Ad-hoc Reports, Standard Reports Using Query Studio and Report Studio
• Created Reports of different formats like HTML, PDF, EXCEL and Delimited Text.
• Created Parameters, Prompt Pages using various Prompt types (Value Prompts, Text Box Prompt, Date Prompt, Select & Search Prompt, Interval Prompt on teh reports).
• Created Lists, Groups and Cross-tab reports wif drag and drop functionality.
• Created standard Calculation on Query Item and applied various Filters to Data like Tabular, Group Filters on Query items and formatted teh Reports.
• Created Drill-through connection to link 2 Reports, Book Marks and Conditional Block Lists.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Provided End user Support & training to teh ReportNet users on Report Studio and Query Studio.
• Exposure on Installation of Cognos, Upgrade and configuring on different environments.

Environment: Cognos ReportNet1.1, Framework Manager, Query Studio, Report Studio, PowerPlay Transformer, PowerPlay Enterprise Server (PPES), Impromptu 7.1, Transformer 7.1, PowerPlay 7.1, PowerPlay Enterprise Server 7.1, Access Manager Oracle 8i, Toad, MS-Excel, Windows.

Confidential

Jr. SQL Developer

Responsibilities:

• Used SQL* LOADER to load data into table space.
• Connected to Remote Data Bases using Data Links and pulled required data.
• Designed and developed front-end application using CGI/C ++ programming. Insert, update and deletion were done using these forms.
• Handled Complex queries wif TRANSLATE & DECODE.
• Granting access to different users for teh system
• Modifying teh profiles of different users
• Development and report generation.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality

Environment: Oracle 7x, PL/SQL, SQL*PLUS, SQL*LOADER, SQL Scripts, Developer 2000, Windows.