SUMMARY:

8 years of .net development and database development experience, in addition to experience working in various industries such as transportation and retail

CORE COMPENTENCIES:

• E - Commerce Web application development Project management
• Business Analysis Web Service development Database Security
• Business Intelligence Technical documentation Data Encryption

TECHNICAL SKILLS:

DBMS: MS Access, SQL 2000-SQL 2012, Oracle 10g

OTHER: SPSS, HL7 standards and formatting, ACL Auditing Software, MS Project 2010, ASP.NET 2.0, 3.5, 4.0, C#, VB.NET, MS Visio, C++, Visual Studio 2008-2013,, Plan View for Confidential, Lotus Notes, Sharepoint, Salesforce, Windows Phone 7 development, SSIS, SSRS

EXPERIENCE:

Confidential, Merrillville, IN

Adjunct Professor

Responsibilities:

• In charge of teaching the following subjects: Information Security, IIS Administration, and Database /XML
• Creating lesson plans
• Lecturing and administering exams
• Counseling students

Confidential, Rosemont, IL

Senior Project Analyst

Responsibilities:

• Creating ad-hoc reports using SSRS
• Database query creation and testing using SQL Server 2008
• Creating embedded code for SSRS using VB.NET
• Manipulation of medical related data
• Involved in creating and modifying current business processes
• Creating business and technical requirements
• Performing data analysis and database design
• Data modeling and data architecture using Visio

Confidential, Chicago, IL

IT Programming Manager

Responsibilities:

• Performing team leadership duties by overseeing other team members
• Delegating tasks to other team members
• Implementing project management duties by overseeing work schedules and work allocations
• Development of new internal systems using ASP.NET/C# 3.5-4.0
• Translate business requirements into technical requirements
• Provide status reports of team activities to upper management
• Formulate and define specifications for complex installations, maintenance and upgrades
• Utilizing 3rd party tools like Telerik for ASP.NET UI
• Supporting SharePoint document management system
• Performing data migrations and integrations using SSIS with SQL 2012-2014
• Performing data analysis and database design
• Developing application development and application security standards
• Modifying data structures using Entity Framework
• Creating and modifying SSRS reports
• Performing various DBA duties
• Performing IIS administration duties by overseeing deployments of web applications on existing Windows servers (Windows 2008 R2/Windows 2008)
• Performing some help desk duties
• Data modeling and data architecture using Visio
• Creating project plans and scope documents
• Being a liaison between staff members and the department
• Maintenance of existing systems using C#
• Acting Security Engineer by supplying credentials for existing applications
• Creating functional and UAT test cases
• On call support for problem resolution
• Creating user and technical documentation
• Scheduling SSIS jobs for data manipulation and cleansing
• Creating console applications using C#
• Responding to after-hours calls and emergencies
• Knowledge of IT processes
• Developing contingency plans for software disaster recovery
• Utilizing project management tools such as Confidential Project
• Enhanced web security by creating and implementing new web security policies
• Increased quality by creating and implementing new application development standards
• Increased efficiency by modifying software development workflows and plans
• Increased efficiency and quality of data by creating and introducing Business Intelligence tools to the department

Confidential, Chicago, IL

Technical Applications Analyst/Project Manager

Responsibilities:

• Creating Ad Hoc SSRS Reports
• Creating and modifying queries and stored procedures using SQL 2008
• Creating stored procedures using T-SQL 2008
• Implementing SQL Server Security functions
• Testing and modifying SSRS Reports
• Supporting and enhancing SharePoint site by creating and adding various components
• Supporting and enhancing SharePoint document management system
• Performing data migrations and data integrations using SSIS with SQL 2008 and SQL 2012
• Modifying and configuration MS Access Databases
• Performing data analysis and database design
• Implementing and creating procedures to ensure HIPAA regulations are following within business applications
• Implementing HIPAA practices by ensuring sensitive data is encrypted
• Holding status meetings with team members and external vendors
• Vendor Procurement
• Implementing database security scripts
• Responding to help desk tickets in a timely fashion
• Creating user and technical documentation
• Creating embedded code for existing reports using VB.NET
• Modifying existing code using VB.NET and JavaScript
• Interpreting existing code using C#
• Acting Security Engineer by supplying credentials for existing applications
• Acting project manager by overseeing million dollar software implementation projects
• Performing systems analysis on potential projects
• Overseeing off shore resources
• Creating data flow diagrams for upcoming projects
• Training and mentoring junior analysts
• Offering suggestions for contingency plans for software recovery
• Creating project plans and scope documents
• Supporting in house content management systems: SharePoint, Great Plains
• Creating functional and UAT test cases
• Interpreting Cerner reports using Confidential
• Data modeling and data architecture using Visio
• Responding to after-hours calls and emergencies
• Utilizing project management tools such as Confidential Project
• Increased efficiency by improving business processes
• Increased profitability and efficiency by implementing a new clinical, HRIS, and payroll systems such as ADP
• Improved training standards by providing new orientation processes and procedures
• Improved documentation standards

Confidential, Michigan City, IN

C# Application Developer

Responsibilities:

