We provide IT Staff Augmentation Services!

Application Developer / Sql Resume

3.00/5 (Submit Your Rating)

Paramus, NJ

SUMMARY

  • Around 9 years of diverse experience in Information Technology with emphasis in Database Development, Quality Assurance, Requirement Gathering and Process Improvement.
  • Expertise in the development, implementation and maintenance of SQL Server 2019/2017/2016/2014/2012/2008 R2/2005 including the MS SQL Server suite of products like SSIS, SSRS.
  • Expertise in writing Stored Procedures, T - SQL queries, Functions, Views and Triggers for SQL server databases.
  • Expertise in designing the database for the various applications and analyzing the performance issues that may be needed for future enhancement and maintenance of the products.
  • Proficient in Database performance optimization, debugging and tuning using the SQL Server Profiler, Database Engine Tuning Advisor and Query Execution Plan.
  • Highly proficient in all aspects of database implementation including development, normalization, de-normalization and performance tuning.
  • Experience in creation of Extract, Transform and Load (ETL) processes for large-scale Data Warehouses.
  • Expertise in creation of complex SSIS packages that utilize script components, loops, expressions, variables, constraints, error handling, logging and transformations like data conversion, conditional split, sort and merge join.
  • Developed SSIS packages for loading data into CRM of Microsoft Dynamics 365 by using KingswaySoft SSIS Integration Toolkit.
  • Highly proficient in Migrating Data from heterogeneous and legacy systems to SQL Server using Microsoft SSIS 2012/2008 R2.
  • Created various Reports like Ad-Hoc Reports, Sub-reports, Drill-down reports, Drill-through reports, Chart reports, Summary reports and Parameterized reports in SSRS.
  • Experience in implementing CDC (Change Data Capture).
  • Experience in Backup and Restore databases.
  • Experience in Log Shipping and Replication.
  • Experience in working with Kentico (CMS).
  • Experience in working with Healthcare systems like Meditech and Athena.
  • Experience in creating API Integration using Informatica.
  • Worked in Agile environment, following Agile principles for software development.
  • Adaptable to new technology and self-learner to evaluate upcoming technology for implementing robust solution.
  • Experience in requirement analysis, coding and testing database modules in a Software Development Life Cycle (SDLC).
  • Experience in documenting the gathered knowledge and conducting knowledge transfer sessions.
  • Experience in working with analysts, designers, managers, developers and testers for complex projects in Agile environment.

TECHNICAL SKILLS

.Net Technologies: ASP.Net, C#

Databases: SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2 and 2005

MS SQL Tools: SSIS (ETL), SSRS

Web Technologies: HTML, CSS

Configuration Management Tools: Sub Version (TortoiseSVN), Team Foundation Server (TFS)

Software Tools: Firebug, Http Watch IE Debugger, Chrome’s Developer Tools

Operating Systems: Windows 10, Windows 8, Windows 7, Vista, Windows XP

PROFESSIONAL EXPERIENCE

Confidential, Paramus, NJ

Application Developer / SQL

