|
|
Title: |
Business Intelligence Software Developer
|
Location: |
US-Virginia-Fairfax
|
Work History: |
TSymmetry, Arlington, Virginia May 2008 - Dec 2008
Consultant at Department of Homeland Security
Creating new reports using Business Objects Web Intelligence and Crystal Reports. Designing and creating new Business Objects Universes. Accessing data in an Oracle database and also using web services as a data source. Deploying the reports to Business Objects Enterprise 3.0 CMC and Infoview. Updating the requirements, design and test documents for these reports. Moving the reports using the Import wizard between different Business Objects installations. Creating subreports, complex formulas, parameters, totals and cascading prompts for these reports.
Skechers, Manhattan Beach, California Sept 2007 - Oct 2007
Crystal Reports Specialist
Creating new reports using Crystal Reports and SQL from a Microsoft SQL Server Database. Cleaning up the database by writing SQL update queries and scripts using temporary tables and cursors. Reports are primarily for Spending Approvals. Installing Crystal Reports Server and deploying reports to Crystal Infoview. Administering the Crystal Reports Server using the Central Management Console.
Kaiser Permanente, Pasadena, California July 2007 - August 2007
Software Consultant
Creating reports using Crystal Reports and SQL from a Clarity database. Reports are primarily for operating rooms in different Kaiser Medical Center Areas and locations in Southern California. Writing SQL queries and Crystal Reports that help manage surgeons and operating room data. Worked in the MIA ( Management Information and Analysis ) group.
AIDS Healthcare Foundation., Los Angeles, California May 2007 - June2007
Data Analyst
Working in the Managed Care department. Using Microsoft SQL Server Enterprise Manager and Query Analyzer to write SQL queries and T-SQL stored procedures. Creating reports using Microsoft Access front end. Working with provider, claims and other healthcare data.
Application Objects Inc. Feb 2007 - Mar 2007
Crystal Reports Developer
Creating reports for Dell Computer and its OEMs. Data is in a Foxpro database. Downloaded the database to home computer and am creating Crystal Reports as per report specifications. Creating complex formulas, custom subtotals, subreports etc
. Writing SQL queries. Using inner and outer joins to join the tables. This is a telecommuting job.
Kaiser Permanente, Pasadena, California Oct 2006 - Dec 2006
Crystal Reports Developer
Optimizing existing Crystal Reports to make them run faster. Changed formulas and added WHERE clauses to SQL to significantly improve run times. Created views in the DB2 database. The backend database is IBM DB2. Ported the reports from Crystal Reports 9.0 to Crystal Reports XI. Deploying the reports to Crystal Enterprise.
McManus Consulting, Los Angeles California Nov 2005 - Sept 2006
Crystal Reports Consultant
Modifying Crystal Reports for the MTA ( Metropolitan Transit Authority ) of Los Angeles. This was a telecommuting job.
Modifying Crystal reports for Sony Pictures Entertainment. Modifying existing SQL queries. Coming up with innovative solutions to handle new requirements like international timezones, fixing high priority defects in the reports and making changes to the reports according to specifications. Data is stored in an SQL Server database. Modifying SQL queries. Learning WebIntelligence Reports. This is a telecommuting job.
Application Objects Inc. Jan 2006 - Feb 2006 This job was done concurrently with work for McManus Consulting
Crystal Reports Developer
Creating Crystal Reports for DELL Computer and its OEMs. This was a telecommuting job done for Application Objects. Data was in an Oracle database. The reports were created using Crystal Reports XI and deployed using Crystal Enterprise XI. Writing SQL queries to access the data in the database
Trader Joes Inc., Monrovia, California Jun 2005 - Oct 2005
Software Developer
Retail Company.
Created reports for the accounting and operations departments using Crystal Reports. These reports access data in an Oracle database and were used for auditing, merchandise valuation, inventory, stock synchronization etc
The reports were deployed using a custom web application. Worked on the Store Order Guide report using Java and JasperReports. Created a scheduler using Oracle PL/SQL to automatically run reports at predefined intervals and keep a history of report data. Modified the Visual Basic front end for reports to upgrade it from Crystal Reports 8.5 to Crystal Reports 9.0. Modifying existing SQL queries to extract data from the Oracle database.
TXU/Cap Gemini, Dallas, Texas Mar 2005 - Apr 2005
Software Developer
Retail Company
Modified existing reports to enable the export to Excel to work properly. Ran daily reports and put them on the internal website. Added new features and columns to existing reports. Reports ran off of an Microsoft Access database. This database was populated with data regarding the calls coming into the call center.
Neiman Marcus,Inc. Dallas, Texas Feb 2005 - Mar 2005
Crystal Reports Consultant
Retail Company
Created reports using Crystal Reports ( version 10 ) for the Warehouse Management System. The reports calculated remake time, backlog, days above standard, cases to be processed and other statistics. Some of the reports also displayed information concerning the flow of products through receiving, processing, shipping etc
Wrote complex formulas and did custom programming in Crystal Syntax language.Some of the reports also used subreports. The backend database was Oracle. Wrote SQL queries to extract data.
RealPage,Inc. Dallas, Texas Feb 2004 - Feb 2005
Crystal Reports Developer
Software Development Company.
Created reports using Crystal Reports ( version 8.5 and 9.0 ) for the Leasing, Rents and Prospect Management parts of the RealPage software product. The RealPage product is for multi-family communities ( apartment complexes ). The reports were web based and deployed using Crystal Enterprise 8.0. Created new reports and modified existing reports. The backend database is SQLServer. The data is extracted from the database using stored procedures. Created and modified ASP pages that collect report parameters and pass them to the scheduler. Wrote T-SQL queries to get data from the database. Created SQLServer stored procedures and optimized existing stored procedures.
Salion, Austin, Texas Jun 2003 - December 2003
Crystal Reports Consultant
Software Development Company.
Created reports using Crystal Reports ( version 8.5 ) for the Salion Knowledge Manager and Salion Revenue Process Manager. Fixed high priority ( Priority 1 and Priority 2 ) bugs in existing reports ) . Created custom reports for customers of Salion including Delphi and Dura. The backend database was Oracle 8i. Reports were deployed using Crystal Enterprise 8.0. Used custom Java and XML to collect report parameters.
Hire.com, Austin, Texas Aug 2002 - May 2003
Crystal Reports Consultant
Software Development Company.
Created reports using Crystal Reports ( version 8.5 ) for the Recruiting Center, Hiring Center, Reporting Center and HireAnalytics products. The data was stored in a MS SQLServer database. Wrote SQL queries to get the data from the database. Created custom alerts, drill-down, subreports and graphical reports. Created custom reports for clients of Hire.com including Qwest, H&R Block and Harris. Wrote T-SQL queries to get data from the SQL Server database. Also worked on an Oracle database.
ELOYALTY, Austin, Texas July 2000 - July 2001
Software Engineer
Software development company specializing in customer relationship management.
Created web-based reports using Crystal Reports ( versions 8 and 8.5 ) for the ELoyalty Lab. Created drill-down, cross-tab, graphical and subreports. Connected to the data in an Oracle database using both ODBC and Oracle native connections. Created a total of 30 reports of different types. Created a website so that the reports ( .rpt files ) could be viewed in a browser using a plug-in from Seagate. Set up the Seagate Page Server and Microsoft IIS for this website.
Created reports for American Express ( client of ELoyalty ) also using Crystal Reports. These reports aggregated and displayed call center data regarding calls coming in from cardmembers. There were a total of 20 reports created for this client.
Initiated and wrote a program using Java JBuilder, Java SWING and JDBC to generate data that was inserted into an Oracle database.
Wrote SQL queries to manipulate the data in the database.
Installed the LOM (Loyalty Outcome Manager) software at a number of client sites throughout the United States. The LOM is a Java application that transfers data between Repository and Warehouse Oracle databases.
Successfully worked with developers to solve a number of Java programming problems using EJB, Servlets and WebLogic.
Created web-based reports using WebFocus for AllState Insurance.
.
COMPUTER SCIENCES CORPORATION ( CSC ), Austin, Texas Apr 1999 - Jun 1999
Consultant at IBM
Created a Java applet to display IBM RS6000 reliability reports that were stored in a database.
Programmed in Java and HTML for the front end and interacted with the DB2 database at the backend.
Used the Java AWT ( Abstract Windowing Toolkit ) and JDBC ( Java Database Connectivity ).
FundsXpress, Austin, Texas Feb 1999 - Mar 1999
Consultant
Doing testing of web sites created for various small banks.
Doing automated testing using SILK.
Marlabs, Austin, Texas Nov 1998 - Jan 1998
Consultant
Doing testing of web based Java applications.
Learning HTML and modifying HTML based website.
Internal Revenue Service, Austin, Texas Sept 1998 - Oct 1998
Consultant
Doing testing of the STARS system.
Created a bug tracking system in Microsoft Access.
SMART TECHNOLOGIES, INC., Austin, Texas Dec 1997 Aug 1998
Software Engineer
Performed Quality Assurance of web applications using the SILK and WebLoad automated test tools.
Wrote tests and ran them on Windows NT platforms
Learnt to program in JAVA and HTML.
Built a web site for Motorola.
Attended a class on SILK automated test tool.
.
TATA Consultancy Services, Pune, India Feb 1997 - May 1997
Software Engineer
Worked in the TRDDC ( Tata Research Design and Development Center ) division
Group I worked in was the artificial intelligence group.
Project was creating an expert systems for helpdesk software.
Front end was a PowerBuilder user interface.
Gave a presentation on Expert Systems for VLSI design which was based on my undergraduate thesis..
LUCENT TECHNOLOGIES, Murray Hill, New Jersey July 1996 - Sept 1996
Consultant
Directly responsible for setting up an Oracle database and tables for the Stonehenge project.
Creating and populating Oracle tables.
Created a database in Microsoft Access that stored all the data required for generating telecommunications bills.
Created the schema and tables for the database. Ran shell scripts and modified them to generate telecommunications bills.
Sheilds Enterprises Inc., New York, New York Apr 1994 - Aug 1994
Consultant at Unilever,Inc
Wrote PowerBuilder scripts, C and SQL for the marketing and financial planning system for Lever Brothers.
Wrote scripts and designed screens for displaying and updating data, SQL queries for accessing the Oracle database, and C programs for formatting the data and generating the remote procedure calls required by the OEC distributed systems toolkit. Hardware was IBM RS6000/AIX and IBMPCs.
Network Programs Inc., New York, New York Aug 1993 - Mar 1994
Consultant at Unilever,Inc
Did a telecommunications billing project using Visual Basic.
Purchased and installed SUN computers.
Did a project in which I had to collect and integrate code of different programmers for a distributed software development environment..
AT&T, Columbus, Ohio Jan 1991 - May 1993
Consultant
Created a service creation environment on NeXT workstations. Programmed in Objective-C and UNIX. Used the UNIX utilities lex and yacc extensively. Created an interpreter for a template language that was specialized for creating telecommunications services. Software ran on NeXT workstations running UNIX 4.3 BSD. Wrote automated tests using the BUSTER test tool and C shell for the BaseWorX applications development environment.
Wrote rules in C5 and scripts in C shell for the auditor and configuration generator parts of BaseWorX. Used the Sable system for source code management.
Coded and tested on SUN, HP and NCR workstations.
SOFTWARE INTERFACES, INC., Houston, Texas Feb 1990 - Nov 1990
Software Engineer
Created a reportwriter for SQLAssist which is a graphical query building system that allows users to create a query using menus.
Wrote C, lex and yacc code for creating a WYSIWYG reportwriter.
System interfaced with an event driven windowing system and an API that could connect to databases like Oracle, Ingres, RdB. Software ran on VAX machines.
|
Skills: |
Highly skilled, US Citizen, software professional offering 15 years experience in the software industry. Excellent command of Crystal Reports (versions 8,8.5,9,10,XI), Business Objects Enterprise, Web Intelligence reports, Business Objects Universe creation , SQL , T-SQL, ( queries, views , stored procedures, cursors, triggers), Oracle ( PL/SQL), Microsoft SQL Server, Crystal Enterprise, FoxPro, ASP, WebFocus ( reporting tool ), Java, Java SWING, Jasper Reports ( Java reporting tool ),AWT, JDBC, JBuilder, HTML, Windows, C and UNIX ( 4.3 BSD, SunOS, HP-UX ). I am experienced in all aspects of designing, creating, deploying and maintaining Business Intelligence reports using a variety of reporting tools and databases.
|
Education: |
M.S. - Computer and Information Sciences, Dec 1989, University of Delaware, Newark, Delaware
G.P.A. 4.0/4.0
B.Tech - Computer Science and Engineering, May 1988, Indian Institute of Technology, Bombay, India
G.P.A. 8.3/10
|
Endorsements
|
 |
Rajesh has received 1 endorsement.
|
Rajesh has endorsed 0 Members.
|
|
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
1.001 |
Experianced Computer Tech and Web Developer |
US-California-San Bernardino/Palm Springs |
 |
Details
|
|
|
|
|
Public Messages
|
|
| From |
Date |
Message |
 |
06.06.11 |
[This message has been removed by ITsaNetwork because it contained inappropriate content.] |
|
|
