Resume

Sign in

Sql Server Project

Location:
Frisco, Texas, United States
Posted:
February 26, 2018

Contact this candidate

Resume:

Murugan Valathi Elumalai #**** Concord dr, Mobile : +1-706-***-**** Frisco, Texas, Email: ac4mey@r.postjobfree.com H1B stamped till dec2018 and can be extended till Dec 2022 USA -75035

Objective

To obtain a software profession through which I can contribute my competent Technical Skills for the project involved and where my experience can be utilized to improve customer satisfaction.

Experience Summary

10 Years of Technical Experience in ETL development(MSBI), SQL Performance tuning, Certified on APIGEE and Application Development with .NET and good experience on the Agile methodology(Agile central)

Academic Qualification:

M.Sc. -5 Years Integrated Programme in Computer Science from Government College of Technology, Coimbatore.

Professional experience:

Company Name

Experience

Duration

Functional Domain Name

Capgemini America Inc

1 years (On site)

Dec-2016 to till date

Banking and finance services

Mindtree Ltd,

Bangalore

5 Years and 9 Months(including 6 months onsite)

Feb-2011 to Nov-2016

Banking and finance services

Wipro Technologies, Bangalore.

3 Years and 8 Months

Jul 2007 to Feb-2011

Energy and Utilities

Technical Overview

BI Tool

MSBI (SSIS, SSRS, SSAS), SQL performance tuning (using SQL profiler and query analyser and execution plans), Certified on APIGEE and going for training on Google cloud

Web Technologies

ASP,ASP.Net, IIS 6.0 and Web Services

Database

SQL SERVER from 2000 till 2016

Reporting Tool

SSRS and Crystal Reports,

NET Platform

.Net 4.0, C#. MVC,NET, VB.NET, ADO.NET, ASP.NET 2.0, Web Services, SOAP, AJAX, XML and XSLT

IDE

Visual Studio 2005 and 2008

Scripting Language

Java Script, JSON, node js and VB Script

Programming Languages

C#, XML,HTML, C++ and C

Tools and Utilities

Visual Studio 2015, Microsoft Visio 2003, Visual SourceSafe, VSS, MS-Visio and FXCop

Third Party Tools

TOAD (Oracle), Infragistics and DTS

Achievements:

Award Title

Month/Year

Description

Teams Spot Award

Apr-2013

The system started billing 40-45% invoices more than current system Automatically; it has completed manual effort for generating invoices

Pat on the Back

Oct-2012

I was awarded for CRMS

Pat on the Back

Dec-2011

I have helped for other projected called Email Branding

Extra mile performance in Project Engineer at Energy and Utilizes level by Senior Vice President and Head -E & U year 2010.

Sep-2010

EXTRA MILER, The Certificate of Appreciation is awarded to me for the exceptional performance in the project

Appreciation Certificate awarded by Shell Project Manager

Dec-2009

This Certificate of appreciation is awarded to me for exceptional level of professional responsibility, technical expertise and ownership during the execution of MTA Project

Finance and Banking Fundamentals certificate from FLIP

Sep-2012

MCTS Web Applications certificate Microsoft

Apr-2010

Personal Strengths:

Self-motivated and willing to learn new technologies and attend trainings.

Hardworking, Self-Confident, Adaptable Personality

Fast learner and able to work under pressure and deadline

Share knowledge and gain whatever possible from the team

Able to work with different people in a friendly manner and Good team player and inter personal skills.

Rich Experience in ETL Development, Testing, Deployment, Implementation and Maintenance.

Project experience in Capgemini America Inc

1.Project details: Datasolution

Client : Heartland

Technologies: SQL Server 2014 and SSIS 2014, Neteeza, SSIS, Abinitio, SSRS and Microstrategy

Domain : Banking and financial Services

Duration : Dec 2016 to till Onsite

Team size : 25

Data solutions is store the card processing data into databases which will be used multiple downstream systems and it plays the 1) Replication of data into ODS from various front end databases like Gateway, Atlas, Passport etc with the help of Abinitio tool, 2) Role of generating the different level of customized reports and files to Merchant & Corporate Users from SQL & Netezza DB’s post replication of card transactions/batch, 3) Aggregated data on data warehousing(Neteeza DB) and Microstrategy reports from Neteeza. Rally – Agile tracking tool

Role played in project Onsite:

DiAl for two offshore teams(Development and QA)

Requirements gathering and sharing with offshore

Taking care of reviewing offshore work deliverables

Team management and sending weekly, monthly reports to all the stakeholder

Project experience in Mindtree Ltd on offshore and Onsite.

2.Project details: Single Bank ( Merger 28 Banks merge into one Single bank)

Client : Synovus bank

Technologies : SQL Server 2012 and SSIS 2005 and 2014, SSRS and SSAS

Domain : Banking and financial Services

