Post Job Free

Resume

Sign in

Sql Server Business Analyst .Net Developer 2008

Location:
Charlotte, NC
Posted:
November 26, 2013

Contact this candidate

Resume:

SUMMARY

*+ years of hands-on experience in the architectural analysis, design, development, integration, implementation, documentation and testing of .NET based solutions for real business needs using OOAD/OOPS, ASP.Net, C#.Net, ADO.Net, LINQ, Perl and Visual Studio 2010/2008/2005.

• Understanding business requirements, functional specification and designing the systems to meet the requirements, development and maintenance of the applications.

• Solid understanding and hands-on experience in TDD software development process and SDLC process.

• Highly self-motivated with strong analytical and problem solving skills and communication to interacting with management and technical resources.

• Able to work independently and collaborate as necessary.

TECHNICAL SKILLS

Languages/Scripting : C#.NET, ASP.NET, Perl, Framework 4.0/3.5/2.0, SQL, JavaScript

Web Technologies : HTML, CSS, AJAX, XML, IIS, JQuery, JavaScript, Custom MVC

Tools and Utilities : Visual Studio.Net 2005/2008/2010, Rational Rose, Intelligence Development Studio, MS Office, MS Project, MS Visio, Active Perl, Anthill (deployment tool), JIRA (issue tracking tool)

Databases : SQL Server 2008/2005, Sybase, Oracle 9i/10g/11g, DTS Packages.

Operating Systems : Windows 7/NT/XP, Vista, Windows Server 2003, Linux

Versioning Tool : Visual Source Safe (VSS), Team Foundation Server (TFS), Subversion (SVN)

PROFESSIONAL EXPERIENCE

Wells Fargo, Charlotte, NC Mar 2013 to Present

.Net Developer – Cash Projection

• Wells Fargo is one of the major banks in Repo Funding Space and desires to improve its funding operations for repo trading and replace its existing cash needs reporting platform with the Cash Projection platform which will provide full transparency between Front Office and Back Office operations. Also, this platform will enable them to make better investment decisions and comply with regulatory requirements.

• Involved in developing and enhancing existing dashboard of the Cash Projection application.

• Developed Dashboard Reports tab using Telerik reporting services.

• Created tables and Stored Procedures in SQL Server 2008.

• Worked in all phases of SDLC process from requirements gathering, design, code, development, testing and maintenance of the application.

• Knowledge of trade and funding operations business.

• Resolved GUI application issues during deployment and provided production support in all environments (Dev, SIT, UAT and Prod)

• Developed individual extracts using Perl and worked on automation of emailing hourly results/extracts to business.

• Environment: C#.Net, ASP.Net 4.0, Visual Studio 2010, IIS, SQL Server 2008, Sybase, Anthill, SVN, JIRA, Perl, Winmerge.

State Street, Boston, MA Jun 2012 to Jan 2013

.Net Developer and L3 - ODR, CBED, CIA

• Understanding and analyzing the client’s requirement.

• Involved in enhancement of the existing applications to provide additional functionality to the application.

• Involved in code changes to the UI, business layer and database layer.

• Used OOPS concepts to provide code reusability.

• Developed GUI using HTML, CSS, JavaScript for a dynamic look and feel

• Supported (primary) many applications during this period and created documents for the same.

• Used SQL Server 2008 DB for resolution for issues reported in production environment.

• Used master pages, skins and themes to provide a uniform look throughout the website

• Found root cause for many production issues and provided analysis/solution to SME’s/L4.

• Interacted with various levels of teams during support.

• Attended meetings, created docs and transitioned many applications.

• Environment: C#.Net, ASP.Net 4.0, Visual Studio 2010, SQL Server 2008, Agile Methodology.

Asurion, Nashville, TN Nov 2011 to Jun 2012

.Net Developer - iWeb AT&T

• IWeb AT&T is an online claim-filing application for AT&T subscribers enrolled under the Mobile Insurance Program of Asurion Inc. Asurion maintains separate code bases to customize individual service providers.

