We provide IT Staff Augmentation Services!

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.

Hire Now