COMPUTER PROFICIENCY:

• Window/Web Applications, Database Applications,
• Reports Applications.
• VISUAL BASIC(VB) Version 3, 4, 5 & 6 SQL ACCESS, HTML, XML, ASP,
• SSRS. Crystal Reports versions 7, 8, 8.5, 9,10,11, Business Objects,
• SQL SERVER, ODBC, OLEDB, DTS, SQL 2000 & SQL 2005 SSIS. Crystal Enterprise.
• Relation Database(RDBMS), ACCESS Database, SQL Database, Oracle
• ADO, RDO & DAO.
• WINDOW 95, 98, 2000, XP, NT WINDOW, FRONTPAGE
• MS EXCEL, MS WORD.

Note: Have done over 1000 of Crystal Reports They includes parameters, formulas,
subreports, pivot tech, cross-tab reports, graphs, charts, formulas, pick lists, grouping,
conditional formatting formulas, detail/summary reports, business Objects & etc.

Have done Transact-SQL for last 10 years plus. --- It includes SQL query, SQL stored
procedures, trigger, performance test, debugging, designing SQL database.
Installing SQL server, tuning SQL server performance,analyzing SQL server, updating
SQL server. Converted from one/multi databases to another databases or vice versa.
Used DTS extensively from designing packages to import/export databases.

MOST RECENT EXPERIENCES:

Company Name: Confidential, Burlington, MA Date: Dec &rsquo11à
Tasks Accomplished:

• Developingcomplex HealthCare Crystal Reports using charts graphs cross-tab subreports aggregatefunctions & complex pick-list(very user-friendly features). Altogetherdeveloped more than 30 reports within a short period. Published reports to BO.
• Analyzing few databases & developed complex SQL queries to achieve the reports.
• Using Crystal ReportDTS, SQLSSRSBussiness Objects, ACCESS & EXCEL.

Company Name: Confidential,Brockton, MA Date: Sep &rsquo11à Dec&rsquo11
Tasks Accomplished:

• 1.Developingcomplex SSRS Reports using complex SQL queries based on spec., old crystal reports & new business rules. Overall developed more than 20 reports with charts/graphs, few technical documents & analysis documents.
• Duties include whole cycle of the project - including holding conference with users, analyzing, developing reports & implementation.
• Using SSRS, SSIS, SQL Crystal Reports, Bussiness Objects, ACCESS & EXCEL.

Company Name: Confidential,Worcester,, MA Date: Jan &rsquo11à Jul&rsquo11
Tasks Accomplished:

• Developingcomplex Crystal Reports using charts graphs cross-tab subreports & aggregate functions & complex pick-list(very user-friendly features). Altogether developed more than 30 reports within a short period. Published reports to BO.
• Analyzing few databases & developed complex SQL queries to achieve the reports.
• Using Crystal Report SQL Bussiness Objects, ACCESS & EXCEL.

Company Name: Confidential,Springfield , MA Date:Nov &lsquo10 , Jan &lsquo11
Tasks Accomplished:

• Developing Crystal Reports using very complex SQL queries used for developing sales forecasting reports.Using Crystal reports graphs, subreports and pick-list.Also used complex grouping and sorting for the Crystal Reports data.
• Assisted in downloading data from different store databases into company headquarter database.
• Using Crystal Reports v11, SQL queries, ACCESS, SSIS, SSRS and SQL Server 2008.

Company Name: Confidential,Worcester , MA Date: Jul&lsquo10 ,Oct &lsquo10
Tasks Accomplished:

• Developing one very complex Crystal Report. Initially analyzed existing database system and recommended system updates to be used with Crystal Reports.
• Using Crystal Reports v11, SSIS, SSRS, ACCESS, SQL and SQL Server 2008.

Company Name: Confidential,Westwood, MA. Date: May\'09 Apr&rsquo10
Tasks Accomplished:

• Developingcomplex Crystal Reports using charts graphs cross-tab subreports & aggregate analytical functions These reports allow executives to view how employees spending time by calculating man-hours/units in multi-dimensions. Also, developing over 20 adhoc reports for other groups. Responsible for whole project cycle from gathering requirements till displaying reports to end-users. All reports are accessed via Crystal Enterprise/Business Objects.
• Tasks include analyzing business requirements designing, coding & implementing. Developed complicated Stored Procedures to select data for the reports. Maintained SQL server & databases. Wrote technical documents for maintaining the systems.
• Tools - Crystal Report 11 SQL PL/SQL Stored Procedures Business Objects, SSRS, Crystal Enterprise.

