SUMMARY

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 ’11à
Tasks Accomplished:
1. Developingcomplex HealthCare Crystal Reports using charts; graphs; cross-tab; subreports
; aggregatefunctions & complex pick-list(very user-friendly features). Altogether
developed more than 30 reports within a short period. Published reports to BO.
2. Analyzing few databases & developed complex SQL queries to achieve the reports.
3. Using Crystal Report;DTS, SQL;SSRS;Bussiness Objects, ACCESS & EXCEL.

Company Name: Confidential,, Brockton, MA Date: Sep ’11à Dec’11
Tasks Accomplished:
1.Developing complex 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.
2. Duties include whole cycle of the project - including holding conference with users,
analyzing, developing reports & implementation.
3. Using SSRS, SSIS, SQL; Crystal Reports, Bussiness Objects, ACCESS & EXCEL.

Company Name: Confidential,Worcester,, MA Date: Jan ’11à Jul’11
Tasks Accomplished:
1. Developing complex 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.
2. Analyzing few databases & developed complex SQL queries to achieve the reports.
3. Using Crystal Report; SQL; Bussiness Objects, ACCESS & EXCEL.

Company Name: Confidential,Springfield , MA Date:Nov ‘10 –-> Jan ‘11
Tasks Accomplished:
1. 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.
2. Assisted in downloading data from different store databases into company headquarter
database.
3. Using Crystal Reports v11, SQL queries, ACCESS, SSIS, SSRS and SQL Server 2008.

Company Name: Confidential,Worcester , MA Date: Jul‘10 –->Oct ‘10
Tasks Accomplished:
1. Developing one very complex Crystal Report. Initially analyzed existing database system
and recommended system updates to be used with Crystal Reports.
2. Using Crystal Reports v11, SSIS, SSRS, ACCESS, SQL and SQL Server 2008.

Company Name: Confidential,Westwood, MA. Date: May\'09 --> Apr’10
Tasks Accomplished:
1. Developing complex 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.
2. 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.
3. Tools - Crystal Report 11; SQL; PL/SQL; Stored Procedures; Business Objects,
SSRS, Crystal Enterprise.

Company Name: Confidential,MA. Date: Feb\'09 -->May’09
Tasks Accomplished:
1. Developing over 50 sophisticated Crystal Reports using charts; graphs; cross-tab;
subreports & 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.
2. Developing data solutions to achieve reports for accountants/VP via Crystal Report.
3. Tasks include developing BO, Crystal Reports; coding queries; interfacing with
users/technician. Developed spec. & technical documents.
4. Tools - Crystal Report 11; SQL; ORACLE; Crystal Enterprise; Business
Objects; ACCESS.

Company Name: Confidential,Boston, MA. Date: Sep\'08 --> Jan’09
Tasks Accomplished:
1. 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.
2. Tasks include coding stored procedures; developing/maintaining DTS packages;
monitoring all job streams in different servers.
3. Tools - SQL 2000; SQL 2005 SSIS; Crystal Report 11; Business Objects; ACCESS;
EXCEL & SQL Query.

Company Name: Confidential,Boston, MA. Date: Apr\'08 --> Jul’08
Tasks Accomplished:
1.Developing new initiative sophisticated Crystal Reports using charts; graphs; cross-tab;
subreports & etc. Also, very complicated SQL aggregated queries; functions;triggers.
Reports are for marketing analysis doing the current/forecast reports. Translating business
requirements into technical solutions using Crystal Reports/SQL/VB.
2.Tasks include designing, coding. analyzing, implementing & documenting.
3. Tools - Crystal Report 10; Business Objects; Crystal Enterprise; SQL 2000; SQL
2005 SSIS; Stored Procedures.

Company Name: Confidential,Canton, MA. Date: Dec\'07 --> Apr’08
Tasks Accomplished:
1.Developing complex Crystal Reports (Revenue Recognition Mgt System) using
charts; 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.
2. Tasks include analyzing business requirements; designing, coding, database coding/linkage
-- wrote multi-complicated Stored Procedues to select data for CR; implementation.
3. Tools - Crystal Report 10; SQL 2000; SQL 2005 SSIS; ORACLE; TOAD; Stored
Procedures; Business Objects.

