Professional Summary

Over **+ years of experience in various database management systems (DBMS) such as Oracle, SQL Server, and PostgreSQL, as well as relevant tools and technologies such as SQL, PL/SQL, T-SQL.

Skilled in Business Intelligence technologies like SSIS & SSAS, Microsoft Azure Cloud Services like ADLS, ADBK, ADF and Synapse Analytics Services.

Extensive SQL development experience in education and state agency domains.

Hands on experience on cloud migration projects.

Highly experienced in creating complex SQL server, oracle, postgresql queries, dynamic queries, views, stored procedures, triggers and user-defined functions to implement business logic and data protection.

Experience in performance tuning and optimization of sql, sql scripts and stored procedures using sql tools, execution plans, trace, statistics, index tuning wizard and sql profiler

Over 9 years of experience in SSAS designing, developing, processing of cubes using sql server analysis services.

Over 9 years of experience in designed and developed SSIS packages to clean and load data to data warehouse.

Over 4 years of experience in designed and developed packages in Azure Data Factory, Azure Data Lake Storage, Azure Data Bricks and Synapse Analytics Services.

Over 4 years of experience in Power BI & qlik sense.

Designed and Developed data vault 2.0 methodology.

Performed database installation and configuration tasks such as system requirements analysis, installation planning, software installation, and configuration tuning.

Hands on experience on PySpark using databricks notebooks.

Hands on experience on backup and recovery models.

Strong analytical, and design skills and excellent communication skills with leadership qualities of handling team.

Experience in working with very large and complex databases containing several millions of rows.

Deploying packages to SQL Server and executing packages through jobs.

PROFESSIONAL EXPERIENCE

Lead database engineer at HCL Technologies (For the customer Tenneco @Northville, MI) Jan 22 - Present

Responsibilities:

• Responsible for migrating the existing SAP Hana projects into Azure Cloud

• Designed and developed packages in azure data factory, azure data bricks and synapse analytics services

• Design/develop data vault 2.0 methodology.

• Involved in database administration tasks such as database design, implementation, optimization, and maintenance.

• Performed database installation and configuration tasks such as system requirements analysis, installation planning, software installation, and configuration tuning.

• Implemented data models for both transactional and analytical database systems, including OLTP, OLAP and data warehousing solutions.

• Created complex sql queries, dynamic queries, views, stored procedures, user-defined functions.

• Involved in database optimization techniques such as query tuning, index optimization, and database schema design to improve performance, scalability, and reliability.

• Created the pull requests and deployed in qa, pre-prod and production environments using DevOps

• Interacted with Internal and external clients and gathering requirements.

• Implemented query optimization strategies including but not limited to indexes, fragmentation and execution plans

• Created and managed ER (Entity Relationship) diagrams based on the proposed database changes.

• Involved in the SQL code walk through and reviews with the team members.

ENVIRONMENT: Oracle, PostgreSQL, SQL Server, SSIS, Azure data factory, ADLS, Databricks, ASQL.

Business Intelligence Specialist at Dell International Services Jul 16 – Dec 21

Responsibilities:

• Interact with Internal and External Clients and Gathering Requirements.

• Taking care of the project deployment and Deployment in Production Environment.

• Construct the data model, design stable, reliable and effective databases with maximum uptime.

• Developed SLA PD Dashboard for multiple accounts.

• Developed ETL packages for different sources.

• Performance tuning and optimization of SQL, SQL scripts and stored procedures.

• Configured database servers, instances, and databases, as well as troubleshooting issues related to configuration and installation.

• Created complex SQL queries, views, stored procedures and user defined functions.

• Performed SSAS designing, developing, processing of cubes using sql server analysis services

• Created and configured data source & data source views, dimensions, cubes, measures, and partitions using SQL server analysis services.

ENVIRONMENT: Oracle, PostgreSQL, SQL Server, SSIS, SSAS, Azure data factory, ADLS, Databricks

Database Developer at Choice Solutions (For the customer Maine Department of Education, Maine) Jan 14 – Jun 16

Responsibilities:

Creates T-SQL scripts involving Joins, correlated and nested sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.

Enhanced performance using optimization techniques-normalization, indexing, monitoring logs to ensure the completeness of batch processes and scripts.

Involved in development of new features / customization based on the client requirements.

Performed SQL Server database migration tasks such as migration planning, source and target environment analysis, data migration, and testing.

Designed and Developed SSIS packages to clean and load data to data warehouse.

Extracted data from various sources like SQL Server 2008, .CSV and Excel from Client servers and through FTP.

Developed SSIS Packages using derived columns, condition split, aggregate, execute SQL task, data flow task, execute package Task etc to generate underlying data for the cubes.

Designed and developed cubes as per the client’s requirement.

Optimized SQL queries as well as cubes to enhance performance.

Created partitions and aggregations to increase the performance of the cube.

ENVIRONMENT: SQL Server, SSIS, SSAS

Experience before Choice Solutions

Sanguine Global Solutions Nov 09 – Dec 13

Education:

Master of Business Administration (MBA) From JNTU University in 2009

Contact this candidate