Resume

Sign in

SQL, SSIS, ETL, Power Bi, Data Ware House, Azure SQL, C#

Location:
Bangalore, Karnataka, India
Posted:
March 23, 2020

Contact this candidate

Resume:

ARJUN B SURENDRA

Seeking a Challenging Technical role in IT/ITES/Technology Solutions

PROFESSIONAL SYNOPSIS

lA dynamic professional with over 12 years of rich experience in design and development of Web applications and Database solutions using Microsoft technologies such as SQL Server 2008/2012/2016 and SSIS 2016, SSAS, AZURE SQL

lHave good experience in developing of ASP. Net web applications on IIS platform, using MVC, WEB.API, WCF and Windows Applications using Microsoft technologies

lProven skills in working with teams in sync with the corporate set parameters & motivating for achieving business and individual goals.

lExcellent communication & interpersonal skills with proven abilities in customer relationship management & Team Management

lonsite experience at client location (USA) in being an interface between the client and the dev team offshore.

lUS VISA SPONSORSHIP – no immigration sponsorship would be necessary.

Experience Summary:

lWorking at Happiest Minds Technologies since Jan 11’th 2018 to Date

lWorked at Neviton Softech from December 22’nd 2014 till Nov 30’th 2017.

lWorked at NTT Data(formerly Keane International) as Team Lead from Jan 2012 to October 9’th 2014.

lWorked as a Senior Software Engineer at Ness Technologies Bangalore from January 2010 to December 2011

lWorked as a Technical Analyst at CDC Software Bangalore from May 2008 to January 2010

lWorked as a software developer at Nelito Systems Limited (A TATA Enterprise) from September 2005 to August 2007

CORE COMPETENCIES

lExtensive knowledge of Normalization and Relational Database Management System

lGood technical acumen in developing Database solutions and maintenance activities using SSIS, and SQL Server.

lImplemented Data Warehousing solutions for a large-scale enterprise database.

lGood knowledge of RDBMS which includes T-SQL, MS SQL Server 2000 / 2005/2008,2012,2016, MS Access, Data Warehousing concepts, and Enterprise Level Data Migration

lExtensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

lExperience in Performance Tuning and Query Optimization.

lExperience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

lExperience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

lExpertise C#.Net, ASP.Net, WCF (Web services), WEB.API, MVC, and Entity Framework.

lGood working Knowledge on JavaScript, jQuery and Angular (2 and above)

lProficient in Microsoft Visual Studio.Net and Microsoft Visual Studio Code

lExcellent knowledge on GitHub and Bitbucket, TFS and other used Source code repositories.

lStrong analytical and problem-solving skills, self-motivated, willing to take initiative and able to learn quickly and apply new tools and technologies in the projects.

lCapable of forming and maintaining positive and productive working relationships in internal/external and team environments.

lExperienced in the complete software development lifecycle and had contributed at all stages of the lifecycle.

lGood experience and exposure to business processes strong technical knowledge with good exposure to various latest technologies and has been involved in many client facing assignments.

lWorked in creating test plans and assisting QA team in defect tracking.

lExcellent communication skills and has been involved in requirement gathering, elaboration, analysis and documentation.

Technical Skills

Languages : C#, VB.Net,Angular, EXT.JS

Web Technologies : ASP, ASP.Net, ADO.Net, Web Services (asmx and WCF), MVC, WCF, WEB API

Scripting/Markup languages : HTML, VBScript, JavaScript, Angular, jQuery

Database Technologies : SQL SERVER (2008/2012/2014/2016), SSIS, ETL, SSAS

Data Warehouse, AZURE SQL

ACADEMIC QUALIFICATIONS

lBachelor’s Degree in Mechanical Engineering from Vishweshwaraiah Technological University Karnataka (B.E) in 2005

Latest Project Experience

Project: Data Warehouse Role: Tech Lead

Client: QwikCilver Solutions Period:November 2018- Till Date

