SUMMARY

• Accomplished and results driven professional with 10 plus years of professional experience worked as a Software Quality Engineer . QE in reviewing product requirements, reviewing designs, creating test plans test cases, review and tested the reports, demonstrated ability to communicate and work with co - workers at all levels
• Expertize in manual and Strong skills in automated testing of data analysis, ETL data testing, Big data testing web applications on Windows and UNIX operating systems.
• Ability to work on Agile, SDLC, Scrum and challenging environments with focus on product delivery. Be consistent and committed to Quality goals.
• Actively involved in various phases of testing life cycle such as data analysis (ROI), functional, non-functional, regression, integration, system and User acceptance testing (UAT).
• Have clear understanding and experience with Data warehousing and Business Intelligence concepts including OBIEE, Cognos 8 BI, SAP, Business Objects with emphasis on and life cycle development using (ETL)Informatica Power Center, Repository manager, Designer, Workflow Manager and Workflow Monitor, Data Stage.
• Experience in UNIX Sun Solaris, basic shell scripts, Dimension modeling, and data warehouse concepts.
• Experience with different software engineering methodologies (AGILE, Waterfall, Kanban).
• Strong SQL and NoSQL knowledge, including writing and executing queries to analyze data
• Performed Back-End testing to ensure data consistency on front-end by writing and executing the Complex SQL queries on database.
• Working and good hands on in BIG data technologies like Azure data lake, Spark, Hadoop, Hive, Google Cloud.
• Performed GAP analysis of business rules, business and system process flows, ensuring accuracy and deadlines were met. Interacted with business users to prepare and update Business process BPR and software system requirement SSR, created test cases and test scripts.
• Experience in processes consisting of data sourcing, data transformation, mapping, conversion and loading.
• Experience in mapping analysis, Test Plan, Test case preparation, test execution, defect reporting, and regression testing and final documentation.
• Wrote Automation in Scala/python in ETL end to end testing.

TECHNICAL SKILLS

Language: Core Java, SQL,, Python, Scala

Databases: Oracle10g 11g, DB2, Microsoft SQL server, MySQL, PL/SQL

Operating Systems/tools: Windows 95/98/NT/XP, UNIX, Linux, PuTTY Quality Center 9.5/10(ALM), JIRA, Bugzilla

PROFESSIONAL EXPERIENCE

Confidential, Emeryville, CA

Lead data Quality/Data Analyst

Responsibilities:

• Involved in tetsing new data model ETL testing (Facts/Dimensions) to support new ERP azur cloud/DAX, heavely used complex sql and python to automate all the sql manual test cases.
• Lead offshore team to support other project and involved in troubleshooting business tickets.
• Primary contact person for data quality on site, conducted meeting to review requirement and scope of testing.
• Created report which include all measures/KPI on Power BI to support business requirement. Conducted UAT and sign - off meeting with business and streamlined defects reports.

Environment: Putty, SQL Server, Azur cloud, Matillion, Snowflake, Power BI,D365,DAX Confidential Sr. Test Automation Engineer/Data Analyst Responsibilities:

• Reviewed project status and worked with product manager and delivery managers.
• Reviewed and corrected all the features and stories created by Product Manager, SA s and BA s.
• Worked as Data Analyst on few projects, managed project end - to end.
• Good exposure in GCP component, Airflow, Big Query, Scheduler, Composer, Data-proc.
• Developed automation framework (Scala, python) for End to End validation and Project code validation.
• Experience with databases and cloud storage such as Oracle, Db2, Azure Datalake, Google Cloud, MYSQL, HiveSqoop command Worked in Agile methodology and participated in pre inception, inception and Iteration process of projects.
• Performed and monitored various types of testing include functional testing, regression testing and system testing, Integration testing, end to end testing during different stages of Stella MCOM, BCOM testing application.
• Worked on different Integration, migration projects and other user experience projects across different teams.
• Experienced in testing of ETL and message queue workflows and workloads, including such tools as Apache Kafka.
• Worked in TIBCO EMS server and GEMS messaging layer, HIVE Hadoop Projects.
• Tested all the created data on MCOM ( Confidential .com), BCOM (Bolmindale.com) test application in different databases.
• Has been working on Teradata migration project to Google Cloud. Testing hundreds of tables every day.
• Working with application team on sign-off/showcase the test result. Coordinating with business, Development, offshore n day to day activity.
• Extensive Knowledge of running on Jenkins Continuous Integration Environment and Code push in GIT repository.
• Verified all the generated data in CSV files /Test files/Avro files with database and data dictionary.
• Performed Aggregation and loaded all the CSV files to the site databases with proper commands.
• Executed complex queries in SQL to validate the output in database.
• Excellent communication and interpersonal skills with problem solving abilities, effective in working independently and an exceptional team player.

Environment: Putty, SQL Developer, Jira, Test Link, Microsoft Excel 2007,UNIX, Cognos, Rest Console, Rest Client, Mozilla Firefox, Eclipse, Jenkins and Window, Data stage 11.3,Hadoop, Scala, Python, GCP(cloud), Version one, Jira, Hadoop, Hive, service now, Tableau, Power BI Confidential Sr. Quality Engineer Responsibilities:

• Participated in the requirement gathering of the various work streams by meeting with the Business user, base lining the details and documentation.
• Utilized advanced MS Excel and database design to create test cases in mapping process .
• Provided specifications and instructions for Operations team to build QA and stage environments.
• Translate the business rules from data mapping documents into SQL queries for validation.
• Involved and coordinated QA/UAT offshore team and supported production releases.
• Identify business requirements, develop test schedules, review testing plans, and track and document the development and results of these plans on SAP Module (Order/Billing/Management system).
• Tested and worked with the implementation of Content Management Systems (Oracle site studio)on Confidential Support site
• Tested mapping in Informatica to load the data from various sources into Data ware house using different transformations like Joiner, Aggregator, Update Strategy, Rank, Lookup, sequence Generator, Sorter, Source Qualifier.
• Worked as a Production and acceptance tester, who was responsible for accepting and raising incidents.
• Responsible as onsite QA lead, did bug-reporting, follow up and tracking. Involved in coordination with off-shore team, and managing team.
• Experience in testing and writing various reports and Validation of the data by using SQL queries.
• Functional testing of front-end web application user interface, including verification of layout, metadata, browser compatibility, on-screen calculations, error handling, navigation.
• Experienced at ETL and flat file data transfer validation, the data mapping from Source to Target and validate report using OBIEE tool
• Testing ETL sessions and UNIX scripts in data warehouse applications.
• Monitored and tested the Informatica workflows using Power Centre monitor, Session log files .
• Tested Content Management Database on Oracle site studio and Ominature Debugger to analyse the web site.
• Tested Support Site Order status, Technical Assistance, Software Downloads, Product Documentation, User Registration, and Exception License Delivery applications.
• Collaborated with the analysts and developers in testing the customer reported issues in Production.
• Worked in releases for every 2 months with bug fixing.

Environment: SAP module, ALM, HP Quality centre(QC) 11.0, ETL/informatica 9.0, Si te Catalyst (CMS), Window, Linux, J2EE, oracle site studio.