SUMMARY:

Around 11 years of experience in Analysis, Design, Development and Tuning of Relational Database Management Systems (RDBMS) for domain specific Business Intelligence (BI) applications in Online Transaction Processing (OLTP) environment and all phases of Software Development Life Cycle (SDLC) with a thorough understanding of Object Oriented Principles(OOPs), Conceptual, Logical and Physical database modeling, Normalization, Data mapping, ER Diagrams, Extract, Transform and Load process(ETL) and creating precise SQL Server Reports(SSRS) in terms of observing business rules.

TECHNICAL SKILLS:

Databases: SQL Server 2016/2012/2008 R2/ 2005

Database Tools: SQL Server Management Studio (SSMS), SQL Profiler, Database Tuning Advisor, Toad,Beyond Compare

Programming Languages: T - SQL(DDL&DML), XML, JSON, PowerShell and knowledge of C#, VB.Net,ASP.Net

Operating Systems: Windows Vista/7/8/10 and Windows 2012 Server.

Business Intelligence and data modelling Tools:: MS Visual Studio, MS Visio, MS Office and Erwin Studio.

Business Intelligence Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), knowledge of OLAP and SQL Server Analysis Service (SSAS - Cubes, Dimensions, attributes, Measures, Hierarchies and Members).

Version Control: Visual Source Safe, Team Foundation Server, SVN, RedGate, PCI Integrity.

Data Modelling: Conceptual, logical and physical modelling(OLTP), in depth knowledge of Data warehousing, Data Marts, Dimensional modelling(facts, dimensions and measures)

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Senior ETL/SQL Server Developer

Responsibilities:

• Actively involved in Client meetings, requirement gathering and technical documentation.
• Worked closely with BA(s), Application Developers(s) and DBA(s) to achieve the technical goals.
• Managed the offshore team, reviewed the code and provided the necessary feedback.
• Worked closely with the Database architect in designing relational model for the rental module using ERWin/Studio 17.
• Abstracted non-relevant information from users using row level security (RLS) and Dynamic Data Masking.
• Utilized the JSON Support feature of SQL Server 2016 to convert the sql data to JSON format(FOR JSON AUTO, PATH)
• Created stored procedures and TSQL scripts ( Views , Triggers and Functions ) to query databases, develop processes that simplified and made more efficient data entry and transaction processes to extract/load/update data.
• Implemented logic to handle SQL Injection and Parameter sniffing in stored procs.
• Analyzed indices for performance using DMVs/ DMFs for fragmentation levels to rebuild/reorganized indices accordingly.
• Created, Configured, deployed and fine-tuned SSIS packages with Lookup transformations, Merge joins, script tasks, Fuzzy Look Ups, oledb command, FTP, Data Transformation and Derived column Tasks.
• Created PowerShell scripts/bat file for deployment automation of ISPAC and sql files to the relevant servers and databases.
• Researched on downloading files from SFTP Servers using WinSCP, SSIS (sensitive parameters) and Script component task.
• Designed/ developed/deployed Tabular type Drill Down/Drill through Reports with Cascading parameters, Groupings, Expressions and Dashboards in SSRS with Data Driven Subscriptions.

Environment: Visual Studio 2015, PCI Integrity, Outlook 2010, SQL Server 2008/2016, Windows 7, Beyond Compare, Toad, ERwin

Confidential, Roseland, NJ

Senior BI/SQL Server Developer

Responsibilities:

• Designed and developed SQL Server Objects (Tables, Stored Procedures, Functions, Triggers, and Views, temp tables, table variables and User defined types) using Transact SQL (TSQL).
• Fine-tuned and refactored code for the existing stored procedures to proper coding standards.
• Created Dynamic scripts to drop/create constraints and truncate tables in multiple databases.
• Created SSIS packages for migrating/integrating (Look Up, Merge Join, SCD) data from heterogeneous sources.
• Monitored daily Processes for different Data Loads and resolved Issues.

Environment: Visual Studio 2012, TFS, MS Outlook 2010, SQL Server 2012, Windows 7, RedGate.

Confidential, Addison, TX

Senior BI/SQL Developer

Responsibilities:

• Loaded data from heterogeneous sources (MS Excel, MS Access, and Flat Files to SQL Server using SSIS).
• Programmed user Defined Functions, Views using TSQL Scripting for complex business logic.
• Created interactive reports with SSRS , using the report parameters, query parameters, Filters and Expressions .
• Analyzed and fine-tuned database objects to migrate to production level using sql profiler .
• Authored technical design documents for the newly created objects’ specifications.

Environment: Visual Studio 2012, SVN 3.0.4, MS Outlook 2010, SQL Server 2008R2/2012, Windows 7.

Confidential, NYC, New York

SQL Database Engineer

Responsibilities:

• Worked with business analysts to develop project specifications.
• Developed new database schema and objects (Stored procedures, Functions, Triggers and complex SQL Queries) for importing the legacy data for upgrading/downgrading the companies’ rating.
• Created and maintained fairly complex SSIS packages using Fuzzy lookups for importing the most accurate legacy data.
• Integrated companies’ info with the ratings in one central database with historical data.

Environment: Visual Studio 2012, SVN 3.0.4, MS Outlook 2010, SQL Server 2008R2/ 2012, Windows 7.

Confidential, NYC, New York

SQL Server/SSRS Developer

Responsibilities:

• Designed and created tables, views, triggers and other objects required for web statistics & analysis.
• Coordinated with front-end developers for implementing the logic in stored procedures and functions .
• Created dynamic packages for Incremental Loads and Data Cleansing using SSIS.
• Developed and deployed ad hoc and customized reports using SQL Server Reporting Services ( SSRS ) .

Environment: Visual Studio 2010, Windows 7.0, SVN, MS Outlook 2010, SQL Server 2008R2/2012, SSRS.

Confidential, De Pere, WI

Jr SQL Developer

Responsibilities:

• Developed stored procedures, views, triggers using T-SQL to calculate premiums, deductibles and copays.
• Debugged the triggers , views , monitored the system and SQL server jobs for any failures.
• Utilized Merge statement introduced in sql server 2008 to insert/update/delete from target tables
• Imported the data from flat files to sql server using bulk insert.
• Analyze data trends and resolved client functional questions in a timely manner.

Environment: Windows 2003 Server, Visual Studio.Net 2.0, SQL Server 2005/2008, Team Foundation Server.

Confidential, Ashland, OR

Jr SQL Developer

Responsibilities:

• Created stored procedure, Functions, Triggers and Views using TSQL .
• Got an opportunity to work on SQL Profiler and Database tuning advisor to fine tune queries.
• Fixed the Bugs in the existing Stored Procedures, TSQL Scripts.

Environment: WindowsServer2003, Visual Studio 2005, SQLServer2005, Tortoise CVS.