SUMMARY

• 12 years of experience in the analysis, design, development, implementation, testing, and maintenance of database applications in SQL server 2016, 2012, 2008R2, 2005, & 2000, integration services (SSIS - ETL)& reporting services (SSRS) .
• Having good knowledge of performance tuning, query optimization by creating useful indexes and avoiding the expensive logical and physical operators. Used tools such as display estimated execution plan, Set Statistics Time On and other tools to analyze the execution plan and delayed queries
• Extensive Experience of writing new complex Stored Procedures, Functions, Types, Triggers & Views and having good knowledge of analyzing the business logic of existing SP’s, UDF’s, TRG’s and Views were updated with new implementation of business logic
• Experience in data modeling by using normalization techniques and building referential integrity constraints in OLTP database servers.
• Created SQL Server objects like tables, stored procedures, views, joins, set joins, indexes and functions using T-SQL Programming.
• Temporal tables and CDC tables configuration on different versions of sql server for change data capture.
• Created clustered indexes and non clustered indexes on the columns .Created indexes such as covering indexes, Columnstore indexes and filtered indexes.
• Created SSIS packages for data extraction ETL from diff. sources to diff. destinations like SQL server, Db2,Teradata,oracle,Excel, XML CSV and txt file.
• Good experience of using SSIS transformations like data conversion, derived column, lookup, merge join, merge, union all conditional split, OLEDB Command, aggregate, sort, multicast,rowcount,row sample, SCD etc. in SSIS packages.
• Having good knowledge of using variables and expressions in packages. Used variables in execute SQL task, script task, DFT, for each loop container, for loop container, logics for workflow such as expression and variables used in precedence constraints.
• Used to log all the events of executables using SSIS logging feature in SQL server table and log the package details also in the SQL table such as which is useful for error handling and auditing.
• Worked on conversion of DTS packages to DTSX.
• Extensively used reporting services to develop the tabular, matrix, gauge, dashboards, sub reports, parameterized reports, drill down & drill through SSRS reports as per the business requirements.
• Deployed SSRS reports and data sources from SQL server data Tools to SSRS reporting server.
• Single handedly deployed SQL server 2016 database to Azure database.
• Helped the team to create database project for CI\CD pipeline.
• Code maintenance in TFS and GIT repository.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Developer

Responsibilities:

• Attended the daily scrum calls to discuss about the each PBI business requirements, progress updates of the sprint.
• Created efficient Stored Procs, UDFs, and Views having complex queries to enforce the business rules to load the valid data in the destination tables.
• Redesigned the existing stored procs code by using merge statements, temp tables, table variables, CTE and exists clause to improve the performance of the stored procs.
• Incorporated the new business logic in the existing stored procs.
• Worked on the development of the database objects such as tables, constraints, indexes, views, table functions, scalar function and referential integrity as per the requirement and business rules.
• Have in depth knowledge about indexes clustered index, non clustered index, columnstore index, filtered, covering index.
• Extensively used queries such as merge statement, lead and lag functions, rank functions, sub query, joins, correlated subquery etc.
• Developed complex stored procedures having lot of business rules and logic, used dynamic query within the stored procedures .
• Debugged the existing stored procedures in QA/Prod environment and fixed the issues. Also did production support for fixing the issues related to stored procedures.
• Extensively used functions like date functions- datediff, dateadd, datepart,datename,string functions such as substring,charindex,len,ltrim,rtrim,left, IsNumer,Isdate null functions such as nullif,isnull,coalesce, row number,rank,dense Rank and many other functions and also developed many customized functions as per the data requirement.
• Migrated the existing database from sql server 2016 to the Azure database PAAS model.
• Database deployment included varbinary file blob import export templates to the Azure database using PowerShell script
• Actively supported and resolved production issues related to database objects for the modules such as email notification, data extract, Geo location, Utc timezone.
• Worked on the performance tuning of the stored proc by using many techniques such as display actual / estimate plans, avoiding expensive operators, checking the run time using set statistic time on and Statistic IO on, analyzing the lagging query, creating appropriate indexes also working on index fragmentation issue.
• Set up Temporal tables framework in the Azure databases to capture DML data changes on databases by creating history table and enabling system versioning on the main tables.
• Single handedly deployed SQL server 2016 database to Azure database by scripting the database, all the objects and scripting out insert data script for master tables.
• Checked in all SQL objects schema, deployment scripts and related queries in the TFS (Team Foundation Server).

