Manan Unakdat (MS Access / VBA / VB Developer)

Mobile Phone: 816-***-**** E-mail: nm4t29@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Seasoned Developer with expert skills in Oracle, SQL, Visual Basic, ASP and Access 97/2000/2003

Having 9+ years of experience in Information Technology & Consulting; working on various technologies

Worked in various phases of SDLC such as Business/Functional & Technical Requirement & Analysis, Designing, Development, Implementation and Testing of multi tier Client server Applications in Insurance Domain like: Life, LTD, STD and Dental

Skills are design and development using Visual Basic (VB), Visual Basic for Applications (VBA), MS Access 97/2000/2003, Core Java, DataStage, ETL, Oracle, AutoSys Scheduling, Pl/SQL.

TECHNICAL SKILLS

Databases: Access 97/2000/2003, Microsoft SQL Server, Oracle, PL/SQL.

Operating Systems: Windows 2000/2003, Linux

Languages: Visual Basic, VBScript/JavaScript, HTML, XML, ASP, VBA, Unix Shell Script, Macro, Templates

Applications: Microsoft Office Suite (Word, Excel, PowerPoint), MQ Series

Tools: TOAD, SQL Navigator, MQ View, WMQ Tool, ETL tools, Reporting tools like Business Objects, Harvest, FileNet, Citrix, Visio, Adobe suit, Macromedia Dream viewer 8, Front page 2000, WebSphere, xPression

Version Control: PVCS, VSS, CVS, and Subversion

FTP tools: Message Queue Setup, Hummingbird Exceed, SFTP, WinSCP, FileZilla

PROJECT DETAILS

Project: Conversion Project

Client Assurant Employee Benefits

Title: Software Specialist

Conversion is MS access based Policy admin system for Conversion policy. I have developed and maintained this Access database to provide full functionality about Policy administration.

In this mdb file there are 15 Forms and more than 40 macros, which are responsible to provide complete Policy admin with fewer Screens. This access database has some nice feature like,

1. Automated report for Daily/Quarterly and Yearly report process

2. ACH system which provided ACH transfer from Chase Bank directly.

3. Data feed through MQ from Oracle

4. Well maintained Switchboard which provide easy browse to all screen

5. Daily Backup using Macro/Batch file.

In this project Access Forms, Reports, Sub Forms, Reports and Macros are extensively used. Also maintain company compliance for all outgoing emails.

Role & Responsibilities

1 Building this project from scratch. Understanding Business functionality and create Functional Specification along with detail data flow diagram (Visio)

2 Screen components detailing, screen validation.

3 Define database objects, create dry runs to understand the data flow within underlying tables

4 Creating Report, Forms, Macros and queries

5 Providing good quality and daily back

6 Preparing test cases, performing unit & integration testing.

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Onsite Co-coordinator (Current),

Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. MS Access 2003/97

2. AutoSys,

3. Oracle and Quality Control,

4. Visual basic applications (VBA),Visual Basic

5. Visio.

Duration of the Project : From : June 2010 To : Current

Project: Print Mailing

Client Assurant Employee Benefits

Title: Software Specialist

Print mailing is access 2003 based application. This application gets feeds from CaTS system and provides complete Mailing system.

Key features are

1. Automated System for Printing Labels/Letters

2. Mail-Merge used

3. Export Text file to xGen application. xGen will convert into XML and send to xPression for printing

4. Send archive text file to Mainframe system for long term storage.

5. Automated Status update using Email communication after completion of each print request.

In this project Access Forms, Reports, Sub Forms, Reports and Macros are extensively used.

Role & Responsibilities

7 Understanding Business requirements and Functional Specification along with detail data flow diagram (Visio)

8 Built All screen and maintained Switch board

9 Performed complete SDLC cycle independently

10 Created all macro for archival and email process

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Onsite Co-coordinator (Current),

Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. Access 2003

2. Visual Basic/ VBA