• Participated in business requirements analysis, gathering and preparation of functional specifications.

• Developed the GUI using ASP.Net, AJAX Controls, HTML and JavaScript.

• Developed web forms in ASP.Net using C#.Net.

• Involved in deployment of project in different stages like Development, Integration and Pre-production.

• Provided support to the application in the production environment and responsible for resolving the production issues.

• Created Use Cases for Business Users, fixed bugs in the application at business logic level, and created Unit Test Cases.

• Created functional, technical specification and non-functional documents along with screen notes for the application.

• Hands on experience on deploying source code, testing, giving demos to PA’s.

• Environment: C#.Net, ASP.Net 4.0, Visual Studio 2010, SQL Server 2008, HTML, XHTML, JavaScript, XML, IIS, Web Services, TFS, Agile Methodology, custom MVC.

JP Morgan Chase, Columbus, OH Mar 2011 – Oct 2011

.NET Developer - LRA, ALPS

• LRA (Lien Release Application) is an internal application. The LRA application is intended to identify and work loans that have refunds due to a customer when their lien is released. The refund is a calculation based on what the customer paid for county fees and what the county actually charges when the loan was released.

• ALPS (Assumptions Loan Processing System) is an application used to track name change requests and ensure smooth loan processing. A name change request comes in because of marriage, death, divorce or some other reason.

• Participated in business requirements analysis, gathering and preparation of functional specifications.

• N-tier architecture was used for the development of Presentation, Business and Data Layers using C#.NET.

• Extensively worked on the development of GUI using ASP.NET, ASP.NET AJAX Controls, HTML and Java Script.

• Used subversion for version control.

• Achieved good Code Coverage by writing unit test cases using nUnit.

• Involved in deployment of project in different stages like Development, Integration and Pre-production.

• Handled many production issues and made enhancement to the existing live portals.

• Designed a rich and interactive Graphical user interface (UI) by extensive usage of Web Forms.

• Coded the web pages in ASP.NET using C#.NET programming Language.

• Created Java Script functions to validate the inputs at the client side in web based applications.

• Created procedures, packages using oracle 11g

• Performed Code Review, Debugging & Integration testing of the application before moving to Production environment.

• Created Use Cases for Business Users, fixed bugs in the application at business logic level, and created Unit Test Cases.

• Creating functional, technical specification and non-functional documents along with screen notes for the application.

• Environment: C#.Net, ASP.Net 3.5, Visual Studio 2008, ADO.Net, Oracle 11g, HTML, JavaScript, XML, IIS, Web Services, Subversion.

CLUB WVO, Orlando, FL Feb 2010 – Mar 2011

.NET Developer - CLUB WVO

• CLUB WVO is a points-based vacation ownership program. WVO has developed and acquired vacation ownership resorts throughout United States. This application allows WVO to add world-class vacation options for owners by affiliating with high-quality standing condominium inventory, utilizing the company’s industry-leading sales and marketing expertise to sell vacation ownership interests.

• Responsible for functional requirement study

• Designed a rich and interactive GUI by extensive usage of Web Forms.

• Developed reusable controls using ASP.NET and C#.NET.

• Involved in writing Stored Procedures and creating Tables, Views.

• Coded the web pages in ASP.NET using C#.NET programming Language.

• Created JavaScript functions to validate the inputs at the client side in web based applications.

• Performed code review, debugging, and integration testing of the application before moving to Production environment.

• Environment: C#.Net, ASP.Net 2.0, Visual Studio 2008, Oracle 10g, Telerik and Agile Methodology

CVS, Woonsocket, RI Aug 2009- Feb 2010

Software Developer - Patient Medical Information (PMI)

• Project was designed for the new super specialty hospital and was developed as a generic product, which could be further marketed by the sales team. The solution offered better and more efficient operations, achieved cost efficiency in operation and maintenance, and ensured patient confidentiality and integrity of patient medical information. Contained ten modules including: Application Administration, Patient Information System, Medical Record System, Pharmacy, Financials, Material Management, Order Management, Operation Theatre, Dietary, and Maintenance.

