Engineer Electrical
Resume:
DENNIS ROSHAN RICHARD
******.******@*****.***
Objective
To obtain a position as Software Quality Assurance Analyst that provides
challenging career opportunity to utilize my prior experience and
prospects to enhance my skills and grow in the organization.
Technical Skills
Programming Languages: C, C++, Oracle SQL, PL SQL, T-SQL, UNIX Shell
Scripting
Assembly Languages: Intel MCS-51, PIC 16f877, TI - DSPTMS370
Processors Families: Intel 8085, Intel 8086, Intel 8051 Micro-controller,
PIC 16F877, TMS370C6713, TMS470-32bit RISC ARM7TDMI
Platforms: DOS, UNIX, Linux, Microsoft Windows 95/98/NT/2000/XP/Vista
Design & Simulation Tools: Code Composer Studio, IAR Systems, IAR
Embedded Software, Spice, MATLAB, KiCAD
ETL Tools: Informatica - PowerCenter 6.2, PowerMart 4.7
Testing Tools: Quality Center10.0, Microsoft Team Foundation Server 2008
Admin Tools: Microsoft Team Foundation Server 2008, Oracle BI Admin tool
(OBIEE) 10.1
Database Configuration/Management/Admin Tools: SQL Developer 3.0, TOAD
9.0, Microsoft SQL Server Management Studio 2008R2, Microsoft Access 2010
RDBMS: Oracle 9i/10g/11g, Microsoft SQL Server 2008R1/2008R2, Teradata
13.0
Reporting Tools: Oracle Business Intelligence Enterprise Edition 11g
(OBIEE), Business Objects XIR3, SSRS
Professional Experience
IT America Inc, Edison, NJ, November 2011 - Present
QA Analyst Test Engineer
. Developed complex SQL scripts using inner joins and outer joins and
sub queries.
. Worked on UNIX platform to validate the flat files.
. Actively involved in Backend Testing and data analysis.
. Involved in the preparation of Test Strategy & Test Cases in
Quality Center.
. Actively involved in Functional Testing, Regression Testing.
. Executed all the Test Cases in Quality Center with
Pass/Fail/Blocked status.
. Developed UNIX shell scripting and PL SQL scripts for different
environments.
Environment: TOAD 9.0, T-SQL, Business Objects XI R3, Oracle 9i/10g, SQL
Server 2008, Quality Center 9.0, LINUX(Red Hat 4.0) UNIX
Projects:
Fallon Community Health Plan, Worcester, MA October 2012 - Present
EDW Redesign Project
QA Analyst Test Engineer
. Analyzing the data mapping specifications, business
requirements for creating Test Cases in Quality Center.
. Preparation of Test Plan, Test Strategy, Test Cases.
. Executing packages to load data into the ODS and STAGEIN and
EDW databases.
. Developing complex T-SQL queries to validate the different
target tables.
. Interacting with Business Analyst for the fixes in mapping
documents.
. Performing the quality check of entrance and exit criteria as
appropriate before proceeding into the next phase.
. Actively involved in package execution and monitoring the
package execution process.
. Executing 100% of the Test Cases with Pass/Fail/Block status.
. Tracking the defects encountered during testing various
modules of the application.
. Interacting with the Business for User Acceptance testing.
. Coordinated testing throughout ODS and EDW systems.
. Developing complex T-SQL Scripts using complex JOINS on
different source tables.
. Developed Business scenarios as per Business requirements.
. Worked on different tracks of the project in completing the
deliverables for the project.
. Worked and co-ordinated with offshore team in achieving the
goals of projects in different tracks of the project.
. Analyzed data in order to build and create queries for the
business UAT scenarios.
. Co-ordinated Integration testing with different tracks of the
project.
Environment: Microsoft SQL Server Management Studio 2008R2, T-SQL,
SQL Server 2008, Microsoft Team Foundation Server(TFS) 2008, Quality
Center 10.0, Microsoft Visual Studio 2008, Oracle11gR2, Microsoft
Access 2010
Starbucks Coffee Company, Seattle, WA April 2012 - September 2012
Supply Chain Optimization
QA Analyst Test Engineer
. Analyzed business requirements, developed Test Cases using
Microsoft Team Foundation Server.
. Developed complex queries to test the reports developed using
SQL developer.
. Validate the OBIEE reports and involved in RPD deployments.
. Performed Transformation Verification, Validation on the
Input data before loading into target database.
. Actively involved in interacting with developers for the Bug
Fixes and Problem resolution.
. Tested the reports with Drilldowns, Drill Up and Pivot
reports options generated from OBIEE.
. Actively involved in creating deployment plan and executing
the deployment plan.
. In charge of CERT environment in order to deploy the SQL
scripts and packages and procedures.
. Altered SSRS parameters for Burndown and BurnRate charts to
reflect current sprint data.
. Performed front-end testing on OBIEE Executive Dashboard
portal.
. Created complex SQL queries to validate the initial and
incremental ETL loads.
. Interacted with Users to understand the bugs in Business
Reports generated from OBIEE.
. Used Inner join, Outer Join, MINUS operations and CASE
statements in SQL scripts.
. Actively involved in creating deployment plan and executing
the deployment plan.
. Created QA official sign off document for each sprint.
Environment: SQL Developer 3.0, Oracle BI Admin tool (OBIEE) 10.1,
Oracle 10g/11g, Microsoft Team Foundation Server (TFS) 2008, SQL
Server 2005, Oracle Enterprise Manger Fusion Middleware Control 11g,
Microsoft Visual Studio 2008, Oracle Business Intelligence Enterprise
Edition 11g (OBIEE)
Mentis Solutions Inc, Woodbridge, NJ, September 2010 - October 2010,
Web Logic Admin
. Installed, administered, configured BEA Web Logic Servers in
clustered and non clustered environments.
. Deployed & Configured HTML and JAVA scripts on Oracle Web Logic
Servers.
. Configured JDBC connection pools and data sources.
Environment: JDK1.4, WinNT, JDBC, Oracle9i, WebLogic Server 9.2/8.0, HP-
UX, Apache web server, Linux.
Xentaur Corporation, Yaphank, NY November 2010 - August 2011
Electrical Engineer
. Enhanced Pandora reliability fixes.
. Built test setup for the Athena and the Vortex boards. Performed
the testing of the Vortex and Athena (using MODBUS RTU).
. Installed WIM software Vortex and Athena boards. Troubleshooting
boot priority on the Athena and the Vortex. Developed pressure
sensor circuit and temperature circuit and the battery charging
circuit.
. Audited NEC processors using a test fixture.
. Installed WIM firmware on the embedded chip of Vortex and Athena
motherboards and make a system disk.
. Released schematics using KiCAD software.
Academic Project
Department of Electrical Engineering, NYU-Poly, Brooklyn, NY, September
2008 - November 2010
Multi Cooperative Autonomous Mobile Robotic Agents
Research & Graduate Assistant
. Established the communication between the DSP and the computer by
configuring the I/O ports (RS-232) on the DSP.
. Performed the testing and analysis of data flow from the DSP to the
PC.
. Programmed the DSP in C to configure various parameters in the
chip.
. Tested for functionality, the various sensor components (such as
encoder, ultrasonic & magnetometer) on the Robot.
. Developed the sensor interface by designing the support circuitry
to the DSP processor (DSP470R1B1M).
. Performed the Simulation of kinematics and dynamics in MATLAB.
. Generated a PWM wave to drive motors by programming the DSP.
. Configured the I/O ports of the DSP using IAR embedded software.
Education
Master of Business Administration in Information Technology (Anticipated
Graduation: December - 2014)
Goldey Beacom College, Wilmington, Delaware, USA
Master of Science in Electrical Engineering (Graduation: May - 2010)
Polytechnic Institute of New York University, Brooklyn, New York, USA
Bachelor of Engineering, Electronics & Communications Engineering (May -
2007)
Visveswaraiah Technological University, Bangalore, Karnataka, INDIA.
Contact this candidate