Manager Sql Server

Professional * Years of IT experience in OLAP Business Intelligence

• Strong experience on Cognos 10,Cognos 8.4.1,Cognos 8 BI, Cognos 7 Series

• Expertise in Cognos 8.2 and 8.4.1 with Framework Manager, Query & Report Studio and Cognos Connection and Event studio.

• Experienced in Cognos 10 with Framework Manager, Query & Report Studio and Cognos Connection.

• Expertise in the development of Cognos Impromptu, Cognos Transformer, Power Play Reports.

• Strong experience in Cognos products Implementation including customization of Cognos connection, Installation, Configuration and Creation of Content Store, Content Manager.

• Strong Knowledge with Transformer model design and Decision Power play cube building

• Worked on SDK and Java Scripts to automate the process of generating the Cognos reports and storing them on the network drive.

• Expertise in the development of Cognos Impromptu, Cognos Transformer, Power Play Reports.

• Experienced in Business Objects XIR2 and 6.5.1 BO Developer Suite (Broadcast Agent, Document agent, Supervisor, Designer, Info View, Reporter, Explorer), BO Web Intelligence (Webi).

• Extensively worked on publishing of (IWR) Impromptu web and PowerPlay web Reports using Cognos upfront.

• Extensively worked on Cognos Report XML.

• Developed Dashboard Reports using Cognos 8.4

• Implemented the Dashboard reports with the various Cognos Dimensional Functions.

• Involved in installation Cognos 8.4 Suite on Windows servers

• Familiar with PAM product interface and functionality.

• Extensively worked on Powerplay Transformer for Data Modeling of the corporate data for building up of Multidimensional Cubes.

• Designed and implemented database and reporting solutions using SQL, MDX and XML.

• Strong analytical and conceptual skills in database design and development using Oracle.

• Very Good Knowledge in Cognos Planning and Cognos TM1 9.4

• Strong knowledge in Teradata Basics , Advanced SQL and Architecture

• Strong knowledge in Teradata Application Utilities like BTEQ, Fast Load, Fast Export, Multi Load and Tpump.

• Knowledge of other tools like Ab Initio.

• Extensive Unix Shell Scripting knowledge.

• Familiar in Extraction, Transformation, and Loading using Data stage.

• Responsible for interacting with business partners to identify information needs and business requirements for reports.

• Familiar with SDLC and other related development methodologies.

• Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process.

• Proactive and full of initiative versatile team player with proven problem solving abilities.

• Exceptional communicator, focused on building strong client relationships.

Technical Skill Set:

Operating System Win NT 4.0, Win 95/98, Win 2000/XP, AIX UNIX

IBM Cognos 10.1 Report Studio, Query Studio, Cognos connection, Event Studio, Transformer, Business Insight, Business Insight Advanced

IBM Cognos 8x Report Studio, Query Studio, Cognos connection, Event Studio, Transformer, Analysis Studio

Cognos Series 6x & 7x Impromptu Administrator, Impromptu, Impromptu Web Reports, Cognos PowerPlay Transformer, PowerPlay User, PowerPlay Web Reports, PowerPlay Enterprise server, Upfront Administration, Access Manager Server, Configuration Manager

Modeling Tools Cognos Framework Manager ,Erwin

ETL Tools Informatica PowerMart/PowerCenter 8.1.1/7.1/ (Designer, Repository, Workflow and Server Manager, Workflow Monitor, Session Manager)

Others BI Tools Business Objects XIR2 and 6.5.1, MicroStrategy 7.x and Crystal reports, IBM Cognos TM1 9.4

Language SQL, PL/SQL, Visual Basic, ASP, JSP, JavaScript

Databases Oracle 10g, Oracle 9i,Toad 10.5 SQL-Server 2000/2005, MS-Access,DB2,Sybase

Others XML, HTML, VBScript, JavaScript, DHTML, VSS,PAM Product, MDX

Packages MS Office, MS Access, MS Publisher, Visio

Education Qualifications:

• Master of Computer Application (MCA)

Cognos Certifications Acquired:

Certification Name Institution Certified Date

Cognos ReportNet Product User Cognos 09/06/2007

IBM Cognos 8 BI Author IBM Cognos 22/03/2010

IBM Cognos Administrator IBM Cognos 30/04/2010

Professional Experience:

Commonwealth of Massachusetts May’10 to Present

Boston, MA

Sr. Cognos Developer

The Pharmacy Code of Conduct (PCOC) regulation requires pharmaceutical and medical device manufacturers that employ marketing agents in the state of Massachusetts to disclose to the state information on payments made to certain health care professionals. These health care professionals are referred to as “covered recipients” in the regulation language. Covered recipients are certain health care professionals that make decisions or have influence over the prescribing of drugs and devices to patients and also the purchasing of drugs and devices for facilities

