Management Development .Net Sales Data Design

SUMMARY

. Over Fourteen Years of extensive work experience as a Software

Engineer in the area of Programming, System Analyst and in IT

Industries.

. Highly proficient in ASP, ASP.net, VB 5/6.0, VB.Net, C#, VBA, VB

script, JAVA script,

MSSQL server 2005/2008, ORACLE 8.0/10G PL/SQL, Crystal Reports XI

Active Reports, MS Access, MS Excel, Microsoft IIS and Borland

StarTeam.

. Highly competent in management, designing and development who has been

through several

SDLC including analysis, design, source code development and

management, production, QA and GAO audit support.

. Highly competent in designing, development, Testing and Debugging of

COM components,

ActiveX server and ActiveX Controls, deployment and management of

COM components.

. Highly competent in User interface designing. Highly experienced

and efficient working with ADO, ADO.Net, ODBC and OLEDB.

. Highly competent in Design and Development of Relational Database

and Database Objects PL/SQL, Constraint structures, stored

procedures using Cursors and Functions, extensively experienced

using Data Base Indexes, Triggers and Views.

. Excellent project management skill including project planning,

coordination, problem solving and status reporting.

. Highly experienced and competent working with end users regarding

requirement planning and refining, UAT support and client meetings.

. Highly efficient to learn new business details and quickly adopts

work environment and process.

PROFESIONAL EXPERIENCE

Multifamily Division (MARS, L3 Prod Support)

May 11 to 05/17/2013

Client: Freddie Mac.

Freddie Mac Multi Family division provides Multi Family mortgage

services. MARS (Mortgage Accounting Reporting System) development includes

modification and restructuring to the existing applications and dataflow.

Data conversion and data validation to transfer the loans to LoanIQ.

Integration layers and adaptor design and development to synchronize

different application systems. Providing support to production activity,

data research, maintenance, analysis.

Responsibilities:

. Responsible for coding, user interaction, status reporting,

development estimation (LOE) and

completion.

. Responsible for BA interaction for requirement planning and

involved working with the QA and

testing support.

. Responsible for development/analysis with VB.net, VB 6/5/4, Sybase

12, Oracle, Autosys,

Rapid SQL.

. Responsible for partial development of Loan IQ data conversion

validation module.

. Responsible for development with Winforms.

. Work with data base objects, ADO.Net, ADO, RDO, SQL stored

procedures, Triggers.

. Designed and developed the database objects using Relational and

constrain structures.

. Involved in Performance tuning and optimization of queries.

. Experience working with Production Support Team for analysis, data

fix.

. Experience working with SOX enhancements, maintenance and audit

activity with L3

production support.

. Produced design docs, Unit Test docs and conduct review meetings

. Responsible working with Remedy System, Clear Case, Clear Quest and

Lotus Notes.

Environment: VB.net, Visual Basic 6/5/4, VBA, Rapid SQL, Sybase 12,

Oracle,

Clear Case, Lotus Notes.

Wealth Management System (RockitTM Command)

Aug 09 to May 11

Client: Rockefeller Financial.

RockitTM Command provides highly customized solutions across the

spectrum of investment and wealth-management services. The data flows in to

the RockitTM Command from Custodian, Outside Manager and Brokers as

transaction feeds and pricing feeds. The data will be aggregates and

reconciled after error resolution and transaction will be post to accounts

and general ledger also updated at the same time. Custom reporting and

tools helps the wealth holders and advisors to make the decision.

Responsibilities:

. Responsible for coding, Client interaction, status reporting,

development estimation (LOE) and completion.

. Responsible for BA interaction for requirement planning and involved

working with the QA and testing support.

. Responsible for development with VB.Net, VB 6.0, MSSQL 2008, MS Excel.

. Responsible for new import system implementation and enhancement to

all import systems. This includes implementation, development and

modification to import modules. Coding, debugging and deployment of

COM, ADO.net, ADO, VB 6.0 UI and SQL stored procedures using cursor

and functions .Preparing and developing new set of validation and

rules for imports.

. Creating validations using VB.Net and integrating the function to SQL

stored procedures.

. Involved in developing and enhancing custom reports using Active

Reports, SQL stored procedures and functions. Development and

modification of report forms to introduce new input report parameters

as well as modification to existing report parameters. Implementation

of custom grouping mechanism, implementing report for internal and

external distribution and preparing one time SQL scripts to update

existing data for modification.

. Developed search forms and transaction forms using VB 6.0 controls,

Custom controls, ADO, SQL stored procedures. Designed and developed

the database objects using developed Relational and constrain

structures, Tables, Views, Indexes

. Responsible for maintaining TestTrak for development tracking and

