SUMMARY:

• Business Applications and Data warehouse Developer with 12 years of experience in application and data warehouse development.
• Strong overall experience with application and data warehouse design, development, unit testing, regression testing.
• Hands on VB.NET/C# experience developing Web/WCF services for integration between several systems such as CRM, Credit Delivery, Confidential and Imaging.
• Developed custom .NET ASPX pages for CRM customization.
• Used Infragistics Controls for Grid and page navigation features.
• Designed a Custom Web(ASP.NET) Application for Loan Verification for Confidential users.
• Data Warehouse Experience: Hands on data warehouse experience building Stage, ODS and datamart databases using ETL tools like SSIS 2005/2008, SQL 2005/2008 for tables, stored procedures, functions, triggers, Erwin data modeler and Red Gate SQL tools. Applied dimensional modeling methodologies to build the data warehouse.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2000/NT 4.0, Windows 95/98, Unix

Database: MS SQL Server 2008/2005/2000/6.5/7.0 , Oracle 7.x/8.x/8i, Sybase ASE 11/12.5, MS Access

CRM: Confidential CRM 3.0/4.0

.Net technologies: VB .NET, ASP.NET, C#

Business Intelligence tools: SQL Server Integration Services(SSIS 2005/2008), SQL Server Reporting Services (SSRS 2005/2008)

Web Application Framework: Confidential

Service Oriented technologies: WCF

API technologies: .NET Web Services

GUI: Visual Basic 5.0/6.0, Developer 2000

Tools: and Technologies Crystal Reports 6.0/7.0/8.0,Oracle Reports 2.5, Data Reports, Microsoft Help Workshop, Visual Sourcesafe, Active X, ODBC, DAO, RDO, ADO, RDC.

Web Tools and technologies: Visual Interdev 6.0, Microsoft Frontpage, CGI, Active Server Pages (ASP), COM/COM+ /DCOM, Internet Database Connector (IDC) and E - Commerce.

Web Servers: Internet Information Server, Personal Web Server, Microsoft Transaction Server (MTS), MS Site Server 3.0 E-Commerce Edition

Hardware: Range of Intel Pentium servers, IBM PC and Sun Solaris.

Languages: C, C++, Java, Pascal, Cobol

Software Methodologies: Rumbaugh (OMT), Waterfall Chart Model, UML

Scripting Languages: VB Script, Java Script, Perl, Shell

Markup Languages: HTML, DHTML, XML

Design Tools: Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, SC

Senior Applications and Data Warehouse Developer

Responsibilities:

• Confidential is a Farm Credit Bank that provides funding, financial and technological services to 23 agricultural credit associations in 15 eastern states and Confidential .
• These associations provide real estate and production financing to farmers, agribusinesses and rural homeowners.

Confidential

Technologies: SSIS 2008, MS CRM 4.0, SQL 2008, VB.NET, C#, ASP.NET, WCF Services, Cozy Rock components

Responsibilities:

• Converting the ALP Customer Confidential Web Services(.NET 2.0) to Confidential Customer Confidential WCF data services(.NET 4.0) which’re being consumed by CRM custom .NET ASPX forms and other applications.
• Also working on designing and rewriting CRM Scribe jobs to SSIS nightly jobs to load CRM data. Using Dynamics CRM Cozy Rock components to insert and update CRM data through CRM APIs.

Confidential

Technologies: SSIS 2008, Confidential 4.0, WCF Services, C#, SQL 2008

Responsibilities:

• Imaging is a document management system for better search and retrieval of documents by associations.
• Confidential is a product used in this process which would replace existing OnBase imaging system.
• Confidential technologies are used to develop agdox application to meet Confidential customers needs.
• Web Services using TCP/IP are used for faster search and retrieval.
• Created C# WCF services for search and retrieval of customer and loan data from other systems such as Confidential and Credit Delivery into imaging database.
• Developed SSIS packages to synch the imaging data on a nightly basis with external source systems such as Confidential and Credit Delivery.

Confidential

Technologies: SSRS 2008, SQL 2008

