Amit Parekh Email & Phone Number

Houston, Texas, United States

• Implement (Model N) revenue management system in three phases, one for each of the three key business areas (Medicaid, Commercial, and Government Pricing).• Create custom reports and to bring new solutions for Commercial, Finance, and Government Pricing by working with all areas of the management and users.• Create EDI processes with external vendors, and scheduled interfaces for payment and payment acknowledgement with ERP system in place.• Perform a continuous evaluation of current processes and setting up a new process improvement group within the development team.• Maintain effective lines of communication across business domains and make all users aware of activities with potential to impact relevant data.• Provide additional support to business users by keeping track of the project budget by evaluating the time spent by implementation teams and Model N (RMS) teams.• Project timelines and create smooth user experiences by responding immediately to solve gross to net (G2N) project interface issues.• Zeroed in on inconsistencies within data from two systems where interfacing files were transferred.• Minimize work performed on daily, repeatable processes by acting as internal consultant training users.

• Worked with Query & Reporting team to analyze, design and construct reports from data warehouse/Date Marts using Business Objects XIR3.• Worked on multiple migrations (6.X to XIR2 platform) as well as upgrade (XIR2 to XI 3.1) projects.• Migrated about 150 reports from XIR2 WEBI to XIR3 WEBI using BO Conversion tool. • Coordinated with the offshore team for report deliveries.• Developed standard and ad hoc reports based on business and technical requirements.• Created New Business Object reports for business involving, Marketing, Circulation, Finance, Customer Retention for analysis of New York Times Home Delivery and Digital subscriptions.• Successfully implemented various Full Lifecycle projects (Requirement gathering/Reviewing through implementation and enhancement) of Business Objects reporting.• Trained end users in developing ad hoc reports through Web Intelligence.• Worked with Various business teams to understand the business and data in order to efficiently provide the solutions to develop new products.

• Developed home-grown Business Intelligence Reporting solution using Business Objects for the Insurance/Reinsurance System for Global Corporate, Europe to support both operational and executive reporting needs of various departments of Zurich.• Gathered report requirements by interacting with Business Analysts and Business users.• Perform Analysis to understand if existing data mart can support report requirements.• Create a new Business Objects Universe and Modified existing Business Object Universe.• Generated linked reports with complex cross-tab reports with multiple queries, conditions, global filters and multiple data providers.• Coordinated with DBA’s to enhance and make necessary changes in the Database as needed to enhance the reports.• Provided post-production support for system issues, including research and follow-up.• Tested the Business Objects XIR2 migration to ensure the reports are functioning as per expectations.• Troubleshoot migration defects and provided technical solutions to correct defects.

• Used Business Objects to assist in accessing and analyzing data for its franchise hotels.• Gathered user requirements and engaging with Business Analysts in order to create new reports.• Assisted in system maintenance and support in a production support environment as required by the client. Analyzed and produced ad-hoc reports for the users.• Interacted with the client throughout all phases of Business Objects development.• Modernized, eliminated and condensed existing outdated reports and rewrote processes• Performed system testing and data validation, report creation, system security, data extracts and personnel training.• Prepared strategic trend reports to measure KPI, Increased leadership focus on key Performance Indicators.

• Oversaw all financial & admin. operations including sourcing activities at the executive level. • Involved in Requirement Gathering and prepared Technical specs and documents.• Created reports as per user requirements using Hyperion reporting tool• Created reports using Hyperion with functionality like, Slice and Dice, Drill Down, Master/Detail, Cross Tabs, and chart.• Involved in Unit, functional and Integration Testing.• Scheduled the reports using the scheduler tool.• Created Alerter, Filters, Ranking and Inserted Breaks in designing reports.• Worked with the Treasury department and Audit consultants to verify the data accuracy.

• Migrated Business Objects reports from their local system to Business Objects 5.x/6.5.• Designed the reports according to client’s requirement using Business Objects 6.5.1• Interacted with Business users and Business Analysts to gather the marketing requirements and business logics.• Created user prompts, conditions and filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.• Involved in post production support and gave training to the end users to create adhoc reports.• Tuned the queries to improve the performance of the existing reports for various functional areas.• Coordinated and executed marketing activities aimed at customer retention and development.• Made recommendations to senior managers based upon research findings.• Worked with external data suppliers regarding data accuracy and integrity.

• Executed projects through all phases of the application development process including Analysis, Scoping, Design, Development, Quality Assurance Testing, and Implementation.• Involved in the Design, Development, Testing and Implementation phase of Database.• Assisted in technical support for a team that involved technical and quality reviews of the Implementation cycle.• Worked with Client Service on the development of strategy and implements product features and specific courses of action as they pertain to the business.• Collaborated with cross-functional teams to develop numerous reports including, testing, documentation, performance tuning, and requirements gathering and design.• Performed functions pertaining to trading operations, including daily trade and asset reconciliation, trading maintenance transactions, periodic performance reporting.• Maintained Employee Stock Purchase Plans and Employee Stock Option Plans databases (CMS, & Equity Edge) to accurately reflect employee and Company sourced contributions.• Performed detailed problem analysis, review solution alternatives and follow-through to resolution.

Education record

Education record