Software Test Engineer with progressive experience in ensuring Quality Data Systems. Focused experience in Business Intelligence (Database, ETL, OLAP, Data warehouse & Reporting) Projects. Quick learner with strong communication skills and high level of motivation
Environment: SQL Server Integration Services (SSIS) 2012, SQL Server Management studio, Oracle 11g, IBM Cognos Business Intelligence, CA Agile central, TFG Mainframe.
Description: Currently working as an ETL Tester to test the Data Warehouse of Western Reserve Group, which is a Property & Casualty insurer who is upgrading their Legacy Systems to Guide wire.
Environment: Informatica 8.6.1/9.1, SAP Business Objects , Oracle 11g, SQL, PL/SQL, UNIX, Shell Scripting, Microsoft SQL Server 2008, Control Version System, Data Center Manager, TOAD, Quality Center 10.0, Agile, Scrum, Abinito.
Description: Capital One is the Group's brand for a branchless direct bank. Its products include savings accounts, tax-free savings accounts (TFSAs) mortgages, retirement savings plans (RSPs), guaranteed investments (GICs), mutual funds, business accounts and no-fee daily checking accounts. Worked on different Projects like Home loans life cycle (measures the overall life of the loans from opening to funding), Money Saving Account (mapped related attributes into data warehouse), Mortgage Service Platform) conversion of Purchase loans into existing MSP Platform.
Environment: Datastage 9.1, Oracle 11g/10g, SQL, OLAP, PL/SQL, UNIX, Java, HTML, HP Quality Center 9.2.
Description: Citizens Bank, through its subsidiaries, provides retail, commercial, and corporate banking services principally in the United States. The company operates through three segments: Community Banking; Wholesale Banking; and Wealth, Brokerage, and Retirement. Plan sponsors are being reminded of their fiduciary responsibility to accurately determine and evaluate their plan fees. because of the multiple providers involved and the various ways fees are assessed, it can sometimes be difficult to determine who is receiving how much, and for which services, yet that information is necessary to determine if plan costs are fair and reasonable. Expense Project is based on calculating expenses over maintaining different retirement plans. It involves calculation of different Itemized, participant based and Asset based fees calculation and their distribution over the different retirement plans (FTE, FTE-Related, and Non-FTE).
Environment: Datastage 8.5, Oracle 10g, SQL, OLAP, PL/SQL, UNIX, Java, HTML, XML, Windows, DB2,HP Quality Center 9.1,Microstrategy,FTP.
Description: EmblemHealth, Inc., through its companies Group Health Incorporated (GHI) and HIP Health Plan of New York (HIP) provides affordable, quality health care coverage and administrative services to approximately 2.8 million people. Groups and individuals can choose from a variety of PPO, EPO and HMO programs as well as prescription drug, dental and vision plans. The project goal is to create data mart for analysis of current information on various Health Plans & doctors listed under these plans.
Companies Worked For:
Job Titles Held: