B.PRAMOTH

MS SQL DEVELOPER

Mobile: +91-979**-*****

E-Mail: addan1@r.postjobfree.com

OBJECTIVE

To build my carrier in a progressive organization that will provide me exciting opportunities to learn more and utilize my skills and experience. My key strength is my ability to learn more and produce results within a reduced time frame and with minimum learning curve.

EXPERIENCE AND SKILLS

I have 6.6 years of IT experience in Microsoft SQL Server 2012/2008/2005 with knowledge of MSBI (SSIS, SSRS).

Expertise with backend programming using SQL,T-SQL, Stored procedures, triggers, functions, views, cursors on databases.

Hands on performance optimization for server and Query tuning.

Expertise preparing report specifications and database designs to support reporting requirements.

Proficient in writing complex SQLs to Extract and Transform data from various data source and debugging SQL related problems

Ensuring all the assigned tickets are resolved within SLA time based on priority

Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.

Good communication and interpersonal skills.

TECHNICAL SKILLS

Databases

Microsoft SQL Server 2012/2008/2005

ETL Tool

SSIS

Reporting tool

SSRS

Operating Systems

Windows 10

Versioning

TFS, VSS

Certification

Oracle 10g, ORACLE 10g OCP in DBA

Certification ID: OC1114725

WORK EXPERIENCE

Senior SQL Developer in Valgenesis India PvtLtd,Chennai from Jan 2019 to 19-dec-2019.

Senior Software Engineer in RLab Global Enterprise Service, Bangalore from May 2018 to Dec 2018.

Senior Software Engineer in IT Trail Blazers Consultancy, Bangalore from Nov 2017 to May 2018.

SQL Developer in Sulekha.Com New media Pvt ltd, Chennai from Sep 2015 to Aug 2017.

Analyst Programmer in Ramco Systems, Chennai from May 2014 to Aug 2015.

Software Engineer in Bartronics Global Solutions Limited, Chennai from Feb 2013 to Apr 2014.

EDUCATIONAL QUALIFICATION

●MCA 73% - Anna University Chennai

●B.Sc Computer Science 72% - Bharathiyar University Coimbatore

PROFESSIONAL EXPERIENCE

Valgenesis India Pvt LTD, Chennai 02-Jan-2019 – 19-dec-2019

Senior SQL Developer

Product Name: Valgenesis 4.0.

Valgensis 4.0 supports life science companies to bring products to market quickly, safely and efficiently by delivering integrated paperless validation lifecycle management software solutions that provide data integrity, consistency, control and transparency across the organization.

Responsibilities:

●Analyzed, developed & modified T-SQL, SQL objects like Procedures and Functions

●Involved table structure review for new development.

●Involved metadata preparation & test data population to testing.

●Involved backend related bug fixing with Front developer.

●Coordinated with application developers to guide and create optimized queries

●Design and develop T-SQL, Procedures, query performance tunings

●Involved in development of SSIS ETL packages

●System Testing, Unit Testing, Project Deployment

●Developed SSRS reports

●Involved TFS check in (SQL Objects like Procedures, Function and Tables) for source maintenance.

ILab Enterprise services, Bangalore 17th May 2018 – 14th Dec 2019.

Senior Software Engineer (MS SQL Developer)

Client Company: IBM India Private Ltd, Chennai.

Project Name: Olam – SAP Migration.

OLAM are a leading agri-business supplying food, ingredients and raw materials to over 22,000 customers. OlamUsed two major software products to maintain their business, which are SAP & PLUTO Contract Management System. OLAM needs Synchronization between SAP & PLUTO.

Interface stored procedures created for Contracts based on the mapping document and xml shared in the document which is interfaced from SAP and send the return interface to SAP with Purchase Contract details and receive SAP Contract number back to PLUTO via Interface to save in PLUTO for reference

Responsibilities:

●Analyzed, developed & modified T-SQL, SQL objects like Procedures and Functions

●Created Reference Validation for interface data and Exception Handling code added for Interface Stored procedure to prevent dynamic error and find that particular transaction (Interface) Success or failure.

●Worked with application developers to guide or create optimized queries

●Design and develop T-SQL, Procedures, query performance tunings

IT Trail Blazers Consultancy, Bangalore Chennai 17th Nov 2017 – 16th May 2018.

Senior Software Engineer

Client Company: Attune Technologies, Chennai

