Data Software

DEEPA KRISHNAMOORTHY

Email: abki20@r.postjobfree.com

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

SUMMARY

. 8 years of industry experience with 6 years of Development and Business

Analysis experience in Data warehousing working in the Semiconductor, Web

applications and Business process management domains.

. Developed complex and scalable ETL software solutions adhering to

standards, processes, and best practices

. Extensively worked in the ETL process consisting of data sourcing,

transformation, mapping and loading.

. Experience developing detailed business requirements, designing solutions

and prototype

. Extensive experience functional testing of software solutions,

coordinating UAT and issue tracking

. Solid understanding of complete software development lifecycle (SDLC) and

software methodologies

. Strong analytical skills and problem solving skills with attention to

detail

. Experienced at interfacing with end users/customers and Global teams to

ensure timely delivery of specific technical or business needs.

. 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,

Business Objects XI R2, 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

Software Development Engineer, Global Foundries spin off from Advanced

Micro Device (AMD)

March 2006 -

Present

. Leading a team of 4 globally situated team members for analysis,

design development of ETL modules for the semiconductor manufacturing

Data warehouse and company's B2B portal per requirements collected by

business analysts and projects partners.

. Developing and maintaining Ad-hoc reports using Business Objects to

validate data, create monitoring dashboards and publish reports to end

users

. Responsible for the design, development, enhancement of several data

warehousing/ETL development projects including

o A highly scalable and performance tuned manufacturing data

warehouse

o Developing Collections that provided user requested aggregations

of data.

o Solely responsible for the engineering Data mart capturing data

of a specific module of the semiconductor process

o An internally developed, Generalized Extract Tool to capture

data per user defined parameters.

. Creating source to target (STM) mappings for all of the different

projects as part of the design

. Developing monitoring and cleanup scripts as per the need and

requirements of the projects in PERL.

. Assisting the SQA team during functional and integration testing of

ETL code in the test environment.

. Validating data loaded to the data warehouse in making sure data

quality meets the requirements of end customers using simple to

complex Oracle queries.

. Evaluating ETL applications for scalability, performance bottlenecks

and worked on performance improvement tasks.

. Primary point of contact for the group for agile development and scrum

process of ETL projects using Jira.

. Coordinating with configuration management team globally to test ETL

releases, configure ETL application and database environments

. Providing support for debugging and solving post production ETL bug

fixes and data issues..

Environment: ETL, PERL, Oracle 9i/10g, PL/SQL, Business Objects, KSH, SVN,

XML, Visio, Clarity, Jira.

Software Developer, 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 residing in Dresden Germany

. Performing functional testing of ETL modules by running automated

regression load test suite in the SQA environment.

. Performing integration and systems tests according to the requirements

of the specifications.

. 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 before deploying to production.

. Providing oncall support for production systems to resolve any issues.

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

Computer 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.

. Gathering business requirements and goal specifications, analyzing

data, and translating requirements into use cases.

. 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. All information was stored in an MS SQL

database.

. 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 automatation 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,

BE, Computer Engineering, University of Pune.

Contact this candidate