Company Name: Confidential,Beverly, MA. Date: Jul\'07 --> Oct’07
Tasks Accomplished:
1. Developing over 50 Mercury Engineering Reports(MER) to inf’o 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.
2. Tasks include analyzing, meeting with users, designing, coding, testing & WEB designing.
Also preparing technical documents explaining the linkage of database & etc.
3. 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’07
Tasks Accomplished:
1. 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.
2. Tasks include programming, heavy analysizing, heavy debugging & reporting.
Preparing documents for the applications.
3. Tools - ASP, VB, PL/SQL, TOADS, JAVAscript, VBscripts, ACCESS, ASP debugger,
VB debugger.

Company Name: Confidential,CambrIdge MA. Date: Mar’07 --> Apr\'07
Tasks Accomplished:
1. Developed analytical reports for the sales & research groups using SQL & Crystal
Reports. Tasks include meeting with business users & IT analysts to iron out reports,
formulae, different graphics, table, cross-tab reports & etc. All completed successfully.
2. Tools - Crystal Report 10, ACCESS & VB.

Company Name: Confidential,Boston, MA. Date: Jan’07 --> Mar’07
Tasks Accomplished:
1. Developed/analyzed multi financial Reports using Oracle database &
Crystal Reports 10.
2. Tasks include designing, analyzing, coding, testing & implementing.

Company Name: Confidential, Boston, MA. Date: Aug’06 --> Dec’06
Tasks Accomplished:
1. Developed/Maintained the YSIS application which controls the underage criminals
in and out of the State Correction Facilities. YSIS is written in VB, HTML, DLL, IIS,
SQL/PLUS, UNIX, ACTUATE, CRYSTAL REPORTS, ACCESS & ORACLE.
2. Responsible for analyzing/coding/testing/implementing. Assisting in solving
problems, 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.
3. Tools - VB, HTML. DLL, IIS, SQL/PLUS, SQL, CRYSTAL REPORTS 9,
TOADS, Oracle & ACCESS.

Company Name: Confidential,Marlboro, MA. Date: Sep’05 --> Jun’06
Tasks Accomplished:
1. 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.
2. Responsible for designing/coding/testing/implementingsoftware;analyzing data
Requirements & proposing technical approaches. As project grows, wrote
technical documents to maintain thesoftware.
3. 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.
4. Tools - VB, Crystal Reports 9, SQL, ACCESS, VB.NET, XML, HTML,

Company Name: Confidential,Danvers, MA. Date: Jan’05 -->Jul’05
Tasks Accomplished:
1.Designing/developing Survey Assessment Application to collect/analyze employee
surveys & generating reports.
2.Developing Scanning Manufacturing Application to control inventory.
Involving whole cycle of both projects---from communicating with users to
implementing.
3.Overall tasks include meeting with users, system architecture, database
designing, coding testing & implementing.
4.Designing/generating Crystal Reports. Maintaining/supporting existing
Crystal Report Applications & utility applications.
5. 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’04 -->Nov’04
Tasks Accomplished:
1.Deisgning , testing, coding & implementing, converting main frame data into SQL
database. Coding in stored procedures, ACCESS, VB.
2. Tools - SQL, ACCESS, VB.NET & VB.

Company Name: Confidential,Coventry, R.I. Date: May’04 --> Aug’04
Tasks Accomplished:
1.Designing/developing 12 sales & inventory reports for the Sales Order Inventory
WEB sites using Crystal Reports, ORACLE & SQL. Also 50s subreports, cross-tabs,
charts & stored procedures. Allowing users to generate/distribute reports from the WEB
sites. Converting reports to EXCEL, XML & other formats as requested.
2.Tasks also include analyzing business requirements, creating stored procedures/
queries/triggers /views, data-extraction, testing, data verifications & etc. Meeting
with business groups to convert business logic into report logic/formulae.
3. Tools - SQL, ORACLE, Crystal Reports 8 with parameters, formulas, subreports,
cross-tab, graphs & charts, VB.
EDUCATION
B.S. in Mathematics & Economics