Data Ssis

Location:

Dallas, TX

Posted:

February 08, 2021

Contact this candidate

Resume:

Name

Ajitha Reddy Y

Position

SQL Developer

Experience

Experience in Data Warehousing = 6 years

Experience in SQL Development = 6 years

Education

Degree Type

Major Field

Date Received

University

Bachelors Of Technology(B.Tech)

Computer Science & Information technology

2012

St. Mary's College of Engineering and Technology (JNTU,HYD)

Technical Skills:

ETL Tools

MS SQL Server Integration Services (SSIS) VS 2017/DTS/BIDS, Matillion

DBMS

MS SQL Server 2017/2012/2008/2005, Oracle 12c/11g/10g, Teradata, IBM DB2, MS Access

Database Tools

Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor, Aginity, SQL Workbench etc…

Reporting Tools

MS SQL Server Reporting services (SSRS), Crystal Reports 9.0.

Data Modeling Tools

Dimensional Data Modeling (Star Schema, Snow-Flake, FACT, Dimensions),

Physical and Logical Data Modeling

Languages

SQL, T-SQL, PL/SQL, Unix Shell Scripting, C, C++, HTML, CSS, PHP, Core JAVA

IDE

Microsoft BIDS/SSDT, Microsoft Visual Studio 2005/2008/2008 R2/2010/2012

Operating System

Windows 7, Windows 2003/2000/XP/98, Linux and UNIX

Applications

Microsoft Share point, MS excel, word, power point, MS Visio, MS Outlook 2007/2012.

System Design

Requirements Gathering and Analysis, Data Analysis, ETL Design,

Development and Testing UAT Implementation

Other Tools

TOAD, MS Studio, SQL * Plus, Putty, Bitbucket, Jenkins, SVN Tortoise Version Control, Active Batch.

AWS platform

Amazon Redshift, S3, EC2

Professional Summary:

Around 6 years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server Experience in various industries includes Financial Services, Insurance, Retail, Health Care and Banking.

Experience in Information Technology with a strong background in Database development and Data warehousing using MS SSIS/SSAS/SSRS.

Experience in AWS platforms like S3, EC2, Red-Shift while implementing Enterprise Datawarehouse.

Extensively worked on CI/CD pipeline for code deployment by engaging different tools (Git, Jenkins etc) in the process right from developer code check-in to Production deployment.

Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions (SCD) and Dimensional Modeling (Kimball/Inmon methodologies, Star Schema and Snow Flake Schema).

Proficient in designing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.

Good understanding of software development process like Waterfall, Agile within the SDLC (Software Development Life Cycle).

Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Experience in database design & development, database programming, data modeling, business process analysis, and application development.

Experienced in TSQL (DDL,DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server.

Expert in Migrating SQL 2000 databases to SQL 2005 and SQL 2008 and SQL 2012 using migrating services.

Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.

Performed data profiling and analysis of structured and unstructured data.

Expert level skills in Replication, Data Modeling (Physical and Logical), Star Schema, Snowflake schema, Data Mapping, Installation and Configuration, up gradation from previous versions, Table Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS, Objects creation such as Tables, Views, User created Data Types, Stored Procedures, Triggers.

Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats and Power View Reports with multiple views featuring tiles, and a number of visualizations, using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).

Extensive experience in design techniques, ETL (SSIS) processes, relational database theory, N-Tier development.

Experienced in creating DTS Packages and data designer usage and Migration of DTS packages to SQL Server integration services (SSIS).

Experienced in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS packages with T-SQL Stored Procedures.

Development skills in stored procedures, Ad-Hoc SQL Queries, triggers, UDF, custom DTS packages.

Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).

Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.

Understanding of various source transformations, including flat files, XML and relational systems.

Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS) Power Pivot BI Semantic Tabular model.

Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.

Experience in working on OLAP/OLTP data warehouse and data mining.

Very good experience in using data modeling tools like ER-win, MS Visio etc.

Extensive Knowledge in HTML, XML, IIS software development life cycle.

Strong technical background, and posses excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.

Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

Experience in production support activities with on call rotation support 24x7.

Professional Experience:

Subway Franchise World Hqts, Milford, CT May 2019 – Current

Role: Sr Data Warehouse ETL Dev

Project: EDW and Data Integration Projects

Brief Description: Subway is an American privately held restaurant franchise that primarily sells submarine sandwiches and salads. It is one of the fastest-growing franchises in the world and it has more than 4ok locations in more than 100 countries. More than half its locations are in the United States.

Worked in Data Integration team as a shared resource for multiple projects/teams. Played key roles in Enterprise Datawarehouse Projects, Production Support rotation and other major Digital Tech initiative projects/platform re-innovations.

Responsibilities:

