SUMMARY:

• Seeking a position which deals with data. I am a passionate software engineer who has worked on all aspects of the SDLC, some aspects of being a technical lead, which has led to my final calling.
• TSQL and SQL Server - are two areas of computer science, that I get most excited working with.
• Storage of data in SQL Server, manipulation of data to suit frontend applications, ETL, DTS, SSIS and TSQL stored procedures development.
• Translating business needs into viable logic and design.
• Troubleshooting complex sql queries and data. Optimizing sql code via performance tuning, indexes, execution plans and profiler traces.
• In short, to work in a challenging data environment in SQL Server. Ability to be self-directed, able to focus on personal assignments while remaining part of a larger team with proven ability to multi-task, keen intellect, sharp thinking, quick analysing, fast understanding of business and current project needs, hardworking ethic, compelling writing, a vibrant and helping attitude make me an asset to your organization.
• 13 years of experience in the Information Technology industry.
• Extensive experience managing and developing 14 entire e-Commerce Web B2B, B2C website, developing web and client-server applications mainly using MS Site Server, ASP and SQL Server in the year 2000.
• In-depth knowledge of developing Full Life Cycle Development SDLC, conversion, enhancement and maintenance projects.
• Experience in analysis, design, code modification, testing, quality control, training and support of various software projects.
• Acted as a part of a team and a team leader on many occasions.
• Performed on various SQL dialects including that of SQL Server, Oracle, Ingres and DB2 for over 13 years now.
• Worked on database development and have been involved in TSQL programming of stored procedures, triggers, alerts, emails, scheduling, automation of DTS and SSIS packages, bulk copy programming, jobs, ETL, dealing with different filetypes into and out of SQL Server
• Helped write and support technical qualifications when preparing RFPs.
• Been part of the ‘business requirements gathering effort’ meetings.
• Written Requirements Definition Document.
• Translated business needs into software products.
• Designed and developed user-interface prototype and database model through Use Case Scenarios
• Prepared Detail Definition Documents.
• Coordinated software development effort with onsite and offshore team.
• Developed test plans and test scripts.
• Created User Guides that act as training manuals for the websites and client server applications.

PROFESSIONAL EXPERIENCE:

SQL Server 2008 Developer

Confidential, Dearborn, MI

Responsibilities:

• Stored Procedures TSQL 2008
• SQL Server Reporting Services SSRS 2008
• Regular maintenance of SQL jobs
• Programming SSIS packages.

SQL Server Developer

Confidential, Rochester Hills, MI

Responsibilities:

• Gathered requirements to build suitable excel reports.
• Wrote sql stored procedures resulting in a suitable dataset.
• Used dts to create xls files from sql datasets
• Created dts packages and stored procedures to place xls reports on specified folders.
• Please contact Confidential for further information on my work out here.

SQL Server Developer

Confidential, Livonia, MI

Responsibilities:

• Capturing requirements for building the SQL Server 2000 database which consists of tables, indexes and constraints
• Writing new and modifing existing SQL stored procedures to transfer data as flat files to SQL Server tables

SQL Server Database Developer

Confidential, Detroit, MI

Responsibilities:

• Extensive work in Extract Transform and Load - ETL using TSQL, DTS and SSIS
• Transfer data into and out of SQL Server from various file formats such text files, csv files and xls files.
• Design, develop and implement cost effective, high quality ETL jobs to meet/exceed customer needs.
• Interpret the transformation rules for all target data objects and develop the software components to support the transformation
• Automate the ETL process through scheduling and exception-handling routines as well as source to target mapping development, support, and maintenance
• Deploy a TSQL error management mechanism to capture all relevant error information and associate data in a manner that can be re-processed independently
• Write TSQL Stored Procedures to provide thorough metrics to measure progress and accuracy of data transfers
• Assist with development of testing methods to validate loaded data with TSQL functions and stored procedures
• Performance tuning and monitoring of ETL processes, jobs and extractions
• Conduct root cause analysis and resolve production problems.
• Create documentation of implemented ETL processes for knowledge sharing and hand-off
• Support both client and department programming standards.
• Perform unit testing of all ETL Jobs developed and/or enhancements to systems.
• Work with Quality Assurance team to ensure quality of work produced.
• Monitor application to identify areas for enhancing performance.
• Optimize existing DTSes to drop and recreate indexes before and after loading which increased performance of the DTSes from an 8 hour runtime to 4 hours.
• Optimize existing tsql stored procedures by creating relevant indexes, making sure the indexes are being used in their execution plans, dropping indexes that are not used.
• Understand the exact need of the end users and hence helping them come to the most perfect solution in terms of an efficient GUI for them, which involves a very good database design
• Brought consistency by means of standardization of all naming convention of database objects (tables, views, stored procedures, dtses, jobs), file placements and comments within the code.
• Laid down standard codes for error proofing dtses and safeguards against wrong loading wrong data for example
• Slashed down unnecessary downloading of wasteful data
• Put in place stringent column datasize requirements, that is, if a tinyint was required, then it shall be a tinyint, not a smallint or an int.
• Careful evaluation of each column’s definition in all tables.

