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.
• 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, Cary, NC

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.

Confidential, Rock Island, IL

Logistics System Analyst

Responsibilities:

• Worked with business requirements analysts/ subject matter experts to identify and understand requirements. Mapped source system data to data warehouse models (source target mappings).
• Modeled and involved with design of a large integrated Army Equipment and Supply Stocks data warehouse. Tracked location and condition of equipment and stocks. Fulfilled customer orders.
• Implemented ad-hoc queries in Oracle.
• Loaded inventory data from text files and excel files onto the database using Toad and in house tool.

Confidential, Durham, NC

Application Developer

Responsibilities:

• Co-developer/designer of user interface for inventory, parts, and order fulfillment application in Java.
• Designed programs which performed easy search for parts in inventory database.
• Involved in the system design of the application and also in the database design.
• Designed an SQL Server database for parts and order fulfillment.
• Wrote SQL queries to test databases.

Confidential, Morrisville, NC

Developer

Responsibilities:

• Designed and developed computer parts inventory applications in VB.Net.
• Oracle database was used for the back-end.
• Wrote SQL queries to extract data from Oracle database.
• VB Forms and Crystal Reports used for front-end.

Confidential

Teaching Assistant

Responsibilities:

• Taught internet classes.
• Students learned different business models such as B2B, B2C, P2P, and business concepts behind e-commerce.
• Graded and corrected student programs and graded student tests.