Responsibilities:

• Leading the reports conversion project for all associations.
• Currently, Confidential reports fetch the data from ALP and Lending datamarts which will be sunset in the near future.
• There’s a pressing need for the conversion effort to fetch the data from Confidential instead.
• So, all the Confidential reports need to be converted to SSRS and Confidential .
• Leading this effort by providing the requirements to other developers, validating and deploying the reports.

Confidential

Technologies: SSIS 2005/2008, SQL 2005/2008, SQL Compare/Data Compare, Erwin Data Modeler/Navigator

Responsibilities:

• Developed SSIS packages to load the data from sourcesytems into stage, stage into ods and ods into datamarts.
• Designed and developed internal, external recon tables, stored procedures and packages to reconcile Confidential data with source system data.
• Used Redgate SQL and Data compare to generate all the sql and delta scripts.

Confidential

Technologies: CRM 3.0/4.0, VB.NET, ASP.NET, Javascript, IE Inspector

Responsibilities:

• Created CallOuts and User Plugins to trigger events.
• Implemented dupecheck functionality to identify and resolve duplicate customers.
• Created webservices to create an interface between CRM and Credit Delivery so that CRM data can be used by CD.
• Created custom CRM views from filtered views to optimize the performance of the views used in Confidential reports.

Confidential, Columbia, SC

VB/.NET/SQL Server Developer

Technologies: Sql Server 2000, Visual Basic 6.0/.NET

Responsibilities:

• Involved in the design and development of various projects at Confidential .
• Involved in the development and testing phase of Credit Delivery Phase 2.0.
• Worked on several enhancements for CD Phase 2. CD Phase2 was the next phase
• Invlolved in the database development and testing of CAT(Credit Admin Tool) Phase I.
• Involved in the database design, development and testing of the Front End Project for Credit Delivery.
• Worked on CD Phase 3.0 (Enhancements to Credit Delivery) and CAT Phase 2.0 (Enhancements to CAT) projects. These CD Phase 3.0 enhancements include collecting Confidential Data in Credit Delivery, changes to Upload program which’s written in ‘C’ which uploads Credit Delivery data to MainFrame and many such enhancements.
• CAT Phase 2.0 enhancements include collecting Refinance data from CreditDelivery, developing a process for collecting Default and Impaired Loans data.
• Developed a new process for FCA LoanType conversion.
• Made enhancements to the Synch process to add some additional fields (FCALoanTypeNumber, OriginatingEntity etc.) from CD and CAT in DailyDWH.

Confidential, MD

Sql Server/Crystal Reports Developer

Technologies: Sql Server 2000,Crystal Reports 8.5

Responsibilities:

• Worked on MACC(MidAtlantic Career Consortium) reports and Stored Proecedures.
• Developed the reports using the input parameters from SQL Stored Procedures.
• Used temporary tables in stored procedures to store the reporting data.
• Developed Summary/Detail reports and Stored Procedures for the states of MD, VA, WV, PA so that these states can view the jobseeker information and other details .

Confidential, VA

ASP/SQL Server Developer

Technologies: ASP 2.0, DTS, IIS 5.0, ADO, VBScript, JavaScript, Access 2000, VBA, SQL Server 2000, Windows 2000/XP

Responsibilities:

• Involved in development and implementation of Web Assistant using ASP and SQL Server 2000.
• Web Assistant enables to control, process and monitor expressions of interest, registrations, demographic updates and speaker and presentation details received via the internet.
• Developed web forms for Demographics Update, Expression of Interest, Registration without Payment, Registration With Payment and Speaker and Presentation Details.
• Extensively used VbScript and JavaScript for validations.
• Used ADO to connect and interact with the Database .
• Wrote Access Routines to transfer the raw data from Text File to View tables in Sql Server.
• Wrote Stored Procedures in SQL Server 2000 to transform the data from View tables to real tables.
• Worked on Live Link to develop a web reporting tool which also enables the users to edit their information.

Confidential, VA

Oracle Developer

