Candidate Information Name Available: Register for Free Title Team Member Warehouse Target Location US-OH-North Royalton Email Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Warehouse Associate Team Member Cleveland, OH Team Member Warehouse Associate Cleveland, OH Warehouse Associate Team Members - Work From Home Chardon, OH A Team Amazon Warehouse Cleveland, OH Customer Service Team Member Cleveland, OH Team Member High School Cleveland, OH Team Member Crane Operator Cleveland, OH

Curriculum VitaeCandidate's Name  EMAIL AVAILABLEExperience SummaryDevelopment expertise with Oracle and SQL and PL/SQL.Knowledge on Data warehousing Concepts and Data warehousing Testing.Training and CertificationsCompleted Oracle External Certification Oracle 9i: SQL, 1Z0-007.Completed Oracle External Certification Oracle 9i: PL/SQL 1Z0-147Completed IBM Websphere Data Stage 000 - 415Technical SkillsDatabases & Tools : Oracle 9i,TeradataLanguages : Oracle, C, C++Relevant Project Experience:DESCRIPTION OF THE PROJECT:CLIENT DESCRIPTION:Pfizer Inc. is the market leader in the Pharmaceutical space .Pfizer Inc discovers, develop manufactures, and markets leading prescription medicines for humans and animals and many of the world's best-known consumer brands. Their innovative, value-added products improve the quality of life of people around the world and help them enjoy longer, healthier, and more productive lives. The company has three business segments: health care, animal health and consumer health care. Their products are available in more than 150 countries.PROJECT DESCRIPTION:Pfizer is building a data warehouse that will consolidate information from across all the countries in Europe and Canada. Pfizer is adhering to a phased implementation methodology that will ensure implementing the data warehousing solution across the different countries. The EuCan data warehouse, as it is called, will source data from disparate source systems that will include the Electronic Customer Management System (ECMS) in Siebel and Audited Sales (IMS) Statistics for Pfizer and the competitors. The data warehouse and the related schemas are built on Oracle 9i and the data integration layer is built using Ascential Data StageTRAINING ATTENTED:Entry Level Training Program for 2 months in Data Warehousing Technology.UNIXAttended training in Hyperion Tool.ENVIRONMENT:DataStage 7.5.2 (Designer, Manager, Director, Administrator) Server Edition,Oracle 10g, SQL, PL/SQL, Toad, UNIX,CVSPfizer EuCan W3 QUOTA-Scicon Core Team, Wave 3 - PfizerDurationSep 2007 to December 2007.TechnologyOracle 10g, Data StageProject AbstractThe project aims at providing users with advanced technical capability using centralized data warehouse. The project is expected to serve multiple countries in US, Canada and UK and has been divided into Waves for better manageability and implementation.This project was initially started with the U.K requirement in Wave 1&2.In Wave 3 several countries are added to the implementation in an incremental fashion.Pfizer EuCan W4 QUOTA- Core Team, Wave 4  PfizerClientPfizer Eucan DW, UKProject NameWave-4 QuotaProject PurposeEuCan DW is a centralized warehouse build for all European countries and Canada. The main goal is to have single central Warehouse system from there they can access all information pertaining to any applications like ECMS, IMS,QUOTA etc.Quota (Client-Server Based System) is a tool which is used to define/maintain Pfizer reps quotas and how each Pfizer District Manager. DW has to give the Quota tool input and also receives a feed from Quota tool. Quota relates to Quota setting process and Quota attainment reporting process .Quota setting process results in the calculation of Quotas/Objectives for Pfizer Sales Representatives. Quotas are set by each country for their field force at logical Selling Position level.Role PlayedDesigning, Developing and Testing, Aqua Reports.DurationDecember 2007 To September 2008.SoftwareOperating SystemWindows XPTechnologiesData StageServerUnixVersion Mgmt.CVSTeam Size5RESPONSIBILITIESAnalyze the business requirements, functional specification and technical specification.Involved in design and development of Validation Package for various countries and in creation of Aqua reports.Involved in tuning the queries within the oracle validation package to provide better performance.Successfully completed Unit Testing, System Testing and Business Testing and Regression Testing.Ensured the implementation and Quality process at each and every step of the project.Maintained version control using Win CVS.3. PROJECT NAME: Endeca Plan DashboardProject TitleEndeca Plan DashboardRoleTeam MemberDurationAugust 2008 to October 2009LocationChennai, IndiaHardwarePentiumOperating SystemsWindows XPDomainAnnuity,InsuranceDatabaseTeradataReporting ToolOBI(Oracle Business Intelligence)PROJECT DESCRIPTION:TIAA-CREF has engaged with Endecas Professional Services team in order to develop a pilot Plan Administrator application, based on a Proof-of-Concept (POC) produced in December, 2008, highlighting Endecas interactive search and analytics capabilities.The primary goal of this project is to rapidly deploy an interface similar to the POC into the TIAA-CREF environment, so that the application can be made available for demonstration purposes to a handful of select client institutions. The completion deadline for this project is September, 2009. Future phases are anticipated after a pilot with thirteen TIAA-CREF institutions.CLIENT DESCRIPTION:TIAA-CREF is one of the largest financial services companies in the United States, with more than $428 billion in assets under management as of June 30, 2007. Its approximately 15,000 institutional clients are drawn from the non-profit and educational sectors, and the company itself is operated on a not-for-profit basis.TIAA-CREF is headquartered in New York City and has major offices in Denver, Colorado; Charlotte, North Carolina and Dallas, Texas as well as 55 local offices throughout the U.S. Since 2002 its Chairman, President, and Chief Executive Officer has been Herbert M. Allison, Jr. TIAA-CREF ranks 80th on Fortune's list of the 500 largest corporations in America.TIAA-CREF was originally created to provide retirement income for professors, and its core business remains retirement plan administration and annuity products. It is by far the largest manager of so-called employer-sponsored 403(b) tax-sheltered annuity plans, a defined contribution retirement plan for employees of 501(c)(3) educational, religious, and charitable organizations.The company also offers 401(k) and 457 plans, Keogh plans, and Supplemental Retirement Plans. Contributions from these plans are typically invested in the company's traditional or variable annuities or its line of mutual funds.ROLES AND RESPONSIBILITIES IN THE PROJECT:Requirements gathering and analysis.Created SQL queries based on the requirement and as per the report Layout.Knowledge capture document on the products functionality.Understanding test traceability and coverage.Identified test scenarios for the DashboardDesign and execution of comprehensive Test Cases.Tested the bar graphs and charts present in the DashboardValidated the data by writing and running the SQL queries..Defect Management using Quality Center.Involved in driving calls with the onsite team members for test status updated on a daily basis during the testing phase.Responsible to communicate any issue/ concerns related to the release testing to the onsite/offshore lead coordinators.Involved in gathering test status from the testers group, raise alarm and escalate for any critical issues raised during the test cycle.TECHNOLOGIES USED IN THIS PROJECT:Microsoft Office: For maintaining the test cases, RTM and other status reports.Quality Center: To Track overall Test management, to view Test Cases, execute them and for logging defects.OBI: To generate reports.PROJECT NAME: Plan Reporting Future State WorkflowProject TitlePlan Reporting Future State WorkflowRoleTeam MemberDurationNovember 2009 to Febuarary 2010LocationChennai, IndiaHardwarePentiumOperating SystemsWindows XPDomainAnnuity,InsuranceDatabaseTeradataReporting ToolOBI(Oracle Business Intelligence)PROJECT DESCRIPTION:The Alternate Work flow Tool is used to validate reports, control the data, perform automated reconciliation process and automated distribution process .It automatically tracks reporting processes and provides management metric reporting. The objective of the project is to Support certified financial reports for 17,000 clients, to ensure that the Regulatory requirements are met and to provide Plan Reporting services.ROLES AND RESPONSIBILITIES IN THE PROJECT:Requirements gathering and analysis.Created SQL queries based on the requirement and as per the report Layout.Knowledge capture document on the products functionality.Understanding test traceability and coverage.Defect Management using Quality Center.Validated the data by writing and running the SQL queries