EXPERIENCE SUMMARY:

• Nine years of experience in Information Technology, with technical expertise in WEBFOCUS and SQL Server.
• Extensive knowledge in creating and styling reports in Excel, PDF, CSV and PPT formats.
• Experienced in developing Flex Dashboards in PDF formats with the Data handled as XMLs using WEBFOCUS and the report designed in flex.
• Trained and Experienced in creating HTML Dashboards using compound reports and frames.
• Experienced in WEBFOCUS 7.1.4, 7.6.9 and 8.0.2 versions.
• Experienced in handling and working on projects with Agile and Waterfall models.
• Experienced in troubleshooting and creating SQLs and Stored Procedures in SQL Server 2000.
• Experienced in working with many Backend technologies including SQL Server, DB2 and Oracle.
• Received Syntel’s Individual for Synergy for the first quarter of 2012.
• Received Syntel’s team for Stretch for the third quarter of 2011.
• Over four years of experience as Onsite Coordinator and has managed the offshore team by stretching the work time and effort.
• Over five years of experience as project leader with handling the end to end project development, testing and implementation.
• Quick Learner and excellent Team Player with good interpersonal skills, commitment and Hard work.
• Result oriented with a quest and zeal to learn new technologies and undertake challenging tasks.
• Strengths include Excellent Analytical and Designing skills.

TECHNICAL SKILLS:

Reporting tool: IBI WEBFOCUS 7.1.3, 7.6.9, 8.0.0.2

Flex tool: Adobe Flash Builder 4.6

Databases: SQL Server 2000, Oracle 9i, IBM DB2, MySQL

Programming Languages: C, C++, Basic JAVA

Operating Systems: Windows XP, 2008, Unix

Testing Tool: HP Quality Center

Versioning Tool: Visual SourceSafe, Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential

IBI Developer and Technical Lead

Responsibilities:

• Analyze and Defining the Report requirements.
• Designing the parameters for the reports based on the requirements.
• Created the SQL in DB2 for fetching the data based on the user role.
• Design the HTML5 report with multiple Layout tabs and graphs based on the requirement.
• Design the report based on the parameter selection by the user during setup.
• Create individual report and graph components that could be referred inside the composer for the HTML5 design.
• Analyzed and designed the user stories for each sprint in Agile method.

Technologies: IBI WEBFOCUS 8.0, Flash Builder 4.6, DB2, QualityCenter

Confidential

IBI Developer and Technical Lead

Responsibilities:

• Analyze and Defining the Report requirements.
• Designing the parameters for the reports based on the requirements.
• Created the SQL in DB2 for fetching the data based on the user role.
• Designed the Excel report with dynamic fields based on the data from Backend. The fields count and order would vary based on the user role.
• Coordinated the end - to-end development and testing of the Reporting Applications.
• Analyzed and designed the user stories for each sprint in Agile method.

Technologies: IBI WEBFOCUS 8.0, Flash Builder 4.6, DB2, QualityCenter

Confidential

IBI Developer and Technical Lead

Responsibilities:

• Analyze and Defining the Report requirements.
• Designing the parameters for the reports based on the requirements.
• Created the SQL in DB2 for fetching the data based on the filters from parameters.
• Created the XMLs for each panel inside the Dashboard in WEBFOCUS.
• Designed the Dashboard with Flash builder using the XML data as input.
• Created the library with all the image files in SWC format to be referred inside the Dashboards.
• Analyzed and designed the user stories for each sprint in Agile method.
• Created the stored procedures in DB2 to capture the metrics inside WEBFOCUS for each Dashboard.

Technologies: IBI WEBFOCUS 8.0, Flash Builder 4.6, DB2, QualityCenter

Confidential

IBI Developer and Technical Lead

Responsibilities:

