Ajay G

Database Administrator


Database Administrator


Austin, TX

Education Level:


Will Relocate:



Professional Summary * About 7+ years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2014/2012/2008 R2/2005 production QA and Development Environments . * Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation. * Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries. * Excellent in High Level Design of ETL - DTS Packages & 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, Bulk Insert, merge and union all. * Ability to work in all stages of System Development Life Cycle (SDLC). * Created one central SSIS Master Package to execute multiple child packages with Control Flow and Data Flow. Utilized Parent Package and XML Configuration to dynamically pass variable values on runtime. * Performing intensive data analysis on large data volumes, testing for quality assurance, and migrating releases into stage and production environments. * Connected to the FTP Server and pull the group of Excel sheets into the SSIS from the folder located on FTP Server. * Implemented complex business logic with case, cast, convert, CTE using T-SQL. * Defined parameters, variables and run time parameters within the SSIS package Execute SQL task and executed stored procedures within the packages by passing parameters and loaded the data into the tables. * Extensively used Package Configurations while deploying the SSIS packages from DEV- Stage, Stage - Prod environments. * Prepared Mapping documents and design documents for data conversion. * Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL * Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services * Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent. * Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS. * Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2012 * Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access. * Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service. * Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.


CollapseWork Experience


(Confidential) Ms Sql Bi Developer (Ssis, Ssrs Ssas) 5/2017 - Present