Sql Server Crystal Reports
Resume:
B.I Analyst
AGASTIN DEVARAJ
Business Intelligence Analyst – H1B
Email : **************@*****.*** / Phone : (H)781-***-****,(M) 781-***-****
Summary:
• 8 years of experience in the development of Application Software Design and Development
using Crystal Reports / COGNOS/ BIRT/ SQL Reporting Services/ Microsoft Analysis Service.
• Experienced in the development and deployment of Reports for Retail, Healthcare
Manufacturing, and Software companies.
• Defined, designed & developed the use of Reports by blending the knowledge of the client
with the available technical know how.
• Sound Knowledge in the Analysis, Design, and Development of database systems using
Relational Database Management Systems.
• Experienced with multiple RDBMS including Oracle 8i/8.x/7.x, MS SQL Server
2005/2000/7.0/6.5, and associated SQL Dialects such as PL/SQL.
• Proficient experience of using Crystal Publishing Wizard and Crystal Management Console for
publishing reports on the company’s Intranet. Scheduled Reports using e Portfolio and
Management Console.
• Excellent ability in writing specifications and gathering requirements from the user and
developing Reports as per the needs of the client. Maintaining proper documentation of the
reports for future reference.
• Strong interpersonal skills, with demonstrable verbal and written communications to maintain
effective work relationships with all levels of personnel.
• Capable of working as an individual as well as a part of team.
Computer Knowledge:
Reporting Tools: Cognos, BIRT, Crystal Reports 8.5/9.0,10,XI, Crystal Enterprise8.0/9.0, and Cognos
RDBMS: MS SQL Server 6.0/6.5/7.0/2000/2005, Oracle7.x/8/8i, MS Access2000, MYSQL
Web Technologies: Java, VB.NET, ASP.NET
ERP: PeopleSoft, SAP
Languages: SQL, SQL*Plus, T SQL C, C++, Pascal, Fortran, Java, Visual Basic 5/6.0
Web Technologies: HTML, XML, JSP, TOAD, Macromedia Dreamweaver, MS FrontPage, Java Script
Operating Systems: Windows NT, MS Windows 200/98, Windows XP, MS DOS, UNIX
PERSONAL SKILLS
B.I Analyst
Comprehensive problem solving abilities, high grasping power in learning new things, excellent verbal
and written communication skills, ability to deal with people diplomatically, willingness to learn, team
facilitator and hard worker.
P a g e 1
Professional Experience:
Trinity Pharma Solutions, Waltham, MA 01/08 to Present
Business Intelligence Developer
Responsibilities:
• Understand clients’ business needs and translate those needs into actionable tasks;
• Generate complex reports for clients;
• Lead client change management process with the support of assigned Associate
Business/Operational Analysts
• Guide assigned Associate Business/Operational Analysts by providing mentor ship and ensuring
their development/growth.
• Develop and maintain process flow, report generation and other client related documentation;
• Escalate complex client inquiries and issues to senior level Business/Operational Analysts;
• Complete other related ad hoc projects and assigned tasks.
• Provide subject matter expertise and guidance to less experienced staff members
• Documentation of specifications for new reports and changes to existing reports
• Work collaboratively and independently with the business groups to create operational reports
and the tools to automate their delivery
• Communicate with report owners to ensure that all reporting requirements and specifications
are met and documented
• Analyze data reporting requirements of various business units and create reports and
processes to support those requirements
Sunray Infosys Inc, Princeton, NJ 01/07 to 01/08
Programmer Analyst
Responsibilities:
• Gathered user requirements, drafted specifications, and designed, deployed, and documented
reports using Cognos
• Involved in the creation of Cross Tab Reports and Sub Reports
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie
Charts etc
• Involved in the implementation and maintenance of Info Server, Info Desktop on Windows NT
operating system.
• Developed several Complex Reports (various features used include multiple groupings,
drilldowns, parameter fields, formulas and conditional formatting)
Environment: Cognos, BIRT 2.2, Business Objects XI, .NET, MS SQL Server 2005, Oracle 10g
B.I Analyst
P a g e 2
Authoria Inc, Waltham, MA 11/06 – 12/06
Reports Developer
Responsibilities:
• Developed Reports in Cognos, SQL Reporting Services
• Actively involved in gathering end user requirements, user/system documentation, user
training, and testing of crystal reports for final deployment. Interacted directly with the user for
getting specs, draft specs, and generated new reports according to the specs and gave it to the
user for verification.Created Cubes
• Tested the developed crystal reports and created test cases for the testing team.
• Involved in transformation of the existing Crystal Reports to meet user requirements.
• Applied heavy formatting for reports and developed reports with essential Formulas and
Parameter fields.
Environment: Cognos, Crystal Reports 10, Microsoft Analysis Services, SQL Server 2005, Windows 2000
Heart Lab Inc, Westerly, RI 07/06 – 10/06
Reports Developer
Responsibilities:
• Developed Reports in SAP BI.
• Embedded the Reports in C#.net
• Actively involved in gathering end user requirements, user/system documentation, user
training, and testing of crystal reports for final deployment. Interacted directly with the user for
getting specs, draft specs, and generated new reports according to the specs and gave it to the
user for verification.
• Designed, Embedded SQL in Microsoft SQL Server 2000 to be deployed in the reports for better
performance.
• Created and Documented Crystal Reports Standard used in this application.
• Tested the developed crystal reports and created test cases for the testing team.
• Involved in transformation of the existing Crystal Reports to meet user requirements.
• Applied heavy formatting for reports and developed reports with essential Formulas and
Parameter fields.
Environment: Cognos, Crystal Reports 11, C#.net, SQL Server 2000, Windows 2000
Fresenius Medical Care, Lexington, MA 11/05 – 06/06
Data Analyst
Responsibilities:
• Developed Reports in Crystal Reports10.0 for Soarian Financials and Soarian Clinical Health
Care System.
• Involved in transformation of the existing Crystal Reports to meet user requirements.
B.I Analyst
• Applied formatting for reports and developed reports with essential Formulas and Parameter
fields.
Environment: Crystal Reports 10, SQL Server 2000, Windows 2000, Soarian Financials and Soarian
Clinical
P a g e 3
Emhart Glass, Enfield, CT 07/05 – 10/05
Crystal Reports Developer
Responsibilities:
• Developed Crystal Reports XI to address diverse levels of the organizational requirements
ranging from Individual employees to a complete line of operations.
• Actively involved in gathering end user requirements, user/system documentation, user
training, and testing of crystal reports for final deployment. Interacted directly with the user for
getting specs, draft specs, and generated new reports according to the specs and gave it to the
user for verification.
• Developed Cross Tab Reports, Sub Reports, and Parameter Reports by using Crystal Reports
versions XI.
• Tested the developed crystal reports and created test cases for the testing team.
• Involved in transformation of the existing Crystal Reports to meet user requirements.
• Developed PIE and BAR Charts with Drill down option using Drill down Report Expert.
• Applied heavy formatting for reports and developed reports with essential Formulas and
Parameter fields.
• Involved in inclusion of linked as well as unlinked Sub Reports along with the primary reports.
• Involved in Architectural decision making process and assisted other programmers in coding as
well as for other problems that were raised during the development process.
Environment: Crystal Reports XI, SQL Server 2000, and Windows 2000.
Sprint, Kansas 01/05 06/05
Crystal Reports Developer
Responsibilities:
• Developed Crystal Reports10.0 to address diverse levels of the organizational requirements
ranging from Individual employees to a complete line of operations.
• Actively involved in gathering end user requirements, user/system documentation, user
training, and testing of crystal reports for final deployment. Interacted directly with the user for
getting specs, draft specs, and generated new reports according to the specs and gave it to the
user for verification.
• Deployed Reports on web by using components of Crystal Enterprise.
• Designed around 50 60 Views /Stored Procedures in Microsoft SQL Server 2000 to be deployed
in the reports for better performance. Used these Procedures and Views in numerous reports.
• Developed Cross Tab Reports, Sub Reports, and Parameter Reports by using Crystal Reports
versions 9/8.5.
• Tested the developed crystal reports and created test cases for the testing team.
• Involved in transformation of the existing Crystal Reports to meet user requirements.
B.I Analyst
• Created numerous Alerts that are executed based upon certain conditions
• Developed PIE and BAR Charts with Drill down option using Drill down Report Expert.
• Fixed bugs and enhanced existing reports. Converted reports that were created in earlier
versions to Crystal Reports 8.5/9.0 with appropriate change.
P a g e 4
• Applied heavy formatting for reports and developed reports with essential Formulas and
Parameter fields.
• Involved in inclusion of linked as well as unlinked Sub Reports along with the primary reports.
• Documented all the procedures and views that were formed in SQL Server 2000.
• Involved in Architectural decision making process and assisted other programmers in coding as
well as for other problems that were raised during the development process.
Environment: Crystal Reports 10/9.0/8.5, Crystal Enterprise 9.0, Seagate Info 7.0, SQL Server 2000, T
SQL, MS Access 2000/Reports, Windows NT, Windows 2000.
St.Jude’s Computer Research Institute, India 03/03 to 12/04
Developer
Responsibilities:
• Involved in the execution of Reports on Crystal Enterprise 8.0 & Crystal Reports 8.5 on
Windows NT 4.0 Operating System and Oracle 8i database.
• Deployed Reports on web by using components of Crystal Enterprise.
• Developed Production reports using Crystal Reports 8.5. Developed various report formats
including Sub Reports, Cross Tab Reports, OLAP Reports and Standard Reports
• Customized the Crystal Enterprise 8’s ePortfolio to suit the company’s requirement.
• Developed reports using Seagate Crystal 8.5 which could be accessed from the Visual Basic 6.0
application. Customized various Reports after the upgrade process.
• Used TOAD and SQL*Plus for writing the Stored procedures, Views, Functions in Oracle as the
client.
• Developed OLAP reports from the Oracle8i database.
• Developed Graphic Reports, Pie charts for the statistical representation of the data
• Worked with Seagate Analysis tool for analysis of ad hoc queries and Reports.
• Designed and developed custom Reporting solutions and Re Engineering solutions to enhance
existing frameworks to work with newer technologies.
• Involved in recruiting and mentoring offshore team and Training Users.
Environment: Cognos, Crystal Decisions Crystal Reports 8.5, Crystal Enterprise 8.0, HTML, TOAD7.2,
Oracle 8i, SQL*Plus, Windows NT, Crystal Query.
JMA Private Limited, Singapore 02/01 to 06/02
Reports Developer
Responsibilities:
• Gathered user requirements, drafted specifications, and designed, deployed, and documented
reports using Crystal Reports Designer, Crystal Query.
B.I Analyst
• Involved in the creation of Cross Tab Reports and Sub Reports using Crystal Report Designer in
Seagate Info Version 7 environment.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie
Charts etc by using Chart expert of Crystal Reports.
P a g e 5
• Involved in the implementation and maintenance of Info Server, Info Desktop on Windows NT
operating system.
• Created Tables, Views, Stored Procedures, and Queries to meet the reporting needs by using
SQL Server 7.0, SQL Server 6.5, and MS Access.
• Worked with Info Administrator for creating Users, User Groups, assigning rights, roles etc.
• Developed several Complex Reports (various features used include multiple groupings,
drilldowns, parameter fields, formulas and conditional formatting) using Crystal Reports.
Environment: Crystal Reports8.0, MS SQL Server 7.0, Windows NT, Seagate Info 7.0, and Crystal Query
Education:
Master Degree in Computer Science, Madras University, India
Advanced Certification in Information Technology, SSI
Trained by Siemens (Philadelphia) for Developing Soarian Financials Reports
Trained by Siemens (Philadelphia) for Developing Soarian Clinical Reports
B.I Analyst
P a g e 6
Contact this candidate