Salman Kamruddin Rajwani

Mobile : +1-613-***-****.

Email : acy3ec@r.postjobfree.com

OBJECTIVE:

Hard working and motivated IT industry professional with proven organizational skills and proficient in Software Development Life Cycle (SDLC) with Agile processes seeking to apply my abilities and experience to the position of developer/architect in database and data warehouse technologies. PROFFESIONAL SUMMARY:

Around 4.1 years of experience in IT having experience in Database and MSBI Development& Support of MS SQL Server 2014/2012 and 2008R2.

Certified in Querying Microsoft SQL Server 2012/2014 (70-461).

ITIL Foundation Certification IT Service Management.

Good knowledge and experience in working with Agile – Scrum Master Methodology.

Proficient in Relational Database Management Systems (RDBMS).

Proficient in Tuning T-SQL queries to improve the database performance and availability.

Expertise in creating SSIS Packages for data migration, data loads and client reporting.

A good team player with excellent analytical, communication and interpersonal skills.

Experience in creating Jobs, Alerts, SQL Mail Agent scheduling DTS and SSIS Packages. Certifications:

1. 70-461 Querying Microsoft SQL Server 2012/2014 – January 2016. 2. ITIL Foundation Certification IT Service Management – June 2015. 3. BDA Certification for telecom domain (internal to TCS India). 4. Human Capital Management Basic certification (internal to ADP India). Technical Skills:

DB Tools : MS SQL Server 2008/2012 & 2014, MSBI.

Support Tools : ITSM, HPSC, BMC Remedy.

Operating Systems : Windows.

Languages : T-SQL, MDX, RIFL.

Education:

Bachelors of Technology in Electrical and Electronics Engineering from JNTU, Hyderabad, India (2008 - 2012). WORK EXPERINCE:

Company: Designation: Duration:

ADP Private Limited. (India) Member Technical. Feb 2016 to Jan 2017 (11 Months) TATA Consultancy Services. (India) System Engineer. Dec 2012 to Jan 2016 (3 Years 2 Months) Project Details:

1. NAS – HCM implementation (Benefits) at ADP private Limited ADP is a Human Capital Management (HCM) company which provides various services like HR, Payroll, and Benefits etc. Benefits area deals with importing data from various sources provided by the client and their vendors, transforming it and maintaining in ADP systems. Role ETL Developer

Duration Feb 2016 – Jan 2017

Team Size 7

Environment Details

Tool Pervasive

Language RIFL, SQL

Responsibilities:

Extracting the data from various sources like DBs and Flat files provided by the client and their vendors.

Importing and transforming the data into ADP environment.

Loading and maintaining the data in ADP systems. 2. Manufacturing Intelligence at Tata Consultancy Services. MI is a manufacturing intelligence application which collects data from different source formats such as flat files, Data base, zipped files etc. and performs the ETL actions and finally loads it into the database and from the database the data is sent into the cubes from where a micro strategy front end is used to display the data through UI.

Role ETL and SQL Developer

Duration Mar 2015 – Jan 2016

Team Size 7

Environment Details

Tool SQL Server 2014, SSIS

Language T-SQL, MDX

Responsibilities:

Performing the data loads and fixing the issues related to source file interruption.

Loading monthly and quarterly business data as per requirements.

Adding new data source from different factories to the existing system.

End to end responsibility to Production deployment. 3. Premium Cashflow Management at Tata Consultancy Services. Premium is an advanced version of OPCM which has much more scope and functionality with a bigger user support and better performance. Premium has a complex DB structure which includes Clustered DB failovers, High availability, Replication & Service Broker. It also uses ETL tool (SSIS) to extract & load business critical data. Role Support Executive / ETL & SQL Developer

Duration Jan 2014 – Mar 2015

Team Size 10

Environment Details

Tool SQL Server 2012, SSIS

Language T-SQL

Responsibilities:

OPCM – Premium data migration using MSBI (SSIS - ETL Tool) from SQL 2008 to SQL 2012 by maintaining the integrity with the integration systems.

Module Lead for all the Integrations, Business data loads and reporting.

Data correction fixes for any bad data in the system by maintaining referential integrity with the system.

Identifying and tuning queries to obtain performance gain. 4. Opportunity Profitability & Cash Flow Management at Tata Consultancy Services. OPCM is a sales tool for price steering, profitability, risk and cash flow analysis to support the client’s sales process. The purpose of OPCM is to consolidate profitability, price governance, cash flow and risk analysis to improve accuracy of the financial and pricing part in Sales Decisions Points (SDP). Role Support Executive / SQL Developer

Duration Feb 2013 – Jan 2014

Team Size 6

Environment Details

Tool SQL Server 2008, SSIS

Language T-SQL

Responsibilities:

Support the users to run their business smoothly and efficiently.

Create database objects such as tables, views, stored procedures, Triggers which automates and improves the performance by archival of old data etc.

Design, Develop and Deploy SSIS Packages for data loads and data retrieval from DB. Extracurricular:

Organized team outings, monthly and quarterly celebrations for the account.

Organizing and active Participation in various sports and cultural events.

Received multiple Spot awards for being proactive & delivering quality work well within stipulated time. Personal Details:

Date of Birth : March 17, 1991.

Languages Known : English, Hindi and Telugu.

Contact this candidate