| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name PHONE NUMBER AVAILABLEEMAIL AVAILABLEOBJECTIVEHighly motivated and a compassionate individual seeking for a challenging position as a Software Business Analyst/ Data Analyst to grow as an individual and become an asset to the company.PROFESSIONAL SUMMARYOver 20 years of extensive IT experience in Business, Data Analysis and Software Quality Assurance Testing with Mobile, Connected Vehicles, Client Server, Web based and ERP (Financial & Supply Chain) applications using:Big Query, Hadoop (HQL)Java & VB (.Net)SAP R/3(MM/SD/PP)Oracle Financials 11i (AP, AR, GL, FA)Peoplesoft & WINSOL5 Years of Hands-on experience in Data Analytics using Google Cloud Platform components like Big Query, Cloud SQL & BIG Data ecosystem components like Hadoop, Hue, Oozie, Hive & Pyspark and Involved in developing dash boards using QlikView and Transformed the data from Hadoop source system to target using Informatica and data profiling and data analysis using Alteryx.Worked closely with the Product Owners, Product Managers, Product Designers, and team to work on user stories.Participated in various phases of Testing Life Cycle on GL, AP, AR, CM, INV, AM, MM and OM Modules of SAP, Oracle Applications, PeopleSoft, WinsolDeveloped manual/automated unit tests to confirm functionality for both functional and non-functional requirements.Experience in developing BRD (Business Review), TSD (Technical Specification), Test Strategy, Test Plan, Test Scenarios, Test Case & Traceability matrix documentsExperienced in Manual Testing, Data warehouse Testing and Automated Testing Tools.Performed different types of Tests like SmokeTest, White Box, Black box, Integration, Stress, System, Backend, Volume, Load, Performance, Functional, Regression & UATExtensive experience in SDLC & STLC involving in various stages from Requirements Analysis to Test Cycle Closure and deployment to production.Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) beginning from requirement specification to deployment and support.Wrote functional tests to confirm user story acceptance and to detect regression defects.SKILLSStrong analytical ability, effective problem solving and decision-making skills.Has ability to learn new technologies and apply them.Positive team attitude, able to take initiative & originate new ideas.Good interpersonal and communication skills, both verbal and written.Commitment towards work and willingness to take up additional responsibilities.Share knowledge among the team members, helped and guided when needed.EDUCATIONBS in EngineeringMasters in Information SystemsCERTIFICATESCertified Scrum Master from Scrum AllianceGoogle Cloud Big Data and Machine Learning FundamentalsGoogle Cloud Fundamentals- Core InfrastructureModernizing Data Lakes and Data Warehouses with Google CloudCertified in Perfecto Overview, Manual & Mobile AutomationCertificate in Oracle 11i General LedgerCertificate of Appreciation to the GOTD program for OPSS application in Ford Motor CompanyCertificate of Appreciation to the launch of release 4 in Connected Vehicle, Ford Motor CompanyTRAININGSLearnt Machine Learning Language using R-StudioLearnt BigQuery, Cloud SQLLearnt Hadoop (Hue, Oozie, Hive, Pyspark)Learnt QlikView, Alteryx, Python, Informatica, Tableau, Power BITECHNICAL SKILLS:ERP:Oracle Financials Release 11.0.3/11i (GL, AP, AR, CM, Inventory, OM, AM, AOL, SYS ADMIN), SAP 10.7 (MM, SD, PP), Winsol (4.0.3), People Soft 8.9/9.1 (AP, GL)Big Data Ecosystem: Data Warehouse:GCP (Big Query), Hadoop, Hive, Oozie, QlikView, Alteryx, Python, R, DB2, SQL Server, STAR, Micro Strategy, InformaticaLanguages:SQL, PL/SQL, C, Java (Servlets, JSP), VB (.Net), ASP, VB ScriptGUI/tools:Developer2000 (Oracle Forms 4.5, Oracle Reports 2.5,OracleGraphics 2.5), Discoverer 4i. Toad, Azure, Mobile (iOS, Android)Oracle Tools:SQL* Plus, SQL* Loader, Workflow Builder 2.62RDBMS:Oracle11g, 7.x/8.x, MS Access, MS SQL Server 7.0/2005/2008, DB2Operating Systems:UNIX (Sun Solaris), Linux, Windows 95/98, 2000, Windows NT, XP, MS-DOS, IBM MainframeInternet Tech:HTML, XML. Microsoft Visio, ProjectTesting Tools:Load RunnerPHONE NUMBER AVAILABLE,Test Director, Jira, HP QC (10, 11), SOAP UIPROFESSIONAL TECHNICAL EXPERIENCE:Ford Motor Company, Dearborn, MI, USA: Mar-2014 to Oct-2024Data Analyst/ Business AnalystFord Motor Company is one of the major Big 3 Motor Companies and has plants worldwide. Maintains great quality from design and manufactures to sales and service.Projects:Build and enhancement of Connected Vehicle Echo System data products using GCP (Big Query) & (Hadoop (Big Data))Integration testing of Echo system products including Load & PerformanceFord Pass (Android, iOS)EV (Electric Vehicle)WIG (Wi-fi Gate Way)IoT Hub MigrationIntegration Validation Testing-GOTD (OMCC, CVOS, OBM, ESB, SI, OMS/SOB, GForce, OGMF, SAP (CRM), GOE, GTS)WAS 8.0 MigrationOPSS (Order Production Scheduling & Sequencing)SVS System Algorithm OptimizationResponsibilities:Involved in data migration from On-Prem systems to GCP (Google Cloud Platform)SME for data products such as Strategy Part Number, Master Vin Summary & Vehicle Meta Info.Developed and administered SCA-V data operations mobility portalInvolved in GitHub administrator activity/rolesDeveloped Business/technical review documents and UAT specification documentsInvolved in new data product implementation, Migration and feature enhancement projectsTransformed the data from Hadoop source system to target using Informatica and productionized the product for the downstream systems consumptionInvolved in data profiling and data analysis using AlteryxDeveloped dashboard for the Distinct Vin Authorized Vin count by Month, Vehicle Volume analysis, VSDN Prod Growth Graph, TPS, Daily/Hourly Trend and Message type (Connection Status, Vehicle Health Data, Vehicle Position, Motive Mode begin/end, Remote start begin/end, Ignition on/off and periodic vehicle data) using QlikViewCreated Test Scenarios, Test Cases and Defect Summary StatusPerformed test data setups in QA & UAT for NA, EU, AP regions.Involved in end user and production supportEnv: GCP (Big Query), Hadoop (HQL, Hive), Informatica, Alteryx, Tableau, QlikViewLoad & Performance Test Lead:Coordinating work and ensuring timely and high-quality delivery of the performance testing and engineering activities by the offshore team.Conducting meeting with technical architects and project managers for understanding, discussing and reporting the issues and tracking the progress of the sprints/different stages of the project.Developing Web protocol test scripts using HP Load Runner PHONE NUMBER AVAILABLE and testing of web services through PostmanExecuted Load, Stress tests to check applications for response time and bottlenecks.Monitoring the System performance of the server using Performance Monitoring tools like Dynatrace/Pivotal Cloud App Manager.For deep down analysis of the response time break down across different layers and to identify bottleneck areas, Super Simulator server logs are downloaded through the use of MS SQL queries and stored procedures. The response times across different components are analyzed, and root cause and pain areas are highlighted to the Dev team for further troubleshooting and resolution.Analyzed test results sharing with project team (developers, architects and delivery leads).Involving in the Performance Engineering Activities like results analysis, CPU - Memory - Thread Analysis, Root Cause Analysis.Created Mobile (Android & iOS) scripts in PerfectoEnv: Load Runner, Dynatrace, PerfectoIntegration Test Lead:Performed test data setups for end to end EV testing features for NA, EU, APValidate the completeness & accuracy of the scheduled, unscheduled orders, reason codes, and various counts from scheduling run that meets Op Plan required volumesPerformed Data setup for the PLC constraints and scheduled more dealer priority orders and provided transportation cost savingsCreated Order sequencing by creating profile set, importing into Optessa, assigning rotation#, pre-assignment sets, sequencing rules then approve and commit runset.Performed required volume calculation (RV) for different VL (Superduty,Expedition etc)Performed end-to-end testing for the US, Canada, Mexico and Lincoln China marketsVerify in GF& GZ Flow that Moved an Unscheduled order to a Scheduled state and Scheduled Order state is progressed to another Scheduled StateAmending the order with a duplicate Item number- expected -the order should be updated with the Item number sent by OMSCreate Mapping between the market and the WERS market code (WSPAD) for different model year (2016) and vehicle lines (MKZ, MKX, MKC, Navigator).Involved in build & deployment process to QA, Pre-Prod and Prod using Jenkins (CICD)Env: Agile Methodology, Java, SQL Server, SOAP UI, TDK, FTCP, CAN Bus, Azure, Carrier Simulator, Postman, MultiComm, DET, CVFMA, CVFTA, NGSDN, TCU, GIVIS, TCU, CDR, SYNC, CONTI,FB2, FB4, HMI, Mobile (Android, iOS, Perfecto), Jenkins (2.164.3)Erie Insurance, Erie, USA Oct13 Dec13Software AnalystErie Insurance offers a range of services to meet family insurance needs, including a variety of home and tenant (renters) insurance policies and boat Insurance Erie Family Life offers a complete line of products to meet individual and business life insurance needs.Responsibilities:1099 CCR (Credit Card Reversal) Payment Processing & Premium Receivables:Created single, multiple vouchers, single line, multiple & mixed lines---single payment- post withholding activityrun the custom process and validate that payment would be created for voucher and review withholding, payment tables to determine if the correct paid amount captured.Void-Re-Open/Re-Issue Voucher-Pay voucher, post payment, post withholding- run the custom process and validate that payment would be created for vouchers and review that withholding, payment tables to determine if the correct paid amount capturedVerify that count of policies, premium should match between 2 files at the Master Company, policy number and policy module levels and verify that current premium of PMS and Premium master files balance when ACCOUNT-ENTER-Month-ENTEREDEnv: PeopleSoft (9.1) (General Ledger, Accounts Payable), IBM Mainframe (Z/OS 1.6), Oracle (11g), ACR, Java, SQL Developer (3.0.2), SQLRogers, Brampton, Canada Feb13 Sept13Software UAT AnalystCanada's telecommunications leader, keep everyone informed, connected and entertained, with our exciting array of products and services.Maestro Application:Developed UAT Test plans on the basis of BRD and DSD and Involved in Test execution process for UAT & Regression of the Maestro Program Release 0713.Developed SQL statements to validate the successful execution of a single/multiple iteration of the script on different databases such as CRMPET, ABP PET, OMS PETCreated Service Order tickets and created Miscellaneous Orders from CRMCreated Search Payments, Add Authorized Contact, Change Case Status, Search Contact and Service Order ticket, CC9 B2B Link, New Identifier, Change Case status and tested address sharing issue via Web services using SOAP UIEnv: CRM, OMS, EIF, WOM, OBI, V21, SOAP UI (4.5.1), XML, Java, Oracle (10), CQ (7.1.2.4), HP QC (ALM), TOAD, SQL, Agile Test.Amerisource Bergen Corporation, Mississauga, Canada, Sept 11 Jan 13Software AnalystABCC is a leading pharmaceutical services provider focused on supply chain including drug distribution, technology solutions for pharmaceutical and health care community.Project: Flyer & Promotions (Web Site & ERP based Applications):Initiated Quality Assurance Standards, Processes and methodologies in the organizationTested Web services against various modules of ABBC Website - Security Verification, Pre-book catalog calls, and Pre-book Order confirmations against specific PO.Tested web reporting functionality for user defined and standard reports for web services calls.Created Pre-book, Replenish and Forecast Orders for the Promo and Non-Promo items and validated the Pre-book, Replenish Orders pricing.Setup Customers, Sponsors, Groups and tested Promotion Order release schedule option.Created Forecast order for all Alternate Whses and not for exempted Whse of Alternate Whse and verified OEZ1 Cancels promo orders that have reached their cancellation date.Verified email Confirmations for Pre-book and Replenish Orders as configured in SU13Validated Terms by WHSE Split (Alt Whse), different zones for Promo and Non-Promo Items for Pre-book and Replenishment OrdersTested Android and Mobile devices by creating Purchase and Sales Orders using Scanner.Env: SAP Supply Chain (MM, SD), Winsol (WMS), Web Services, SQL Server, SQL, HP Quality Center (ALM), Web Logic, MDM, Java, ASP.Net, Agile407 ETR Concession Company, Toronto, Canada Jun 11 Sept 11Software ERP Analyst407 ETR is the worlds first all-electronic open access toll highway which extends 108 kilometres east-west, just north of Toronto. 407 ETR benefits all users with a barrier free system so anyone.Responsibilities:Involved in requirements gathering, analysis, documentation, maintain traceability, serve as a liaison between technical development teams and non-technical stakeholders and Participated in the quality assurance process by reviewing and validating functionality against requirementsCollaborate with quality assurance teams to design test cases, scenarios, and test plans based on documented requirements and Manage and document changes to project scope, requirements, and priorities, ensuring transparency and minimal project disruption.Tested depreciation for certain assets that depreciate based on usage (VKT, Revenue)Tested an asset through Asset Basic/Express Information with new Depreciation Method.Tested Fully/partially retire an asset with no proceeds with new Depreciation Method.Calculated depreciation value for an asset with multiple additions e.g. Jan, Mar, Apr and Prepared SQL Queries to identify assets within environment that meet each test caseTested Asset addition through Accounts Payable (AP) and verified accounting entries generated in GL through AM and assets through AP through AM.Env: PeopleSoft (8.9) (General Ledger, Asset Management, Accounts Payable), IBM Mainframe (Z/OS 1.6), DB2 (8.2), Test Link, Mantis, Toad (2.7)BMO (Davis + Henderson), Toronto, Canada Feb11Mar11Software UAT AnalystBMO Bank of Montreal and Davis Henderson, a leading solutions provider to the Canadian financial services industry.Project: BMO Retail Client Implementations (Web Site Changes):To provide a more seamless and efficient process to replace the current manual flow with fax and emailCreated the Master UAT test plan for the Web site changes projectPrepared the detail test cases on the basis of Functional requirement document.Provided QA estimates for the management and involved in peer review process.Performed walk through meetings with business, developers, Project management teamInvolved in test execution process, test results review and test status meetingsConducted meetings to ensure the tasks are delivered on time and co-ordinated tests among teamInvolved in maintaining test cases in QC and defect management processEnv: Java, SQL Server 2008, SQL, SQL Navigator, HP Quality CentreAEGON, Canada Jan 09 Dec10Software AnalystAEGON Canada Inc. provider of life insurance, Property & Casualty, Health Insurance, RRSP, guaranteed investments, segregated funds, Mutual Funds and offers investment solutions through imaxxFunds.Responsibilities:Worked on various projects such as HST, Fusion, IFRS, and TGIF. Financial System UpgradePerformed Functional, UAT, System, Regression and Integration testing with JDE and KhalixConducted the Test Plan, Test Case, Test Results and Defect Triage review meetings.Created the Testing Analysis Summary Report, Purchase Order, Voucher entry, review the exemption codes for ON, BC, NS, NB, NLVerify the Tax rate allocation such as HST, GST, PST, QST applied to Purchase Orders and ensure that it does not affect the existing and closed PO.Made sure that reports (RBC Wire summary & GIC Fund movement) will read this table and allocate the appropriate amounts and allocation of direct investments and fund on fund investments within mixed investment fundsVerify that Journal entries sent to JDE and UL statements and reports are generated.Pre-Pared Requirement Traceability Matrix by working closely with Business Analysts.Created and Modified UNIX Shell Script for the file Extraction and imported the file from Unitrax, Lifetrax server to JD Edwards financial systemInvolved in daily exceptions item processing reports including incoming and outgoing returns,Verified the Customer profiles and verified Items that have been deposited twice are charged back against depositor accounts and the required substitute checks, customer notices, applicable feesEnv: Oracle Apps 11i (GL, AP, AR, Procurement), Unitrax, Lifetrax, PATS, ReCon++, SQL Server 2008, HP QC (10.0), SQL, Java, Linux, Shell Script, DB2, AS400Honda Finance, Canada Feb08- Dec08Team Co-OrdinatorHonda Financial Services, goal is to help to lease or finance the Honda VehiclesProject: My Acura, My Honda & Finance Website:Developed (BRD, DSD, FRD) based on System Use Cases, Activity diagrams, User Interface Specifications),Functional, Integration, System, UAT and Regression test plans, test casesConducted meetings with team members to collect test dependencies & scripts.Assigned the tasks to the team and scheduled the execution of the test scripts.Organized the defect management & status meetings among different groups.Performed the defect analysis and generated the reports for the management.Used SQL Queries to verify the data from the database.Env: VB (.Net), SQL Server 2005, IBM Main Frame, DB2, SQL, Quality Centre, AgileInvestors Group, Winnipeg, Canada Sept 07 Dec07Software QA LeadIG Wealth Management is a Canadian leader in providing personal financial products and services, and is dedicated to building lasting client relationshipsDeveloped (BRD, DSD, FRD) based on System Use Cases, Activity diagrams, User Interface Specifications),Functional, Integration, UAT and Regression test plans, test casesCreated Traceability matrix for Disaster Recovery Testing and reported defects in HP QCCreated customer master, customer number range and assign to customer account groupsCreate partner stock and verified material stock, customer material info record,Created and verified Inquiry, Quotation, Sales Order, Credit and Debit Memo, Sales type documentVerified by creating shipping point, picking, packing, returns, free of charge &sub-sequent delivery.Verified Consignment process(Consignment fill-up, consignment issue, return, consignment pickup)Create bill of materials, correct invoice, defining item category, billing blocking reasonsTested pricing by item category, involved in testing tax calculation proceduresTested item categories, create accounting key, create quotations, post goods receiptCreate chart of account, GL account, and post to GL, opening and closing periods.Create vendor master data, one time vendor, purchase invoice postingTested various reports such as GL account list and balances, AR customer balances, AR customer line items, AR customer payment history, AP vendor balances and line items.Env: SAP (MM, SD, FI/CO), Oracle 10g, SQL, HP Quality CentreDell, Texas, USA Feb 07 June 07Software ERP AnalystDell is a multinational technology company specializing in the development and sale of computers, laptops, servers etc.Reviewed requirement documentation (BRD, DSD, FRD,Developed System, UAT and Regression Test plans on the basis of BRD and DSDDocumented the test scripts and detailed defect reports in HP QCCreated, applied and reversal of Manual Receipts in ARCreated Transactions, Customers, Invoices, Customer Profiles, Misc.Cash ReceiptsCreated Account Code Combinations, Manual JE and post JEInvolved in testing the Secure Approval Transmission Application verifying IT Administrator, Payroll Administrator roles, approvals for reviewers and sendersGenerated and verified Account analysis, Accounts Payable, Accounts Receivables, Journals general, Trial balance details, Journals voucher reports, General Ledger, Chart of accounts, Budget, Average Balance Audit, Summary detail budget reports.Analyzed test results (Pass/Fail Criteria) and reported defectsEnv: Oracle 11i (AP, AR, GL), Oracle 8iMercer HR Consulting, Toronto, Canada May05-Nov06Software AnalystProvides services on HR and related financial advice and services. Retirement, Health Care & Benefits, Investment Consulting, Property & Casualty, Payroll and Global Investments.Project: Web Time Entry SystemDeveloped (BRD, DSD, FRD) based on System Use Cases, Activity diagrams, User Interface Specifications),Functional, Integration, System, UAT and Regression test plans, test casesCreated Traceability matrix for Disaster Recovery Testing and reported defects in HP QCCreated/Define Responsibility, profile options, Users, Suppliers, Invoices, Payments, Payment Formats, Payment Terms and created Transactions, Customers, Invoices, Customer Profiles, Misc Cash Receipts and define Aging buckets, Auto Lock Box and executed Revenue RecognitionVerify that AR Aged Trial Balance Report (unapplied, on account) for all customersVerified the various reports such as AR Salesperson, Outstanding Debtors Listing reportWorked on Report Writer and generated custom Reports (Employee, Payroll, Audit, Performance).Loading of Bank statements into Oracle Financials and verifying Bank statement interface table and comparing transactions with production system and test systemSetup notifications of items & modified business rules using Workflow in WFbuilder.Tested and verified the Sub Inventory, Inter Org transfers and Re-Order point planningTested the Order Entry, Schedule Order, Returns, Shipping Transactions (Pick release, Ship Confirm) and various reports (Shipper, Invoice and Bill of Loading Reports)Env: Oracle 11i (AP, AR, GL, OM, Inventory, Procurement), Java, Oracle 8i, SQL* Loader, SOX, Workflow 2.62, SQL, HP QC (10)Loyalty Group, Toronto, Canada Jan05-Feb05Data warehouse QA AnalystProject is about Air Miles Rewards Program, analyze each and independent Customer usage.Responsibilities:Created and Built Segments, Metrics and Lists (12 Char, UPC) in STAR applicationWorked with various SSOLTC, Collector Attribute, Collector Behaviour, Tbase, Redeem, Segment Expirations, Mega Cube reports and analyzed results with Database and Prepared SQL queries to retrieve data from DB2 database and compared with STAR generated results.Wrote complex SQL queries and performed testing for the Transaction data Validation reports on SQL Data warehouse and master data from source systemsCreated test plans, test cases and methods for daily activities.Performed end-to-end defects testing and submitted the bug report.Analyzed test results (Pass/Fail Criteria) and reported defects in Test DirectorCreated business scenarios in Micro Strategy and ran them through Various Reports.Env: SQL, ETL, DB2, SQL Server 7.0, STAR, Micro Strategy, Data Junction, Data MiningADP, Toronto, Canada Aug04-Oct04Software ERP AnalystProvides a range of Payroll services and Human Resources systems to organizations of any size.Payroll System: (Migration from Oracle Financials 11.0.3 to 11i)Generated reports for Credit Process for Autopay and Paytech clientsScheduled batch jobs in AS400 and extracted the file and interfaced into Oracle Financial systemCreated, applied and reversal of Manual Receipts in ARVerified Credit Tier Management Report, Over Threshold Report, Data and Time Exception Report, Outstanding Employee Checks Report, Summary of Unpaid Tax Invoices by Control Report, Client Payroll Submission Pattern Report, Funding Exception Report and Billing and Receipts History Report under the 11.0.3/11i.Performed transactions in AP and AR (Invoices/Payments,Transactions,Receipts and Customers)Scheduled Autopay and Paytech Wraps and Generated WRAP Balance ReportsCreated & Confirmed Payment Batches and Validated the AR Transactions, AP invoicesCreated Credit Memos, Debit Memos, Invoices and Receipts and applying to InvoicesEnv: Oracle Fin 11i/11.0.3 (AP, AR, GL), AS400, DB2, Test Director, JAVA (1.1), Web Logic, Oracle7.1Codify Inc, CA, USA Jan01-Jan02Software EngineerInventory Management:Process of managing inventories from raw materials to finished products and maintain customers order info and generate invoices and send to shipping areaDeveloped and maintained web pages for planning and forecasting, purchasing & ordering, receiving, storing, inventory tracking, packing and shippingEnv: Java, JSP, SQL,OracleBIT Tech, CA, USA Mar00-Dec00Software EngineerWarehouse: Provide info of nearest repair center to the customerMaintain customer info with purchase details such as warranty, extended warranty, expiration dateSend the alerts to the customer when the warranty gets expires and find the nearest contact info if customer needs items to be repairedEnv: Java, JSP, SQL, SQL Server 7.0/8.0 |
