Bhaskar Reddi Baddam
Software Developer
Bhaskar has over nine years of IT experience, more than eight working with SQL Server's suite of products. He is a Power BI and Microsoft-certified professional with expertise in all phases of the software development lifecycle, from gathering requirements and development to implementation, testing, and support across different business domains. Bhaskar is a quick learner and a good performer on teams and independently.
Portfolio
Experience
SQL Performance - 10 yearsT-SQL (Transact-SQL) - 10 yearsStored Procedure - 9 yearsSQL Server Reporting Services (SSRS) - 9 yearsBusiness Intelligence (BI) - 9 yearsETL Implementation & Design - 9 yearsSQL Server Integration Services (SSIS) - 8 yearsSQL Server Analysis Services (SSAS) - 6 yearsLocation
Availability
Preferred Environment
Windows
The most amazing...
...project I've worked on involved moving data to a new system, creating all the purpose dynamic reports, and writing the scripts for trend analysis.
Work Experience
BI Architect
Freelance
- Provided an architecture solution that was reusable, maintainable, and scalable.
- Leveraged AWS cloud services to build secure, highly scalable, and flexible systems.
- Built and designed real-time streaming from sensors, IoT devices to a data lake using Redshift, PI, Kinesis, Glue, Lambda, and CloudWatch.
- Implemented an S3 data lake for storage and Amazon Redshift and RDS for data organization along with Tableau/Power BI for data visualization.
- Built a data lake solution for high performance to enable analytics using S3, Redshift, Glue, Lambda, Athena, CloudWatch, CloudFormation, SageMaker, and other AWS services.
- Improved query performance on Redshift by leveraging the cluster types, distribution keys, sort keys, and by de-normalizing the data.
SQL Server and SSIS Developer
Saibber
- Led the offshore development team, acting as a technical mentor for developers.
- Helped formulate estimates and timelines for project activities and set related goals.
- Provided an architecture solution that was reusable, maintainable, and scalable.
- Created an ETL Design for splitting data with multiple values into normalized tables and designed an SSIS template to capture the package's execution events.
- Designed SSRS Report Templates and created SSRS Audit Tables.
- Scheduled the SSRS reports by using SQL-RD.
- Migrated Ab Initio graphs to SSIS Packages and Cognos reports to SSRS reports.
MS SQL Server Developer
BA Technolinks
- Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
- Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins, and created indexes wherever necessary.
- Designed and implemented ETL processes with SSIS packages using heterogeneous data sources.
- Created different parameterized reports and worked on all types of report types such as tables, matrices, charts, sub-reports, and more.
BI and SQL Developer
Techve Solutions PVT
- Created tables, views, complex stored procedures, and indexes.
- Wrote complex SQL statements, custom T-SQL stored procedures, and triggers.
- Designed the production deployment system for configuration files.
- Worked on performance tuning by unblocking transformations.
- Generated multiple enterprise reports and included various reporting features such as groups, drill downs, drill through, sub-reports, navigation reports, and more.
- Maintained the physical database by monitoring performance and optimized SQL queries for maximum efficiency.
Experience
SQL Server Blog
Educational Video Blog
https://www.youtube.com/user/bbaddam/playlistsSkills
Languages
Stored Procedure, T-SQL (Transact-SQL), Python, SQL, MDX
Tools
Microsoft Power Apps, SQL Server Profiler, SSAS, Visual SourceSafe, Visio, Erwin, Toad, Microsoft Team Foundation Server, TFS, Microsoft Excel, Microsoft Power BI, Abinitio, Tableau, Redshift Spectrum, Microsoft Access, DTS
Paradigms
ETL Implementation & Design, Business Intelligence (BI), ETL
Platforms
Amazon EC2, Oracle, SharePoint, Windows, Windows Server 2003
Storage
Redshift, Amazon S3 (AWS S3), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2008 R2, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server Analysis Services (SSAS), SQL Performance, Oracle PL/SQL, Database Modeling, Microsoft SQL Server, Data Lakes, SQL Server 2000
Other
Software Development, Data Engineering, Cognos 10, Data Architecture, QuasarDB, Big Data, Big Data Architecture, Business Intelligence Development Studio, Windows Server 2005, SAP BusinessObjects (BO), Amazon Kinesis, EMR, Identity & Access Management (IAM), Visual Studio 2005, Windows 98
Frameworks
AWS EMR, .NET
Education
Master's Degree in Computer Science
Silicon Valley University - San Jose, CA
Bachelor's Degree in Computer Science
JNTU - Hyderabad, India