Responsibilities

• Analyzed client’s user requirements for systems applications while designing, developing, testing, implementing.

• Interacted Business team in the areas such as functional and technical design, coding, and testing. Supporting the SDLC (Software Development Life Cycle) through design, testing code, debugging, cutover and documentation

• Involved in Installation and configuration of Cognos 8.4.1 and Configured Web server and Cognos configuration different dispatchers and gateways.

• Created Framework Manager Models using normal joins, Applied filters, calculations and created a packages and published using Framework Manager.

• Created Parameter Maps for resolve a complex logics using Framework Manager

• Involved in Migrating of the content store from Cognos 8.4 to Cognos 8.4.1 Version.

• Created different list Reports and cross tab reports using Report studio as per the requirement.

• Created different prompts and filters at summary level and detail level in report studio.

• Created Drill through and Master Detail reports in report studio

• Created reports using manual SQL for improving performance.

• Created a JavaScript’s resolving the complexity in prompt page

• Created chart reports using deferent chart in report studio

• Working with Cognos connection to run and schedule the reports as per the requirements.

• Creation of jobs in Cognos connection to run multiple reports at a time or in sequence as per the requirement.

• Created Cubes and schedule to cube build weekly and monthly.

• Created deployment achieves ( Export files) for the reports and Content store to import to deferent QA,ST and Production server environments

• Deployment of reports to the servers using content administration.

• Performed unit testing, integration testing, system testing and UAT of reports on different server environments.

• Frequently testing performance of the reports, Monitoring and Customizing reports through Cognos interface.

• Used share point to upload project documents and used Clear quest toll to maintain tasks

Environment: Cognos 8.4 and 8.4.1 (Cognos Report Studio, Query Studio, Analysis Studio, Cognos Connections, Event Studio, Framework Manager), SQL Server, Oracle 10g,Toad, Java scripts, Cognos SDK Windows, Windows 2003 server.

State Street Corporation, MA Jun’09 to March’10

Sr. Cognos Developer (SSgM)

This project is to provide PAM users with a simple to use reporting interface which utilizes the latest web-based technology. We have been developing reports for the business areas like Accounting, Analysis, Cash, Holding, Operations, Transaction, and Performance measurement using Cognos 8.2 with highly customized as well as formatted prompt/Report pages involving Cognos utilities and java scripts and been Migrating reports from Cognos 8.2 to 8.4 version.

Responsibilities

• Analyzed and understood the user requirements.

• Interacted with the BI Team getting a clarifications for developing the reports and solving the issues

• Involved in Installation and configuration of Cognos 8.2 and Configured Web server and Cognos configuration

• Involved in Installation of SQL Server and Configured of SQL Server and Cognos Content store

• Created Framework Manager Models using normal joins, Applied filters, calculations and created a packages and published using Framework Manager.

• Created Parameter Maps for resolve a complex logics using Framework Manager

• Involved in Migrating of the content store from Cognos 8.2 to Cognos 8.4 Version.

• Created different list Reports and cross tab reports using Report studio as per the requirement.

• Created different prompts and filters at summary level and detail level in report studio.

• Created Drill through and Master Detail reports in report studio

• Created reports using manual SQL for improving performance.

• Created a JavaScript’s resolving the complexity in prompt page

• Created chart reports using deferent chart in report studio

• Working with Cognos connection to run and schedule the reports as per the requirements.

• Creation of jobs in Cognos connection to run multiple reports at a time or in sequence as per the requirement.

• Modified Report MDX and XML based on requirement.

• Created deployment achieves ( Export files) for the reports to move to server environments

• Deployment of reports to the servers using content administration.

• Performed unit testing, integration testing, system testing and UAT of reports on different server environments.

• Enhanced Reports in Cognos 8.4 as per the changes from Client.

Environment: Cognos 8.2 and 8.4 (Cognos Report Studio, Query Studio, Analysis Studio, Cognos Connections, Event Studio, Framework Manager), SQL Server, Oracle 9i, Java scripts, Cognos SDK Windows, UNIX - AIX Servers

PFS- Princeton, NJ Oct’08 to May’09

Cognos Lead (PAM Reportal)

PAM is a key source of information in our client’s reporting process. The PAM Reporting Portal will provide a series of reports organized in five distinct sections. They are Holdings, Transactions, Performance, Accounting and Cash using Cognos 8.2 and 8.4. This specification will lay out the cash view available to the user though the portal.

Responsibilities

• Designed and developed reports using Cognos 8.2 Report Studio.

• Installed Cognos 8.2 and managed the deployment of IBM Cognos 8 Business Intelligence, including Content store, Content Store Manager, Configuration, maintenance, content management, security and system optimization.

• Designed and Developed the Framework Manager models using Stored Procedures, Relational tables and Published into server.