• Analyze and designing the report requirements and detail design documents.
• Created the SQL in DB2 for fetching the data based on the selection by user.
• Designed the Excel compound report to display in multiple tabs and sections with different styling.
• Included logic to display a default report when there is no data available based on the user selection.
• Designed the SQL for display alternate names for columns inside the report based on the user selection.
• Coordinated the activities with all interacting applications during Build and testing of the reports.

Technologies: IBI WEBFOCUS 8.0, DB2, QualityCenter, Sharepoint

Confidential

IBI Developer and Technical Lead

Responsibilities:

• Analyze and designing the Report requirements and detail design documents.
• Created the SQL in DB2 for fetching the monthly data based on the selection by user.
• Designed the PDF report to display the data in different styles based on the transaction types and quantity.
• Designed the Excel compound report to display in multiple tabs and sections with different styling.
• Developed the common routine for all the header and footer styling inside the reports.
• Created a logic to capture image from the java tool and display in the report.
• As a project leader assisted and coordinated the activities with creating and performance tuning of all reports.

Technologies: IBI WEBFOCUS 8.0, DB2, QualityCenter, Sharepoint

Confidential

IBI Developer and Technical Lead

Responsibilities:

• Analyze and Defining the Report requirements.
• Designing the parameters for the reports based on the requirements.
• Created the SQL in DB2 for fetching the data based on the filters from parameters.
• Designed the PDF report with multiple graphs including piechart and column chart.
• Designed the Excel compound report to display in multiple tabs and sections with different styling.
• Created a common routine to style the numeric values in different formats based on the selection by user.
• As a project leader assisted and coordinated the activities with creating and performance tuning of all reports.

Technologies: IBI WEBFOCUS 8.0, DB2, QualityCenter, Sharepoint

Confidential

IBI Developer

Responsibilities:

• Execute the DTS package to pull the profile and user information to the database.
• Update the profile information based on new changes to the report and requirements.
• Execute the procedures for the profiles associated to the reports in SQL Server 2000.
• Validate the reports if it has been mailed to the correct recipient with the attachments.

Technologies: MS SQL Server 2000

Confidential

IBI Developer

Responsibilities:

• Created the logic to calculate the report period based on the frequency selected by the user.
• Designed the SQL in SQL server to fetch the data for the period selected by the user.
• Designed the report with multiple column charts based on the result set from the SQL.
• Designed the compound PDF report with the image files embedded in header and footers.

Technologies: IBI WEBFOCUS 7.6.9, SQL SERVER

Confidential

Application Developer

Responsibilities:

• Involved in the analysis, design, preparation of the functional specifications documents and detail design documents.
• Writing Stored Procedure using Microsoft SQL Server to capture and display data based on the selection in the screen by user.
• Include checks if the mandatory fields I the screen is entered by the user.
• Include validations if the IDs entered by user is unique across all layers.
• Design of screens using the earlier version of Ramco Virtual Works RVW 2.0.
• Responsible for Problem identification and fixing the root-causes.

Technologies: MS SQL Server 2000, Oracle PL/SQL, DB2, Java, RVW2.0

Confidential

Application Developer

Responsibilities:

• Analyzing the Requirements and come up with a proposed solution.
• Programming in Java to authorize and authenticate users referring with SQL Server as backend.
• Include validations to check the login credentials passed by user during login.
• Writing Stored Procedure using Microsoft SQL Server, Oracle to capture design data of Virtual Works Model 3.0.

Technologies: MS SQL Server 2000, Oracle PL/SQL, DB2, Java, RVW2.0

Confidential

Application Developer

Responsibilities:

• Involved in the design, preparation of the functional specifications documents and detail design documents.
• Programming in Java for the Collection of data from one data source and migrating to a different data source.
• Creating stored procedures in SQL Server to capture data and migrate to a new database.
• Include validations to check the data types with similar names migrated from different databases.
• Development of new programs and Enhancement to existing system using detailed design documents.
• Responsible for Problem identification and fixing the root-causes.

Technologies: MS SQL Server 2000, Oracle PL/SQL, DB2, Java, RVW2.0