3. Oracle

4. Mainframe

5. Visio.

Duration of the Project : From : Jan 2010 To : June 2010

Project: SBSC (Small Scale Business Selling)

Client Assurant Employee Benefits

Title: Software Specialist

SBSC small business selling system which built for sales team. This is access database based application which provides Policy quote system based on entered parameter.

Key features

1. With few input it calculates quotes in PDF format

2. When user click for PDF in background it complete all Business validation using Macro

3. Provide accurate and correct calculation

4. Provides ability to send PDF in email

5. Keep track of all quotes and email. Its also set remainder for follow up for an agent

6. Workgroup is created so it can allow multiuser environment.

7. Achieve PDF in FileNet. This PDF sent automatically to FileNet using MQ Client

In this project Access Forms, Reports, Sub Forms, Reports and Macros are extensively used.

Role & Responsibilities

11 Onsite coordination through draft documentation of Macro level study, understanding Business functionality and create Functional Specification along with Screen components detailing, screen validation.

12 Form Prototype designing, defining database objects, writing store procedures, development of screens, creating help file/ manuals & technical documentations.

13 Created access macro, build new forms and repots using Access VBA,

14 Built & setup new Queues, AutoSys feed jobs. Created macro for feed process.

15 Preparing test cases, performing unit & integration testing

16 Packaging and building deployment through Novell & Citrix environment.

17 Maintain Version control in PVCS.

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Onsite Co-coordinator (Current),

Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. MS Access 2003

2. Visual Basic, COM/DCOM

3. Oracle & PL/SQL

4. Mainframe, MQ series, Citrix,

5. Visio.

Duration of the Project : From : Sep 2008 To : Dec 2009

Project: CalcFee

Client Assurant Employee Benefits

Title: Software Specialist

CalcFee is Access based system built for Fee Calculation for any provider.

Key Features.

1. Provide Fee Calculation based on Business validation

2. Generate Export for Other system to use generated Fee Quotes

3. Exports are created based on system like for Mainframe its text file and For Other application its in Spread sheet format

4. Provide ability to send quote in Email

5. Ability to achieve each quote in Mainframe using MQ client

In this project Access Forms, Reports, Sub Forms, Reports and Macros are extensively used.

Role & Responsibilities

18 Understanding the business specification and create documentation

19 Detailed study of existing application and created all screen/Report/Macro.

20 Detailed analysis of user requirements. Complete involvement on all SDLC phases.

21 Developing User interface and application controller

22 Configuration Manager for project deliveries

23 Preparing test cases, performing unit & integration testing

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Onsite Co-coordinator (Current),

Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. MS Access 2003

2. Visual Basic, COM/DCOM

3. Oracle & PL/SQL

4. Mainframe, MQ series, Citrix

5. Visio.

Duration of the Project : From : Jun 2007 To : Sep 2008

Project: Life Conversion

Client Assurant Employee Benefits

Title: Sr. Software Engineer

Life conversion is policy admin system. This application can establish new policy, termination of existing policy and maintain premium. User interface is based on MS Access VBA. It gets daily feeds from other admin system and converts policy with new premium structure. This feed come through AutoSys jobs and MQ. This application provides monthly repots to actuarial. These reports are built in Business objects and Excel.

Role & Responsibilities

24 Understanding Business functionality and create Functional Specification along with Screen components detailing, screen validation.

25 Define database objects, create dry runs to understand the data flow within underlying tables

26 Creating access macro, build new forms and repots using Access VBA.

27 Building & setup new Queues, AutoSys feed jobs.

28 Preparing test cases, performing unit & integration testing.

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Onsite Co-coordinator (Current),

Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. MS Access /VBA

2. Visual Basic, Excel, AutoSys

3. XML, MQ Series

Duration of the Project : From : Sep 2006 To : Jun 2007

Awards (if any) : None

Project: PDG Tin specific Export to ClaimFacts