• Designed and developed multiple reports using various templates like list reports, cross-tab reports and chart reports.

• Migrated reports from Business Object 6.5 to Cognos 8.2, using Framework Manager and Report Studio.

• Involved in migration of the Cognos content store from Cognos 8.2 to Cognos 8.4 version.

• Designed complex reports using the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down ,Drill Up)

• Worked on SDK and VB Scripts to automate the process of generating the reports and storing them on the network drive.

• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.

• Connecting, controlling access, and performing basic tasks using DB2 UDB Express GUI tools

• Used DB2 Command Center to write a SQL Statement to retrieve the data for testing with report data using DB2 database

• Created sub query to retrieve the data from one table that also exist for a given project in a second table using DB2 Command Center.

• Managed scheduling of reports (Cognos scheduler and Event Studio), maintenance of public and individual folders, distribution lists, user groups and roles using Cognos connection.

• Conducted end user training and support of the reports and that were created.

• Interacted with the End users on a regular basis for resolving issues pertaining to the reports

• Performance tuning by analyzing and comparing the turn around times between Crystal and Cognos reports.

• Facilitated client workshops and training, typically small to medium group of clients.

• Coordinated with Development Team tasks& Deliverables and working on high priority issues

Environment: Cognos 8.2 and 8.4 (Cognos Report Studio, Query Studio, Analysis Studio, Cognos Connections,) Framework Manager, BO 6.5.1 - Universe Designer, Desktop Intelligence SQL Server,DB2, Oracle 9i, Java scripts, Cognos SDK Windows, HP-UNIX & AIX Servers

CIMB-GK Securities, New York, NY Feb’07 to Sep’08

Sr. Cognos Consultant (CIMB Reporting)

CIMB was established to serve as the Group's equity sales arm in the United States. The firm will focus on Southeast Asian equity sales complementing CIMB Group's already strong investment banking, stock broking and institutional sales franchise in Kuala Lumpur, Singapore, Jakarta, Bangkok and Hong Kong.

Responsibilities

• Created projects, prepared models, created and published packages in Cognos 8.2 Framework Manager

• Extensively used cascading prompts, drill-through, sub-reports, conditional formats, grouping, master-detail reports and association features of Cognos 8.2 to generate efficient and user-friendly complex reports

• Managed scheduling of reports (Cognos scheduler Event Studio), maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in ReportNet.

• Worked closely with the users to fine tune report queries, at times worked with them on creating new queries according to the business requirements. Streamlined many processes across the agency to run smoother and faster by Automating Processes, Scheduling Jobs and Emailing Reports Automatically to users

• Customized and integrated the Cognos 8.2 reports on the Company’s Intranet Portal using Cognos Portlets.

• Handled Deployment of Cognos reports from one environment to the other using the Deployment feature of Cognos. Worked on Performance Tuning of Cognos to make sure that the Reporting System was performing at its optimum level of Performance.

Environment: Cognos 8.2, Cognos Report Net 1.1 (Report Studio & Query Studio), SQL Server,, Oracle 9i, Java scripts, Cognos SDK Windows, UNIX - AIX Servers

Daimler Chrysler, Auburn Hills, MI Nov’06 to Feb’07

Cognos Developer (DCX SDW)

Supplier Data warehouse project developed to keep track of Supplier Performance. The supplier performance is evaluated based on parameters like delivery schedules, timeliness, critical shortages etc over a period

Responsibilities

• Data moved between sources to ODS and ODS to DDW.

• Developed complex Informatica Mappings and monitored those mappings.

• Developed various ETL transformations and PL/SQL program units.

• Developed incremental and updateable loading through mappings.

• Designed reusable transformations and shortcuts to share different mappings.

• Created and edited multiple sessions and added them into batch component.

• Implemented Restart Recover Logic to capture the data at certain point of failure from load.

• Worked with type1, type2, and type3 dimension changes in data model process work.

• Debugged, and resolved the loading failures by verifying the log files and validate the data in data marts after loading process balancing with source data and resolve the performance issues by using different methods and techniques.

• Connecting, controlling access, and performing basic tasks using DB2 UDB Express GUI tools

• Used DB2 Command Center to write a SQL Statement to retrieve the data for testing with report data using DB2 database

• Created sub query to retrieve the data from one table that also exist for a given project in a second table using DB2 Command Center.

Impromptu Reports:

• Queried data from different database tables as per the requirement.

• Joined the different table as per the requirements in catalog.

• Customized data by adding calculations, summaries and functions.

• Created List Reports, Cross Tab Reports and Drill through reports using Cognos Impromptu tools querying database.

• Created summary & detailed Filters, Conditions and Prompts in Catalog.

• Developed Impromptu Web Reports (IWR) and published them into Upfront.

