We provide IT Staff Augmentation Services!

Lead Service Engineer / Sql Developer Resume

4.00/5 (Submit Your Rating)

Redmond, WA

SUMMARY

  • More than 12+ years of IT Industry designing and supporting SQL Server databases
  • Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.
  • Experience writing complex SQL Queries and Procedures.
  • Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
  • MS SQL Developer. Excellent hands on Experience in Database Designing. Excellent Database programming skills in Oracle and SQL Server and Data Modeling and Database design skills using E - R Model. Created and Deployed SSRS Reports in BIDS.
  • Excellent hands on Experience in Database optimize, and maintain all databases, tables, stored procedures, indexes, triggers, data extraction, transformation, and validation as well as other processes as required.
  • Created Stored Procedures, Triggers, and Functions, Indexes, Views, Joins and T-SQL code for applications.
  • Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
  • Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
  • Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
  • Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
  • Scheduled and executed SSIS Packages using SQL Server Agent.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Develop DTS script to migrate data from SQL*Server database to Oracle database.
  • Develop Procedure and Function using SQL*Server database to migrate data to Oracle database.
  • Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity
  • Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.
  • Created Power BI reports for ad-hoc reporting and analysis.

TECHNICAL SKILLS

SDLC Models: Agile Development (SCRUM), Water Fall, Iterative Model

Databases: MS SQL Server 2005/2008/2012/2014 , Toad, Oracle, MS-Access.

Version Control: Subversion(SVN)

Language: T-SQL, PL/SQL

Reporting Tools: Report Viewer, SSRS, Power BI

Agile Management Tools: Rally Dev (CA Agile tool)

Operating System: Windows Server, Windows 2000 Professional, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Redmond WA

Lead Service Engineer / SQL Developer

Responsibilities:

  • Gathered requirements from the business users and defined and elaborated the requirements by holding meetings with the users.
  • Involved in defining the source to target data mappings, business rules, business and data definitions according to the software development life cycle.
  • Created SQL Stored Procedure to create new Audit by using their established Audit framework and scheduled them to send email on daily bases.
  • Created test cases and SQL queries to validate the data for new Build items
  • Created Multiple Power BI reports for Production and UAT environment Confidential RSD, DSM, YoY level and published them in Power BI services dashboard.
  • Created and configured data gateway in Power BI services to refresh dashboard on daily bases.
  • Created validation scripts using T-SQL to validate data between warehouse server and factory servers after Bug deployment.
  • Wrote the test cases and technical requirements and got them electronically signed off. While also performing small enhancements (data cleansing/data quality) to ensure the testing is through.
  • Coordinated (with business users, DBAs and testing team) in mirroring production testing.
  • Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
  • Regular connects with Business, Engineering & Support relating to Pending, Ongoing & Future releases that includes bug fixes & feature releases as part of Daily Triage, Scrum, and Sprint Iterations.
  • Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
  • Created new reports based on requirements and document various Data Quality mapping document.
  • Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
  • Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.
  • Involved in providing KB articles to help improve the operations standards for troubleshooting.
  • Provided 24/7 in SQL production support, problem management support to the development team.

Confidential, Alpharetta GA

Lead SQL Server Developer

Responsibilities:

  • Lead a team of report developers; taught them how to write optimized SQL to have the report created
  • Supported three separate departments by dealing directly with them as customers, collecting Report specifications and then designing and developing the reports, using SSRS, TSQL and SSIS.
  • Planned, designed and implemented application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
  • Optimize existing T-SQL code.
  • Analyzed Execution Plans to troubleshoot potential performance issues.
  • Implemented performance tuning by implementing suitable optimizations and appropriate indexes and keys
  • Used System monitor, event log viewer, SQL profiler, SQL analyzer to monitor and tune the performance of SQL server.
  • Excellent hands on Experience in Database Designing. Excellent Database programming skills in Oracle and SQL Server and Data Modeling and Database design skills using E-R Model.
  • Excellent hands on Experience in Database optimize, and maintain all databases, tables, stored procedures, indexes, triggers, data extraction, transformation, and validation as well as other processes as required. Scheduled jobs, created alerts, notifications with SQL agent and configuring Linked servers for data access between new and old servers.
  • Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer.
  • Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
  • Tune existing store procedures by putting indexes, and improving complex queries performance by using better logic with less reads and CPU usage.
  • Supported SQL clustered environments that is Active-Active nodes & maintained which supported several applications
  • Troubleshot database-related issues for clients during implementation, maintenance, upgrade, and migration processes.
  • Providing on-call support for production systems with rotation basis.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Supported all production operation activities, with focus on integration and development of new and existing products and services.
  • Identified data issues and provided recommendations for resolution to ensure optimal performance.

Confidential, Hoffman, IL

Lead SQL Server Developer

Responsibilities:

  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Supported all production operation activities, with focus on integration and development of new and existing products and services.
  • Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading. Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer.
  • Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
  • Tune existing store procedures by putting indexes, and improving complex queries performance by using better logic with less reads and CPU usage.
  • Created Stored Procedures, Triggers, and Functions, Indexes, Views, Joins and T-SQL code for applications.
  • Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
  • Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.

Confidential, Alpharetta GA

SQL Server Developer

Responsibilities:

  • Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications
  • Supported applications, revising, updating, creating and improving stored procedures, problem solving and providing documentation as required, including root cause analysis.
  • Worked with internal and external clients for import and normalization of third-party data.
  • Documented and maintained database system specifications, diagrams, and connectivity charts.
  • Monitored and provided front-line support of daily processes.
  • Made effective and much appreciated suggestions for changes in the system applications, and gave expert advice as to proper operation.
  • Created and executed SQL statements in both SQL production and development environments.
  • Provided SQL Support to front end users and resolved user tickets
  • Resolved issues within production database using T-SQL queries.
  • Created SQL instances and databases as needed.
  • Executed daily batch processes, and researched file share for a duplication project.
  • Utilized SSIS to manage and create ETLs to transfer data from various sources.
  • Helped create process logging and new monitoring tools, integrity reports, and mapping tools.

Confidential, Richardson TX

SQL Developer

Responsibilities:

  • Created Clustered and Non Clustered Indexes on tables, views, and columns.
  • Planned, designed and implemented application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
  • Implemented performance tuning by implementing suitable optimizations and appropriate indexes and keys.
  • Configured Server for sending automatic mails to the respective people when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit.
  • Used System monitor, event log viewer, SQL profiler, SQL analyzer to monitor and tune the performance of SQL server
  • Designed complex packages for ETL to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, OLE DB, Excel and Access to SQL Server 2005/2008.
  • Provided on-call support for production systems with rotation basis.

We'd love your feedback!