Cognos reports developer/DBA Resume

PROFESSIONAL SUMMARY:

Over 7 years of experience in various Cognos Reports/SQL DBA/SUPPORT roles in Technology environment.
Experience in working with Healthcare, Automotive, Manufacturing and Sales Industries, designing applications using various techniques.
Worked in Projects that use leading edge technology
Presentation Skills for Technical and Non - technical audiences.
Preparation of User guides and manuals.
Conducted and participated during sessions and presentations of the new systems and processes for the end users.
Performing Support Analysis to the Project Managers and Business counter parts.
Provided End User and Support.

Working Knowledge of Cognos, Mysql 5.0, MSSQL 2000/2005/2008 and crystal reports.
Excellent Communication and Demonstrative Skills.
Ability to lead a team.
Ability to learn and adapt to new Technologies Quickly.
Possess excellent technical skills, leadership qualities, consistently outperformed schedules and acquired interpersonal and communication skills.
Strong analytical skills with ability to perform development tasks with minimal Supervision.
Hardworking and Task accomplishing.

TECHNICAL SKILLS:

Operating systems/environment: MS DOS, MS Windows 7/95, WINDOWS NT/2003

Case tools: Cognos Reports, crystal reports

Languages: C

Databases: MS SQL 2000,2005,2008, Mysql 5.0

PROFESSIONAL EXPERIENCE:

Cognos reports developer/DBA

Confidential

Responsibilities:

Report Developer in Cognos 8 and DBA for MySQL.
Knowledge on Frame work manager.
Extensively working on Cognos 8 (Query Studio and Report studio) as report developer.
Having good knowledge on Data warehousing Concepts.
Ability in analyzing Business Requirements.
Gather/Design report requirements and build sophisticated reports/dashboards/scorecards, analysis and queries
Develop macros/create job/event schedules to automate report execution & delivery.
Provide security, control report access.
Performed detailed requirements gathering, analysis in managing reports to achieve projects.
Team member in technical development of BI reports, applications and other tools.
Ensured a high level of availability for all critical reports and applications.
Team member in project for interpretation (Data), use of the end results and ensure that the data is understood by users.
Created ad-hoc queries and reports as requested and provide on-going support for these requests to end users..
Developed health care subject matter expertise related to Cognos reports.
Conducted in Cognos for end users and advanced users.

Contract DBA

Confidential

Responsibilities:

DBA for SQL 2005/2008.
Part of Data modeling team in data warehousing and clustering analysis and design.
Created various SSIS/DTS packages including ETL jobs.
Experience with tuning & optimization, disk space management, installs and maintenance in different environments with VM experience.
Migrated/Managed data from SQL server databases on the server and replicated as per client needs.
Load the data from various data sources into the working databases, including troubleshooting and monitoring.
Created various reports using various reporting services.
Part of a DBA/Support team in a 24 hr production environment which included Log shipping, tuning and performance analyzing.
Worked in a high volume client support environment, dealing with customers on the phone or via email, and solving various software design and development problems.
Escalated unresolved calls to third-line support.
Provided software installations, upgrades and to client.

Contract DBA

Confidential

Responsibilities:

DBA for SQL server with data integration and server management.
Created databases in SQL server including writing TSQL codes.
Migrated data from SQL server with data clustering.
Managed SQL server 6.5 servers with 1500 users and 5 databases on the MS SQL 2005 server.
Performance monitoring and loading data from various data sources into the working databases.
Backed up the databases with data recovery to the tape.
Supported MS SQL/Oracle database for Web reporting.
Created tables, stored procedures, Views, control files, shell scripts.
Automated the loading process for Web reporting.
Analyzed data, tables and objects in various MS SQL/Oracle databases.
Backed up the databases to the tape.
Created GUI programming using VB and databases in SQL server.
Load the data from mainframe into the working databases. Designed and defined database tables and objects using SQL
Backed up the databases to the tape.