Akshit Gutta
Summary
Detail-oriented BI professional with around 7 years of experience in design, development and implementation of data warehousing, ETL and reporting applications. Proficient in creating and deploying ETL solutions using SSIS, Matillion to migrate data between varying systems. Expertise in creating reporting datasets and dashboards depicting key KPIs to help in business decisions. An excellent negotiator with proven business acumen and outstanding analytical skills. Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules.
Overview
7
7
years of professional experience
Work History
Senior BI Developer/ Data Engineer
BAYADA
06.2019 - 05.2024
- Creation and maintenance of Data marts by strictly adhering to data warehousing principles
- Created star and snowflake data models for enterprise data warehouse
- Managed timely flow of business intelligence information to users throughout BAYADA including CTO and CFO through General Ledger, Compensation and Service Office Transactions data marts and their SSAS cubes which approximately held almost 30% of the primary data used throughout the company and also acted as source to various Tableau reporting datasets
- Used C# scripting in Script task and script component in SSIS to perform complex functions
- Deployed various Business Intelligence solutions using ETL tools such as SSIS and through SQL Server
- Timely optimization of SSIS packages, SQL queries and various objects like Stored Procedures, functions, views present in the Data Warehouse
- Consistently involved in Lights on support and PROD server support
- Used DataBricks to create data pipelines to load data from SSMS to Snowflake as part of transition of On-prem data warehouse to cloud
- Delivered complex projects related to Electronic Visit Verification of employees, Reimbursement Cycle, Revenue Cycle, Payroll exceptions etc
- Usage of BAYADA based internal tools like BEARS to extract data and deliver to users through Tableau reports
- Gained experience with different internal source systems like AlayaCare and Homecare Homebase
- Utilized JIRA to create various user stories, accept service requests from users and time tracking
- Usage of different types of facts and dimensions concepts like Slowly Changing Dimensions, Junk Dimension, Additive facts etc., to create data marts and for optimum functioning of the Data Warehouse as a whole
- Created complex reporting datasets for users to use on SSRS and Tableau
- Automation of SSIS packages by using SQL Server Job Agent through SQL Server
- Implementing error handling techniques in SSIS using event handlers and precedence constraints
- Used Source Control tools and Collaborative tools like GitLab and Alation to check in work of all the PROD SSIS packages and SQL server objects.
SQL BI Developer
Anthem
10.2018 - 05.2019
- Implemented JIRA to create various user stories and technical tasks
- Participated in various grooming sessions to determine the appropriate story points, business value and opportunity cost value in JIRA
- Implemented SQL Server to create and execute various T-SQL objects such as stored procedures, UDFs, triggers, complex scripts and batches
- Collaborated with team member and performed data validation and data cleansing
- Worked with Macess which dealt with storage of member information and information about various documents such as claims, letters that are related to members
- Implemented custom logging in SSIS to track activity for future reference using script task
- Used various components in SSIS both at control flow and data flow levels
- Implemented SSIS packages utilizing containers, checkpoint, breakpoint, and data viewers
- Enhanced the performance of SSIS packages by configuring several properties / features at control and data flow level
- Incorporated parameters to configure package properties to migrate SSIS packages from development/testing to production environments
- Utilized enterprise JIRA and CNR to deploy SSIS packages and SQL codes into QA and Production
- Created multiple reports in SSRS to present insurance claims data to perform gap analysis
- Designed and deployed parameter-driven reports by setting up report-level parameters in SSRS
- Generated reports utilizing SSRS such as parameter-based reports, graphical reports, drill-down chart and tabular report along with creating subscriptions for different users.
Software Intern
Synapse Tech Services
09.2017 - 06.2018
- Translated business and system needs into technical requirements for Designers, Developers and Testers
- Participated in planning, designing and development of new projects
- Includes analysis of business and user needs, documenting requirements and current state processes, assisting in requirement gathering of use cases, ERD and revising existing system log difficulties as necessary
- Engaged in defect fixes and enhancing development of new applications
- Formulated and defined systems scope and objectives through research and requirements
- Worked with MS Visio, MS Office, Advanced Excel, MS SQL Server
- Designed ETL mapping document per business requirement with help of FRD document
- Utilized SSRS to create, execute, and deliver tabular, matrix and charts reports
- Gained exposure with SQL Server Reporting Services SSRS to author, manage, and deliver both paper-based and interactive web-based reports.
Education
Master of Science in Information Science -
University of North Texas
Denton, TXBachelor of Engineering in EEE -
Gokaraju Rangaraju Institute of Engineering And Technology
Skills
Database: SQL Server 2022, 2019, 2016, 2014, 2012, 2008/R2
SDLC: Agile, Scrum, Waterfall, and Spiral
Data Modeling: ER-win, MS Visio
Programming Languages: T-SQL, MDX, DAX, Python, C#
Development Tools: BIDS, SSDT, SSMS
Integration Tools: SSIS, Matillion
Analysis Services: SSAS, OLAP Cubes, Tabular Model
Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI
Source Control & Collaboration Tools: Team Foundation Server (TFS), SharePoint, GitLab, Alation
Cloud Technologies: MS Azure, Azure SQL, Azure Data Warehouses, Data Factory, Azure Storage (BLOB, Tables, Queues, and File Share), DataBricks, Snowflake
Ticketing: JIRA
Timeline
Senior BI Developer/ Data Engineer
BAYADA
06.2019 - 05.2024
SQL BI Developer
Anthem
10.2018 - 05.2019
Software Intern
Synapse Tech Services
09.2017 - 06.2018
Master of Science in Information Science -
University of North Texas
Bachelor of Engineering in EEE -
Gokaraju Rangaraju Institute of Engineering And Technology