OBJECTIVE:

Seeking a challenging job as a Datawarehouse developer that will utilize my technical skills and professional experience.

PROFESSIONAL SUMMARY:

• A IT Professional with over Ten years of experience as an application developer in Software products involving Requirements, Analysis, Specification, Design, Development, Conversions, Installations, Maintenance, etc.
• Experienced in implementing reporting, datawarehouse and decision support applications. Experience in Business Analysis, Reporting using Crystal Reports, Crystal Enterprise, Business Objects Enterprise, Web Intelligence, Xcelsius, QAAWS, Voyager, MS Access, Oracle, SQL, PL/SQL, SQL Server, T - SQL, Sybase, Remedy, PeopleSoft etc.
• Experienced with Business Objects/Crystal Enterprise Servers - Setups, Configurations, Installations, and Migrations. Integrated authentication and authorization using LDAP, Windows AD, and Windows NT security models.
• Working experience in Business Objects Products like Universe Designer, Web Intelligence, Ad Hoc reporting, System Usage Monitoring, Central Management Console, Configuration Manager, Repository, Migration Wizard, Publishing Wizard, InfoView.
• Experienced in database modeling using different tools like Erwin, MS Visio, Rational Rose.
• Strong knowledge of relational database and data warehousing concepts. Experience in creating Databases Tables - Views, Stored Procedures and Triggers using SQL, T-SQL and PL/SQL.
• Experienced in conducting design sessions to evolve system specifications and test plans with the ability to handle sessions and documentation.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role.

TECHNICAL SKILLS:

Operating Systems: Windows 7/2008/2003/XP/00/98/95/NT, MS DOS, UNIX.

Languages: HTML, XML, Java Script, VB Script, Java, SQL, PL/SQL, T-SQL

GUI Tools: VB.NET, Visual Basic 6.0/5.0

Databases: Oracle 11.g/10.g/9.i/8.i/7.x, MS SQL Server 2005/2000/7.0 . , 2008 Sybase, MS Access, Remedy 7.0/5.5.

Reporting Tools: Crystal Reports 2011/2008/XI/ 10.0/9.0/8.0 /7.0/6.0 , Business Objects XI R4, R3, R2, R1/6.x, Designer, Web Intelligence (Web I), Crystal Enterprise 10.0/9.0/8.0 , Xcelsius 2008, Voyager, Seagate Info 7.0, Data Reports, R & R report writer, MS Access, MS Excel.

Other Software: IIS, Websphere, Weblogic, ERWIN, MS Visio, TOAD, SQL Loader, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Germantown, MD

Quality Reports Developer/ Analyst

Responsibilities:

• Work with the end users and the higher management to define the requirements. Review the requirements and convert them into design specifications.
• Work with higher management to implement new processes for the creation of Quality Metrics Reports. Create supporting documentation for implementation of Quality Metrics Reports.
• Work closely and cooperate with the end users, delivery group to deliver reports, and ensure designs and development of data usage is maximized
• Worked with internal business customers and IT team members to analyze, design, create and maintain targeted reporting solutions required to support business processes and goals.
• Designed Crystal Reports which included standard reports, cross-tab, summary reports according to the requirements.
• Used SQL to test reports. Also provide data set to the end users according to the requirements.
• Worked with Business Objects Designer for Universe development; developed Web Intelligence and Crystal Reports for reporting needs.
• Used Business Objects Console related to publishing reports, scheduling reports.

Environment: Windows 7.0, Peoplesoft CRM, Oracle 11g, SQL Server 2005, Crystal Reports 2008, Business Object Enterprise XI R3, SQL Developer, Tora, Excel, Power Point, Share Point

Confidential, Arlington, VA

Developer/ Analyst

Responsibilities:

• Work and cooperate with the end users, delivery group to deliver reports, and ensure designs and development of data usage.
• Designed and developed Crystal Reports using XML file and Stored Procedures, according to the requirements. Used complex formulae, conditional formatting, sub reports, parameters with drill-down capabilities.

Environment: Windows 7.0, Crystal Reports 2008, SQL Server 2008, XML Marker 2.1, Sophis 4.3.1, Tamale RMS 6.1, Oracle 11.g.

Confidential, Rockville, MD

PX Reporting Developer/ Analyst

Responsibilities:

• Work with the end users and the higher management to define the requirements. Review the requirements and convert them into design specifications.
• Work closely and cooperate with the end users, delivery group to deliver reports, and ensure designs and development of data usage is maximized
• Conducted user sessions and supported them with new requests, enhancements, and modifications.
• Designed and developed Crystal Reports, according to the requirements. Used complex formulae, conditional formatting, sub reports, parameters with drill-down capabilities.
• Used Central Management Console to perform administrative tasks related to user groups, accounts, report publishing, folder management etc.
• Developed complex SQL queries for the report command objects.
• Performed data analysis by writing complex SQL queries on various source systems and data warehouse to find trends and anomalies in the data to support the requirements.

Environment: Windows 7.0/2003, Crystal Reports 2008, Business Objects XI R 3, Oracle 11.g, MS SQL Server 2005/2008, SQL Developer.

Confidential, Hendon, VA

Infrastructure Team Developer/Administrator

Responsibilities:

• Worked with higher management to gather requirements and design Crystal Reports, Web Intelligence Documents, Universe on Oracle, Sybase, SQL Server, Remedy, Clear Quest, Buisness Objects Audit data.
• Developed the Remedy ticket status, Trend reports, Incident, Problem aging reports for the higher management according to the requirements.
• Developed the Business Objects Usage reports, User Activity reports for SOX auditing.
• Created Xcelsius dashboards using Query As Web Serivce(QAAWS) and Live Office.
• Setup guidelines and standards for development of Reports to improve quality and consistency of the reports across various environments. Provide technical support and guidance for the development of reports, universes, etc. Reviewed the developed Crystal Reports and provide feedback on best practices and standards to the users.
• Worked as Business Objects Administrator responsible for designing, developing, testing, debugging and maintaining reports, dashboards and universes to support business needs.
• Install, configure, and maintain the Business Objects environment, including universes, reports, Crystal Reports, Dashboards, Xcelsius and other specific deliverables on Windows and Unix environments. Worked on setting up Business Objects Security Model. Worked on BOE clustering and load balancing.
• Support business users and the SAP functional team members in the creation of Desktop/Web Intelligence, Crystal Reports, and Xcelsius dashboards.
• Provide support for end users issues and questions on Business Objects and Crystal Reports.
• Responsible for closing out Business Objects related IT tickets in a timely manner that includes troubleshooting report issues and research data quality problems.
• Identify potential migration, patches, fix patches, and any other server related upgrades.
• Created and worked on Row level security, Object level security and various predefined security settings depending upon users and group needs using CMC.
• Published reports to Business Objects Servers in various environments. Migrated Crystal Reports, Universes and Webi documents from one environment to another using Business Objects Import Wizard, Client Tool. Worked on BOXI Data Integrator migrations.
• Worked with Business Objects CMC & CCM to manage Content and Servers.
• Worked as an administrator on Business Objects Servers/ Crystal Enterprise. Respond quickly to Crystal reports issues, Webi, Business Objects Servers issues which emerge in different Systems and environment.
• Work with the end users, team members to coordinate the migration of Reports to different environments. Work with different team members to resolve conflicts, look into server problems, and escalate issues. Provide status reports to the higher management.
• Worked on certifying Crystal Reports 2008, Xcelsius 2008 to provide the tools and support to the customers.
• Tested and certified the BARDT tool which is used BOXI automated migrations.
• Provided 24 X 7 support for the Business Objects/Crystal reports servers as needed.

Environment: Windows 200/XP, Unix, Crystal Reports 2008/XI R2,R1/9.0, Business Objects XI R3.1/R2/R1, Crystal Enterprise 9.0, Oracle 10.g, Sybase, SQL, PL/SQL, Weblogic 8.x, IPlanet, Tomcat, BO Universes, Webi, Infoview, Business Views, Xcelsius 2008, Voyager, QAAWS, Live Office, Data Integrator, Remedy 7/5.5.

Confidential, Herndon, VA

Orders Tracking Reports Developer/Analyst

Responsibilities:

• Worked with the end users and higher management to gather requirements for reports and data analysis. Conducted user sessions. Supported end users with new report requests, enhancements and modifications.
• Designed and developed Crystal Reports, which included standard reports, cross-tab, summary reports according to the requirements. Reports developed contained Crystal Formulae, SQL Expressions, Selection Criteria, and Sub Reports etc.
• Used Crystal Management Console/Seagate Info to perform administrative tasks related to user groups, accounts, report publishing, folder management etc.
• Managed Crystal Enterprise/ Seagate Info reports repository with automatic versioning and scheduled reports accordingly with the data updates.
• Used SQL, PL/SQL to maintain the data for reports and validation of the reports.
• Performed impact analysis for new requests. Coordinated the development effort of several developers in the team
• Created Business Objects Reports from the Universes as the main Data providers, provided adhoc reports, formatted the Reports as per the Users requirements using Business Objects, which allows the users to analyze the data.

Environment: Windows 2000, UNIX, Crystal Reports 9.0/8.5/7.0, Crystal Enterprise 9.0/8.5, Seagate Info 7.0, Business Objects 5.x, Oracle 9.i, SQL, PL/SQL, TOAD 7.0.

Confidential, Washington, DC

Living Disaster Recovery Planning System Reports Developer/Analyst

Responsibilities:

• Designed and developed Crystal Reports which included standard reports, cross-tab reports, summary reports according to the requirements. These reports used Summary, Crosstab, Graphs, formulae, conditional formatting, sub reports, parameters, drill-down capabilities.
• Used SQL, T-SQL to validate reports.
• Published the reports using LDRPS.

Environment: Windows 2000, Crystal Reports 9.0, SQL Server 2000, SQL, T-SQL, LDRPS 9.1.

Confidential, Bethesda, MD

Clinical Research Information System Developer/Analyst

Responsibilities:

• Communicated effectively for requirements and reports testing with the end users. Created detailed reports, summary reports and labels using Crystal Reports for the clinical requirements. These reports used Crystal formulas, Parameters, Selection Criteria, Sub Reports, etc. The completed reported were integrated into VB.NET application.
• Using SQL, T-SQL I created Views, functions, and Stored Procedures. Created reports using these views and stored procedures.
• Reported application errors while analyzing the data for reports.
• Scheduled and published reports using SunriseXA.

Environment: Windows XP, Crystal Reports 8.5, SQL Server 2000, SQL, T-SQL, VB.NET, Eclipsys SunriseXA.

Confidential, Vienna, VA

National Transit Database Developer/ Analyst

Responsibilities:

• Designed and developed Crystal Reports, according to the requirements using legacy system reports. Created view and stored procedures using SQL, PL/SQL for Crystal Reports data sets.
• Used Visual source safe to maintain the different versions of the reports.

Environment: Windows 2000, Crystal Reports 9.0, Oracle 9.i, SQL, PL/SQL, Java, Java Script, TOAD.