SUMMARY:

• Confidential has over 20 years of experience in every phase of the software development lifecycle.
• He specializes in Microsoft based technologies applied in finance, manufacturing industries and health care.
• He has a proven track record as a data architect using SQL Server, SSIS, SSRS and SSAS.
• He also has strong experience with C#, VB.NET, Visual Basic, Web Applications, Windows Applications and Web Services.
• He has successfully led development teams and designed enterprise application systems and data warehouses from inception.
• He has also served as an application architect, lead developer and a database architect.

TECHNICAL SKILLS:

Languages / Tools: TSQL, SSIS, SSRS, SSAS, C#, Visual Basic, HTML, Java Script, WCF, AJAX, Web Services, AJAX, MVC, XSL, Crystal Reports, SharePoint, Powershell

Databases: SQL Server 6.5 - 2014, Oracle, Redbrick, DB2

Platforms: Windows, Unix

Development Tools: Visual Studio (Windows Application, Web Application, SharePoint, SSIS, SSRS, SSAS), SQL Server Management Studio, Excel (PowerPivot, Power Map, Power View)

PROFESSIONAL EXPERIENCE:

ETL Developer / .NET Developer

Confidential

Responsibilities:

• Migrated databases from SQL Server 2000 to 201 4.
• Re-architected ETL processes to convert DTS packages to SSIS.
• Added enhancements to portal application that was implemented two years earlier.

Database Architect / Developer

Confidential

Responsibilities:

• Migrated data from SQL Server 7 to SQL Server 2014.
• Re-architected existing DTS packages and created new SSIS packages.

ETL Developer

Confidential

Responsibilities:

• Designed and built ETL processes using Pentaho Data Integration to load data from multiple health care providers for multiple customers.
• Created processes to validate data from its raw form, in staging and into the production data warehouse.
• Created complex processes to roll up medical and dental claims data to the claim, provider, etc. levels.

Database / Application Architect and Lead Developer

Confidential

Responsibilities:

• Designed and built database for project management application in SQL Server 2012.
• Designed and built ASP .NET application to reside in an existing portal.
• Designed and built ETL process for integration with external systems using SSIS.

Data Architect

Confidential

Responsibilities:

• Designed and built data warehouse.
• Created ETL process to load and match properties from 18 different systems.
• Designed and built self-service BI model.
• Successfully created data validation process to ensure the accuracy of the corporate accounting.
• Created two-way integration between SalesForce and Yardi (property accounting system).
• Created ASP .NET site to allow users to load data to the warehouse from Excel, manage reference data and approve and process jobs including loading data to Great Plains.

Confidential

Responsibilities:

• Learned and documented the deployment process for creating online banking application environments for development, QA and UAT.
• Created over 70 environments for development, QA and UAT.
• Trained Confidential internal staff on the process of creating environments.

Developer

Confidential

Responsibilities:

• Developed the first SharePoint 2010 site to be used at Confidential .
• Developed internal sites.
• Supported SQL Server DBAs during deployments.
• Worked on the team that developed, tested and deployed public facing sites.

Developer

Confidential

Responsibilities:

• Created data extract from SQL Server and reporting in Excel to facilitate business processes.

Developer

Confidential

Responsibilities:

• Gathered and documented requirements from business users.
• Designed database for Confidential to automatically process and approve claims.
• Created ETL process to load claims data.
• Created stored procedures to apply business logic to auto approve claims where appropriate.

Developer

Confidential

Responsibilities:

• Gathered and documented requirements from business users.
• Designed and built database schema.
• Worked with designer to create the look and feel for the site that the users liked while staying within Confidential ’s branding specifications.
• Architected, built and tested web application.
• Designed and build SSRS reports
• Worked with the business users to test the application.
• Managed the complete life cycle of the application.
• Continue to support and enhance the application.

Developer

Confidential

Responsibilities:

