ASHOK
ASHOK
ashokbalajicsu@gmail.com
224-662-1633
PROFESSIONAL SUMMARY:
Around 5 years of experience in using T-SQL (DML, DDL) in SQL Server 2012/2014/2016 platforms
In-depth knowledge of the Microsoft Azure framework and Azure Cloud platform
Experience in Creating APIs using C#
Experience working with terabyte to petabyte scale data
Experience in creating Tables, Complex Query, Stored Procedures, Views, Indexes, Triggers, CTE, and User Defined Functions in observing Business needs
Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
Skilled in Business Intelligence tools like SQL Server 2012/2014/2016, Integration Services (SSIS), Reporting Services (SSRS)
Skilled in creating several reports such as Drill Down reports, Drill through reports, Parameterized reports, Sub reports, Matrix Reports, Chart reports using SQL Server Reporting Services. Worked on Standard and Data-Driven Subscription in SSRS
Proficient in using Extract, Transform and Load (ETL) solutions using SSIS Containers, Data transformations like For Loop, For Each Loop, Execute SQL task, Derived Column, Conditional Split, Sort and Merge Joins, Lookup, Multicast Transformations.
Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2008/2012 using SSIS tools like Import and Export Wizard
Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
Hands on experience in full/diff backup and restore in SQL Server 2012/2014/2016
Hands on experience on all phases of software development life cycle (SDLC).
Experience in production support and troubleshooting of database applications.
Strong communication, interpersonal, organizational, presentation skills, highly motivated, team player, quick learner. Willingness to learn new technologies, openness to new ideas.
TECHNICAL SKILLS
Databases: MS SQL SERVER 2016, ORACLE
SQL Server Tools: T-SQL, Data Transformation Services (DTS), SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server analysis Services (SSAS), SQL Jobs, Jira
Languages: Oracle PL/SQL, T-SQL
Scripting: PowerShell, Unix Shell
ETL Tools: ORACLE SQL Loader, Informatica 8x, SSIS
Business Intelligence: SSRS, Crystal Reports
Microsoft Products MS Word, MS Excel, VSS, MS Access, MS Power Point, MS Visio 2008
Operating Systems MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX
EDUCATION:
Masters in Management Information Systems
CERTIFICATION
Microsoft Certified Professional Querying Data with TSQL 70-761
PROFESSIONAL EXPERIENCE
Medline Industries LP - Chicago, IL Aug 2021 to Present
Database Developer
Project: Medline Sales Reporting.
This tool helps to generate automated scheduled report to gather sales data and provide analysis on top of it. We have classified the data into material groups for better query performance on the reports generated. We have created more than 75 reports which are currently running on a daily, monthly and yearly basis.Responsibilities:
Design/Implemented efficient Database solutions and optimize existing Database architecture to make them more proficient based on technical requirements using T-SQL programming
Design and Improve database/SQL centric software products for Sales Department which includes multiple phases of development such as design, coding, testing of technical solutions using SQL Server
Developed SSIS ETL packages to load/process data from multiple sources into SQL Server for analysis.
Created API services using C#
Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
Use Window azure to deploy the application on cloud and managing the session.
Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.
Involved in Performance tuning and recommend various options such as Index tuning and SQL query optimization techniques to improve the application throughput by analyzing the query plans.Act as POC between UI team and other software development teams, assist them by architecting database solutions, and recommend latest Database technologies within the scope of product
Performing hands on Database Development and design while serving as POC for multiple teams across the organization and handling multiple projects simultaneously
Environment: PowerShell, MS SQL Server, Windows Servers, SSIS
Digi sense, Chennai, IndiaJuly 2019 to April 2021 Sql Developer
Project: Digi sense Membership Enrollment
Digi sense Marketing kit helps our customers to get them on boarded to our digital marketing application without any difficulties in short term of time. This helps their business to quickly get into Digital marketing and start servicing their consumers and increase their sales. This tool comes with the business profile page where they can monitor their accounts, online sales and current promotions.
Responsibilities:
Design, develop and maintain commercial software product database, applying principles and knowledge of computer science and engineering
Responsible for maintaining data integrity in the companys database
Designed and developed the ETL processes in Informatica PowerCenter to load and cleanse data from SQL Server, Oracle 10g, Flat Files, XML Files and Excel files to target database.
Proficient in creating optimized Stored Procedures, Views, Functions
Performance tune slow running queries in SQL Server
Involved in writing unit test cases for the existing stored procedures using tSQLt framework
Create SSRS reports as per requirements
Enhanced ETL algorithms, Data extraction processes via automation using Shell Scripting
Designed ER Diagrams in SQL Server using Erwin tool based on client requirements
Work closely with team members to develop and maintain database artifacts, identifying areas for database schema and coding improvement
Involved in resolving the deadlocks occurred while submitting the batch submissions, by monitoring them in SQL Profiler.
Created logical and physical data modeling for development database using ERWIN tool.
Effectively logged the errors using the Try Catch logic in the stored procedures.
Created the SSIS /DTS packages and scheduled them using SQL Server agent.
Involved in writing the C#.Net code for SSIS packages to follow the flow and structure and to validate the raw data.
Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
Environment: Oracle 11, SQL Developer, UNIX and shell scripting.
Loader.
SoftSol Hyderabad, India August 2017 to June 2019
SQL Developer
Project: GTR 2.0 Data Warehousing and Reporting
DTCC Global Trade Repository (GTR) is a platform application where in all the trade details have been captured and stored for reporting. This application captures the trade details across the globe based on the reporting jurisdictions. This application has been enhanced to enable the market participants to comply the trade reporting requirements as defined by various Regulatory Technical standards around the world.
Responsibilities:
Responsible for maintaining data integrity in the companys database
Designed and developed the ETL processes in Informatica Power Center to load and cleanse data from
SQL Server, Oracle 10g, Flat Files, XML Files and Excel files to target database.
Involved in requirements gathering, design, and development for the project.
Creating websites using ASP.NET, C#, SQL Server.
Writing Database Queries and creating Tables, Stored Procedures, Views in Microsoft SQL Server 2008.
Implemented custom role providers and membership providers.
Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
Created and scheduled SSIS Packages using Visual Studio 2008 and SQL Server 2008.
Implemented various transformations such as Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mappings
Wrote Perl/shell scripts to trigger Informatica Workflows
Converting classic ASP forms to ASP.NET forms. Creating reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
Created jobs using Data stage v9.1 which processed and cleansed data.
Ensured data quality in the inbound/outbound transmissions in the SQL Server.
Environment: Oracle 10g, PL/SQL, Customized Data Loader, Teradata, UNIX Shell Scripting