Environment: Windows 10, SQL Server 2016,2014, 2008 R2, Microsoft SQL Azure RTM 12.0.2000.8 ,SSIS, SSMS, BIDS and .Net Web Client Tool.

Confidential

Sr. SQL & SSRS/SSIS Developer

Responsibilities:

• Developed complex stored procedures having lot of business rules and logic, used dynamic query within the stored procedures .
• Used CTE, temptables, tables variables, subquery, correlated within the stored procedures.
• Enabled CDC on the existing tables to capture dml changes in the CT tables.
• Worked on the development of the database objects such as tables, constraints, indexes, views, functions, types, triggers as per the requirement and business rules.
• Extensively used queries such as merge statement, lead and lag functions, rank functions, sub query, joins etc.
• Developed parametrized, drill down, matrix, drill through, cascading parameters reports, tab reports having user permission(only particular rows and columns to be displayed as per user).
• Developed Stored procedures and tables,views database objects to filter the SSRS having row filter and columns hide and unhide based on the Userid.
• Developed reports having dynamic columns by using dynamic query in stored procedure.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
• Did compressive performance tuning of the long run quires.
• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling
• Developed many SSIS packages to perform ETL to various sources such as SQL Server, Oracle, DB2, TERADATA, MS Access, Excel, Flat. To load these data used Data Flow Task, Execute SQL Task, Script Task, Execute Package Task and other executables and transformations in SSIS package for applying business rules.
• Used President constraint for applying constraints and expression for controlling the logical workflow of the executables in the control flow section
• Worked on the error handling of the SSIS packages and Stored procedures.
• Deployed the SSIS package in QA and production.

Environment: Windows 10, SQL Server 2016,2014, 2008 R2, SSIS, SSMS, BIDS and .Net Web Client Tool.

Confidential, Los Angeles, CA

Sr. SQL & SSIS Developer

Responsibilities:

• Involved in project meetings to walk through and review the functional and technical specifications with client.
• Delegated Project based tasks to the offshore team. Communicated with team about the project and business requirement.
• Deployed SSRS reports and data sources from SQL server data Tools to SSRS reporting server.
• Created Normalized database structure, database objects such as views table and stored procedure and designing of SSIS packages for extraction and transformation (data manipulation logic) of data from FTP folder based on the tickets from select staffing end user.
• While developing SSIS package extensively used executables such as for each loop, Sequence container, for loop, DFT(along with many transformations in DFT), execute sql task, bulk insert task, FTP task, file system task, execute process task, execute package task, send mail task, script task .
• Eliminated duplicate data from staging tables and loaded the distinct data to PROD tables by creating stored proc for each staging table.
• Used big logics to develop stored procedures to align with the business rules and data requirement especially to load the data from staging tables to PROD tables.
• Used merge statements for DML operation in Stored procedures.
• Extensively used sub queries, correlated queries, temp tables, CTE, table variables in stored procedures
• Managed all the published reports using report manager. Controlling the user permissions to access the reports at site level, folder level and report level access.
• Used Lookup transformation and merge join to update the existing data with new data if it was not matched and loaded new data which was not existed in the PROD table.
• Extensively used event handlers, lookup, merge join, script component, union all, data conversion, derived column, conditional split, multicast, merge, sort, aggregate, row count, row sample for applying the business rules in SSIS packages.
• Handled error and given the production support for data issues related to SSIS packages and Stored procedures.
• Did compressive performance tuning of the long run queries.
• Enabled SSIS package logging and configuration in the SQL server table

Environment: Windows 10, SQL Server 2016,2014, 2008 R2, SSIS, SSMS, BIDS and .Net Web Client Tool.