Company Name: Confidential,MA. Date: Feb\'09 May&rsquo09
Tasks Accomplished:

• Developing over 50 sophisticated Crystal Reports using charts graphs cross-tabsubreports & etc. Using very complicated SQL aggregated queries functions triggers.. Translating business requirements into technical solutions using BO/Crystal Reports/SQL.
  Maitainning existing CR reports including debugging & tunning. Analyzing data from multi databases & linking data to one another to produce reports, charts & graphs.
• Developing data solutions to achieve reports for accountants/VP via Crystal Report.
• Tasks include developing BO, Crystal Reports coding queries interfacing with users/technician. Developed spec. & technical documents.
• Tools - Crystal Report 11 SQL ORACLE Crystal Enterprise Business Objects ACCESS.

Company Name: Confidential, Boston, MA. Date: Sep\'08 Jan&rsquo09
Tasks Accomplished:

• Developing/maintaining SQL stored procedures controlled/maintained all DTS/SP jobs Generating reports. Responsible all local/remote servers maintenance backup/restore & other tasks requested by users.
• Tasks include coding stored procedures developing/maintaining DTS packages monitoring all job streams in different servers.
• Tools - SQL 2000 SQL 2005 SSIS Crystal Report 11 Business Objects ACCESS EXCEL & SQL Query.

Company Name: Confidential,Boston, MA. Date: Apr\'08 Jul&rsquo08
Tasks Accomplished:

• 1.Developing new initiative sophisticated Crystal Reports using charts graphs cross-tab subreports & etc. Also, very complicated SQL aggregated queries functionstriggers. Reports are for marketing analysis doing the current/forecast reports. Translating business requirements into technical solutions using Crystal Reports/SQL/VB.
• Tasks include designing, coding. analyzing, implementing & documenting.
• Tools - Crystal Report 10 Business Objects Crystal Enterprise SQL 2000 SQL

2005 SSIS Stored Procedures.

Company Name: Confidential,Canton, MA. Date: Dec\'07 Apr&rsquo08
Tasks Accomplished:

• 1.Developing complex Crystal Reports (Revenue Recognition Mgt System) usingcharts graphs cross-tab subreports & etc. It allows users to select a single or random criteria item(s) before executing reports. Creating summary reports plus detail reports with drill-down technology. Responsible for whole project cycle from gathering requirements till displaying reports to users.
• Tasks include analyzing business requirements designing, coding, database coding/linkage wrote multi-complicated Stored Procedues to select data for CR implementation.
• Tools - Crystal Report 10 SQL 2000 SQL 2005 SSIS ORACLE TOAD Stored Procedures Business Objects.

Company Name: Confidential,Beverly, MA. Date: Jul\'07 Oct&rsquo07
Tasks Accomplished:

• Developing over 50 Mercury Engineering Reports(MER) to inf&rsquoo semiconductor tools to manufacture chips. The MER use Crystal Reports 11, SQL, C#, ASP.NET & etc. MER consists of very complicated data calculating, graphing, charting & tables linkage. Responsible for whole project life cycle.
• Tasks include analyzing, meeting with users, designing, coding, testing & WEB designing. Also preparing technical documents explaining the linkage of database & etc.
• Tools Crystal Report 10, VB, ASP.NET, SQL, JAVAscript, ADO.NET, ASP debugger, Business Objects, C#, XML & HTML.

Company Name: Confidential,Charlestown MA. Date: Apr\'07 Jul&rsquo07
Tasks Accomplished:

• Maintained existing application for the insurance teleclaim company. Discussing with clients, business analysts & IT analysts to determine how project should be approached. Accomplished successfully all projects & some with recommendations.
• Tasks include programming, heavy analysizing, heavy debugging & reporting.Preparing documents for the applications.
• Tools - ASP, VB, PL/SQL, TOADS, JAVAscript, VBscripts, ACCESS, ASP debugger,VB debugger.

Company Name: Confidential,CambrIdge MA. Date: Mar&rsquo07 Apr\'07
Tasks Accomplished:

• Developed analytical reports for the sales & research groups using SQL & CrystalReports. Tasks include meeting with business users & IT analysts to iron out reports,formulae, different graphics, table, cross-tab reports & etc. All completed successfully.
• Tools - Crystal Report 10, ACCESS & VB.

