SUMMARY:

Software developer with over 17 years of experience developing, implementing, and maintaining software applications through strategy, design, and data architecture, primarily using Microsoft technologies.

TECHNICAL SKILLS:

LANGUAGES: C#, ASP, VB.NET, SQL, ASP, Java, Visual Basic, ColdFusion, HTML, CSS, JavaScript, PHP, JQuery

SOFTWARE: MS SQL Server , SSRS Reporting, MySQL, Oracle, Teradata, J2EE, MS SharePoint, MS Access, MS Visual Studio.NET, Crystal Reports, Web Services, Tableau, PVCS, Flex, SSIS Packages, DTS Packages

APPLICATIONS: Distribution Requirements Planning, SAP, Inventory Management, Order Entry, Purchasing, Shipping, Warehousing.

Manufacturing : Bill of Material Processing, Capacity Control, Just - In-Time Release, Material Requirements Planning, Planning and Scheduling

WORK EXPERIENCE:

SQL Server Database Developer

Confidential, Elk Grove, IL

Responsibilities:

• Responsibility for data availability, integrity, consistency, and performance of all critical databases for the organization
• Work with developers to identify and tune poorly performing queries.
• Tune Transact-SQL code, SQL Server configurations, and operating systems for optimal performance.
• Automation and standardization of SQL Server environment to operationalize repetitive tasks.
• Developed customized queries that pulled legacy data and transformed it for SAP
• Built SSIS packages for regular process pulls from AS400 into SQL Server, these packages would run sometimes daily, weekly, or bi-weekly depending on the need.
• Converted legacy databases to SQL Server, replacing it with an automated ETL process.
• Rebuilt current month end process that reports sales figures for the past month, forecasts the remaining year’s projected results.

Database Administrator

Confidential, Southfield, MI

Responsibilities:

• Rebuilt current month end process that reports sales figures for the past month, forecasts the remaining year’s projected results.
• Created data warehouse that centralized data from four different sources and summarized data as need be.
• Created all SSRS reports that are based on the new data warehouse
• Automation and standardization of SQL Server environment to operationalize repetitive tasks.
• Built the web service that feeds our suppliers with shipping information based on plants output.

SQL Server Developer- Applications

Confidential, Bloomfield Hills, MI

Responsibilities:

• Responsibility for data availability, integrity, consistency, and performance of all critical databases for the organization
• Work with developers to identify and tune poorly performing queries.
• Tune Transact-SQL code, SQL Server configurations, and operating systems for optimal performance.
• Automation and standardization of SQL Server environment to operationalize repetitive tasks.
• Built SSIS packages for our ETL process from our transactional database into our historical database. Also our SSIS packages would extract our data and we would ship it off to a variety of vendors depending how they want the data. It could be in excel, or a flat file.
• Converted all DTS packages over to SSIS which mainly had to do with running data manipulations for the daily management report suite.
• Architect systems for disaster recovery and high availability including mirroring and clustering technologies.
• Replicated the web site data that we are capturing (online appointments, website complaints, membership information) and pushed it to our data warehouse so we can build historical reports on the information without taxing our website.
• Built the inventory and PA module in .NET C#. The inventory module showed facilities counts of products sold and remaining products. The PA module was to harvest web site complaints and forward it to our patient advocacy team which they can log on how they address the original complaint.
• Developed management dashboards, and converted excel spreadsheets into Tableau. Now management can click on an interface that shows their entire network performance and financial history rather than clicking many different reports, and running their own macros, queries, etc.
• Developed an ETL process to load client insurance information from a variety of providers. This data was sent to us nightly and we digested the data into our system, each provider’s data was different so the solution had to be versatile.
• Introduced partitioned tables into our environment, this allowed many our queries and stored procedures to run faster. We have a nightly process that digests all transactional detail from our other databases into our data warehouse. It usually took without errors six hours to complete, currently it's tracking at less than an hour now.

SQL Developer

Confidential, Detroit, MI

Responsibilities:

• Created web based interface for the Enterprise Release Management team.
• Converted all DTS packages over to SSIS packages which had to do with loading data from all other department databases into our specific data warehouse.
• Created Stored Procedures for the employee dashboard that was implemented for ERM team
• Created Adhoc Reports in ColdFusion for different departments as needed.
• Created management reports using ColdFusion.
• Trained Blue Cross employees to use the ERM web based interface.
• Created the SQL Views needed to run the ColdFusion reports.
• Built SSIS packages and scheduled them as nightly jobs.

Lead Developer

Confidential, Auburn Hills, MI

Responsibilities:

• Prototyped the logistic software that track and traced finished vehicles for Confidential .
• Rebuilt three dozen crystal reports into SSRS reports.
• Created a web based reporting tool that allowed remote locations to print bar code labels for vehicles.
• Built the vehicle aging system in ColdFusion with an Oracle backend, this system allowed analysts to track vehicles that were sitting a long time on yards.
• Built the railcar inventory tracker in ColdFusion with an Oracle backend, this module allowed analysts accurate counts of railcars on a yard that they can use to build loads.
• Built a portable .NET Gate entry system for small transportation companies that couldn't afford an elaborate EDI software package. This allowed the transportation companies to accurately count their inventory.
• Created a daily management reporting suite that allowed management a daily view of the vehicle network.

Software Developer

Confidential, Grand Blanc, MI

Responsibilities:

• Created a customized EDI translator for a customer that required compliance with a multitude of their client base.
• Created a catalog building interface for AC Delco.
• Creating a E-Learning environment for Napa Auto parts that allowed Napa to certify store employees with the skill set they needed to familiarize themselves with new vehicle product lines, that weren’t available before.
• Prepared stored procedures for all SQL Server databases for the organization .
• Created all Crystal Reports for the organization.

Web Programmer

Confidential, Saginaw, MI

Responsibilities:

• Created a web based interface for Confidential to track parts.
• Created a web based interface for Confidential Application that provided engineering drawings based on a REC number.