• Created custom BI application portal interface proof of concept.
• Designed and built filtering mechanism within application to allow users to select and customize report filtering criteria for the portal.
• Designed the variable handling process to serialize the variable number of parameters into XML to query the database for the reports.
• Worked with the project manager and business users to refine and redesign the user interface.
• Created the WCF services to serve the numerous charts on the site.
• Vetted and selected the tools to be used for the user interface controls and charts.

ETL Developer

Confidential

Responsibilities:

• Documented existing ETL process used to import large files to be formatted into XML for large format printing.
• Processed fulfillment files for printers.
• Designed, coded, tested and processed changing business rules midway through normal processing.
• Made quality improvements to existing processes.
• Created process for data validation and quality assurance.

Developer

Confidential

Responsibilities:

• Designed and built SQL Server database for application.
• Designed and built user interface.
• Tested application.
• Loaded database with existing data from Excel.

Data Architect

Confidential

Responsibilities:

• Designed and modelled database for security application to manage key card access for all locations worldwide.
• Created SSIS packages to convert and load data from existing application’s database.
• Wrote and performance tuned stored procedures to support the application.

Data Architect

Confidential

Responsibilities:

• Designed, modelled and built database in SQL for application.
• Designed, modelled and built data warehouse in SQL Server for reporting.
• Created SSIS packages to load reporting data warehouse.
• Designed and created SSIS packages for converting data 7 existing applications into the new replacement application and new schema.
• Served as team lead for a team of 8 developers.
• Served as technical lead for DBA team.
• Designed and developed database promotion process for deploying the database to multiple test and production environments.

Developer

Confidential

Responsibilities:

• Built custom web service reporting tool using XML, XSLT and C# to be used by both client server and mainframe applications.
• Evaluated several server side components for creating PDF files before choosing Aspose PDF.
• Created custom XSL templates to emulate existing reports.
• Created working proof of concept web service that took in XML, a report layout specification and a destination and created a PDF file that adheres to business requirements for watermarking based on the report type.

Developer

Confidential

Responsibilities:

• Re-architected Fee Bill and Interest Bill processes in Windows Forms and Web Forms applications of the warehouse lending application that loaded data to the GL.
• Designed and developed web forms to process business transactions.
• Designed and developed custom controls for web forms.
• Corrected inheritance issues with existing architecture.
• Created SSRS reports.

Developer

Confidential

Responsibilities:

• Created application ASP .NET used by the DoD for tracking all purchases over a certain dollar threshold.
• Worked with team to introduce SOA to client’s internal development team.
• Created code creation tool to be used for coding middle tier object based on database schema.
• Modified code generation tool to implement parent child business object relationships.
• Developed user interface in web forms and custom sections of the business tier.
• Created dynamic web pages that are fully configurable through the administration pages.
• Mentored Confidential development staff.
• Created marketable, packaged software product that is now generating revenue for Confidential .

Developer

Confidential

Responsibilities:

• Participated on a team of developers to create a ASP .NET web forms for an application to manage resource scheduling for the police department.
• Worked on several key modules of the application.
• Provided guidance and mentoring to junior team members.

Developer

Confidential

Responsibilities:

• Supported multiple n-tier ASP internal reporting sites.
• Developed web security practices for development team and implemented changes to several hundred ASP pages and COM object.
• Consulted on ASP .ENT application that was not performing satisfactorily. Increased speed and scalability of the application.
• Worked to transition development efforts of recently purchased divisions from Danbury, CT office to St. Paul headquarters. This effort also included restructuring the ongoing development of the acquired division to fit within the corporate environment and development methodologies of corporate IT.

Developer

Confidential

Responsibilities:

• Worked with team to develop, maintain and enhance a multi-terabyte Redbrick data warehouse.
• Created client server applications to allow analysts to create and execute their own UNIX jobs.
• Designed and built data mart to serve and ASP reporting site.
• Created security web service to authenticate users and limit them to seeing data for only their accounting units and any under them.
• Created .NET reporting application and trained Confidential team on .NET development and VB .NET.