Manager Sql Server
Resume:
Shardul Desai
Professional Summary:
> Over * years of IT Experience with Analysis, Design, Development,
Customization and Implementation of various Software applications and
generation of reports using Various Databases.
> Over 5 years of experience in Cognos Suits OLTP/OLAP/Data Warehouse
reporting tools Impromptu Administrator, PowerPlay, Transformer,
Access manager, Impromptu Web Reports (IWR), PowerPlay Web Reports
(PPES), Upfront, Scheduler and Visualizer.
> Experienced in Report Net with Framework Manager, Report Studio, Query
Studio and Cognos Connection.
> Over 4 years of Experience working with Cognos 8.x BI tool, Analysis
Studio, Event Studio, Report Studio and Query Studio and Dashboard
reports.
> Created and managed reports in Zero-footprint environment using Report
Net.
> Experienced with Microsoft SQL Server 2000/2005, MSAS, SSAS.
> Working knowledge of designing multidimensional architecture for
Extract, Transform, Load environment with Cognos tools and
Informatica, MS DTS
> Solid understanding of data warehousing, Data Marts, OLTP and OLAP
concepts.
> Expertise in Data Modeling for DW using Erwin.
> Expertise in Business process modeling, Data analysis and Business
Requirement gathering.
> Experienced in developing applications using Oracle 9.x/8.x/7.x,
Forms, Reports, SQL, PL/SQL, SQL Server 2000, and SQL Server 2005
> Excellent Communication, Interpersonal and Organizational skills.
> Experienced in Migration Projects as well Maintenance and support of
existing Reports and OLAP Cubes.
> Provided Professional Cognos & DW Training to the Resources.
> Good team player with excellent communication skills, analytical and
learning new technologies.
Education Qualifications:
MS in Electrical and Computer Engineering
Professional Certifications:
> IBM Certified Report Designer (Exam:COG 112) (Testing ID: SR6409074)
> Brainbench Certification for Cognos
Skillset:
Cognos Impromptu Administrator7.x, Power Play 7.x, Transformer, Upfront,
Access Manager, Impromptu Webreports (IWR), Power Play Web reports,
Powerplay Enterprise Server, Scheduler, Cognos ReportNet1.1 and Cognos 8.x
(Framework Manager, Query Studio, Report Studio, Analysis Studio, Event
Studio, Powerplay Studio, Transformer) Erwin, HTML, XML, SQL, PL/SQL, T-SQL
and C,C++, Windows 98/NT/2000/XP, UNIX, Toad, Oracle 7.x/8.x/9.x,/10g/11g
SQL Server 2000/2005, MS Access,MS DTS, IBM DB2
Experience:
Verizon Wireless, Orangeburg, NY
3/2008 - Present
Sr. Developer/Programmer/Migration Consultant
Verizon Wireless is No one CDMA Provider in USA. The Project goal was to
consolidate their Data Warehouse as well Payroll system. The Project also
involved in Migration from Cognos 7.3 to Cognos 8.3 and 8.4 as well as to
Design and Build New Framework Models, Reports and Cubes for Various
applications.
Hardware/Software:
Cognos 8.3 FrameWork Manager, Cognos Connection, Cognos Report Studio 8.3,
Cognos Query Studio 8.3, Cognos Analysis Studio 8.3, Windows XP
Professional, Oracle 10g,Oracel 11g, Toad 9.0, Linux, Putty, IBM Cognos
8.4
Responsibilities:
> Functional lead on the Modules like Payroll/HeadCount/ELM Applications
> Involved in Full life cycle of the Project from Development, Basic
Admin work, Ad-hoc testing as well Troubleshooting and support for
the production applications.
> Extensive Interaction with Business Users for gathering Businesss
Requirements
> Involved in Development of Cognos 8.3 Reports, Cognos 8.3 Cubes
> Created Complex List Reports, Cross tabs Reports, Drill through,
Master-Detail Relationships, Cascading Prompts, Charts, and Maps.
> Did Detail Analysis of Requirements and Build the Relational as well
as the DMR Modeling for Various Business Applications.
> Build the Customized Framework Packages and Published those to Cognos
Connection Portal
> Customized data by adding filters at both the Framework level and
Report level.
> Formatted reports using conditional formatting
> Experienced with trouble shooting and optimizing cube performance
> Developed advanced Reports using Report Studio, Worked with Dashboard
Reports.
> Set up the Bursting tables in the Database as Well at the Framework
Package Level and Performed bursting among no of user community
> Involved in Installation of Cognos Reportnet 1.1, Cognos Frame Work
Manager 8.3,IBM Cognos 8.4 Framework Manager
> Involved in migration of Cognos Objects from version 7.4 to 8.4
> Troubleshooting and Maintenance of Migrated Reports from Version 1.1
to 8.3
> Did analysis studio Reports for analysis and testing purpose.
> Created organized report folders and other contents on Cognos
connection Portal.
> Customized data by adding filters, Calculations, Prompts, Summaries
and Functions.
> Provided training as well end user support with reports.
> Test and debug cognos Metadata Layers.
> Performed ad-hoc testing.
> Ran SQL queries and Procedures for troubleshooting, testing and
analysis of data
> Ran SQR as well PL/SQL Programs for Data Loading
Solvay Pharmaceuticals, Marietta, GA
10/2007- 3/2008
Cognos BI Developer
Solvay Is a leading and Growing Pharmaceuticals. It has diversified
business, which also involves Manufacturing, Invention of Drugs and by
Products. The Project goal was to create some of the reports and cubes to
meet their requirements.
Hardware/Software:
Cognos FrameWork Manager 8.1, Cognos Connection, Report Studio, Query
Studio, Windows XP Professional, Oracle 10g, Toad 8.6.
Responsibilities:
> Involved in gathering Business Requirements.
> Involved in Creation of Cognos 8 Reports, Dashboard Reports.
> Created Complex Reports using Report studio, Plugged Prompts, Drill
through Master- Detail Reports.
> Built Framework Manager Models, Did Database Connections and Published
to the Reportnet server.
> Created Cognos Cubes and use it in Framework Packages.
> Created burst table and did Bursting of reports.
> Developed No of Charts and customized it according to requirement.
> Experienced with trouble shooting and optimizing Report performance.
> Customized data by adding filters at both the Framework level and
Report level.
> Formatted reports for various Output formats.
> Created organized and formatted reports, folders and other contents on
Cognos Connection Portal.
> Created List Reports, Cross tabs, Cascading Prompts
> Customized data by adding Filters, Calculations, Prompts, Summaries
and Functions.
> Provided Training and End User Support with my reports and also
Knowledge transfer.
Newark Beth Israel Medical Center
8/2007 - 10/2007
Cognos Consultant
Newark Beth Israel Medical Center is among the top 10 leading Medical
Center in the country and The Project goal was to create some dashboard
reports as a Part of Pilot Project.
Hardware/Software:
Cognos FrameWork Manager 8.1, Cognos Connection, Report Studio, Query
Studio, Windows XP Professional, Microsoft SQL Server 2000, MSAS, DTS.
Responsibilities:
> Involved in gathering Business Requirements.
> Involved in Creation of Cognos 8 Reports, Metrics Manager, and
Dashboards Reports.
> Created Complex Reports and also developed charts for various users.
> Built Framework Manager Models, Did Database Connections and Published
to the reportnet server.
> Created MSAS Cubes and use it in Framework Packages.
> Experienced with trouble shooting and optimizing Report performance.
> Customized data by adding filters at both the Framework level and
Report level.
> Formatted reports for various Output formats.
> Created organized and formatted reports, folders and other contents on
Cognos Connection Portal.
> Developed advanced Reports using Report Studio.
> Created List Reports, Cross tabs, Drill throughs, Cascading Prompts,
Charts.
> Customized data by adding Filters, Calculations, Prompts, Summaries
and Functions.
> Provided Training and End User Support with my reports and also
Knowledge transfer.
Farmers Insurance Group, Los Angles, CA
3/2007- 8/2007
Cognos ReportNet Consultant
Farmers is the fastest growing auto insurance company and is a source of
summary information for executives on various components like Claims,
Membership, Customer Service, and Provider Network. The goal of this
project is to automate the entire claims component by making changes to
Data warehouse and create reports for various clients and internal persons.
Hardware/Software:
Cognos 8, FrameWork Manager, Cognos Connection, Report Studio, Query
Studio, Windows XP Professional, Oracle 9i, Toad 8.0, Informatica Power
Center 7.0, IBM DB2
Responsibilities:
> Functional lead in Claims, Events and Exhibits packages. Took
decisions pertaining to the report design.
> Interacted with Business Users for Reporting Requirments.
> Involved in gathering Business Requirments.
> Involved in Creation of Cognos 8 Reports, Cognos 8 Cubes, and
Dashboards Reports.
> Build Model, Created database Connections, and Published Packages in
Frame Work Manager.
> Experienced with trouble shooting and optimizing cube performance.
> Customized data by adding filters at both the Framework level and
Report level.
> Formatted reports for various Output formats.
> Created organized and formatted reports, folders and other contents on
Cognos Connection Portal.
> Developed advanced Reports using Report Studio.
> Created List Reports, Cross tabs, Drill throughs, Cascading Prompts,
Charts, and Maps.
> Involved in Installation of Cognos Reportnet Server, Frame Work
Manager, Report Studio, Query Studio, and Cognos Connection Portal.
> Performed Bursting Reports and Multilingual Reports using Report
Studio and Query Studio.
> Customized data by adding Filters, Calculations, Prompts, Summaries
and Functions.
> Provided Training and End User Support with my reports and also
Knowledge transfer.
> Tested and Debugged Cognos Metadata Layers.
> Performed Unit testing.
Private Health Care Systems (PHCS), Nashville, TN
2/2006 - 2/2007
Cognos ReportNet Consultant
Project goal is to meet the users and get the requirements and develop a
set of reports and for user access and develop a Data Warehouse for
analysis and decision support in areas of Tracking the Physician, Patients,
Costs, by sourcing Data Warehouse system and to Create Reports & Cubes in
for Internal users and Clients.
Hardware/Software:
Reportnet1.1MR1, Framework Manager, Query Studio, Report Studio, Cognos
Connection, Windows 2003, SQL Server 2000, Informatica Power Center 7.0
Responsibilities:
> Involved in Installing and Configuring ReportNet Server, FrameWork
Manager, ReportStudio, QueryStudio and Cognos Connection Portal.
> Involved in understanding the Business in all Departments.
> Interacted with business users for their requirement.
> Involved in Startegic Planning for Cognos ReportNet Framework Model.
> Built Models and published Packages utilizing Framework Manager.
> Created database connections for different data sources.
> Created Reports (Simple & Complex) using Query Studio and Report
Studio for training purpose.
> Created, organized and formatted reports, folders and other contents
on Cognos Connection Portal.
> Created several different types of ad-hoc (Simple List, Grouped List,
Section Heading, Crosstab, and Nested Crosstab) Reports and
represented data graphically by Charts utilizing Query Studio.
Created several different types of Professional Reports (Mailing
Labels, Web Page Style, Cascading, Linked /Drill Through, Production,
Business, Ranking, ets with complex formatting utilizing Report
Studio.
> Created reports for various departments like Finance, Sales, HR,
Inventory, and Production.
> Developed, Customized and Burst Reports using Report Studio.
> Produced Queries and Reports in Multiple Languages, Format, Present
and Distribute Reports utilizing Different Layouts, Multiple Report
Objects and Multiple Logical Pages.
> Involved in Conversion of Impromptu catalogs into Reportnet 1.1
> Created, Ran and Scheduled Reports and Jobs using Cognos Connection.
> Involved with Scheduling and Distributing Reports through Schedule
Management in Cognos Connection.
> Tested and debugged Cognos metadata layer reports.
> Developed Standard templates in Report Studio for developing reports.
> Wrote SQL and Stored Procedures.
> Performed Unit testing for all developed reports.
Andrx Corporation, Weston, FL
11/2004 - 1/2006
Cognos Consultant
Andrx Corporation is a leading specialty pharmaceutical company that uses
innovative science and market insight to develop responsive products for a
changing world. Since its founding Andrx has pursued a growth strategy
combining internal product development, strategic alliances and
collaborations, and synergistic acquisitions of products and businesses.
Hardware/Software:
Cognos Report Net MR1.1, COGNOS EP Series 7.x (Impromptu Administrator,
Impromptu Web Reports Power Play, Transformer, Power Play Enterprise
Server, Access Manager, Server Administrator, Upfront (for Web), HTML, XML,
Netscape Directory Server, Oracle 8i/9i, MS Access, SQL, PL SQL, Toad, and
Window.
Responsibilities:
> Interacted with the users for understanding and gathering business
requirements.
> Involved in the analysis, design, develop, testing, deployment and
user training of analytical &transactional reporting system.
> Involved in development of Report Net with Framework Manager, Report
Studio, Query Studio and Cognos Connection.
> Involved in design and development of user classes, filters,
calculations, prompts and conditions in Catalog and query definition
files in Impromptu Administrator.
> Optimized by assigning relative weights to the tables in the Catalog
and Query Performance (in Governor's settings).
> Discussed business requirements and mapped business needs using Cognos
Transformer.
> Successfully developed and implemented Metrics using Cognos Impromptu.
> Developed Visualizer Charts to make better decisions.
> Created Architect models for business requirements including Joins,
Prompts, and Filters.
> Used Cognos Query for ad hoc Reports and Users design Custom Queries
on the Web.
> Installed, Configured and did Performance Tuning Cognos EP Series as
Business Intelligence tool.
> Involved in Report Administration & Server Administration.
> Performed Data Modeling using Erwin.
> Used stored procedure to return a value (like a function call) and
created a result set in the same way as an SQL SELECT statement.
UPS Supply Chain Solutions, Roswell, GA
7/2003 - 11/2004
Cognos Developer
UPS is the world's largest package delivery company and a global leader in
supply chain services, offering an extensive range of options for
synchronizing the movement of goods, information and funds. Its business
unit, UPS Supply Chain Solutions, offers transportation and freight
services, logistics and distribution, consulting, and international trade
services.
Hardware/Software:
Cognos Impromptu 6.06, Cognos Power Play 6.6, Cognos Transformer, Cognos
Impromptu Web Reports, Cognos Power Play Enterprise Server, Access Manager,
Cognos Upfront, SQL *Loader, Oracle 9.0, Windows NT/2000.
Responsibilities:
> Extensively interacted with Business Users and gather information and
requirements.
> Developed and created classes with Dimension & Measure Objects and
specified the hierarchies.
> Worked extensively on Oracle database. Troubleshoot for SQL
issues/performance issues.
> Installed and configured Cognos Power Play and Impromptu software.
> Participated in the development of catalogs, multiple queries with
complicated reports and query definition files using various join and
filter conditions in Impromptu.
> Created Dimensional Maps, Transformer Models, Power-Cubes and Drill
through.
> Performed detailed reports, catalogs, folders filters, prompts,
calculated columns and conditions for multi dimensional analysis.
> Defined, and created Impromptu web reports using Distribution Shuttle
Builder.
> Published on IWR Server.
> Worked extensively with Power Play Enterprise Server and the Upfront
in publishing the cube.
> Automated tasks with Cognos Scheduler using Macros, Cognos Script
Editor and Cognos Script Dialog Editor.
> Created Snapshots to minimize data processing when the network traffic
for the database is heavy.
> Optimized Catalog by using Database Interaction, Client/Server
balancing, Database functions, Table Weighting and Qualification,
Governors Settings.
Prudential Financials, Newark, NJ
9/2002- 7/2003
Cognos Developer
Prudential Financials is one of the leading financial Corporations in North
America. Used Cognos as front end and Oracle as back end and ReportNet to
develop and publish web reports.
Hardware/Software:
Cognos Impromptu, Power Play, PP Enterprise Server Oracle 8, Windows
NT/2000, Upfront (for Web) and Access Manager.
Responsibilities:
> Designed and developed catalogs that reflect business view of the
data.
> Extensively interacted with users to develop catalogs and various
reports as per their requirement.
> Integrated multiple feeds from relational sources.
> Extensively used Power play Transformer to move relative data mart
data into power cubes and Power play reports.
> Automated reports and cube generation through scheduler using macros.
> Published Impromptu Web Reports using Distribution Shuttle Builder
created posting folders, plp file to NT server.
> Published cubes and power play reports to UPFRONT through PPES
administration.
> Trouble shot and evaluated report effectiveness by tuning query data's
and controlling user access.
> Installed various Cognos tools, performed ODBC connections/defined
data sources.
Contact this candidate