Engineer Software Developer

Urvashi Bhatia

Charlotte, NC adb3r9@r.postjobfree.com (704) 775 - 8427

SUMMARY:

Software Developer (ETL) / SDET / QA Engineer with more than five years of professional experience along with a Bachelor of Science in Computer Engineering. Open to entry-level roles in order to build recent experience and learn new/modern technologies.

** Authorized to work in the U.S. for any employer without sponsorship. **

TECHNICAL SKILLS:

Testing Tools

Selenium WebDriver/IDE/GRID, HP Quality Center/ALM, SOAP UI, POSTMAN

Languages

PL/SQL, Java, JavaScript, HTML, XML

Application Tools

Informatica Power Centre, IDQ, Eclipse, Toad, SQL Navigator, Putty, Jira, SQL Loader, Ab Initio.

Schedulers

Jenkins, Operational Console, AutoSys

Bug Tracking Tools

JIRA, HP Quality Center, Visual Studio TFS

Databases

PL/SQL, Oracle, MySQL, Teradata SQL Assistant (DB2)

Platforms

Windows, UNIX, LINUX, Sun Solaris, Mac OSX, iOS, Android

PROFESSIONAL EXPERIENCE

Accenture July 2009 – October 2014

Citibank Singapore Senior QA Automation Engineer (2013 – 2014)

●Created automation test scripts in Java using Eclipse IDE. Performed UI Testing, API Level testing for web services, enhanced the Test harness and developed many Test suites using XML and Java.

●Worked as Triage lead holding the responsibility of UAT handover to business post SIT Completion.

●Worked as Point of contact for any clarification on solution/data/environment related questions.

●Involved in Agile (Scrum Process) methodology-based Project Planning, Test planning and coordinating on all SDLC phases.

●Understanding business requirements and Interacted with client to have a better understanding of functionality.

●Creating test plans and performs planning activities.

●Worked on deciding and grouping the test cases for automation and preparing the Test data set for Automation.

●Developed and executed SQL queries to verify the proper insertion, deletion and updates into Oracle tables and cubes.

●Defect logging and tracking using HP Quality Centre (QC) and updated the test defects status with results.

●Reviewing the Test Reports and Preparing Test Summary Report for execution of Automation scripts.

●Worked on Regression testing planning and execution.

●Worked on resolving issues and providing daily and weekly status reports to clients.

●Planning and execution of knowledge transfer to new team members.

Citibank ETL Developer (2011 – 2013)

●Work Order Management tool that included Claims management and had Data loads for Work Order lifecycle. This involved contractor (Vendor) and product management for Claims approvals for third parties.

●Designed and developed complex ETL Informatica mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations. Designed and developed the logic for handling slowly changing dimension (SCD) table’s load by flagging the record using update strategy for populating the desired.

●Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.

●Created UNIX scripts to call other programs and file maintenance. And oracle database scripts for table partitions compress and rebuild indexes, partition exchange and purging the partitions.

●Analyzed Business requirements, prepared the Physical design, High level designs and technical specifications.

●Worked on providing solutions for issues related with same which covers activities like requirement analysis, ETL Informatica designing, scheduling workflows and providing Maintenance, Enhancement & Support to the Client

●Create ETL Informatica processes to extract data from tables for loading into various oracle staging tables.

●Wrote PL/SQL Procedures, Functions. Created other database objects like tables, Synonyms, Ref Cursors, Constraints, Indexes, Views, and Inline Views, Partitioned tables with concept of local and global index using Oracle 10G.

Additional experience includes Software QA Engineering for Travelers Insurance from 2009 to 2011 through Accenture.

EDUCATION

Maharishi Dayanand University

Bachelor of Engineering, Computer Science & Engineering

Contact this candidate