SQL Server Developer

Confidential, Livonia, MI

Responsibilities:

• Captured requirements for building the SQL Server 2000 database which consists of tables, indexes and constraints
• Wrote SQL stored procedures to transfer data as flat files to SQL Server tables
• Wrote SQL stored procedures reports
• Was lauded for significant achievement in doing the exact data conversion from flatfiles to sql server database, without losing or mangling data in the process.

Business Analyst

Confidential, Farmington Hills, MI

Responsibilities:

• Captured requirements for the Confidential (Logistics Management Suite) application
• Defined and wrote functional specification documents to be handed over to developers for software development
• Act as a liason between the business users and technical team
• Interfaced with the customers.
• Wrote user guides for the application

ASP-Oracle Programmer Analyst - Production Support

Confidential, Dearborn, MI

Responsibilities:

• Provided production support for technical issues in client server and web applications.
• Solved production issues for the warranty related applications in Ford.
• Interfaced with the customers.
• Developed an enhancement plan for the applications based on customer inputs.
• Developed code in HTML, ASP, VB and Oracle 8i packages and procedures.

B2B ASP-Oracle Website Project Lead

Confidential, Jackson, MI

Responsibilities:

• Led a team of five software developers on site and three developers offshore, in India.
• Led a team led that designed the website user interface prototype, database model and prepared the detailed design document.
• Estimated, scheduled and assigned software development tasks to individuals.
• Interfaced with the client project manager and client business analyst.
• Developed test plan for testing phase.
• Interfaced with the client at various stages of development and lead weekly status and review meetings while engaged as a Business Lead.
• Created a User Guide for the website.
• Charted project development with NIKU Workbench and Visio.
• Developed code in HTML, ASP, VB and Oracle 8i packages and procedures.
• Developed reports in Crystal Reports 8.5.

Technical Environment: IBM PC, MS Windows 2000, MS IIS, ASP, Visual Basic, COM+, Oracle 8i, Active X Controls, Crystal Reports 8.5, TOAD, HTML, DHTML, JavaScript, VBScript, PVCS, Visual InterDev, Visual SourceSafe, Visio 2000, Niku Workbench, and MS Project.

Client-Server Project Lead

Confidential, Rochester Hills, MI

Responsibilities:

• Participated in the requirements gathering effort and developed requirements definition document with estimates for the software development effort.
• Designed Client-Server user interface prototype and database design model for the project and develop the detailed design document.
• Prepared test plan document that was used in system and user acceptance testing.
• Acted as the Technical Lead, leading a two-person team to develop the product in MS Access 2000 and SQL Server 2000.
• Scheduled and assigned tasks to individuals while engaged as a Technical Lead.
• Acted as the Business Lead, interfacing with the client at various stages of development, lead weekly status review meetings.
• Developed code in Access, T-SQL.
• Developed reports in MS Access.

Technical Environment: IBM PC, MS Windows 2000, SQL Server 2000, MS Access 2000, ActiveX Controls, Visio 2000, and MS Project 98.

Senior ASP - SQL Programmer

Confidential, Pittsburgh, PA

Responsibilities:

• Maintained all the websites developed and hosted by LabWerks. Inc.
• Programmed all the websites in ASP and database as SQL Server.
• Helped automate file transfers between Confidential SQL Server database and the client.
• Designed a WAP site for Confidential using WML, WMLScript and ASP.

Technical Environment: IBM PC, XML, WML, IIS, ASP, Visual InterDev, COM, Visual Basic, SQL Server 7.0 - 2000, Stored Procedures, Triggers, FrontPage, HTML, DHMTL, JavaScript, VBScript, CSS, and Adobe PhotoShop.