We provide IT Staff Augmentation Services!

Sr. Sql Developer Resume

Ashburn, VA

SUMMARY:

  • Around 7years of IT experience in Design, Development, Implementation and support of RDBMS in Production and Development Environments using Oracle Tools.
  • Involved in complete Project Life Cycle including requirements gathering and Analysis, Database design, Database development, Application development, Testing, Implementation and Support of the application software and extensively on Production support.
  • Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views, partitioned tables using SQL database programming language.
  • Extensively used Cursors, REF Cursors, composite data type and Collections in writing the backend SQL code.
  • Expertise in Database Performance Tuning using Oracle Hints, Partitioning and Indexes, Gathering Statistics.
  • Experience in developing SQL*Loader control programs and SQL validation scripts for validating data to load data from staging tables to production tables.
  • Hands on experience in installing, configuring, managing, upgrading and migrating Backup/Restore , monitoring and troubleshooting SQL Server 2008 and 2012.
  • Extensive experience withvarious test efforts like data validation, integrity testing and Unit testing.
  • Excellent in Query Optimization Techniques, Creating, Replacing & modifying database entity models and maintenance.
  • Used Oracle APIs for Oracle Financials Domain.
  • Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
  • Good team player, quick learner and detail oriented, strong technical, organizational and report writing skills combined with self-motivation.
  • Good interpersonal, Analytical and communication skills.
  • Good working experience in Reports, T-SQL , PL/SQL and RDBMS Concepts
  • Good expertise in all the stages of Full Software Development Life Cycle Implementation (SDLC ).

TECHNICAL SKILLS:

RDBMS: SQL Se rver Management Studio,SQL Server Business Intelligence Developmen t Studio

Operating Systems Windows server20 03, Windows2000 advanced server

Languages: T - SQL, C #, PL- SQL

Database Tools: MS SQL Server, MS Access

BI Tools: SQL Server Integration Services (SSIS ), SQL Server Analysis Services (SSAS ), SQL Server Reporting Services (SSRS ),Data Transformation Services( DTS) .

Reporting Tool: SQL Server Reporting Services ( SSRS ), Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Sr. SQL Developer

Responsibilities:

  • Involved in Design, Development and Testing of Conversions, Interfaces, Workflow and Reports.
  • Work closely with business users to congregate and comprehend requirements.
  • Preparation of documentation for all the requirements and enhancements to reports.
  • Involve in complete Software Development Lifecycle (SDLC).
  • Analyze user requirements, functional and technical specifications, preparing test plans and write test cases.
  • Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.
  • Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.
  • Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
  • Used complex expressions to Calculate, Group, Filter, and parameterized and Format the contents of the report according to the requirement.
  • Stored procedures to retrieve data from the SQL Server using appropriate SQL language (T-SQL) to provide optimal performance.

Environment: SQL Developer, Microsoft Office, T-SQL, SSIS, SSAS, SSRS.MS SQL Server Management Studio 2008

Confidential, Herndon, VA

Sr. SQL Developer

Responsibilities:

  • Design & Develop ETL packages at different Stages (Acquire, Stage, ODS).
  • Contribution in the Design & Development of Audit Balance control frame for ETL.
  • Design & Develop Error handling & Email notification components.
  • Involved in Enhancements and Fixing Issues.
  • Identifying detailed analysis of data sources.
  • Preparing data mapping document from source to target.
  • Involved in preparing business transformation rules that should be applied to source data.
  • Designed Data Migration Logic between source and Target Systems.
  • Identifying data issues with data in the source systems.
  • Loading data from the various data sources like Flat files, CSV's, SQL Server and MySQL etc.
  • Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, data conversion and Execute SQL Task to load data into Database.
  • Performance tuning of SSIS packages.
  • Implementing new functionality in the existing ETL packages.
  • Monitoring the jobs and providing production support.
  • Communicate effectively to management, business and technical roles to meet the deliverables and schedule
  • Created Functional and Technical Specification document.

