Software Engineer Sql Server

DEEPA KRISHNAMOORTHY

Email: **********@*****.***

Phone: 714-***-****

SUMMARY

• 9 years of software development and testing experience working in the Financial, Semiconductor, Web Applications and Business Process management domains

• 5+ years of professional experience with software development in data warehouse ETL - extract, transform and loading, environment using Abinitio and oracle database as backend.

• Extensive experience in writing SQL scripts to validate the database systems and backend database testing.

• Proficient in working with UNIX shell scripts

• Experience with integration testing of the applications using various sources like flat files, XML, oracle and SQL server databases.

• Good understanding of complete software development lifecycle (SDLC) and software methodologies

• Experience in QA processes and different levels of testing like Function, Regression, and Integration testing against design and business scenarios.

• Interfacing with end users/customers and Global teams to ensure timely delivery of specific technical and business needs.

• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame

• Initiative to learn new technologies and tools quickly.

• Strong analytical skills and problem solving skills with attention to detail

• Excellent communication, interpersonal skills and ability to act as a liaison between different groups.

• Process-driven organizational skills with the ability to prioritize and multi-task.

TOOLS/TECHNOLOGIES

Software: C, Java, HTML, XML, JCharts, VB6

Scripting: PERL, JavaScript, KSH

Databases: Oracle 9i/10g, MS SQL Server 2000, MS Access

Operating Systems: Sun Solaris, Linux, Windows NT/XP/2000/7

Tools: Abinitio GDE 1.14/Co-op 2.14, Informatica Power Center 8.6, Toad, Oracle developer, SQL*Plus, Eclipse, Apache, Tomcat, Tortoise CVS and SVN, ANT, XPATH/XSLT, MS Visio, MS Infopath, Scarab, Clarity, Jira, HP Quality Center, SharePoint, MQ

PROFESSIONAL EXPERIENCE

Sr. IT Consultant, Carte Solutions December 2010 – March 2011

Wachovia - Wells Fargo data integration project @ Wells Fargo.

• Running the integration test suite to check that development is according to business requirements and validating data loaded to target tables

• Monitoring batch jobs using autosys and ETL jobs using Informatica Powercenter (ETL) Monitoring

• Understanding the release plan and collecting the test data from various sources for integration test.

• Capturing errors from the integrations test and guiding the development and QA team on improvements for future releases

Environment: Informatica Power Center 8.6, Oracle 10g, SQL server, Unix, HP Quality Center

Software Engineer, Global Foundries (Company split from AMD) Feb 2009 – December 2010

Software Engineer, Advanced Micro Devices (AMD) March 2006 - Feb 2009

• Developing and enhancing various modules of their engineering data warehousing projects for new releases or bug fixes including

o Highly scalable and performance tuned manufacturing data warehouse

o Collections data mart providing user requested aggregations of data.

o Engineering Data mart capturing data of a specific aspect of the semiconductor process

o Web based Generalized Extract Tool to capture data per user defined parameters.

• Extensively participated in walkthrough meetings with business analysts to understand the requirements

• Creating software design documents

• Creating the test data for development testing.

• Assisting the testing team during functional and integration testing of ETL code in the test environment.

• For bug fixes, performing risk analysis based on severity.

• Involved with creating UNIX Shell scripts, PERL scripts and oracle sql scripts as per the requirements

• Coordinating and packaging test releases for configuration management team globally and configuring the development ETL and database environments

• Providing support for debugging and solving post production bug fixes and data issues..

Environment: Abinitio, PERL, Oracle 9i/10g, PL/SQL,KSH, SVN, XML, Visio, Clarity, Jira.

Software Developer Test, Carte Solutions

Project with Advanced Micro Device January 2005 – March 2006

Worked as a software consultant with Advanced Micro Devices to support functional and integration testing of their Historical Manufacturing Datawarehouse

• Setting up the test environment before each release

• Performing functional testing of ETL modules by running automated regression load test suite in the test environment and capturing detailed information regarding software bugs and/or system errors.

• Implementing automated SQL scripts and views to validate data and verify from source to target

• Evaluating the system for scalability and finding system performance bottlenecks by running large amounts of data.

• Providing deployment documentation to configuration management team to test releases

• Providing on call support for production systems to resolve any issues.

Environment: ETL, PERL, Oracle 9i/10g, Unix KSH scripting, UNIX, XML

Systems Analyst, Inventes Inc March 2003 – December 2004

Project with Dell Computers, Austin TX

Point of contact for integration of the Dell DMS (Dell Managed Services) Applications.

• Performing functional testing of Dell DMS application modules for each new feature or bug fix to ensure it aligned with customer requirements.

• Participating in Integration testing of application and ensured stability of production systems after software updates and patches.

• Developing test plans and test cases for scenarios in the requirements document.

• Performing gap analysis between current and desired state and conveyed findings to development team

• Conducting training sessions for customers by creating user manuals, making presentations and providing application walk through.

Environment: JAVA, Oracle 9i, HTML, JSP, Visio

Project for Stewart Reidata Inc, San Antonio TX

Responsible for writing backend modules to automate Stewart REI’s business of providing comprehensive information solutions to title agents, lenders, real estate agents and other markets with related needs.

• Developing the business flow prototype using HTML/ JSP/JavaScript and writing backend java modules for data uploaded via the web interface.

• Responsible for configuration of the business flow application by creating administrative information for users, counties and source information about each county.

• Responsible for running the software builds for each release/patch. The builds were automated though Ant and deployed to a Tomcat application server.

• Developing test plans and test cases for each business flow and also for customer training.

Environment: JAVA, MS SQL Server 2000, Tomcat sever, JSP, HTML, ANT

Project for Brandan Gary & Co

Project required automation of business process flow for review of a sample of underwritten loans in the real estate sector. The loans were reviewed to ensure they followed the underwriting guidelines.

• Using an inhouse Business Process Management system (BPMS) based on XML/XFORMS for developing processes flows for specific user types.

• Developing a reporting framework using automated PDF file creation using XSLT/XSL:FO.

• Developing trend charts using the JCharts library to provide statistical details about recurring problems that client needed to address.

• Being the primary POC for recording bugs, issues and configuration of scarab issue tracking tool.

Environment: JAVA, XFORMS, XML, XSLT, XSL:FO, Javascript, HTML, JCharts, Scarab

Technical Consultant, Ahila Exports July 1999 – August 2000

• Providing Help desk support resolving end-user software, hardware or network issues.

• Managing user accounts using the Lotus Domino 4.0 server.

• Developing in-house accounting application for customized tax calculations in Visual Basic with MS Access back end.

Environment: Lotus Domino Server4.0, Windows NT server, Visual Basic6.0, MS Access

Education

MS, Computer Science, University of Minnesota Duluth, 2003

BE, Computer Engineering, Pune Institute of Computer Technology, 1999

Contact this candidate