Attune Lab Information System is designed exclusively for lab owners and pathologists to help manage the daily operations of the lab efficiently and grow the business. System dealing with the unpredictability of number of samples to be processed on a daily basis for planning resource and reagents and most of all the need to grow and scale the business to multiple centers and cities, fast. Finally generated report and send to the end user.

Responsibilities:

●Reviewed query performance and optimized code

●Worked with application developers to guide or create optimized queries

●Creating table indexes to improve database performance

●Analyzed, developed & modified T-SQL, SQL objects like Procedures and Functions

●Design and develop T-SQL, producers, query performance tunings

●Created table indexes to improve database Object performance.

Sulekha.com, Chennai Sep 2015 – Aug 2017.

Database Lead

Sulekha.com is an Indian website which hosts classified ads, social networking, and other forms of user-generated content. Rentals, real estate are the most popular services provided by sulekha.

Responsibilities:

●Analyzed, developed & modified T-SQL, SQL objects like Tables, Procedures and Functions for Mobile App.

●Design and develop T-SQL, producers, query performance tunings

●Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

●Reviewed query performance and optimizing code

●Created table indexes to improve database performance ( views, stored procedures, and functions)

●Checking daily back end related error log files

●Worked on optimizing SQL Server performance, monitoring and queries tuning

●Created and configured Daily scheduler jobs (stored procedures) & monitored for Lead providing to customer, ad expiry & checking duplicate ads in database

●Prepared adhoc reports from database table for customer support team requirement. & product team.

●Involved in development of SSRS Report Sps (Topslot report – Paid Ads)

Project description.

Realestate& rentals are two most popular services provided by sulekha. Customer real estate projects are created & relevant ads created and listed in sulekha websites. User can search who wants properties new & old can get through sites as per his requirement (city,locality,budget& area).Customer can get direct responses through sites & we are giving leads

Ramco Systems Ltd, Chennai May 2014 – Aug 2015.

Analyst Programmer (SQL DEVELOPER)

Responsibilities:

●Analyzed, developed Tables, Procedures and Functions as per the requirement.

●Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

●Developed and Supported the Batch process during UAT and Pre-UAT.

●Created database objects through development, testing and production environments

●Alert mail created using scheduler stored procedure and configured as job.

Project Description:

Ramco Systems is a leading provider of functionally distributed Enterprise Wide Resource Planning (ERP). Ramco ERP is an integrated, Client Server suite of Business applications Designed using Microsoft tools and technologies. Ramco ERP encompasses all aspects of the working of an Enterprise such as Logistics, Sales, Production, Finance, Human Resources Management and Manufacturing.Ramco ERP is implemented at more than 300 customer locations around the world. Ramco ERP is also available on CLOUD hosted on Amazon Web services.

Service Resource Planning(SRP) is an integrated cloud-based solution that caters tp the entire engagement life cycle of a Professional Services Organization(PSO),which typically extends over

Requisition to Release (R2R) : Resources are at the heart of operations for Professional Services organizations. Starting with workforce capacity planning that is glued in with the recruitment process, the solution covers the Human Capitial Management process.

Bartronics Global Solutions Limited, Chennai Feb 2013 – April 2014. Software Engineer (SQL DEVELOPER)

Client Company :Ramco Systems Ltd, Chennai

Responsibilities:

●Analyzed, developed Tables, Procedures and Functions as per the requirement.

●Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

●Developed and Supported the Batch process during UAT and Pre-UAT.

●Created database objects through development, testing and production environments

●Alert mail created using scheduler stored procedure and configured as job.

Project Description:

Service Resource Planning(SRP) is an integrated cloud-based solution that caters tp the entire engagement life cycle of a Professional Services Organization(PSO),which typically extends over

Requisition to Release (R2R) : Resources are at the heart of operations for Professional Services organizations. Starting with workforce capacity planning that is glued in with the recruitment process, the solution covers the Human Capitial Management process.

PERSONAL DETAILS

Father’s name : P.K. Balakrishnan

Date of Birth : 07.02.1986

Marital status : Single

Sex : Male

Communication Address : 17/12F, Ethirajstreet,

Pallipettu, Sriramnagar road,

taramani,

Chennai-600113

Permanent Address : 6/44,PonneGoundanPudur,

S SKulam (Via)

Coimbatore – 641107.

Language known : English, Tamil, Malayalam.

Contact Number : +91-999**-*****

DECLARATION

I hereby do affirm that the above mentioned details are true to the best of my knowledge and belief.

Place :

Date : (B. PRAMOTH)

Contact this candidate