Developer Service
Resume:
Mita Sharma Eden Prairie, MN *****
******.****@*****.***
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