Duration : May 2016 to till Onsite

Team size : 7

Commercial Portal delivers a controlled and secured single point of entry for commercial customers to access the Synovus Product family, providing Synovus with a greater degree of control over customer access and understanding of our customers, their needs and their work habits.“Single Bank” initiative is about the subsequent migration of all customer and account information into that single bank model, as part of this initiative, database component is the migration of the actual data from the banks into a single bank. Also preparation for developing, testing and verifying the proposed data change scripts for each migration, with test/verify steps for each migration. This will bring down cost of deployment to the customer and manage product roll outs and upgrades more systematically. This model will also enable on boarding customers quickly which is very crucial in an environment of cut throat competition.

Role played in project Onsite:

Requirements gathering, Architect refactoring and database schemas design changes

Data migration/conversion and Involving in coding, code Integration documentations and code reviews

Monitoring the DBA activities

3.Project details: Sofia Integration with CRMS

Client : CIT Bank for US/Canada

Environment : SSIS, ASP.NET 3.5, C#, Windows 2000, Vista

Back end : SQL Server 2005

Interface : SSIS Package, BizTalk Server

Domain : Banking and financial Services

Duration : May 2015 to Apr-2016

Team size : 56

Sofia is a legacy system application having various modules to manage the business operations of CIT Rail, Invoicing Module is critical to Business, has complex business rules. It has been integrated with CRMS application

Processing Invoicing Events generated by User Actions, CLM Processor and External Data Feeds.

Role played in project:

Requirement gathering and co-ordinating between the Customer and Offshore team.

Involved in database design, coding, code Integration documentations and reviews

UAT Support

4.Project details: Tank Car Management System

Client : CIT Bank for US/Canada

Environment : SSIS, ASP.NET 3.5, C#, Windows 2000, Vista

Back end : SQL Server 2008 R2

Interface : SSIS Package

Team size : 14

This Rank Car management system to take care of monitoring and managing all maintenance schedule activities and feet management

Role played in project:

Requirement gathering and co-ordinating between the Customer and Offshore team.

Involved in database design, coding, code Integration documentations and reviews

UAT Support

5.Project details: Document Management System

Client : CIT Bank for US/Canada

Environment : SSIS, ASP.NET 3.5, C#, Windows 2000, Vista

Back end : SQL Server 2008 R2

Interface : SSIS Package

Team size : 7

The Document Management System is used uploading and downloading relevant documents for Rail Car Management system (around 10 lacks documents).

Role played in project:

Involved in requirements phase.

Involved in database design, coding, code Integration documentations and reviews

UAT Support

6.Project details: Commercial Rail Car Management System

Client : CIT Bank for US/Canada

Environment : SSIS, ASP.NET 3.5, C#, Windows 2000, Vista

Back end : SQL Server 2005

Interface : SSIS Package, BizTalk Server

Domain : Banking and financial Services

Duration : Mar 2012 to Apr-2015

Team size : 10

CRMS is a .NET Smart Client application having various modules to manage the business operations of CIT Rail, Invoicing Module is critical to Business, has complex business rules which is done on SSIS.

Processing Invoicing Events generated by User Actions, CLM Processor and External Data Feeds.

Role played in project:

Involved in requirements phase, co-ordinating between Customer and Offshore team

Involved in effort/cost estimation, coding, code Integration documentations and code reviews

Maintenance of source code and documents in SVN and releases to UAT/Production

Involved Post Production support

7.Project details: CIT Rail ePortal

Client : CIT Bank for US/Canada

Environment : SSIS, ASP.NET 3.5, MVC, C#, Windows 2003 and Windows 7

Back end : SQL Server 2005

Interface : SSIS Package

Domain : Banking and financial Services

Duration : Apr 2011 to Feb-2012

Team size : 5

The Rail ePortal Website is a Customer focused end user online website. This basically derives all the data from CRMS (System which manages entire CIT’s Rail Transactions) and shows as Report. Rail ePortal has major modules like Rail Car Mechanical Attributes, Invoice, Lease Information, Dashboard (Graphical), Admin, Shop and Regulatory Compliance.

Role played in project:

Involved in requirements phase, effort/cost estimation and led the offshore Team

Involved in coding, code Integration documentations and code reviews

Maintenance of source code and documents in SVN and releases to UAT/Production

Involved Post Production support

Projects experience in Wipro Technologies in offshore

8.Project details: Supply Contract Tracking (SCT)-Canada

Client : SHELL Downstream, Canada and Global.

Environment : ASP.NET 3.5, C#, SSRS, VB 6.0, Crystal report, Windows 2000, Vista

Back end : SQL Server 2008, Oracle 10i.

Interface : GSAP, GSE, BizTalk Server, SSIS Package

Domain : E&U

Duration : Jul 2010 to Feb-2011

Team size : 13

