We provide IT Staff Augmentation Services!

Database Consultant Resume

Mechanicsburg, PA

PROFESSIONAL SUMMARY:

  • A Senior Level Consultant with over 18 years’ experience in Information Technology specializing in Information/Data Management including Architecture, Data Warehousing design, Data Modeling, Business Intelligence (BI), Data Quality and Maintenance. Full Systems Development (SDLC) experience from planning to implementation and operations.
  • A highly motivated and ambitious individual able to give timely and accurate advice, guidance, support and training to team members and individuals. Possessing excellent communication and shows dedication, strong commitment, teamwork, planning, monitoring and problem solving skills. Having the ability to work with the minimum of supervision.
  • Over 18 years of IT experience with more than 10 years in Data Warehousing, Data modeling, Database Administration, System Analysis, Design, Development and Support of Sybase, MS SQL Server 2005, MS SQL Server 2000, 7.0 in Production, Test, Development and Replication Environments.
  • Experience in DTS (Data transformation Services), SSIS and Reporting Services.
  • Experience in Multidimensional database design skills on SQL Server 2000/2005 and Oracle
  • Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
  • More than 7 years of experience in Developing Stored Procedures, triggers and UDFs using SQL Server, Oracle and Sybase Adaptive Server.
  • Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
  • Experience in ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 8.1/7.1 and PowerMart 6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
  • Significant experience in Data modeling across wide spectrum of industries like Judiciary, Finance, Healthcare, Public Welfare, Entertainment and Insurance using Power Designer,Rational Rose, Erwin and Visio.
  • Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
  • Good SQL Server Administration skills using various backup recovery, Model (simple, Bulk and full), database maintenance plan, user (NT/SQL) security authorizations.
  • Data migration using DTS services across different databases like Oracle, MS access & flat files.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
  • Good understanding of Master Data Management (MSM) using CRUD (Create, Read, Update, Delete) Cycle.
  • Experience in BAAN and CODA Financials.
  • Solid understanding of BIG DATA and Hadoop .
  • Experienced in developing various web applications using ASP.net and VS.net.
  • Good understanding about BPM technology, Cloud computing and PEGA.

TECHNICAL SKILLS:

ETL tools: Informatica Power Center 7.2/6.1, SSIS, DTS

OLAP Tools: Business Objects XI R2

Reporting Tools: Crystal Reports 9.0

Data Modeling Tools: ERWIN, Visio 2002, Rational Rose, Power Designer 10

Languages: T - SQL, PL/SQL, XML, HTML Script, VB script, Java, J2EE

RDBMS: Oracle 9i/10g, MS SQL Server 2005/2000/7.0 Sybase Adaptive Server 15.0.2, Sybase IQ, Front End MS Visual Basic 6.0, ASP.net

Version Control Tools: Visual Source Safe 6.0, Team Foundation Server

Operating Systems: Windows 2003 Enterprise Server, 2000 Advanced Server, Windows NT

Other Tools/Languages: Embarcadero DBArtisan,Embarcadero RapidSQL 8.5Visual Studio.net, BMC Remedy User, Sharepoint

ERP: Package SAP CRM 4.0, BAAN

Financial Package: CODA Financials

BPM Tool: PEGA (Training), NoSQL Hbase

Big Data Analytical tools: Hadoop, Sqoop, Fume, Pig, Hive, Flume, Oozie

PROFESSIONAL EXPERIENCE:

Confidential, Mechanicsburg, PA

Database Consultant

Environment: Sybase Adaptive Server 15.0.2, Embarcadero DBArtisanPower Designer 10, SQL Server 2005/2008, Sybase IQ, TFS, BMC Remedy User

Responsibilities:

  • Direct the design, development, review, documentation, and implementation of data models for relational database applications with a special emphasis on assuring data integrity and access between major applications.
  • Used Power Designer as the data modeling tool.
  • Used Sybase Adaptive Server 15.0.2 and SQL Server 2005/2008.
  • Responsible for maintaining the Master Data for the entire CP Case Management system.
  • Coordinate data models, dictionaries and other database documentation across multiple enterprise applications
  • Day-to-day responsibilities include analysis of data requirements and translation of these requirements into data models. Other responsibilities include developing modeling and naming standards, writing modeling guidelines, developing power-user training materials, loading master data and transaction data across client project teams.
  • Create new database logical and physical design to fit new business requirements, and implement new design using Power Designer.
  • Extensively used BCP Utility, DTS and XML for data migration and replication.
  • Write scripts and performs data fixes, tests and schedules appropriately.
  • Designed, developed and implemented data interfaces for various state agencies.
  • Determines the need for database modifications; writes and maintains database specifications.
  • Integrate the Master data with the Lower court business process for the appropriate case upload from Lower court to Common Pleas court.
  • Configure the Master data to send appropriate messages to JNET when certain events happen on a case.
  • Involved with the application developers and IT management team as needed in developing design improvements to the underlying databases.
  • Validated change requests and made appropriate recommendations.
  • Use Remedy User and TFS to track and resolve end user issues.
  • Create complex Stored Procedures, triggers, cursors, tables and security views.
  • Analyze long running slow queries and tune the same to optimize application and system performance.

Confidential, Harrisburg, PA

Database Architect/Developer

Environment: SQL Server 2000/2005 Windows 2000 Advanced Server

Responsibilities:

  • Designed and Created databases, tables, views, stored procedures and triggers.
  • Monitored and scheduled existing/new jobs on production environment.
  • Experience in Extracting, Transforming and Loading (ETL) data using SSIS which is latest in 2005 also implemented DTS Import/Export utility
  • Imported data from text files and excel spread sheets into SQL Server 2000 database using DTS package.
  • Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
  • Responsible for incorporating database changes for the new enhancements.
  • Created reports from Data Warehouse using SQL Server Reporting Services (SSRS).
  • Perform the integration testing for newly added functionalities.
  • Extract data from different environments and provide as needed reports according to the request from different users.

