BI Architect
2014 - PRESENTTavant Technologies- 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.
- Managed a range of projects to enhance and maintain BI, DW, and DB environments as a project manager and technical lead.
- Automated maintenance jobs by tuning the SQL Server locks and index configurations, administering SQL Server security, and enabling SQL Server automatic email notification.
- Optimized queries and enhanced the performance of database servers using a performance monitor, SQL Profiler, and Foglight.
- Used ETL and SSIS to load data from MS Access, Excel spreadsheets, and flat files into the target SQL Server database.
Technologies: MS SQL Server, T-SQL, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MS Excel, Universe database, OHM application, OHM ERP, Erwin, SSRS, SSAS, Tableau, Power BISQL 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: MS SQL Server, T-SQL, MDX, SQL Server Reporting Services (SSRS 2008), ETL, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SAP BO, CognosMS 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: MS SQL Server, T-SQL, MDX, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), ETL, Business Intelligence Development Studio (BIDS), MS Excel, Advanced Windows 2005 ServerBI 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: MS SQL Server, MS Access, MS SQL Analysis Services, MS Excel, Visual Studio 2005, Windows Server 2003, Windows 98, SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer
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
- Tavant TechnologiesMS SQL Server, T-SQL, SQL Server Integration Services (SSIS)...
- SaibberMS SQL Server, T-SQL, MDX, SQL Server Reporting Services (SSRS 2008), ETL...
- BA TechnolinksMS SQL Server, T-SQL, MDX, SQL Server Integration Services (SSIS)...
Experience
- T-SQL, 10 years
- SQL Server Reporting Services (SSRS), 9 years
- Business Intelligence (BI), 9 years
- Stored Procedure, 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-SQLTools
Microsoft PowerApps, SSAS, SSRS, Visual SourceSafe, Visio, Erwin, Toad, Microsoft Team Foundation Server, TFS, Microsoft Excel, Microsoft Power BI, Abinitio, TableauParadigms
ETL Implementation & Design, Business Intelligence (BI)Platforms
AWS EC2, Oracle, SharePointStorage
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), Oracle PL/SQLOther
Software Development, Cognos 10Frameworks
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
