OBJECTIVE:

• Motivated and ambitious Data Management and Support Software Development with experience using MS SQL Server. Seeking an opportunity to utilize my skills and abilities in a challenging environment that offers professional growth while being resourceful, innovative and flexible. I am capable of leading and working in a team as well as individually.
• Having 3+ years of professional IT experience in design, development, implementation, maintenance, and Testing in MS SQL Server 2017/2016/2014.
• Involved in the SDLC (system development life cycle) of a data warehouse and responsible for designing, coding, testing, implementing, supporting the ETL processes for data warehouse solutions/data marts and implementing the reporting requirements.
• Experienced in SQL Server Business intelligence tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) as a back - end developer in financial, health care, insurance, and retail companies.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin.
• Experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins.
• Experience in writing T-SQL queries and Rank functions.
• Hands-on Work experience in developing SSIS Packages to Load data into the Data warehouse from Heterogeneous databases such as Oracle, DB2 and MS Access.
• Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
• Hands on experience in creating Configuration files and deploying into the file system and the SQL Server database.
• Experience in report building using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Chart Reports. Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experience in the field of Unit testing, have tested codes of T-SQL and SSIS Packages in the testing environment.
• Knowledge in Backup and Restore.
• Strong working experience in the Data Analysis, Data Profile, Data Quality, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
• Experience in creating SQL Server Maintenance Plan.
• Experienced in creating Indexes, planning and implementing Server Security and authentication.
• Experienced in using tools like MS SQL Profiler, Index Tuning Wizard, and Red Gate Data Generator.
• Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop a creative solution for challenging client needs.
• Deploy Power BI to grant specific permissions to users from any department to access database in a way they want to use it.

TECHNICAL SKILLS

Languages: SQL, Mathematics

Database Systems: MS SQL Server 2017/2016, Azure, MySQL, Oracle 12cR1

Software: MS Office, G Suite, PostgreSQL, Informatica, Teradata, Power BI

Client Operating Systems: Windows 7/8/10, RedHat Linux, MAC OS X

Cloud: AWS, GCP

PROFESSIONAL EXPERIENCE

SQL Database Developer

Confidential

Responsibilities:

• Create numerous simple to complex queries involving self-joins, correlated subqueries and XML techniques for diverse business requirements after analyzing running database, conducting compatibility and investigating alternate configuration & implementing better solutions.
• Employee best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implement the importation and exportation of data using XML and SSIS.
• Use the SQL Server Profiler tool to monitor the performance of SQL Server - particularly of workloads and implemented its recommendations whenever required.
• Development of Database Server Configuration Management of Source code.

Confidential

Junior SQL Server DBA

Responsibilities:

• Gathered requirements from business users, created technical specification documents.
• Involved in creating tables, constraints, stored procedures, views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database, as well for Data consistency using SSAS.
• Moved files between the File Groups and partitioned the tables as well rebuilding the indexes at regular intervals to improve the performance.
• Monitoring SQL server performance using profiler to find performance implemented by SSRS.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Backing up, restoring the database manually and by scheduling the jobs and Maintenance Plans written in T-SQL Scripts using SSIS with ETL. Designed and implemented a comprehensive Backup plan and disaster recovery strategies Implemented.

Confidential

Software Project Trainee

Responsibilities:

• Developed and Maintained JDBC on JDK 1.6 to create software for every given project by Senior Software Engineer.
• Analyzing data and conducting compatibility and quality assurance testing. Investigated alternate configuration & implemented better solutions.