Contract management systems are used in several supply envelopes as tools to assist the managing and balancing of 3rd party contract agreements, tracking in month movements against monthly and annual commitments and providing month end appraisal and reporting. Without such management tools Shell’s ability to maintain partner controls in a dynamic Supply environment requires significant manual effort and resources.The current landscape for Supply Contract Tracking includes three legacy applications:Contracts Database (CDB), in the Rhine, Exchange Forecasting (XFor), in the US (exchanges only) Visagio, in Brazil (bio fuels purchases only).

An IT portfolio study recently recommended XFOR as the Shell target application for Supply contract tracking. This recommendation was endorsed by the Supply Design Authority.

Role played in project

Involved in requirements phase and leading the Team in offshore.

Prepared the Functional Specification and worked on design phase of the Project.

9.Project details: MTA Global Rollout and Server migrations

Client : SHELL Downstream, USA and Global.

Environment : Windows XP/2000 professional S/w: ASP.NET 2.0, C#,AJAX

Back end : SQL SERVER 2005 and SSIS.

Interface : MS BizTalk

Domain : E&U

Duration : Dec-2009 to Jun-2010

Team size : 8

Mitigate Threats to Availability or MTA (also called PTO) was a Microsoft Access application (localized application) that has been converted to more robust, globalize application so that sites across the world can use it to mitigate and resolve threats and it has been converted .NET web application with SQL Server 2005 as the database. MTA stores details of potential threats and opportunities that happen at a refinery or chemical plant. Risk assessment is done on each of these threats and projects are started to mitigate these threats. A potential threat can have one or more Projects running to resolve it.

Role played in project

Involved in requirements gathering and led the offshore team

Writing ETL (SSIS) Scripts to migrate data as per MTA database and verified the data which are migrated to new system

Coordination between development team and the performance test team, Knowledge transfer to BAM and post production support

10.Project details: MTA Development

Client : SHELL Downstream, USA.

Environment : Windows XP/2000 professional S/w: ASP.NET 2.0, C#

Back end : SQL SERVER2000, 2005 and SSIS.

Interface : MS BizTalk

Domain : E&U

Duration : Apr-2008 to Nov-2009

Team size : 6

Mitigate Threats to Availability or MTA (also called PTO) was a Microsoft Access application (localized application) that has been converted to more robust, globalize application so that sites across the world can use it to mitigate and resolve threats and it has been converted .NET web application with SQL Server 2005 as the database. MTA stores details of potential threats and opportunities that happen at a refinery or chemical plant. Risk assessment is done on each of these threats and projects are started to mitigate these threats. A potential threat can have one or more Projects running to resolve it. A Project would involve Capital/Operating/Revenue expenses and has different phases to it. Rollout for 30 counties- Data migration from Ms Access and Excel sheet to SQL 2005 through SQL Server 2005 Integration Services (SSIS).

Role played in project:

Discussing requirements with Client and coordinating the team

Involved in effort/cost estimation,creating CR Design document

Involved in coding, documentations and code reviews

Maintenance of source code and documents in VSS and live link

Responsible for releases to UAT/Production and exposure to all aspects of the SDLC.

11.Project details: Workflow Tool

Client : SHELL Downstream, South Africa.

Environment : Windows XP/2000 professional S/w: ASP.NET 2.0, C#

Back end : SQL SERVER 2005 and SSIS and JD Edwards

Domain : E&U

Duration : Nov-2007 to Mar-2008

Team size : 11

JD Edwards ERP system is currently used in Shell South Africa in which customer’s data needs modification / correction from time to time. Data changes cannot be made in JDE until it is verified and approved by the relevant people. Based on the kind of data being modified the number of levels of approval and the approver differs. Currently this is being done manually and challenges such as versioning, history, notifications and reporting still remain to be addressed. To overcome the above limitations, Workflow Project is developed as a web based Intranet application by creating custom Workflows based on Initiator with customer templates designed exclusively for respective Master Data. Auditing and reporting features were also implemented to keep track of changes.

Role played in project

Involved in coding and testing of applications developed using C# and SQL 2005 as backend.

Academia:

M.Sc (Computer Science) 5-Year Integrated Course from Government College of Technology, Coimbatore between Jun 2002 and May 2007 with 72.6 %.

Completed 12th from Government Higher Secondary School, Melmalayanur between Jul 1999 - May 2001 with 65%

Completed 10th from Government Higher Secondary School, Melmalayanur on 1999 with 77.2%.

Personal Profile:

Age/DOB : 5th Feb 1984

Sex/ Marital Status : Male/Single

Nationality : Indian

Passport Details : Available Place of Issue - Regional passport off Chennai

Hobbies : Watching movies, listening News and Music.

Declaration

I hereby declare that the above mentioned information is correct to best of my knowledge

Murugan V.E



Contact this candidate