Software Engineer Azure Data

OBJECTIVE

A result-oriented IT professional with 8.9 years of experience with Software Development. Expertise in MS SQL 2008 database and In-depth experience in MSBI (SSIS) and ETL Tools. Seeking a challenging position in a revered organization and proven ability to lead and motivate project teams to ensure success.

TECHNICAL EXPERTISE

Applications

Microsoft SQL Server 2008r2,2017

SSIS 2012,2017

SSRS

Azure Data Factory, Azure Data Bricks

Microsoft Excel

OPERATING SYSTEMS

Microsoft Windows 7

Microsoft Windows 8

Microsoft Windows XP

PROFESSIONAL EXPERIENCE

TATA CONSULTANCY PVT LMT

Roles SQL and SSIS Developer

Designation Assistant Consultant

Duration 01/2023 – Present

PROJECT DETAILS:

PROJECT TITLE : EY(Earnst & Young)

Ernst & Young Global Limited, trade name EY, is a British multinational professional services partnership. EY is one of the largest professional services networks in the world. Along with Deloitte, KPMG and PwC, it is considered one of the Big Four accounting firms. It primarily provides assurance, tax, information technology services (including managed services in areas like Cybersecurity, Cloud, Digital Transformation and AI), consulting, and advisory services to its clients.

EY operates as a network of member firms which are structured as separate legal entities in a partnership, which has 395,442 employees in over 700 offices in more than 150 countries. The firm's current partnership was formed in 1989 by a merger of two accounting firms; Ernst & Whinney and Arthur Young & Co.

Roles & Contributions to project:

•Working experience in SSIS control flow like Execute Package Task, Execute Sql task.

•Working experience in Error Handling, Checkpoints, Breakpoints, Event handler.

•Working experience in SSIS Data flow like OLEDB Source&Destination, Data Conversation, Conditional Split.

•Working experience in SSIS transformations like Lookup, Union All, Merge, Multicast,SCD,Debugging.

Monitoring and Supporting the ADF and ADB jobs using Azure.

•Working experience in Cluster,Data storage,workflow and analyzing the bugs using batch id’s

•Working experience in Data moving from Landing zone to Bronze layer and into Silver and Gold layer with the help of ADF and ADB jobs

•Monitoring and Supporting the Batch/jobs using Control-M.

•Involved in Creation and Execution of Stored Procedures which includes Tables, Joins, Views,,CTE’s, Table variables, Subquery and fixing Bugs, and tuned them such that they perform well.

•Responsible for the complete ETL solution to receive, transform and load the data from different various sources on target databases.

•Interacted with the users for understanding and gathering business requirements.

•Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.

•Implemented stored procedures for Data migration from Working Database into Development databases.

•Regular interaction with client and team members by assisting technically to launch project on time.

PROFESSIONAL EXPERIENCE

INDIUM SOFTWARE PVT LMT

Roles SQL and SSIS Developer

Designation Senior Software Engineer

Duration 09/2022 – 11/2022

PROJECT DETAILS:

PROJECT TITLE : EUROPRO HUB

Europro is a commercial property management company established in 2003 specializing in a tailored and service-based approach to commercial real estate. Headquartered in Toronto, Ontario with regional offices in Kitchener, Windsor, London, Barrie and Sarnia, Europro has grown to managing assets in 10 cities province wide. We constantly strive to improve our portfolio of properties, managing assets ranging from local service-type retail and office to Class A office towers and regional shopping centres.

COGNIZANT TECHNOLOGY SOLUTIONS

Roles SQL and SSIS Developer

Designation Senior Associate

Duration 01/2020 – 09/2022

PROJECT DETAILS:

PROJECT TITLE : CHUBB INSURANCE

CLIENT : Chubb INA Holdings Inc

Chubb is the world’s largest publicly traded insurance company and a leading commercial lines insurer in the U.S. With operations in 54 countries and territories, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance, and life insurance to a diverse group of clients. Clients of Chubb consist of multinational corporations and local businesses, individuals, and insurers seeking reinsurance coverage.

Roles & Contributions to project:

•Working experience in SSIS control flow like Sequence container, Execute Package Task, Execute Sql task.

•Working experience in Error Handling, Checkpoints, Breakpoints, Event handler.

•Working experience in SSIS Data flow like OLEDB Source&Destination, Data Conversation, Conditional Split.

•Working experience in SSIS transformations like Lookup, Union All, Merge, Multicast,SCD,Debugging.

•Monitoring and Supporting the Batch/jobs using Autosys.

•Involved in Creation and Execution of Stored Procedures which includes Tables, Joins, Views,,CTE’s, Table variables, Subquery and fixing Bugs, and tuned them such that they perform well.

