We provide IT Staff Augmentation Services!

Sql Developer Resume

NJ

SUMMARY

  • I have over 15 years of total experience and over 9 years experience working on MS SQL Server utilizing Transact-SQL (DDL, DML), Views, Stored Procedures, function and Triggers.
  • Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services SSIS.
  • Experience in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
  • Experience of RDBMS. Database design issues like Normalization and De-normalization.
  • Extensive experience in performance tuning, query optimization and statistics.
  • Involved in design, coding, testing, quality assurance and production support in most of the projects.
  • Translate the functional requirements into technical requirements and performing development tasks to complete solution.
  • Good understanding of End user req. analysis and full Software Development Life Cycle (SDLC) with QA Has worked with complete software development life cycle, analysis, design, development, testing and delivery (SDLC).

TECHNICAL SKILLS

Languages: T-SQL, PL / SQL, VB.Net, VB6, Power builder 7 & 6, Oracle forms, Cobol & Clipper

Database: MS SQL 2008/R 2 / 2008 / 2005 / 2000 , Oracle 9i & MS Access.

Server: Window 2003/ 2000 / NT & Novell Netware

Applications & Tools: Visual Studio .Net 2005/2008, VSS, Data Modeling, SSIS, SSRS, PowerPivot

PROFESSIONAL EXPERIENCE

Confidential

Role: SQL Developer / SSRS / SSIS

Environment: T-SQL/SSIS/SSRS 2005/2008 R2/2012

Responsibilities:

  • Write and troubleshoot SQL code/ SSRS Reports / SSIS Package
  • Convert Crystal Reports to SSRS Reports.
  • Performance tuning and Query optimization .
  • Refactoring existing SP’s, Views & Functions.

Confidentia

Working as Reporting Analyst / BI developer

Role: SQL Developer / SSRS / SSIS / PowerPivot

Environment: T-SQL/SSIS/SSRS 2005/2008 R2/2012

Responsibilities:

  • Write and troubleshoot SQL code/ SSRS Reports / SSIS Package /Code review
  • Design and create ETL processes using SSIS to import data from external sources and also retrieve data to be send to internal and external users
  • Performance tuning and Query optimization .
  • Refactoring existing SP’s, Views & Functions.
  • Understand BRD and create or modify the reports, AHQs or Dashboards.

Confidential

Role: SQL Developer / SSRS / SSIS

Environment: T-SQL/SSIS/SSRS 2008 R2

Responsibilities:

  • Write and troubleshoot SQL code and design (stored procedures, functions, tables, views, triggers, indexes, constraints etc.)
  • Design and create ETL processes using SSIS to import data from external sources and also retrieve data to be send to internal and external users
  • Data Migration from different data source and daily night batch processing.
  • Data cloning for test users.
  • Performance tuning and optimization of Stored Procedures.
  • Refactoring existing SP’s, Views & Functions.
  • Create Reports using SSRS as per the requirements.

Confidential

Role: Database Developer / ETL

Environment: MS SQL 2005/2008 R2, SSRS 2008 R2/2005, SSIS 2008 R2

Responsibilities:

  • Design and create ETL processes using SSIS to import data from external sources and also retrieve data to be send to internal and Data Warehouse.
  • Generate different Preload and Post load reports.
  • Generating Missing Valid values. Developed Complex quires, SPs, functions and Views.
  • Extraction, transformation and Loading of Data using SSIS Packages.
  • Processing, manipulating, cleansing data before migrating to development environment.
  • Generate QA data, Data forensic and load statistic.
  • Create various reports using SSRS like Auditing, QA/QC, statistics etc.

Confidential

Role: Database Developer / SSRS / SSIS

Environment: MS SQL 2005/2000, SSRS 2008/2005, SSIS 2005

Responsibilities:

  • Writing Optimized procedure, Function, View and Triggers.
  • Developed SPs, Views for SSRS to generate expected business reports for client.
  • Extraction, transformation and Loading of Data using SSIS Packages.
  • Data Staging from different data sources through SSIS and Linked Servers.
  • Processing, manipulating, cleansing data before migrating to production.
  • Sending data from staging to different production data sources.
  • Create Jobs and batch processing.