About the Client: Qwikcilver, a global leader in end-to-end gifting & stored-value solutions, helps the brands and retailers transition their business with a retention & rewards .

Project Description: The project Involved developing a new Data-warehouse solution from scratch using SSIS 2016 and SQL 2016 . The Current OLTP system was heavily transactional and led to huge amount of data being stored in the DB on a daily basis thereby affecting the reporting queries and the performance.

I was tasked with creating a Data-warehouse solution that could help eliminate the dependency on the OLTP and make the reporting more meaningful and easily accessible at all times .

Responsibilities:

lTranslated business requirements into technical design specifications using Visio to design ERD schema.

lModeled the Data-warehouse system using the OLTP tables and creating an easy to use Reporting Database that could scale large amounts of data .

lDenormalized data fields to meet the business requirements and specifications to build a data marts for various departments into a metadata.

lDesigned and implemented cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as its needed

lDesigned ETL flows to extract data from OLTP application and stored in Data-warehouse DB.

lMaintained ETL jobs for OLAP cubes. Executed and supported ETL using MS-SQL Server

lCreating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.

lCreated SSIS packages to populate data from various data sources.

lConfigured SSIS packages using Package configuration wizard to allow packages run on different environments.

Project: Database Archiving Role: Tech Lead

Client: QwikCilver Solutions Period: March 2018- October 2018

About the Client: Qwikcilver, a global leader in end-to-end gifting & stored-value solutions, helps the brands and retailers transition their business with a retention & rewards .

Project Description: The project Involves bringing a solution that involves creating a dynamic flexible self-maintaining database Archiving solution that can cater to purging huge amount of data at regular times so that the Active OLTP database can perform better at all times thereby increasing the application performance and end user experience.

Responsibilities:

lInvolved in the complete coding, Design, Architecture and testing of enhancements required and defect fixing.

lPreparing Test Plan scripts.

Designed and developed the system using SQL Server 2017, SSIS.

lMade changes in Reports to align to Archive Database for Querying of Historical data .

lInteracting with clients/ Major stakeholders at regular intervals to understand the requirements on a weekly basis to bring a solution to life that proved to be a generic Archiving solution for any database.

lConfigured Active/Active and Active/Passive clustering for failover

lScheduled the SSIS packages to run at different intervals to load the data.

lUsed data profiling task in SSIS 2008 to identify poor data and repair it.

Project: Acelero Learning Role: Tech Lead

Client: Shine Insight Period: March 2017- Nov 2017

About the Client: Acelero Learning has been established is to bring a relentless focus on positive child and family outcomes to close the achievement gap and build a better future for children, families, and communities served by the Head Start program.

Project Description: The project Involves consuming the data exposed by the end user through a web service (WCF) and importing it into the system through after doing the necessary transformations.

There was also change requests for modifying the existing application features and to add new features for better end user accountability.

Responsibilities:

lInvolved in the complete coding and testing of enhancements required and defect fixing.

lPreparing Test Plan scripts.

Designed and developed the system using WCF, ASP.NET MVC, JQUERY.

lUsed SQL Server 2012 For Databases. Written Stored Procedures and Functions for

Retrieving /Updating data.

lInteracting with clients on a weekly basis to update status and give demo through the course of development just to be sure enough to align to the requirements

Project: Data Warehouse Role: Tech Lead

Client: Shine Insight Period: Nov 2016-Till March -2017

About the Client: Acelero Learning has been established is to bring a relentless focus on positive child and family outcomes to close the achievement gap and build a better future for children, families, and communities served by the Head Start program.

Project Description: The project Involves Migrating the existing OLTP Database and having the reporting data move into a Dimensional Model (OLAP). The data points were identified based on the existing database design and Data Model created to have a DATA WAREHOUSE set up. Whenever there were changes made to the Application the changed data needs to be tracked and moved over to Data warehouse DB.

This DB is then projected as a source for the Reporting purposes for the business team.

Responsibilities:

lMentoring junior team members.

lPreparing Test Plan scripts.

