Application Developer / Sql Resume
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.