Navilash Hanmanthreddygari

Marlborough, CT – ****7 – 860-***-**** – ad4pk1@r.postjobfree.com – www.linkedin.com/in/navilashreddy

Professional summary

Proficient in Microsoft BI Tools (SSIS/SSRS/SSAS) and T-SQL using SQL Server 2005/2008R2/2012/2014/2016,2019.

Proficient in advanced features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables, and Dynamic SQL.

Expertise in developing applications using PowerApps, canvas, model driven app, Common Data Service CDS, SQL, Forms, SharePoint online, Dynamics 365 CRM, Azure, C#, ASP.Net, Web Services.

Experience in developing applications in PowerApps using Common Data Service CDS, SQL, Flow, Excel, and SharePoint.

Expertise in using DAX and generated dashboards & reports and integrating with PowerApps.

Excellent SQL skills for RDBMS including AWS Redshift, SQL Server, MySQL, Netezza and PostgreSQL.

Strong Knowledge in designing and creating dimension and cubes with Snowflake and STAR schema using SSAS.

Strong experience in developing Enterprise, Distributed and Web applications using MS- SQL Server, MDX, DAX, Power BI, SQL BI, T-SQL, Dashboard.

Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQL SERVER 2000/2005/2008 R2/2012.

Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.

Experience in Building snow pipe and Data sharing in Snowflake.

Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.

Experienced in extracting streaming JSON data, flattening, performing data profiling and transforming JSON to Data-mart as required for the business reporting using the snowflake SQL.

Experience in developing report such SQL Server Reporting Services (SSRS), SSAS, MDX, Power BI, CUBES, SQL Server Integration Services (SSIS), DTS Packages and Performance tuning.

Expert in writing T-SQL, working on SSIS, SSRS, SSAS, and Data Migration projects.

Expertise in Data Extraction, Transforming and Loading (ETL) between different Systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP).

Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

Experience in SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Experience in developing and debugging Stored Procedures and Triggers.

Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.

Experienced in developing a dynamic SSIS packages as per the ad-hoc request.

Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.

Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages.

Extensive experience in the Microsoft Power Platform – MS Power Apps, Flow, and Power BI

Experience in Python to manipulate data for data loading and extraction, using python libraries like Matplotlib, Seaborn, NumPy, Scipy and Pandas for data analysis.

Experience in setting up various HADR solutions using SQL ALWAYS ON and DB Mirroring

Career Progression

City Of CHESAPEAKE, Chesapeake, VA Aug 2022- Present

SQL Server DBA

Installed and configured SQL Server 2019, 2017, 2016, and 2012 on Development, Production, and UAT environments along with applying latest patches as they are released by Microsoft.

Upgraded/Migrated SQL databases servers from 2012 to 2016,2017 and 2019.

Demonstrated expertise in deploying SQL Server Always ON High Availability solutions (2012, 2014, 2016, and 2019) to ensure continuous application availability.

Involved in setting up DB Maintenance with Ola’Hallengren scripts.

Involved in setting up Logins as per Security policies in Production environment.

Deployed and scheduled SSIS packages for efficient data integration.

Upgraded SSIS packages from 2012 to 2019.

Involved in installing and configuring SQL Server Reporting Services in all environments along with migrations from 2012 to 2016,2017and 2019.

Configuring SQL backups according to clients RPO.

Used tools like SQL IDERA and SQL Profiler. Extended events and Performance Monitor for Performance Tuning.

Designed and documented the entire Architecture of Power BI POC

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.

Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect to distribution center solutions design analytics in Power BI.

Developed application in PowerApps using Common Data Service CDS, Flow, Excel, Forms and SharePoint online.

Installed and configured Enterprise gateway and Personal gateway in Power BI service.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.

Defined and deployed monitoring, metrics, and logging systems on AWS RedShift.

Responsible for creating SQL datasets for Power BI, OBIEE, SSRS ad-hoc Reports. Worked with SQL Server 2008R 2/2014/2016.

Generated MDX scripts for KPIs and calculated members based on business requirements in SSAS.

Worked on importing, shaping, and transforming data for business intelligence (BI), visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.

Graphic design UI/UX to ensure the usability of the site and change management to assist in the analysis and outreach in the adoption of the data.

Created stored procedures and SQL queries to pull data into power pivot model.

Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Created Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and T-SQL, PL/SQL Queries to implement business rules and created data sets required for Power BI reports and OBIEE reporting.

Unit tested the tables loaded to snowflake for random days by validating them with the on-premises Oracle DWH tables

Created data marts and multi-dimensional models like Star schema and Snowflake schema.

Worked in the Enterprise Data & Analytics department to create data visualizations, analysis and statistical modelling using the programming language R and python.

Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.

Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.

Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Created Reports using Charts, Gauges, Tables, matrix.

Manage and administer JIRA/Confluence/BitBucket add-ons, plugins, and extensions.

Management of other reporting and collaboration tools in the engineering environment

Maintain and manage Automation Build Environments such as Jenkins.

Implemented complex query techniques of passing Multi - Valued parameters and cascading parameters in MDX.

Create complex JIRA workflows including project workflows, field configurations, screen schemes, permission schemes and notification schemes.

Take the overall responsibility for the Jira configuration and be the go-to person for any Jira issues, enhancements or best practice question.

Serve as a technical advisor and the primary implementer for new capabilities in JIRA.

Create team specific Agile process flow in JIRA to move tasks from one activity to another.

