We provide IT Staff Augmentation Services!

Database Consultant Resume

4.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • Over five years of experience in IT of which more than as MS SQL SERVER 2005/2008/2012/2014 and Oracle 11g.
  • Preferred Data - stage Experience and strong experience on using Stages, customization, design and definition Stage
  • Good at ETL Preperformance tuning
  • Have strong data warehouse concept and data model skills using ER-win
  • Hands on experience on VSTS 2010
  • Hands on experience on MySQL and MySQL pentaho
  • Hands on experience on DB2
  • Be able to provide whole ETL solution along with ETL schedule solution.
  • Solid experience with XML
  • Solid experience with Agile
  • Solid experience with Crystal Reports 9.0
  • Experience in Database Development such as Creation of Databases, Tables, Stored Procedures, Triggers, Views and Functions using Transact-SQL.
  • Hands on Experience in upgrading from MS SQL Server 2008 to MS SQL Server 2012
  • Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Excellent exposure to Data Transferring Tools like Merge and Transactional Replication.
  • Extensive experience in writing queries by using Joins Indexes and views.
  • Strong skills in setting-up and administering SQL Server replication and DR solutions
  • Extensive experience in SSIS (SQL Server Integration Services), SSRS (Reporting Services) and SSAS (Analysis Services).
  • Understanding of software quality management principles (tracking, analyzing, reporting, problem resolution and training)
  • Expert in DAX expressions
  • Expert in Share Point
  • Experience in SAP
  • Experience in PowerShell
  • Experience in Mongo DB
  • Ability to build and maintain strong working relationships with other DBAs and application teams
  • Extensive development experience with MDX cube skills
  • Extensive development experience in OLAP cube design and implementation for large terabyte size data warehousing installation.
  • Wrote C# Script for SSIS
  • Organize professional with excellent Oral and written communication skills.
  • Ability to work on fast paced work environment skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training /supporting end users.
  • Experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Adviser.
  • Worked with Oracle Loading and Unloading operation using Oracle Exp/imp utilities, SQL Loader, Oracle Data pump and External Tables good hands on handling high volume data.
  • Have worked on database management activities such as scrubbing, meta-data index and table creation.
  • Have configured, tested, patched and monitored all instances of database.
  • Experience in database segmentation and worked on designing the index and make partitioning.
  • Developed user audit strategies and major changes to the production tables using packages. Also managed user permissions on database objects.
  • Extensive experience in Installation, managing, monitoring, troubleshooting Configuration and Maintenance of MS SQL Server
  • Experience in supporting multiple Production database servers including backup and recovery, Performance Tuning.
  • Experience in resolving database performance and deadlocking issues.
  • Have an excellent catalytical, communication, programming and problem solving skills. Strong believer of automation.

TECHNICAL SKILLS

Operating Systems: Windows NT/XP/VISTA/7/8.

Databases: MS SQL Server 2005/2008/12/14 , oracle/DB2

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, Alerts, SQL Jobs, SQL Mail, DTS,SSIS,SSRS and SSAS

ETL Tools: (DTS) Data transformation services, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS) Datastage 8.5

Development skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, C# JAVA

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Database Consultant

Environment: MS SQL Server 2012/2008, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), VSTS 2010,Crystal Reports 9.0, HTML, PowerShell CSS, ADO.NET, flat files, Excel, BCP, Bulk Insert, SQL Profiler, Query Analyzer, Windows XP Pro, Windows Performance monitor.

Responsibilities:

  • Involved in migrating the database from SQL Server 2005 to SQL Server 2008/12.
  • Involved in designing ETL solutions to migrate data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
  • Design, develop, and maintain SSRS reports.
  • Involved in designing and creating the website utilizing HTML and CSS for designing and using ADO.Net for connecting back end databases for managers and end users to access information as needed.
  • Testing of T-SQL Queries and performance tuning of those Queries as well as documentation.
  • Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
  • Used SQL profiler to capture slow running queries and stored procedures and used Windows Performance Monitor as a tool for performance tuning.
  • Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
  • Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
  • Responsible for developing and deploying reports using Crystal Reports.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data Warehouse.
  • Performed T-SQL tuning and optimizing queries for reports that take longer execution time in SQL Server 2008.
  • Provide complex customer support and technical communication in support of the tiered customer support model
  • Provide input to Test Strategies and Test Plans.

