Balaji Adavi Email & Phone Number

Toronto, ON, CA

• Created SAS data sets by extracting data from SQL Server using SAS/EG. Used SAS/ACCESS to read datasets from Databases, Flat files, also read and write other PC File formats.
• Developed Mappings between Source and Target and loaded the data and Validated Data for missing values based on the requirements.
• Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.
• Developed queries on the existing SQL server databases to provide ad-hoc reports using SAS DI/SQL for marketing department use. Coordinated analyses involving customer information, campaign response data, and.
• Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, and SAS/MACROS.Environment: Enterprise Data Warehouse (EDW), SAS/SQL, MS SQL Server SAS Enterprise Guide.

• Analyze, design, develop, test and implement new systems, functionality and features on an as needed basis using SAS Enterprise Guide, SAS Macro, SAS/SQL, Oracle.
• Creating production reports using SAS EG/SQL. Design, develop and preparing various reports, circulars and other documents, some of them intended for senior management.
• Participated in various projects with a potential impact on profitability and efficiency.
• Build Oracle Tables, Indexes and Constraints using SQL. Develop SAS program to create SAS datasets from oracle database table and raw data
• Develop and maintain SAS/SQL tables, views, stored procedures
• Perform monthly/quarterly operational functions supporting the SAS ETL processing to generate client profitability and performance measurement results. Submit, execute, and monitor monthly and quarterly SAS.

Toronto, Ontario, Canada

• Designed and developed efficient ETL solutions using SQL Server Integration Services 2017.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion.
• Developed, Code reviewed fixed bugs, tested and deployed SSIS packages using SQL Server Integration Services 2017.
• Developed Complex Stored Procedures, Common Table Expressions (CTE’s) Views and Temporary Tables in T-SQL as per the requirement in SQL SERVER 2016.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2012, Analysis Services (SSAS) and Reporting service (SSRS)
• Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, DAX queries.

Chittoor

• Created & Implemented Database Components Databases, Tables, views, Constraints, Stored procedures, CTE’s Views and Functions using SQL Server 2012/2014.
• Developed Stored Procedures to extract data from stage layer.
• Worked on performance tuning of functions, stored procedures.
• Performed ETL to SSAS tabular cubes by developing Views from Datawarehouse.
• Worked on Dynamic SQL to extract, transform and load (ETL) data to Datawarehouse database.
• Developed Functions to perform ETL from Extracts to Datawarehouse.

Vishakhapatnam, Andhra Pradesh, India

Master Of Engineering - Meng, Industrial Engineering, 8.5

Bachelor Of Technology - Btech, Mechanical Engineering, 8.5