Summary
Overview
Work History
Education
Skills
Career Advancement And Professional Experience
Websites
Validation Number
Educational And Professional Training
Personal Information
References
Timeline
Generic

Shilpa Nikam

Plainsboro,NJ

Summary

Accomplished Senior Software Developer with extensive experience at Eagle Trading Systems, specializing in SQL Server and SSRS. Proven track record in optimizing report performance and enhancing data integrity. Strong analytical skills combined with effective collaboration with stakeholders to deliver impactful reporting solutions. Proficient in database management and documentation.

Overview

35
35
years of professional experience

Work History

Senior Software Developer

Eagle Trading Systems
Princeton, New Jersey
03.2007 - 07.2025
  • Developed a production database in SQL Server and created Crystal Reports to meet production needs until 2013.
  • I took training in the SSRS report suite.
  • Converted all CR reports into SSRS reports over a period of 1 year.
  • Developed reports using SQL Server Reporting Services for various business needs.
  • Collaborated with stakeholders to gather reporting requirements and specifications.
  • Designed and implemented data models to enhance report functionality and performance.
  • Conducted testing and validation of reports to ensure accuracy and reliability.
  • Optimized existing reports for improved loading times and user experience.
  • Maintained documentation for reporting processes, ensuring compliance with standards.
  • Troubleshot issues related to reports and resolved technical challenges efficiently.
  • Maintained data integrity while designing and developing new report structures in SSRS.
  • Designed, developed and maintained report models, data sources, datasets and report parameters in SSRS.
  • Involved in creating stored procedures and views for better performance of the reporting system.
  • Optimized existing SSRS reports by improving query performance and reducing execution time

Sr. Crystal reports Developer

Aetna
02.2006 - 02.2007
  • Company Overview: Active Health Management NYC. The requirement of Second Gen reports e.g., CareEngine Reports, HRA Reports, ICM Reports, etc are based on the various healthcare products used by Insurance Companies like Aetna, Anthem and its Providers, Patients, Doctors to improve the way healthcare information is used to help identify and manage medical conditions of a patient. This reporting system has been developed from the new Reporting Data mart and uses Business Object Enterprise platform for data, central repository and reports.
  • Responsible to work with business users to understand the requirements and providing end-to-solutions for reports and data analysis.
  • Responsible to create sample report, templates, views, and stored procedures.
  • Load the data used exclusively for Outer joins in the reports.
  • Design reports using various data sources as SP, Tables, and Command objects, various connections like ODBC, Oracle drivers and validate data.
  • Design complex reports using multiple sub reports, parameters, complex custom functions, evaluation time functions, Show/Hide sections of report based of type of output like Excel or PDF, Dynamic text based on the report input parameter.
  • Design Test Cases and work with Business Analysts to validate the reports.
  • Resolve the Test cases related issues in the report, data, performance etc.
  • Migrate report and related objects to Dev, QA and Production Server.
  • Maintenance of users, servers, securities on BOE.
  • Documentation of the report by creating user guide, training users, etc.
  • Active Health Management NYC. The requirement of Second Gen reports e.g., CareEngine Reports, HRA Reports, ICM Reports, etc are based on the various healthcare products used by Insurance Companies like Aetna, Anthem and its Providers, Patients, Doctors to improve the way healthcare information is used to help identify and manage medical conditions of a patient. This reporting system has been developed from the new Reporting Data mart and uses Business Object Enterprise platform for data, central repository and reports.
  • Technology used: - Windows 2000, Oracle 10g, SQL Server, Business Object Enterprise XI, Crystal Report XI, ETL Informatica, TOAD, Aqua, Mantis0.19.4, MS VSS 6.0.

Sr. Crystal reports Developer

Sharp Inc.
NJ
02.2005 - 02.2006
  • Company Overview: The requirement was to create a reporting portal to consolidate various existing reports using Excel sheets, other reports, and forms into one reporting system. The application used Crystal report XI and SQL server Database.
  • Translating business requirements into technical documentation.
  • Transform Data from various sources (DTS) to SQL Database Server.
  • Confirm the report output with existing reports and validate the data.
  • Schedule and publish the reports as per Business calendar on Business Objects Enterprise server.
  • Improve performance of report using Custom Functions and Grouping.
  • Documentation and training to employees.
  • The requirement was to create a reporting portal to consolidate various existing reports using Excel sheets, other reports, and forms into one reporting system. The application used Crystal report XI and SQL server Database.

Sr. Crystal reports Developer

