Sql Server Data

E Abhinay Dornala

Email: ac8pym@r.postjobfree.com Cell: 813-***-****

PROFESSIONAL SUMMARY

7+ Years of extensive IT Experience in full life cycle of software development process including Database Design, Data modeling, Development, Implementation and Support of Microsoft SQL Server 2005/2008/2012 in Development, Testing and Production Environments with various business domains like Financial and Banking.

Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server.

Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.

Experience in Performance Tuning, Query Optimization using Indexes, Profile Traces for Dead Locks and using DBCC Utilities for Database Consistency Checks.

Experience in programming languages using .Net, VB 6.0, C# .Net, ASP.Net, Access and XML.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Having good knowledge on Tableau server and can able to perform Admin tasks using Tableau server.

Developed Complex database objects like Stored procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.

Experience in Design and Development of Visual Basic Applications.

Strong background in table/query design, report design and automation utilizing VB Modules.

Expertise in in configuring and creating SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration services.

Expertise in creating Property Expressions, Script Tasks for SSIS packages.

Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SQL Server Reporting Services (SSRS) based on client requirement.

Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.

Hands on experience in creating the MDX cubes and dimensions using SSAS.

Expertise in creating Dashboard Reports to support end users using SSAS.

SKILLS

Operating System

UNIX, Windows 7/Vista/XP/2003/2000, Windows Server 2003, Windows NT and MS-DOS.

Programming Languages

T-SQL, PL-SQL, C#, VB 6.0, VB.Net, MySQL.

Web Technologies

HTML, XML, PHP, WCF.

RDBMS

MS SQL Server 2014/2012/2008/2005, Tableau, MS Access

BI Tools

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Performance Point Server 2007.

Database Query Tools

SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Query Analyzer, SQL Profiler.

CERTIFICATION: Certified in MS SQL and Visual Basics 6.0

PROFESSIONAL EXPERIENCE

BI Tech Lead Sep 2015-Current

Cognizant Technology Solutions, CA.

Project1: Cincinnati Fulfillment Conversion of VB 6.0 and Access to SQL Views and Stored Procedures using SSIS.

Project2: Develop and Review Code for T-SQL, Visual Basic Programming, MS Access. The Bulk Licensing utility must handle all the tasks of taking the standard file(s) extracted for each Bulk Licensing program adding additional files as needed, altering them to fit the format expected by the customer, sending them to the customer, archiving the data, and cleaning up older data.

Responsibilities:

Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL Programming, Microsoft SQL Server Integration Service(SSIS), Automatic Schedulers (Visual Basic Programming).

Performed Data Migration from Visual Basic and Access Code(Platforms) to MS SQL Server using SSIS packages.

Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Derived Column, Conditional Split, Bulk Insert, Merge and Union all.

Developed Packaging and Testing Code Scenarios for ETL process. Involved in Functional Testing, Regression Testing, and Data Validation using Data Prep Tool.

Created reports in Tableau using SQL Queries and Stored Procedures.

Created custom Hierarchies to meet the Business requirement in Tableau.

Enhanced the performance of database servers. Worked on deadlocks issues and minimized the occurrence of these situations.

Analyze and communicate report development issues, including problems with data integrity, data design, and functional and technical software issues.

In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Responsible for ETL Operations using SQL Server Integration Services (SSIS) and have experience in incremental data loading.

Develop and Review Code in Visual Basic Programming 6.0, Microsoft Access 2.0 and 2000 version.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Develop and unit test the data solutions and transition recurring execution of the data file extract to Operations Staff.

Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI” S & MDX Queries using SQL Server Analysis Services(SSAS).

Having knowledge on Real Estate Data and Mortgage Industry Data.

Environment: SQL Server 2016/2014/2012, SQL Server Integration Services, Visual Studio 2012/2015, SQL Server Reporting Services, Tableau, SSAS, T-SQL, MS Access, VB 6.0, C#, .NET, Data Prep Tool, TFS.

SQL BI Developer Jan 2014 – Sep 2015

Sriven Infosys Inc, NY.

Responsibilities:

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, MS Excel, XML files into UL Database and DB2 Billing Systems.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services.

Converted data types using Derived Column, Data Conversion Transformation in SSIS.

Delivered the reports using ‘pulled’ and ‘pushed’ methodologies and formatted the reports using the Global variables and expressions.

Managing SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.

Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.

Performed Data mapping for extraction and loading. Responsible for Disaster Recovery, backups, database optimization.

Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.

Formatted the reports using the Global Variables, Expressions and Functions.

Created required SQL queries to be integrated to Java code to meet the requirement for generating the user defined formulary reports.

Developed, publishing, customized integrative reports and dashboards, report scheduling using Tableau server.

Developed complex stored procedures using T-SQL to generate reports using Crystal Reports.

Provided support for Tableau developed objects and understand the tool administration.

Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, sub reports.

Write Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.

Create SSIS 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 and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2008/2012/2014, Team Foundation Server, Microsoft Visual Studio 2008/2010, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), T-SQL, Tableau.

Database Developer Dec 2011-Dec 2013

ICICI Bank-Hyderabad, India.

Responsibilities:

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Modify SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.

Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

Professional in communicating Dashboards per Tableau visualization features.

Optimizing Stored Procedures and long running SQL queries using indexing strategies and query-optimization techniques.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services.

Wrote SQL, PL/SQL Programs required to retrieve data using cursors and exception handling.

Worked on development of SQL and stored Procedures on MySQL

Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL Server 2008.

C, C++ and Visual Basic: Designed and implemented single/multi-function programs for data retrieval and storage using Native and User Defined Data Structures.

Oversaw the operation of 50+ work stations. Troubleshoot and resolved Software issues.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Developed, monitored and deployed SSIS packages.

Responsible for automation of maintenance jobs, locks and indexes configurations.

Optimized queries using SQL Profiler and Database engine tuning advisor.

Collaborated in the development of in-house development of new banking software interfaces.

Supported existing legacy system to provide newly created cases and ensured they were available in the systems until legacy system were retired.

Environment: SQL Server 2008/2005 Enterprise Edition, SSRS 2005/2008, SSIS 2005, SSAS 2005, .NET Framework, C, C++, Oracle 9i, 10g, Tableau, Visual Studio 2005, MySQL, PHP, MS Excel, and MS Access.

Contact this candidate