Client Assurant Employee Benefits

Title: Software Engineer

Dental Health Alliance (DHA) is large dental business for AEB. In DHA they are connected to new network called PDG. Now in PDG provider Fees are TIN specific. ClaimFacts need all fee data to process claims. This Access based project build to transform User input fee into TIN specific fee and export it to ClaimFact for claim Processing

Role & Responsibilities

29 Development of new design based on client requirement specification.

30 Creation of high level & low level design specification and Component specifications,

31 Building all Screen/Export Queries/Import Macros and coordinated with other development team

32 Building extensive test case and providing zero defect deliverables.

33 Implementing company standards

34 Follow the review/rework process after each phase of design, coding and testing

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Onsite Co-coordinator (Current),

Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. MS Access /VBA

2. Visual Basic, Excel, AutoSys

3. XML, MQ Series

Duration of the Project : From : May 2005 To : Sep 2006

Awards (if any) : None

Project: BSL Webstore & Managerial Information System for BSL (MIS)

Client Birla Sun Life Insurance

Title: Software Engineer

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. HTML/DHTML

2. JavaScript/VBScript

3. Visual Basic 6.0 , Active Server Pages (ASP)

4. SQL Server 2000

Duration of the Project : From : Dec 2004 To : Feb 2005

Project: Online shopping mart for Orra & Intergold Jewelers

Client Orra & Intergold Jewelers

Title: Software Engineer

Orra & Intergold are reputed gold merchants; client of Easybuy and wanted to develop online shopping for users based in India. The website provides different payment options like cash, check, debit/Credit card to its users. Payment gateway is implemented with this website.

Role & Responsibilities

35 Develop new requirement as per client specification. Requirement analysis and client interaction. Creation of application as a part of exiting website

36 Design for the Web-store customizations. Coding, Testing & debugging

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. HTML/DHTML

2. JavaScript/VBScript

3. Visual Basic 6.0 , Active Server Pages (ASP)

4. SQL Server 2000

Duration of the Project : From : Aug2004 To : Nov 2004

Project: Monthly Points Statement.(MPS)

Client Birla Sun Life Insurance India

Title: Software Engineer

BSL Insurance Company. This Monthly point’s statement is utility software as a subsidiary part of BSL web-store. This is automated mailing system for sending statement of points for BSL agents. MPS sends statement at every first week on month. With the help of this utility user can view current point’s availability on their account.

MPS is a mailing application, which does not include any user interaction. Using this utility Manager of BSL can also send new scheme of forthcoming attraction along with the statement.

Role & Responsibilities

37 Understanding of business model and requirements analysis

38 On the base of analysis create a new technical architecture, Coding, Testing & debugging

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. HTML/DHTML

2. JavaScript/VBScript

3. Visual Basic 6.0 , Active Server Pages (ASP)

4. SQL Server 2000

Duration of the Project : From : May 2004 To : Aug 2004

Project: Online Examination

Client Saurashtra University India.

Title: Software Engineer

Atmiya Infotech is product-based company. This Online examination is developed for university to conduct entrance exam via web.

Role & Responsibilities

39 Design & implementation of ASP pages writing store procedures.

40 Understanding of business model and requirements analysis

41 On the base of analysis create a new technical architecture, Coding, Testing & debugging

Your Role in the project (Programmer, Designer, Analyst, Project manager etc) : Developer,

Team member

Proprietary Tools /Frameworks / Methodologies used in the project (e.g. Structs in Java ) : 1. HTML/DHTML

2. JavaScript/VBScript

3. Visual Basic 6.0 , Active Server Pages (ASP)

4. SQL Server 2000

Duration of the Project : From : Nov 2003 To : Apr 2004

EDUCATION

Master of Computer Application (MCA), Saurashtra University, Gujarat, India

Bachore of Commerce (B.Com), Saurashtra University, Gujarat, India

Contact this candidate