Jun 2018 – Jun 2020 · 2 yrs

• Azure Cloud Architect
• Architected & Implemented Public Cloud Infrastructure in highly distributed environment.
• Experience in architecting and designing technical solutions for Microsoft-centric solutions based on industry standards using Azure IaaS, PaaS and SaaS capabilities.
• Conduct current state assessment of infrastructure framework to identify gaps and recommend solutions.
• Point of contact between offshore implementation team and functional experts to convert business needs into reporting solutions.
• Design the IAC (Infrastructure as code) modules and implement using Terraform and ARM Templates.
• Define CI/CD Strategy for building and deploying the resources.
• Led DevOps Development using Github, Jenkins and Terraform Integration.
• Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DHCP address blocks, DNS settings, security policies and routing, NSG’s (Layer 4 Access Control Lists (ACLs)), Firewall Appliances (Layer 7 Security models)
• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
• Designed VNets and subscriptions to conform to Azure Network Limits.
• Exposed Virtual machines and cloud services in the VNets to the Internet using Azure External Load Balancer.
• Develop workloads using HDInsight, Data Factory, Azure Data lake, Azure Postgresql and Blob storage
• Create dataflows in PowerBI to leverage direct connection to Azure Data Lake/HDInsight

Jun 2017 – Jun 2018 · 1 yr

• Leading 29 Members High-Performance BI Team and Driving the Delivery
• Architecting new BI systems and applications for the customers
• Manage the Customers and Internal Stakeholders
• Demonstrate POC’s and MVP’s using new Tools and Technologies
• Implement Agile Practices and improve the solutions for Time to market
• Participate in design sessions and propose the solutions based on the existing system functionalities
• Design Reporting solutions using open source technologies like MEAN (MongoDB, Express Js, Angular and Node Js), D3.Js, Chart.js etc.
• Review and Define Metrics and Measures for the reporting solutions
• Design and Develop the ETL Architecture
• Conduct CBA (Cost Benefit Analysis) and Propose the new tools set to help reduce cost to the customer
• Design and Develop the Data feeds for Analytics teams
• Design and Driving the Migration Strategy for On-Premises Bigdata systems to Azure Cloud
• Involve in Sprint, PI and Release Planning Activities
• Plan and Monitor the Teams Velocity and Backlog items
• Manage the Time Reporting and Productivity of the team

Jul 2015 – Jun 2017 · 1 yr 11 mos

• Managed a ten-person team of ETL developers and automation engineers
• Design and Architect data processing framework for clients' high-level workloads
• Conduct design sessions and make recommendations for prospective feature implementations
• Demonstrated proof of concepts on different business intelligence tools like tableau and power bi
• Manage many customers in the portfolio and make sure the team's priorities are set
• Assist team members in addressing challenges by working closely with them
• Providing knowledge transfer to the team in areas of competence and encouraging functional and technical growth
• Always follow Win-Win strategy
• Motivate team members and provide positive insights to them
• Work with passion, dedication and commitment

Jun 2013 – Jul 2015 · 2 yrs 1 mo

• Design extract, load and transform (ELT) components and process flow using Hive, Python and Pig
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• Develop, validate and maintain HiveQL queries.
• Designed Hive tables to load data to and from external files.
• Using Hive and Pig to perform ETL tasks in Hadoop
• Involved with ingesting data received from various relational database providers, on HDFS for analysis and other big data operations.
• Create analysis of source systems, business requirements and identification of business rules.
• Develop, support and maintenance for the ETL (Extract, Transform and Load) processes using DTS/Adeptia/Hive/Pig
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Extensively used ETL to transfer and extract data from source files (Flat files and SQL Server) and load the data into the target database/Hadoop.
• Document Mapping and Transformation details, user requirements, implementation plan and schedule.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.
• SQL querying for Data Analysis and wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling. Extracted business rule and implemented business logic to extract and load SQL server using T-SQL
• Create different feature execution flows and workflows to load the data to Data Warehouse using Adeptia Workflow Manager.

Apr 2012 – Jun 2013 · 1 yr 2 mos

• Automate the tasks through Python, VBA scripting
• Dashboards creation in Excel VBA
• Use VBA to connect to MS-Access, SQL Server for dashboard preparations

Jun 2010 – Apr 2012 · 1 yr 10 mos

• Created custom ETL exports for the customer by using DTS packages
• Analyzed the requirements and framed the business logic for the ETL process
• Exporting and importing data using Export/Import utilities.
• Configure the DTS Packages for required ETL transmissions
• Involved in data cleansing to facilitate efficient data transfer between various environments.

Jul 2007 – Jun 2010 · 2 yrs 11 mos

• Extensive experience in SQL query writing and stored procedures creation.
• Generating the Monthly Reporting Deck by using the SQL queries
• Created data checks jobs in SQL Server to capture the reporting data and have logics to filter bad data in the system.
• Write T-SQL procedures automate the data calculations and extractions based on customer requirements
• Scheduled Jobs using SQL Server Job Agent, to run the batch files. Send the automated mail to Manager and team members.

Jun 2006 – Jul 2007 · 1 yr 1 mo

• Extensive experience in automation of tasks through VBA
• Created Management Dashboards through Excel VBA
• Created Interactive Excel Plug-in to capture the data from SQL Server and Web interface to find the differences
• Created tool in VBA to calculate maturity date, cumulative interest rate for the bonds, debentures and other fixed income securities based on the inception date and the number of installments to redeem.
• Created Excel Add-in to facilitate different options to analyze data in the spread sheet with respect to fixed income securities for the customer requirements