SUMMARY

• To obtain a position as Software Engineer to utilize my skills in SQL, SAS software, VB 6.0/.NET,.NET, C#, C++/C, Java, Perl, programming and networking technologies and methodologies in an organization seeking an individual with the ability to analyze, track and solve problems, provide support and troubleshooting solutions with solid communication skills, understanding of computer hardware and software and with strong background in programming, understanding of network protocols, understanding of database systems, BI and testing techniques and methodologies.

TECHNICAL SKILLS

Database Systems: SQL Server 2008, SQL Server 2005, SQL Server 7.0, Oracle 11/10/9i, MySQL, Teradata, MS Access

Languages: SQL, SAS 9.2, VB 6.0/.NET, C#, C++/Visual C++, Java, Perl, ANSI C/C, MFC, VBA, PHP

Business Intelligence/ETL Technology: Cognos 10.1, Data Stage 8.5, Autosys, Autovisn

SAS Software: SAS 9.2, Enterprise Guide, ITRM 3.1/2.7

Web Technology: JavaScript, HTML, DHTML, CSS, XML, ASP.NET, CGI, PHP, AJAX, Ruby Rails

IDE: Eclipse, MS Visual Studio.Net, SAS Eclipse, Net Beans IDE, Flex 3

Software: Crystal Report 9.0, FileMaker Pro 9, MS Office 2003/2007, MS Excel, Visio

Operating Systems: Windows XP Pro, Windows NT/2000/Vista/7, Unix, Linux, Red Hat Linux

VCS: SVN, CVS

Application Server: GlassFish 3.1.2, Apache, IIS

Automation Tools: Ant, JUnit

Design Tools: Dreamweaver, Flash and Photoshop

PROFESSIONAL EXPERIENCE

Confidential - Cary, NC

Financial Warehouse Support Analyst

Responsibilities:

• Provide 2nd/3rd level production support
• Use sql loader to load data into our dev database
• Wrote queries to extract data from Jira and from dev database
• Monitor ETL jobs, Cognos Cube builds, and Cognos reports.
• Provide detailed analysis into running jobs in Autosys and Data Stage
• Investigate job failures and provide solutions
• Perform Admin tasks in Cognos environment
• Perform environment and system checks
• Wrote perl and shell scripts to automate processes

Confidential - RTP, NC

Developer

Responsibilities:

• QA audits
• Tested Database for integrity and duplicates.
• Uploaded test booklets for user grading system
• Imported data from various sources to personal database to test for various cases
• Wrote testing scripts in SQL Server for the databases and executed scripts for data integrity
• Wrote perl scripts to automate daily tasks
• Used VB.Net and C#

Confidential - RTP, NC

Developer

Responsibilities:

• Assisted in user testing of a software system for material management system
• Worked with users and programming staff to analyze, design and implement new systems and system enhancements
• Used SQL Server 2005, VB.Net and C#, at the back end and .Net at the Front end
• Wrote testing scripts in RDBMS for the application known as Management System and execute scripts for data integrity
• Wrote technical and validation documentation for Management Inventory System
• Created Users and Technical manuals for Management Inventory System
• Development, implementation, backup and update Supply Database and Supply inventory system
• Developed tracking system database for regulatory submissions and QA audits

Confidential - RTP, NC

Test Engineer

Responsibilities:

• Responsible for Regressions testing on the model simulation build on the SC, SCLite, MP chips.
• Provided data analysis and generated complex detailed reports for Project Managers on each project.
• Wrote SQL queries to extract data from test results stored in Oracle databases.
• Wrote Perl Scripts for automation, to parse log files for test failures, to schedule when to launch regressions for each project, to clean up test directories and traverse directories.
• Worked directly with the Project Managers on various projects.
• Managed HD space for PM's.
• Secondary duties were to assist PM's with their work and to take on their responsibilities to reduce workload. Performed initial debug.
• Assigned tests to be debugged to testers.
• Wrote perl scripts

Confidential - RTP, NC

Developer/Tester

Responsibilities:

• Worked with testers and team lead to refine goals, designing and implementing traffic generation tools.
• Tools created to test Cisco switches and routers.
• Tools were written in Perl and Tcl.
• Aggressively tested tools and updated existing tools.
• Created user documentation for tools.
• Extracted data from databases.
• Implemented user defined Perl modules and libraries to be used in conjunction with Tub tool, which was written in Perl.
• Imported CPAN and other modules for Tub tool.
• Set up key-based authentication on test servers(DUT's).
• The tools were designed to test the switch by making http, ftp, smtp calls to test the switch.
• Configured cisco routers and switches using IOS and CatOS.
• Performed packet traces using Wireshark.
• Other tools used are Tcpdump, Traceroute, Putty, OpenSSH, and SSH.
• Setup servers and installed Red Hat Linux images on servers.
• Setup DNS and assigned ip address to servers.

Confidential

SAS Developer

Responsibilities:

• Submitted bi-weekly reports on field conversions.
• Assisted team members with table templates, summary plan data models and stage table templates.
• Utilized skills such as: importing various types of raw data into SAS, transforming data to generate reports in html format using proc report, converting SAS datasets into summary plan XML and procedures using Base SAS functions, SAS Perl functions, Macros, and Proc SQL.
• Generated SAS code for automation of field conversions.
• Performed redundancy checks.
• Responsible for converting data from different server operating systems to show in a unified reporting structure. Worked extensively with data steps, ods, proc report, and export files.
• Applied field normalization specifications.