Sr.net Sql Server Developer Resume Profile
SUMMARY
- 10 years of IT experience as a Senior Developer/Architect in Microsoft .NET Technology and SQL Server with applications development experience in deployment of large scale projects web-based Client-Server applications with development of business processes and system solutions for Credit Cards Banking and Financial Industries and Healthcare industries for various projects from conceptualization to implementation.
- Technical expertise in Object Oriented Design and development using Microsoft .NET technologies C VB.NET ASP.NET WCF WPF Web Services .NET Framework 3.5 4.0 SQL Server 2005/2008/2012 TFS Visual Source Safe.
- Development experience in MVC Framework for credit card and banking projects.
- Extensive experience is DDL/DML SQL Stored Procedures and Performance tweaking.
- Proficient in database development including Constraints Indexes Views Triggers Cursors Packages using SQL Server.
- Administrative experience with Microsoft IIS server.
- Proficient in building Web Services using WCF XML/XSD and Expertise in consuming publishing internal/external Web Services and Server Controls.
- Experience accessing databases via Entity Framework ADO.NET LINQ NHibernate.
- Experience in migrating legacy applications from VB ASP to C .NET/VB.NET ASP.NET
- Experience with development SQL Server SSIS and SSRS services.
- Worked on web development languages such as HTML CSS Javascript jQuery AJAX.
- Knowledge in basic Java UNIX and Oracle. Hands on experience in WinForms Adobe SDK.
- Excellent technical writing skills to create Business Requirements Document BRD Functional Specifications Document FSD Nonfunctional Requirements Document and Use Cases Specifications documents.
- Excellent conceptual and working knowledge of System Development Life Cycle SDLC Agile SCRUM RUP OO Models and UML Methodologies.
- Experience with Mainframe Web Development E-commerce and Healthcare projects.
- Knowledge in developing Test Plans and Test Cases ensuring adequate testing on software both before and after completion conducting and documenting UAT.
- Experience with code deployments to Development/Test/SIT/UAT environments.
- Healthcare experience with Health Information Exchange HIE and Electronic Health Record EHR system knowledge. Also worked on various EMR products.
- Analysis of protected health information PHI to better manage the quality and cost of care delivered and query and retrieval of information across the health care.
- Coordinate review cycles with business users during all phases of the project.
- Provided leadership to a team of analysts that directly and indirectly support the operations.
- Worked on standalone Windows Desktop application and Adobe Flex applications.
- Experienced in Medicaid and Medicare Line of Business for the state government of Massachusetts.
- Excellent Team player to work in conjunction with testers QA developers and other members in validation of complex project scenarios and in the maintenance of Quality Standards of projects.
- Use healthcare and banking business operations expertise to seek out research and evaluate a variety of solutions to provide end users with high quality efficient products.
- Working closely with VP operations PM Subject Matter expert SME to develop business strategy for financial planning budgeting and strategic planning.
- Dynamic and assertive team player with excellent verbal and written skills.
- Creative and aggressive self-starter with integrative thinking skills capable of forming and maintaining positive and productive working relationships in internal external independent and team environments.
CORE COMPETENCIES BUSINESS SKILLS
Design Methodologies Server Side Applications Quality Assurance Object Oriented Systems Operating Systems Protocols User Interfaces Distributed Systems Software Processes Project Management Software Construction Data Structures | Business Definition Requirements Business Process Analysis Research Use Case Modeling Analysis Technical Requirements Development JAD/JAR Sessions Requirements Gathering Change management CCR ER Diagrams Gap Analysis and Impact analysis Cross-group collaboration Release management Project Estimation Resourcing |
TECHNICAL SKILLS
Methodologies | RUP UML Six Sigma Agile methodology Cost-Benefit Analysis Risk Analysis Gap Analysis SWOT Analysis |
Databases | SQL Server Oracle DB2 VSAM IMS |
Project Management Tools | MS Visio MS Office Suite SharePoint |
Operating Systems | Windows LINUX/UNIX Z/OS OS390 |
Defect Version Tracking Tool | Rational Clear Case Virtual Source Safe Team Foundation Server Changeman Endover |
Documentation Tool | SharePoint MS Office Suite Word/Excel/Power Point |
Languages | C VB.NET ASP.NET SQL Server HTML XML JAVA CSS Oracle COBOL JCL CICS REXX |
Reporting Tools | SSRS Crystal Reports MS Project |
Framework | .NET Framework J2EE Mainframe |
Other Tools | MS Office Word Excel Access PowerPoint Publisher Photoshop Dream Weaver Lotus Notes Outlook Load Runner Visual Studio |
PROFESSIONAL EXPERIENCE
Confidential | Sr.NET SQL Server Developer |
Role Responsibilities
- Development of re-usable customize-able enterprise reporting framework s .
- Core feature development in .NET 4.0 4.5 with ASP.NET C SQL Server 2012.
- Use of latest technologies where possible to bring the development and customer experience to a maximum performance and processing.
- Worked of tweaking performance of SQL Stored Procedures.
- Administrator for TFS 2008 and migrations through to TFS 2010 and TFS 2012.
- Development of Technology Roadmaps for the development team s .
- Worked on custom SSRS reports to render in FLEX environment.
- Architectural designs from Client side frameworks such as AngularJS Knockout all the way through the Server Data Access Tier including Web Services Web API MVC WCF and Entity Framework.
- Developed and coordinated integrated development team code reviews.
- Introduced branching and merging strategies in TFS 2012 for supporting multiple active release versions of an application.
- Continued work as a part of the companies Innovation Team for Research Development.
- Worked closely with solution architects Functional leads Business Analysts and Project Managers. Conducted meetings and actively coordinated with Developers and Business Team.
Environment .NET 4.0/4.5 ASP.NET C SQL Server 2012 SSRS Visual Studio 2012 MS-Office MS-Visio MS-Access MS-Project Share Point 2012 Microsoft Office Suite MS Word Excel PowerPoint XML Agile.
Confidential | .NET Architect |
Role Responsibilities
- Involved in formulating the test strategy test plans test scripts reviewed QA test plans for appropriate test coverage and conducted system testing functional regression and integration testing.
- Led a team of up to 6 developers in creating a line of business application using C ASP.NET MVC nHibernate SQL Server 2010.
- Creates custom SQL Server Reporting Services SSRS Reports to be displayed in a CLPPP application.
- Architected designed and developed the system in 3 tiers.
- Developed the front end using ASP.Net HTML and CSS.
- Developed Serviced middleware components using C .
- Designed and developed the database and wrote stored procedures for SQL Server 2008.
- Responsible for project architecture technical design/decisions and domain modelling.
- Responsible for all Code Reviews and mentoring junior team members.
- Manage Microsoft SQL Database Tables views and stored procedures.
- Worked closely with solution architects Functional leads Business Analysts and Project Managers. Conducted meetings and actively coordinated with Developers and Business Team.
- Project Management/ Quality Assurance and Standards implementation.
- Onsite / Off Shore Team building and Resource Management.
- Created various mapping documents for mapping from one message format Source Specific XML to the Target Specific Message XML RXML HL7 CCD
- Used object-oriented analysis and the Waterfall model for business requirements business processes design Use Cases using UML .
- Used UML methodologies to design workflow analysis data flow diagrams and document and manage requirements throughout the full lifecycle of the project i.e. definition design and testing phases.
- Involved in Risk-Management Process whereby identifying critical areas of business risk and modifying the business process to reduce the same.
- Responsible for maintaining the SharePoint site for project tracking financials milestones and other deliverables.
- Performed Data modeling data mapping and XML Mapping. Worked in SOA environment.
- Experience with writing SQL queries and stored procedures.
- Assist in development of training materials for new technology and process improvements.
Environment .NET SQL Server 2012 Visual Studio 2012 MS-Office MS-Visio MS-Access MS-Project Share Point 2012 Microsoft Office Suite MS Word Excel PowerPoint XML Waterfall SOA.
Confidential | Sr.NET Developer Onshore Lead |
Projects
- Add-it-up Program for Credit Debit Cards Add It Up program rewards card customers with extra cash back when they shop through partnered online retailers in an effort to bolster participation in the BankAmeriDeals program.
- ADDP Fraud Detection Prevention ADDP Fraud Prevention application is initiative to prevent fraud processing of all non-monetary details of customer. The real-time data is collected and updated within various systems. When a fraudulent transaction is happening the system undergoes various checks and response is given back to the system of request origin.
- Fraud Detection Service Layer FDSL Implementation IFP Gen 2.0 Fraud Detection Service Layer FDSL System is one of the key applications in Bank of America. FDSL System will have their own set of business rules and it handles all the transaction is being made from different channels and applies the rules in order to identify whether the particular transaction is been involved any high risk transaction / fraudulent transaction.
- Customer Information Systems CIS Customer Information Systems CIS updates the customer information and account information in East Coast and Mid-West states of United States. The application maintains the Customer information Address Information and Account Information using various online and batch activities.
- Strategic Rewards Systems SRS POINTS / SRS is a parameter driven system that rewards Bank Cardholders for increased card usage in the format of points for merchandise redemption merchant coupons savings bonds and account credit in form of rebates. This system accommodates wide variety of unique Affinity partner programs by providing a range of options program parameters that define how the accounts within the Affinity program accumulate and redeem points for incentives. The incentives provided to the customers are the result of an accumulation of points based on transaction activity including cash balance transfer or net retail purchases and encompasses a variety of forms like travel rebate rewards etc.
Role Responsibilities
- Acted as team and technical project lead on multiple projects.
- Developing Windows Applications using Windows Presentation Foundation in .NET 3.5.
- Planning Database Architecture and Software Architecture to increase both productivity and speed.
- Web development using ASP.NET with C . I ve been in the process of developing both smaller and larger business websites targeted at a larger audience. Using T- .
- Suggesting design and technical solutions to the client for the application.
- Bug fixing and application enhancement and optimizing code for performance tuning.
- Created desktop applications in C and VB.NET for database access to a SQL Server 2005 database.
- Migrating existing application from .Net 2.0 to .Net 3.5 and later frameworks.
- HTML/DHTML/CSS development.
- Design JSON and XML-based REST APIs that adhere to tightly-held standards
- Planning new architecture of the existing application and suggest new design to the client to build new light weight and high performance application.
- Helping team members in technical issues.
- Acrobat SDK is used to generate daily weekly and monthly PDF reports and emailed to business owners.
- Involved in technical discussions for supporting projects like implementation and resource management.
- Proven experience in various stages of SDLC and Six-sigma that includes analysis design research testing and implementation of software applications. Also awareness of projects working on offshore-delivery model execution and Agile Software methodologies.
- Translated business and technical requirements between the users and developers.
- Involved in writing Use Cases and Test Cases based on the Business narratives Functional requirement specs FRS and Design specs. .
- Performed the role of Onsite coordinator and leading a team of 6-7 developers at offshore to reverse engineer the existing code of entire Mortgage app and enhancing the same.
- Provided support and maintenance development for numerous data manipulation and analysis utilities.
Environment C ASP.NET .Net Framework SQL Server XML Rhapsody T-SQL PL-SQL VB6 COM MSMQ MS Access Crystal Reports Visual Studio 6 Visual Source Safe TFS
Confidential | Applications Programmer |
Projects
- Identity Theft Management System ITMS Citi Cards Identity Theft Management System CITMS is case based identity theft registering system. It is a web based system built to handle the case management by the CITI case managers. It is operated on intranet and accessed by representatives/managers to add monitor and track cases. The case management system utilized by the CITS unit is called the Identity Theft Management System ITMS . It included Database storage of client information queuing and case follow up functionality error tracking and controls systemic integration with imaging system and systemic feeds to and from Transunion. When a victim of Identity theft contacts CITS they are assigned the case manager / representatives who work with them until the completion of their case.
- Apply and Buy Citi Cards Application Processing module deals with processing Online/POS applications from customers Consumer/Business . The application provides a user friendly front end. Validations are taken care of for all the fields. Security Issues such as protecting User information like Social Security Number Tax Payer ID etc. are handled appropriately. Integrated Partner Solutions acts as a middleware to transfer the application data received from the frontend to the backend after performing the required business validations. Then the applicant s information is submitted to the Credit bureau and the other backend components. The response is received and displayed appropriately to the Customer. The credit card types covered by these applications are the Oil Private Label cards and the Retail Private Label Cards. This project also handles the production support issues as well as change requests.
- Private Label Systems Private Label System PLS is a mainframe system built on Vision Plus product that supports the processing of private label retail cards processing for United States and Canada. This system takes care of functionalities like Application Processing Accounts Processing Letters and Statements generation Embossing Collections Authorizations and Customer Services.
Role Responsibilities
- ASP.NET developer using C 2.0 and Microsoft SQL Server 2005 in the programming team of a well-established bank design.
- Design and build of bespoke development projects involving all elements of the software development lifecycle SDLC .
- Significant enhancements to the company s own e-commerce engine including a web based admin
- Performed code review worked close to team member to ensure consistence to code standards.
- Optimized application performance by 40 .
- Developed reports using Crystal Reports and MS SQL reporting.
- Worked close to business people to review requirements.
- Also worked with Change control support group and managed changes by reviewing testing and incorporating compliance during various stages of SDLC.
- Actively communicated with users on system status including system changes problems enhancements and potential impacts.
- Worked extensively on SQL queries for client warehouse analysis ad-hoc requests. And also used Business Objects BO for reporting purposes
- Facilitate User Acceptance Testing UAT and production rollouts and the defects detected were tracked and managed using HP Quality Center.
Environment .NET 2.0 / 3.5 ASP.NET C JavaScript JSON HTML CSS SQL XML Web Services LINQ Web Services IIS Waterfall Agile Visio Mainframe Systems COBOL DB2
Confidential | Developer Intern |
Role Responsibilities
- Preparing the Low level design document as per the High level design
- Review program specifications for enhancements
- Developing the new codes
- Involved in Coding the modules and Testing
- Participation in Unit System Integration testing
- Support QA CIT SIT and test environments
- Design and execute testing approaches
Environment .NET 2.0 C ASP SQL Server HTML.