Bharath Kumar Nallamala

Background

About Bharath Kumar Nallamala

10+ years of experience in ETL and Business Intelligence technologies utilized for a Data Warehouse and for Data Analysis. • Expertise in creating SSIS packages using config files and variables which dynamically pickup data from the SQL Server control tables. Developed SSIS packages, Stored procedures for loading data into target tables from different sources like SharePoint, Magento, Oracle, AS400, excel, flat files, and tables. • Experience in designing, developing, implementing data warehouse and data marts. • Good knowledge of the best practices utilized in creating SSIS packages and stored procedures. • Expertise in logging the run time statistics of the SSIS packages into the SQL Server control tables. • Expertise in writing complex SQL server queries to extract the desired data using joins, slicing, and dicing the data and windowing functions. • Expertise in performance tuning by writing stored procedure code which is optimized for good performance. • Very good hands-on debugging and troubleshooting experience to resolve the data and package failure issues. • Expertise in deploying the SSIS packages to production. • Upgraded the SSIS packages from SQL Server 2012 to 2016. • Good experience in creating the SQL Server agent jobs and scheduling them as per the user requirements. • Migrated ETL jobs from ETL tools like DataStage to SSIS. • Good knowledge of BCP to bulk load the data into flat files. • Expertise in troubleshooting and analyzing production issues. • Very good knowledge of the production support model to support the jobs and SSIS packages in production. • Expertise in understanding business requirements by interacting with the customers, creating the functional specifications for the SSIS packages, and creating mapping documents. • Good knowledge of the snowflake cloud for loading, unloading, and ingesting the data. • Good knowledge of GitHub for version control and collaboration. • Good experience in using JIRA and confluence. • Good experience working in an Agile model and working in sprints. • Good knowledge of IBM DataStage ETL tool - Created DataStage parallel jobs and sequences to load data into tables from flat files, to run UNIX shell scripts, to transform the data and to generate and transfer reports to the user. • Designed Sequences in DataStage to implement the job dependencies and restart ability. • Strong knowledge in Data warehousing concepts like Star Schema, Snowflake, Dimension and Fact tables.