SUMMARY

• 10 years of IT experience in Confidential technologies on various Industry domains Sales and Marketing, Banking, Finance, Manufacturing and Azure BIG Data with technology stack of SQL, COSMOS Scope scripts, MSBI, PowerBI, C#, Azure Data Platform - ADLA, ADF MSBI technologies
• Adept in Data Design and Development in Confidential SQL Server 2016, T-SQL, Performance Tuning, Troubleshooting, SSIS Package Configuration and Data-warehousing.
• Design, Develop, Deployment of End to End SQL server agent jobs by writing SQL queries and creating SSIS Packages. and SQL Server Analysis Services.
• Good Experience in creating tabular Cube and various types of reports using SSRS and Power BI.
• Proficient working knowledge in COSMOS scope script using scope studio with End to End development, Business validation testing with automated cosmos job scheduling using Datastudio, XFlow, Datagrid and SSIS.
• Experienced in creating Microservices - stateless Service Fabric Application in C# programming with Unit Test, Functional Test & Deployment of the services in Confidential Azure.
• Experience in creating Cosmos pipelines for HDInsights Telemetry and Azure Stream Analytics to calculate the analytical data of the Big Data Clusters.
• Experience in Azure Data platform includes ADF, ADLA USQL language, Scope - USQL conversion, Kusto to Cosmos migration.
• Azure Resource Management template deployment for Azure service fabric applications and ADF Pipelines.
• Good exposure to Azure DevOps by creating automated Build & Release definitions for DEV, staging and prod environments using Powershell scripting.
• Working experience in Security Development Lifecycle (SDL) activities to achieve the projects under Confidential Compliance.
• Exposure to Product360 portal metrics to publish the reports.
• Good working knowledge in Confidential Dynamic CRM with CRM domain concepts such as Accounts, Contacts, Leads and Opportunities and Engagements.
• Extensive working knowledge on Confidential Global Sales Experience (GSX), Marketing Sales Experience (MSX), Inside sales Experience (ISX).

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer

Responsibilities:

• Extensive usage of COSMOS scope scripts to collect the Cloud services telemetry data from Geneva Cold path.
• Create Ingestion Cosmos jobs in DataStudio and schedule the jobs using feed and frequency based and Sqlize the cooked data for reporting.
• Experience in working with DataStudio to publish and discover data, author queries, orchestrate transformations and move data between stores.
• Experience in converting Kusto query into Cosmos, Cosmos script into USQL.
• New feature implementation using Cosmos for HDInsights telemetry service to calculate the Autoscale enable and disable functionality during cluster creation and in running state from a stream of events in logEntry.
• New feature implementation using Cosmos for Azure Stream Analytics (ASA) to implement Streaming node level SLA to calculate the Hourly and Daily Node aggregates for the clusters and publish the data to P360.
• Played a DRI role in a rotation basis and responsible for mitigating and resolving ICM with the SLA.
• Onboarding the telemetry data to calculate UsageComputeHours, Customer Funnel information for Synapse (SQL Datawarehouse), HDInsights, Azure Stream Analytics.
• Experience in creating Tabular Cube and PowerBI reports on the cooked data from Cosmos scope scripts.

Confidential

Software Engineer

Responsibilities:

• Created SSIS packages to consume the Inside sales Facts and Dimensions tables from Cosmos L4 layer, Data MALL, SharePoint Flat files.
• Tech upgrade of SSIS ETL to ADF pipelines using Integration server to move sales data (Parquet files) from ADLS Gen 2 location to Azure Virtual Machine with error handling and email notification.
• Design and development of Cosmos Scope scripts to consume the source data from Layer 3 (Unstructured and Views) to Layer 4 (Structured streams) and sqlize the streams using DDL and Sqlizer for Analytical modeling and reporting.
• Cosmos scope scripts orchestration using SANGAM and SSIS, Created and deployed SSIS Packages and manage SQL Server Agent Jobs for any failure and troubleshooting.
• Extensive usage of Cosmos scope scripts to create Facts and Dimensions for the CDPVnext project and created Business validation Test for scripts.
• Developed an Azure service fabric application with OWIN listener with Key features Demo mode, AAD implementation, Key Vault, APP Insights logging, development and Automated Unit and functional testing and deployed the application in Confidential Azure.
• Created Tabular Cube and PowerBI reports to show the Inside sales compensation data to the Confidential business users.
• Acted as primary resource in ICM and DRI for the project and played SCRUM Master role.
• Created a POC on Cypher Query language to pull Individual and Organization data using Neo4J and created various marketing Insights to feed Daily Recommender.
• Analyzed the Application insights of PowerBI reports to capture the Bootstrap duration, render duration and Total Execution Duration using Cosmos scope scripts and provided the performance reports of the powerBI Reports to Confidential LT to provide the insights.
• Adhere to Service Level Agreements with the customers related to data releases, data delivery and reports publication.

Confidential

Software Engineer

Responsibilities:

• SQL Server Query performance optimization using SQL Profiler, Indexing, Query Hints to bring down the ETL runtime.
• Performed version upgrade for the ETL tool METaL which is developed using SSIS.
• Involved in monitoring the ETL execution and handled the failures.
• Octopus deployment in Dev, SIT and Production server and upgraded the dotnet code without any issues or bugs.
• Constructed Entity Relationship diagram (ERD) and developed database objects such as stored procedures, user defined functions, views, JOINS, Indexing, complex sql queries.
• Involved in automating the test cases for regression testing using C#.

Confidential

Software Engineer

Responsibilities:

• Requirement Analysis - Verify and validate the data mapping documents provided by the IT-BAs and ensure the transformation logics are clarified.
• Developed SSIS packages to load reference data from Flat files, Excel spreadsheets and reference tables provided by business.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task.
• Developed a Dynamic SQL queries and stored procedures for the SSRS Reports.
• Designed and developed reports using SSRS for reconciliation verification using several SSRS report types like linked reports, parameterized reports, sub reports & drill through and drill down reports.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Authored technical design documents for the schema and stored procedure specifications.

Confidential

Software Engineer

Responsibilities:

• Analyze and resolve issues / tickets related to the Confidential CRM tool raised by Direct Sales, Partner Sales and Internal Sales support teams.
• Manage multiple releases of fixes and enhancements for the GSX application.
• Extensively worked on SSIS, SQL, SSRS and Dotnet web application.
• Performed operations like Data cleansing, Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SQL Server Integration Services (SSIS).