SUMMARY:

• 5 years 6 months of IT experience, which includes analysis, design, development, and implementation of applications, reports and databases (MS SQL Server 2017/2014/ 2012/2008/2005/2000 ) in production environments.
• Background in diverse facets of T - SQL in constructing triggers, tables, user functions, views, user profiles, SQL joins and query writing.
• Well-versed in database concepts and developing stored procedures and triggers.
• Involved in Huge data migrations, DTS to SSIS and MS access migrations.
• Experience in BI Development and Deployment of SSIS packages from asp.net.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Have worked on .NET development, encompassing analysis, design, development, and production support of business applications.
• Built SSIS packages to extract, transform and load data to data warehouse.
• Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development and Implementation.
• Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS) and MDX for data warehouse and data mart solutions.
• Experience in creating and developing Power BI Dashboards
• Experience in creating packages to extract data from Excel, Flat file, Oracle, DB2, Sybase to MS SQL Server by using MS SQL Server DTS and SSIS.
• Experience in data Migration between different heterogeneous systems and SQL Server as part of data migration and data maintenance.
• Experience in Jobs, Sending Alerts using SQL eMail.
• Experience in creating simple and parameterized SQL Reports using SQL Server Reporting Services (SSRS).
• Strong in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, Triggers, User Defined Functions, Views, DDL/DML, T-SQL Scripts and Batches.
• Experience in SSRS with Report authoring, Report management, Report Delivery and Report Security.
• Experience in defining query for generating drill down reports in SSRS 2005/2008.
• Working knowledge in configuration and version management using Visual Source Safe (VSS).
• Good understanding of technology with focus on delivering business solutions.
• Comprehensive problem solving abilities, Interpersonal Skills and Leadership Qualities.
• Good Experience in Technical support and maintenance of the applications delivered to the client.
• Excellent communication skills and have experience in working directly with client to identify business objectives and establish requirements.
• Task oriented and consistent in finishing work as per deadlines.

TECHNICAL SKILLS:

Operating Systems: Windows 2003 / NT / XP/ME/9.X

Languages: C, C++, C#, T-SQL, VB.NET, Java

Web Technologies: HTML, JSP, WML, XML

Databases: MS SQL SERVER 20 / 7.0, MySQL, MS Access 2003, Azure SQL DB

Packages: MS Office 2005, MS Visio, ERWIN, MATLAB

Testing: Win Runner, Load Runner

ETL tools: DTS, SSIS, SSAS, SSRS, Web Focus

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Query AnalyzerIndex Analyzer, SQL Agents, Data Stage, SQL Alerts, PowerBIData warehouse lifecycle, SQL Mail, SQL Client Configuration utility, Backup Server, data stage technology concepts, Tableau Replication server, OLAP Services, Replication Tool

PROFESSIONAL EXPERIENCE:

Confidential - Florham Park, NJ

SQL Server Developer

Responsibilities:

• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Actively participated in migrating SQL Server R2 as part of converting legacy application Case Trakker Enterprise to Case Trakker Dynamo.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Developed SQL scripts to Insert/Update and Delete data in MS-SQL database.
• Used Exceptional Handling and log in SSIS to handle errors and track the package execution.
• Configure SSIS Package for run time Parameters and Config file.
• Worked on ACCDS tool to track the production tickets.
• Handled data marts of heavy sizes efficiently and provided documentation for maintenance.
• Intensively involved in Prod Support.
• Scheduled the SQL jobs and SSIS Packages using Job Controller (Enterprise Scheduler).
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Used Try Catch Finally exception handling extensively to avoid circumstances leading to abnormal program termination.
• Maintained error logs for the Stored Procedures.
• Used Team Foundation Server and Visual Source Safe as a version control tool.
• Involved in designing the databases and also participated in disaster recovery plan.
• Development of .NET batch applications which process high volume of data.
• Consuming and Developing Windows Communication Foundation Services (WCF).
• Followed PHI security policies as per HIPPA compliance and implemented the TDE (Transparent Data Encapsulation) at very granular level.
• Generated reports and masked the sensitive data as per the IEHP policies.
• Followed industry standard naming convention for database objects and documented them very efficiently.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution Plan.
• Transferring the data from SQL server 2000 to SQL Server 2008 using SSIS.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012/2008/2005/2000, Visual Studio 2010/2015, TFS, VSS, Reporting Services (SSRS), Integration Services (SSIS), DTS, SQL Profiler, SharePoint, T-SQL, .Net, Excel, CaseTrakker Enterprise, CaseTrakker Dynamo.

Confidential - McLean, VA

SQL Server BI Developer

Responsibilities:

• Participated in gathering requirements and discuss details with team lead.
• Analysed the source data and figured out correct data mapping to staging tables, data warehouse and data marts.
• Created Tables, Views, Indexes, Stored Procedure and Triggers.
• Used multiple join statements to retrieve data and update the tables.
• Design and develop T-SQL procedures, query performance tuning and SSIS packages.
• Created functions to provide custom functionality as per the requirements.
• Used SSIS to implement slowly changing transformation to maintain historical data in data warehouse.
• Implementing full load and incremental load logic to load data warehouse based on the size of the source data.
• Used various SSIS transformations such as conditional split, look-up table and derived column for data scrubbing and data validation during staging, before loading the data into data warehouse and implement proper auditing for the ETL process.
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Created summary reports, sub reports, Drill Through and Drill-down reports using SSRS.
• Deployed SSRS reports in to SharePoint portal and Report Manager.
• Utilized Microsoft team foundation server and its features for code sharing and updates from other members.
• Good experience using SSIS script task to create complex transformation logic using C#.net
• Debug through C#.Net code to troubleshot production issues & crated untested methods for validation of codes develop.

Environment: SQL Server 2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, ProClarity, SSAS, SharePoint services, Erwin

Confidential

SQL Server Developer

Responsibilities:

• Gathered the requirements by discussing with users and team members.
• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Transformed logical data models into physical database structures and defined the appropriate constraints and indexes as per the requirement of data retrieval and modification.
• Involved in Normalization and De-Normalization of database.
• Optimized the performance of queries with modification in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Involved in writing SQL batch scripts.
• Planned Backup strategy based on projects requirements.
• Created Various DTS Packages to Extract/Transform/Load source data into SQL Server in a highly efficient way from Sources like Excel, ORACLE, SQL 2000 and MS Access.
• Automated the DTS/ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa.

Environment: SQL Server 2000, T-SQL, DTS, MS-Excel, Windows 2000/2003, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler.

Confidential

SQL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Actively participated in gathering of Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2008/2005, T-SQL, .Net, Microsoft Framework 2.0, Erwin, MS Visio.