• Presented complex data summary report and Exception highlighting.

• Created Impromptu Reports and published them to the PPES server.

Power Play Reports:

• Created PowerPlay cubes using Transformer (PowerPlay).

• Reported Operations such as Sum and Average, Intersection, Exception Highlighting, Sorting, Ranking

• Created UNIX shell scripts for atomization of the Cubes Refresh using the Crontab on the Cognos AIX Server

• Changed filters, layers and measures.

• Created Multi-Dimensional reports using PowerPlay.

• Applied Cube Security using user classes Apex and suppress

• Designed and developed multi dimensional cubes, Visualizations.

• Created Visualizer objects for better presentation of data.

Environment: Cognos Impromptu 7.1, PowerPlay 7.1, PowerPlay Transformer 7.1, Upfront, Informatica PowerMart/PowerCenter 6.2, SQL Server,DB2, Oracle 9i, Windows NT and UNIX Server

Syntel Ltd Mar’06 to Nov’06

Sr. Analyst Programmer DCFS (BI/DW)

DCFS BI/DW Maintenance Support & Enhancements services needed to perform maintenance support & enhancements activities and furthermore optimize the services rendered. The key goals of the ‘BI/DW Maintenance Support & Enhancements’ are:

Provide seamless, cost-effective, pro-active services and creating Multidimensional database and cubes using Cognos and Essbase for Gives a better performance to client business.

Responsibilities

• Data has been extracted and loaded into Warehouse using Informatica Integration platform.

• Installed the Cognos EP Series7.0 Software and performed Creation of Catalog using Cognos Impromptu Administration

• Created the Type-In Prompts in Prompt Manager, Conditional formats and Styles as per the requirement.

• Customized the List Reports by adding Filters, calculations, conditions and functions.

• Created the Sub-Reports and inserted them In-Group and List Footers.

• Created various types of Chart Frames like Bar and Pie Graphs.

• Developed Impromptu Web Reports (IWR) and published them to Upfront and administer the web-publishing activities for Upfront.

• Customized the UTML files and created the themes as per the requirement.

• Created the users and user classes and provided the security through Access Manager.

• Installed the Cognos PowerPlay Enterprise server.

• Created Cubes for multi dimensional analysis using PowerPlay Transformer and with External Rollups.

• Created Multi-Dimensional reports using PowerPlay and converted them to Excel spreadsheets.

• Designed and developed web based transaction reports in Cognos ReportNet.

Environment: Cognos Impromptu 7.1, PowerPromts, Impromptu Web reports (IWR), PowerPlay 7.1, PowerPlay Transformer 7.1, Upfront, Cognos Reportnet Frame Work manager, Cognos Report Net (Report Studio & Query Studio),Informatica 7.1 , Excel, SQL, Oracle 9i Enterprise Edition, Toad, Windows 2000/IBM-AIX

Maven Soft Systems May’04 to Mar’06

Analyst Programmer (CAR, KIA Motors)

Sales Agents, customer and transactions will organize the data according to the requirements of the organization. The main process that is performed is Extraction, Transformation and Loading. This system is used to perform claim processing. The functionality implemented included the development of KM Warranty Data Mart, which maintains historical warranty claims information such as vehicle .The console application, which is part of this system.

Responsibilities

Impromptu Reports:

• Created Catalog and assigned joins as per the requirements.

• Generated the reports using Cognos Impromptu by querying the data from different database tables as per the requirement.

• Customized the reports by adding calculations, conditions and functions.

• Created List Reports, Cross Tab Reports and Drill through reports.

• Created Filters, Conditions and Prompts in Catalog.

• Created various types of Chart Frames like Bar and Pie Graphs.

• Developed Impromptu Web Reports (IWR) and published them into Upfront.

• Created summary and detailed filters and different types of prompts.

• Created the users/user classes and provided the security through Access Manager

PowerPlay Reports:

• Created Cubes for multi dimensional analysis using PowerPlay Transformer.

• Done Data retrieval, Multidimensional analysis, PowerPlay structure, Exception Highlighting, Sorting, and Ranking.

• Changed filters, layers and measures.

• Created Multi-Dimensional reports using PowerPlay.

• Created Top ten Reports & Sort Data on Percentage Growth.

• Generated Trend over Time, Variance Reports.

• Converted PowerPlay Reports to Excel spreadsheets.

• Designed and developed multi dimensional cubes, Visualizations.

Environment: Cognos Impromptu 7.0, Impromptu Web reports (IWR), PowerPlay 7.0, PowerPlay Transformer 7.0, Cognos Query, Upfront, Excel, and PowerPlay for Excel, SQL, Oracle 8.1.7, SQL Navigator, and Windows NT/Solaris UNIX.

Reference:

• References available upon request

Contact this candidate