•Responsible for the complete ETL solution to receive, transform and load the data from different various sources on target databases.

•Interacted with the users for understanding and gathering business requirements.

•Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.

•Implemented stored procedures for Data migration from Working Database into Development databases.

•Regular interaction with client and team members by assisting technically to launch project on time.

•Having experience in Tableau by using different functionality and different types of filters

in datasource level, dimensional and measures level and cascading and context filter and calculating filters

PROFESSIONAL EXPERIENCE

4W TECHNOLOGIES PVT LTD

Roles SQL Developer

Designation Software Engineer

Duration 08/2018 – 12/19

PROJECT DETAILS:

PROJECT TITLE : TRADER HUB

CLIENT : HANSEN MUELLER

Hansen-Mueller Co. engages in commodity trading business. The company trades commodities, such as corn, soybeans, wheat, and oats; and various feed ingredients, as well as byproducts, including dried distillers grains and soy hull pellets. It provides a range of services in bulk commodity logistics from on-farm grain loading by truck to ocean vessels to assist in importing, exporting, storing, and trans-loading bulk commodities. The company also produces processed grain products. In addition, it owns and operates country elevators in Sublette, Kansas; and bulk storage facilities throughout the Midwest from Superior, Wisconsin to Houston, Texas to assist customers with inventory management. Hansen-Mueller Co. was founded in 1979 and is headquartered in Omaha, Nebraska with trading offices in Omaha, Nebraska; Alabaster, Alabama; McKinney, Texas; Salina, Kansas; and Sandusky, Ohio. It also has handling facilities in Broken Arrow, Oklahoma; Council Bluffs, Iowa; Houston, Texas; Kansas City, Missouri; Superior, Wisconsin; Toledo, Ohio; and Hugoton, Kismet, and Sublette, Kansas.

Roles & Contributions to project:

•Working experience in SSIS Transformations like, Data Conversion, Derived column,

Union All, Conditional split, Aggregate, Sort, Slowly Changing Dimension(SCD) etc.

•Responsible for the complete ETL solution to receive, transform and load the data from different various sources on database.

•Created SSIS packages using transformations such as Derived column, Lookup, Merge joins, Conditional split

SHRIRAM VALUE SERVICES PVT LTD

Roles SSRS and SQL Developer

Designation Software Engineer

Duration 07/2017 – 08/2018

PROJECT DETAILS:

PROJECT TITLE: CORPORATE ACCOUNTS

CLIENT : SHRIRAM TRANSPORT FINANCE COMPANY

Shriram Value Services (SVS) is a CMMI Level 5 Certified IT & ITES arm of Shriram Group with a strong technology and domain expertise in Financial Services, Insurance and Ecommerce industries, with a proven track record of delivering high quality business solutions. Shriram Group, established in 1974, is among the leading financial services conglomerates in India.

Description:

The client is a leading financial (non-banking) sector in India and objective of the project is to enable business analyst teams to view various metric reports on different time spans, weekly, monthly and annually which will enable them to analyze and monitor business growth. Also these metric reports plays crucial role in future planning and enhancements. Users can view their reports either in web based applications or by delivering reports/metrics pulled directly from database.

Roles & Contributions to project:

Working as a part of Database and Reporting team which performs data migration, Back-end development, Code Automation and Product Support.

Maintaining Daily Backup in server.

Involved in Creation and Execution of Stored Procedures which includes Tables,Joins, Views,CTE’s

Involving in performance tuning using Indexes and Query Execution Plans.

Having Knowledge in financial components like TB,Stock,NPA,Pledging etc.

BOTCODE TECHNOLOGIES PVT LTD

Roles SSIS and SQL Developer

Designation Software Engineer

Duration 10/2015 – 06/2017

PROJECT DETAILS:

Project#1

PROJECT TITLE: ABBOTT

CLIENT : ABBOTT

Abbott is a worldwide broad based healthcare company .We are looking to find Official website for Abbott in World Wide Web. They having branches in 84 countries in world. We are checking 7 countries per month. Here we using tool name called Visual Web Ripper to getting data from the website. At the end of month, we are sending Report to the client.

EDUCATION QUALIFICATIONS

Master of Computer Application, 2015 - 71%, at MIET Arts and Science College, Trichy.

Bachelor of Computer Science, 2013 – 70%, at MIET Arts and Science College, Trichy.

HSLC, 2010- 57% at Khajamian Hr Sec School State Board of Tamilnadu Trichy.

SSLC, 2008 - 78% at Khajamian Hr Sec School State Board of Tamilnadu Trichy

DECLARATION

I hereby declare that the above written particulars are true to the best of my knowledge and belief. If given a chance, I can prove myself.

Date: (Gajendran.s)

Contact this candidate