Manager Sql Server
Resume:
Chandan Revuri [pic]
*******@*****.***
Professional Summary:
Certified Cognos 8 BI Developer with 7 years of experience and expertise in
providing business
Solutions for IT Industry in areas such as Insurance, Health, Financial
Services, Telecom and Networking with a Functional and a Technical approach
in Business Intelligence (BI) and Report Generation.
Technical Expertise
. Experience in Full life cycle system development: Data Requirement
Analysis, Design, Development, Testing, Implementation and
Documentation of Business Applications.
. Proficiency in developing reporting applications
using Cognos Business Intelligence components like Framework Manager,
Report Studio, Query Studio, Analysis Studio, Metrics Studio, Data
modeling, Power Play Transformer, Cubes, Power Play client,
and Cognos Connection.
. Organized and accessed several data sources into transformer models,
Dimension maps, Dimensional data marts and developed Power Cubes,
which can be changed in many ways to Slice and Dice and Drill Through
data for further Multi Dimensional Analysis using Cognos (Framework
Manager, PowerPlay Transformer and Impromptu).
. Good knowledge of Data extracts strategies, Cognos EP (Impromptu,
Cognos Scheduler, Access Manager, Dashboard, Upfront and Cognos
Visualizer).
. Hands on experience in implementing Dimensional Modeling, Metadata
Modeling, Deployment process, Cardinality, Cascading, Crosstab,
Charts, Repeaters, Grouping, Sorting, Section, Bursting and
Conditional Blocks.
. Proficient in designing multidimensional Model in Framework Manager
in Cognos BI version 8 and as well as Strong knowledge and
understanding of Snow Flake and Star Schemas.
. Developed OLAP applications using Cognos suite of tools.
. Experienced with multiple relational databases including Oracle
10g/9i/8i, MS SQL Server and DB2.
. Efficient in Optimizing, Debugging and testing SQL queries and stored
procedures written in Oracle and SQL Server 2000, 2005 & 2008 and MS
Access.
. Excellent communication and interpersonal skills. Strong experience in
client interaction and understanding business application, data flow
and data relations.
Technical Skills:
Reporting: Cognos 8.4/8.3/8.2/8.1, Cognos Report Net 1.1
MR3/MR2/MR1: Framework Manager, Report Studio,
Query Studio, and Analysis Studio, Metric
Studio/ Metrics Manager, Cognos Connection.
Cognos Impromptu Web Reports 7.3/7.4, Powerplay
Enterprise Server, Access Manager 7.3/7.4, and
Cognos Visualizer.
ETL: Business Objects (Desk Intelligence and Web
Intelligence), Reporting Services (SSRS) and
Crystal Reports.
OLAP/Modeling: Cognos Data Manager, Informatica Power Center
(Repository Manager, Power Center Designer,
Operating Systems: Workflow Manager and Workflow Monitor),
Languages: Ascential Datastage7.x.
Web Technologies:
RDBMS: Cognos PowerPlay Transformer, PowerPlay
OOAD methodologies: Transformer 7.3/7.4,
SCM/Version Control: Analysis Services (SSAS).
UNIX, Windows NT/XP/2000 and MS-DOS.
Others: PL/SQL, Perl,VB.Net, ADO, ASP, ASP.Net, C, C++
JavaScript, HTML, XML.
Oracle 8i/9i/10g, SQL Server, MS Access,
TeraData, DB2.
Unified Modeling Language.
Clearcase (Base, Multisite), CVS, Clearquest.
Erwin, TOAD, Queryman, MS Visual Studio, TCP/IP,
UDP.
Work Experience:
Clearwire, Kirkland, WA
Aug '09 - Present Sr.Cognos Developer
Clearwire is the first one in the corporate world to launch 4G (Wimax)
Technology.This project was to develop complex reports, scorecards and
dashboards to report performance information to managers, policy makers and
public. The whole project was to coordinate the design and construction of
DB2 tables to support development of a new reporting system using Cognos
Report Studio and Oracle as data-ware house.
Responsibilities:
. Understand user requirements and Data Model documents defined and
developed by the business analysts and data architects.
. Implemented Dimensional Modeling and Relation modeling in Framework
manager and created query subjects, relationships, filters and
calculations in the model.
. Communicate to the business analyst, Data Modeler on a regular basis
to be informed on changing requirements or data model design
alterations.
. Developed detailed and summary reports using Cognos Report Studio.
. Created drill thru reports and enabled the drill-thru feature on the
current master reports to manage more complex business reporting
requirements.
. Involved in setting up Hierarchies, performing Drill and Slice & Dice
operations and creating Cross Tab Reports.
. Developed reports using different Joins, Unions, complex display
logics using different variables.
. Created different Burst reports, filters, and prompts as per the
Business requirement.
. Created Highly Customized Reports using Report Studio like Conditional
Formatting Reports, Cascade Prompt Reports and master detail
relationship.
. Involved in Installation, implementing, administrating Cognos for both
networked and web-based solutions to maintain Cognos reports on the
web.
. Security Administration for setting up users, groups and roles and
creating access permissions.
. Provided user Training to fellow consultants and end user training to
client representatives.
. Upgraded Framework Manager 8.2 models to 8.4 and republished packages.
. Tested every report to make sure:
- Converted from 8.2 to 8.4 correctly
- Validated
- Checked whether Runs correctly in an acceptable timeframe
. Strategically extracted/cleansed data from multiple data sources
including SQL, Excel Spreadsheets, CSV Files, and MS Access Databases
through application of refined decision stream modification and design
techniques.
. Provided expertise, assistance and feedback to other departments in
extracting data and creating reports and peer review reports created
by other developers.
. Deployed the packages (exporting and importing the packages) using the
Deployment functionality under Cognos Connection Portal.
. Documented standard reports development methodology for Business Users
. Once approved the reports were signed off by placing them in the
Network Drive and converting the database from Test Production.
Environment: Cognos Framework Manager, Cognos BI 8 Series (Report Studio,
Analysis studio Query Studio, Event studio, Cognos Connection), Oracle, SQL
Server, Cognos Decision stream, Data Stage .
Westcon Group, Tarry Town, NY
Nov '08 - Jul '09
Sr Cognos Reports Developer/Data Analyst
Westcon is a leading distributor of networking and communications
technologies operating in the IT channel. In this project, I was a member
of the Sales and Marketing Analytical team which was responsible for
providing key information and reports to the management on the performance
of the systems in various territories and the performance of respective
sales team.
Responsibilities:
. Built models containing query subjects, query items, and namespaces
from scratch as well as from imported, design the dimensional modeling
and data modeling as per the requirement supports the business
processes.
. Configured the content manager, Framework manager, and application
server.
. Created metadata models, Joins, filters and calculations in packages,
organized Folders according to the Business view and published the
packages using Framework Manager onto Cognos Connection and created
the store procedure.
. Created Cubes, Lists, Grouped Crosstab, and Reports with calculated
fields, conditional filters and Drill Through functionalities.
. Created Reports to evaluate the business performance based on various
sales territories.
. Designed the reports and catalogs using Impromptu from OLAP, as per
the requirements.
. Used Dashboard/Scorecard to monitor the execution of corporate
strategic objectives at each level of the organization.
. Created dashboards that show the status of various product sales and
ordering information.
. Developed Ad-hoc reports using Query studio.
. The Reports Developed in Test area were sent for testing, roll over
and validation through Snapshots and Publishing it in HTML which they
view in their Browsers.
. Created catalogs for different group of reports in the project as
per the requirements.
. Using Powerplay cubes as data source import into Framework Manager,
and created Models, packages for Analysis Studio.
. Created highly Complex Reports using OLAP Cubes as Data Source for
Multi Dimensional Analysis.
. Scheduled to trigger dashboards based on an event using Event Studio.
. Worked on Cognos Security Administration to restrict the Users.
. Updated Impromptu Catalog by adding tables and creating new joins.
. Used Cognos Scheduler to schedule the Reports.
. Lead teams abroad from multiple countries and developed an efficient
off shoring model for project development.
Environment:
Cognos 8.3 Suite- Framework Manager, Report Studio, Analysis studio, Event
studio, Metric Studio, Powerplay Transformer, ReportNet 1.1, Impromptu 7.0,
PL/SQL, MS-Excel, Windows 2003, Oracle10g.
SunTrust, Atlanta, GA
May '07 - Oct '08
Cognos Consultant
SunTrust Banks, Inc., is one of the nation's largest and strongest
financial holding companies. Through its banking subsidiaries, the company
provides deposit, credit, trust, and investment services to a broad range
of retail, business, and institutional clients. Other subsidiaries provide
mortgage banking, asset management, brokerage, and capital market services.
Responsibilities:
. Installed and configured Cognos8 client /server tools and Web Server.
. Set up database connectivity in Cognos Connection.
. Built Framework Manager Model, and established the cardinalities to
suit the business needs. Implemented security for Data access, Object
level access and Package access.
. Developed and Published Packages in Framework Manager - Connecting and
testing the data source, created database layer, physical layer and
presentation layer, defining appropriate relationship between query
subjects.
. Was responsible for Application Reporting and supported all users from
different organizations in the company.
. Some of the Key Reports were Cost point Sales Report, International
Revenue Report, Prepaid Consulting, Customer Count Report, License
revenue report, Maintenance Revenue report, AR Aging Cube and
Consulting Bonus Reports.
. Developed List, crosstab, drill through, master-detail, chart and
complex reports which involved Multiple Prompts, Filters, multi-page,
multi-query reports against multiple databases.
. Applied grouping and associated the data with group functionality to
get the required Impromptu report.
. Performed aggregate functions on calculations in report studio.
. Developed prompts with report pick list and generated the current
information by applying proper filter condition.
. Fixed issues with reports and successfully deployed
the reporting application for production.
. Built PowerPlay Cubes for General Ledger, Purchasing, Accounts
Payables and Federal Administrator.
. Tested the join paths between the tables in Impromptu.
. Created User Groups, Roles to implement the Cognos Security, using
LDAP.
Environment:
Cognos8 (Framework Manager, Report Studio and Query Studio), Cognos
Scheduler, Configuration Manager, Content Manger, Impromptu 7.3, Cognos
Series 7.3, Cognos Power Play 7.3, Cognos Transformer 7.3, Windows NT,
Oracle 9i, Toad, PL/SQL, MS Access.
First Citizens Bank, Chase City, VA
Sep '06 - Apr '07
Cognos ReportNet Consultant
The company uses Cognos Business Intelligence to provide timely reports,
deep analysis and notifications of key business issues. The scope of this
project was to provide the financial department with timely reports based
on their performance, profitability, revenue and many more.
Responsibilities:
. Interacted with the Business Users, BI Team, ETL Team
and Report Analysts to analyze the report use cases.
. Gathering requirements from the business, end users and the existing
ORR Reports to understand the requirements and build an
agile reporting platform which could accommodate both Actual Deals and
Proposed Deals data.
. Developed Framework Manager Model using Proposed Deals and Actual
Deals Data Mart to facilitate and ease the complexity in the Data
Marts for Reporting.
. Adeptly used filters, calculated data items, query subjects and
security in the Framework Manager.
. Eased the complication of the Bridge Table and Workflow Table in the
Data Mart to simple Query Subjects to make the reporting effortless
for the business users and Report developers.
. Involved in implementing drill-up/drill-down on cubes from DMR
techniques.
. Intensively worked on Report Studio to develop reports based on
Leasing Agents, Attorneys, Tenant DBAs and many more, which would not
only replace the existing reports but also enhance them with new
features.
. Developed various complex reports using Query calculations, Layout
calculations Filters, Conditional Blocks and Report Expressions.
. Worked on Metrics studio for highlighting the key performance of the
organization (Scorecarding).
. Enhance the look and feel of the reports using various kinds of
prompts, Java Scripts, HTML items and Layout Component References.
. Developed Single and Multipage Reports based on user requirements and
user selection using Conditional variables.
. Working closely with ETL team in flattening the tables, pre-
calculations and to have the live data.
. Used Query Studio to develop reports on the fly.
. Involved in the complete business cycle of the project from Research,
Planning, Analysis, Development and Testing.
Environment:
Cognos ReportNet 1.1 MR1, Cognos EP Series 7.x (Impromptu Administrator,
Impromptu Web Reports, Power Play Transformer, Access Manager, Ascential
DataStage 7.5.1,HTML, XML, Netscape Directory Server, Oracle 8i/9i, MS
Access, SQL, PL SQL, Toad.
Amerus Group, Des Moines, IA Dec
'05 - Aug '06
Cognos & SQL Server Developer
Amerus is involved in Life Insurance & Annuity Products since the year
1896. The Project involved in developing the Policy wise Revenue Reports &
Policy Holders Reports in ReportNet 1.1.Besides Policy Comparison
Analysis reports in Transformer 6.6.
Responsibilities:
. Interacted with the Business users and documented their query,
business analysis and reporting needs. Understood data and business
logic underlying the requirements.
. Created Projects, Models and Packages using Cognos Framework Manager
and deployed packages on Cognos Connection.
. Created folders, filters, prompts and complex financial calculations
in Framework Manager and Report Studio. Created charts, Lists and
Crosstabs, using Report Studio and ad hoc reports using Query Studio.
Developed various dimensions, measures and calculation
in Cognos Transformer.
. Developed Budgeting & Revenue Reports in using Report Studio.
. Setup the Cognos samples and created a Pilot project in Cognos BI .
Involved in Creating Content store, installation and Configurations of
the ReportNet. Involved in creating security and deployment (exports
and imports).
. Tuned Cube builds, Impromptu Reports and ReportNet reports and servers
for better performance.
. Provided security to the ReportNet in Access Manager through LDAP
Server and configuration settings in Cognos configuration.
. Administration involved Installation and configuration
of Cognos servers, implementing security, managing users, user groups
and roles in the organization. Worked on bursting reports for the web
users.
. Implementation of Impromptu reports and PowerPlay cubes using multiple
queries.
. Imported power cubes from the PowerPlay enterprise server to
ReportNet Cognos connection server.
. Scheduled PowerPlay reports to run on a monthly, weekly and daily
basis using Cognos Scheduler.
Environment:
Cognos ReportNet 1.1 (Framework Manager, Report Studio and Query Studio),
Cognos PowerPlay 7.3, Cognos Transformer 6.6b, Cognos Impromptu 7.3, SQL
Server 2000, Oracle 10g/9i, Windows 2003, RH Linux 9.
ICICI Bank, Hyderabad
Aug '04 - Nov '05
SQL Server Developer
ICICI Bank is India's second-largest bank in India. ICICI Bank has a
network of about 614 branches and extension counters and over 2,200 ATMs.
The Project involved end-to-end application deployment to support Loan
Organization like online loan application, loan interest rates, Adjustable
And Fixed Rate Loan, Balance Transfer of your existing loan from other
banks, Compliance, Reporting and treasury operations.
Responsibilities:
. Working on Client/Server tools like SQL Server Enterprise Manager and
Query Analyzer to Administer SQL Server.
. Involved in requirement gathering, analysis, design, development,
change management, deployment and user training.
. Actively involved in Normalization & De-normalization of database.
. Designed DDL and DML for MS SQL Server 2000.
. Create rules, defaults, tables, views, clustered & non-clustered
index, user defined data types, and user defined functions.
. Responsible for General Database Administration, Query Performance
tuning.
. Taking Database full Backup, Transaction log backup & differential
backup in daily Routine.
. Worked with DTS packages to load the massaged data into Data
warehousing system.
. Trouble shooting problems by using SQL server profiler.
Environment: SQL Server 2000, SQL Server 7.0, Windows XP, SQL Server
Enterprise Manager, SQL Server Query Analyzer.
Reddy Labs, Hyderabad
Jul '03 - Aug '04
Reports Developer/Analyst
Reddy Labs is a leading chemical Research Lab in India. It has systems
designed to automate the Lab activities in the Analysis Department and also
has systems automated for Registration and activities pertaining to the
Testing/Analysis of Samples that are submitted to the Lab.
Responsibilities:
. Involved in system study, requirements gathering and analysis.
. Designing of inputs and outputs.
. Created PL/SQL procedures and scripts to build business rules to load
data, also involved performance tuning.
. Improved integrity by identifying and creating relationships between
tables.
. Designing and development of forms and reports.
. Extensive testing and enhancements.
. Generation of User manual and system manual generation.
Environment:
PL/SQL, SQL Server, Shell scripts, UNIX, Windows NT
Education and Qualifications:
. Bachelor of Engineering from JNTU, INDIA.
Contact this candidate