Anurag Kanchibhotla Subhramanya Email & Phone Number

Birmingham, Al, Us

Built data pipelines using AWS firehose, S3 and loaded the JSON payload in Snowflake using snow pipeBuilding pipelines in Databricks to create Bronze, Silver& Gold layer Schema design to reduce the latency of data to < 1 minEffectively working on data which are coming from Kafka which are using messaging queues, streaming technology and batch processing to load data into SnowflakeDeveloped framework to ingest data from Bigquery to Snowflake to build single platform for any sources using sparkArchitected and developed framework to read data from intercom using API and load the data into snowflakeMigrated all pipelines from databricks to dataproc and made our framework to use open source tools Upgraded spark clusters to 3.2.0 and upgraded all other connectors to use 3.2.0 version of sparkBuilt and architected framework to export data from snowflake to multiple sources with different file format optionsOptimized snowflake usage for a 44B record table to effectively use partition and clustering the table using appropriate keysAutomated cluster restart process and drone build for frameworks to automatically restart the streaming clusters upon failure and avoid manual intervention for on-call engineers. Reduced several hours of human on-call hours

Irving, Texas, Us

Build, support and test BI/data warehousing/ETL/Reporting solutions; led BI projects in a cross-function and geography teamsArchitect/Developed the ETL framework; built/designed 100+ ETL pipelines; established logs for the jobs for the Source system upgradation to cloud by pushing data from AWS cloud datalake to staging and to SQL Server data warehouseWorked on messaging que and streaming technologies in AWS cloud to bring moved data into Microsoft SQL ServerImprovising T-SQL queries to build customized star schema and reduce the SQL query processing time along with query plan optimization, windowing functions and aggregate designWorked with Finance team to develop/automate 80 pages paginated Monthly Business Review report using Cognos/T-SQL SP that helped the team to reduce 160 hours of development time globally for every monthWork on building and designing a data warehouse using star schema designs for better reporting performanceDevelop and maintain around 100+ complex financial/Operational reports/dashboards using T-SQL queries, ETL, Cognos/Power BICollaborated with Supply Chain team to build Kanban Dashboard using Power BI on live data from SQL Server to track the inventory level based on a trigger point, item tracking between warehouses; improved the factory processing time by 30%Worked with Finance team to develop/automate 80 pages paginated Monthly Business Review report using Cognos/T-SQL SP that helped the team to reduce 160 hours of development time globally for every monthDeveloped pricing tool by closely working with Sales/Pricing team using PowerApps/PowerFlow/T-SQL SP star schema to calculate the quote value for a customer order; reduced quote building time from 10/week to click of a buttonPartnered with Directors of IT & HR, to develop a live time and attendance tracker for the supervisor, as the company was losing a revenue of $10M due to the hourly employees not properly clocking in the job hours; Recovered $300K

Global, Us

Armonk, New York, Ny, Us

Lead and managed a team of 3, chaired weekly team meetings, mentored new staff, delivered knowledge transfer to new trainees on Tableau dashboard, SQL queries, prepared root cause analysis document for the deliverablesExperience in an Agile Scrum environment and working with a cross-functional team for effective project completionReporting: Created interactive Tableau dashboard on SSIS data migrations jobs for ad-hoc reporting on job failure, status, on daily/monthly basis; Analyzed, visualized task efficiency using python correlation heat mapData Mining: Analyzed credit posting for client “DirecTV” using statistical measurements (Regression, T, F test) to formulate marketing campaigns for next quarter on potential customers.Reported on project efficiency to team members and senior management using customized Tableau dashboardsPerformed data migration activities on customer warehouse using custom SQL scripts improving errors by 12%Automation: Created Pivot Tables, used VBA in Excel to maintain dashboard for most subscribed packagesOptimized efficiency of queries by 17% by removing outer joins and converted them to inner joins in the database

Master'S Degree, Management Information Systems, General

Bachelor'S Degree, Electronics And Communications Engineering