SUMMARY

• Around 12+ years of Design and Development experience of Databases, ETL systems, Reporting in Software systems for Automotive, Healthcare, Finance and Educational domains.
• Experience in transforming complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, Triggers, TSQL Scripting, SSIS and Jobs.
• Experience in Using Sql Profiler, Execution plans, Dynamic management views and extended events to determine the causes for performance degradation and maintaining the performance.
• Experience in implementing Indexes, table level partitioning for improving performance and manageability.
• Experience in extracting and transforming data using SSIS Import/Export Data, Bulk Insert, BCP and DTS/SSIS Packages.
• Experience in Designing ETL Packages for integrating data from heterogeneous sources and destinations. (Excel, CSV, Oracle, flat file, ODBC, Text Format Data)
• Experience writing custom scripts using Script component in SSIS.
• Experience in developing drill trough and drill down reports using SQL Server Reporting services.
• Experience in developing dashboards and charts using SQL Server Reporting services power BI, and Tableau Software.
• Experience in designing and developing Data Warehouses, Data marts and Business Intelligence using multi - dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using SSAS.
• Experience in writing MDX queries to query the cubes for the reporting needs.
• Experience in writing Advance T-SQL queries for handling data in JSON, XML format.
• Experience in working with No-SQL databases Ealasticserach and MongoDB.
• Working Knowledge of Microsoft Azure cloud platform and other services.
• Working knowledge of Azure SQL, Cosmos DB and Graph database services.
• Working knowledge of pipelines using Azure Data factory to move data from cloud.
• Experience with COSMOS, SCOPE, SCOPE Studio and COSMOS tools.
• Knowledge of Hadoop architecture and data analysis using Hive.
• Experience in different team projects with good project implementation experience, team skills, troubleshooting, presentation abilities and issue resolution capabilities.
• Excellent communication, analytical and interpersonal skills and ability to learn new concepts.
• Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance, implementing cutting-edge technology solutions, and training/supporting end users.
• Flexible and versatile to adapt to any new environment and work on any project.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Engineer

Responsibilities:

• Actively involved in the overall Development life cycle of SDLC including requirements analysis, design, coding, testing, and deploying.
• Actively interact with the product management team to analyze the requirements for the design of enterprise database solutions.
• Co-ordination with the Developers and DBA’s to implement data solutions and maintain best practices.
• Design and develop databases, tables, and partitioning.
• Develop and create Normalized and denormalized Tables, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Analyze and tune the queries and apply necessary indexes using execution plans, profiler, and DMV's.
• Develop and Maintain syncing the data to DataMart from Datawarehouse using CDC.
• Develop and Maintain queuing and batching of the data to ingest into Elasticsearch indexes for On-Demand application.
• Write advanced T-SQL queries to pass data in JSON format to consume in API.
• Develop, test, and deploy jobs using Enterprise Job Manager Application.
• Design and develop ETL Packages for generating the extracts, loading the data into data warehouse using SQL Server Integration Services.
• Design and develop, and publish the reports, dashboards, Charts using Sql Server Reporting Services and power BI Reporting tools.
• Develop and deploy cubes using SQL Server Analysis Services.
• Create SCOPE scripts to migrate from on premise SQL sources to COSMOS
• Experience with COSMOS JobMan, data downloader, COSMOS PowerShell and COSMOS API tools to schedule jobs and import data from COSMOS to SQL
• Created SCOPE scripts to support ad-hoc requests and analysis purpose.
• Responsible for providing production support including troubleshooting and resolution.
• Review, understand and document the current processes to establish support for current and future requirements.
• Responsible for Technical documentation.

Environment: SQL Server 2008 R2/2012/2016, Power BI, Sql server Reporting services,Sql Server Integration services, SQL server Analysis Services, Elasticsearch, Kibana, TFS, Windows Server 2003, .Net, ASP.Net, IIS7.0, Excel, Visio, VB script, MS Access, Microsoft Excel.

Confidential, Jacksonville, FL

Sr. BI Developer

Responsibilities:

• Actively involved in the overall Development life cycle of SDLC including requirements analysis, design, coding, testing and deploying.
• Actively interact with the users to gather the requirements for the selection of healthcare claim data for the analysis.
• Actively involve with business to gather requirements for generating extracts and imports from OLTP system to clients SFTP Systems.
• Review, understand and document the current operational processes and data sources to establish support for current and future reporting requirements.
• Co-ordination with the Developers, BU, business partners to implement custom solutions using SSIS and SSRS.
• Database designing, Query review, Query tuning / performance improvement
• Develop, test and publish the reports, dashboards, Charts using Sql Server Reporting Services and Tableau software.
• Develop, test and deploy the ETL Packages for generating the extracts, loading the data into data warehouse using SQl Server Integration Services.
• Develop, test and deploy jobs using Sql server Agent.
• Develop and deploy cubes using sql server analysis services.
• Responsible for providing production support including troubleshooting and resolution.
• Responsible for Technical documentation.

Environment: SQL Server 2008 R2/2012/2016, Sql server Reporting services, Tableau 8.0, Sql Server Integration services, SQL server Analysis Services, SVN, Fogbugz, Windows Server 2003, .Net, ASP.Net, IIS7.0, Excel, Visio, VB script, MS Access, Microsoft Excel.