lDeveloped/coded the procedures using SQL SERVER 2016.

lDeveloped SSIS Packages for Extracting data from OLTP database and invoking the procedures for retrieving the changed data and moving into OLAP database using

SSIS 2016 and Microsoft Change Data Capture (CDC) Technology

lCarrying out the unit testing based on the test case documents. Expediting the issues for an early closure.

Interacting with clients on a Daily basis to update the Progress

Project: SPARTA Role: Team Lead

Client: Disney Period: Oct 2015-Nov 2016

About the Client: The Walt Disney Company, commonly known as Disney, is an American diversified multinational mass media and entertainment conglomerate headquartered at the Walt Disney Studios in Burbank, California

Project Description: The project Involves catering to new enhancements and fixes that arise during the course of development and/ or related to new customer requirements. The changes span across the UI, Server side or Databases (mainly stored procedures).

Responsibilities:

lInvolved in coding and testing of enhancements required and defect fixing.

lMentoring junior team members.

lPreparing Test Plan scripts.

lDeveloped/ coded applications using C#.Net in Visual Studio 2013, EXT.NET, EXT.JS, JQuery, MVC, Angular

lModify the user interface to add /edit certain changes pertaining to UI in C#, EXT.NET, MVC Views

lCarrying out the unit testing based on the test case documents. Expediting the issues for an early closure.

lInteracting with clients on a weekly basis to update the health of the application and monitor the progress of the team and new requirements being implemented.

lUsed database environment through ADO.Net and used Entity Framework extensively to interact with MS-SQL 2012 databases.

Project: Data Migration Role: Tech Lead

Client: Shine Insight Period: April 2015- Till October 2015

About the Client: Acelero Learning has been established is to bring a relentless focus on positive child and family outcomes to close the achievement gap and build a better future for children, families, and communities served by the Head Start program.

Project Description: The project Involves working with the data collected from the End user and customers for the client. The data comes in a standard template defined by the team wherein it’s exported in CSV format. The data is then taken and run through the process of SSIS and procedures which take the source data do the necessary validation and then map it to the correct destination tables. The system has been developed and maintained such that year after year if any new customers want to use our Application, they could easily migrate just by exporting their data to us. Once the customer data is in our system it just runs as if it were created from the application natively.

Responsibilities:

lInvolved in the complete coding and testing of enhancements required and defect fixing.

lPreparing Test Plan scripts.

lDesigned and developed the system using SSIS 2012 Integration services

and MS SQL Server 2012

lInteracting with clients on a weekly basis to update status and give demo through the course of development just to be sure enough to align to the requirements

Project: SPARTA Role: Team Lead

Client: Disney Period: Dec 2014- Till April 2015

About the Client: The Walt Disney Company, commonly known as Disney, is an American diversified multinational mass media and entertainment conglomerate headquartered at the Walt Disney Studios in Burbank, California

Project Description: The project Involves working with the data collected from Disney

for helping and analyzing the Box Office results, and plan and target sales better with the tool. The application captures vital information about the movies released country wise, region wise, and other parameters that helps to achieve and increase the profitability and target better sales. The application also provides certain features where in the reports are generated for analysis from the business and marketing team.

Responsibilities:

lInvolved in the complete coding and testing of enhancements required and defect fixing.

lMentoring Junior team members.

lPreparing Test Plan scripts.

lDesigned and developed applications using C#.Net in Visual studio 2012, EXT.NET, EXT.JS, jQuery, MVC

lModify the user interface to add /edit certain changes pertaining to UI in C#

lCarrying out the unit testing based on the test case documents. Expediting the issues for an early closure.

lInteracting with clients on a weekly basis to update the health of the application and monitor the progress of the team and new requirements being implemented.

lUsed database environment through ADO.Net and used Entity Framework extensively to interact with MS-SQL 2008 databases.

PERSONAL DETAILS

lDate of Birth : 24/01/83

lEmail Id : adce3q@r.postjobfree.com

lContact Number : 91-984*******



Contact this candidate