Confidential - Chicago, IL

Database Consultant

Environment: .MS SQL Server 2008/2008R2/2012, SSIS, SSAS, SSRS, Agile,Import and Export Data Wizard, SQL Query Analyzer, SQL Profiler, Window performance monitor, Crystal reports 9.0, Windows 7/8

Responsibilities:

  • Involved in migrating the database from SQL Server 2005 to SQL Server 2008/12.
  • Migrated from SQL Server 2005 to SQL Server 2008.
  • Creating and running DTS Packages for Import and Export of Heterogeneous Data.
  • Testing of T-SQL Queries and performance tuning of those Queries as well as documentation.
  • Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
  • Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
  • Involved in generating and deploying various reports using global variables, expressions and functions using SSRS
  • Involved in designing, implementing and managing data warehouses OLAP cubes to use with SSAS 2012.
  • Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
  • Migrated all DTS (Data Transformation Service) packages to SQL Server Integration Services (SSIS) and modified the packages according to the advanced feature of SQL Server Integration Services (SSIS).
  • Responsible for developing and deploying reports using Crystal Reports.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data Warehouse.
  • Performed T-SQL tuning and optimizing queries for reports that take longer execution time in SQL Server 2008.

Confidential

MS SQL Developer/ BI Developer

Environment: MS SQL Server 2008/2005/2000 , SSAS, SSIS, SSRS, SQL Profiler/Analyzer, Management Studio, Import/Export Wizard, Excel, Oracle 10G, DB2,Windows Performance monitor, Crystal Reports, XML, Windows XP/Server 2003.

Responsibilities:

  • Designed ETL (Extract, Transform, Load) strategy to transfer data from source to stage and stage to target tables in the data warehouse tables and OLAP database from heterogeneous databases using SSIS and DTS (Data Transformation Service).
  • Developed SSIS packages to export data from Excel (Spreadsheets) to SQL Server, automated all the SSIS packages and monitored errors using SQL Job on a daily basis.
  • Prepared reports using SSRS (SQL Server Reporting Service) to highlight discrepancies between customer expectations and customer service efforts which involved in scheduling the subscription reports via the subscription report wizard.
  • Involved in generating and deploying various reports using global variables, expressions and functions using SSRS.
  • According to customer requirement, understand ETL requirement and project environment; provide technology architecture support against problems of ETL architecture design, solution design and deployment.
  • Re-engineering of ETL to make multi-node partitions in parallel in DataStage 8.5.
  • Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS (SQL Server Analysis Service).
  • Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
  • Involved in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
  • Involved in designing and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained referential integrity using SQL server
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
  • Monitored scheduled jobs and alerts created for SSIS packages and SSRS reports in SQL Server
  • Implemented complex business requirement in back-end using efficient stored proceduresand flexible functions, and facilitated easy implementation to the front end application.
  • Closely interacted with subject matter experts in understanding the business process methodology.

Confidential

MS SQL & BI Developer/ DBA

Environment: MS SQL Server 2005/2008, SSAS, SSIS, SSRS, SQL Profiler/Analyzer, SAP, Management Studio, Import/Export Wizard, Excel, Oracle 10G, Windows Performance monitor, Crystal Reports, XML, Windows XP/Server 2003.

Responsibilities:

  • Worked as a developer on databases like MS SQL Server 2008, MS Access (using DTS, T-SQL, scripts, stored procedures and views).
  • Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
  • Develop,implement and document processes and standards for SAP Business Objects
  • Involved in Logical & Physical design, development and testing of the system.
  • Managed requests from the clients and from the development teams.
  • Designed and developed the Logical and Physical model of the database.
  • Developed complex T-SQL code for the application.
  • Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Worked on complex data loading (implemented the batch data cleansing and data loading).
  • Involved in designing and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained referential integrity using SQL server
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Generated reports using MS Reporting services.

We'd love your feedback!