Sql Server Developer
Resume:
PRIYANKA MHAPSEKAR
SUMMARY:
About * years of experience in development of software applications for Banking, Financial Services and Insurance, Media & Entertainment, Oil & Gas industry sectors using .NET and SQL Server. Focused on development, support and implementation of web and windows based applications using SDLC or Agile (Scrum) method.
TECHNICAL SKILLS:
Technologies/ Languages
.NET, ASP.NET, C#, VB.Net, Classic ASP, MVC4, Razor, Entity Framework, LINQ, Web Service, jQuery, JavaScript, Anglarjs, HTML 5, CSS, XML, T-SQL, C, C++
Database
SQL Server 2005/2008/R2/2012, MySQL
BI/ETL
Microsoft SSIS, SSRS
Code Management
Microsoft Team Foundation Server 2005, 2008, 2012
EXPERIENCE
Software Engineer, BitsOfCode Software Systems, Inc., Houston, Texas Oct 2014 – Present
PROJECTS:
Customer: Cameron International Corporation
Role: Application Developer – Well Market Share Oct 2014 –Present
Technologies: ASP.NET, Entity Framework, MVC, Razor, jQuery, SSIS, SSRS, SQL Server 2008 R2/2012.
Web application to analyze Cameron’s and their competitor’s market share in market segments they operate.
Responsibilities:
Designed and developed Web application using MVC/ Entity Framework/ Razor.
Created SQL Agent job which invokes the SSIS package managing and loading multiple types of data feed files.
Developed complex SQL Stored procedure for managing and processing Market/Rig data.
Developed several reports in SSRS to analyze operators and suppliers market share.
Sabbatical, January 2014 – September 2014
Leant and practiced new technologies during the break. Did certification of .NET Framework 4 and Web Applications.
Software Engineer, L&T Infotech., India Nov 2012 – Dec 2013
Customer: Paramount Pictures
PROJECTS:
Role: Application Support - PARIS (Participation & Residuals Information System) May 2013 – Dec 2013
Technologies: Classic ASP, ASP.NET, SSIS, SSRS, SQL Server 2008
Web application to monitor and manage participation contracts and residual statements to ensure timely reporting and payment of residuals.
Responsibilities:
Developed SSIS packages to manage various data sources and routing queues for Data staging module.
Developed SSRS reports for participations contracts, calculated statements, and Picture Analysis.
Enhance and maintain supporting application developed in ASP.NET.
Application support for maintaining existing Classic ASP application.
Role: Application Developer - Library Management System (ALIAS/OPIS) Nov 2012 – Apr 2013
Technologies: .NET Framework 3.5, ASP.NET, Web service, SSIS, SSRS, SQL Server 2008
Web application for archiving digital and physical assets, built using service oriented concepts.
Responsibilities:
Developed supporting metadata information tool using ASP.NET /jQuery, access information from web service and migrate information in different file formats.
Manage and access asset information in SharePoint lists and document libraries from application.
Responsibilities included enhancing and maintaining OPIS/ALIAS application in ASP.NET.
Developed reports in SSRS for Digital and Physical assets.
Software Engineer, Nucsoft Ltd., India Aug 2010 – Oct2012
PROJECTS:
Customer: Major Bank
Role: Application Developer - Credit Facilities Monitoring System (CFMS) Jan 2012 – Oct 2012
Technologies: .NET Framework 4.0, ASP.NET, Java Script, Web service, JQuery, SSIS, SSRS, SQL Server 2008.
Web application to maintain monitored credit facilities given to clients and tracks documents to ensure the completeness of the credit facilities to cover bank’s risk and protect the bank’s interest at all times.
Responsibilities:
Participated in requirement gathering for enhancement of application.
Developed Web application in ASP.NET/Web Service/jQuery in Agile (Scrum) environment.
Devolved document tracking logic and email handling.
Developed complex queries for security management and SSRS reports mainly in Basel Reporting.
Role: Application Developer - Loan Servicing System (LSS) Sept 2011 – Dec 2011
Technologies: .NET, C#, WinForms, SSIS, SQL Server 2005
Developed a Single-tier windows application which migrate exiting system data to new database. Exiting system images which are captured as flat files will be moved to new database.
Responsibilities:
Developed complex scripts for migrating data.
Created SSIS packages for execution SQL scripts and database activities.
Developed Windows application in .NET/C# to run migration scripts and generate log information.
Role: Application Developer - Operational Risk Management (OpRisk) Feb 2011 – Aug 2011
Technologies: .NET Framework 4.0, ASP.NET, Java Script, Entity Framework, Linq, SQL Server 2008
Web application which collects, consolidates, analyses and reports critical information relating to Operational Risk, in a single scalable solution.
Responsibilities:
Developed the Web application in ASP.NET/ Entity Framework in Agile (Scrum) environment.
Developed Color scales and Heat Map using JQuery for generating Risk Matrix.
Developed workflow to handle risk events in ASP.NET
Role: Application Developer - Fund Transfer Pricing System (FTPS) Aug 2010 – Jan 2011
Technologies: .NET Framework 4.0, ASP.NET, Java Script, Entity Framework, Linq, SQL SERVER 2008
Developed web application pricing system to compute fund transfer pricing income after deducting cost incurred in arranging the funds through treasury.
Responsibilities:
Developed Web application in ASP.NET.
Developed complex stored procedures for calculating FTP income.
Developed Excel based reporting for maintained Deposit and contracts.
Customer: Internal Aug 2009 – Jan 2010
Role: Application Developer – Job Portal
Technologies: .NET Framework 3.5, ASP.NET, Java Script, SQL SERVER 2005
Web application for candidates to create profile and apply for posted job and for employers to post job opportunities and search candidate from the registered candidate database.
Responsibilities:
Developed Web application in ASP.NET for creating job and candidate profile.
EDUCATION QUALIFICATION AND CERTFICATION:
Bachelor of Engineering in Information Technology (2005-2009) from University of Mumbai, India.
Completed a course of Windows & Web Application Development using .Net Framework from NIIT, Mumbai, India (Jan 2010).
Microsoft® Certified Technology Specialist: .NET Framework 4 and Web Applications.
Contact this candidate