SUMMARY:

• Over fifteen years of IT experience in information technology including over ten Years of strong emphasis on Business Intelligence technologies like SAP Business Objects, Crystal reports, XCelsius, BO/Crystal SDK, Tableau, Micro Strategy, SQL, SSIS, SSAS, DTS in a data warehousing environment.
• Very good experience in wide variety of languages, databases, operating systems, reporting tools, dashboards etc.
• This include developing client/server applications, data modeling, developing Universes, report development, and dashboard development in both federal and private sectors.
• Can learn and adapt quickly to new and emerging technologies/software.

TECHNICAL SKILLS:

Business Intelligence: Business Objects XI4.1/XI4.0/XIR3.1/XIR2 (Information Design Tool, Universe Designer, Web Intelligence, Desktop Intelligence, Central Management Console, InfoView, Launch Pad), SAP Query Builder, Crystal Reports 2008/XI/ 10.0/9.0/7.0/ 6.0, Crystal Enterprise 10/9, MS SQL Server 2008 R2 Report Builder, MS SQL Server Analytical Services (SSAS), Tableau, Micro Strategy 9

Databases: Oracle 11g/10g/9.i/8.i/7.x, DB2 9.x, SQL Server 00/7.0/6.0, dBase III +, MS Access, My SQL

ETL: SQL Server Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Version Control: Clear Case, CVS, Tortoise SVN, Serena Dimensions, Visual Source Safe

Languages: SQL, PL/SQL, T - SQL, JAVA, Visual Basic, C++, C, PASCAL, COBOL, FORTRAN 77.

Web Technologies: Java Script, HTML, DHTML, XML, CSS, JQuery, J2EE, Servlets, JSP, JavaBeans, CGI, Perl, EJB

IDE: IBM Data Studio, TOAD, SQL Server 2008 R2 Management Studio, SQL Server 2008 R2 Business Intelligence Development Studio, Oracle Forms 4.5, Eclipse, IBM Rational Application Developer (RAD), Net Beans, JBuilder, JCreator, Visual C++, Borland C++

Servers: WebSphere Application Server 7/6.x, BEA Weblogic 8.1/7.0/6.1, IIS, Apache Tomcat.

Operating Systems: MS-Windows XP/2000/NT/98, UNIX and MS DOS.

Other Software: MS Visio 2003/2000/5.0, Dream Weaver

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Senior BO Developer/Reports Developer

Responsibilities:

• Responsible for overall production support for TIS Reporting and TRDM including universes, WebI reports and Crystal reports enhancements, project software environment and user access issues etc.,
• Highly involved in gathering report requirements from the business users for further analysis and actions. Maintaining the latest documentation (design specifications, functional specification and reports) using Tortoise SVN.
• Updating report technical documentation, Operation Support Plan (OSP) / Dynamic OSP, report details document and unit test cases. Keep track of the reports database changes, issues logs and resolutions etc.,
• Responsible for analyzing the current reporting structure and the universe objects structure. Presented the better solution and successfully implemented the proposed structure on development through production environment.
• Responsible for analysis, time estimation, designing, developing, testing and implementing new crystal reports /enhancements for TIS reports for the Trademark requirements from USPTO users. These reports’ features include crosstab, cascading prompts, sub reports, charts etc,
• Developed complex SQLs, views, stored procedures which served as the data source for the Crystal reports. Created Crystal Reports using XML files on the server. Validate the data from the files.
• Highly involved in designing star schema model for TRDM universe, developing universe, used Derived tables, secure, test and manage universe. Analyze and develop solutions to complex problems. Performed data mapping for new database built for reporting environment. Created complicated reporting like drill down, cascading prompts, variables, filters, sorts, sections, breaks, conditional formatting, sub queries, integrate some of the detail reports with Business application.
• Responsible to provide the processes and procedures to implement for better organizing the team, responsible for migrating universe/reports/ other dependencies to different environments. As a part of CMMI, highly involved in gathering all the milestones of the project. Prepared templates for design, business specifications and quality control, kept track of migration process between the teams. Responsibilities included gap analysis and efficiency recommendation across various business groups.
• Established and implemented best practices to ensure data quality and perform quality reviews of logical and physical data models from reports perspective.
• Responsible for making suggestions to ETL processing for reports team. Extensively worked with sql queries for optimization, fine tune reports. Responsible to consolidate the code, documents into version control and to keep track of the activities of the team, mentoring the junior staff, provide guidance for better practices.
• Created Dashboards and incorporated into the reports for better visualization/ decisions or higher management. These data visualizations are being used by Trademark users in decision making.
• Responsible to create BIAR file for the reports/universe of TIS Reporting/TRDM, migrate and maintain in Development through production environments using SAP Upgarde Management Tool and BOXI Central Management Console (CMC). Responsible for creating new user/group, security levels and solving any user/group access issues for TIS Reporting / TRDM.
• Created the Quarterly Baseline for TIS Reporting that include creating BIAR file, Change requests using the BMC Remedy Action Request System, version request and build requests using Continuous Integration Configuration Management (CICM).
• Involved in writing the test cases and testing the reports / universe for the System test and preparing the test cases for the users and prepared the user documentation for the universe/reports.
• Created/Updated the reports, analyzed data and dashboards using Tableau Business Intelligence tool and analyzed/presented the findings/recommendations to the business users.
• Maintaining the report properties like bulk password change using 360View tool.

