SUMMARY:

• To obtain a software profession through which me can contribute my competent Technical Skills for teh project involved and where my experience can be utilized to improve customer satisfaction.
• 12+ Years of development experience in APIGEE, DevOps, Java, Good Exposure Google cloud and good experience on teh Agile methodology

TECHNICAL SKILLS:

BI Tool: APIGEE, Java, DevOps, MSBI (SSIS, SSRS, SSAS), SQL performance tuning, Setup and manage jobs in SQL Server Agent

Google Cloud: Data processing and ETL operations, App Engine, App computing, Dataflow, Dataproc, BigTable, BigQuery, Kafka, Cloudera

Web Technologies: ASP,ASP.Net, IIS 6.0 and Web Services, C# Automation

Database: SQL SERVER from 2000 till 2016

Reporting Tool: SSRS and Crystal ReportsNET Platform: .Net 4.0, C#. MVC,NET, VB.NET, ADO.NET, ASP.NET 2.0, Web Services, SOAP, AJAX, XML and XSLT

Scripting Language: Java Script, JSON, node js and VB Script

Programming Languages: C#, java, XML,HTML, C++ and C

Tools: and Utilities: Agile central, Sourcetree, Bitbucket, Testrail, JIRA, Bitbucket, Bamboo, Testrail, Visual Studio, Microsoft Visio 2003, Visual SourceSafe, VSS, MS - Visio and FXCop

Third Party Tools: TOAD (Oracle), Infragistics and DTS

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Working as APIGEE SME for entire Synchrony account at offshore
• Taking care review and responsible for offshore APIGEE deliverables
• Taking care of Development all transmit APIGEE services
• Part of APIGEE architectural team and development part of shared flow

Confidential

Banking and financial Services

Responsibilities:

• Taking care of APIGEE development for common gate way
• Implemented CICD (DevOps) for XCharge and EdgeExpress PC products
• Taking care of ETL design to store transaction details on database
• Monitoring daily jobs and fix issue if any failure duration data transfer
• Performance tuning on SQL procs for complex reports
• ETL design for import test cases from testrail into database and vice versa
• Changes on SSRS reports
• Bulk updates on test cases, scheduling automation jobs and reporting results
• C# automation for XCharge product

Confidential

SQL Server

Responsibilities:

• ETL design and Implementation
• Performance tuning on SQL procs for complex reports
• Taking care of reviewing ETL team work deliverables
• Team management and sending weekly, monthly reports to all teh stakeholder

Confidential

Responsibilities:

• DiAl for two offshore teams (Development and QA)
• Requirements gathering and sharing with offshore
• ETL Design and Implementation
• Performance tuning on SQL procs for complex reports
• Taking care of review all our offshore deliverable
• Monitoring teh Scheduled ETL jobs and DBA activities

Confidential

SQL Server 2005

Responsibilities:

• Coding on in SSIS and SQL and taking care of review all our offshore deliverable
• Performance tuning on SQL procs for complex reports
• Requirement gathering and co-ordinating between teh Customer and Offshore team.
• Involved in database design, coding, code Integration documentations and reviews
• UAT Support

Confidential

SQL Server

Responsibilities:

• Coding on in SSIS and SQL and taking care of review all our offshore deliverable
• Performance tuning on SQL procs for complex reports
• Requirement gathering and co-ordinating between teh Customer and Offshore team.

Confidential

SQL Server

Responsibilities:

• Involved in requirements phase.
• Involved in database design, coding, code Integration documentations and reviews
• UAT Support
• Coding on in SSIS and SQL and taking care of review all our offshore deliverable
• Performance tuning on SQL procs for complex reports

Confidential

SQL Server

Responsibilities:

• 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
• Coding on in SSIS and SQL and taking care of review all our offshore deliverable
• Performance tuning on SQL procs for complex reports

Confidential

SQL Server 2005

Responsibilities:

• Coding on in SSIS and SQL and taking care of review all our offshore deliverable
• Performance tuning on SQL procs for complex reports
• Involved in requirements phase, effort/cost estimation and led teh 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

Confidential

SQL Server

Responsibilities:

• Contract management systems are used in several supply envelopes as tools to assist teh 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. Teh current landscape for Supply Contract Tracking includes three legacy applications: Contracts Database (CDB), in teh Rhine, Exchange Forecasting (XFor), in teh US (exchanges only) Visagio, in Brazil (bio fuels purchases only).
• An IT portfolio study recently recommended XFOR as teh Shell target application for Supply contract tracking. Teh Supply Design Authority endorsed dis recommendation.
• Involved in requirements phase and leading teh Team in offshore.
• Prepared teh Functional Specification and worked on design phase of teh Project.
• Coding on in SSIS and SQL and taking care of review all our offshore deliverable
• Performance tuning on SQL procs for complex reports

Confidential

SQL SERVER 2005 and SSIS.

Responsibilities:

• Involved in requirements gathering and led teh offshore team
• Writing ETL (SSIS) Scripts to migrate data as per MTA database and verified teh data which are migrated to new system
• Coordination between development team and teh performance test team, Knowledge transfer to BAM and post production support

Confidential, USA.

SQL SERVER2000, 2005 and SSIS.

Role played in project:

• Discussing requirements with Client and coordinating teh 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 teh SDLC.
• Coding on in SSIS and SQL and taking care of review all our offshore deliverable
• Performance tuning on SQL procs for complex reports

Confidential

SQL SERVER 2005 and SSIS and JD Edwards

Role played in project

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