SUMMARY:

• Advanced Report Development including Web and Barcode reports Client/Server Application Development Database Design Business and Systems AnalysisConceptual Knowledge: Payroll, stock planning, asset tracking, and talent management
• Fleet tracking, options trading, oil & gas, healthcare, manufacturing, pharmaceutical, software, and retail
• A dynamic, technically skilled, and results - focused professional recognized for providing business analysis, systems analysis and advanced report and application development thereby ensuring and enhancing delivery of information technology.
• Expertise in design, development, and administration of reports, applications, and databases.
• Ten + years’ experience with reports and applications development and with SDLC in client/server environments using business intelligence tools like SAP Business Objects (SAP BOBI), Jaspersoft Jasper Reports/iReport, SSRS reporting, MS Access reports, VB/VB.Net, Java, JavaScript, ASP/ASP.Net, JSON/XML, Oracle, MS SQL Server, MS Access and MySQL.
• Proven ability to successfully analyze an organization's critical support requirements, identify key deficiencies and potential opportunities, and develop innovative reporting solutions.
• Possess creative problem solving and excellent communications skills, a team player and a self-starter, completing projects ahead of deadlines, and continuously developing new technical skills and adapting new technologies to increase productivity.

SYSTEMS SKILLS:

BI and Reporting Tools: TIBCO Jaspersoft Studio, iReport, JasperReports Server, Tableau, Power BI, SAP Business Objects BI 4.x, Crystal Reports, Crystal Xcelsius, Actuate 8 Reports, and MS Access reports

Programming Languages: Java, SQL, and PL/SQL, VB/VBA/VB.Net, C, ASP, and HTML

Databases: MySQL, DB2, Oracle, SQL Server, and Access

DB tools: MySQL Workbench, IBM Data Studio 4x, TOAD, Erwin, TOra, Visio, Squirrel SQL

App/Web Servers: IIS, Apache Tomcat

Java IDE: Spring (STS), Eclipse, Exadel Studio

ETL Tools: Informatica 7, Kettle

Source Safe: GitHub, Git, Jira, SVN, TFS, Visual Source Safe, Harvest

Other: Tieto Energy Components, SharePoint, Odyssey, JSON/XML, UC4, HP ALM Defect Tracking System, DMS, and Crucible

Conceptual knowledge: Power BI, Tableau, SAP BW/Bi

Cloud: Amazon Web Services (AWS), Agile, Kanban Boards

EXPERIENCE:

Confidential, Lakeland, FL

Jasper Reports Developer

Responsibilities:

• Maintenance of existing reports, enhancement of existing reports per client requests, and development of new reports.
• Creating functions whenever necessary in MySQL.
• Performing unit testing of the reports.
• Maintenance of JasperReports Server by checking schedules, report configurations etc.
• Interacting with support individuals to discuss report changes, enhancement requests and requirements.
• Technologies being used include TIBCO Jasper Studio 6.2.0, JasperReports Server, GitHub, MySQL, MySQL Workbench, and JIRA.

Confidential, Keller, TX

Jasper Reports Developer and Analyst

Responsibilities:

• Creating JRXML files using Jaspersoft Studio.
• Creating Java classes (BO, DO, DOImpl) in Spring environment to deliver reports to Confidential ’s reporting architecture.
• JUnit testing, integration testing, and assisting with system testing.
• Submitting code reviews in Crucible to make sure code is aligned with Confidential and SEC requirements
• Interacting with designers to discuss and finalize report requirements.
• Using HP ALM defect tracking system to work on defects/issues identified by users/testers.
• Participating in daily scrum meetings.
• Technologies used included TIBCO Jasper Studio 6.2.0, JasperReports Server, Java, Sprint, DB2, SVN, SQuirrel, UC4, HP ALM, DMS, and Crucible.

Confidential, Houston, TX

Jasper/Crystal Reports Developer and Analyst

Responsibilities:

