Sql Server Customer
Resume:
A NUJ KU MAR
********@*****.***
Summary
• 10+ years of Experience in information Technology with expertise in design
and development of 3 t ier architecture web applications and windows
applications using C #, VB.Net, Entity F ramework 5.0. ASP.NET,
A DO.Net, Java Script, JQue ry, JSON.
• Worked on Distributed application using C #, Web Services and WCF, Web
A pi, COM +.
• Design and development of business objects, middle tier components COM+
i n WCF Services i n C #, using .Net F ramework 4.0 and M icrosoft .NET
F ramework (2.0/1.1).
• Good Hands on Experience in creating W indows Communication
Foundation (WCF) Services and Web AP I using M VC 4.0 f ramework.
• Designed and coded application components in an agile environment
u tilizing a T est D r iven Development (TD D) approach.
• Used a concept of D ependency I nversion P r inciple (D I P) by I nversion
of control ( IOC) Design pattern th rough D ependency I n jection (D I)
using N I nject .
• Hands on Experience of using entity framework (ORM) by creating a
G eneric Repository and U nit of Work (UoW) design pattern.
• Expertise in using ADO.NET objects such as SQL/OLEDB Connection
O bject, SQL/OLEDB Command Object, D ata Reader Object, D ataset
O bject and Data Adapter Object .
• 5+ Years of Experience as T eam Lead, playing roles like Offshore Lead,
Onshore coordinator, Application SME, M icrosoft Center-of-Excellence Lead
and had worked with other teams of various domains, platforms and
technologies.
• Involved with the compliance audit like SOX, SCABBA in current project.
• Experience in creating B usiness requi rement Document (BRD) a fter
conduction various meeting with the Business in current project.
• Good exposure of analyzing the Business Data to reconcile the business
reports with various stake holders like accounting and operations team.
• Excellent analytical and logical programming skills with a good
u nderstanding at the conceptual level and possess excellent presentation,
i nterpersonal skills with a strong desire to achieve specified goals.
• Excellent in documentation skills. Have released Technical Design
Documents, Design SPECs, Architecture documents etc. of precise quality.
• Have performed various testing activities like Unit Testing, In tegration-
System Testing, Regression Testing, and User Acceptance Testing and
ensured that the code is ideal. Other activities include archiving the test logs
and publishing the User Acceptance test logs to the respective stake holders.
E D UCAT ION
Masters of Computer Applications, CCS University (1999-2002), Meerut, India
Bachelor of Science, CCS University (1994-1997), Meerut, India
Technical Skills:
Unix Shell Script, PL/SQL,VB.NET,C#
P rogramming
L anguages
.NET 4.0/3.5/3.0/2.0,Web Services WCF, WebAPI,
Tools & U tilities
L I NQ, L I NQ, ASP.Net MVC framework 4.0,
I nformat ica 9.1.0, Toad, Toad for Data Analysis, PL
SQL SERVER 2008, Sybase Put ty, Smar tFTP,
w inSCP, Text pad, Edi t plus, Notepad++, MS
E XCEL 2010.
SERVER 2008,SQL SERVER 2K SQL, SybaseIQ
R DB MS
15.2,Oracle 10g
AppWorks, Informatica Scheduler
Scheduling Tools
Windows 9x/2000/XP/7, UN IX
Operating Systems
Toad 7.6/7.2, SQL Developer, Putty 0.60, WinSCP
O ther Tools
4.1.7, SmartFTP, AppWorx, Visual Source Safe,Start
Team
P rofessional Work Experience:
P roject Name: Syndication –SYNAM
L ocation: Stamford CT
Client: GE CAP I TAL July 2010 to
t ill date
Role: Senior Dot Net Developer and Tech Lead
Syndication Servicing is the process where account level values are calculated to
supplement the data supplied by the Portfolio Management System (PMS) to
support the reporting and accounting for the syndication settlement process.
Syndicated accounts get booked in mainframe system fi rst and then booking team
booked the same deal as off book account in Synam application. All the t ransactions
for that accounts start coming into feed files. There are some jobs which have been
scheduled to pull those incremental t ransactions from mainframe system and
p laced on a FTP location as text files .All the data in text files are Pipe separated. PMS Feed is a data feed from the source system which provides business
data for syndication servicing and settlement reports, which will then be split into
d ifferent Events based on Business rules to be fed in to SAM application for
p rocessing.
Responsibilities:
• Involved in design, development and testing phases of project.
• Involved in architectural meetings. Created Architecture Diagrams, and Flow
Charts using Microsoft Visio.
• Created U ML design diagrams like Class Diagram, Object Diagram,
Deployment Diagram and Component Diagram Designing and implementing
Web API, was used to communicate between business-to-business (B2B),
business-to-consumer (B2C).
• Created a Module name Feed Activity Manager and Loan deal Manager in
ASP.Net using M VC framework in C#.
• Extensive used of p a rtial views on the front end screen when updating the
data using model binding.
• Creating Web AP I for Customer/Investor as well as Syndication Module.
• Designing of WCF based Services, Data, Fault and Message Contracts,
Configuration of Bindings.
• Implemented Repository Pattern and I nversion of control ( IOC) t hrough
D ependency I n jection (D I) using N I nject.
• Followed T D D approach w hile developing the application.
• Developed Extraction, Transformation and Load process (ETL) using SSIS to
c reate the XML Files which eventually being consumed by our web
A pplication.
• Involved in all the SDLC processes to develop this project.
• Loaded data into SQL Server through XML Targets using Transformations.
• Performed Unit testing, debugging and performance tuning of targets,
sources, mapping and sessions.
• Developed, updated and maintained documentation of processes.
Environment: .Net 4.0.Visual Studio 2010, C #, ASP.Net, MVC, JQuery, WCF
SSIS, SQLSERVER 2008, Flat files.
Tools Used: W in SCP, TOAD for Data Analysts, Sybase DBISQL, MS Office, Visual
S tudio 2010,
N U nit.
P roject Name - VF PD & PD Over r ide
Senior: Tech analyst/Net Developer Location:
D anbury CT
C lient: GE CAP I TAL November 2007-
July 2010
Description
VF PD & PD Override module has been created to provide capability to the Credit
A nalyst for adding and maintaining Moody’s Issuer, K MV Public, and Risk Calc
agency rating information for Customers and ensures that correct agency ratings
i nformation defaults automatically on the credit decision rating. When a Credit
analyst fill the above mentioned rating for a customer and save it, a rerating logic
r uns in which a final rating and PD score for that customer (Obligor) is assigned
and stored in ICE database that is being used by data ware house peoples. When a
Customer is in bankruptcy, out of business or in payment default it assigned the PD
to 100%.In this module we were maintaining and showing the 13 months rolling
h istory of obligor ratings. A 13 month rolling history of GE Calibrated ratings for
t he models used to decision deals has been stored and displayed for each customer.
T his has occurred once a month after the CMS Score H istory and Customer re-
rating is completed. History will only be kept for models in the Model Hierarchy. In
I CE project there is a decision tool SEM which decision the deals. In this module
r atings and PD’s are being assigned PD’s to SEM auto-decision raw scores or
r atings from GE Calibrated Behavioral or Origination Models.
Responsibilities:
• Created a COM+ class in C# and Web Services to get the data and to update
i n Database through data access layer.
• Team lead for a group of 5 who were involved with the creating the win forms
and com components and SSIS packages.
• Daily Feed Data comes from the PMS for a newly created Customer, after
applying some t ransformations; we store the data in SQL Server Database.
• In teracting with business users to gather new business requirements and
i mplement them into production.
• Provided Level 3 production support.
• Release manager to deploy code changes in production.
• Created the technical run books which will have the list of all tasks and jobs
and the sequence in which they need to be executed as part of each release
cycle.
• Performance tuning of long running workflows.
• Involved in reviewing SQL procedures, views and data build/storage.
• Involved in providing weekly status to the client via dashboard.
Environment : C#, VB.Net, Win Forms, COM+, Flat files, SSIS UN IX, SSIS.
Tools Used: W in SCP, TOAD for Data Analysts, Sybase DBISQL, MS Office.
P roject Name - I C E
Dot Net Technical Developer Location:
D anbury CT
Client: GE CAP I TAL November 2007-
July 2010
Description
This is one of the f lagship projects being used at GE Comfin. I t provides on demand
decision services for GE’s leasing and financial business. Request for decision are
submit ted in XML format and routed via IB M-MQ.ICE follow a complex workflow
and invokes customized rule engines. Decision about the deal is sent back to the
requester in less than two minutes. On any good day ICE decisions around 10,000
deals. This is VB.NET application, with MS-SQL server at backend, web distributed
v ia CITRIX.
Responsibilities:
• Team Lead and SPOC for client.
• Preparation of design document for existing DTS process on SQL Server
2000.
• Development of mappings while using SSIS t ransformations.
• Creating framework and guidelines and ensuring the standards for
development
• of packages
• Created tools and reports for Data integrity checks.
• Unit and In tegration Testing.
Environment: V isual Studio 2002, SQL Server 2000, Flat files, Solaris (UN IX).
Tools Used: SQL Server 2000, MS Office, WINSCP .
P roject Name KYC Checks (Credit Decision Application)
Role Senior Developer Location:
D anbury CT
Client GE CAP ITAL November
2005-Oct 2007
Description
Our client‘s existing credit decision application was using only IBP and OFAC
screening for validating customer authenticity. These checks were performed using
t ightly integrated COM component with the application, whose maintenance was a
cumbersome process. Few other checks for validating customer were also done by
A nalyst manually from different sources. With the increased focus of the Fraud and
r isk departments, it was required that all these checks were automated from a
s ingle thi rd party vendor to reduce manual errors and ensure business safety. The
requirement was to enhance the existing Credit Decision Application by
i ncorporating automated checks for validating the customer authenticity using
Lexis-Nexis Web services. The Know Your Customer (KYC) checks included,
1. OFAC Fraud Screening
2. IBP Screening
3. Customer Legal Name Authentication
4. Customer Address Authentication
The changes included hard stop for deal approval in case of validation failure,
notifications to stakeholder in case of any red f lags, and ensuring the checks
i ncorporation in all deal workflows. With this project the process of authenticating
t he customer was improved significantly and in tu rn helped in reducing the TAT for
C redit Decision
• Team Lead
• Requirements gathering from client after brain storming sessions with client
and with
Onsite peers and preparing high level design document.
• Co-ordination of work and knowledge sharing with in team and with client.
• Created Com components and classes using C# and VB.Net.
• Development of application using VB.net 2.0 which includes development of
D ifferent layers of application (presentation layer, business layer, enti ty layer, data
access layer).
• Development of database objects (tables, procedures and DTS) for the project
for the application in SQL Server 2000.
• U nit and In tegration Testing.
• Coordinating and driving UAT, with client in teractions and Test Director
Tool.
Environment: C#, Win Forms, SQL Server 2000, Flat files, Solaris (UN IX).
Tools Used: SQL Server 2000, MS Office.
Project Name BBC – Bor rowing Base Certificate Location:
C hicago
R ole D eveloper
Client GE-H FS J anua ry 2005-Oct
2005
Description-
BBC is a process that enables the GE-HFS customers to request for funding. These
customers are mainly Medical institutions and the funding is requested against loan
secured by bills recognized by the federal government (Medicare, Medicaid etc.).
T he Borrowing Base Certificate involves creation of a template containing details of
t he customers’ branches, collaterals, adjustments and legal verbiage etc. I t
basically represents the loan contract between the customer and the GE-HFS.
The project comprises 2 sites:
I n te rnal Site: Created for HFS users. Through this site, the HFS users can
c reate BBC, approve/reject funding created by the customer and administer
reporting options etc.
Roles: Relationship Manager, Portfolio Analyst
Exte rnal Site: In terface for customers to request funding and check the status
of their funding.
Roles: Customer Approver, Customer Preparer
• Development of application using ASP.net which includes development of
D ifferent layers of application (presentation layer, business layer, enti ty layer, data
access layer).
• Development of database objects (tables, procedures and DTS) for the project
for the application in SQL Server 2000.
• U nit and In tegration Testing.
• Coordinating and driving UAT, with client in teractions and Test Director
Tool.
Environment: VB.NET, ASP.NET, SQL Server 2000.
Tools Used: SQL Server 2000, MS Office.
Project Name Online Survey Management System (OLS)
R ole D eveloper
Client I mpact Consulting Ltd (US) F eb
2004-Dec 2004
Description-
The “Online Survey Application” also called as “Survey Management System”, allow
new user
to get registered with the site and subscribe to the dynamic subscription plans
.Online payment integration will be used for payments th rough Credit card. The
registered users will be able to create unlimi ted online surveys. Using the Admin
tool, administrator will be able to manage the feature like Customers account
p rofile, post online payment (credit card and Manual Check), reset password, create
new sale plans, t rouble shoot surveys created, Survey Managing,Email Directory
Settings, Import data from outlook, Manage site Layout, Report Export, Sales Plan
S tructure, Managing User Registration From Field display Settings.
Environment: VB.NET, ASP.NET, SQL Server 2000,.
Tools Used: SQL Server 2000, MS Office.
• Development of application using ASP.net which includes development of
D ifferent layers of application (presentation layer, business layer, enti ty layer, data
access layer).
• Development of database objects (tables, procedures and DTS) for the project
for the application in SQL Server 2000.
• U nit and In tegration Testing.
• Coordinating and driving UAT, with client in teractions and Test Director
Tool.
Environment: VB.NET, ASP.NET, SQL Server 2000.
Tools Used: SQL Server 2000, MS Office.
Project Name Employee Payroll Portal
Role D eveloper
Client I mpact Consulting Ltd (US) June 2003-
Feb 2004
Description-
This is a web-based employee payroll portal where the client should be able to
manage information related to employees. This websites can be broadly categorized
i nto two main sections. One is Admin Section and another is Employee section. In
t he Admin Section User is able to manage the information related to employee,
department, Pay Categories, Salary details etc. Admin can set the permission for
t he employee to view the different fields (i.e. Enable fields which wants employer to
v iew in read mode, and which in wri te mode), Back out time management, security
log and report. Change admin Password. In the Employee section, the employee is
able to manage the details to their own information. Employee is allowed to enter
i nto the system using a secured Login/Password, which is authenticated against the
details available with the system in a SQL server’s database .Once the
authentication details are verified user enters into the system where he can view
/print/edit the details related to his/her information, pay slip etc. The changed
details are stored into another table. Employee is given the option of viewing his/her
p revious pay slip also.
E nvironment: VB, ASP, SQL Server 2000,
Tools Used: SQL Server 2000, MS Office.
• Development of application using ASP.net which includes development of
D ifferent layers of application (presentation layer, business layer, enti ty layer, data
access layer).
• Development of database objects (tables, procedures and DTS) for the project
for the application in SQL Server 2000.
• U nit and In tegration Testing.
• Coordinating and driving UAT, with client in teractions and Test Director
Tool.
Environment: VB, ASP, SQL Server 2000.
Tools Used: SQL Server 2000, MS Office.
Contact this candidate