Consultant ID: SCR1                                        Get me Complete Resume

SUMMARY

ELEVEN years plus professional experience in Software System Design, Development, Testing and Implementation of Client/Server applications using databases as SQL-Server 2000, Oracle 10g and reporting tools as Crystal Reports XI and their earlier versions.

• Generated reports using Crystal Reports. The report included sub-reports, passed parameters, drill downs, cross tabs, sorting and grouping data, formulas and record select conditions depending upon selection criteria.
• Work done in Crystal Reports include
  • Build reports using report wizard. Or starting with a blank report and customise the report later in design. Modified reports in stand alone and preview mode.
  • Adding and deleting objects, sizing objects and sections working with guidelines. Managed sections by controlling visibility of sections in a report by hiding or suppressing sections. Kept section together or splitting sections as per the situation.
  • Creating summary reports and drill down. Implemented summary operations of grand totals, subtotals and other summary fields as minimum, maximum, average etc. Declaring variables and creating running totals with variables.
  • Ordered the display of records on a crystal report by sorting or grouping. Sorting groups. Did selection of top and bottom groups.
  • Did record selection using select Expert and edited the select formula directly. Did group selection. Adding parameters to the report and use it in selection criteria.
  • Did adding, editing and deletion of formulas with operators and punctuations in formula.
  • Used visual effects as adding lines and boxes. Adding borders to objects.
  • Setting specified order for grouping. And creating multi-value groups. Including "Others" group.
  • Building linked and unlinked sub-reports. Building cross-tab reports to show data in grid.
  • Worked with Crystal Analysis Pro and Crystal Management Console of Crystal Enterprise.
  • Exporting to spreadsheets as Excel, Word or CSV files.
  • Launching reports from Visual Basic. Passing parameters, using selection formulas through Visual Basic.
• Work done in Crystal Enterprise include
  • Setup of Crystal Enterprise Framework including the setup of Crystal Report Server. Setup of group and users. Setup of the user authentication for the user.
  • Setup of the folder structure. Publishing of the reports and other objects on CMC. Scheduling of the reports for execution and their distribution by Emails in PDF format.
  • Extensive worked on both Crystal Management Console (CMC) and Crystal Enterprise and their launch pad. Helped in purchase of user licence.
• Two years of experience in Win-Forms and Web-Forms using Visual Basic.NET and ASP.NET using ADO.NET to connect to the database.
• Eight years experience in MS SQL-Server 2000 (T-SQL) database design and development in writing Constraints, Indexes (Clustered and Non-Clustered), Views, Stored Procedures, Extended Stored Procedures, Cursors, Triggers, User Defined Functions, Database Backup and Recovery.
• Three years experience using PL/SQL working in Oracle 8i and 10g. Worked with SQL Developer, SQL*Plus and TOAD. Write function, procedures and packages in PL/SQL. Used TOAD to modify and create procedures.
• Involved in Unit testing, Peer testing and Integration testing of system interfaces.
• Very good analytical and teamwork skills.
• Excellent communication and interpersonal skills.
• Experience in Banking, Finance, Credit Cards, Entertainment Industry, Material Management and Real time systems