Environment: Windows 2008 R2, SQL Server 2008 R2, SSIS, SSAS, SSRS.

Confidential, NY

Sr. SQL Developer

Responsibilities:

  • Gathered the requirements from Business Users and passed on the requirements to the team.
  • Created custom SQL procedures to read data from flat files to dump to database using SQL * Loader.
  • Installation and configuration of SQL Server 2012.
  • Took over the designing of newer data warehouse and produced data models using Erwin. Considered different ways of approaching the designing of database and documented all the possible ways before building the data warehouse.
  • Discussed and documented the building of data warehouse at every step.
  • Exported the existing data from a legacy database to a newer database.
  • Optimized the existing stored procedures and automated them for various tasks.
  • Created new Database objects like Tables, Views, indexes and functions.
  • Developed a new set of complex stored procedures for newer business requirements.
  • Imported data from various sources like Excel, Access.
  • Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
  • Used SQL Server Profiler to trace the slow running queries and the server activity.
  • Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
  • Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
  • Participated in disaster prevention and recovery strategies.

Environment: SQL Server 2000, Windows 2000/NT, UNIX, Excel, MS Access, T-SQL

Confidential, Ashburn, VA

SQL Developer

Responsibilities:

  • Installation and configuration of SQL Server.
  • Analyzed the business requirements and building logical and physical data models.
  • Developed new stored procedures and optimize existing ones.
  • Developed template scripts for users so they can generate their own daily/weekly/monthly reports.
  • Developed and implemented stored procedures and triggers for automation tasks.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
  • Modify the existing SSIS packages to reflect the new business requirements.
  • Developed packages to create Error Fallout Reports, send Business and IT mails.
  • Created connection strings using various external drivers like Relativity Drivers or CONNX Drivers.
  • Apply various transformations like Slowly Changing Dimension (SCD), Multicasting, Union, Derived Column and Data Conversion.
  • Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
  • Used various advanced SSIS functionalities like complex joins, conditional splitting for better performance during package execution.
  • Developed Unit test plans for SSIS packages.
  • Performed ETL operations to support incremental, historical data loads and transformations using SSIS.

Environment: SQL Developer, Microsoft Office, T-SQL, SSIS, SSAS, SSRS. MS SQL Server Management Studio 2008

Confidential, San Diego, CA

SQL Developer

Responsibilities:

  • Extracted data from different sources like flat files and loaded into data warehouse according to the specifications.
  • Created new tables by pulling data from different sources
  • Wrote T-SQL queries like Joins, DML, DDL, Case statements.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
  • Data sources, targets were SQL Server, Excel, Flat files.
  • Used merge, union, union all, derived column, conditional split, Sort, Slowly changing dimension
  • Supported data extraction from legacy systems into flat files for loading into Policy Center database.
  • Developed Stored Procedures in SQL for extracting and performing data transformations on the legacy data and load into the Policy center database.
  • Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
  • Responsible for Migrate Data from multiple sources like flat file and Excel to Single SQL Server table.
  • Leveraged dynamic SQL for improving the performance, and efficiency.

Environment: SQL Developer, Microsoft Office, T-SQL, SSIS, SSAS, SSRS. MS SQL Server Management Studio 2008.

Confidential

SQL Developer

Responsibilities:

  • Involved in designing of conceptual logical model and physical model.
  • Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server.
  • Maintained security by creating users and giving appropriate permissions to users.
  • Scheduled the backups for databases and transaction log. Performed restoration operations. Suggested backup strategies.
  • Developed database triggers to enforce data integrity and additional referential integrity.
  • Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
  • Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
  • Used SQL profiler and query analyzer to optimize DTS package queries and stored procedures.
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
  • Involved in performance tuning using indexing (cluster index, non-cluster index) tables.
  • Responsible for cleansing up database for maintenance of the database.

Environment: SQL Server 2000, T-SQL, Tableau.

Hire Now