Manager Sql Server
Resume:
RANI SAMYUKTHA
***@*****-******.***
Sr. Cognos Consultant
PROFESSIONAL SUMMARY
. Over 8 years of total IT industry experience analysis, design,
testing, development and implementation of Business Intelligence &
data warehousing environments.
. Experience in Financial Services, Healthcare, Insurance,
Pharmaceutical and IT sector.
. Expertise in Cognos 8 BI including Framework Manager, Administration
Tasks, Report Studio, Query Studio, HTML, Java Scripts, Dashboards.
. 8+ years of experience with Cognos Tools such as Cognos 8 BI Suite
(Framework Manager, Cognos connection, Report Studio, analysis Studio,
Query Studio, Metric Studio, Event Studio) Cognos Report net 1.1.MR3,
Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Analysis Tools such as
Cognos Transformer & Power Play 7.x/6.x.
. Experience in developing multi-dimensional model design and Power play
cube building, security using power play Transformer.
. Created complex statistical and financial reports, trend over time
reports, ranking, and forecast reports, Executive Dashboards using
Report Studio.
. Installed and Configured Cognos 8.3 in single server Environment.
. 3 years of experience in working with Cognos Report Net utilizing
Framework Manager, Cognos Connection, Report Studio and Query Studio.
. Sound Skills in Developing Standard and Complex Dashboard Reports
using Report Studio.
. Strong Experience in developing Custom Portal Tabs and complex
Dashboards.
. Sound Skills in developing custom prompt pages using HTML and
JavaScript.
. Proficient in Creating Variables for Complex Formatting Reports.
. Highly experienced in IWR (Impromptu Web Reports), Publishing using
Upfront, maintaining Users, User classes, Deployment, Scheduling the
Reports and sending Updated Reports to Recipients through E-Mail by
using Notice Cast.
. Experience in writing SQL, T-SQL, PL/SQL Packages, Stored procedures,
Functions, Triggers, Cursors as per the business needs.
. Experience in databases like Oracle 10g/9i/8i, MS SQL Server 2005/2000
and DB2.
. Strong knowledge in data warehousing concepts (Star schema, Snow Flake
Schema, Fact Analysis).
. Excellent written and verbal communication skills and expertise in
working with clients and functional teams.
. The ability to work independently as well as collaborate as needed to
meet project requirements and deadlines.
TECHNICAL SKILLS
Business Intelligence Tools Cognos 8.4.1/8.4/8.x Suite: FrameWork Manager,
Report Studio, Analysis Studio, Query Studio, Event
Studio, Metric Studio, Cognos Transformer 8.4/8.3
(Multi-Dimensional OLAP), ReportNet 1.1/1.0x, Cognos
EP Series 7 (Impromptu, IWR, Power Play Transformer
and Power Play Windows/Web), Cognos Administration,
Access Manager, Cognos Connection, PowerPlay Studio,
PowerPlay Client, Cognos PowerPlay Enterprise Server
(PPES), Cognos Visualizer.
ETL Tools Microsoft Integration Services (SSIS), Informatica
Power Mart 4.6/5.1
Scripting Languages ASP, PHP, JavaScript, Perl, VBScript
Databases Oracle 9.x/10g/11g, SQL Server 2000/ 2005 /2008, DB2, MS
Access
Querying/Reporting T-SQL, PL/SQL, SQL * Plus, SQL*Loader,
TOAD, ORACLE
Web Portal Technologies HTML, Photoshop, Visual Studio,
PHP
Programming Languages PL/SQL, TSQL, XML, C, C++, UNIX Shell Scripting,
Java, .net
Data Modeling Tool Erwin, SQL Server Analysis Server
2005/2008(SSAS)
Web Servers IIS, Apache
Documentation Tools Latex, MS Office (Including MS
Project, VISIO)
Operating Systems Windows NT/2000/XP/2003/2000/98/95, Windows Server
2000/2003, Linux Distributions-Red hat,
SUSE, Ubuntu
Database Connections ODBC, JDBC
PROFESSIONAL SKILLS
Client: Citi Group, Dallas, TX
Duration: Nov 2008 - Present Position: Sr. Cognos Developer
Domain: Banking
Citi is a major American financial services company based in New York, NY.
Citi has the world's largest financial services network, spanning 140
countries with approximately 16,000 offices worldwide. The company employs
approximately 260,000 staff around the world and holds over 200 million
customer accounts in more than 140 countries.
Responsibilities:
. Gathered & analyzed the end-user business requirements.
. Created projects, designed models for reporting and created & published
packages in Framework Manager from various data sources.
. Used Dimensional modeling (DMR) and Snow flake Schema modeling technique
to develop models
. Implemented Third Party Security with LDAP and use those in creating Data
Level, Object Securities in Framework Manager Models.
. Designed Reports using most of the Report studio features (Conditional
Formatting, Conditional Page layout, Sections, page Breaks, Master-
detail, Drill Through, Drill Down, Drill Up).
. Developed dynamic drill down, expand collapse, on-click sort using Java
Scripts.
. Implemented dynamic measures, dynamic column selection in Report Studio.
. Used Cognos Transformer to build multidimensional cubes and used it in
Dashboards.
. Developing Analysis Studio views of analysis from dimensional modeled
packages.
. Create the scorecard reports using the Metric Studio.
. Analyzing all reports and Standardize these reports using Power Prompts
and Charts
. Used Cognos Connection for scheduling and bursting reports across the
Business segments and providing additional security to published cubes as
well as reports
. Design and creation of Multi Dimensional Cubes using Transformer, so that
all key performance indicators can be analyzed.
. Developed the mapping specifications from the business requirements and
the data model. Involved in data modeling and design of the data
warehouse.
. Extensively used Informatica Web Services Wizard to extract data from XMI
files stored in web server.
. Deployed the objects from Development to Test and from Test to
Production post UAT validation, creating Connect Strings and
synchronizing the Connect Strings and Connection Objects in Dev, Test
and Prod environments.
Environment: Cognos 8.3/8.4 (Framework Manager, Query Studio, Report
Studio, Analysis Studio, Metric Studio and Event Studio), Cognos
Transformer 8.1/8.4, Oracle10g (SQL, PL/SQL) and Windows 2003 server.
Client: Daiichi Pharmaceuticals, Montvale, New Jersey
Duration: Jun 2007 - Oct 2008
Position: Sr. Cognos
Developer/Administrator
Domain: Pharmaceuticals
Daiichi is a wholly owned subsidiary of Daiichi Pharmaceutical Co. Ltd in
Tokyo. Daiichi focuses in specific and specialized therapeutic areas
through the development of innovative products that improve patient's
lives. The objective of this project was to support Business Executives to
take quick decisions. Generated and analyzed reports based on buyers,
representatives and marketing specialist that focus on market performance
in different locations.
Responsibilities:
. Installed and Configured Cognos 8 BI Version 8.2 Suite in multi server
environment on Windows
. Involved in Planning and implementation of Cognos 8 BI Suite.
. Worked jointly with the data management team members to understand
data domains, values, cardinalities and other dimensions of data
needed to support BI solutions.
. Created Framework Manager Models to the reports and created IQD's for
Transformer.
. Created and published packages from Cognos 8 BI Modeling.
. Build POC for Dashboard and Designed the Dashboard Navigation.
. Created Complex Reports in Cognos 8 BI Report Studio.
. Created Power Play Reports by using Analysis Studio.
. Developed multiple page reports with page-breaks based on the first
page of the report using Master-detail relationship.
. Developed List, cross tab, drill through and complex reports which
involved multi-queries.
. Extensively used Power play Transformer to move relative data mart
data into Power Cubes.
. Scheduled the reports and bursted reports according to user
requirements in Cognos.
. Implemented Cognos SDK application to save the reports to windows file
system.
. Upgraded Reportnet Reports, Packages and Data Source Connections into
Cognos 8 BI.
. Upgraded the Cognos version 7.x to Cognos 8.2
. Deployed Packages and Reports from DEV Environment to UAT and PROD
Environments.
. Imported metadata from various sources such as Relational Databases
and Report Net models into the Framework Manager.
. Involved in Unit Testing for all reports and packages.
. Creating report views with saved prompts and schedule according to the
business requirement..
. Personalized Cognos Connection, Specified display options, regional
options and personal information.
Environment: Cognos 8.2 BI Suite, Framework Manager, Query Studio, Report
Studio, Analysis Studio, SDK, CognosTransformer7.4,Windows NT/2000, .Net
3.5 framework, Oracle 10g, JavaScript, SQL, PL/SQL, TOAD 9.6.
Client: American Express, Greensboro, NC
Duration: May 2006 -
May 2007 Position: Sr. Cognos Consultant
Domain: Finance
American express is a diversified global financial services company
headquartered in New York City. Founded in 1850, it is one of the 30
components of the Dow Jones Industrial Average. The company is best known
for its credit card, charge card and traveler's cheque businesses. Amex
cards account for approximately 24% of the total dollar volume of credit
card transactions in the US, the highest of any card issuer.
Responsibilities:
. Designed Functional Requirement Specifications for report development,
modified relationships between different database tables and building
models using Framework Manager.
. Upgraded Framework Manager Models, Transformer Cubes and reports from
Cognos Version 8.2 to 8.3.
. Migrated power play cubes and upgraded to Cognos 8.3.
. Used enhanced Cognos 8.3 functionality in creating cube reports.
. Customized Cognos Connection with appropriate reports and security
measures.
. Created, refreshed and supported Cognos Transformer OLAP models and Power
Play cubes.
. Designed & developed reports from the Data warehouse using Cognos 8.3
report studio, Analysis Studio.
. Design & development of multiple reports using various templates.
. Created several Formula Measures and scenarios for Financial Reporting.
. Developed Financial Reports such as Variable Annuity Accounts,
Traditional Annuity, Stable Return Annuity, Funds Retirements Class and
Retirement Plan reports using Report Studio.
. Developed Dash Board reports in Report Studio using MDX Functions.
. Trained power users to use Query Studio for Ad-Hoc reporting. Trained
professional authors to write complex reports using Report Studio.
. Interacting with the End users on a regular basis for resolving issues
pertaining to the reports.
. Developed Reports Using Crystal Reports 9.0 and SAP BW.
. Worked with Stored Procedure Query Subjects in FM and Reports.
. Performance tuning by analyzing and comparing the turnaround times
between SQL and Cognos.
. Administering the Servers - Installation, configuration, roles,
Privileges and Performance Tuning of the Servers.
. Design and Developed the Framework Manager models from different data
sources and Published into server.
. Involved in deployment of applications to production, Troubleshoot the
errors during the upgrade process.
. Interacting with the Cognos support team and creating & following-up the
cases in the Cognos support site.
Environment: Cognos 8 BI, Power Play Transformer 8.0, 7.0, Upfront 7.0,
Access Manager, Oracle 9i/10g (PL/SQL), Windows NT, UNIX.
Client: Department of Health & Human Resources, WV
Duration: Dec 2004 - Apr 2006
Position: Business Intelligence Consultant
Domain: Health care
Department of Health and Human Resources West Virginia FACTS Project is The
Family and Children Tracking System (FACTS) is a customized Statewide
Automated Child Welfare Information System established FACTS was designed
and developed based on the requirements established by the U.S. Department
of Health and Human Services, Administration for Children and Families, to
support the state's federal reporting for Adoption and Foster Care Analysis
and Reporting System and National Child Abuse and Neglect.
Responsibilities:
. Analyzed the existing Commitment source systems.
. Developed and tested the Commitments Catalog, Commitment Fulfillment
Analysis cube, Drill Thru report and Threshold Impromptu reports. Created
management decision support models and reports (SQL Queries) that derived
information from the system to help make funding decisions.
. Performed security control by creating and dropping user, to create role
and profile, to enable or disable the access rights to users.
. Involved in writing database scripts, PL/SQL, stored procedures,
packages, triggers and testing them.
. Created List Reports and Cross Tab Reports and Drill Through reports.
. Created Cognos Macros for Excel Formatting.
. Reported Operations such as Sum and Average, Intersection, etc.,
Exception Highlighting, Sorting, Ranking etc.
. Created news boxes on the Upfront server and published the cubes and
reports to upfront server.
. Created Power Cubes in Power Play transformer using multiple data
sources. (IQD & CSV).
. Created Dashboards and Scorecards using Report Studio and Metric Studio.
. Applied security to cubes by creating dimension views, user class views
and applying password.
. Assigned the user classes access to the upfront news boxes.
. Designed and Developed List and Cross Tab Reports, Trend Analysis Report,
Cycle Track Report and Selection Report.
. Created standard and Ad hoc reports using Cognos Impromptu tool.
Environment: Cognos7.1-Impromptu Administrator, Cognos Power play, OLAP
Transformer, DB2, DB2 Client Configuration Assistant, Cognos Script Editor,
Excel 2000, Cognos 8.1,Cognos Reportnet1.1, Cognos connection, Cognos
Configuration, Framework Manager, Report net.
Client: American Income Life Insurance CO, Lenexa, KS
Duration: Nov 2003 - Nov 2004
Position: Cognos Consultant
Domain: Insurance
Immediate requirements at AIL Insurance had revealed a need to develop ad-
hoc reporting solutions in order to respond to the critical data that might
not be available through existing reports. Reports were created daily,
weekly and monthly in aggregations.
Responsibilities:
. Involved in installation and configuration of Cognos Report Net 1.1 MR1.
. Created the Design Documents for the Development of Cognos Report Net
Reports.
. Translate Report use case documents into Cognos cross tab, data warehouse
reports.
. Involved in creating the Model and Package using Framework Manager.
. Supported the TEAM in Developing of Reports using Cognos Report Net.
. Migrated Cognos Series 7 reports to Cognos Report Net.
. Involved in the Design Phase of the Resource Bundle, which would be used
in Internationalization of the Reports.
. Understand the project design, detailed design for assigned work units.
. Modified Power Cubes by adding new Dimensions, Levels and Measures.
. Designed Cognos Transformer cube models using reports modeled according
to user needs.
. Developed List, cross tab, drill through, master-detail, chart and
complex reports which involved Multiple Prompts, Filters, multi-page,
multi-query reports against multiple databases.
. Designed models using Framework Manager and deployed packages to the
Report Net Servers.
. Developed numerous sophisticated drill-through Power Play and ReportNet
reports
. Created standard and Ad hoc reports using Cognos Query Studio.
. Developed Templates, standard Reports, Master Detail Reports, Bursting
Reports using Report Studio and Query studio.
. Managed issue log sheet in the development of reports.
Environment: Cognos Report Net 1.1 MR1 (Framework Manager, Report Studio,
Query Studio, Cognos Connection, Access Manager, Cognos 7.1) Pentium PC,
Windows NT/2000, SQL, Macro Scripting, Oracle 9i, Sql Server 2000, DB2
Client: 3C Computers, Hyderabad, India
Duration: Apr
2002 - Oct 2003 Position: Software Engineer
Domain: IT sector
3C Computers is a Cad /Cam based company. I worked for its client to
develop customized BI solutions. As a part of the BI team, I was
responsible for creation of Impromptu reports, which provided users the
ability to access, analyze, and share information in the company's
database.
Responsibilities:
. Gathered & analyzed the end-user business requirements.
. Developed Impromptu Catalogs, Joins, folders, Calculations and standard
reports.
. Developed Impromptu Query Definitions, Hot files and Thumbnails.
. Build Multi-dimensional models in transformer and build Cubes and
published into Web.
. Created Power Play cubes using Transformer (Power Play).
. Data retrieval, Multidimensional analysis, Power Play structure.
. Created Multi-Dimensional reports using Power Play.
. Designed and developed multi dimensional cubes, Visualizations.
. Created reports in HTML format for easy navigating of data from web
browser.
. Created List Reports, Cross Tab Reports and Drill Through reports.
. Developed Impromptu Web Reports (IWR) and published them into Upfront.
. Exception highlighting and Created Reports and prompts.
. Created Impromptu Reports and published them to the PPES server.
Environment: MS SQL Server, Windows 2000, Impromptu 6.0, Impromptu Web
Reports, Transformer 6.6, Informatica 6.0, Cognos Upfront Server, Power
play windows XMI and HTML.
Education
Bachelor of Technology at Nagarjuna University (B. Tech), INDIA
Contact this candidate