Objective

Self-motivated information technology professional with over 10 years of experience in Business Intelligence Actuate, QlikView, Crysal Reports and BOXI , SQL Server Database Development and Administration, ERP, application software development and implementation. Looking for a challenging career to utilize my skills and abilities in the IT Industry that offers Professional Growth while being innovative, resourceful and flexible and where I can prove myself as an aspiring asset for the industry.

Summary

• Expertise in Report design using BI Tool such as Actuate e.Reports, BIRT, Information Objects, QlikView, BO Crystal Reports, SSIS and Cognos.
• Expertise in Database designing, modeling developing Applications and administrating MSSQL SERVER. Proficient in SQL data management tools and design packages.
• Having experience in Ramco e. Applications ERP Package of Ramco Systems Ltd. . Implementation of ERP Package Technical functional .
• Participated in all phases of SDLC starting from Analysis to Delivery of the application development projects and also supported enhancements and maintenance of existing applications

Experience

Technical Skills

Projects:

Project Description

Morgan Stanley Advisory group provide services from proposal creation to new account opening. It has various modules like Proposal System, New Account Opening, Model maintenance and Account Maintenance. Financial Advisors can manage the client with various business programs using this various Advisory Tools. Consulting Group Proposal System CGPS is the one of the Advisory application gives option to FA to create proposal for client with various model and will produce the proposal document for the client. CGPS is a migration project where the Legacy Smith Barney Applications migrated into the Morgan Stanley Smith Barney environment. As part of migration Actuate e.Reports also migrated from Actuate 8 to Actuate 10. CGPS Application deals with the client/prospect and will create proposals based on their investment strategy. The final output of the application is proposal PDF that is generated from Actuate.

Contribution

• Analyze the existing CGPS proposal reports functionality
• Migrating Actuate Reports into Crystal Reports 2011
• Design and implement the CGPS Proposal PDFs in Actuate
• Developed utility using JAVA Flex.
• Integration of Actuate and Java modules.
• SQL Developments and Query optimization.
• Data preparation and analysis using Excel.
• Designed prototype using EXT JS
• Unit testing of all existing reports in CGPS.

Confidential

Project Description

The Confidential operates the world's largest and most liquid exchange group and offers the most diverse array of financial products and services. It which brings together six cash equities exchanges in five countries and six derivatives exchanges, is a world leader for listings, trading in cash equities, equity and interest rate derivatives, bonds and the distribution of market data

Contribution

• Actuate iServer installation with LDAP configuration.
• Design, Analysis and Development of Actuate e.Reports, BIRT reports IOD.
• Dashboard design and Integration of Dashboard reports with JBOSS portlets.
• Integration of Actuate standard reports with Web application
• Written complex PL/SQL queries and Procedures.
• Manual Unit testing and Performance testing for all the reports.

Confidential

Project Description

Confidential migrating CA Clarity PPM 8.1.1 to CA Clarity 8.1.2. In Clarity 8.1.1 they were used Actuate reports for reporting. In Clarity 8.1.2 they want to convert that existing Actuate reports to Business Objects which clarity 8.1.2 supports. In this project we are migrating the existing Actuate report s to Crystal Reports XI format.

Contribution

• Analyze the existing Actuate reports functionality and complexity.
• Analyze feasibility study for migrating Actuate Reports to BO XI.
• Prepared technical design documents and UTC.
• Design the existing Actuate reports in BO XI Crystal Reports .
• Written complex TSQL queries in SQL Server 2005.
• Manual Unit testing and Performance testing for all the reports.

Project Description

The Confidential is a global system, which is used for tracking information of all hazardous materials used at GMNA and GME in order to protect the employees and the environment as well as to meet legal requirements. Confidential is handling Material Safety Data Sheet MSDS and chemical related data as well as Safe Use Instructions SUI , Inventory, Regulations, etc.

Contribution

• Developed a package using which is dynamically generating the BIRT reports and render the reports in various formats PDF, Excel. Etc. .
• Create various Actuate BIRT Reports using eclipse designer.
• Validation of existing reports depending upon business demands.
• Prepared SDD, UTC Documents and minor development documents
• Created dashboard using Qlikview
• As a Team Member, was responsible for
• Understanding the business requirements and supply the information required by the team members for report generation.
• Analyzing the report specifications provided by the Business user.
• Designing and developing actuate BIRT reports using eclipse BIRT Designer with XML as data source.
• Writing java codes using BIRT API.
• Final testing of the Reports within the time frame.

Confidential

Project Description

Confidential is an application, which provides a system for maintaining Employee Stock Holdings. It provides extendable reporting solution, which is configurable based on application requirement. It has a set of pre-defined layouts, which will address some of the reporting requirements and can be extended by creating additional templates and configuring them into the solution.

Contribution

• Developed Actuate Reports for the assessment and review of the Employee Stock Option Purchase Plan.
• Validation of existing reports depending upon business demands.
• Prepared Technical design documents and minor development documents
• As a Team Member, was responsible for
• Understanding the business requirements and supply the information required by the team members for report generation.
• Analyzing the report specifications provided by the Business user.
• Designing and developing actuate reports.
• Final testing of the Reports within the time frame.
• Design , develop and implementation reports using Exstream Dialogue

Confidential

Project Description

