We provide IT Staff Augmentation Services!

Sql Resume Resume

Nashville, TN

SUMMARY

  • Over 7 years compound experience in SQL Server database development experience with DBA duties
  • Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005
  • Experience in developing and monitoring SSIS Packages and DTS
  • Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
  • Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering
  • Experience in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
  • Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
  • Extensive experience with Monitor, tune and analyze db performance and allocate server resources to achieve optimum db performance.
  • Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
  • Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
  • Extensive experience in design techniques, ETL processes, relational database theory, N-Tier development
  • Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Excellent report creation skills using Microsoft Reporting Services
  • Used Microsoft team foundation and VSS.
  • Excellent communication, presentation and interpersonal skills
  • Strong troubleshooting and organizational skill

TECHNICAL SKILLS:

Tools

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS,SSAS Business Intelligence Development Studio, , Data Transformation Services. Performance Point Server

Database

Oracle 9i/8i/7.x, MS SQL Server 2000/7.0/6.5/2005/2008, DB2 UDB, MS Access 2000/7.0,

Testing Tools Win Runner, Load Runner, Test Director, and Quick Test Pro.

Operating Systems

Microsoft Windows XP/2003/2000/9i/NT, IBM AIX Unix 4.2, Red Hat Linux 8, IBM OS/390 version 2.8, Novell Netware 4.1, Sun Solaris 8 and DOS

LanguagesC, C++, Perl, J2EE (JSP, Servlets, EJB), SQL, PL/SQL, Transact SQL, Unix Shell scripting, HTML, XML,VB scrpt, Java script
Mercury Interactive

Southwindhp, Nashville, TN Aug'09-Till Date
SQL Developer/BI Developer
Responsibilities:

  • Developed user defined functions, indexes, user profiles, relational database models, data dictionaries
  • Created views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages
  • Gather requirements and design of data warehouse and data mart entities
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
  • Analyzed the existing data mart in SQL 2000, planned and performed the migration from SQL server 2000 to SQL Server 2005 following the Normalization standards to maintain data consistency.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
  • Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL SSIS.
  • Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.

Confidential, SanFransisco,CA Sep '08-June'09
Database Consultant
Responsibilities:

  • Perform design, development and implementation work related to the maintenance.
  • Developed Triggers, user defined functions, indexes, user profiles, relational database models, data dictionaries
  • Helped in Maintaining Data Integrity
  • Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions
  • Created system for capturing, reporting, and correcting error data.
  • Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
  • Provide on-call support to production system to resolve any issues.
  • Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc
  • Gather requirements and design of data warehouse and data mart entities
  • Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record
  • Implemented the lookup transform extensively to populate the unmatched entries to dimension table
  • Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads
  • Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference
  • Developed financial models, preferably related to fixed income trading.
  • Actively participated in all phases of equity / fixed income research
  • Extensively worked with SSAS for processing different cubes
  • Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
  • Conduct code walkthroughs and review peer code and documentation.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
  • Worked on different file formats(fixed width, ragged right and delimited data sets)
  • Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month
  • Responsible for creating reports based on the requirements using SSRS 2005/2008.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
  • Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services(SSAS)
  • Defined a bunch of parameters like database name, server name, file location in the config file using package configuration utility
  • Checked in and checked out packages using VSS and Team foundation
  • Designed web pages using HTML, ASP and VB Script.

Environment: SQL Server 2005, Microsoft Business Intelligence Development Studio, .Net Frame work, T-SQL, SSIS, SSAS, SSRS, ERWIN, Business Objects

Confidential, Memphis, TN Jan'08-Aug '08
Database Consultant
Responsibilities:

  • Participated in Design and Architecture meetings and proposed technical solutions to resolve business requirements.
  • Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.
  • Extensively involved in gathering user and system requirements for the RMRS-B Data mart.
  • Worked closely with the architect and team in designing, developing and implementing the logical and physical model for the Data mart.
  • Involved in the analysis of an existing application (RMRS-C) built on SQL Server 2005 platform and leveraged it for the design of RMRS-B.
  • Analyzed various processes like OMS, Orders, Metrics, Adjustments and Objectives.
  • Followed the Microsoft recommended best practices in designing, developing, implementation and testing of the ETL using SQL Server Integration Services.
  • Built various packages in SSIS to load the data coming from various interfaces like OMS, Orders, Adjustments, Objectives, FARM and CR!FT.
  • Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
  • Created and Modified customized Crystal reports to satisfy each organizational specific needs
  • Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
  • Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
  • Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
  • Worked with the team in building the daily dollar, summary, funnel genie, objective and adjustments reports.
  • Created different user level groups, and assigned appropriate permission levels to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the Organizational hierarchy.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
  • Tested the Business Objects XIR2 migration to ensure the reports are functioning as per requirements.
  • Both Client side and Server side scripting was accomplished using VB Script.
  • Worked in Creation of new security for the migrated reports and users.
  • Worked in resolving issues that were raised during the scheduling
  • Experience with design and development of business reports using SSRS and Crystal Reports 9.0/10.0 for Client-Server and Web based applications
  • Involved in end to end documentation of all the processes including aggregation, metrics and all the relevant customizations made in the system.
  • Actively participated in (UAT), preparation of user manual and technical support manual.

