Power Project

Title:Technical Illustrator/Drafter-SEACOR INCORPORATED

abpv28@r.postjobfree.com

Document

Source below

NAME: reddy, Sridhar

ADDRESS: 11421

ADDRESS2:

CITY: Artesia

STATE: CA

ZIP: 90701

CANDIDATE ID: 2249056

US CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 4

WILL RELOCATE: Yes -

JOB WANTED: Any

RATE NEEDED

: Open

TELEPHONE: 562-***-****

EMAIL: abpv28@r.postjobfree.com

HOMEPAGE:

HOTTEST SKILLS: Cognos =3+ yrs, VB =4+ yrs, Impromptu =3+ yrs, SQL =4+ yrs, Java =2+

yrs, Powerplay Enterprise =3+ yrs, Oracle =4+ yrs, Transformer =4+ yrs

REVISION: 03-OCT-01

YOE: 4

RESUME:

Career Objective:

Seeking a challenging position as a Cognos Developer in the generating reports, utilizing

my technical skills and experience with opportunity for learning and advancement.

Summary of Experience:

h Around 4 and half years of experience in IT Industry with experience in analysis,

design, testing, development, and implementation of client server applications of which

around 2 and half years of experience on Cognos.

h Expert in the development of Cognos Impromptu, Cognos Transformer, Power Play Reports.

h Extensively worked on Publishing of (IWR) Impromptu web.

h Extensively worked on Transformer for Data Modeling of the corporate data for building

up of Multidimensional Cubes.

h Strong analytical and conceptual skills in database design and development using

Oracle, Visual Basic, MS SQL Server and MS Access.

h Responsible for interacting with business partners to identify information needs and

business requirements for reports.

h Good communication and interpersonal skills.

Skilled Information Technology Professional specializing in OLAP software application by

using:

- Cognos Impromptu - Cognos Power Play -Cognos Scripting

-Impromptu Web Reports - SQL/PLSQL -HTML/DHTML - VB5.0 -Developer 2000

- MS-Access - Unix - Java

- VBScript - JavaScript - HTML

- Crystal Reports - SQL Server6.5/7.0 - C/C++

-Access Manager -Power Play Enterprise Server

Hardware/ Operating Systems:

Pentium, MS Windows NT/ 98/95, UNIX, MS DOS

Software Tools:

Cognos Impromptu 5.0/6.0, Power Play 6.5/6.6, Visual Basic 5.0/6.0, SQL, PL / SQL, Oracle

8, MS Access 7.0, MS SQL Server 6.5/7.0, HTML, C, C++.

Professional Experience:

Cognos Developer

Client: GE

Power systems, GA May, 01 -Present.

Responsibilities:

Developing and Customization of Impromptu Reports:

h Created Catalog and assigned joins, grouped according to the user requirements.

h Applied Governor settings to the appropriate users, table weighting to improve the

performance.

h Generated the reports using Cognos Impromptu tool by querying the database.

h Created List Reports, Crosstab Reports and Drill through Reports.

h Created different types of prompts like catalog pick list, cascading prompts etc.

h Customized the reports by adding calculations, conditions.

h Created the reports in HTML format for easy navigation.

h Involved in publishing the reports on the web using UPfront.

h Installed the Impromptu, Report Administrator.

Power Play Reports:

h Generated Business Mix Reports in Clustered Bar Display.

h Installed Cognos Power Play Transformer for Client, Cognos Power Play Server.

h Generated Top Ten Reports Rank & Sort Data on Percentage Growth.

h Created Multi-Dimensional Cubes and Reports as per the User Requirements.

h Generated Nested Categories and Revenue Statements.

h Data retrieval, Multidimensional analysis, Power Play structure.

h Reporter Operations such as Sum and Average, Intersection, etc.,

h Generated Trend Over Time, Variance Reports.

Environment: Cognos Impromptu 6.0,Impromptu Report Administrator, Cognos Distribution

Shuttle builder, Upfront,

Power play, Powerplay Enterprise server, Oracle 8i and Windows NT.

Cognos Consultant & Analyst