Confidential is a Graphical Management Report to see the performance of their respective divisions. It was integrated with Ramco ERP, Excel files for Budgets and other application i.e., Roistering, Time Management, and Request Tracker and gets updated every hour in Reporting Server. Based on the actual, management can take a right decision at right time. This Report actually designs on the slice and dice concept with multiple dimensions.

Contribution

As a team member

• Design, develop and implementation Good Morning using Actuate
• Managed security, including page-level security for multiple tiers and group bursting, including conditional group bursting.
• Designed, developed, implemented and deployed complex Actuate reports using customized Actuate libraries and template.
• Administer the Actuate I Server Portal that includes deployment of reports, Creating Security roles, scheduling of batch reports, backup of volume, Crash recovery to the active portal.
• Build Dynamic Queries to work with dynamic data access and dynamic content frames, control, etc. Generation
• Developed Dashboard using QlikView.
• MIS Reports preparation using Excel.

Confidential

Project Description

G4S IT has successfully implemented Ramco ERP in Confidential around 120 Branches with 20 Regions , Thailand and South Africa. Ramco ERP having modules Payroll, HRM, AP, AR, GL, POMS, Sales, Shipping, Inventory and Administration Module. Creation and Configuration of Companies and OGLs as per the guidelines provided by Ramco. Setting up the System Parameters and Quick Codes for different modules at Company and Location level. We can create User Defined Screens, Reports, Drill Downs and Rules, using the technologies provided like Ramco ERP's Extension Development Kit, Additional Information Screens, Ramco Report Writer, DCubes and SQL Server 2000. Uploading the basic data in different modules for making a module operational for the first time like Chart of Accounts, Cost Centers, Details of Customers and Vendors, Deployment Details, Employee Details etc., using the special software called Visual Test. Scheduling and monitoring the status of critical Jobs like Database Shrinking, reclaiming the free spaces from the databases, Re-indexing of tables in the databases etc

Contribution

• As a team member, was responsible for
• Implementation, Development and Support of ERP Modules Payroll, HRM, AP, AR, GL, POMS, Sales, Shipping, Inventory and Administration Module at different countries.
• Functional Technical support for Ramco ERP implementation in India, South Africa, Philippines and Thailand.
• Backup Restoration of Databases, SQL Server Optimization, Query Optimization, Data Porting, DTS Packages, Scheduling of SQL Jobs, Backup Restore Database Management, Crash Recovery.
• Fine Tuning and Creation of Stored Procedures, Triggers and Indexes.
• Customization, Bug fixing, Implementation and support of Ramco Marshal ERP/ Ramco e. Applications 3.6.
• Trouble shooting of Ramco Marshall ERP modules HR, Payroll, Sales, Shipping and Administration Module .
• Study of client requirement and project specification preparation.
• MS Visual Test Script 4.0 to Automate the process, EDK Extension Development Kit ,Drill Down, Common Code Help CCH
• Generation customization of various reports like MIS reports, Document Reports and etc., using Report Writer 3.0, Crystal Reports 7.0 / 9.0 and Actuate.
• Generated different reports for the modules using either of the above tools and provided necessary MIS data via the above reports

Confidential

Project Description

Confidential is chiefly targeted at automating almost all of the business activities of a Spare Parts Dealership, which may be a Main or Sub dealers. DMS can start yielding the results from day One. Seamless integration of the package with the General Accounting reduces data entry and provides Accurate MIS reporting. Also this package can handle Spare Parts Claim, Admin and Payroll, which is also tightly integrated. This package can handle multiple company data with multiple stock locations, multiple manufacturers, for vehicles and Spares.

Contribution

• As a team member, was responsible for
• Develop front end using VB 6.0
• Database Design, Developing and Maintenance
• Design creating Tables, Stored Procedures, Cursors and Views in Optimized SQL Statements.
• Database Maintenance Optimization
• Analyzing, Developing and implementation of the software
• Reports generation on Crystal Reports Spread Sheet.
• Testing and Debugging of the above Application
• Interaction with users and understand user requirements
• MIS Financial Report preparation using Excel.

Confidential

Project Description

This system is for review of Sales, Stock, Outstanding, Financial GP, Expenses, factors and constraints that are affecting sales and GP done by the Management Periodically. All reports are done through Graphical Representations with comparative studies

Contribution

• As a team member, was responsible for
• Develop front end using VB 6.0
• Database Design, Developing and Maintenance
• Analyzing, Developing and implementation of the software
• Reports generation on Crystal Reports Spread Sheet.
• Testing and Debugging of the above Application
• Interaction with users and understand user requirements

Confidential

Project Description

Confidential is chiefly targeted at automating almost all of the business activities of a Production Company. Also this package can handle Admin and Payroll, Sales, Purchase, Production Planning, Production, Quality Checking Accounts. This package can handle multiple company data with multiple stock locations. It is a multi-user package

Contribution

• As a Programmer, was responsible for
• Develop front end using VB 6.0
• Reports generation on Crystal Reports Spread Sheet.
• Testing and Debugging of the above Application
• Interaction with users and understand user requirements

Confidential

Project Description

Confidential is automated transaction system for Pawn Broker. At any time we can view the customers OS and performance. Automated Tax calculation system. From this system we can find our current stock, current value of our Stock and also it holds all accounts entry

Contribution

• As a Programmer, was responsible for
• Develop front end using VB 6.0
• Reports generation on Crystal Reports Spread Sheet.
• Testing and Debugging of the above Application
• Interaction with users and understand user requirements