BI Architect
2014 - PRESENTFreelance- 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.
Technologies: Business Intelligence Development Studio, Redshift Spectrum, Identity & Access Management (IAM), SSAS, SSRS, SQL, Redshift, EMR, AWS Kinesis, AWS S3SQL Server and SSIS Developer
2012 - 2015Saibber- 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.
Technologies: SAP BusinessObjects (BO), Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Cognos 10, SQL Server Integration Services (SSIS), ETL, MDX, T-SQL, SQLMS SQL Server Developer
2011 - 2012BA 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.
Technologies: Windows 2005 Server, Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Microsoft Excel, ETL, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), MDX, T-SQL, SQLBI and SQL Developer
2003 - 2010Techve 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.
Technologies: Windows 98, Visual Studio 2005, SQL Server Analysis Services (SSAS), DTS, T-SQL, SQL Server 2000, Windows Server 2003, Microsoft Excel, Microsoft Access, SQL
Bhaskar Reddi Baddam
Software Developer in Atlanta, GA, United States
Member since July 1, 2016
Bhaskar has over nine years of IT experience and over eight years of experience in SQL Server's suite of products. He is a Power BI and Microsoft certified professional involved in all phases of the software development lifecycle, from gathering requirements and development to implementation, testing, and support with various business domains. Bhaskar is a quick learner and a good performer both on teams and independently.
Bhaskar is now available for hire
Portfolio
- FreelanceBusiness Intelligence Development Studio, Redshift Spectrum...
- SaibberSAP BusinessObjects (BO), Business Intelligence Development Studio...
- BA TechnolinksWindows 2005 Server, Business Intelligence Development Studio...
Experience
- SQL Performance 10 years
- T-SQL 10 years
- Stored Procedure 9 years
- SQL Server Reporting Services (SSRS) 9 years
- Business Intelligence (BI) 9 years
- ETL Implementation & Design 9 years
- SQL Server Integration Services (SSIS) 8 years
- SQL Server Analysis Services (SSAS) 6 years
Availability
Full-time
Preferred Environment
Windows
The most amazing...
...project I've worked on involved moving data to a new system, creating all of the purpose dynamic reports and writing the scripts for trend analysis.
Employment
Experience
- SQL Server Blog (Other amazing things)
Provided basic training for T-SQL and MSBI.
- Educational Video Blog (Other amazing things)https://www.youtube.com/user/bbaddam/playlists
Created a series of educational videos.
Skills
Languages
Stored Procedure, T-SQL, SQL, MDXTools
Microsoft PowerApps, SSAS, SSRS, Visual SourceSafe, Visio, Erwin, Toad, Microsoft Team Foundation Server, TFS, Microsoft Excel, Microsoft Power BI, Abinitio, Tableau, Microsoft Access, DTSParadigms
ETL Implementation & Design, Business Intelligence (BI), ETLPlatforms
AWS EC2, Oracle, SharePoint, Windows, AWS Kinesis, Windows Server 2003Storage
Redshift, AWS S3, SQL Server Reporting Services (SSRS), SQL Profiler, 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, SQL Server 2000Other
Software Development, Cognos 10, Business Intelligence Development Studio, Windows 2005 Server, SAP BusinessObjects (BO), EMR, Identity & Access Management (IAM), Redshift Spectrum, Visual Studio 2005, Windows 98Frameworks
AWS EMR, .NET
Education
- Master's degree in Computer Science2010 - 2012Silicon Valley University - San Jose, CA
- Bachelor's degree in Computer Science2006 - 2010JNTU - Hyderabad, India