§Worked in Enterprise Datawarehouse project which is built on Teradata database using SSIS VS 2017/2008.

§Used Matillion ETL tool to develop EDW/Integrations for different digital project initiatives.

§Involved in conversion/migration project from Teradata to AWS Redshift platform.

§Created ODS (Operational Data Store) in Sql Server platform for Subway real-time applications using ETL process.

§Developed Data warehouse solutions using the Microsoft Business Intelligence based tools.

§Involved in client-project meetings for gathering the business requirements.

§Designing and developing SQL Server 2016/2012 Databases, Tables, Views, Synonyms, User Defined Functions, Triggers, and Stored procedures.

Created process flow diagrams to show end to end batch process.

Wrote Common Table Expressions (CTE) and used analytical functions while creating stored procedures.

Performed complex joins to extract data from various tables in the databases.

Developed Type 1, Type 2 and Type 3 SCD (Slowly Changing Dimensions) to load data into Dimensions and Fact tables in EDW.

Used Change Tracking (CT), MD5 concepts to get Incremental data from Source systems.

Written complex SQL statements using joins, sub queries and correlated sub queries.

Fixing the performance related issues in the existing SSIS packages and SQL’s.

Worked on design, develop, test and deployment areas of ETL packages using SSIS.

Performed data conversions from flat files into a normalized database structure.

Implemented package configurations, logging, scheduling, error handling, variables etc. while creating the packages.

Created Clustered and Non Clustered Indexes on tables, views, and columns.

Developed stored procedures, triggers, synonyms, UDF’s and functions and added/changed tables for data extraction, transformation and loading.

Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.

§Developed and modified complex stored procedure-based processes supporting ETL processes in a Data Warehousing environment and other data related tasks.

§Worked closely with the QA and UAT teams to create test scenarios and mockup data for Automation.

§Worked with customers and/or analysts to define and/or review business requirements for new ETL process. Design and develop ETL processes and reports that meet team standards and use consistent methodology and development approach. Performed comprehensive unit testing of all work.

§Created and maintain technical designs, data dictionaries, and systems operations documentation.

§Performed data validation before loading different type of data files on daily basis as per defined by business user and worked with monthly new project deployment.

§Used SSIS to transform and load data into SQL database via FTP from XML files, MS Excel, CSV, Fixed-width files as source data.

§Created Jobs in ActiveBatch scheduler and monitored Production jobs on rotation basis.

§Completed change request work to load data with extra columns to understand details data and started new import source to process the data.

§Worked for Data Truncation and reload as per the requirement to change in import for data quality.

Attend daily standup calls, Iteration Planning, Backlog grooming, Retrospective and Review sessions with project team.

Used TFS as Agile Methodology tool to create User Stories, tasks, track Project status, defects etc in each Iteration.

Code check in TFS using Bitbucket and deployment integrations using Jenkins.

Involved in Debugging and Troubleshooting SSIS packages.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

§Performed Code review to ensure that ETL development was done according to the company’s ETL standard and that ETL best practices were followed.

§Executes dashboard and automation for repetitive processing tasks, as well as offers support to upgrade and modify automation.

Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Environment: MS Visual Studio 2017/2008, AWS Redshift, AWS S3, Matillion ETL, SSIS, SSRS, MS SQL Server 2016/2012, Data Modeling Tools, ER-win, T-SQL, Sql Server Management Studio, Jenkins, Bitbucket, TFS, SQL Workbench, MS Excel, MS Office, Agile software development, ActiveBatch scheduler.

Healthe Systems, Tampa, FL Oct 2016 – Dec 2017

Role: Database Developer

Project: Datawarehouse and Integration Projects

Brief Description: Healthe systems is a specialty provider of innovative medical cost management solutions for the workers’ compensation industry. Healthe services include a leading Pharmacy Benefit Management (PBM) program and Clinical Review Services as well as a revolutionary Ancillary Benefits Management (ABM) program for managing and adjudicating ancillary medical services.

Worked in Data Integration team as a shared resource for multiple teams. Played key roles in Enterprise Application Services and Financial Services team serving the team as well as project needs using my expertise in SSIS and Database skills etc

Responsibilities:

§Created the project documents, right from the design to the development.

§Developed Data warehouse and reporting solutions using the Microsoft Business Intelligence based tools, services and support (SSIS, SSRS).

§Provided on-going support for client in relation to existing reports with respect to their requirements.

§Worked closely with the testing team to create unit test scripts and monitor issues using the ticketing system.

§Designing and developing SQL Server 2016/2012 Databases, Tables, Stored procedures, Views, Triggers.

Created use cases, user guides, programmer documentation, application administration, and process flow diagrams.

Created the Table and Matrix reports as per the requirements.