Responsibilities:

  • Worked with creation and management of several databases some of these databases fetched data from around 10 thousand tables.
  • On a day-to-day basis dealt with creating Tables, Stored Procedures, Indexes, User Defined Functions, CTEs, Views in SQL Server.
  • Created Stored Procedure to find out all the tables and column references which resides across different databases in all the stored procedures, views and functions in the given database.
  • Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Server Profiler, Execution Plan and Database Engine Tuning Advisor (DTA).
  • Implemented CDC (Change Data Capture) on number of tables in the database to keep the history of the data in those tables.
  • Implemented ETL by creating SSIS packages for loading csv file into the Data Warehouse with 150 tables.
  • Developed SSIS packages for loading data on daily basis into CRM of Microsoft Dynamics 365 by using KingswaySoft SSIS Integration Toolkit.
  • Developed several reports using SQL Server Reporting Services (SSRS) and utilized complex SQL queries and stored procedures.
  • Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS.
  • As per user requests created subscriptions in SSRS report that would allow sending the reports on scheduled basis.
  • Utilized Dynamic Subscription feature of SSRS 2019.
  • Created VMarts out of data warehouse with thousands of tables with millions of records so that these can be used by Analytics Team and in the reports.
  • Lead the project and created new Intranet home page and several other pages in Kentico CMS for the company.
  • Working as one of the leads for converting ASP/HTML based Intranet pages into Kentico CMS.
  • Worked on automation with SQL Server Agent to schedule jobs that would run stored procedure on scheduled basis.
  • Created various jobs in VisualCron job scheduler that would allow following tasks to be done in automated manner; Create table in the database from excel file; SFTP files from company’s server to Vendor’s server; Check the file existence in specific folder; Execute the SSRS report and save as PDF and copy it to another computer on the network; Execute Stored Procedure and generate a file.
  • Implemented sending out emails from automated jobs to notify respective groups about job failures, success and completion.
  • Configured SQL Server to work with SMTP server for sending out emails about job statuses.
  • Lead the migration of Intranet from old server to new server.
  • Experience in creating API Integration using Informatica.
  • Experience in working with Healthcare systems like Meditech and Athena.
  • Appreciated for hard work, dedication, quick turnaround in implementation in several areas of different systems.
  • Received company awards and appreciations from customers and upper management who used implemented features on day to day basis.

Environment: SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, Content Management Tool, VisualCron.

Confidential, Berkeley Heights, NJ

Database Developer

Responsibilities:

  • Written a number of SQL Stored Procedures, T-SQL queries, User Defined Functions, CTEs and Views required for new features or maintaining the applications.
  • Designed new Database and tables in SQL Server based on the requirement.
  • Extensively used Joins and Sub-Queries for complex queries involving multiple tables from different databases.
  • Written complex T-SQL queries to manipulate data in the database.
  • Optimized SQL Server performance by using SQL Server Profiler.
  • Used Database Engine Tuning Advisor (DTA) for SQL Server performance Tuning.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Created SSIS package to perform ETL for Data Migration to transfer data from legacy tables to the tables in new application during the first promotion of the new application.
  • Created one-way and two-way Triggers in SQL Server to keep two sets of tables in sync.
  • Created SSIS packages for copying data from one application database to another application database which would run on a weekly basis.
  • 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.
  • Deployed SSIS packages and scheduled them in SQL Server Agent, also maintained the jobs running on Servers.
  • Developed complex reports in SSRS like tabular and matrix form, leveled and grouped, summary functionality in main reports providing detailed drill down through on demand sub-reports, charts.
  • 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).
  • Validated and tested reports, then deployed the reports to the Report Server.
  • Implemented Log Shipping for Database Backup and Restore.
  • Monitored the performance of the database and checked on the execution time.
  • Involved in Production Support.
  • Used Subversion (SVN) for central repository.
  • Worked closely with business to resolve a number of critical maintenance tasks and took the ownership to solve them independently.
  • Followed Agile practices during development and worked as a team player to meet Sprint goals.

Environment: SQL Server 2012, SQL Server 2008 R2, C#, Subversion (SVN), Visual Studio 2013, Visual Studio 2012.

Confidential

Software Developer

Responsibilities:

  • Worked in a team-oriented environment following Agile methodology and functioned as a technical resource.
  • Worked with business analyst in finding out exact requirements and was also involved in Design and Analysis sessions.
  • Designed Web Pages using HTML and wherever required use JavaScript for client-side validations.
  • Developed Master pages and Nested Master pages in Asp.Net, which are used in the application to maintain consistency.
  • Modified a module of the website to show SEO friendly URLs using URL rewriting in Http Modules.
  • Used Asp.Net C# controls such as GridView, Repeater and DataList.
  • Used ADO.NET objects such as Data Adapter, Data Reader and Data Set for data retrieval and manipulation.
  • Used CSS for achieving uniformity through all the web pages.
  • Involved in writing Queries, Stored Procedure and Views in SQL Server.
  • Designed the Database Tables for maintaining Product details and Jewelers Information.
  • Learnt different aspects of ECommerce during the project.
  • Resolved issues found by QA and provided quick solutions as per requirements.

Environment: ASP.NET 3.5, C#, Visual Studio 2008, SQL Server 2005, Windows 7, Windows XP, Windows server 2003.

We'd love your feedback!