Sham Lakshminarayan
Austin, TX*8728
Mobile: 512-***-****
Email:abhxo7@r.postjobfree.com
SUMMARY:
. Good Crystal Reports experience, working in diverse application
environments. Extensive experience in performing Design, Architect,
Develop, Implement, Test, Document and user-Interaction.
. Strong technical and working knowledge with Crystal Enterprise
Administrator Launch pad, Crystal Management Console, Crystal
Configuration Manager, Crystal Migration Wizard, Crystal Publishing
Wizard and e-portfolio.
. Extensive experience in creating complicated well-formatted reports
embedding sub-reports, parameters, graphs, formulas, TOP/Bottom N
drill-down, Image overlay etc based on the requirements and technical
specifications.
. Created with Xcelsius advanced functionality to dashboards using
gauges, sliders, maps and "what if analysis".
. Experienced in XML, HTML, Visual SourceSafe, Web Services and e-
portfolio activities.
. Extensive experience in Oracle, SQL Server, DB2, writing SQL, Stored
Procedure, Triggers and data modeling.
. Created Crystal Reports with different data sources (Oracle, SQL
Server, DB2, Sybase, MS Access, and XML).
. Extensive experience in developing Technical Spec document, System
workflow diagrams using tools like MS-Visio.
AREAS OF EXPERTISE:
Platforms: WINDOWS 95/98, NT 4.0/ WIN2000, WINDOWS XP, WINDOWS VISTA
Business Intelligence: DATA WAREHOUSE, SYSTEM ANALYSIS, BUSINESS
ANALYSIS, PROJECT MANAGEMENT, BUSINESS OBJECTS/CRYSTAL
ENTERPRISE ADMINISTRATION, CRYSTAL REPORTS (5.5, 6, 7, 7.5,
8, 8.5, 9, 10, BOXI R2), BO EXCELSIUS, BRIO 6.5. /8.2,
MICROSOFT SQL SERVER REPORTING SERVICES, Created reports in
JD Edwards, Portal, People soft, Oracle Financials, SAP,
Remedy and custom environments.
Applications & Tools: VISUAL STUDIO.NET, VISUAL BASIC 5.0/6.0,
ORACLE 7.3/8/8i/9i/10G, ACCESS, DB2,IBM I SERIES S5R3,
DATABASE PROGRAMMING RDBMS, SQL, PL/SQL, SQL
6.5/7.0/2000,TSQL,,HTML, MS OFFICE 97/
2003.VISIO,TOAD,IIS, VISUAL SOURCE SAFE, Mercury Test
Director, Remedy, Sharepoint.
. Gathered requirements from users and created functional and technical
specifications.
. Created SQL queries, pl/sql procedures and Stored Procedures to
efficiently run the reports.
. Developed Crystal Reports 10.0, XI R2 using Access, DB2, Oracle, SQL
Server 2005 and Siebel databases.
. Reports designed were with parameter prompting, drill down structures,
and aggregation functions.
. Administered BO/Crystal enterprise.
. Implemented two projects using Brio Intelligence Suite.
. Implemented Business Object Enterprise XI scheduling, security.
. Hundreds of SQL queries, pl/sql procedures, indexes, Stored Procedures,
views, and functions were created.
. Have good experience in data analysis and read ERD diagrams.
. Hundreds of reports were created in different environments like
peoplesoft, JD Edwards, oracle financials, AS400, Remedy, SOX and
custom environments.
. Good Exposure to create Dashboards with Excelcius.
. Good knowledge to create report in Microsoft SQL Server Reporting
Services
. Created Business Views from stored procedures, sql queries etc.
. Migrated reports from earlier versions like v6.5/v7.5 to 8.5 /v10.
I created several reports to some major organizations like Willbros, Sound
Transit, Texas Mutual Insurance, XM Satellite Radio, Delta Dental, Nortel
Networks, Honeywell, Waste Management, I created standards for report
generation, methodologies. I have the ability to manage and coordinate
projects.