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