Confidential, Harrisburg, PA

Database Administrator/Modeler

Environment: SQL Server 2000/ASP.Net/Crystal Enterprise/Win 2000 Advanced Server/ Erwin 4.0

Responsibilities:

  • Plan, install, configure, and upgrade installations of Microsoft SQL Server.
  • Worked as a Data Modeler for various projects.
  • Responsible for creating schema objects like tables, views and indexes.
  • Involved in the Database Architecture for various projects using Visio Professional.
  • Created numerous DTS Packages for transferring and manipulating data from heterogeneous DBMS using various connections, workflows and tasks.
  • Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
  • Configured various Publishers and Subscribers for Transactional replications.
  • Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
  • Performed database health checks using SQL profiler, SQL performance monitor and performance counters.
  • Created Database Maintenance Plans for the Performance of SQL Server which covers DBCC CHECKDB, re-indexing etc.

Confidential, Harrisburg, PA

Database Architect

Environment: SQL Server 2000/Rational Rose 2000/ Windows 2000 Advanced Server, Rational Rose

Responsibilities:

  • Worked as a Data Architect for the Confidential project.
  • Used Rational Rose and UML as the data modeling tool.
  • Good working knowledge with Use Cases, Activity diagrams and Sequence Diagrams.
  • Responsible for data dictionary generation.
  • Creation of the Logical model of the database.
  • Experience in the migration of Legacy data in the DMS to the new SQL server Database.
  • Physical implementation of the database.
  • Identify different database objects such as stored procedures, triggers and views needed for the entire application.
  • Developed and used SQL Scripts to maintain consistency between different databases and responsible for moving data files from one to other servers.
  • Monitored and improved database performance by creating efficient database design, creation of necessary indexes and table partitioning. Completed documentation of database structures and processes used to move data in and out of database for future development and expansion of database.
  • Day-to-day responsibilities include analysis of data requirements and translation of these requirements into data models. Other responsibilities include developing modeling and naming standards, writing modeling guidelines, developing power-user training materials, loading master data and transaction data across client project teams
  • Responsible for importing the legacy data to the redesigned database.

Confidential, Portland, OR

SQL Server DBA

Environment: SQL Server 2000/Windows 2000 Server

Responsibilities:

  • Performance tuning and testing on stored procedures, indexes, and triggers
  • Creation of database triggers.
  • Established backup and recovery procedures for databases and implemented automated jobs for backup.
  • Scheduling of the jobs for Data transformation and routine processes.
  • Assist the development staff with best practices for SQL Server including but not limited to code optimization.
  • Developing Security administration, DDL Script generating and maintenance.
  • Extensively used SQL Server BCP Utility, DTS Import/ Export to load the database from text files received from different applications.
  • Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc. Automating Jobs and Creating Alerts.
  • Automated consistency check of the database (DBCC) for SQL Server.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • Monitoring the data file, transaction log and temp DB growth.

Confidential, Los Angeles, CA

Database Administrator/Modeler

Environment: SQL Server 2000/ SQL Server 7.0

Responsibilities:

  • Worked as a Data Architect in various projects.
  • Extensively used Erwin as the Data modeling tool.
  • Plan, install, configure, and upgrade installations of Microsoft SQL Server.
  • Experience in the migration of SQL Server 7.0 to SQL Server 2000
  • Review and enhance existing SQL stored procedures and write new stored procedures
  • Design, develop, and maintain the development, test and production database architectures, including database management, configuration, optimization, security, replication, maintenance, and support.
  • Involved in the implementation of clustering server.
  • Developing Backup plan and performing timely data and transaction backup and recovery of data.
  • Creation and monitoring extract, transformation and loading scripts
  • Restoring the back up at the time of database mark suspect or corrupt.

Confidential, Simi Valley, CA

Programmer Analyst

Environment: Visual Basic 6.0/DB2 400 V4R4

Responsibilities:

  • Involved in the system design.
  • Generated DFD’s, ERD’s and System Flow Charts for the entire system.
  • Incorporated in Data modeling using Visio Professional.
  • Used Client Access as the database connectivity tool.
  • Created the User Interface Design for the entire application.
  • Created COM objects and ActiveX controls.
  • Developed by using VB 6.0 as the front-end and DB2/400 V4R4 as the database under Windows NT environment.

Confidential, Peoria, IL

Programmer Analyst

Environment: VB 6.0, Sybase SQL Anywhere 5.02, Windows NT 4

Responsibilities:

  • Involved in the Design, Development, Customization and Implementation of Patient management system for various health care clients of the client.
  • Involved in Patient Scheduling module.
  • Developed by using VB 6.0 as the front-end and Sybase SQL Anywhere 5.02 as the database under Windows NT environment.
  • Responsible for creating stored procedures, triggers and adhoc queries in the back end.
  • Developed and tested Next Free slot, Waiting list, Customization of price scheduling and Appointment windows in this module.
  • Used the three-tier architecture concept in the entire application.

Confidential

Programmer Analyst

Environment: Visual Basic 5.0, Oracle 7.0, Crystal Reports

Responsibilities:

  • Software is a customization to Coda Financials.
  • Involved in Manual and Auto bank Reconciliation.
  • Involved in Data modeling using the Case Tool ERWIN
  • Involved in DBA works includes Database Creation and Performance tuning.
  • Create complex Stored Procedures, triggers, cursors, tables and security views.
  • Physical implementation of the database.

Hire Now