Chanakya R Ganta

Promoted from Senior BI engineer to Engineering manger to lead modernization of data analytics across organization.

• Leading team responsible for designing and implementing infrastructure and Data Analytics workloads on AWS Redshift, DBT, Stitch, Retool, Airflow and PowerBI platforms.
• Led design and implementation of migrating 13 functional team workloads from SQL Server legacy system onto Redshift, Data Build Tools(DBT) and PowerBI platforms.
• Developed and deployed hands-on SQL and Python solutions for functional teams on DBT, Redshit and Airflow.
• Led project and technical designs of implementing data analytics solutions in a multi-cloud, multi-data center environment.
• Contributed to drafting new data strategy across company to revamp current data architectures by migrating to cloud agnostic vendors like Databricks and Snowflake, including both operational and analytics layers.
• Led training and office hour sessions to coach data analysts to better leverage analytics platforms like Redshift and DBT.
• Led training and office hour sessions to coach data analysts on adopting SDLC development style, CI/CD and version control to manage data pipelines efficiently.
• Led design and implementation of PowerBI workspace organization enabling environment of collaboration between various analytics functions.
• Promoted self-serve BI across the company by enabling functional teams with knowledge of analytics platforms and providing continuous guidance improving the time-to-insights metric.
• Managed cross-functional teams, ensuring successful delivery of complex analytics projects on time and within budget.
• Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
• Championed a data-driven culture by providing training and resources for employees at all levels of the company.
• Implemented KPI promotion process to thoroughly vet metrics reported at executive level.
• Enhanced overall team productivity with continuous guidance, training and mentoring of engineers.
• Enhanced data-driven decision making by implementing advanced analytics tools and methodologies.
• Managed risk assessments during project planning phases, proactively mitigating potential issues before they arose during execution stages.
• Established strong partnerships with business stakeholders to align analytical solutions with strategic objectives.
• Set clear goals and expectations for team that align with company level goals
• Create an environment of continuous learning by hosting learn and grow sessions on advancements in data field.

• Responsible for organization, management, and standardization of enterprise data
• Improved data-driven decision-making by designing and implementing BI solutions for various business units.
• Work with the Product Managers for specific matters of scope, tasks, and resources to drive the Data Management implementation
• Design and implement logical and physical database models for complex health care data warehouse and operational data systems in a scalable manner
• Designed and implemented enterprise OLTP and OLAP data architecture models using different normalization and schema techniques based on business needs
• Lead a team of data and BI developers to implement end to end data analytics solutions
• Designed and implemented ETL framework using SSIS to control execution and load plans for ETL pipelines
• Integrated disparate data sources into a cohesive analytical framework for accurate insights into business operations.
• Enhanced data quality and reliability through the development of ETL processes and data validation procedures.
• Implemented Change Data Capture for auditing and ETL between different servers
• Designed and implemented tabular model solutions for enterprise data warehouse system
• Building, publishing customized interactive reports and dashboards, report scheduling using tableau server
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
• Work with the other IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions for internal and external use
• Designed and implemented enterprise server architecture by doing infrastructure resource planning for virtual machines, storage, CPU, memory, and IO based on current and future application requirements
• Acts as an expert technical resource to client and development staff in all phases of the development and implementation process
• Monitor SQL server and database performance and proactively address potential performance issues
• Implemented data governance policies to ensure data integrity, availability, and usability
• Created POC for implementing azure data platform technologies like Azure Data Warehouse, Azure Data Factory V2, Data Lake, Azure SQL managed instances and how to integrate them with on premise systems in a secure manner
• Implemented Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory and SSIS
• Implemented data management solutions like data archival, backup and restores, purge mechanisms, and data dictionaries
• Provided technical consulting to application development teams during application design and development for highly complex or critical projects

• Gather, analyze, and translate business requirements into programming
• Developed and tested system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications
• Designed and ETL Packages in SSIS to transform data to MS SQL Server from Excel for further analysis
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports
• Designed the reports layout for creating tabular and matrix reports
• Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
• Implemented security, scheduling and sorting, filtering, aggregation of report data
• Provide feedback to management and co-workers on best practices including one on one training sessions or group mentoring

• Attending meetings with clients to gathering requirements and propose solutions
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse
• Extensively used SSIS Import/Export Wizard, for performing the ETL /SSIS operations
• Experience in creating, debugging DTS/ETL packages using Active X Task, dynamic properties task for file check, sending mails upon package completion, and file archiving
• Used DTS/ETL packages to do file operation, to apply business rules
• Experience in Data warehouse such as dimensional modeling, star and snowflake schemas, Data marts, fact and dimension tables identification, and OLAP
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
• Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery

• Co-ordinate with front end developer to put business rules
• Involved in creating ER Diagrams and mapping data into database object
• Installed and configured SQL Server 2005 successfully
• Modified and redesigned existing database by adding tables and relationships to support online system in the development database
• Created Views for efficient data security
• Optimized the performance of queries by modifying the existing index system and rebuilding Indexes again with respect to the I/O and also using Performance Tuning

• Involved in installation and configuration of SQL server 2000/2005 on Servers
• Applied patches and service packs to keep the database at current patch level
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions
• Implemented database standards and naming convention for the database objects
• Data conversions and data loads from various databases and file structures
• Monitor failed and long running MS SQL Server jobs