Technologies: Windows 2000, Oracle 8i, Unix, C Shell, Perl, AS/400 Nord System

Responsibilities:

• Involved in design, development, testing, implementation of MNR(Maintenance and Repair) using Oracle. MNR provides product, provider, market etc. information for North and South regional states as MD,VA,NY,NJ,PA.
• Embedded business functionality by writing Oracle PL/SQL stored functions and procedures.
• Wrote Perl and Shell scripts for data comparison and other activities.
• Written SQL code to test the Data transformation through different layers. Written sql scripts to compare the datamart’s data against AS/400 Nord System’s data.
• Implemented unit testing and Integration testing and Involved in documenting the project.

Confidential, Washington, DC

C/C++/VB Developer

Technologies: ASP 2.0, Visual Basic 6.0, COM/COM+, IIS 4.0, VBScript, ASE 12.5, C, C++, Unix, C Shell, Perl, Sybase, SQL, Windows NT 4.0, Sun Solaris 2.6, Gvim, Workshop 6.1

Responsibilities:

• Developed the application using 3-tier architecture with Visual Basic in the user interface layer, developed VB components using COM/COM+ in the business tier and Sybase stored procedures and tables in the data layer. Developed a COM component in Visual Basic for commission calculations.
• Developed dynamic web pages for Orion users for accessing commission, amortization, income expense modules and month end close calculations using ASP 2.0 and VBScript on NT environment.
• Worked on the conversion of ORION Application from Sybase DB Libraries to Client Libraries. Used IRIS Libraries for converting the modules written in C. The Receipt and Income Expense modules, which have been written in C++, have been using Link++ Libraries. The Link++ Libraries were developed using DB Libraries. Converted these Link++ libraries from DbLib to Ctlib 12.0. Made changes to the existing system. Compiled the new code using the new C/C++ compiler (workshop 6.1). Extensively debugged the application using workshop 6.1
• Worked on IWT(Integrated Wire Transfer). IWT contains several processes such as:
• Written SQL Scripts for unit testing and data retrieval.
• Wrote Perl scripts for testing the performance of monthly closing, commission, amortization
• Involved in production support of the system on a 24/7 basis.

Confidential, Washington, DC

C/VB Developer

Technologies: ASP 2.0, Visual basic 6.0, COM, Java Script, IIS 4.0, Unix, Sybase ASE 11.9.2, Oracle 8.0, SQL, Perl, Shell, C, Windows NT 4.0, and Sun Solaris 2.6, Gvim, Workshop 4.0

Responsibilities:

• Written ASP scripts for ELP which will interface with the STAR and ORION systems to retrieve relevant data from Oracle. Wrote ASP scripts to interface with IRDB to obtain yield curve information.
• Developed a VB component which allows the user to view LIBOR and DISCO spot and forward rates for a given day. Using this component, the user will have the ability to change the Yield curve as of date to view previously pulled yield curve data stored within ELP.
• Extensively used APEX True DBGrid Control for several data access operations.
• Worked on the conversion of ELP application from DB-Libraries 10.0.4 to (Client) CT-Libraries 12.0. The Enhanced Liquidity Portfolio system is to automate the core business functions (position evaluating, tracking and monitoring performance) so that risk, growth and profitability targets may be achieved most efficiently. ELP is a portfolio consisting of Assets, Liabilities, Forward Rate Agreements (FRAs), and Intercompany Term Debt grouped into positions and managed in such a way that the spread between assets and liabilities is positive and thus generates income.
• ‘C ’ Programs and Sybase stored procedures were developed for primary calculation functions. On a nightly basis, ELP will interface with the STAR and ORION systems to retrieve relevant data allocated to Liquidity Investment Portfolio (LIP). Elp Jobs run on a nightly basis in Autosys. Retrieved data will be stored in the ELP database primarily for use in performing batch calculations. ELP will also interface with the Interest Rate Library (IRL) to obtain needed yield curve information.
• Written SQL Scripts for unit testing and data retrieval.
• Wrote Shell/Perl scripts to automate the ELP jobs that run on nightly base.