Naga Aswani Nittala Venkata

Email ID:ad25sm@r.postjobfree.com

Phone No:919-***-****

PROFESSIONAL SUMMARY:

Having 5+ years of good experience as a SQL Developer with extensive experience of analytical techniques.

Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies.

Strong in writing 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 SQLSERVER 2000/2005/2008 R2/2012.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.

Good Experience in creating reports & dashboards with different types of tables, charts & graphs via Power BI Desktop.

Experience in using ETL methodology for performing Data Migration, Extraction, Transformation and Loading and designed data conversions from wide variety of source system using SQL Server Integration Services (SSIS).

Proficient in performing various SSIS data transformation tasks such as Look-ups, Fuzzy Lookups, Aggregate Functions, Merge Join, Conditional Split, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.

Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.

Very good experience in Oracle tools like SQL Plus, SQL Loader, SQL Developer using TOAD in secure databases.

Expertise in Client - Server application development using Oracle, PL/SQL, SQL *PLUS, TOAD

Hands on experience in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

Knowledge of Relational Database Management systems.

Prepared flow charts, database ER diagrams using diagramming tools like Microsoft Visio.

Good interpersonal, Analytical and Communication skills.

TECHNICAL SKILLS:

SQL Developer Tools

SQL Developer, SQL plus, Toad

Languages

C, C++, SQL, JavaScript, PL/SQL,Python

Web Technologies

HTML5, CSS3, DHTML, XML, XHTML, XSLT, JavaScript, TypeScript, AJAX, JQuery, JSON, Apache

SQL Server Tools

SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Export & Import wizard, DTS, SQL Server Profiler, SQL server configuration manager

Tools

TOAD, SQL Developer, Erwin, SQL Navigator, SQL Loader, SQL Plus, MS-FrontPage, MS Office Suite, iSQL Plus,

Reporting Tools

MS SQL Server Reporting Services (SSRS), Power BI, Excel PowerPivot

Data Modelling

Erwin, MS Visio, MS Access

Web Servers

Apache Server, Windows IIS Server

Other Software/tools

Visual Studio, WinSCP, Putty

Databases

Oracle, DB2, MySQL, MS SQL Server

Operating system

Windows Variants, Mac, Unix, Linux

PROFESSIONAL EXPERIENCE:

Client: Direct General Insurance, Nashville, TN Jan 2022 – PRESENT

Role: SQL Developer

Responsibilities:

Extensive experience in analytics, generating data visualizations using Python and creating dashboards using PowerBI.

Experience in using various packages in Python like Numpy,Pandas,Matplotlib,Seaborn.

Used Power BI desktop to connect to database tables and created Datasets using Import, Direct Query and composite mode and responsible for building reports in Power BI from Scratch.

Used Power Query Editor to extract data from different sources such as SQL Server, Excel, CSV files & cleansed the data and loaded it into the Power BI canvas for visualization and analysis.

Used Cross-Report Drill through to link source and target reports to drill through the necessary information for the end user.

Created different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports for existing databases using Power BI.

Designed reports utilizing custom filters and DAX expressions, Power Query functions in Power BI.

Created database links and accessed the data through SQL statements in Power BI Desktop.

Designed and deployed reports with Drill Down, Drill Through and field parametrized drop-down menu options and Linked (Cross reports) reports.

Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations.

Created custom KPI scorecards to help end users visualize metrics according to their preference.

Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.

Used Enterprise level Power BI Gateway to connect to different on-prem data sources to build PBI datasets and dataflows.

Utilized Power Query Editor to perform data cleansing operations like clean and format data, eliminate redundant information, append and merge tables from various data sources.

Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.

Design and created financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically.

Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.

Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

Involved in various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Developed, implemented and maintained various database objects such as stored procedures, gtriggers, functions, indexes and views.

Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.

