Sql Server Developer\dba Resume
Sacramento, CA
SUMMARY
- Over 7 years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2008/2005/2000 databases.
- Designing, testing and implementation of high availability solutions for databases for large, medium and small customers.
- Experience in SQL Replication models, Stored Procedures, Triggers, Indexes, Views, Locks, Data Transformation Services, and Analysis services.
- Coding of Database objects like Triggers, Procedures, Functions and Views.
- Expert in MS SQL Server suite of products like SSAS, SSIS and SSRS of MS SQL Server 2008.
- Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance.
- Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
- Exposure to T - SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package.
- Extensively worked on developing and deploying applications using: SQL Server 2008/2005, Microsoft office, VBA and macros.
- Experience in developing and monitoring SSIS and DTS Packages.
- Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.
- Extensively worked with SSIS for extracting data from legacy systems to stage and then to Cleanse, Process and Loading into Data Marts and Data Warehouse.
- Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
- Very good experience in developing reports using SQL Server 2008 Reporting Services (SSRS).
- Hands on experience in creating ETL packages using SQL Server 2008 Integration Services (SSIS).
- Worked with OLAP and Data warehouse application and worked with star schema, type1/type2/type3 dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
- Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning.
- Worked with writing the ETL process to implement the hybrid data environment using SSIS and custom query.
- Hands on experience in creating OLAP cubes using SQL Server 2008 analysis services (SSAS).
- Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
- A Team-Player with motivation and ability to work independently, worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
- Worked with performance tune the complex queries using the Microsoft Query analyzer and used to support batch process.
- Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues. Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
TECHNICAL SKILLS
RDBMS/DBMS: Microsoft -SQL Server 2008/2005/2000/7.0 , Oracle 8i & 9i, MS Access.
BI /Data model Tools: Microsoft SQL Server Reporting Services 2005/2000, Crystal ReportsDTS, SSIS, Erwin and Visio
Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/
Windows XP, IIS 5, 6:
Programming Languages: T-SQL, PL/SQL, C, VB 6.0, VB Script, SQL * Plus, VB.NET, ASP .NET
Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business
PROFESSIONAL EXPERIENCE
Confidential, Sacramento, CA
SQL Server Developer\DBA
Responsibilities:
- Implemented triggers and stored procedures and enforced business rules via checks and constraints.
- Created stored procedures and views to generate various Drill-Down reports.
- Created SSIS packages using derived columns, Fuzzy lookups, execute SQL tasks, Data flow tasks and transfer SQL server objects task to load data from different sources like Excel spread sheets and text files to SQL server Database.
- Created SQL server jobs using SSIS package and automated those jobs using job scheduler for day to day data loads from different sources.
- Involved in monitoring of daily scheduled jobs, database backups and transaction logs for production support.
- Created the complex reports like drill down using SSRS.
- Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
- Monitoring the performance of databases and creating indexes to improve the performance of SQL server.
Environment: SQL Server 2008, BIDS,T-SQL, SSIS and SSRS
Confidential, Detroit, MI
SQL Server Developer
Responsibilities:
- Implemented triggers and stored procedures and enforced business rules via checks and constraints.
- Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
- Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
- Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
- Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.
- Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
- Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
- Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
- Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
- Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
- Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.
Environment: SQL Server 2005, MS BIDS, T-SQL, SSRS.
Confidential, Charlotte, NC
SQL Server SSIS Developer
Responsibilities:
- Worked on the reporting module of the project as a developer using T-SQL scripts, stored procedures and views.
- Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
- Worked on Performance tuning, and optimization of procedures and queries.
- Verified/Compared results in database tables using DB Visualizer.
- Expert in script tasks, look up transformations and data flow tasks using SSIS.
- Used DTS and T-SQL store procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
- Set-up and maintained the environment stability of more than 3 database servers in BACARDI system and responsible for the deployment/migration of the code across ETL environment.
- Proven ability in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design.
- Used Erwin to reverse engineer the existing database design in MS SQL Server 2005.
- Worked on different kinds of transformations in SSIS as per the client’s Requirements.
- Expert in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Environment: MS SQL Server 2005/2000, SSRS, DTS, T-SQL, XML, Erwin, MS ProClarity, Windows 2003 Advanced Server.
Confidential, Overland Park, KS
SQL Server BI Developer
Responsibilities:
- Wrote several SQL Scripts such as finding tables that has Identity Columns, finding tables that do not has primary key.
- Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
- Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
- Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
- Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
- Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
- Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
- Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
- Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select statement in certain queries.
- Created views to restrict access to data in a table for security.
- Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
- Involved in development of various critical Master Detail Forms, Reports, Procedure, Functions, Packages and Database Triggers using Oracle.
- Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
- Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
- Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
Environment: SQL Server 2005/2000, XML, MS Access 2005/2000, ERwin 4.x, Oracle 10g, MS SharePoint.
Confidential, Houston, TX
SQL Server Developer
Responsibilities:
- Actively involved in Normalization and De-normalization of database.
- Designed and developed a Front Office database system.
- Create tables, views, clustered & non-clustered indexes, user defined data types, and User-defined functions.
- Involved in administration of the SQL Server by creating users & login ids with appropriate roles and grant privileges to users and roles.
- Created and used stored procedures for database transactions in SQL Server.
- Used T-SQL statements for retrieval of data and involved in performance tuning of T-SQL.
- Created automatically running Stored Procedures and Triggers.
- Created and customized DTS packages and used to load data from different sources.
- Extensively used the SQL Analyzer and Profiler for studying the SQL statements and Stored Procedures.
Environment: Windows 2003, MS SQL Server 2000, Business Objects and ETL tools.