Manager Project

I have Employment Authorization Card

Santhosh Kumar

Email: abnsag@r.postjobfree.com

Education Master of Science in Information Systems

Texas A & M International University, Laredo, Texas

Bachelor of Science in Electronics and Communication Engineering

Jawaharlal Technological University, Hyderabad, India

Technical Skills

ETL Tools Informatica Power Center 8.1.1/7.x, Informatica Designer, Workflow Manager,

Workflow Monitor

Data Modeling Tools Erwin 4.x/3.x, MS Visio

Reporting Tools Cognos 8, Cognos Reportnet 1.1, Cognos Impromptu 7.1, Business Objects XI R2

Databases Oracle 10g/9i, SQL Server, Ms-Access

SQL Loading Tool SQL *Loader (oracle)

Languages SQL, PL/SQL, ASP.Net, C#, VB.Net, C, C++, HTML, VHDL

Web Technologies Java Script, HTML

Operating Systems Windows 7/Vista, XP, 2000, 98, Ms-Dos, UNIX

Others MS-Office, Dream weaver, Fire works, TOAD

Experience

Graduate Teaching Assistant, Texas A & M International University, Laredo Sep 2007 – Dec 2007

Taught UNIV 1101 for Undergraduate students focused on exploring library website and resources

Graduate Assistant, Texas A & M University, Corpus Christi Apr 2007 – Aug 2007

Developed and enhanced Library web site using Dream weaver, Fireworks, Java script and HTML.

