We provide IT Staff Augmentation Services!

Database Developer Resume

4.00/5 (Submit Your Rating)

Pittsburgh, PA

PROFFESSIONAL SUMMARY

  • Highly motivated SQL server Developer with Seven Years of Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.
  • Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000.
  • Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, DTS, SSIS, SSAS and SSRS 2005/2008.
  • Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
  • Experience in writing complex SQL queries involving multiple tables inner and outer joins.
  • Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
  • Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
  • Worked Extensively on ETL process using SSIS package.
  • Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
  • Expert in design and developmentof SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
  • Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
  • Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS)based on client requirement.
  • Ability to deliver comprehensive BI through MS solutions including MS Excel, Microsoft Office SharePoint Server (MOSS), and Performance Point Server 2007
  • Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
  • Absolute knowledge of Agile Methodology in Software Development.
  • Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
  • Good understanding of Health care, Financial and Retail domains.

ACADEMIC
Bachelors of Computer Science

TECHNICAL

SQL Server 2008/2005/2000, MS-Access, OLE-DB, SSAS and OLAP, Transact SQL, VB.Net, ASP.Net, C/C++,SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, BIDS Studio, SQL Server Reporting Services (SSRS), Microsoft Excel, Crystal Reports, Windows 95/ 98/NT/2000/XP/Vista

PROFESSIONAL EXPERIENCE

CLIENT: Confidential, Pittsburgh PA, Oct 2011 – Present

ROLE : Database Developer

Confidential is a multi-practice law firm with more than 500 lawyers nationally. The firm provides corporate, litigation and regulatory legal services to leading businesses, governmental entities, nonprofit organizations and individuals throughout the nation and the world My duties in the project focused on maintaining, and optimizing the existing SQL databases; monitoring database performance and growth, performance tuning, to create Reports according to the business requirement using SQL Server Reporting Service (SSRS)and performed Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS).

RESPONSIBILITIES:

  • Developed Logical and physical data model using ERWIN and mapped the data into database objects.
  • Created Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports usingSSRS.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Problem identification, troubleshooting, resolution, and index tuning databases.
  • Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2008/2005, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007

CLIENT: Confidential, Parsippany, NJ, Jun 2010 – sep 2011

ROLE: SQL Server/SSIS/SSRS Developer

Confidential is a national provider of wireless voice, messaging, and data services capable of reaching over 293 million Americans where they live, work, and playgroups in the world. The project mainly involved in creating new databases, Performance tuning, creating, deploying and scheduling reports. Also it included Extract, Transfer and Loading (ETL) of data from flat file, excel sources, etc using SSIS, writing T-SQL, backups etc and create various operational, drill-through and dynamic reports using SSRS 2005.

RESPONSIBILITIES:

  • Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
  • Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
  • Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • 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.
  • Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
  • Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
  • Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
  • Scheduled the monthly/weekly/daily reports to run automatically.
  • 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.
  • 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 provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
  • Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.

Environment: SQL Server 2008/2005, MS Analysis Service SSAS Developer 2008/2005, MS Project,Asp.net, MS Access 2007/2003& Windows 2K platform.

CLIENT: Confidential, Milwaukee, WI, June 2009 – May 2010

ROLE: MS SQL Server/SSIS/SSAS Developer

Confidential is one of America\'s leading retailers & nation\'s largest general merchandise catalog business. The project involved in transferring data from OLTP (Online Transaction Processing) to OLAP (Online Analytical Processing) and in creating cubes using SQL Server Analysis Services to analyze the business activities. 
RESPONSIBILITIES:

  • Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs
  • Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
  • Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
  • Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
  • Implemented SQL Server OLAP services (SSAS) for building the data cubes.
  • Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Designing and building data load procedures using MS SQL Server.
  • Designed and implemented Stored Procedures and Triggers for automating tasks.
  • Configured product meta-data tables to support client data reporting needs.
  • Incremental and full database recovery with experience of complex recovery scenarios.
  • Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries

Environment: MS SQL Server 2000/05, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 2007, ASP.NET, C#.NET, XML, Windows 2003