release management.

. Responsible for providing assistance for problem solving to team

members.

. Involved in Performance tuning and optimization of queries.

. Highly Efficient and experienced using centralized and geographically

distributed software development environments (SourceOffsite)

Environment: Visual Basic 6, VB.Net, VBA, MSSQL 2008, Active Reports,

SourceOffsite.

AIMS (Assessment Information Management System)

Mar 06 to Aug 09 Client:

Federal Deposit Insurance Corporation (FDIC).

Assessment Information Management System (AIMS) is one of the key

applications used by FDIC. FDIC broadly relay on Assessment Information

Management System (AIMS) to calculate, invoice, and collect deposit

insurance assessments from insured financial institutions. AIMS generate

the Invoice quarterly to collect the deposit insurance assessments from

insured financial institutions.

Responsibilities:

. Extensively involved in developing data flow diagrams of business

model.

. Designed and developed the database objects Tables, Views, Indexes,

Relational and constrain structures

. Designed and developed MSSQL Stored procedures, Functions and triggers

for data manipulation.

. Involved in Performance tuning and optimization of queries.

. Responsible for designing, development, debugging and deployment of

COM components.

. Design and developed User Interface using ASP, HTML/DHTML, CSS, VB

script, JAVA script

. Responsible for coding in VB, ASP, VB.net, ASP.net, Design UI with

Win Forms

. Designed and developed ADO, ADO.Net for data access with MSSQL Server

2005.

. Designed and developed reports with MS-Excel, Actuate Reports, Crystal

Reports.

. Design and develop a COM component for Cryptographic (FIPS-140-2)

access authentication and password encryption and decryption.

. Extensively involved in requirement planning and refining, Testing

support, client meetings, TMR meetings, GAO audit.

Environment: Visual Basic 6, VB.net, ASP.net, VBA, ASP, MSSQL 2000/ 2005,

Actuate Reports, Crystal

Reports, Borland StarTeam, IIS 6.0/5.0.

A.E.R.I System (Auto Email Report Import System)

Feb 05 to Feb 06

Client: Total Logistic Services (TLS)

TLS is a consolidation service provider, works with USPS, UPS, DHL,

APX, APS and other shipping companies .TLS provide the bulk mail and parcel

distribution services to all over the USA.

A.E.R.I System (Auto Email Report Import System) is the program for

the processing and reporting structure. A.E.R.I System down load all the

manifest files from FTP sites to TLS's server and imports the information's

to the SQL server. A.E.R.I System is developed with a efficient reporting

facility. A.E.R.I System allows users to subscribe for reports with

customized criteria's and formats. The subscribed reports automatically

create and send to users email account.

Responsibilities:

. Responsible for Software Requirement Analysis, Design Specifications,

and Functional Specifications.

. Developed stored procedures, Functions and triggers for data

manipulation.

. Involving in Performance tuning and optimization of queries.

. Developing Business logic using VB and COMs

. Developed User Interface screens using Visual Basic 6.0.

. Responsible for coding in VB and unit testing.

. Designed and developed reports with MS-Excel, Crystal Reports.

Environment: Visual Basic 6, VBA, MSSQL 2000, Crystal Reports, Windows

2000/XP 8.0

Inventory Management System Jun

03 to Jan 05

Client: Corporate System Solutions Inc

IMS is a customized multi user three-tier application. It allows user

to generate Invoice, Sales order, Purchase Order and Bills. Administrator's

console allows creating new users, manipulating security privileges. IMS

provides Customization of Price levels based on customer type. The

application also includes efficient report generation for Inventory

Management, Sales Department, Purchase Department, Returns and Damages

Department.

Environment: Visual Basic 6, VBA, ASP3.0, Data Reports, MSSQL7.0 /

2000,Oracle 8.0, Crystal Reports, Windows 2000/XP 8.0

Cost Allocation Management System (CAMS)

Aug 02 to Dec 02

Client: CASA De San Bernardino, CA, USA

CAMS is an application developed for Government sponsored drug rehab

center. It allows user to create patient profile, history of addiction,

Scheduling treatment plan classes and history of the medication treatment.

Environment: Visual Basic 6, MSSQL7.0, and Crystal Reports 7.0

Price.com Aug 02

to Dec 02

Client: Price.com

The site provides price comparison to enable buyer to compare the prices

and select the company for the product of their interest.

Environment: VB6.0, ASP 3.0, PostgreSQL, JavaScript, HTML, DHTML, XML,

IIS5, Win2000

EDUCATION

MCSD (Microsoft Certified Solution Developer)

. BE in Engineering (Instrumentation)

. Diploma (Instrumentation)

Contact this candidate