Environment: SQL Server 2005, Microsoft Business Intelligence Development Studio, Business Objects, .Net Frame work, T-SQL, SSIS, SSAS, SSRS

Confidential, Ashburn, VA Jan '07 - Dec'07
Database Developer / Administrator
Responsibilities:

  • Extensively involved in gathering user and system requirements for the POS Data mart.
  • Developed a data model and implemented the same using ERWIN.
  • Analyzed the existing data mart in SQL 2000, planned and performed the migration from SQL server 2000 to SQL Server 2005 following the Normalization standards to maintain data consistency.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
  • Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL SSIS.
  • Created several Reports using Crystal Reports .Net and presented in printable format
  • Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
  • Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes using Performance Monitor, Profiler, and Database Engine Tuning Advisor.
  • Created stored procedures to build the Fact tables in the data mart cubes for Multi-Dimensional analysis.

Environment: SQL Server 2005/2000(2003 ,64 bit edition of SQL Server 2000, Microsoft Business Intelligence Development Studio, VB.Net, Active-X script, ASP.Net, Business Objects ,T-SQL , SSIS, SSAS, SSRS

Confidential, Abilene, TX Mar'06-Dec'07
SQL Server Developer
Responsibilities:

  • Created views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages
  • Participated in designing, testing disaster recovery model & implementation.
  • Wrote complex stored procedures to process drivers record and balanced the processing load between front end and back end
  • Troubleshooting DB performance issue and implementing necessary Database changes
  • Successfully requested drivers driving record from Choice Point a third party vendor and successfully entered those received drivers information into Database for further processing
  • Managing SQL Server security, replications, created logins, roles and users
  • Developed DTS packages to refresh Master Policy Data on a daily basis from an Excel Workbook provided by the finance and accounts departments
  • Migrated new policy information published by agencies onto an FTP site in Access file format using DTS jobs on a nightly basis
  • Experience in data extraction, transforming and loading (ETL) using data transformation services (DTS), SSIS, Bulk Insert, and BCP.
  • Worked in modifying, testing and maintaining universes and built Cross-Tab reports
  • Worked in creating and maintaining Business Objects reports and Web Intelligence reports.
  • Worked in resolving major issues affecting the reporting environment.
  • Provided solutions for the most complex scenarios of linking objects
  • Implemented batch processing for approval process using Stored procedures, DTS & Jobs
  • Optimized the performance of queries with modification in index system for online system
  • Converted DTS packages to SSIS based upon business requirements.
  • Generated reports using Crystal Reports 8.0
  • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing

Environment: Server 2005/2000(2003 ,64 bit edition of SQL server 2000), 7.0,SSAS, SSRS, VSS, VBScript, XHTML, XML, Windows 2000/2003 Server, IIS 5.0, 6.0, 7.0.

Confidential, New York, NY Sep '05 - Feb'06
SQL Server Developer with Business objects
Responsibilities:

  • Participated in gathering User Requirements and System Specifications
  • Involved in designing, testing disaster recovery model & implementation
  • Designed physical development databases on SQL 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in developing database for contract maintenance system.
  • Enhanced database structures as per the business requirement which is applicable for Contract Accounting Maintenance in an efficient way.
  • Developed and maintained data, procedures and performed Data Impact Analysis
  • Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.
  • Wrote and modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
  • Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Implemented distributed transaction using MS Distributed transaction coordinator on replication and Linked servers.
  • Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
  • Coordinated and assisted with the Front-End Developers in handling & solving bugs.

Environment: : SQL Server 2000 Enterprise Edition, Enterprise manager, Windows NT, XML, SQL Reporting service, DTS

Confidential, Hyderabad, India May'03-Aug'05
Database Consultant
Responsibilities:

  • Creating Database objects including Tables, Indexes, Clusters, sequences, roles, and privileges.
  • Calculating and monitoring size and space for tables, clusters and indexes
  • Creating separate table spaces for Users, Indexes, Rollback Segments and Temporary Segments. Renaming and resizing of redo log files, user data files, rollback files, index files and temporary files.
  • Creating and maintaining Triggers, Packages, Functions and Procedures.
  • Interacted with users to collect and analyze the specs and designed documents, includes functional and technical specifications.
  • Responsible for design of the Schema and finalization of naming and coding standards throughout project life cycle.
  • Planning and Implementation of backup and recovery of the Oracle 7.x Database.
  • Created Oracle instance, table space and UTL settings. Developed, Tested and Migrated the Oracle PL/SQL scripts to Production. Developed, Tested and Migrated UNIX Shell Scripts.
  • SQL* Loader Scripts was used for loading the data into oracle tables.. Responsible for the creation and maintenance of the Table spaces, Users and assigning Roles and Privileges

Environment: Oracle 7.x, SQL*DBA, SQL*Plus, PL/SQL, Developer 2000 (Forms 4.5, Reports 2.5)

Hire Now