Radix comp USA
NJ
03.2004 - 02.2005
  • Company Overview: The requirement was to migrating existing reports from COBOL to Crystal Report 10. It’s a web based reporting system for a small-scale business.
  • Reverse engineering on the system to design ER-diagram.
  • Extensive use of grouping, highlighting features used in the reports.
  • Create numerous complex formulas using report Syntax.
  • Performance tuning.
  • Schedule and publish the reports on Crystal Report Server.
  • The requirement was to migrating existing reports from COBOL to Crystal Report 10. It’s a web based reporting system for a small-scale business.

Java developer

Philips International
INDIA
10.1990 - 11.1999
  • Company Overview: PhilMail is an Intranet eCommerce application that holds Catalog information of various Clients and vendors.
  • Analyzed and documented the business requirements for the application.
  • Designed application and documentation of design Specifications.
  • Developed web pages, user interfaces, and server modules for the application using JSP, and HTML and Java class.
  • PhilMail is an Intranet eCommerce application that holds Catalog information of various Clients and vendors.

Education

Bachelor of Engineering - Electronics and Telecom

INDIA

Skills

  • Windows (NT, 2000/98/95)
  • Business Objects Enterprise
  • Crystal Reports XI
  • SQL
  • Transact-SQL
  • PL/SQL
  • Oracle 10g
  • Oracle 9
  • MSSQL Server 2022
  • Access
  • Microsoft Visual SourceSafe 60
  • ER WIN 40
  • TOAD
  • SQL navigator
  • MS Office
  • Informatica 50
  • DTS in SQL Server
  • JavaScript
  • HTML
  • IIS 60
  • ftp protocol
  • SQL Server
  • SSRS 2022
  • Stored procedures
  • Report optimization
  • Database management
  • Business analysis
  • Documentation skills

Career Advancement And Professional Experience

  • Aetna: - Active Health Management, New York, NY, Sr. Crystal reports Developer, 02/2006, Present, Responsible to work with business users to understand the requirements and providing end-to-solutions for reports and data analysis., Responsible to create sample report, templates, views, and stored procedures., Load the data used exclusively for Outer joins in the reports., Design reports using various data sources as SP, Tables, and Command objects, various connections like ODBC, Oracle drivers and validate data., Design complex reports using multiple sub reports, parameters, complex custom functions, evaluation time functions, Show/Hide sections of report based of type of output like Excel or PDF, Dynamic text based on the report input parameter., Design Test Cases and work with Business Analysts to validate the reports., Resolve the Test cases related issues in the report, data, performance etc., Migrate report and related objects to Dev, QA and Production Server., Maintenance of users, servers, securities on BOE., Documentation of the report by creating user guide, training users, etc., Windows 2000, Oracle 10g, SQL Server, Business Object Enterprise XI, Crystal Report XI, ETL Informatica, TOAD, Aqua, Mantis0.19.4, MS VSS 6.0
  • Sharp Inc., New Jersey, NJ, Sr. Crystal reports Developer, 02/2005, 02/2006, Translating business requirements into technical documentation., Transform Data from various sources (DTS) to SQL Database Server., Confirm the report output with existing reports and validate the data., Schedule and publish the reports as per Business calendar on Business Objects Enterprise server., Improve performance of report using Custom Functions and Grouping., Documentation and training to employees.
  • Radix comp USA, New Jersey, NJ, Sr. Crystal reports Developer, 03/2004, 02/2005, Reverse engineering on the system to design ER-diagram., Extensive use of grouping, highlighting features used in the reports., Create numerous complex formulas using report Syntax., Performance tuning., Schedule and publish the reports on Crystal Report Server.
  • Philips International, INDIA, Java developer, 10/1990, 11/1999, Analyzed and documented the business requirements for the application., Designed application and documentation of design Specifications., Developed web pages, user interfaces, and server modules for the application using JSP, and HTML and Java class.

Websites

Validation Number

1064943020

Educational And Professional Training

Bachelor of Engineering in Electronics and Telecom, INDIA, Crystal Report Certified Professional XI by Business Objects, Informatica (ETL tool), Business Intelligence and Data Warehouse Technology

Personal Information

Registration Number: 213370285

References

References available upon request.

Timeline

Senior Software Developer

Eagle Trading Systems
03.2007 - 07.2025

Sr. Crystal reports Developer

Aetna
02.2006 - 02.2007

Sr. Crystal reports Developer

Sharp Inc.
02.2005 - 02.2006

Sr. Crystal reports Developer

Radix comp USA
03.2004 - 02.2005

Java developer

Philips International
10.1990 - 11.1999

Bachelor of Engineering - Electronics and Telecom

Similar Profiles

CREATE PROFILE
Shilpa Nikam