Environment: SAP Business Objects BI Platform 4.1, Crystal Report Enterprise 4, SAP Crystal Reports 2013, Information Design Tool, Universe Design Tool, SAP BO Dashboard Designer, XCelsius, Tableau, SAP Data Services 4.2, SAP Upgrade Management Tool, ORACLE 11g, SQL Developer 4.0, Tortoise SVN, 360 View Tool, BMC Remedy Mid Tier 7.6, CICM

Sr. ETL Flash Reports Developer

Responsibilities:

• Responsible for analysis, estimation, designing, developing, testing and implementing applications based on business requirements from FEP.
• Responsible for gathering requirements from Director’s Office users to enhance / create reports. Prepared Functional specification, technical documentation, report mapping documents and unit test cases. Developed user manuals for ease of use of the product.
• Created new Crystal reports and modified existing as per user requirements for multiple projects (like PCCER, FIMS, FEPMIR, QIPS, FEPER, ACM etc.,).
• Developed complex SQLs, views, stored procedures which served as the data source for the reports and web applications.
• Created complicated Crystal reports like sub reports, cross-tab, drill down, cascading prompts, parameters, filters, conditional formatting, sub queries, integrate some of the detail reports with Business application.
• Deployed and maintained reports through BOXI Central Management Console (CMC). Created Users, groups and set the security levels for the specific reports. Migrated the reports from Crystal Reports XI R2 to Crystal Reports 2008.
• Developed Java web pages/modules to generate the crystal reports using Crystal SDK.
• Highly involved in data analysis, design, and development of the dimensional database for PACER for data analytical reports.
• Migrated/Rewritten the DTS Packages to SSIS Packages as a part of SQL Server 2008 upgrade project to extract, load, and transform (ETL) the data from the text files to the table in the database for Open Season application.
• Analyze and develop data solutions to complex problems. Performed data mapping for new database built for reporting environment. Presented and implemented best practices to ensure data quality and perform quality reviews of logical and physical data models from reports perspective which enhanced the ETL processing.
• Involved in checking and correcting the SQL code while the applications are upgrading the database from SQL Server 2005 to SQL Server 2008.
• Written Java code using Crystal SDK to generate the Crystal Reports from the web application.
• Developed Web Application modules for PACER project using Crystal SDK, Java/J2EE, Spring, JDBC etc.,. (Creating front end JSP pages in PACER application using style sheets, JavaScript, JQuery etc., and Integrated CKEditor, DataTable plugins with Java).
• Completed analysis, evaluation and proof of concept for Adhoc reporting using Business Intelligence solutions like SSAS, Report Builder, Power Pivot Excel etc.,. Presented the analysis, findings, soutioon implementation, pros/cons etc., to the business users along with business analysis team, testing team and developer team.
• Involved in review, providing the findings and recommendations for current reports in Micro Strategy. Created/updated reports using Micro Strategy.
• Completed analysis of ad-hoc reports using Tableau. Created the reports, analyzed data and dashboards using Tableau Business Intelligence tool and presented the findings/recommendations to the business users.
• Created documents in Requisite Pro. Involved in creating tags for the FRS and did traceability of FRS tags to the BRD requirements.

