Sql Server Developer Resume
Ga, AtlantA
SUMMARY
- Over 7 years of experience as a SQL Server Developer in the field of Database Design, Implementation.
- Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
- Involved in developing windows applications, web applications, and web services in Microsoft Visual Studio .Net IDE using C#,.Net 1.1,C#.Net2.0,VB.NET,ASP.NET,ADO.NET and SQL Server.
- Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
- Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
- Around 5 years of SQL Server Integration Service (SSIS) Experience.
- Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
- Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
- Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
- Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages.
- Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments.
- Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
- Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2000/2005/2008.
- Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
- Expert in generating drill down Reports in SSRS 2005/2008.
- Deployed reports across Test, Dev and production environments.
- Configured report subscriptions both data driven and time driven.
- Experience in SSRS in Creating reports using MDX and Analysis Services as a data source, Passing Parameters (MDX and regular) to drill down reports, Working with Charts/Gages (Multi Column datasets), Deploying Reports, and Administering Security
- Experiences in SQLServer Analysis Services OLAP Cubes, and Data Mining.
- Actively involved in the analysis of Cubes and added the KeyPerformance Indicators (KPI) to the created cubes.
- Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
- Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.
- Creating and Managing logins, users, roles and assigning necessary permission.
- Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.
- Creating and Managing logins, users, roles and assigning necessary permissions.
- Involved in Server &DBMonitoring and tuning efforts using various tools like Perfmon, SQL Server profiler, Index Tuning Wizard (ITW), SPOTLIGHT, and Log Explorer.
TECHNICAL SKILLS
SQL Server Tools: Enterprise Manager, Profiler, Query Analyser,Export & Import (DTS), SSIS, SSRS, SSAS.
Microsoft Technologies: ASP.NET 1.1,ASP.NET2.0, VB.Net,C#.NET, ADO.NET
RDBMS: MS SQL Server 2000/2005, Oracle 9i/10g, MS Access
ETL: DTS, SSIS, Data Stage
Programming Languages: SQL,T-SQL,PL-SQL,.Net
Internet Technologies: XML, HTML
Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage
Operating System: Windows95/98, UNIX, Windows2000/NT/XP,MS DOS
Reporting Tools: Crystal Reports 11,10,9, SSRS
PROFESSIONAL EXPERIENCE
Confidential, GA, Atlanta
Sql server developer
Environment: MS SQL Server 2008/2005, VS2008/2005, SSRS 2008/2005, SSAS, SSIS, Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007.
Responsibilities:
- Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle),Excel Spreadsheet to SQL Server 2008.
- Developed various T-SQL stored procedures, triggers, viewsand adding/changing tables for data extraction, data loads and transformations.
- Created various database objects such as tables, indexes and views based on the requirements.
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
- Involved in migrating some of the Informatica jobs in to SSIS packages.
- I worked with Informatica team by providing them stored proceduresand gather the requirement documents.
- Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.
- Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAPCubes, Dimensions and data source views.
- Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
- Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries, Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
- Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
- Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
- Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from those servers.
- EDI applications have been used on different systems according to the business requirement.
- Created and worked with drill down reports and identified the report parameters.
- Used various report items like tables, sub report and charts to develop the reports in SSRS.
- Deployed and generated reports on to the server using the Reporting Services Report Manager.
- Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules And integrated reports in MOSS 2007 using web parts
- Involved in setting up Performance Point Server and creating dashboards and scorecards in the PPS.
Confidential, Kansas City, KS
MS SQL Developer/SSIS/SSRS/SSAS
Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, Oracle 9i, VBScript.
Responsibilities:
- Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
- Involved in business requirement gathering and created functional/technical specification documents.
- Developed physical data models and created DDL scripts to create database schema and database objects.
- Designed data models using Erwin and Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
- Created SQL scripts for tuning and scheduling.
- Developed Web forms using ASP.NET using C#
- Developed application logic using C#
- Used N-tier architecture for presentation layer, the business and data Access layers and were coded using C#.
- Involved in performing data conversions from flat files into a normalized database structure.
- Developed functions, views and triggers for automation.
- Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
- Provided disaster recovery procedures and policies for backup and recovery of Databases.
- Scheduled Cube Processing from staging Database tables using SQL server Agent.
- Wrote MDX queries and expressions for use in front end BI applications.
- Created KPI objects in line with requirement Docs.
- Optimized Cubes for better query performance..
- Created reports by extracted data form OLAP Cubes.
- Extensively worked on designing reports using SQL Server Reporting Services (SSRS). Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
- Defined report layouts for formatting the report design as per the need.
- Wrote queries for drill down reports to get the dataset required to build the report.
- Identified and included report parameters for parameterized report.
- Formatted the reports using Global variables and expressions.
- Deployed generated reports onto the Report Server to access it through browser.
- Maintained data integrity by performing validation checks.
- Optimized queries, tuned and monitored server performance
- Installing SQL Server Client side utilities and tools for all the front-end developers/programmers
- Involved in performance tuning to optimize SQL queries using query analyzer.
Confidential, Glen Allen, VA
SQL Server Developer
Environment: MS SQL Server 2005, ANSI SQL, SSAS, SSIS, BO XI,, MS SQL Server Reporting Services 2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin, C#.Net, SAP, CSS, Java Script, XML, HTML
Responsibilities:
- Involved in gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.
- Followed the four step procedure for building data warehouse solution which comprised of Analyzing Business Processes, Identifying the Grain, then identify Dimensions and Facts.
- Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
- Involved in debugging Reports and deploying Reports.
- Created Tabular Reports, Cross Tab Reports and Sub Reports.
- Scheduled the Reports to run automatically.
- Extract Transform Load (ETL) development using SQL Server 2005,
- Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.
- Implementation of EDI transactions for medical clams.
- Experience in creating complex SSISpackages using proper control and data flow elements with error handling.
- Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
- Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
- Enhancing and deploying the SSIS Packages from development server to production server.
- Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
- Performed quality assurance for developing EDI financial software applications.
- Used ANSI dynamic SQL for writing to the standard ANSI pre compilers using macro command lines.
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Used Performance Point Server to create interactive reports with an ability to drill down into details.
- Experience in Performance Point Server powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
- Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards
- Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.
- Design, build, administer and production support of the BO reporting environment Vendor Management i.e. to work with Business Objects customer support team to report & resolve issues/limitations/bugs in the off the shelf BO software.
- Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
- Developed complex T-SQL code for the application.
Confidential
SQL Server Developer
Environment: MS SQL Server 2000/2005, SQL Server 2005 Analysis Services (SSAS), Reporting Services (SSRS 2000/2005, Microsoft Visual Studio 2005, BIDS, Visual SourceSafe, MSOffice, HTML, VBScript, Erwin and Visio.
Responsibilities:
- Gathered requirements from users and business analysts and created requirement documents.
- Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis
- Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
- Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
- Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks
- Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
- Expert in SQL joins, sub queries, tracing, usage of Table Variables, Temp tablesetc
- Experience in Event Logging, error handling& logging Log files, File and File Groups, Security, Backup and Recovery
- Worked on SSRS 2005/2000 to generate about 30+ reports for various user groups and developer groups.
- Created stored procedures to use as the datasets for the Report Design.
- Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports
- Extensively worked on Report coding to behave according to the front end CRM Application.
- Configured Subscriptions and Security for all critical reports.
- Handled the database components (Code migration, Change control) for application releases.
- Creates technical specifications, test plans and test data to support ETL processes
- Experience with Data migration utilities (Import & Export - BCP,Bulk Insert) from text to SQL Server
- Involved in Database Administration activities like Back up, Security, Migrations in the Development servers
Confidential
SQL Developer
Environment: SQL Server 2000/7.0, Oracle 8i, Ms-Access, Windows 2000, Linux, C++, T-SQL,Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS.
Responsibilities:
- Installation of SQL Server 2000 on Windows environment.
- Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
- Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity
- Checks, Update Statistics and Re-indexing.
- Configured and managed merge replication database articles.
- Developed DTS packages to transfer data from heterogeneous data sources and different files like Flat Files, Spread Sheets to SQL Server.
- Data migration (import & export - BCP) from Text files to SQL Server 2000/7.0.
- Created Triggers to enforce data and referential integrity.
- Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000.
- Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
- Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
- Responsible for Oracle/SQL Databases and Application performance tuning, physical/logical design and optimization and availability.
- Implemented and maintained industry standards in database management.
- Monitored SQL server performance using SQL profiler, Index tuning advisor for query tuning, stored procs.
- Maintained the database consistency with DBCC commands at regular intervals.