Scroll To View More
Bhaskar Reddi Baddam, T-SQL Developer in Atlanta, GA, United States
Bhaskar Reddi Baddam

T-SQL 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 Technologies
    MS SQL Server, T-SQL, SQL Server Integration Services (SSIS)...
  • Saibber
    MS SQL Server, T-SQL, MDX, SQL Server Reporting Services (SSRS 2008), ETL...
  • BA Technolinks
    MS SQL Server, T-SQL, MDX, SQL Server Integration Services (SSIS)...

Experience

  • T-SQL, 10 years
  • Stored Procedure, 9 years
  • Business Intelligence (BI), 9 years
  • SQL Server Reporting Services (SSRS), 9 years
  • SQL Server Integration Services (SSIS), 8 years
  • SQL Server Analysis Services (SSAS), 6 years
Atlanta, GA, United States

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

  • BI Architect

    2014 - PRESENT
    Tavant 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 BI
  • SQL Server and SSIS Developer

    2012 - 2015
    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.
    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, Cognos
  • MS SQL Server Developer

    2011 - 2012
    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.
    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 Server
  • BI and SQL Developer

    2003 - 2010
    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.
    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

Experience

Skills

  • Languages

    Stored Procedure, T-SQL
  • Tools

    Microsoft PowerApps, Microsoft PowerBI, SSAS, SSRS, Visual SourceSafe, Visio, ERwin, Toad, Microsoft Team Foundation Server, TFS, Microsoft Excel, Microsoft Power BI, Abinitio, Tableau
  • Paradigms

    ETL Implementation & Design
  • Platforms

    AWS EC2, Oracle, SharePoint
  • Storage

    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/SQL
  • Other

    Business Intelligence (BI), Cognos 10
  • Frameworks

    AWS EMR, .NET

Education

  • Master's degree in Computer Science
    2010 - 2012
    Silicon Valley University - San Jose, CA
  • Bachelor's degree in Computer Science
    2006 - 2010
    JNTU - Hyderabad, India
I really like this profile
Share it with others