Confidential

Role: SQL Developer / BI Developer

Environment: VB6, VB.Net, MS SQL 2005/2000, SSRS 2008/2005, SSIS 2005, SSAS

Responsibilities:

  • Created the Stored procedure, Function, View and Triggers in Development stage.
  • Wrote Optimized stored procedure.
  • Used SSIS to migrate data from different sources to 2005.
  • Upgraded required stored procedures from SQL 2000 to SQL 2005 with ANSI compatible.
  • Extensively used the built-in services for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Extraction, transformation and Loading of Data using SSIS Packages.
  • Modified existing data warehouse with SP & cube.
  • Developed stored procedures & used SSRS to generate expected business reports for client.
  • Modification of existing front end applications developed in VB6 & VB.Net.

Confidential

Role: SQL Developer / Business Intelligence Developer

Environment: VB6, VB.Net, MS SQL 2005/2000, DB2/ AS400, SSRS 2008/2005, SSIS 2005

Responsibilities:

  • Team member in Database design team, actively involved in the database creation using the Normalization techniques.
  • Created the Stored procedure, Function, View and Triggers in Development stage.
  • Wrote Optimized stored procedure
  • Used SSIS to migrate data from SQL 2000 to 2005.
  • Extensively used the built-in services for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Developed accurate and efficient ETL processes based on business requirement.
  • Extraction, transformation and Loading of Data using DTS Packages.
  • Developed stored procedures & used SSRS to generate expected business reports for client.
  • Modified existing front end application developed in VB.Net.

Confidential

Role: SQL Developer / Report Developer

Environment: T-SQL, SSIS/DTS, ETL, MS SQL Server 2005 / 2000, VB.Net, .Net 2005, Financial Objects Applications, SSIS, SSRS, Business Intelligence Development Studio & Quality Center.

Responsibilities:

  • Worked extensively on T-SQL, Reports and Data loads for Shell Trading.
  • Did extensive modification of existing VB, VB.net application modules.
  • Responsible for writing stored procedures, Views and User defined functions for handling business logic and functionality of Energy Credit Applications.
  • Worked on analyzing and performance tuning on ad-hoc queries by looking at the Indexes, Appropriate joins and Execution plans using Query Analyzer, SQL joins, sub queries, usage of Table Variables etc.
  • Created and modified T-SQL ad-hoc quires for Reporting.
  • Did ETL Loads using SSIS/DTS packages from various data sources.
  • Gained business knowledge of Energy Trading.

Confidential

Role: Programmer Analyst /SQL DBA

Environment: Visual Studio.Net 2005, VB.Net 2005, WinForms, ASP .Net 2005 (Intermediate level), Clipper 5x, Crystal Reports, Visual Basic 6, Power builder 6 & 7. Databases: MS SQL 2000, Oracle 9I & PL SQL, MS Access, Oracle Form

Responsibilities:

  • Designed and developing applications for the requirement of an insurance company such as Insurance Quotation, Underwriting, Claims, Reinsurance, HR and Payroll for Administration.
  • Extensive use of Client/Server Programming with VB6, VB.Net, MS SQL Server 2000, and Oracle 9i with Forms and report with Crystal Report, Excel Spreadsheet and Lotus Spreadsheet
  • Maintained current business applications, systems and related procedures.
  • Developed application in Power Builder 6 for insurance claims.
  • Analyzed, design, coding, debugging, testing and problem solving of application programs.
  • Designed tables, defining entities and table relationships, developing triggers, stored procedures, and views, performance tuning queries, increasing DB response time and throughput.
  • Implementation of Network, Server configuration, Network Connection, User Creation, User rights, permission and password in Windows NT network.
  • Controlling the Data Backup in various format and different places.
  • Business Intelligence Report like Business Operation, Forecasting, Multidimensional Analysis etc.

Hire Now