Written Common Table Expressions (CTE) and used analytical functions while writing stored procedures.

Performed complex joins to extract data from various tables in the databases

Written complex SQL statements using joins, sub queries and correlated sub queries.

Fixing the performance related issues in the existing SSRS reports, from database design and report query areas.

Worked on design, develop test and deployment areas of SSRS report development. And involved in client-project meetings for gathering the business requirements.

Used the SQL server profiler for tracking run time parameters, user information, execution time etc.

Performed data conversions from flat files into a normalized database structure.

Worked on project specification documents, participated in data analysis meeting etc.

Implemented package configurations, logging, scheduling, error handling, variables etc. while creating the packages.

Excellent analytical and problem solving skills.

Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.

Created Clustered and Non-Clustered Indexes on tables, views, and columns.

Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading.

Involved in the SSAS cube design, to create partitions, processing the cube using SSIS package and displaying the data using Excel source.

Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.

§Developed and modified complex stored procedure based processes supporting ETL processes in a Data Warehousing environment as well as creating reports in Reporting Services and other data related tasks.

§Worked with customers and/or analysts to define and/or review business requirements for new ETL processes and reports. Design and develop ETL processes and reports that meet team standards and use consistent methodology and development approach. Performed comprehensive unit testing of all work.

§Created and maintain technical designs, data dictionaries, and systems operations documentation.

§Performed data validation before loading different type of data files on daily basis as per defined by business user and worked with monthly new project deployment.

§Used SSIS to transform and load data into SQL database via FTP from XML files, MS Excel as source data

§SQL Enhancement/New Report by adding new data source system for production and scheduled job for the process

§Worked for Functional and Technical design to speed up the process and query optimization.

§Completed change request work to load data with extra columns to understand details data and started new import source to process the data. Worked for Data Truncation and reload as per the requirement to change in import for data quality.

Executes dashboard and automation for repetitive processing tasks, as well as offers support to upgrade and modify automation.

Environment: MS SQL Server 2016/2012, Oracle 12c/11g, SSIS, SSRS, Data Modeling Tools, MS Visual Studio 2017/2015, Visual Basic/VBScript, ER-win, T-SQL, SQL Profiler/Data Tuning Advisor (DTA), Sql Server Management Studio, MS Excel, MS Office, Agile software development, ActiveBatch scheduler.

AudaExplore, Addison, TX July 2015 – Sep 2016

Role: MSBI Developer

Project: EDW Project

Brief Description: AudaExplore is a business unit of Solera Holdings, Inc., the leading global claims solutions provider serving the automotive industry.

The project scope was to build an Enterprise Datawarehouse (EDW) project by consolidating all the legacy systems data into one place. The data to be integrated needed to satisfy all data governance rules and apply optimization strategy, perform performance tuning, and data integrity. The information can be accessed by higher management in form of reports or displayed as a complex dashboard.

Responsibilities:

§Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.

§Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

§Using Integration Services (SSIS), built high performance Data Integration Solutions, including extraction, transformation and loading (ETL) packages for data warehousing.

§Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.

§Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

§Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

§Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi-dimensional model.

§Designed Data Integrator jobs with Error Handling and email notifications.

§Worked with development teams in the design of physical databases and in modification.

§Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).

§Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

§Created Packages in SSIS with error handling.

§Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.

§Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi-dimensional model.

§Designed logical / physical data models and defined primary key, foreign key using Erwin tool.

§Worked with different methods of Logging in SSIS.

§Generation of reports from the cubes by connecting to Analysis server from SSRS.

§Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

§Created complex SSIS packages using proper Control and Data flow elements.

Environment: MS Visual Studio 2008, MS SQL Server 2008, Oracle 11g, SSIS, SSAS, SSRS, Data Modeling Tools, T-SQL, Sql Server Management Studio, MS Excel, MS Office, Control_M scheduler, Agile software development.

Kennedy Soft, Hyderabad, India June 2012 – Mar 2014

Role: SQL Server SSIS/SSRS Developer

Project: DWH Project

Brief Description: The project scope was to consolidate client’s information and businesses into a data warehouse and apply optimization strategy, perform performance tuning, and data integrity. The data to be integrated needed to be transformed according to the structure of existing DW in proper format as required by the organization. The information can be accessed by higher management either in a form of a report or displayed as a complex dashboard.

Responsibilities:

§Created the project documents, right from the design to the development.

§Developed Data warehouse and reporting solutions using the Microsoft Business Intelligence based tools, services and support (SSIS, SSAS, SSRS).

§Provided on-going support for client in relation to existing reports with respect to their requirements.

§Worked closely with the testing team to create unit test scripts and monitor issues using the ticketing system.

§Designing and developing SQL Server 2008 Databases, Tables, Stored procedures, Views, Triggers.