SUMMARY:

• Over 8 years of IT Professional experience with strong background in SQL server Development, Client Analysis, Database, Design and Presentation using Microsoft SQL Server 2012/2008/2005/2000. Experience in various industries includes Insurance, Mortgage or Loan Servicing, Telecommunication and Internet Service Provider (ISP).
• Expertise in MS SQL Server 2014/2012/2008/2005/2000 in Development, QA, Production environments.
• Highly proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, User Profiles, Relational Database Models and Data Integrity, Complex SQL Joins, Cursors and Query writing.
• Very good understanding and working Knowledge in cloud technology and big data, specifically Azure data lake analytics, azure data lake store and Azure Database, Azure Data warehouse, data factory etc.
• Extensive experience in writing U-SQL code for data transformation, Partitioning in Azure Data lake store and managing indexes in tables.
• Experience in Creating and Managing Clustered and Non-Clustered Indexes to improve database performance and availability.
• Extensive experience in creating and managing the SSIS/DTS for Extracting and Transforming from SQL Server, Oracle, DB2, Excel Sheet, XML and flat files.
• Experience on Trouble Shooting Database Issues and monitor SQL server stat using DBCC and DMV (Dynamic Management Views).
• Experienced on using the TFS (Team Foundation Server) for Version Controlling and Bug/Task/User Stories Tracking.
• Experience in monitoring system and database using System Monitor, SQL Profiler and Resolving Blocking and Deadlock Issues.
• Experience in Deploying and Configuring Packages, Error Handling and Batch Logging Checkpoints and Trouble Shoot the SSIS packages.
• Experience in creating Jobs, Alerts and scheduling SSIS Packages using SQL Server Agent.
• Experience working with Production (24\7) environment.
• Experience in creating, deploying and scheduling the reports using SSRS.
• Experience in working with SQL third party tools like Idera for managing virtual/Real databases (backup and restore) and SQL Sentry for monitoring the SQL server activity and performance optimization.
• Knowledge in database administration and maintenance activities such as Backup and Recovery, Monitoring SQL Server, Replication, Log shipping, managing and creating SQL server Agent jobs.
• Experience working with Business Stake Holders, Clients, Business Analyst, Database Analyst, Application Developer and Production Team to gather the requirements/issues and discuss the possible solutions and translate it into the conceptual design and physical data model and the code.
• Excellent knowledge in Software Development Life Cycle (SDLC), Agile and other project Methodologies.
• Excellent work Ethics, Fast Learner, adapts well to changes on workplace, Team Oriented, Positive Attitude and Excellent Communication and Presentation Skills.
• Extensive knowledge and trained in azure data warehouse, data lake, Power BI, machine learning and data factory, USQL.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, U-SQL, Script, USQL, C++, Java, XML, HTML, JavaScript,C#,.NET

RDBMS: SQL Server 2014/2012/2008/2005/2000, Oracle 9i/10g/11g

Database Tools: SQL Profiler, Query analyzer,DTS, SSIS, SSRS, SSAS, Business Objects, SQL Lites, ERWin, TFS, SQL Sentry, Idera

Operating System & Software: Windows VISTA/XP/2003, Windows server 2008/2003/2000/ NT, UNIX, Office

Oriented Design and Analysis: Unified Modeling languages - UML, ER modeling

Web Technology: IIS, Apache Server, HTML, XML, VBScript, JavaScript

PROFESSIONAL EXPEREINCES:

Confidential

Team Lead / Database Developer/Azure(USQL) Developer

Responsibilities:

• Gather requirements; analyze feasibility of needs by coordinating with business stake holders, SME and application/database Architect.
• Worked closely with architecture to design and building data lake and data warehouse and load them as designed.
• Responsible for design and develop objects (Tables, views, stored procs, TVFs) in Azure Data Lake.
• Worked on complex U-SQL for the data transformation and loading table and report generation.
• Implemented the create table as select (CTAS) to load/update the azure data warehouse for optimization.
• Create, schedule and manage the ETL process or migrate the data from non-cloud to cloud with Azure Data Factory.
• Plan, design and develop the database and database objects based on requirement provided by business.
• Worked closely with architect, designing the data warehouse with star schema and designing fact and dimension tables.
• Responsible for making appropriate decision related to data collection, data analysis, data security, methodologies and designs.
• Extract the data from different sources such as SQL Server, MySQL, MS Access, Flat File, XML and loaded data in target, by scheduling the session.
• Created SSIS packages to extract data from different sources using Fuzzy lookup, Derived Columns, Conditional split, Execute SQL Task, Dataflow Tasks, Execute Package Tasks to generate the underlying reports.
• Develop the cleaning rule for the source data, validating them and ensure the quality of the data on the destination.
• Convert the complex business process into the database codes using the complex stored procedures, user defined function, triggers and views and database constraints to support the report and applications.
• Responsible of performance tuning for the long run query which includes finding the bottleneck and evaluating the execution plan, rewriting the query and creating the clustered on non-clustered index as needed.
• Supporting daily loads and work with business users to handle rejected data.
• Worked on Agile methodologies and used the TFS for User Story/Task and hours tracking and for source controlling.
• Responsible for production support, debug the code and come up with appropriate solution to solve the existing production issue.
• Responsible for the creating/scheduling jobs and alerts and monitor SSIS package using SQL server Agent.

Environment: MS SQL server 2005/20, Windows 2003/2008 server standard/Enterprise Edition, Azure data warehouse, data lake, SSIS, SSRS, HTML, IIS 7.0, TFS, Visual Studio 2005/20, Redgate, SQL Prompt.

Confidential

Sr. SQL Developer

Responsibilities:

• Plan, design and develop the application database code objects such as stored procedures views and user-defined functions.
• Responsible for the performance tuning of the database codes which includes finding of the long running query in the large stored producers and optimize them by adding the clustered or non-clustered indexes, re-writing/redesign of the query, finding the bottlenecks, provide suggestions, code review etc.
• Production supports which, includes of providing the immediate resolution for the issues, debug the code to find the root cause and fix the code to avoid such problem in future.
• Translate the complex business logic into database codes using the complex stored procedures, user-defined functions, and triggers.
• Analyze and compare the data using the ad hoc queries and provide the reports/explanation to the end user as requested.
• Worked with several control flow tasks, dataflow tasks, transformations (such as derived column, lookup, merge join, conditional split, data conversions etc.) and event handler to create SSIS packages.
• Involved in deployment of SSIS packages in different environment DEV, UAT and Production and configure the configuration file/data for the package.
• Create, maintain, deploy, and schedule dynamic/static SSRS reports as per the users requirements.
• Work with business stakeholders, application developers, and business analyst, production DBA to identify the issues and discuss the possible solutions.
• Worked on TFS (Team Foundation Server) for the version controlling and keep track of task and user story.
• Worked on SQL Server third party tools like Idera for managing the virtual databases(backup and restore of databases) and SQL Sentry for monitoring the SQL server activity and performance optimization.
• Responsible for creating the jobs alerts and scheduling and monitoring the SSIS package using the SQL server agent.
• Responsible for the unit testing, regression testing and performance testing of database objects.
• Responsible for validating the data, quality check, data enhancements for the inbound data coming from different source in a different form before loading them into the database
• Worked as an on-call person on the rotation basis and was responsible for monitoring the jobs during off hours, resolve any issues or re-route the issues to the appropriate person/team.

Environment: MS SQL server 2005/2008, Windows 2003/2008 server standard/Enterprise Edition, SSIS, SSRS, HTML, IIS 7.0, TFS, Visual Studio 2005/20, IDERA, SQL Sentry.

Confidential

Sr. SQL Server Developer

Responsibilities:

• Gather end user requirement and translate them into the database code using the stored procedures, triggers view and functions.
• Solid Experience translating business requirements into conceptual, logical and physical data models.
• Data requirement Analysis, Data Modeling and Data Architecture for Several projects.
• Responsible for performance tuning of the databases, running database-tuning advisor, updating statistics, fragmentation and troubleshooting application issues
• Create clustered and non-clustered index, manage locks, analyze query to improve the performance of the query.
• Create database objects such as table, views, stored procedures, DDL/DML triggers, logins and more using T-SQL script.
• Design standards for using normalized data structures, de-normalized structures and dimensional structures. Define common design patterns for modeling various types of relationship.
• Loaded data from source to staging tables and then to the target tables after performing pre-validation, quality checks, clean ups and enhancement on the staging tables.
• Work with business stakeholders, Business Analyst, data analyst, application developers, and production teams and across functional to identify the needs and discuss solution options.
• Perform data migration from Excel, flat file and other data source using ETL tool such as SSIS, import/export wizard and BCP command.
• Created and managed the SSIS packages to extract, transform and load the data from different source like DB2, Excel, Flat files, MS Access.
• Wrote complex SSIS package using the several task including Scripts task to perform the complex process using the .NET and C# codes.
• Responsible for fine-tuning of the database, troubleshooting, user administration, memory management and running DBCC commands.
• Enhanced performance using optimization techniques: normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Involved in complete life cycle of database, which includes designing of database, populating look up data, creating stored procedure, as per front end requirement and commercial transitions, writing triggers, creating user defined functions and created views to simplify the complexity of the data structure
• Setting up database backup and recovery procedure for QA and development servers.
• Wrote complex Stored Procedures and functions using CTE, Pivot and UnPivot, dynamic SQL complex joins.
• Testing of application for performance, data integrity and validation issues.
• Created Users and Roles and managed security and permission of database.
• Worked on both SDLC and Agile project methodology.
• Provide 24/7 supports for the development/production issues/solution.

Environment: MS SQL server 2005/2008/2012, Windows 2003/2008 server standard/Enterprise Edition, SSIS, SSRS, HTML, IIS 7.0, TFS, Visual Studio 2005/2008/2010, Congnos 10.1.

Confidential

Sr. SQL Server Developer

Responsibilities:

• Planned, designed, and implemented the processes to receive, transform and load valuable data from external sources into local databases.
• Support all production operations activities, with focus on integration and development of new and existing products and services.
• Responsible for performance tuning of the databases, running database-tuning advisor, updating statistics, fragmentation and troubleshooting application issues.
• Database normalization, query optimization and database consistency checks using DBCC utilities.
• Perform database integrity checks, update statistics and run database tuning advisor for improving performance.
• Creates objects such as table, views, stored procedures, DDL/DML triggers and more using T-SQL script.
• Perform data migration from excel and other flat file using ETL tool like SSIS and BCP command.
• Created and managed the SSIS packages to load the data from the flat files and move the file to archive folder with the appended dates on the file name after the completion of the loading process.
• Create, deploy and schedule the reports using SSRS to generate the daily, weekly and monthly reports.
• Analyze query plans, use extended stored procedures and manage indexes and locks.
• Transform business logic into database design and maintain it by using SQL tool such as stored procedures, user defined functions, views and triggers.
• Responsible for configuring replication methods like snapshot, transaction and merge replication.
• Developed standards for SQL server maintenance and updates.
• Involved in complete life cycle of database, which includes designing of database, populating look up data, creating store procedures, as per front end requirements and commercials transitions, writing triggers, creating user defined functions and created views to simplify the complexity of the data structure.
• Responsible for fine-tuning of the database, troubleshooting, user administration, memory management and running DBCC commands.
• Work with business stakeholders, Business Analyst, application developers, and production teams and across functional to indentify needs and discuss solution options.
• On call support 24/7 on production related problems.
• Configuring and maintaining windowns2003/2008, web/applications/database servers.

Environment: MS SQL server 2005/2008, Windows 2003/2008 server standard/Enterprise Edition, SSIS, SSRS, HTML, IIS 7.0, TFS, Visual Studio 2005/2008/2010