Microsoft Certified Professional with Six years of IT Experience in Database Design, Development, and Implementation of Microsoft SQL Server 2005/2008/2008R2/2016/2019 in Development, Test and Production Environments
Experience in working on full Software Development Life Cycle (SDLC).
Experience in developing optimized SQL using best practices.
Expertise in writing dynamic-SQL, complex stored procedures, functions and views.
Hands on Experience in performance tuning using execution plans, SQL Profilerand DMVs.
Incorporated complex business logic into stored procedures and functions for reusability.
Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
Strong debugging skills and the ability to solve complex problems.
Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
Experience in Creating and Updating Statistics to improve the SQL Server Performance.
In-depth knowledge of T-SQL, SSRS, SSIS, Reporting and Analytics.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
Experience in creating SSIS packages using with Error Handling.
Experience in enhancing and deploying the SSIS Packages from development server to production server.
Adept at capturing the execution errors in SSIS for analysis purposes.
Experience in sync processes between two databases using SSIS.
Experience in importing/exporting data between different sources like Oracle/XML/Excel etc. Using SSIS/DTS utility.
Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
Experienced in creating various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports and Multi-valued parameters.
Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
Experience in deploying created reports to report server.
Experience in developing cubes using SQL Server Analysis Services (SSAS)
Created dashboards and visual interactive reports using Power BI.
Analyze data and present it through reports that can help in decision-making.
Experienced in connecting data sources, importing data, and transforming data for Business intelligence.
Experience in Building Analysis Services reporting models
Overview
8
8
years of professional experience
Work History
Data Engineer (with Focus on QA/Data Developer)
LTI Mindtree (Honeywell Client)
03.2023 - Current
Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
Expertise in writing Test Strategy, Test plan preparation and implementation, Test Case Design, Test Tool usage, Test execution, Defect management, and Defect tracking.
Validate the data accuracy and consistency in the data warehouse or target system. Perform queries and reports validation to ensure the transformed and loaded data aligns with the expected results.
Developed and maintained automated test scripts using Selenium WebDriver and Robot Framework.
Utilized Selenium WebDriver for automating functional and regression test cases.
Executed tests across multiple browsers to ensure compatibility and responsiveness.
Conducted regression testing to ensure that changes or enhancements to the process shouldn't impact existing functionalities.
Writing stored procedures and SQL statements to access filings data from SQL Server database.
SQL Developer/ Software Engineer
Tata Consultancy Services
10.2020 - 11.2022
Worked on requirements Analysis, Physical and Logical design development using Erwin, normalization, and SQL Server Enterprise manager
Used tools such as performance monitor, query execution plans to increase the efficiency of the queries
Managed and scheduled daily jobs relating to data transfers, backup and restore.
Migrated DTS packages and converted them to SSIS packages in SQL Server 2008.
Used ETL Transformations to copy columns and load data from source like Oracle, DB2, Flat files to destination databases.
Implemented different types of Replication models including Snapshot and Transactional replications.
Created reports using Cascading parameters and Drill-Through Reports, Sub reports, Parameterized Reports, Report Models and ad hoc Reports.
Experience in Generating Report Models, Refining and Enhancing the Report Models, Deploying Report Model, Creating Reports on Report Models.
Designed reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.
Modified and tuned stored procedures, triggers, views and indexes to provide best performance.
Analyzed, identified and implemented user roles and assigned relative database access privileges.
Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.
Environment: MS SQL Server 2008/2012/2016/2019, Erwin, DB2, ER Studio, MS SQL Integration Services, MS SQL Reporting Services 2008, MS Excel, Windows Server 2007
SQL Developer
Chamber IT Inc(Employer) - US Bank(Client)
06.2019 - 08.2020
Gathered business requirement from the end users.
Involved in creating complex stored procedures according to business logic and also for the creation of RDL for reporting.
Worked with nested Stored Procedures and Functions.
Involved in the performance tuning of the existing SQL code.
Coded with complex customer data related to events such as Delinquency, Bankruptcy, and Collections etc.
Created objects like tables and views and developed SSIS packages to load data.
Implemented Incremental Loading into the target tables/views in SSIS.
Created SSIS packages for moving data between databases.
Involved in maintaining the Error-Logging for the SSIS packages.
The data is moved with one-to-many relationships between tables and many to one relationship between tables.
Created Jobs, Alerts using SQL Server Mail Agent in SSIS.
Developed SSIS Packages and stored procedures to retrieve all accounts from various systems like Settlements, Foreclosures, Transactions and Mortgage to name a few.
Created mock-up data for testing the reports.
Involved in the performance tuning of table valued functions.
Responsible for creating reports using SSRS.
Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement.
Environment: Microsoft SQL Server 2008/2016, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Team Foundation Server.
SQL Developer
Chamber IT Inc(Employer) - Aetna (Client)
03.2017 - 05.2019
Designed and normalized the database and created different objects like Tables, Views Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server.
Involved in installing and migrating legacy database to MS SQL Server 2008R2.
Research with team members and came up with the high level design, impact analysis document with several solutions to the problem during implementation proposed new system.
Created several SSIS package to import Flat files CSV into data tables.
These packages were scheduled in regular time interval.
Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
Created SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
Applied various data transformations like Lookup, Sort, Multitasking, Conditional Split, Derived column.
Perform data validation checks and filtered bad data.
Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
Responsible for the ad-hoc reporting, modification and regenerating on request.
Building scorecards and dashboards using the Performance Point Services 2010 with BI application.
Schedule the reports to run daily, weekly and monthly and also automatically emailed reports to department directors and analyst to review it.
Environment: MS SQL Server 2008R2 SSRS/SSAS/SSIS, Point Services 2010, Microsoft office 2010, T-SQL, Windows 7.
Education
Bachelor of Science - CS
University of Washington
Skills
Databases: MS SQL Server 2012/2008R2/2008/2019, T-SQL, SQL Server Management Studio, Business Intelligence Development Studio BIDS, SQL Server Agent, Data Transformation Services DTS, SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, PL/SQL
Programming Language: C, Python, PL/SQL
DocumentationTools: MS Office Including MS Project, VISIO, Power BI
OperationSystems: Windows, Mac, UNIX, LINUX
Framework: Spring boot, Angular, Bootstrap, Robot Framework
Sr Data Engineer / Data warehouse Developer / Oracle Developer at Amerisure InsuranceSr Data Engineer / Data warehouse Developer / Oracle Developer at Amerisure Insurance