Mita Sharma Eden Prairie, MN *****

ac40co@r.postjobfree.com

612-***-****

ROLES

SQL Developer

Integration Specialist

Sr Software Engineer

Technical Lead

Systems Developer

METHODOLOGIES

Agile

Waterfall

TECHNOLOGIES

MSSQL(SSIS,SSRS)

Datawarehouse

.NET

C#

XML/JSON

Sitefinity

ASP.NET (Web Forms, MVC)

HTML, CSS, JavaScript

Visio

INDUSTRY EXP.

Insurance

Retail

E-Commerce Systems

Payment Applications

Payment Gateway

Operations Management

EDUCATION

Bachelors in Computer Science and Engineering, West Bengal University of Technology, West Bengal, India

EXPERIENCE SUMMARY

Mita Sharma offers 12+ Years of experience of various programming languages. Experience includes roles responsible for business analysis, development, testing, integration and migration of applications pre-dominantly using Microsoft technologies MSSQL(SQL Server Integration Services[SSIS]; SQL Server Reporting Services[SSRS]), Service Oriented Architecture(SOA) principles(WCF), XML, WSDL, ASP.NET, ASP, VB6, VB.net). Excellent Documentation skills to document system for transition and application architecture. 6+ years of experience in end to end execution of small/medium/large scale projects in retail and insurance applications. Experience in Prototype creation (vision for flows & use cases) for multiple projects. Worked in Waterfall as well as Agile development

Strong Co-ordination skills from client/Onsite location, debugging and problem solving skills with very good understanding of system development methodologies, techniques and tools. Ability to learn fast

and work well under pressure.

MSSQL developer and .net skills set.

Authorized to work in the US for any employer

SKILLS

RDBMS

SQL Server 2000/2005/2008 R2/2012/2016

Integration Technologies

SSIS; SSRS; SSAS; windows script

XML Related Technologies

XML, XSL, XSLT, XPath, XPointer, SOAP, WSDL, REST

Programming Languages

ASP.NET2.0/ 3.0 / 3.5 / 4.0 / 4.5, VB.NET, C#.NET, ADO.NET,ADO, ASP,C, C++, C#, VB 6.0, T-SQL

Scripting Languages

Java Script, VB Script

Design Tools

MS Visio

Application Servers

IIS, Apache

Version Control

Visual SourceSafe, SVN, TFS

Unit Testing and Code Analysis

Storm, Swagger, Resharper, SOAPUI, WCF

Defect Tracking Tool

Jira, Remedy, HP Tool, Smartsheet, Quality Control

Content Management System

Sitefinity

Worked on MS SQL to create database tables, stored procedure, functions and views. Optimized complex queries for better performance using SQL Profiler and database engine tuning advisor

A high potential business advisor experienced in enterprise systems integration, information delivery, and process/workflow development with effective communication skills. Integrated multiple system using SSIS, windows command script -

Extraction, transformation and loading of data from Securitylife system and SmartOffice(EBIX) to Ebix Enterprise system.

Create proprietary format files for different Liveverywell exchange partners

Load Vertafore agent/agency demographics, license and appointment data into SmartOffice

Load commission statement from Ebix Enterprise to be available online in Securitylife

SSRS parameterized reports for sales team per business requirement and subscription setup

Created and maintained WCF web services to getrates, do enrollments and search providers using C#, SQL and 3rd party web service(USPS, Authorize.net, Ebix Enterprise, SmartOffice, Elavon payment gateway) utilization.