Client: Alpena General Hospital, MI Jan ! 01-April ! 01

Description: The OLAP project was to provide an investigation report for the Hospital

Management. The project describes carefully on the usage and allocation of the hospital

resources. The project was designed for management to estimate its processes for admission

and discharge timings and tracking the delay in both of these areas. It provides a

exhaustive investigation on the busiest doctor and most efficient ward in terms of number.

Cognos Impromptu Reports/Power Play

Responsibilities:

Power Play Reports:

h Generated Business Mix Reports in Clustered Bar Display.

h Installed Cognos PowerPlay Transformer for Client, Cognos PowerPlay Server.

h Generated Top Ten Reports Rank & Sort Data on Percentage Growth.

h Created Multi-Dimensional Cubes and Reports as per the User Requirements.

h Generated Nested Categories and Revenue Statements.

h Data retrieval, Multidimensional analysis, Power Play structure.

h Reporter Operations such as Sum and Average, Intersection, etc.,

h Generated Trend Over Time, Variance Reports.

h Generated Switch, Pie, Bar, Nested Charts, Line Displays.

h Exception Highlighting, Sorting, Ranking etc.

h Drilling down, Slice and Dice, Filter Change Displays.

h Deployed the Power Cubes on Cognos PowerPlay Enterprise Server.

h Ranking (6 Reports) for Top Ten Customers.

h Top Ten Billing Customer Service Locations.

h Top Ten Revenue Generating Skills.

h Employee Charts (Converting PowerPlay Reports to Excel spreadsheets).

h Written Macros for Transformer model, which adds the security to that model based on

the information in the .imr files, have most recent data for security information.

Developing and Customizing Impromptu Reports, IWR:

h Customized data by adding calculations, summaries and functions.

h Queried from different database tables as per the requirement.

h Using Portfolio, reports were presented Created List Reports and Cross Tab Reports and

Drill Through reports.

h Generated reports using Cognos Impromptu tools querying database.

h Changing Reports from one Catalogue to another Catalogue.

h Created reports in HTML format for easy navigation of data from web browser.

h Created standard and Ad hoc reports using Cognos Impromptu tool.

h Developed Impromptu Web Reports and published using Upfront.

h I involved in creating and publishing web reports in to the Web.

h Installed Impromptu 6.0, and PowerPlay Enterprise Server6.6.

Environment: Cognos Impromptu 6.0, Impromptu web reports (IWR), SQL Server, Power Play

6.6, Power Play Enterprise Server 6.6, Transformer, and Windows NT.

Client: Alliance Pharmaceutical Corp, CA Sep ! 00-Dec !Y00

Responsibilities:

h By using the Transformer models, created the Power Cubes for different group of end

user, to perform their own multidimensional analysis and create reports on OLAP data in

Cognos Power Play for Web, Windows and Excel.

h Provided security and multi-user access using Access Manager.

h Wrote Script to link to report site with the main application and to automatically

update the cube without disturbing the users so that the user can get the most recent

data.

h Generated reports using Cognos Impromptu and Power Play.

h Created Cognos Power Cubes and deployed them on Power Play Enterprise Server.

h Optimizing by Table Weighting, Query Performance (Governor! s setting)

h Created Catalog Prompts, Conditions and Calculations.

h Created and enhanced existing Power Cube as per user requirements.

h Used both Auto Design and Manual Design for Creating Power Cubes.

h Created the time dimension properties as per the requirement.

h Created Multi-Dimensional report using Power Play.

h Created template for impromptu reports and mailing labels.

h Drilling down, slicing, dicing and changing displays.

h Changing filters, layers and measures.

h Data retrieval, Multidimensional analysis, Power Play structure.

h Reporter Operations such as Sum and Average, Intersection, etc.,

h Exception Highlighting, Sorting, Ranking etc.

h Created Multi-Dimensional reports using Power Play.

h Created Standard and Ad hoc reports using Cognos Impromptu tool.

Environment: Cognos Impromptu, Power Play, SQL Server and Window NT.