CLIENT: Confidential, Chicago, IL, Jan 2008 – May 2009

ROLE: SQL Server/SSIS/SSRS Developer

Confidential is a private equity investment firm that acquires middle market businesses with growth potential and a clear path to value creation. I was working on Migration of SQL Server 2000 to SQL Server 2005 and created reports using SSRS.

RESPONSIBILITIES:

  • Migrated data from SQL Server 2000 to SQL Server 2005 with SP2.
  • Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
  • Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
  • Developed scripts to migrate data from multiple sources.
  • Maintained the security, integrity and availability of SQL Server.
  • Performed data backup, recovery, and transfer operations.
  • Analyzed business recovery requirements and maintenance strategies and plans for critical databases.
  • Database space management.
  • Was Responsible for creating, deploying and scheduling new SSIS packages.
  • Did Migration of the data from DTS to SSIS packages.
  • Created reports using SSRS.
  • Managed devices and databases, administered security, scheduled tasks, monitored server and database performance. Monitored allocation of memory and procedure cache, etc.
  • Worked with the other IT associates to design, implement, test, and enhance stored procedures and other applications necessary to support systems and file processing.
  • Designed, added, eliminated, and maintained indexes, organized tables, recommended changes to application development team.
  • Appropriately tuned database applications and monitored their performance for achievement of efficient database access for applications.
  • Performed data extraction and migration activities for populating test (or non-production) and customer databases.
  • Completed administration of MS SQL Server version 2000/2005.

Environment: SQL Server2000/2005 Enterprise Edition, SQL Enterprise manager, Crystal Reports, MS PowerPoint, MS Access 2000 & Windows 2003/2000 platform, DTS, SSIS, SSRS.

CLIENT: Confidential, Sept 2006 – Dec 2007

ROLE: SQL Server Developer

Confidential is government-owned and is the largest banking and financial services 
company in India by revenue, assets and market capitalization. SBI provides a range of banking 
products through its vast network of branches in India and overseas.

RESPONSIBILITIES:

  • Logical and physical database development.
  • Created data model, logical design, and physical design of the database.
  • Created new tables, views, indexes and user defined functions.
  • Developed complex T-SQL queries and Stored Procedures for the application.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Managed the security of the servers, part of administration duties.
  • Managed and Monitored System Utilization.
  • Managed Backup and Disaster Recovery of the systems.
  • Created and automated regular Jobs such as Daily/Weekly Report Generations.
  • Designed and Implemented the Stored Procedures and Triggers for automating tasks.
  • Developed complex stored procedures to create various reports.
  • Created DTS packages to output SQL Data to various data sources.
  • Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text files) to SQL Server.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, Windows2003, Visual Source Safe and FTP Communication, Replication.

CLIENT: Confidential, June 2005 – August 2006

ROLE: SQL Server Developer

Confidential is a leading IT company offering a wide array of customized solutions.It has excellent domain competencies in areas such as Investment Banking & Financial Service, Pharmaceuticals, Healthcare, and Manufacturing. As a diverse end-to-end IT solutions provider UniMak Softwares offers a range of expertise aimed at helping customers re-engineer and re-invent their businesses to compete successfully in an ever-changing marketplace. Project involved Configuring and Managing database to keep company data online for 24x7.

RESPONSIBILITIES:

  • Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
  • Created tables, indexes and constraints.
  • Defined stored procedures for module integrity and application.
  • Wrote database triggers in T-SQL to check the referential integrity of the database.
  • Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Managed the use of disk space, memory and connections.
  • Designed and implemented several complex reports and administration modules.
  • Designed VB forms using the forms and crystal reports were made for business reporting purpose.
  • Involved in performance tuning of the database and T-SQL queries using Explain Plan.
  • Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
  • Prepared of project documentation.
  • Prepared test plans for assembly testing & System Integration testing.

Environment: SQL server 2000/2005, Visual Basic 5.0, Win NT, Crystal Reports 8.0

We'd love your feedback!