Developed, Managed, Designed and implemented technical solutions across multiple Technologies (C#.NET, VB.NET, ASP.NET, VB6 and ASP3.0, HTML5, JavaScript, Jquery, CSS, PowerShell.)

4+ years of expertise in working on developing/enhancing the User Interface (UI) using different UI components like HTML5, JQuery, CSS3 & JavaScript for intranet facing web applications

Worked multiple tools (PVCS Dimensions, TFS, CVS, Crystal reports, ControlM, HPSD, HP QC, Visio, VBA, HP Diagnostics, PowerShell UI)

Virtualized and migrated over 3000+ Windows servers with their applications to Windows 2008 or cloud servers

Scalability expert - Worked on migrating applications from MSSQL 2005 to 2008/2012 version

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Senior Developer(Integration Specialist) Gather Requirements, Design, Develop, Test, Integrate and Deploy.

Security Life Insurance Company of America (Ameritas subsidiary)

Minnetonka, MN December 2013 to Present

Worked on MS SQL 2005/2008/2016. Designed and created database tables, stored procedure, functions and views. Optimized complex queries for better performance using SQL Profiler. Encrypted data using tripleDES algorithm at database column level to maintain data confidentiality

Helped improving Securitylife.com performance by getting plan details from Sitefinity(CMS) database directly rather than the dlls provided by them

Used SSIS package for Live Very Well Exchange to share data between different partners and performing Extraction, transformation and loading of data from Securitylife system and SmartOffice(EBIX) to Ebix Enterprise system.

Data Integration using different transformations like Lookup Transformation to get the data from reference data sets, derived column, etc.

Analyzed preexisting SSAS datawarehouse to find the issue with the fact table reference in Stored Procedure for data issue

Create SSRS parameterized reports for sales team to analyze the sales numbers and pattern which helped evaluate different partners for performance thereby negotiating the commission percentages. In SSRS, created datasets using stored procedures and reports using multi value parameters. Used Report Manager to assign roles, permissions and to create report schedules. Used data driven subscription to automated sending mail to recipients.

Effectively used views to prevent unauthorized access.

Tuned SQL queries using execution plans for better performance.

Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.

Agents License and Appointments along with demography data from Vertafore to Agent Administrative system: Smart Office(Ebix)

Moved the application architecture to service oriented architecture by implementing WCF web services to getrates, do enrollments and search providers using C#, SQL and 3rd party web service utilization.

Created RateEngine based on zip, state, age, coverage level. Created automated testing with the help of SQL for testing rates for all possible combination of state, zip codes and plan codes

Create proprietary format files for different Liveverywell exchange partners

Load Vertafore agent/agency demographics, license and appointment data into SmartOffice

Developed, Managed, Designed and implemented technical solutions across multiple Technologies (C#.NET, VB.NET, ASP.NET, VB6 and ASP3.0, HTML5, JavaScript, Jquery, CSS, PowerShell.)

Sr. Systems Developer – Lead Project developer

Target - Minneapolis, MN September 2007 to November 2013

Understanding the architecture of existing system and perform impact analysis for SQL upgrade from compatibility standpoint.

Understand the design change from the application code in-order to make the application compatible with SQL 2008. Pilot implementation and testing.

Coordination with application and business users regarding the unavailability of applications during the implementations.

Serve as Technical point of contact for all Business and Application teams in Target to discuss on understanding the feasibility of upgrade and migration of SQL 2008 and design change in the applications

Documenting the application changes and app code version changes.

Post implementation support.

Coordinate with the vendors for vendor provided application to check the feasibility and upgrade the Target systems.

Working as a technical contact and handling managerial activities for estimations and project proposals in planning the servers that needs Life Cycle Management(LCM) for financial year 2012, 13 and 14

Analyze the applications installed in the Windows 2000/2003 servers from compatibility point of view and then determine the possibility of virtualization and migration to new OS version Virtualization – Physical(P) or Virtual(V) – P2P;P2V;V2V;Windows 2008 Migration, Move to NAS[Network Attached Storage].

Retail -Applications related to different business portfolio

Finance - Essbase, Assure net, Reconnect, Pay base

Property development - Prolog

Marketing - Documentum, Aprimo Marketing information exchange, XMPie from Hagen

Asset Protection - Loronix, Genetec Omnicast

Target Technology Services - Request Center, HPSD,etc

Supply Chain (Grocery & General Merchandise), Item Management, Pricing & Promotions,

Replenishment / Forecasting, Order Management - Automated & Manual Ordering, Store Demand fulfillment, Warehouse Operations, Inventory Management, Non-Retail Management

Project Management

Cost estimation, resource planning and statement of work creation

Weekly and monthly report presentation to Group manager and Project Management

Review and client co-ordination for multiple projects, Co-ordinated large/medium Engagements

involving cross functional systems spanning across Supply & Distribution Pyramids

Planning and tracking of multiple projects spanning across multiple business areas through all phases of SDLC.

Coordination from Onsite with peak team size of 25

Developer

Tata Consultancy Services (TCS) - Chennai, Tamil Nadu December 2005 – September 2007

Worked on MS SQL 2000/2005/2008. Create database tables, stored procedure, functions and views. Optimized complex queries for better performance using SQL Profiler

Database Stored procedure and view analysis involving multiple Database server sources(using

Linked server)

Enhancement work on Service Change Requests involving .NET, VB, Java.

Requirement gathering and analysis for service change requests

Solving client issues by designing and Developing solution for service change requests

Performance tuning for the batch programs/jobs

Documentation and Implementation of the Service Requests

Development consulting for new projects on applications owned by me

Contact this candidate