• Designing new reports in Jaspersoft iReport 3.1.1 and Crystal Reports 2011, publishing reports to BOBI and EC, creating back-end database objects like views, functions, procedures, and packages, and modifying and fixing existing reports per support tickets.
• Fine tuning SQL queries and reports that took significantly large time to run.
• Hands-on experience of configuring various business functions within EC Production, EC Transport, and EC Revenue modules.
• Interacting with customers through e-mail, phone, screen sharing, and live instant messaging sessions to discuss and resolve their issues.
• Technologies used include Oracle 10g/11g, SAP BOBI 4.1 SP5 (BVM, Launchpad, CMC), Crystal Reports 2011, Jasper Reports, iReport 1.2.8/3.1.1 , EC versions 9x/10x, SharePoint, Team Foundation Server (TFS), Harvest, Odyssey, and MS Lync.

Confidential, Houston, TX

Crystal Reports Developer

Responsibilities:

• Worked closely with User Centered Design ( Confidential ), Applications, and DBA teams to hash out report requirements.
• Designed a data mart using SQL Server for Confidential ’s reporting module.
• Frequently exported/ imported data between servers and to and from backup files.
• Created views and stored procedures to provide data for reports.
• Developed interactive dashboards and charts using Crystal Xcelsius.
• Technically assisted other developers with queries and report logic.
• Often engaged with overseas development teams to collaborate the project work.

Confidential, Merrimack, NH

Reporting Analyst

Responsibilities:

• Comprehensive review of reporting requirements for Confidential ’s Global Platform (GP) systems.
• Gap analysis to identify opportunities of improvement in terms of new reports that could be added to their system.
• Analyzed data interfaces and reporting user interfaces and made recommendations to adopt best practices.
• Interacted with different groups to gather and streamline their requirements and developed assessments for competitor systems. Tools used included Crystal Reports 8.5 and Oracle.

Confidential, Houston, TX

Crystal Reports Developer/ Apps Developer

Responsibilities:

• Developed a reporting solution for an in-house compensation system using open source Java technologies like Eclipse, iReport, and Kettle ETL. For this in-house system, developed several new Jasper reports, developed ETL transformations and workflows to schedule data transfers, and developed a reporting data mart in Oracle.
• Reporting work in Crystal reports involved creation of several new reports from scratch, modification of existing reports, creation of back-end objects, and publishing of the reports to the client web applications.
• Application work involved modification of worksheets (application screens) by adding and removing UI controls using Java script and ASP, design and development of a report admin interface and development of a report generation utility in Java to generate reports in PDF.
• Developed a small-scale custom compensation application using MS Access 2003 for Confidential ’s in-house use. This application applied compensation for employees on a set of rules. It also involved creation of several reports in Crystal Reports.

Tools: utilized: Crystal Reports 8.5, 9.0, Oracle 9i, SQL Server 7.5, VB 6.0, Java, Jasper Reports (iReport), Kettle ETL, Jasper OLAP and ASP.

Confidential, Houston, TX

Consultant - Crystal Reports

Responsibilities:

• Developed about two dozen new web reports, two new bar code reports, and modified about ninety existing reports for Confidential.
• The bar code reports were designed to print 2'' by 3.5” labels on Intermec 3400C label printer.
• Created new JSP files through a customized JSP application to deploy the reports to their web application.
• Back-end work involved writing stored procedures and views. Created documentation for reporting interface and provided training to end users.

Technologies used: Crystal Reports, Oracle, and JSP.

Confidential, Houston, TX

Consultant - Crystal Reports

Responsibilities:

• Collected reporting requirements from business users. Installed and configured Seagate Info 7.5 client and server components including Crystal Reports Designer, Seagate Analysis, Crystal Dictionaries, and Crystal SQL Designer on a new server.
• Developed parameterized reports, with dynamic selection of report titles, selection groups, sort order, and time frame at run time. This methodology reduced the total number of reports required as now one report could be run with multiple scenarios using the parameters.
• Developed multiple section/columned reports to eliminate overprinting problems.
• Created drill down reports to view the data behind individual groups.
• Used advanced totaling, absolute and conditional formatting techniques in several reports.
• Created an ActiveX DLL in VB 6.0 to add more functions to existing Crystal Reports functions library. Monitored, maintained and cleaned up report server on routinely basis.
• Prepared reports documentation and provided technical support on phone and via e-mail.
• Tools used included Crystal Reports 8.5 and SQL Server 6.5.