Capital One • Richmond, VA June 2021-July 2022

SQL Server DBA

Design and developing the POC’S according to business users.

Developing the best practices and drive the code to across development, test and Pre-Prod and Production environments.

Dataverse/ Dynamics 365 as Data source for PowerApps, PowerBI.

Developed the Canvas application in Power Apps to automate the manual data entry application.

Developed PowerApps app using SharePoint and SQL as data sources.

Creating the Daily jobs for data dumps for various teams.

Responsible for Data Analytics migration from Tableau to Power BI.

Designed and developed the migration of Data Analytics to Power BI.

Designed and developed the dashboards, Scorecards and KPI’s in the Power BI Calculated columns and Measure in the Data Analysis Expressions (DAX) and RLS (Row -Level-Security).

Implemented scheduled data refreshes with on-premises data gateways as per the business requirement.

Conducted investigative projects utilizing Python for data analysis and machine learning.

•Used OBIEE Analysis to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.

Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).

Designed and created MDX queries to retrieve data from cubes using SSIS.

Implemented Direct Query, Imports Data and Live Connection modes.

Extensively involved in deploying SSIS Packages, SSRS Reports and SSAS Cubes using command line utilities. Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.

Developed tabular queries for efficient analysis of reports using Pivot/Un pivot in T-SQL.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Building and writing MDX Queries, Calculated Columns using DAX Expressions

Expert in generating complex dashboard reports for ad hoc business views along with user acceptance test and data accuracy test.

Involved in maintenance of ETL Packages in SSIS according to changing business requirements to support the existing ETL strategy.

Worked on Data Transformation Services (DTS) in SSIS or transferring data from Heterogeneous Database

Review and troubleshoot SSIS packages and T-SQL queries to address errors that occur during nightly and ad hoc processing.

Enhanced the Reports by updating the embedded Scripts in SSRS to the Stored Procedures.

Created SSRS Reports: involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Tablix control and involved in Dashboard reporting, Share Point with Power View tool, TFS etc.

Facilitated Scrum ceremonies such as daily stand up, sprint planning, sprint review and retrospectives.

Used TFS to keep track of the User Stories, tracked the progress of the sprint by tracking the Velocity and Capacity of the team by maintaining Burn Down and Burn Up Charts.

Successfully deployed SSIS packages using Azure devOps builds and release.

Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

Extensively involved in Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling.

Sagarsoft Inc • Hyderabad, IND May 2017-Dec 2020

SQL Developer

Designed and developed packages for Data warehouse using Integration Services (SSIS) SQL Server 2014.

Created Packages which include Control flow tasks, Data flow tasks, Event Handlers, Breakpoints and Checkpoints in SSIS.

Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.

Developed SQL Scripts to dynamically manipulate data and generate well-formatted reports based on user requirements.

Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS) and OLAP.

Automate the generation of various dynamic reports on a daily and weekly basis.

Optimize SQL 2014 stored procedures for enhanced performance and robustness.

Worked with T-SQL to create Tables, Views, Stored Procedures, CTE and Temp tables.

Responsible for testing and debugging the SQL Scripts.

Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.

Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.

Generated reports using SSRS 2014 as per business requirements.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Execute SQL Task) and more.

Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Used Breakpoints & Event Handlers to debug packages & capture errors.

Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.

Used Merge statement to update rows, to insert new rows, and to delete invalid rows in destination table.

Developed MDX queries for Analysis.

Loaded Fact/Dimension Tables using Lookups, and Conditional Splits.

Developed objects (i.e. tables, views and stored procedures, functions, indexes) in SQL Server 2014 to get a better and faster performance.

Optimized long running Stored Procedures and Queries for effective data retrieval.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.

Technology Proficiencies

Databases:

Microsoft SQL Server 2008R2/2012/2014/2016/2017/2019, Azure SQL Database, Azure SQL Managed Instance, Azure Data Factory, Azure Data Synch, MySQL, Oracle 11g/10g/9i/8i, PostgreSQL

Operating Systems:

UNIX, Linux, Windows 2012/2016/2019, Windows 2010 Server, Mac OS

Languages:

Java, HTML, XML, C, C++, PL/SQL, Python, Scala, Pig Latin, HiveQL, power shell, SQL.

Tools and Products:

Microsoft Visual Studio, MS Office, FrontPage, MS-Project, Microsoft Team Foundation Suite (TFS), Excel, Power BI, Tableau, IntelliJ IDEA, VSCode, Git.

ETL/BI:

SQL Server:

Big Data Eco-System:

PowerBI, Tableau, Snowflake, Informatica, Dax, SSRS, SSAS, QlikView, QlikSense

MS SQL Server Enterprise manager, Profiler, DTS, Query Analyzer, SQL Server Management Studio, SQL 2012,2014,2016, 2017 and 2019 Integration Services (SSIS), SSMS, Reporting Service (SSRS), and Analysis services (SSAS) (BIDS), SQL Profiler, SQL CMD, Database Tuning Advisor, Performance Monitor, SQL Server Activity Monitor.

HDFS, MapReduce, Hive, Pig, Scoop, Flume, HBase, Kafka, Impala, Stream sets, Spark, Zookeeper, NiFi, Airflow

Education and Certifications

Bachelors in Computer Science

BV Raju Institute of Technology, Hyderabad, India

Masters in Computer Science

University Of New Haven, West Haven, CT, USA.

Certifications

Microsoft Certified: Azure Administrator Associate

Contact this candidate