Assisted in `the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.

Developed highly optimized stored procedures, functions, and database views to implement the business logic and also created clustered and non-clustered indexes.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

Created Parameterized Queries, generated Tabular reports, sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports

Translated business requirements into BI application designs and solutions.

Environment: SQL Developer, SQL Server, SQL Plus, Power BI Desktop,Power Bi Service,Microsoft SQL Server Integration Services (SSIS),Python, Microsoft SQL Server Analysis Services (SSAS), TOAD, ERWIN, Informatica, SQL Developer, HTML5, UNIX, Oracle, Windows.

Client: Forge Health, Paramus, NJ May 2020 – Dec 2021

Role: SQL Developer

Responsibilities:

Used Power BI desktop to connect to databases like SQL Server, Oracle, SAP Hana database and AWS Red shift and created Datasets using Import method.

Used Power Query Editor to extract data from different sources and cleansed the data and loaded it into the Power BI canvas for visualization and analysis.

Designed reports utilizing custom filters and DAX expressions, Power Query functions in Power BI.

Performed and worked with dimensions, measures, and complex DAX queries.

Provided continued maintenance and development of bug fixes for existing and new power BI reports.

Migrated reports from Excel to Power BI as per the predefined templates.

Designed and developed backend DB to support client (mobile and desktop) notification and badging of clinical events (encounters, test results ...).

Maintained the documents and create reports for the business analysts and end-users.

Generates and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

Maintained a series of UNIX Shell Scripts to manage batch order processing.

Database performance monitoring and identifying bottlenecks hindering the performance of the database.

Data Architected solution to automate incoming data feeds for Centauri Risk Adjustment.

Collaborated with the application developers in data modeling and E-R design of the systems.

Code to help automate generation of hospital and clinic websites based upon the services they provide.

Developed and deployed SSIS applications to assist in automated feeds and fulfill Client Services requests. Including utilization of C# within SSIS to handle extraordinary needs.

Also created, modified, maintained and optimized SQL Database.

Created changes in the database according new requirements.

Assimilated data from multiple sources (Google Analytics, Google Big Query, DB2, Teradata & MSSQL) for advanced reporting and analysis (Generation of crosswalk between customer HCA web usage and actual hospital/clinic events).

Delved into medical coding and requirements including generation of new performance reports.

Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.

Created SQL statements using hints for maximum efficiency and performance, create and maintain/modify SQL Packages, mentor others with the creation of complex SQL Statements, perform data modeling and create/maintain and modify a complex database.

Led offshore team in development with daily meetings and communications.

Code review and approval of application production DB code - SPs and deployment.

Responsible for the management of the database performance, backup, replication, capacity and security.

Environment: SQL Developer, SQL Server, SQL Plus, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), ERWIN, HTML5, UNIX, TOAD, Oracle, Windows.

Client: First Utah Bank, Salt Lake City, UT Aug 2018 – Apr 2020

Role: SQL Developer

Responsibilities:

Gathered the client's requirements and designed database and application architecture.

Created Indexes for faster retrieval of the customer information and enhance the database performance.

Installation and configuration of SQL on windows and maintenance of Servers in Production and Development Environment.

Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.

Used the Pragma Exception nit to name the system exceptions that are raised by the program.

Monitoring existing SQL code and performance Tuning if necessary.

Installed, authored, and managed reports using SQL Server Reporting Services.

Interact with business analysts to develop modelling techniques.

Used SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code.

Performed validation and quality control checks of SQL programs.

Used the UNIX for Automatic Scheduling of jobs. Involved in Unit Testing of newly created SQL blocks of code.

Created dynamic SQL to support dynamic nature of front-end applications.

Utilized SQL Loader to perform bulk data loads into database tables from external data files.

Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).

Involved in installation and configuration of SQL server on Database Servers.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.

Implemented database standards and naming convention for the database objects.

Created trigger and stored procedures and enforced business rules via checks and constraints.

Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.

Developed Database Triggers, Packages, Functions and Stored Procedures using SQL and maintained the scripts for various data feeds.

Wrote complex queries to generate reports as per client request as a part of production support.

Environment: PL/SQL, SQL PLUS, SQL Developer, ERWIN, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server, Oracle, UNIX, Windows.

Education:

Bachelors from JNTU, Kurnool, India.

Contact this candidate