Objective SQL Server Developer/Business Analyst/Requirements Engineering
Work experience
2005 to Present Confidential, Atlanta, GA
Senior Developer

• Providing comprehensive ETL packages for (EDI) upstream and downstream data movement using SQL Server 2005 and 2008 SSIS - (control flow, tasks, containers, expressions, error handling, deployment).
• Exposure to SSRS and deployment.
• Creating system and functional specifications and documentation based on user input and business process analysis.
• Business Analysis and Requirements Engineering.
• T-SQL programming, Query writing, Query optimization and database tuning,
• Creating SQL Queries, Scripts, Triggers, Stored Procedures and backup/recovery.
• Providing comprehensive Visual FoxPro versions 6, 7, 8, and 9 front end programming.
• Providing Visual FoxPro to SQL Server migration/data conversion.
• Creating custom financial reporting solutions.
• Database design, modeling and implementation.
• Providing complete systems development life cycle (SDLC) support.
• Project management.
• Visual SourceSafe usage.
• C# .Net Win forms training and exposure.
• Problem Ticket reporting, tracking and resolving using Microsoft Sharepoint.
• Providing lead analysis on legacy Visual Foxpro application conversion to C# .Net.

2002 to 2005 Confidential, Aston, PA
Senior Developer

• Providing comprehensive ETL packages for (EDI) upstream and downstream data movement using SQL Server 2005.
• T-SQL programming, Query writing, Query optimization and database tuning,
• Creating SQL Queries, Scripts, Triggers, Stored Procedures and backup/recovery.
• Designing and implementing a 3 tier, commercial, client server, mutual fund accounting, and financial reporting system for use by large mutual fund firms in the United States and Europe using the Microsoft Visual FoxPro 6.0, 7.0, SQL Server 2000 and Windows platforms.
• System Design and Requirements Specification/Documentation creation.
• SQL Server 2000 and 2005 Data Base maintenance.
• SQL Server 2000 and 2005 stored procedure, script and trigger creation.
• QA tests plan creation and regression testing.
• Object oriented software development using proprietary in house and Codemine Framework.
• Class library creation and sub classing of objects for reusability.
• Leading team of developers in producing deliverables to specification.
• Database modeling, design and data normalization.
• Performing structured systems analysis and design for anticipated and requested software enhancements.
• Visual SourceSafe - version control software.

1999 - 2002 Confidential, Blue Bell, PA
Senior Programmer/Analyst - Project Leader

• Designing and implementing client server accounting, time billing and case tracking and management software solutions to large law firms using theMicrosoft Visual FoxPro 5.0 and 6.0 Object Oriented application development platforms.
• Object oriented software development using frameworks.
• Class library creation and sub classing of objects.
• Analyzing and automating business processes for increasing productivity and efficiency.
• SQL Server 6.5, and 2000 RDBMS backend development - stored procedure and script creation.
• Database modeling, design and data normalization.
• Designing Electronic Data Interchange software for importing and exporting data in various file formats.
• Working with the following Operating Systems: Windows 95, 98, NT 4.0, Server 2000.
• Meeting with corporate clients and preparing formal system and design specifications to meet their IT needs.
• Performing structured systems analysis and design, producing Entity Relationship Diagrams, Data Flow Diagrams and Data Dictionary.

1997 - 1999 Confidential, Malvern, PA
Senior Programmer/Analyst

• Complete rewrite/conversion of a Microsoft FoxPro 2.6 Windows application to Visual FoxPro 5.0 applications running on Windows NT in support of the company's extensive employee benefits administration and healthcare billing functions.
• SQL Server 6.5 Database back end development.
• Class library creation and sub classing of objects.
• Designing and Implementing Electronic Data Interchange (EDI) programs for all data exchange with corporate clients, third party administrators, and insurance carriers utilizing FTP and Internet transmission.
• Performing structured systems analysis and design including the production of Entity Relationship Diagrams, Data Flow Diagrams, Data Dictionary and Functional System Specifications.
• Conversion of legacy FoxPro 2.6 Windows application system to Visual FoxPro 5.0 application system - complete analysis, design and rewrite.
• Visual SourceSafe - version control software.
• Y2K Compliance/Remediation/Testing and Communication.
• Interacting with clients, insurance carriers and third party administrators to ascertain software, processing and reporting requirements.
• End user training and software problem resolution.

1995 - 1997 Confidential, Berwyn, PA
Programmer/Analyst

• Designing and implementing FoxPro 2.6 and Visual FoxPro 5.0 relational database software applications running on Novell Network under Windows 3.1 and 95 in support of the firm's caseload management, client tracking, litigation and billing functions.
• Database retrieval and document production.
• Provide ongoing maintenance programming support to the legacy FoxPro 2.5/2.6 applications.
• Training staff in system operations.
• Troubleshooting hardware and software problems.

1985 - 1995 Confidential, Pittsburgh, PA
IBM System 36 Mini Computer Programmer/Analyst

• Conversion of manual caseload management and client tracking system to a fully automated application system running on the IBM System 36 midrange platform.
• Programming using the IBM midrange computer, proprietary RPG II language.
• Design and implement new software applications to support the caseload, client tracking, litigation and accounting functions.
• Evaluating and purchasing new software and hardware.
• Formulating and implementing data processing policies.
• Training staff in system operations.

Education

Computer Science
Computer Programming/Systems Analysis

• Two Year Certificate College Accounting