Manager Sql Server
Resume:
MOUNIKA REDDY
****************@*****.***
[pic]
Professional Summary:
V Over 8 years of IT experience in Enterprise Business Intelligence
lifecycle implementation projects and Cognos BI tools.
V Expertise in report designing, building, maintenance, requirements
gathering and training.
V Expertise in building Models and Packages in Framework Manager and
publishing those packages to the Cognos Connection.
V Extensively worked on Impromptu, ReportNet, Analysis Studio, Query
Studio, Report Studio and Metric Studio for Reports and Metrics Design in
Cognos Suite of products.
V Extensively worked on Design and Building Cubes in Powerplay Transformer.
V Experience in performing administrative roles in Cognos Suite of
products.
V Expertise in Migration of the applications from Cognos Series 7 and
ReportNet to Cognos 8BI.
V Expertise in Installation and Configuration of Cognos suite of products.
V Extensive knowledge in Cognos TM1 (TM1 Architect Server Explorer, TM1
Perspective Server Explorer, TM1 Turbo Integrator, TM1 Web).
V Expertise in Daily Maintenance of Cognos jobs to load the data into
tables.
V Expertise in creating and modifying tables in the Oracle database.
V Proficient in all phases of Data Warehousing Concepts; experienced in
dimensional and relational modeling in Star Schema and Snow-flake
Schemas.
V Expertise in DW/BI product architecture using Financial cubes and
reports, ETL and end-user data management.
V Expertise in multiple relational databases including Oracle (9i, 10g), MS
SQL Server, DB2 and Teradata.
V Proficient with accessing data in TOAD, SQL Plus, Teradata SQL Assistant
and implementing data solutions utilizing PL/SQL.
V Extensively worked on Oracle Warehouse Builder Design center, Control
center, Repository manager.
V Expertise in Data Warehousing Concepts using Informatica Power Center,
Power Mart, Repository Manager, Designer, Workflow Manager.
V Strong experience in SQL and Oracle PL/SQL in creating complex queries,
functions and stored procedures required for reports.
V Proficient with Rational Requisite Pro for Requirements Management and to
create Traceability Metrics among requirements.
V Proficient in developing and executing test plans based on system and
validation requirements.
V Self-motivated, works well independently and within a team environment.
Proficient and prompt in learning and adapting to new technologies.
V Strong interpersonal, analytical, and communication skills.
Certifications:
IBM Certified Cognos8 BI Reports
IBM Certified Cognos8 BI Metadata Models
Technical skills:
BI Tools : Cognos 8 BI (Framework Manager, Report Studio, Query
Studio, Analysis Studio, Event Studio, Metric Studio, Cognos
Connection, Powerplay Transformer) Cognos ReportNet 1.1/1.02,
Cognos Impromptu Administrator 6.x/7.x, Cognos PowerPlay
6.x/7.x, Transformer, Access Manager, Cognos TM1(Architect,
perspective, Turbo integrator, Web)
Data Modeling : ERWIN 4.x/3.x, Ralph-Kimball Methodology, Star Schema,
Snow Flake Schema, Physical and Logical Modeling, Dimension Data
Modeling, Fact Tables, Dimension Tables, Normalization,
Denormalization, Informatica, Oracle warehouse builder, Data
stage.
Operating Systems : Windows 98/NT/2000/XP, UNIX
Database : Oracle 8i/9i/10g, Microsoft SQL Server, MS-Access, DB2
Languages : C, C++, SQL, PL/SQL, HTML, XML, Java Script
Other Tools : SQL*Plus, Toad, SQL Navigator, Teradata SQL Assistant,
Putty, Ms-Office
Education:
. Masters in Computer Science, USA.
. Bachelors in Computer Science, Hyderabad, INDIA.
Experience:
Verizon Wireless, Warren, NJ
Nov 09-Present
Senior S/w Systems Engineer
Verizon Wireless is the nation's largest wireless network.
Responsibilities:
. Gathered, analyzed and documented user requirements for reporting.
. Daily monitoring of cognos jobs to load the data into tables. Created
scripts to load the data and scheduled the jobs.
. Created and modified database tables in Oracle database.
. Provided high level training for users who want to create survey reports
with different Calculations and Filters.
. Developed cubes in Powerplay transformer and scheduled the cube build
daily to update the cube.
. Developed Framework manager projects and published packages to cognos
connection.
. Created different filters and calculations in Framework Manager that can
be effectively used while reporting.
. Developed List Reports, Cross-tab Reports, Chart Reports, Repeaters, Dash
Board reports, Drill thru reports, Multiple prompt reports, Discontinuous
crosstab reports in Report Studio.
. Set up Cognos Audit database to assess server and report activity.
. Created User Groups and Roles in Cognos connection to assign security for
different users in Cognos projects.
. Installed and configured Cognos Framework manager.
. Using the Cognos Scheduler (Schedule Management tool), scheduled the long-
running reports to provide static views to the business owners.
. Prepared user documentation on how to run the reports in different
formats, how to schedule the reports etc.
. Prepared technical documentation with instructions on what to be done if
the cognos job fails to load data or if the cube fails to do incremental
updates.
Environment: Cognos series8 (version 8.4), Framework Manager, Powerplay
Transformer, Cognos Connection, SQL Loader, Toad, SQL Plus, Oracle 10g,
DB2, Teradata, Teradata SQL Assistant.
Clark County Social Services CIBER ACES, Las Vegas, NV Jul 08-
Oct 09
Data Architect/Analyst/Developer/Administrator
Clark County is one of the fastest-growing areas in the country. First, it
provides urban services and second, it provides regional services for more
than 2 million residents and almost 44 million tourists a year and third,
it provides town services for unincorporated townships. It includes
generating reports using Cognos Series8, Curam Framework and ETL as
standards for reporting.
Responsibilities:
. Gathered, analyzed and documented social services design and development
requirements for reporting using Curam Framework.
. Worked with Cactus Reports and analyzed how these reports can be built in
Cognos.
. Created various reporting requirements in Rational RequisitePro and
traced them to the associated BPREQ's.
. Identified the source data elements from different tables in Curam for
reporting purposes.
. Analyzed the Curam Data warehouse and worked backwards through the
Staging, CDW and Datamarts in Oracle Warehouse Builder Design Center and
identified the changes required to support the reports.
. Installed and Configured Cognos Framework manager.
. Imported Source tables from Curam according on the Reporting
requirements.
. Identified and created different Staging ETL tables from the Curam source
and created Mappings in the Mapping Editor to support the reporting
requirements.
. Created different packages and models in Framework manager based on the
requirements and published them to Cognos Connection.
. Implemented Packet level, object level and data level security in
Framework Manager.
. Created burst reports and made them available to appropriate users
resulting in saving lot of time and effort.
. Created complex Financial reports for Bank of America, Intake and
Management reports using Report Studio and Query Studio.
. Developed List Reports, Crosstab Reports, Charts, Repeaters, Dash Board
reports, Master detail Drill through reports, Drill thru reports,
multiple prompt reports in Report Studio.
. Developed Scorecards in Metric Studio.
. Effectively used Performance Tuning and Bursting reports.
. Strong experience in SQL and Oracle PL/SQL in creating complex queries,
functions and stored procedures required for reports.
. Created User Groups and Roles in Cognos connection to assign security for
different cognos projects.
. Scheduled and Distributed reports using Schedule Management in Cognos
Connection.
. Customized the Cognos connection portal using existing port lets and
customized tabs.
. Prepared user and technical documentation and provided end-user training.
Environment: Cognos series8 (version 8.3), Framework Manager, Cognos
Connection, Oracle warehouse builder 10g, Curam 5.2 Doc Center, SQL Plus,
Oracle 10g, SQL Server, Rational RequisitePro, Rational Clearquest.
UW Physicians Neighborhood Clinics, Seattle, WA Apr
08-Jun 08
Senior Cognos Developer
UW Medicine Neighborhood Clinics offer full range of primary care services
including family practice with Obstetrics, Internal Medicine, Geriatrics
and Pediatrics. It includes generating standard reports using Cognos series
8, Powerplay and ETL as the standards for reporting.
Responsibilities:
. Gathered, analyzed and documented user requirements for reporting.
. Involved in Upgrade Cognos 8.1 Environment to Cognos 8.3 and Deploying
and testing all the Clinical and Financial Reports.
. Used Report Studio to design Simple and Complex reports.
. Created some simple Reports in Query Studio.
. Tested Power Cubes meeting business requirements and successfully
deployed them into production.
. Scheduled and Distributed reports using Schedule Management in Cognos
Connection.
Environment: Cognos series8 (version 8.1 & 8.3), Powerplay Transformer,
Access Manager, Informatica, Oracle 10g, Microsoft SQL Server, Toad,
Teradata, Teradata SQL Assistant, Cognos Connection.
TracFone, Miami, FL
Aug 07-Feb 08
Cognos Developer
TracFone Wireless is the largest prepaid cell phone provider in the U.S.
Responsibilities:
. Involved in the Migration Project from Reportnet to Cognos8.
. Migrated and tested many reports in Report Studio.
. Involved in the installation and configuration of Framework manager.
. Created different packages and models in Framework manager based upon the
requirements and published them to Cognos Connection.
. Implemented Packet level security and object level security in Framework
Manager.
. Tested all the reports including dashboards and created a template and
solved many kinds of issues like Conditional Formatting to the
Dashboards, and many other issues in Report Studio.
. Gathered, analyzed and documented user requirements for reporting.
. Developed processes for cleansing, transforming, extracting, integrating
and loading data with use of Informatica.
. Analyzed the Data Warehouse and worked backwards through the stages and
identified the changes required to support the reports.
. Created simple and complex reports using Report Studio and Analysis
Studio.
. Developed Dash Board reports, Scorecards, Visual Layouts, Master detail
Drill through reports, Drill up and Drill down reports, multiple prompt
reports and cascading prompts in Report Studio and developed Scorecards
in Metric studio.
. Provided training in Report Studio and Query Studio to the end users.
Environment: Cognos series8 (version 8.2), Metric Studio, ReportNet,
Framework Manager, Informatica power center, Designer, Workflow manager,
Toad, Oracle 9i, DB2, Cognos Connection, Microsoft SQL Server.
UW Physicians Neighborhood Clinics, Seattle, WA Nov
06-Jul 07
DW Analyst/Cognos Developer/ Administrator
UW Medicine Neighborhood Clinics offer full range of primary care services
including family practice with Obstetrics, Internal Medicine, Geriatrics
and Pediatrics. It includes generating standard reports using Cognos series
8, Powerplay and ETL as the standards for reporting.
Responsibilities:
. Responsible for understanding Business Process and managing with Business
users to meet specific user requirements.
. Responsible for documenting user requirements and translated requirements
into system solutions.
. Developed processes for cleansing, transforming, extracting, integrating
and loading data with use of Informatica.
. Involved in the installation and configuration of Cognos products.
. Written complex queries to facilitate the supply of data to other teams.
. Worked with Metadata modeling of both Relational and Dimensional data
using Framework manager.
. Queried data from different database tables as per the requirement.
. Developed & tested Power Cubes meeting business requirements and
successfully deployed them into production.
. Optimized cubes using partitioning, time-based partitioning, cube groups
and incremental updates.
. Assisted System Administrators in Cognos Migration and installed software
updates.
. Tested all the Clinical and Financial reports and created a template and
solved many kinds of issues with Prompt pages, filters, formatting and
many other issues in Report Studio.
. Created some Complex financial and clinical reports that cannot be
migrated.
. Used Report Studio to design Simple and Complex standard reports with
multiple cascading prompts for the sales department.
. Prepared user and technical documentation and provided end-user training.
Environment: Cognos series8 (Version 8.1), Impromptu, Powerplay
Transformer, Access Manager, Oracle 9i, Informatica power center, Designer,
Workflow manager, Teradata, Cognos Connection, MS Access, SQL Server,
Teradata SQL Assistant, TOAD.
Endeavor Information Systems, IL
Jun 05-Sep 06
Senior Cognos BI Analyst/Developer
Endeavor Information Systems is a multinational company renowned for
providing quality software and services to libraries all over the world.
This project is to embed reporting capability into their products to
enhance end user experience and improve their business performance.
Responsibilities:
. Gathered and analyzed the user requirements.
. Designed models and packages in Framework Manager.
. Created burst reports and made them available to appropriate users
resulting in saving lot of time and effort.
. Implemented Packet level security and object level security in Framework
Manager.
. Created simple and complex reports using Report Studio.
. Developed Cubes in Powerplay Transformer according to the business
requirements.
. Optimized cubes by selecting appropriate methods, which include
partitioning, time-based partitioning, cube groups and incremental
updates.
. Tuned transformer models for faster cube builds and access times.
. Strong experience with Oracle PL/SQL in creating complex queries,
functions and stored procedures required for reports.
. Effectively used Schedule Management Tool, performance tuning and
bursting reports.
. Assisted administrator with deployment of reports to different
environments.
. Provided training and documentation to the end users.
Environment: Cognos ReportNet (Framework Manager, Cognos Connection, Report
Studio, Query Studio), Powerplay Transformer, DB2.
First Health, Downers Grove, IL
Sep 04-May 05
Cognos Developer
First Health offers group health programs to its clients' (insurance
carriers, self-insured payors and third-party administrators) across the
country. The project was to develop a Claims Management System for the
Claims Department to assist Claim Professionals to track and report Claim
Performance against key claim metrics and also investigate for potentially
fraudulent claims by identifying outliners.
Responsibilities:
. Responsible for business analysis and requirements collection.
. Creating models using multiple data sources in Framework Manager.
. Creating and publishing packages in Framework Manager using star schema
and defining layers in Framework Manager.
. Implemented list reports, crosstab reports, charts, dashboards, drill
through reports in report studio and performed data validation.
. Analyzed and implemented security in Cognos Connection and Framework
Manager.
. Provided necessary training for end users in Query Studio and Cognos
Connection.
Environment: Cognos ReportNet, PowerPlay Transformer, Access Manager,
Oracle 9i, Toad, UNIX
MCI, Colorado Springs, CO
Aug 03-Jun 04
Cognos Consultant
This project was a key phase in the company's development trying to
overcome issues with old reporting standards (excel), delays in reporting
and designing better metrics to monitor daily performance.
Responsibilities:
. Gathered and documented the user requirements for reporting
. Participated in development of catalogs, multiple queries and query
definition files using various joins and filter conditions in Impromptu
. Created various standard reports, drill through, dynamic prompts
. Worked extensively with Powerplay Enterprise Server and the Upfront in
publishing the cubes resulting in reduced time for report access
. Set up report level security
. Trained the end users to effectively use Impromptu and Powerplay
Environment: Cognos Impromptu 7.1, Cognos Powerplay 7.1, Cognos
Transformer, Impromptu Web Reports, Powerplay Transformer, Access Manager,
Cognos Upfront, DB2, Win NT.
Denver Water, Denver, CO
Jun 02-Jul 03
Cognos Consultant
This project is focused on reducing data access time, generate standard
reports. The project dealt with report generation for Sales Department
using Cognos Impromptu and PowerPlay.
Responsibilities:
. Analyzed & defined customer requirements and specifications and offered
solutions to fit the customer's need.
. Created User Classes that reflects the business hierarchy and provided
security.
. Designed Catalogs, Reports and IQDs using Impromptu Administrator.
. Created standard filters, calculation, prompts, and conditions.
. Published reports to the upfront web portal to provide accessibility to
the staff.
. Created cascading prompts in Impromptu reports to help users refine their
search.
. Created Drill-Through reports to provide users with more detailed
information.
. Participated in architectural review and revised requirements to reflect
technical feasibility of desired features.
Environment: Cognos Impromptu, PowerPlay, Transformer, Access Manager, SQL
Server, Windows NT.
Contact this candidate