Environment: Crystal Reports 2008 / XI R2, BOXI 4.0/3.1/3.0, Crystal SDK, JDK 6, J2EE 5, JQuery, MS SQL Server 2005/ 2008 R2, DTS, SSIS, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Report Builder, SSIS Packages, Micro Strategy 9.2.1, Tableau, ORACLE 11g/10g, DB2 9.x, TOAD 10.1, WAS 7, Rational Clear Case 7.1, Clear Quest 7.1, Rational Requisite Pro

Data Analyst/Reports Developer

Responsibilities:

• Responsible for the complete project lifecycle - requirements analysis, design, development, testing.
• Prepared technical documentation and unit test cases.
• Designed and developed new BO universe specific to the ECS reports.
• Created WebI reports and Crystal reports using existing and new universes.
• Deployed and scheduled reports through Infoview.
• Created complex views to overcome loops and contexts.
• Created complicated reporting like drill down, cascading prompts, variables, filters, sorts, sections, breaks, conditional formatting, sub queries, integrate some of the detail reports with Business application.
• Created complex sqls, functions, views, MQTs (Materialized Query Table) .
• Used drill down options on three levels - District Office, Unit, and CE level in Cases at RECA, a Special Report. Used cascading prompts in the SF-1166 Check EFT Register Report which provides a summary and detail view of all payment transactions for the selected batch id(s) that have been transmitted to the Compensation Payment Authority (CPA). Created Crosstab report to show the total claims for each claim status.
• Responsible to create a BIAR file to take the weekly backup of the Universe and the reports.
• Used Central Management Console to publish and schedule reports.
• Trained and used CMMI (Capability Maturity Model Integration) level 3 best practices.

Environment: Business Objects XI R3/R2, DB2 v9.5, IBM Data Studio, Data Integrator, MS-Visio, Rational Clear Case, Win 2000

ETL/Reports Developer

Responsibilities:

• Involved in requirement gathering and written detailed design documents, layouts for the crystal reports, technical documents and reviewed with architecture teams.
• Designed and Developed Crystal Reports using Plain Old Java Objects (POJO) and Sql Pages against DB2 database. Written report specific POJO data sources.
• Developed FEP Direct reports to help users to determine the effectiveness of the Plan’s processing overall, to allow quality sampling and audit, to determine if there is a need for Case Management for an individual etc., Involved in extensive analysis to design the Reports template.
• New reports were designed and developed to support the Director’s Office requirements. These reports are scheduled on daily, weekly, monthly, quarterly and yearly basis.
• Interacted with business users to analyze the business process and requirements and transforming requirements into reports, designing database, documenting and rolling out the deliverable.
• Responsible for creating complicated crystal reports (High Dollar Claims Reports, Payment Greater than Covered charges Reports, First Pass Approval Reports, Plan Tracking reports, Failed Lock Out Reports etc.,) including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, hyperlinks (with Crystal Report XIR2).
• Developed Complex SQLs, stored procedures, functions, cursors and packages. And also involved in SQL performance tuning.
• Built Sql Pages by writing SQL to retrieve report specific information from DB2 database.
• Written Java backend programs to develop the ETL process - Extracting data from DB2, Transforming data in Java and Loading the transformed data to Crystal Reports.
• Interacted with plans (business users) to analyze the business process and requirements and transforming requirements into reports, designing database and documenting of the Claims Processing reports to show the actual claims of users’ interest in a well formatted and well presented data.
• Established and implemented best practices to ensure data quality and perform quality reviews of logical and physical data models from reports perspective.
• Developed Java programs to publish and schedule reports on the web interface using Quartz API reports in different formats like pdf, csv, rtf and html .
• Worked with architecture team in finalizing the reports standards for FEPDirect Reports and Claims Enhancements reports, prepared the user guide, run instructions for the team.
• Written detailed design documents for the crystal reports and reviewed with Application Specialist.
• Prepared technical specification, report field to data mapping document, unit test plan and involved in completion of Requirements Traceability Matrix (RTM).
• Involved in Data mining by analyzing the large amounts of data.
• Involved in the installation, configuration and integration of Crystal Reports for Eclipse.

Environment: Crystal Reports for Eclipse 3.2, RAD 6.0/7.0, Java 1.5, JRC, Quartz, DB2 v9.5, IBM Websphere Application Server 6.1, MS-Visio, CVS, Serena Dimensions, Win 2000, UNIX

Care Coordination Portal Enhancements & Support

Responsibilities:

• Involved in design, development and unit testing of all the transactions of CCP.
• Designed and developed JSP pages using Presentation Framework for all transactions of CCP.
• Used Spring, Spring-form, JSTL tag libraries for Presentation Framework.
• Created various CSS and Java Script functions for the user interface validations, the tab layouts, etc.,
• Implemented client side validations (error codes etc)/server side validations (excluded drugs etc).
• Written complex SQLs to retrieve Member Profile, Member Medical Profile and to retrieve/insert/update and delete data Care Management Coordinator Contacts from Interactive Data Base Repository (IDBR) using JDBC. Also involved in tuning the SQLs to improve performance.
• Implemented Excel download feature for Care Management Coordinator Contacts details.
• Prepared technical specification, screen field to data mapping document, unit test plan and involved in completion of Requirements Traceability Matrix (RTM).
• Written unit test cases as per user specifications document and reviewed with the team. Involved in Integration testing of all the modules.
• Served as a technical support person between directors’ office and FEPOC and involved in weekly meetings while the project is in transition from FEPOC to DO.

Environment: Java / J2EE, JDBC, Spring Framework, DB2 v9.5, Rational Application Developer 7.0, IBM Web sphere Application server 6.1, CVS, Win 2000

Corporate Performance Management Dashboard

Responsibilities:

• Responsible for complete life cycle of the dashboard development involving in analysis, design, development and testing of dashboards against Excel data source.
• Written detailed design documents, layouts for the dashboards and reviewed with architecture teams.
• Prepared technical specification, dashboard field to data mapping document, unit test plan and involved in completion of Requirements Traceability Matrix (RTM).
• Created dashboards complex and dynamic visibility Crystal XCelsius dashboards using gauges/dials, charts, maps and selector objects using Crystal XCelsius, which would facilitate the analysis and decision-making of the directors in terms of the budgeting, system performance issues etc.
• Interacted with the different project owners to analyze and design the dashboard specific Excel data sources with all the specific business logic in it.
• Created dynamic dashboards using excel sheets mapped to XML files. Wrote XML code to retrieve from database and generate the data into excel.
• Created Data Visualizations using XCelsius dashboards and excel spreadsheets.
• Wrote HTML code to deploy dashboards on the web interface and integrated some of the dashboards into PowerPoint and PDF.

Environment: Crystal XCelsius 4.5, Java 1.5, XML, Microsoft Excel 2007, CVS, Win 2000

IT Supervisor/Lecturer

Responsibilities:

• Supervising the real time major project for 2 semesters for the final year students. This includes the complete SDLC from requirement gathering and business analysis, design of Online Student Registration System for UTech, In-House Student Selection Application for UTech Online Accommodations System, Claims/Operation Maintenance, Clinical Study Management (CSM) etc.,using Java, JSP, Servlets, RMI, ASP, Visual Basic, Web, Crystal Reports, Business Objects, DB2, Oracle, SQL Server, Crystal Reports, Visual Basic, Business Objects etc.,
• Lecturing and tutoring all years of Bachelors of Computing and Information Technology (BSc.CIT), Bachelors of Management with Computer Studies (BSc.MCS) students and training different level programmers from various organizarions. The lectured programming languages include C Programming, Object Oriented Programming using C++, Data Structures, Advanced Programming using Java, Advanced C and Information Technology.
• Developing user documentation and training documents.

Junior Professor

Responsibilities:

• Lead multiple projects (Web Enabled Supply Chain Management System, which deals with the CIT online Students Tracking System) for 10 students each team. The technologies used were Java, JSP, Servlets and database using SQL Server, DB2.
• Lecturing and training for work force based students with the techniques in Object Oriented Programming like C++, Core Java and Advanced Java ( JDBC, Servlets, Beans), DataBase Management System Concepts and Database Programming in SQL Server, MS Access.

Confidential

Jr. Programmer Analyst

Responsibilities:

• Participated in designing and development of the complete life cycle of the applications (Document Maintenance System, Budgeting System, Client Case Index History with MECON). Data Access Objects (DAO) was used to interact with the database.
• Developed screens using Active X controls. Communicated with Oracle using DAO 3.5. Designed and developed the functionality of GUI screens using API functions.
• Developed crystal reports such as cross tab, on demand, sub reports, using parameters etc., using dynamic SQL, procedures, views, packages etc., to retrieve data from the source database.

Environment: Visual Basic 5.0, MS Access, ORACLE, Crystal Reports 6.0, and Windows NT 4.2