Company Name: Confidential,Boston, MA. Date: Jan&rsquo07 Mar&rsquo07
Tasks Accomplished:

• Developed/analyzed multi financial Reports using Oracle database & Crystal Reports 10.
• Tasks include designing, analyzing, coding, testing & implementing.

Company Name: Confidential,Boston, MA. Date: Aug&rsquo06 Dec&rsquo06
Tasks Accomplished:

• Developed/Maintained the YSIS application which controls the underage criminalsin and out of the State Correction Facilities. YSIS is written in VB, HTML, DLL, IIS,SQL/PLUS, UNIX, ACTUATE, CRYSTAL REPORTS, ACCESS & ORACLE.
• Responsible for analyzing/coding/testing/implementing. Assisting in solvingproblems, developing new task to meet business requirements, creating numerous
  ad hoc reports as needed. Tasks include from converting business logic phase thru the end-user execution.
• Tools - VB, HTML. DLL, IIS, SQL/PLUS, SQL, CRYSTAL REPORTS 9,TOADS, Oracle & ACCESS.

Company Name: Confidential,Marlboro, MA. Date: Sep&rsquo05 Jun&rsquo06
Tasks Accomplished:

• Developed PacketWriter System(PWS) for nationwide police officers to send police violation ticket information to the police station. PWS is
  written in a special software which is based on VB, VB.NET, SQL, Crystal Reports, XML, Java & HTML.
• Responsible for designing/coding/testing/implementingsoftwareanalyzing data Requirements & proposing technical approaches. As project grows, wrote
  technical documents to maintain thesoftware.
• Tasks include involving whole life cycle of the project, collecting business requirements, analyzing, designing, coding, testing & implementing. Using
  Crystal Report with parameters, formulas, subreports, cross-tab, graphs.
• Tools - VB, Crystal Reports 9, SQL, ACCESS, VB.NET, XML, HTML,

Company Name: Confidential,Danvers, MA. Date: Jan&rsquo05 Jul&rsquo05
Tasks Accomplished:

• 1.Designing/developing Survey Assessment Application to collect/analyze employeesurveys & generating reports.
• Developing Scanning Manufacturing Application to control inventory.Involving whole cycle of both projects---from communicating with users to
  implementing.
• Overall tasks include meeting with users, system architecture, databasedesigning, coding testing & implementing.
• Designing/generating Crystal Reports. Maintaining/supporting existingCrystal Report Applications & utility applications.
• Tools - DTS, SQL, ORACLE, Crystal Reports 8.5 with parameters, formulas,subreports, cross-tab, graphs & charts. ACCESS, ADO.NET, ASP,
  HTML, XML, VB.NET & VB.

Company Name: Confidential,East Greenwich, R.I.. Date: Aug&rsquo04 Nov&rsquo04
Tasks Accomplished:

• 1.Deisgning , testing, coding & implementing, converting main frame data into SQL database. Coding in stored procedures, ACCESS, VB.
• Tools - SQL, ACCESS, VB.NET & VB.

Company Name: Confidential,Coventry, R.I. Date: May&rsquo04 Aug&rsquo04
Tasks Accomplished:

• 1.Designing/developing 12 sales & inventory reports for the Sales Order InventoryWEB sites using Crystal Reports, ORACLE & SQL. Also 50s subreports, cross-tabs, charts & stored procedures. Allowing users to generate/distribute reports from the WEBsites. Converting reports to EXCEL, XML & other formats as requested.
• Tasks also include analyzing business requirements, creating stored procedures/queries/triggers /views, data-extraction, testing, data verifications & etc. Meetingwith business groups to convert business logic into report logic/formulae.
• Tools - SQL, ORACLE, Crystal Reports 8 with parameters, formulas, subreports,cross-tab, graphs & charts, VB.

Company Name: Confidential,Boston, MA. Date: Dec&rsquo03 - Mar&rsquo 04
Tasks Accomplished:

• 1.Developing Annual Meeting 2003 Report Application which consists of 41 main reports & 95 subreports & many Cross Tabs & charts. Its main function is to calculate counts from multi dimension views for the executives of the Church.
• Tasks include analyzing business rules, Oracle database & deciding the most optimalapproach. Then, developing VB front-end & Crystal Reports which accessOracle database. Developing SQL queries to verify report data creating view & etc.
• Tools - VB, SQL, Crystal Reports 8 with parameters, formulas, subreports,cross-tab, graphs & charts, functions & Oracle.

