Sql Server Developer

Mahima Nagaraj

Houston,TX

******.**@*****.***

Ph: 248-***-****

(US Permanent Resident – Green Card)

Objective: Highly motivated, enthusiastic, creative and customer-focused SQL Server Developer, a team player with extensive SQL programming experience in finance and healthcare industries seeking to add value to a challenging IT organization located in the Houston metro area.

Education & Training

Master of Science in Electrical Engineering (GPA: 3.8/4.0) Dec 2009

University of Bridgeport, CT – 06604

Thesis: “Protecting Privacy of Clinical Data Transmission using Random Routing Protocol”.

Relevant Courses: Digital Signal Processing (DSP), Pattern Recognition, Soft Computing, MATLAB.

Professional Diploma in IT, NIIT Technologies, Bangalore, India June 2005

(MS SQL Server and MS .NET Technologies)

Bachelor of Engineering, Electrical and Electronics (First Class) June 2003

Visveswariah Technological University, Bangalore, India.

Technical Skills

Relational Databases: SQL Server (2000, 2005, 2008, 2012,2014,2016), MS Access.

Querying Tools: T-SQL, PL/SQL, SQL Loader and TOAD.

Reporting Tools: SSRS, Crystal Reports, Tableau.

Modeling Tools: Erwin, MS Visio.

ETL Tools: SQL Server Integration Services (SSIS)

Programming Languages: C, C++, C#, .Net Technologies, MATLAB.

Web Portal Technologies: HTML, XML.

Operating Systems: Windows (98, 2000, NT, XP), Windows Server 2000/2003, UNIX, LINUX.

MS Office productivity suite: Word, Excel, Outlook.

Recent Professional Experience & Accomplishments

Envoy Mortgage, Houston TX

SQL Server Developer Sep 2017 – Feb 2018

Roles and Responsibilities:

oDesigned and developed SQL Server Agent Jobs report in SSRS and set up subscription.

oWorked on SSIS packages to enable Marketing team to send and receive files over FTP.

oCreated SQL server tables to load data from SSIS.

oInvolved in setting up new AD Groups as a part of Database login rationalization.

oInteracted with remote operations team in India to monitor the SSRS jobs.

Environment: Visual Studio 2015, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server Reporting Services (SSRS), C# Scripts, SQL Server.

Situs Holding, LLC Houston, TX

SQL Server Developer Dec 2015 – Apr 2017

Roles and Responsibilities:

oDesigned and developed financial analytics reports for different clients using SQL Server 2012/2016.

oCreated and customized reports based on individual client needs SSRS and Developer/Web/Desktop versions of MicroStrategy 10.5 software.

oExtensively worked on creating dashboards, Ad-Hoc parameterized reports, drilldown and drill through reports.

oMonitored the performance of the reports.

oSuccessfully implemented turn-around-time feature for different time zones.

oSuccessfully set up status thresholds for various ongoing client projects involving commercial real-estate investments

oImplemented report subscription to be delivered in MS Excel format for different clients on a weekly basis.

oUsed data from Cubes, SharePoint, Salesforce to create reports.

oUsed Report Builder and Report Designer for report creation.

oModified reports using Crystal Report for Invoice and Payment details.

oWorked with a global team of Business Analysts and Project Managers for project implementation.

Environment: Visual Studio 2015, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server Reporting Services (SSRS), C# Scripts, SQL Server, Crystal Reports, Tableau, Microsoft PowerBI

Planned Parenthood Federation of America, Manhattan, NY

SQL Server Database / SSRS Developer Apr 2014 – Feb 2015

Roles and Responsibilities:

oSuccessfully helped PPFA to develop a sophisticated online automated data survey system.

oWorked with 6 member business intelligence team of PPFA in migration from Sharepoint 2007 to SharePoint 2013.

oLoaded more than 80 PPFA affiliates data from multiple years into the database, fixed bugs in the clinical data and stored procedures.

oSuccessfully planned and coordinated with external vendor NIFTIT in Vietnam and New York City for SharePoint migration in PPFA through web meetings and Basecamp project- management tool.

oWorked with business analysts within the team to implement changes in the database.

oExtensively interacted with QA testing team to validate the loaded data for report generation.

oExtensively used DDL statements in the process of loading the affiliate's clinical survey.

oUpdated the Stored Procedure for calculation and creation of new data in the survey.

oGenerated reports using SSRS 2012 for data analysis.

Environment: Visual Studio 2010, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server Reporting Services (SSRS), C# Scripts, SQL Server, Crystal Reports, Tableau.

Trisync Technologies, Edison, NJ Feb 2010 – May 2012

MS SQL Server/SSRS/SSIS Developer

Roles and Responsibilities:

oSuccessful SQL IT consultant position working on various client projects.

oCreated SSIS packages to fetch data from different sources.

oUsed SSIS 2008 to load data from different formats like .csv, .xlsx, .txt into SQL Server tables.

oCreated stored procedures to validate update and load data.

oExpertise in developing, validating and optimizing Crystal Reports using Business Intelligence.

oUsed Script Component to archive, Rename and Extract date from files.

oUsed DDL statements and Stored Procedures in packages tasks.

oUsed Send Mail tasks in packages to mail the vendors.

oCreated Stored Procedures to maintain the valid data of all the vendors in one table.

oUsed SSRS 2008 to generate reports for Business Users for analysis to automate processes.

oReports were presented in Excel/PDF file formats based on the business requirements.

oImplemented business logic and documented Stored Procedures for different vendors.

oUsed MS VISIO 2003 to map different tables, temporary tables, views and joins in Stored Procedures for Business analysis purposes.

oCreated packages to send error data and obtain valid data from the vendors.

oGenerated cascaded parameters to present data in hierarchical format.

oCreated Drilldown reports for country wise presentation of data.

oWorked with report parameters and generated about 15 – 20 reports daily.

oUsed Tidal Software to schedule jobs daily for loading data.

Environment: Visual Studio 2008, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server Reporting Services (SSRS), C# Scripts, SQL Server Integration Services (SSIS), Tidal.

Graduate Research/Teaching Assistant May 2008 – Dec 2009

Department of Electrical Engineering.

University of Bridgeport, CT - 06604

Roles and Responsibilities:

oWorked as research assistant to develop a protocol for secure transmission of clinical data across the network using Omnet++ software with SQL & MATLAB programming.

oTeaching Assistant for Graduate-Level Courses: Digital Signal Processing (DSP) and Pattern Recognition (PR).

Service Activities

oVolunteered at the Houston Food Bank to install team foundation server (TFS) for the IT department (June 2015).

Awards

oAwarded second place for a technical paper presentation at the India National Level Tech. Symposium, Feb 2003, Pondicherry University, India.

Contact this candidate