(http://rattler.tamucc.edu)

Provided technical assistance for library systems

Addressed & resolved patron concerns regarding systems, online access, remote access, hardware

and software queries

Projects

CTS, North Carolina Sep 2008 – Dec 2008

Role: Cognos Developer

Description: CTS is an IT consulting and software development services in diverse areas. The project was

aimed at making a data-warehousing system out of life insurance customers having different health

insurance policies and generating the reports according to the business requirements using the Cognos

Responsibilities:

Involved in gathering and analyzing Business requirements.

Performed Metadata Modeling using the Cognos 8 Framework Manager and published

the packages

Involved in creation of advanced reports using Report Studio

Developed list reports, cross tab reports, chart reports, reports with multiple prompts, cascading

prompts and Filters

Created complex reports such as dashboard reports, master detail reports, drill through reports.

Creating multi-lingual reports and bursting reports in Report Studio

Generated multidimensional Cube in Power Play Transformer

Worked on Power Play cube partitioning to improve performance

Integrated Cognos Power Play cubes and Reports with Cognos Connection

Used Cognos Connection for organizing, security, scheduling and distributing reports.

Trained users on navigation and creating simple reports in query studio

Environment: Cognos 8(Report Studio, Query Studio, Analysis Studio, Cognos Connection) Framework

Manager, Oracle10g, Microsoft Access, Cognos Scheduler, Windows XP.

Texas A & M International University, Laredo, US Jan 2008 – Apr 2008

Project Name: Data Modeling & Report Generation

Description: The objective of this project is to analyze the data from the given data source (User dataset,

Movies data set, Ratings data set) to generate reports based on user requirements. Goal was to create a

centralized reporting capability for users to perform different kinds of reports on different perspectives. It

is designed to provide accurate information for users.

Responsibilities:

Involved in the entire project life cycle from Evaluation, Design, Development and deployment of

end-user reports.

Developed Framework Manager Models to import the data from data sources, specified the

overall relational data architecture (metadata) and generated packages of various subject areas,

to be published onto a Cognos Connection.

Used Report Studio and Query Studio to develop various types of reports like list reports of user

information, cross-tab reports, and charts/graphs to track the sales performance of geographical

regions over various periods of time, master-detail, and drill-through reports.

Included Table of Contents and Bookmarks in the reports to make it user friendly and enhance the

accessibility of contents. Created Prompts, Calculations, Conditions, Filters and other Metadata

objects using framework manager.

Developed prompt pages and cascaded input prompts to filter reports on user specified criteria.

Involved in testing, debugging and documentation

Environment: Cognos 8, Framework Manager, Oracle 9i, Windows XP.

Texas A & M International University, Laredo, US Sep 2007- Dec 2007

Project Name: Order Management System

Description: The goal of this project is to develop order management software for a small grocery store.

It stores all the orders placed by the customer in SQL Server database. Manager and Employer have

different login privileges. Manager login has ability to add or delete an employee details. It retrieves the

data upon Query by employer.

Responsibilities:

Front End:

The login form consists of the username and password field where the employer can sign into his

own page.

Every employer has his own page customized according to the login. He can take the orders of the

customers, can view the placed orders of a customer, add new customers to the system, can view

all products available, add the newly arrived products and had ability to update the product

details. He can also edit the placed order.

If the customer has to place an order, the customer number is taken which is unique and all the

products (listed as drop down box) he needed are noted down. Each order is given a unique order

number. The date when the order was taken and when is it to be delivered is also taken

The order once placed can be modified by having the customer number.

Backend:

Created a normalized ER database to store Employees, Customers, Products and Order details

information

Created Stored Procedures and user defined functions.

Environment: VB.Net, SQL Server2000, Windows XP, Visual Studio 2003, HTML.

iLogic Technologies, Hyderabad Sep 2006 - Dec 2006

Role: Cognos Developer

Data was stored in Excel files and users had their own way to do the calculations, which lead to different

results and hence invite some error. Cognos was the reporting solution for this. Created cubes from the

Excel files and reports were built in Impromptu and distributed among the organization.

Responsibilities:

Created user classes, catalog prompts conditions, filters and calculations

Optimized the catalog by using database interaction, client/server balancing, database functions,

table weighting and governors settings

Set up drill through to Cognos Impromptu Report

Created a number of multi drillable, cross tab and sub reports

Used Cognos Scheduler to scheduler to schedule various reports

Created the model definition

Used the incremental update strategy for the cube

Performance tuning of power cubes to reduce the calculation time and partitioned cubes

Environment: Cognos Impromptu Administrator, Cognos Transformer, Cognos Scheduler, SQL and

Windows NT

iLogic Technologies, Hyderabad, INDIA May 2006 – Aug 2006

Role: Informatica Developer

Description: This application is for planning, maintaining and performance evaluation of employee’s

activities. The System keeps track of total man-hours spent at different levels, allows estimating overall

cost of project and individual contribution for a given period. The System allows the employees to report

their time and keep track of their allocated tasks, available/utilized hours. The managerial staff can use the

system to allocate resources to projects and can generate Weekly, Monthly, Quarterly Reports.

Responsibilities:

Involved in customer relationship, facilitation, organization, and problem solving skills.

Developed Type 1 and Type 2 mappings in Informatica

Designed and developed various mappings in mapping designer and sessions and workflows in

workflow manager to extract data from Oracle and flat files

Created and Modified ETL mappings

Developed and documented the full ETL process

Executed the SQL queries by using Toad exclusively.

Worked on code review and unit testing of the mappings

Used workflow monitor to tasks and performance

Prepared Test plans and Test review documents.

Environment: Informatica Power Center 7.1, Oracle, Window 2000 Server, TOAD.

Bharat Heavy Electricals Limited, Hyderabad, India Jan 2006 – April 2006

Role: Developer

Description: Authentication of employees by using ID and PASSWORD include both Software and

Hardware. The software code is programmed by using the simulator tool “KEIL UV2” and burnt in to the

AT89c51 microcontroller IC. For the purpose of burning the code into the chip we have designed the

EEPROM Burner .In the next method we have used the concept of Digital image and signal processing .The

software code is written in MATLAB and Code Composer Studio (CCS) Environment.

Responsibilities:

Designed EEPROM burner for the purpose of burning the code into the chip

Written code in Matlab.

Environment: Matlab, Code Composer Studio, Windows XP

Leadership Skills

Served as a President for ISAT (Indian Students Association at TAMIU)

Organized Software Freedom Day, a national level technical seminar on open source and free

software

Organized Seminars to form GNU LINUX user group

Personal Traits

Strong Quantitative and Analytical Skills

Strong Communication and Organizational Skills

Ability to function in a fast paced environment

Ability to work in team as well as independently

Fluent in English, Hindi and Telugu

Contact this candidate