Manager Sql Server

Santhosh G

Sr. Cognos Administrator/Developer

Email: ***************@*****.***

Phone: 908-***-****

Professional Summary:

IT Professional with more than 8 years of experience in Software Design, Development and Analysis, Testing, Data Warehouse and Business Intelligence tools.

Hands on experience in Cognos 10,8 (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection, Business Insight, Business Insight Advanced) and Cognos Series 7.x (Cognos Report net 1.1, Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos Access Manager, Upfront).

Hands on experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.

Developed Active Reports to meet the user requirement of high interactivity at offline reporting.

Experience in Installation, Configuration, Monitoring and Management of Cognos.

Experience in Cognos Upgrade from version 8.4 to 10.2.

Developed tabbed reporting/automatic highlighting of chart contents using active reports.

Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.

Experience developing complex reports using Drill-through reports, Prompts, Dashboards, Master-detail, Burst-reports, Dynamic filtering in Cognos.

Expertise in creating Dashboard reports using Java Script in Report studio.

Experienced in building Scorecard reports and Dashboard reports using Metric Studio.

Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.

Trained users in using the Business Insight for dash boarding and the Business Insight Advanced for Ad-hoc reporting.

Good Experience with MDX Functions in Report Studio using Multi-Dimensional Sources.

Extensive experience with Cognos security (LDAP, Active Directory, Access manager, object level security, data security).

Experience with Cognos Software Development Kit (SDK) to customize reports using JAVA.

Sound Skills in developing SQL Navigator, SQL Scripts, PL/SQL Stored Procedures, Functions, Packages and Visual Source Safe.

Expertise in Oracle 9i, 10g, 11g and MS SQL Server 2000, 2005 & 2008.

Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

Extensive experience on production support and Troubleshoot/Test issues with existing reports and cubes.

Ability to translate Business requirements into technical specifications and interact with end users to gather requirements for reporting.

Good understanding of business process in Financial, HCM and Healthcare areas.

Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.

Education:

Bachelors in Electronics and Communication Engineering – JNTU, India.

Technical Skills:

Hardware

IBM PC Compatibles and NT servers

OS

Windows, UNIX, Linux

OLAP tools

Cognos 10, 8 (Report Studio, Frame work manger, Analysis Studio), Transformer 8.3, Impromptu Administrator, Powerplay Transformer, Powerplay, Report Net, Oracle

ETL Tools

Informatica 6.0, 7.1,8.1,8.6, Data stage 7.5

Databases

Oracle 7.x/8.x/9.x/10&11g, Sql Server 2003, Sql* loader, Teradata

RDBMS

Stored Procedures, Database Triggers, and Packages.

Languages

Multimedia

C, C++, Java, Cobol, VB. net, php, Assembly language

Adobe Photoshop, Flash, Dreamweaver.

Tools

Make, RCS, Autosys, Clear Case, Crontab, Toad, BTEQ

Miscellaneous

TCP/IP Sockets, Sun RPC, XML

Version Control

CVS

Professional Experience:

Universal Service Administrative Company (USAC), Washington D.C Jan 2017 - Present

Cognos/Pentaho Consultant

Responsibilities:

Interacted with Users to obtain initial information related to the business requirements and required documentation for clear understanding of requirements.

Responsible for the Cognos and Pentaho environment performance and tuning.

Involved in migration from Cognos to Pentaho.

Deployed content from Development to Production and administer users/groups/roles.

Installed and configured new Pentaho environment.

Responsible for securing the content and user authentication to various groups.

Creating the Schedules and Jobs.

Responsible for troubleshooting any/all issues in BI environments.

Created List, Cross tab, Chart, Drill through, Master-detail and complex reports with Multiple Pages/Prompts in Report Studio.

Created Database layer and Business layer, defining appropriate relationship between query subjects in Framework Manager.

Created and published metadata models using Framework Manager.

Created and published metadata models using PDI tools.

Trained the end users to use the reporting tool to build Ad-hoc reports.

Created User manual for Business Users to understand the reporting architecture.

Environment: Cognos 10.2, Report Studio, Query Studio, Sql Server, TOAD, Pentaho 6.1, Pentaho Metadata Editor, Pentaho Report Designer, Pentaho Schema Workbench, Pentaho Spoon.

Ultimate Software Group, Weston, FL Feb 2014 – Jan 2017

Cognos Consultant

Responsibilities:

Involved in upgrading the Cognos Reporting Environments from 8.4 to 10.2.1 and from 10.2.1 to 10.2.2. This upgrade includes 70+ separate Cognos environments that include 450+ servers.

Upgrading the Reports Servers, Web Servers, Gateways, Content Store, Reports and Cubes.

Deployed the Cognos content from one environment to other environments.

Troubleshoot any and all issues related to the Administration of the Cognos reporting environment.

Provided level 3 support (last line of support) for the Cognos environment.

Responsible for the Cognos environment performance and tuning on all servers.

Installed and configured new Cognos Environments.

Enable-Disable Cognos capabilities based on specific client needs.

Responsible for creating database connections for different data sources.

Responsible for creating and managing Jobs and Schedules.

Responsible for applying Security and User Authentication to the various User Groups.

