- 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.
Operating systems/environment: MS DOS, MS Windows 7/95, WINDOWS NT/2003
Case tools: Cognos Reports, crystal reports
Databases: MS SQL 2000,2005,2008, Mysql 5.0
Cognos reports developer/DBA
- 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.
- 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.
- 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.