Software Engineer Sql Server

NAZMEEN WARSI

Sr. SQL Server Developer

EMAIL ID: ************@*****.*** MOBILE: +1 – 720-***-****

Experienced software engineer with 7+ years in SQL development. Proficient in database design, T-SQL programming, and SSRS/SSIS reporting. Successfully optimized application SQL statements, resulting in 30% faster performance. Completed emergency support tasks to meet project deadlines in tight timeframes.

Motivated and ambitious database developer with advance experience of SQL Server 2005 and 2008

Report Designing, Database programming, writing Stored Procedures & Designing Database

Participated in Code review and provided suggestions for better performance of query

Experienced and have knowledge in Healthcare, Payroll, backup and recovery domains

Exceptional analytical and technical skills with the ability to deal with issues with precision & accuracy

Played important role in scheduled and emergency releases and delivering high quality products Provided the Knowledge transition sessions at project level

Experience of conducting interviews.

Onsite UK experience in handling team. Experienced in leading and mentoring new team members

Quick learner, appetite to learn new things, ability to work in a team

Result oriented professional, looking to take up the challenging assignments & meet the requirements in time

Goal driven with strong work ethics, continuously striving for improvement

Excellent Communicator with the ability to relate to people at any level of business and management

EMPLOYMENT DETAILS

Inventurus Knowledge Solutions (IKS), Mumbai Analyst Aug’19 – Feb’20

Ingram Micro, Mumbai Software Engineer - SQL Developer June’16 – Aug’17

Continuum Managed Service Provider, Mumbai Software Engineer - SQL Developer July’14 - Jan’16

Cnergyis InfoTech Pvt. Ltd., Mumbai Software Developer June’11 - Mar’14

EDUCATIONAL QUALIFICATION

Bachelor of Computer Application - Tilak Maharashtra University Pune in 2011, Distinction (75.65%)

Higher Secondary Certificate from Maharashtra Board in 2007 with (50.50%)

Secondary School Certificate from Maharashtra Board in 2005 with (47.33%)

PROFESSIONAL EXPERIENCE

Project: Unique Reporting

Profile: Analyst Employee: IKS

Technologies: SQL Server, SSIS, IM, Serve Team Size: 7

Project Description:

IKS health tracks transcription-influenced key performance indicators (KPIs) that supports the health of business with unique reporting and workflow analytics for a better understanding of Healthcare Business

Role and Responsibilities:

Experience in Programming & Implementation of SQL Server

Converting VB.net into Sybase to generate reports

Gathering reports requirement and implementing it

Project: Anovo UK, E2E, RPMS

Profile: SQL Developer Employee: Ingram Micro

Technologies: SQL Server, SSIS, IM, Serve Team Size: 11

Project Description:

ANOVO is a market-leading provider of after sales support and supply chain management services within the technology marketplace. Worked on developing solutions that extend the lifecycle of high-tech products of clients in telecom domain

Role and Responsibilities:

Understood requirements, Applied business logic in coding and implementing solution

Written and optimized application SQL statements

Ensured performance, security, and availability of databases

Prepared documentations and specifications

Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Worked on Profile server resource usage, and optimize and tweak as necessary

Collaborated with other team members and stakeholders

Provided emergency support and helped management in valuable output and client retention

Supported weekends and extra hours to meet deadlines of Annovo UK project

Project: VM Ware, Patch Management of Systems

Profile: SQL Developer Employee: Continuum managed service provider PVT. LTD

Technologies: SQL Server 2008 R2, JIRA Team Size: 3

Project Description

VM Ware: VM Ware provides complete end-to-end business continuity solution that ensures the protection and recovery of critical business data stored on Microsoft Windows servers and desktops, also known as Backup Disaster Recover (BDR). Data of client’s VM and V-Center is stored in database, data is monitored, and multiple reports are generated on specific intervals.

Patch Management of Systems: Patch Deployment is a process which involves the deployment of hot fixes/patches that are released from time to time. The project ensures that each machine of clients is up to date with latest Patch. The patches on system are done by Manual, Auto, Scheduled and on-demand deployment.

Role and Responsibilities:

Created documentation for business logic and database objects

Participated in discussions involving the application creation

Analyzed and understood the requirements

Provided the back-end functionality for the applications

Created database objects such as Tables, Views, Stored Procedures, Indexes and Triggers

Troubleshooting issues in the previously developed applications and provided permanent solution

Identified columns for Primary Keys in all the tables at the design time and created them

Created functions to provide custom functionality as per the requirements

Created stored procedures for application and tested them on prerelease portal

Optimized the queries and stored procedure to make the application run faster

Identified and written best possible code for new deployments and when rewriting code while migrating to newer version of SQL Server

Created and shared the reports of the application with management

Project: Human Resource Management System

Profile: Software Developer Employee: Cnergyis InfoTech Pvt. Ltd.

Technologies: Visual studio 2008, SQL Server 2008, SSRS Team Size: 6

Project Description:

HR software programs are bundled and integrated together internally to make the HRMS behave as a single HR system software. The project involved functions like tracking employee histories, skills, abilities, salaries, and accomplishments.

Role and Responsibilities:

Gathering and analysis of client’s requirements

Designing the software application

Worked on Database (Designing Table, Views, Maintenance Plan, etc.)

Worked on T-SQL Programming (Writing Stored Procedures, Trigger, cursors)

Report Designing & Generation (SSRS, SSIS)

Tested the software units

Integrated each unit into software components & tested the final software components

Implemented the enhancements into final software product

SKILL SET

Create, maintain, modify, and optimize SQL Server databases

Having Strong Practical Knowledge & Programming Logics in Writing Stored Procedures, Triggers, User Defined Functions, Views, and Cursors

Common Table Expressions, SQL Queries, Sub Queries

Index Creation, Index Tuning, and Query (Tuning, Optimization & Performance Analysis)

Having knowledge of BI Tools in SSRS, SSIS, IM and Serve

Analytical Skills, Backup and Recovery, Common Table Expressions, Communication, Database Design, Database programming, Performance Analysis, Programming, Query Tuning, Report Designing, Stored Procedures, Table Design, T-SQL Programming, Views Design, Visual Studio

PERSONAL DETAILS

Name : Nazmeen Musa Warsi

Address : 21086 E Radcliff Pl, Aurora, CO – 80015 (USA)

Date of Birth : 08th Dec 1988

Nationality : Indian

USA Visa : H4 (EAD)

Gender : Female

Marital Status : Married

Hobbies : Cycling, Reading, Travelling, Music

Languages Known : English, Gujarati, Hindi and Marathi

DECLARATION

I hereby, declare that the above given details in my Curriculum vitae are true to best of my knowledge & belief.

{Nazmeen Warsi}

Contact this candidate