Manager Sql Server
Resume:
Swetha
******.***@*****.***
SUMMARY
. Around 7+ years of information technology experience in the Design,
Modeling, Development and Testing of database/Data warehouse
applications.
. Sound knowledge on different phases of software development life cycle
(analysis, design, develop, test) for Business Intelligence solutions.
. Experience in understanding the business requirements and designing
Cognos applications.
. Expert in designing Business Models to meet the complex reporting
requirements using, Cognos 8.x (Query Studio, Report Studio, Analysis
Studio, Cognos Connection).
. Worked on Cognos 8.x Framework Manager for creating Models for reporting.
. Extensively worked around 3 years with ReportNet 1.1. (Report Studio,
Query Studio, Framework Manager, and Cognos Connection).
. Modeling experience in Framework Manager, creating and maintaining
packages, design Relational and Dimensionally Modeled Relational (DMR)
Metadata and maintenance of the metadata-model, developing reports, and
training business users to develop reports.
. Over 5+ years of experience in Data warehouse reporting with Cognos
Impromptu 7.3, Power Play Transformer 7.3, and Cognos Power Play
Enterprise Server 7.3.
. Experience in Oracle 10g/9i/8i, SQL, PL/SQL.
. Expert in Publishing the Reports on Web and using Windows environment.
. Experience in working with databases like Oracle and MS-SQL Server
7.0/2000.
. Highly involved in the writing of Test Scripts for the testing of Cognos
Reports.
. Business goals oriented with strong commitment to deliver high quality
solutions on time.
. Excellent written and communication skills, able to communicate
effectively with all stake holders, including customers, senior
management, business people, and technical staff.
Technical Skills
Reporting Tools: Cognos 8.x (Report Studio, Query Studio,
Analysis Studio, Event Studio, Framework Manager,
Cognos Connection), Cognos ReportNet 1.x (Report
Studio, Query Studio, Framework Manager, Cognos
Connection), Cognos EP BI Series 7.4/7.3-Cognos
Impromptu, PowerPlay Transformer, Cognos Data
Manager.
Database Technologies: Oracle 7.x/8.x/9i,SQL Server 7.0, 2000, DB2
8.1, Teradata, MS-Access.
Operating Systems: UNIX, Windows 2000/NT/XP/2003.
Data Modeling: Erwin, MS Visio
Languages: C, C++, SQL, PL/SQL, Shell
scripting, HTML, XML, Java Scripting, PHP.
Other: Microsoft Office 2000 (Word,
Excel, PowerPoint, Access), Toad 4.0
Work Experience
Client : Ambac Financial Group Inc (New York, NY)
Jan 2010- July 2010
Role : Cognos Developer
Description:
Ambac Financial Group, Inc. is a holding company whose
affiliates provide financial guarantees and financial services to clients
in both the public and private sectors around the world. As
a Cognos Developer, I was involved in building models in Frame Work
manager, creating packages and publish it and develop user specific
reports.
Responsibilities:
. Expert in developing reports of varying complexity, including master-
detail and drill-down/drill-through reports, multi-level aggregate
views/reports.
. Experienced in implementing various prompts such as cascading,
conditional, date, value based on the user's needs.
. Created reports with dynamically varying groups and subtotals based on
the user selections.
. Presented report designs to users, and discussed user requirements
and Cognos limitations with users.
. DMR Modeling, and in Framework Manager using proven best practices
. Coordinating with testers to get the information to resolve the issues
raised by them.
. Scheduling and maintenance of the reports on the timely basis.
. Expert in setting up project/folders across multiple environments
(development, test, production).
. Developed data models using Cognos Framework Manager and deployed
packages on Cognos Connection.
. Create Master-Detail Relationships for reporting from multiple data
sources
. Developed procedures & functions using PL/SQL.
. Imported data into Framework Manager from Oracle 9i.
. Expert in creating Detailed Design Documents for Cognos reports.
. Created various dashboards to indicate KPI of business.
. Created Calculations, Filters in Framework Manager
. Apply OLAP functionalities such as drill-down/drill-up in Analysis
Studio and Report Studio.
. Develop reports based on user requirements from Business Support users -
both for standard reporting and ad hoc requests using Cognos PowerPlay.
. Deployed the reports to test and production environments.
Environment: IBM Cognos 8.4.1 - Query Studio, Report Studio, Analysis
Studio, Framework Manager, Access, Dashboard, Cognos PowerPlay, PL/SQL,
XML, ERWin 4.0, Windows XP, DB2.
Client : Merck Pharmaceuticals, NJ
April 2007- Dec 2009
Role : Cognos Developer
Description:
Merck Inc. is a global research-driven pharmaceutical company. Merck
discovers, develops, manufactures and markets vaccines and medicines to
address unmet medical needs.
The aim of this project is to provide numerous computer-generated reports
and custom analysis to Merck with actionable conclusions, including
demographic breakdowns such as size of vendor and number of contracts
negotiated with Merck per year and also created report on stock
information, Annual reports, proxy statements, Stock holder services.
Responsibilities:
. Involved in understanding existing Business Model and Customer
requirements by participating in the Design Phase and user requirement
gathering.
. Extensive experience in migration of reports from Impromptu using
Migration Utilities and mapping to corresponding metadata of Cognos 8
and Resolved complex problems like calculations, filters, prompts,
conditional styles in migrated reports.
. Upgraded Cognos 8.2 content store and frame work manager models to
Cognos 8.3 using content administration.
. Published the multidimensional cubes to framework manager and
scheduled power cubes monthly basis in Windows.
. Involved in modeling (star schema / snowflake schema) as for the user
requirement using Framework Manager also created models using
different hierarchies.
. Enabled the multilingual feature to generate reports in user specific
language.
. Implemented Security through Framework Manager and assigned users to
the groups through Cognos connection
. Involved in creating Metadata models using Framework Manager and
publishing the packages to Cognos Connection.
. Created Catalogs and Data Marts in Data Manager. Also created
DataStream Derivations, Transformation Model derivations and Mapped
the DataStream to the Transformation Model.
. Developed complex reports like Drill Down, Drill Through & Dashboards
in report studio
. Developed different kinds of reports using calculations, conditional
formatting, conditional layouts and dynamic actions on the reports in
different formats (PDF, HTML, XML, and Excel).
. Set up Security by creating Namespaces and User Classes in Access
Manager and LDAP.
. Designed reports by using HTML, XML and also used JAVASCRIPT for
prompt validations
. Created reports having Filters, multiple Prompts (Select & Search
prompt, value prompt, tree prompt) and provided option of bursting of
reports.
. Designed model for Ad-Hoc report and implemented security on the
model.
. Involved with Scheduling and Distributing Reports through Schedule
Management in Cognos Connection and Bursting reports to different user
groups.
. Involved in creation of mappings to the reports depending on users,
groups and roles.
Environment: Cognos 8.2 & 8.3(Framework Manager, Cognos connection, Report
Studio, Query Studio, Analysis Studio, Metric Studio, Access Manager),LDAP,
Informatica, Power play Transformer 7.4,EP 7 series version 3,SQL
Server2005,Oracle 9i, TOAD, Data Manager,ASP.NET, SQL, HTML, JavaScript.
Client : Mellon Financial Corporation, NY
Mar 2006- Apr 2007
Role : Cognos Developer
Description:
Mellon Financial Corporation was one of the world's largest money
management firms. It was in the business of institutional and high-net-
worth-individual asset management, including the Dreyfus family of mutual
funds.
Responsibilities:
. Worked closely with business users to define reporting requirements
and documenting the requirements in order to design, develop and
maintain Cognos reports.
. Worked with Decision Stream and extracted data from different database
and created own database and used that data base in frame work manager
as a data source.
. Worked on Framework Manager to import data from heterogeneous data
sources and created models & packages.
. Building nested child tabular, tabular set, tabular SQL and tabular
model Reports.
. Designed Functional Requirement Specifications for report development,
modified relationships between different database tables and building
models using Framework Manager.
. Created dimension maps and multidimensional cubes using impromptu's
Query Definition in Powerplay Transformer and Analyzed cubes using
Analysis Studio.
. Migrated power cubes from Cognos 7.3 to Cognos 8 and updated them on a
daily and weekly basis.
. Used JavaScript for customizing the search options and Prompt
controls.
. Enhanced existing reports and created interactive reports using
prompts.
. Created Master-Detail reports which had parameterized detail query or
filtered detail query based on the requirements in report studio.
. Facilitated the end users in building the reports.
. Generated payrolls of every month according to accounts section.
. Tested all the reports with Generated SQL and Manual SQL data.
. Created My Folders Options for users using external application and
displayed report output data in external applications using SDK
. Provided user authentication in Cognos connection using SDK.
. Provided different level of authentication and privileges to various
user classes and users using Access Manager.
. Involved in monitoring Audit reporting based on users, reports and
packages.
Environment: Cognos 8(Framework Manager, Cognos Connection, Report Studio,
Query Studio, Analysis Studio, Powerplay Transformer, Access Manager),
Decision Stream, EP7 series version 3,HTML,JavaScript, SQL Server
2005,Oracle 9i,SQL,.NET, PL/SQL, Apache, Windows.
Client : United Insurance Company, MA May
2005-March 2006
Role : Cognos Developer
Responsibilities:
. Met with end users and documented their query, business analysis and
reporting needs. Understood data and business logic underlying the
requirements
. Revise the Requirement Specifications with the users for better
customer service and feasibility in Report Studio
. Developed and Published Packages in Framework Manager - Connecting and
testing the data source, created database view and presentation view,
defining appropriate relationship between query subjects
. Installation of Cognos 8 Business Intelligence 8.1.2 MR2, ReportNet
1.1 MR3 and Framework Manager 1.1 MR3 and setting Cognos
configuration.
. Designed and developed a Document for the Migration process.
. Built Framework Manager Model, and established the cardinalities to
suit the business needs.
. Developed Assessment reports from scratch in Cognos 8 Business
Intelligence 8.1.2 MR2
. Migrated Report net reports to Report Studio reports and deployed them
into C8.
. Creation of Calculations, Prompts and Filters for usage in various
Reports.
. Developed data models using Cognos Framework Manager and deployed
packages on Cognos Connection.
. Imported data into Framework Manager from Oracle 9i.
. Develop reports based on user requirements from Business Support users
- both for standard reporting and ad hoc requests using Cognos
PowerPlay.
. Schedule, Monitor and Control access by creating groups, roles etc.
using Cognos Connection.
Environment: Cognos 8( Report Studio, Cognos Connection, Framework Manager,
Query Studio),Cognos 8 Business Intelligence 8.1.2 MR2,8.1.1 MR1,Cognos
Report Net 1.1 MR3, Cognos Transformer 7.0, Oracle 9i, Windows NT/2000.
Client : SallieMae-
VA
Nov 2004 -May 2005
Role : Cognos Developer
Responsibilities:
. Installation of ReportNet 1.1 MR3 and Framework Manager 1.1 MR3 and
setting Cognos configuration.
. Designed, Developed and Implemented an Enterprise Wide Reporting
system using Cognos ReportNet.
. Installed and configured various components, such as the Framework
Manager and Content Manager.
. Imported metadata from various sources such as Relational Databases,
ReportNet models into the Framework Manager.
. Developed Landing pages for each business by using Cognos ReportNet.
. Used Framework Manager to build models, packages and publish packages
to the ReportNet Server
. Built models containing query subjects, query items, and namespaces
from scratch as well as from imported metadata.
. Creation of Complex Multi-Object Report Studio Reports using Lists,
Crosstabs, charts, Images and HTML applications using Report Studio
and ad-hoc reports using Query Studio.
. Planned and Created professional reports in Report Studio. Complex
Reporting Requirements - Complex Drill-Through, Cross-Tabs and Summary
Reports.
. Scheduled Reports and Jobs to run periodically.
. Deployed packages, folders and content store from a development
environment to test and then to production environments.
Environment: Cognos ReportNet 1.1 MR3 (Framework Manager, Report Studio,
Query Studio), Oracle 9i,SQL Server 2000,SQL, PL/SQL,EP7 series version
3,Windows XP/NT.
Client : State bank of India, India
Mar 2003 -Sep 2004
Role : Cognos Developer
Responsibilities:
. Work with Business Units to define Business strategy and create a
centralized reporting capability for users to perform analytical, and
ad-hoc reporting for business applications and provide accurate
information available to Decision Makers.
. Installed & configured Cognos component such as the ReportNet.
. Used Cognos Connection for organizing, security, scheduling and
distributing reports.
. Migrated and deployed catalogs and impromptu reports to Cognos
ReportNet.
. Building models and publishing packages in Framework Manager to the
ReportNet server.
. Development of filters, calculations, prompts, conditions, and
created various reports, using Cognos Report Studio.
. Responsible for the delivery of solution-oriented complex reports
using Cognos Report Studio and Development of ad-hoc reporting
interfaces using Cognos Query Studio.
. Used Tabular SQL for some of the Complex Reports In Report Studio.
. Created various IQD packages in Framework Manager and from this IQD
integrated to power play transformer to create various models and
cubes.
. Involved in Migrating catalogs, reports into report net using
migration utility tool.
. Integrated the existing security with Report net Security.
. Business Data Analysis, Design, Development of Multidimensional OLAP
Cubes, deployment and provided drill-through targets to another Cube,
Power Play Portable Reports, Impromptu reports and ReportNet reports.
. Used Transformer with a variety of sources and combined them into
Multi-Dimensional Cube.
. Configured access manager namespace in Cognos connection and created
new users and user groups in access manager
. Provided technical assistance, training and mentoring to Users and
Business Partners
Environment: Cognos ReportNet 1.1 MR3 (Framework Manager, Report Studio,
Query Studio), Oracle 9i, SQL Server 2000, SQL, PL/SQL,EP7 series version
3,Windows XP/NT
Education
Bachelor of Technology in Computer Science
PERSONAL TRAITS
. Methodical approach.
. Excellent ability to gather and understand business requirements and
translate into IT solutions with the use of Cognos.
. Excellent communication and writing skills
. Dedication and commitment towards the attainment of the goal.
. Ability to work in a team and also lead from the front to attain the
organization goals.
Contact this candidate