Responsible for deploying the Packages (exporting and importing the packages) using the Deployment functionality under Cognos Connection Portal and Documenting the process.

Experience in creating models using Framework Manager & creating simple to complex reports in Report Studio.

Updating the Metadata Model when new metadata is imported.

Created agents using Event studio for business factors performance monitoring.

Used Analysis studio to create Ad-hoc reports using cubes.

Test all servers for 24-7 availability to both internal and external clients.

24-7 on call for any cognos Administration issues.

Integrated Cognos with INFOR Workbrain for Time and Attendance product.

Worked on Quarterly upgrade projects for the Company’s core product.

Environment: Cognos 10.2, Report Studio, Query Studio, Framework Manager, SQL Server, TOAD, PL/SQL, Informatica v9.0

Houston Independent School District, Houston, TX Aug 2013 - Jan 2014

Cognos Developer

Responsibilities:

Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.

Experience in building models using Framework Manager. Created Database Layer and Business Layer, defining appropriate relationship between query subjects in Framework Manager.

Created Dashboard reports using the Cognos Report Studio which includes iframes and Dynamic Sorting.

Developed ad-hoc reports using Query Studio.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts, multi-query, Cubes in Report Studio, Burst Reports against database.

Created custom prompted reports in Report Studio.

Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports.

Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.

Involved in creating the User Training manual to help the Business Users understand the reporting architecture.

Conducted training on Cognos technology to the Business users. Mentored the Project Team on latest trends in Reporting.

Environment: Cognos 10.2, Transformer, Report Studio, Query Studio, Oracle 11g, TOAD, SQL Navigator, Visual Source Code, PL/SQL, Informatica v9.0, IBM Netezza v5, Linux v5.4.3.

Citi Group, Warren, NJ Oct 2011 - Jul 2013

Sr Cognos Consultant

Citi has a business in retail/wholesale industries in a great extent. The Cards business is one of the major revenue generator and the customer serving business. It has a wing of insurance and investment products serving more than 15 million users all over. There are multiple IT projects in terms of Risk Analysis, Market analysis, Plan/Forecast of business and multiple business/program performance monitoring projects.

Responsibilities:

Interacted with End Users to obtain initial and/or follow-up information related to the report development and the preparation of preliminary narratives of serious adverse events, developing Cognos reports.

Involved in the installation and configuration of Cognos 8.4 BI

Developed new reports in Report Studio upon requests from business users.

Involved in Strategic Planning for Cognos Framework Model.

Secured Models are created using Framework Manager.

Updating the Framework Model when new metadata is imported.

Created and published Packages using Framework Manager.

Created Dashboards with the selection criteria defaults by user role to help pre-select a subset of data that is most critical and most relevant for the users.

Used Event studio to create agents and monitored Performance of key business factors.

Used Analysis studio to drill down on Cubes and perform business analysis.

Expert in Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio.

Expert in creating database connections for data sources.

Applying Security to various User Groups.

Deploying Sample, Testing the Server and Managing Cognos Connection Portal.

Creating the Schedules and Jobs.

Created Simple and Complex Reports using Report Studio with multiple Charts and Reports on one page.

Introduced Highlight exceptions and graphics, and drill-down reports to expedite analysis.

Used SDK to Manage Java programs.

Scheduled Management is used in Cognos Connection.

Deploying the Packages (exporting and importing the packages) using the Deployment functionality.

Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio, Metric Studio, Oracle 10g, Sybase ASE v12.0, Sybase IQ v12.5, TOAD, PL/SQL, SDK, UNIX.

Celgene Pharmaceuticals, Nutley, NJ Oct 2009 - Sep 2011

Senior Cognos Developer/Administrator

The objective of the project is to create the Existing Sales Data mart that holds the entire sales transactions of different drugs. The Data mart created will help the Business users in performing the analytics using the reporting platform implemented in Cognos

Responsibilities:

Gathered report requirements from Business Users and converted them in to technical documents.

Experience in building models using Framework Manager & creating simple to complex reports in Report Studio.

Created Database layer and Business layer, defining appropriate relationship between query subjects in Framework Manager.

Designed & Implemented List, Cross tab, Chart, Drill through, Master-detail and complex reports with Multiple Pages/Prompts in Report Studio.

Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio.

Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.

Developed Dash board reports to display all the information related to environment using Summary reports.

Created Master Detail reports, Drill through and Custom Prompting reports, and Scheduled reports for efficient resource utilization.

Implemented Cognos SDK code for extracting the report schedules defined by power users.

Trained the end users to effectively use the reporting tool to build their Ad-hoc reports.

Deploying models and reports from Development to Production and administering users/groups/roles.

Involved in creating the User Training manual to help the Business Users understand the reporting architecture.

Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.3 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Transformer v7.4, Cognos SDK, WAS, HTML, Java, Shell Script, Oracle 11g, HP-Unix

Prelude Systems, Chennai, India Jul 2008 - Sep 2009

Software Programmer

Responsibilities:

Involved in designing of Conceptual Logical Model and Physical Model.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.

Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.

Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2000/7.0, Oracle 8i, Windows NT, C++, HTML, T-SQL.

Contact this candidate