• Migrated from the legacy programming language and database to .Net architecture.

• Designed and developed the data access components with N-Tier architecture design. System was comprised of Windows and Web based applications to meet the user requirements.

• Understanding the business requirements and providing analysis.

• Utilized C#.Net for code behind files and for business logic purpose.

• Interacted with the Business Analyst for getting the requirements and developing web pages using ASP.Net and C#.Net

• Hands-on in builds of the Development and Testing Server.

• Environment: C#.Net, ASP.Net 2.0, Visual Studio 2005, ADO.Net, SQL Server 2005, AJAX, IIS, JavaScript.

Realty Mortgage Corporation, India (Offshore) Apr 2008– May 2009

Application Developer - Realty Mortgage Portal

• Portal for Loan Officers and Brokers to pick a product, request a lock, and submit the Loan to Automatic Underwriting. The features of this portal included, finding the products that RMC offers based on the loan inputs from the broker, qualifying and pricing the loan from a pricing engine, requesting credit, performing automatic Underwriting using underwriting engine, etc.

• Utilized web services for communication between portal and DataTrac (LOB System).

• Analyzed functional requirements, identified UI and data elements using functional specifications, and created technical documents for production.

• Developed web pages using ASP.Net and used C#.Net for code behind files.

• Used ADO.NET extensively for database interactions using Data Reader, Data Adapter, Data View and Datasets.

• Used Grid View, Form View, Details View and Object Data Sources extensively.

• Used Themes and Skins for uniform designing and also used Infragistics controls for rich UI.

• Used Update Panel and other AJAX controls using AJAX control tool kit.

• Extensively worked on Visual Source Safe for the source control.

• Involved in Build and deployment of the application in production, system test and user testing environments

• Environment: C#.Net, ASP.Net 2.0, Visual Studio 2005, ADO.Net, SQL Server 2005, VSS, SOAP, AJAX

TrendyWorks, India (Offshore) Mar 2007 – Feb 2008

Application Developer - Modular Batch Record Management System (MBR)

• Designed and developed .Net based Modular Batch Record Management System (MBR) which was a Master Record authoring and Batch record printing solution that included data tracking and reporting functionality, as well as tools to facilitate the review and approval of the records created within the system. The MBR system consists of multiple distinct applications: MBR Authoring, MBR Utility, MBR Doc Compare, MBR Print on Demand, Report Net reporting and Batch Record Status Tracking to facilitate the Pfizer Global Manufacturing Kalamazoo site business needs for Master Record and Batch record creation.

• Generated Electronic Forms for Insurance Carriers. Responsible for gathering business requirements from business users (document processing team) for MBR Doc Compare and MBR Utility modules.

• Involved in writing Detailed Design Specifications (DDS) and Technical Use Cases.

• Interacting with the Business Analyst for getting the requirements and developing web pages using ASP.Net and C#.Net

• Designed and developed user interfaces using ASP.Net 2.0 and used C#.Net 2.0 as code-behind language.

• Used HTML, XML, JavaScript, CSS, and pure CSS layouts.

• Implemented Client-Side validations using JavaScript and ASP.Net 2.0 validation controls.

• Designed and developed the UI using C# Web Forms and involved in implementing the code according to the business logic.

• Implemented SCRUM methodology for project management.

• Developed Test Scripts and involved in Unit testing and bug fixing; involved in writing Test plans and Test cases.

• Extensively used Visual Source Safe for back up and controlling the source code.

• Environment: ASP.Net 2.0, C#.Net, ADO.Net, XML, VS 2005, SQL Server 2005, AJAX, IIS, JavaScript, VSS

EDUCATION

Bachelors in Computer Science, JNTU, India, 2006

CERTIFICATIONS

Microsoft Certified Professional .Net Framework 3.5 and ASP.NET Applications (Exam ID: 562)



Contact this candidate