Client: Syndicate Bank Dec ! 99-Aug! 00

Responsibilities:

h Creation of reports including Drill through Reports, Cross Tab Reports using Cognos

Impromptu.

h Creation of dimension maps for Transformer. Established all dimension hierarchies and

calculated measures. Used Impromptu Query Definition as the source.

h Creation of cubes using Cognos Power Play.

h Implementation of Impromptu reports and Power play cubes.

h Creation of macro and Batch file to run macro.

h Created Reports using Cognos Impromptu by querying the database.

h Created Business Mix Reports and Top Ten Reports.

h Customized data by adding calculations summaries and functions.

Environment: Cognos Impromptu, Power Play, Transformer, and MS-Access.

Client: Specious Chemicals Ltd. Jan ! 99-Nov !Y99

Description: Created the different reports according to user needs. The system calculates

employee pay and maintains corresponding records with pay slips generated monthly. Main

reports include pay-slip, pay register, deduction statements and yearly

earnings/deductions for particular employee.

Responsibilities:

h Marinating all employee details and assist in the development of user documentation.

h Payroll accounting wages and incentives Medical reimbursements leave and travel

expenses reports.

h Customized catalogs and created user profiles to grant user permission for accessing

data from different database tables.

h Participated in design of the Employee & Department modules; developed screens for the

same.

h Used Cognos Impromptu tool to create standard & Adhoc reports.

h Involved in the Unit Testing plans for evaluation of the entire application, Coding

and testing the application by unit test plans.

Environment: Cognos Impromptu, Power Play, Transformer and Oracle.

Client: M.N.Technologies, IND April ! 98- Nov !Y98

Project Tracking System

Description: This project involved in developing a project management system to track

project costs for an overseas client on UNIX/Oracle platforms using VB and PL/SQL. I

worked on the Time and Expense module of the system. Was responsible for designing and

developing several key screens and reports. The key screens include Time Entry Screen,

Project Expense Entry Screen, and Cost Summary by Project/Task Screen. Project cost review

report.

Responsibilities:

h Developed several key management reports including Project status report, Time and

Expense tracking report.

h I involved in designing and coding.

h Helped with performance tuning of several batch programs and reports.

h I have used Visual Basic as Front End Screens.

Environment: Oracle 7.3, Visual Basic 5.0,and Crystal Reports.

Client: Data Con Software Solutions. IND June !Y97-Mar !Y98

Management Information System.

Description: This module is designed and implemented to keep track of student database

for an Educational and Software Training Institute. This system take care of each and

every process of the institute encompassing student enrollment for short/long term courses

with fee details, structures and payment modes for students information with different

screens for ex: dropout list screen, billing screen etc. Generation of fee receipts,

notices to students with optional change format, issuing of certificates and also library

information like availability/issue/return status of books in the library is also

maintained. Weekly/monthly report of students enrollments and projects assigned, duration

and status of information are to be generated and sent to head quarter to keep updated

information for management reference.

Responsibilities:

h Involved in designing and developing the system screens.

h Used DAO! s for accessing the data.

h Used ActiveX Controls like MS Flex Grid etc.

h Involved in creation database tables.

h Generating reports using Crystal Reports.

Environment: Visual Basic 5.0,Crystal Reports, Windows 95, MS-Access 97.

Client : Modern Electrical Ltd. India. Dec! 96!VMay! 97

Project : Power Transformer Design System

Description:

This system was developed to enable design of various transformers i.e. current, power,

tolerance etc. It involves various iterative calculations for current and voltage ratings

where the user input is the primary current and voltage. This package in turn gives the

core size and the gauge of the copper wire etc. The standard values are stored in .DAT

files and the used to do calculations.

Responsibilities:

h Designed the screens related to the calculations of various types of transformers.

h Classes are designed and created to find the current and voltage ratings.

h Developed the screens include the input and output parameters.

h Analyzing the correctness of the percentage tolerance.

Environment : VB, Oracle7.X, Crystal Reports and Windows 95.

Education:

BE(Bachelor of Engineering

in Computer Science ).

Contact this candidate