• Creating and maintaining web sites/internal web applications using ASP.NET/C# 3.5-4.0
• Application integration with various databases such as Oracle and SQL Server
• Creating queries to interface with JD Edwards
• Creating stored procedures using T-SQL 2008
• Data modeling and data architecture using Visio
• Developing applications using ADO.NET
• Creating SQL queries to interface with web applications
• Modifying existing Windows based applications
• Testing and modifying .WSDL web services using C#
• Creating unit tests using Visual Studio 2012
• Performing data analysis and database design
• Running performance reports on internal web applications
• Use of 3rd party tools such as Telerik, infragistics and JQuery controls
• Business and systems requirements gathering
• Holding status meetings with global staff members
• Overseeing junior staff members
• Modifying and creating data warehouses using SSAS
• Modifying data cubes using SSAS
• Client/Server applications
• Active Directory programming
• Creating UAT and functional test cases
• Implementing version control using Confidential Team Foundation Server
• Utilizing project management tools such as Confidential Project
• Increased departmental efficiency by providing technical solutions and better documentation
• Provided technical competitive advantage by introducing new methods and procedures
• Increased sales by improving the organizations e-commerce system using asp.net and c#

Confidential, Lansing, MI

Technical Systems Analyst

Responsibilities:

• Maintaining and developing various applications
• Modifying development standards
• Creating data flow diagrams for upcoming projects
• Creating new work flows in Tidal
• Creating batch file for testing purposes
• Business analyst duties
• Configuring Siebel connections
• Interpreting SQL scripts
• Adhering to federal standards while creating applications
• Ensuring data integrity by use of internal applications
• Following specifications and documentation
• Providing suggestions to several clients
• Data modeling and data architecture using Visio
• Overseeing staff members
• Monitoring and troubleshooting several business workflow processes

Confidential, Hammond, IN

Web/ Database Security Volunteer

Responsibilities:

• Analyzed the current disaster management system and identified potential security threats
• Aligned project requirements prior to implementation by performing extensive research on federal and HIPAA technical standards
• Implementing SQL Server Security functions
• Database modeling and creating UML diagrams using Visio
• Creating stored procedures using T-SQL 2008
• Creating user data types and encryption methods to ensure HIPAA regulations are followed within the application
• Application integration with data elements such as SQL Server
• Followed and created DFD diagrams to ensure proper data flow
• Enhanced disaster management system by applying security components using C#
• Created custom TDES encryption classes using C#
• Created custom login security classes using C#
• Creating web charts for data presentation using ASP.NET 4.0
• Created separate security interface using ASP.NET and C#
• Consumed federal web services to demonstrate X.509 based security
• Created mobile unit section of an existing disaster management system utilized ASP.NET/C# 4.0
• Application integration with data elements such as SQL Server
• Created stored procedures for reporting, data extraction, and to interface with the system
• Created custom data manipulation classes using C#
• Ensured application security followed CISSP and Orange Book standards
• Implemented database security methods using SQL 2008
• Created tables, stored procedures and triggers
• Created new users and roles within the database
• Utilized audit functions in SQL to integrate to the system
• Ensured the system followed federal and HIPAA regulations
• Defined HL7 data types in SQL 2008 databases
• Data modeling and data architecture using Visio

Confidential, Indianapolis, IN

Database Analyst

Responsibilities:

• Involved in rebranding project for Confidential by manipulating data to conform to the new specifications
• Utilizing ETL processes for data formatting
• Manipulation of a combination of Cerner and Lawson data
• Analyzing and creating use case diagrams using Visio
• Physical data architecture and data warehouse technique usage
• Creating complex queries using MS Access and SQL 2005 and SQL 2008
• Creating views in SQL 2008
• Ensuring HIPAA regulations are followed by hiding sensitive data
• Data integration with SQL Server to MS Access
• Manipulating data using SPSS
• Mapping data for data migration into the hospital systems
• Requirements gathering for implementation of projects
• Communicated to upper management of report issues
• Assisted in resolving data troubleshooting issues
• Participated in team meetings that includes discussion of technical specifications
• Informed Database Manager of potential database integrity issues
• Data modeling and data architecture using Visio

Confidential, Crete, IL

Database Specialist/Help Desk Analyst

Responsibilities:

• Cleaning and maintaining student related data
• Importing/exporting data into MySQL database
• Utilizing ETL processes for data formatting
• Installing and maintaining hardware and software
• Responding to troubleshooting tickets in a timely manner
• Ordering additional products required for troubleshooting
• Modifying user accounts in Active Directory
• Implementation of application security
• Experience supporting Blackberry mobile devices

Confidential, Hammond, IN

IT Independent Consultant

Responsibilities:

• Developed the company’s ticketing system using N-Tier architecture of ASP.NET, C# (3.5 framework)
• Utilization of AJAX Controls
• Application integration with data elements such as SQL Server
• Created and maintained databases using SQL Server
• Created and interpreted business requirements for all projects
• Installed new routers and peripherals to various sites
• Created and maintained databases using SQL 2005 and SQL 2008
• IT Procurement management
• Creating stored procedures using SQL 2008
• Physical data architecture for the new system
• Requirements gathering for specific projects
• Modifying and configuration MS Access Databases
• Implementation of web based security
• Documentation of functional business requirements
• Systems and database architecture
• Advised upper management of potential security issues
• Assessment of internal controls in compliance with Sarbanes-Oxley 404
• Hardware and software troubleshooting and maintenance at various sites
• Utilizing project management tools such as Confidential Project
• Data modeling and data architecture using Visio