Manjunath Karanam

KARANAM MANJUNATH Chennai, India Mobile: -| E-Mail:-Seeking a quality IT environment in Data engineering, ETL and SQL Developer to use my analytical and design skills for organizational growth and also carve out niche for both personal and professional growth SUMMARY 10 + years of good experience in Data engineering, SQL Server, ETL (SSIS) design and implementing end to end BI Solution across all domains, specialization in all phases of Software Development Life Cycle SDLC and AGILE methodologies of Analysis, Design, Development and Implementation, Integration and Testing, deployment, and maintenance. Currently working in Microsoft Azure with Azure data factory and Cosmos DB, Azure SQL, ADLS gen2, key vault, Azure SQL, web App service, Azure functions Working in Agile environment Azure devops CICD pipeline Proficient in developing ETL using data bricks. Knowledge in Snowflake TECHNICAL SKILLS Microsoft Azure cloud : MS Azure(App service, Azure functions, Azure data factory and data bricks with python & Apache SQL spark, Azure event hub) CICD : Azure DeVops, power shell, bash script, GIT Deployment : CI/CD Web Technologies : ASP.NET, ASP.Net core Data Warehousing : MSBI(SSIS,SSRS,SNOWFLAKE) Languages : C#,VB Script Languages : JavaScript, JQUERY,LINQ Database                 : SQL Server 2000, 2005, 2008 R2 Reporting Tools   : SSRS, POWER BI,Crystal Report Operating System : Windows 10,9x, 2000/XP/7 Other Microsoft Utilities : Microsoft SharePoint, Grafana, SCOM Tools : Service now, Clear Quest, Cloud Hosting Service, TFS, Hashicorp Vault EDUCATION  Master’s in Computer Application from University of Sri Ramananda Marathward, India 2004  Bachelor’s in Computer Application, SV University, India 2001 WORK EXPERIENCE Organization Designation Duration HCL Technologies Encora Innovation Labs Indicomm Global Services, India  Technical architect Technology specialist SQL/ETL Developer June 2021 – till now Aug 2020 – Mar 2021 Oct 2017 – Dec 2019 Indegene Life Systems, India SQL/BI Developer Oct 2015 - July 2017 KPIT Technologies Inc – India SQL Developer Mar 2013 - Oct 2015 Seventymm Service Pvt Ltd, India SQL Support Engineer Jan 2012 - Feb 2013 Griha Software Technologies Pvt. Ltd, India SQL/ETL Developer Mar 2010 - Jan 2012 MediAssist India Pvt. Ltd, India SQL Developer Nov 2006 – Mar 2010 KEY DELIVERABLES Data Engineer Domain: Banking Project Name: RAWS/Audit Management System Client Name: FXLynx Tools:SQL Server, Power BI and AWS Duration: Oct 2017 - Present Project Description: It provides reliable software design services (2G,3G and 4G) and customization for system integrators to differentiate in the development of essential Search & Rescue, Security and Reliable Private Voice & Video Networks. When using our staff of skilled developers, system integrators or service providers will receive state of the art technical support and quality solutions. Responsibilities: · Working in Azure SQL stack architecture – Azure Data Factory, Azure Data Lake, Azure Synapse · Responsible for providing the solution definition and architecture strategy to enable the data integration for various sources. · Responsible for providing the source to target mapping. Data Engineer Domain: Healthcare Project Name: Risk Adjustment (U.S Health Care) /HEDIS Client Name: MeritusAZ, Nevada health care, Land of Lincoln Tools:SQL Server, Power BI and AWS Duration: Oct 2015 - July 2017 Project Description: A statistical process that takes into account the underlying health status and health spending of the enrollees in an insurance plan when looking at their health care outcomes or health care costs. Responsibilities: · Working in Azure SQL stack architecture – Azure Data Factory, Data Lakes, Cosmos DB · Optimize the existing scripts associated with COSMOS without change in business requirements. · Check various services associated with application using XLens Data Engineer Domain: Manufacturing Project Name: IDS (Salesforce to SQL Server Migration) Client Name: HP Tools:SQL Server, Power BI and AWS Duration: Mar 2013 - Oct 2015 Project Description: Analysis on HP Products and Using Application Efferent and effective way in terms of data access and creating the customer queries. Creating the SQL Equivalent schema with reference to SFDC Schema. Responsibilities: · Working as a Senior Data Engineer in creating ETL Packages. Working along with Business Team/stakeholders to implement the BI Solution – Data Integration. · Working in Azure SQL stack architecture – Azure Databricks(pyspark,scala), Azure Data Factory, Data Lakes, Cosmos DB ,Azure SQL, Synapse, Azure AS, Azure Function , Logic Apps and Azure IaaS Technologies – VMs, SaaS, PaaS and IaaS architectures. · Migrate the on-premise database – SQL server 2016 into Azure SQL DW. · Developed a generic pipeline that handles all the inbound file loads in ADF and Automates all the manual works into ADF Pipelines. · Optimized the existing SSIS packages and Stored procedures without change in business requirements As an SQL Support Engineer Domain: E-commerce Project Name: IDS (Salesforce to SQL Server Migration) Client Name: HP Duration: Jan 2012 - Feb 2013 Project Description: Seventymm.com is home to movies and Bollywood related products and constantly striving to provide a wholesome online experience to our customers. Responsibilities: · Supporting easy application data issues · Setting end to end Test environment for easy application data · Creating and modifying SSIS packages depends on requirements and issues · Monitoring and Scheduling SSIS jobs · Documentation of Packages(GetAimsdata and UpdateAIMSdata) and issues · Analyzing and giving solution for repeating issues · Creating and modifying stored procedure · Creating and modifying Views · project related technical work and non-technical works · Designs, implements and supports ETL in azure cloud. · Performs a variety of tasks.   As an SQL/ETL Developer Domain: Pharmacy Project Name: MDB Client Name: MHS Duration: Mar 2010 - Jan 2012 Project Description: MDB Project is made for the USA Client MHS. This is a Hospital Domain Project. MDB stands for Master Database. This project is designed to maintain the information about all the items present in a Hospital with details of each year. This will generate detail Reports according to requirement of hospital. It also gives cost of each item, rooms, floors and hospitals, so they can find out what is the total cost of the hospital’s now and last year. This provides full security for users; so that they can see items and details present in their hospital only. There are more than 400 hospital’s details present in the Database. Responsibilities: ª Interacted with business users to gather and understand business requirements 4 / 4 ª Developed, deployed, and monitored SSIS Packages ª Created SSIS packages as two stage loads, extracted data from source into staging tables and then transformed the data using data conversion, lookup’s, Derived tasks and load the transformed data into data warehouse tables ª Created the scheduled the Jobs using SQL Server agent ª Implemented packages that uses for each loop, for loop concepts, union and merge tasks ª Validated the data between source to destination and documented the results ª Created and modified attributes, facts, metrics as part of report development and debugging process ª Created reports using Prompts, Filters, Advanced filters, Custom Groups ª Created and updated advanced dashboards with panel stacks, grids and graphs ª Resolved the issues with reporting data, by analyzing the MicroStrategy SQL and backtracking the data warehousing tables and MicroStrategy objects ª Attended daily scrum meetings and updated the status and discussed about upcoming goals, milestones and blockers As an Manual Tester/SQL Developer Domain: Health Insurance Project Name: Blue Sky Client Name: hp Duration: Nov 2006 – Mar 2010 Project Description: Blue Sky is a project developed for MediAssist India TPA Pvt. Ltd. to maintain consistency and accuracy in reporting. The project handles heterogeneous clients such as Insurer,Corporate and Hospitals. The reports were delivered using Subscriptions and web interface which includes auto-subscribed and auto-generated.The SQL 2000 Server Reporting Services is server based for comprehensive reporting applications. This service can deliver not only hardcopy reports but can also provide web based interactive reports. Responsibilities:  Interacted with business users to understand the business requirements  Involved in SQL Support related activities like updates/inserts data sets.  Requirements Study  Involved in Writing, Test Specification, Test Case Development, and Writing Test Procedures  based on the Design Specifications Provided.  User acceptance testing  Positive and Negative Testing was performed for this application  Implemented best practices for production environment  Worked and resolved Level 1,2 and 3 severity tickets within stipulated period  Performed thorough testing of the issue before sending it to UAT  Attended daily and weekly meetings with the client to provide update on the status of the issue/ticket