Company Name: Confidential,Portland, Maine. Date: Dec&rsquo02 Aug&rsquo03
Tasks Accomplished:

• 1.Analyzing & coding Renewal Package System(disability policy system) using CrystalReports, VB, SQL, MS WORD to create documents based on data from the SQL database & user selection criteria from the WEB page. Also, developing few WEB pages usingASP,HTML, VB Script.
• Tasks include analyzing existing systems, proposing software tools & methodology,developing SQL stored procedures, heavy VB coding
• Tools - VB, SQL, Crystal Reports 8 with parameters, formulas, subreports,cross-tab, graphs & charts, Ms WORD, Ms ACCESS, ASP.

Company Name: Confidential,Shrewsbury, MA. Date: Sep&rsquo01 Aug&rsquo02
Tasks Accomplished:

• Analyzing, designing, coding & implementing Nursing Home Initiative system(NHI).NHI is a nursing home case management system to manage state(MASS) nursing homeclients involving sophisticated business rules, database designing & programming.
• Tasks include heavy communicating with users about business rules, businessrequirements, recommendation, designing, programming & etc. Also, include
  designing database, developing stored procedures for the SQL database, designing VB forms & VB programming from the beginning to the end of the project
  development. Mentoring programmer in designing database & coding in VB(GUI & back-end). Developing VB COM business oriented modules. Assisting maintenance of existing WEB systems(ASP, HTML, VBA).
• Developing ORACLE stored procedures, triggers & functions for Elderly Prescription System. Also, maintain ORACLE database via VB.
• Using VB.NET to develop WEB forms to build interactive Internet applications to display HTML documents in Internet Explorer
• Tools -VB, VBA, ADO, VB COM, OO, ACCESS, SQL, ASP, VB.NET, XML, MTS,

SQL SERVER, DTS, FRONTPAGE 2000, ORACLE, EXCEL, NT WINDOW,
TRANSACT-SQL, GUI & Crystal Reports 8 with parameters, formulas,
subreports, cross-tab, graphs & charts.

Company Name: Confidential,Warwick, R.I. Date: Feb&rsquo01- Aug\'01
Tasks Accomplished:

• Converting 6 ACCESS databases into SQL databases & converting each front-endinto WEB pages using ASP(HTML, VBScripts). Converting from 2-tier to 3-tier from window applications to WEB applications.
• Tasks include analyzing existing ACCESS systems & recommending themost optimal methods to approach the conversion. Also, installing SQL server & setting-up SQL databases, tables, indexes, triggers, stored-procedures.Meeting with users to revise new requirements & design new requirements to be installed into the new systems. Designing, coding, testing & implementing in ASP, VBSCRIPT & HTML. Solving problems for existing COM modules.
• For Personal Loan Survey System, created ORACLE stored procedures & functions.Using VB to access/maintain ORACLE database.
• Tools - VB, VBSCRIPT, ASP, SQL, ADO, OO, VB COM, SQL SERVER,

DTS, ACCESS, HTML, FRONTPAGE 2000, MTS, ORACLE, IIS,
TRANSACT-SQL, Crystal Reports 7.5 & WINDOW 2000.

MAJOR PROJECTS ACCOMPLISHED(1976-2011):
PacletWriter System ---- transmitting police officer ticket informations.
Medical Survey Assessment Application & Scanning Vascular Manufacturing Application
E-Commerce Sales Order Inventory Report
Annual Meeting Registration Package
Renewal Package System(Disability Policy System).
Nursing Home Client Management System.
Banking Account Systems.
Invoicing/Shipping/Order Processing System.
Mutual Fund System.
Accounts Receivable Securitization System.
Management Value Pricing System.
Product Service Warranty Report System.
Medical Insurance Claim System.
Mutual Fund Taxation System.
Engineering System(LKG KEY System).
Mutual Fund Sales System.
Banking Foreign Exchange Currency System.
Shopkeeper System --- Payroll Clock In/Out System.
Shipment Suspense Release System.
Engineering Application I/O Report System.
SOIC II System --- (Manufacturing System).
Interactive Telephone Billing System.
Field Service Old/New Warranty System.
Banking Systems.
Order Processing Systems.
CAD/CAM System.
Account Payable/Receivable Systems.
Rotation/Consignment System.
Revenue Accounting System.
General Ledger System.
Insurance Systems.
Educational Budget System.
Inventory System.
Financial Forecast System.
Payroll System.

EDUCATION:
B.S. in Mathematics & Economics