SUMMARY:

• Solid experience in all aspects of the SDLC from the initial system planning to the implementation phase with an emphasis on Data Warehouse/BI practices
• In - depth knowledge of relational database concepts and extensive experience developing scalable and reliable database solutions using Microsoft SQL Server. Proficiency in logical and physical database design, development and optimization
• Extensive experience in design, development and implementation of ETL solutions utilizing SSIS.
• Strong knowledge of Data Warehousing techniques including data analysis, dimensional modeling and ETL processes
• Proficient in development and implementation of BI solutions using Microsoft BI stack
• Working experience ranges from developer to project lead throughout all facets of system development

TECHNICAL SKILLS:

Programming Languages: SQL-2005 (2 years), SQL-2008(4 years), SQL 2012(2 years,) SSIS, SSRS, Microsoft Access, , DB2, Database Technologies Microsoft SQL Server, Development C#.NET (3 years), Silverlight 2.0 (1 month), ASP / JavaScript (2 years), XML (1 year), HTML (4 years), ASP,NET (3 years), ASP.NET(MVC3, AjaxT-SQL (4year), Crystal Reports (1 year), Visual

EXPERIENCE:

Confidential, Jacksonville, Fl

SQL / SSIS BI Developer

Responsibilities:

• Working in the HealthCare Industry Design and implement custom SSIS Packages and SQL on a project-by-project basis.
• Strong and proven SSIS and TSQL skills, store procedure, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• TSQL skills. Create and analyze complex queries via execution plans
• VBA ACCESS. maintenance and enhancements
• Good understanding of Database tuning and query optimization in SQL Server 2005-2012.
• Design and develop solutions that support current application architecture and strategic direction.
• Coordinate, support and maintain Enterprise wide systems.
• Responds to incoming calls and emails, for problem determination and resolution.
• Convert Access 2010 to SQL Server applications
• Perform additional duties as determined by business needs and as directed by management

Confidential, Lenexa, Ks

Professional Services Software Consultant

Responsibilities:

• Successfully design and implement Confidential ’s Enterprise Software solution Utilizing TSQL-SQL 2012 for a variety of different industries and customer environments. Consultants design and document functional details and share these with customers and the Confidential ’s Enterprise Software project team.
• Perform more technical activities, including software deployment, configuration, troubleshooting and system administrator/end-user training.
• Work with project managers and other consultants as a collaborative team to deliver quality solutions to our customers. As contributing members of their project teams, consultants prepare the customer for the onsite implementation and help control project scope. Consultants are also expected to thoroughly document all functional and technical aspects of system implementations and to communicate accomplishments and issues to Project Managers and customers on a daily/weekly basis.
• TSQL-SQL 2012 used for maintenance, manage, and creations of Database and tables when needed as a corrective action data from extraction software.

Confidential, Atlanta, Ga

Software Developer

Responsibilities:

• Convert Cold Fusion programs to MS SQL Server 2012.
• Creation of SSIS packages to bring in data from remote sites for reports and procurement personnel
• Develop business application using SQL 2012,& Oracle Database 11g Release 2
• Creation of SQL financial reports per request
• Use of TSQL for maintenance and errors reflected on Procurement Report
• Review TSQL queries created by other developers for adherence to standards and performance issues
• Creation of triggers and Stored Procedures used to alert specified power users of certain transactions taking place within the database
• Creating Views
• Strong ability to reconcile data and processing problems
• Fine Tune Existing Queries using executions plans and MS Profiler
• ADO.Net Application Development and maintenance.
• Create Web Design MVC Applications etc.; utilizing Visual Studio 2012.
• Maintenance of Financial applications utilizing JavaScript, HTML 5, CSS front end
• Set up and maintain database environments to support production and development activities.

Confidential, Tampa, Fl

Senior Software Implementation Consultant

Responsibilities:

• The Consultant is responsible for the post-sale planning, scheduling, and implementation and configuration of software applications and delivery of related Professional Services. The Consultant is the focal point for project communications to ensure success of the project. I am also responsible for the overall customer satisfaction for the assigned project and for coordination of all Client resources assigned to the project.
• SSIS used for transporting and distributing customer data to stakeholders
• T-SQL 2008r2, 2012 to Create tables and Database
• Crystal Reporting.

Confidential, Decatur, Ga

Programmer /Analyst - Consultant

Responsibilities:

• TSQL 2008.-2012, fine Tuning
• Converting FoxPro over to SQL Server 2008 using SSIS
• Creating Triggers and Stored Procedures
• SSIS environment. Other responsibilities include assisting in the redesign and conversion of all current applications, acting on trouble calls from Commission staff, assisting in the design and maintenance of the SACSCOC Web site, setting up and configuring new hardware and software as needed, and assisting the Director of Computer Operations with his responsibilities.
• Visual Studio 2010, 4.0.
• ASP.Net MVC3/ C#

Confidential, Atlanta, Ga

Software Implementation Analyst

Responsibilities:

• Installation of new software applications and software upgrades as planned; insuring process is carried out accurately.
• Modify and support of software configurations using
• TSQL 2008, related reports and other documentation as required.
• Creation of Tables, Views On-site/remote installation of POS hardware (terminals, touch screen monitors, pin pads, cash drawers, etc.).
• Ensure system initialization and communication with software at all levels (Enterprise, Management, and Terminal).
• Execute database backups and recoveries.

Confidential, Decatur, Ga

Dot Net/ SQL Support Developer

Responsibilities:

• SQL 2005, 2008, Creating reports, correcting data issues etc
• Provided support for existing ASP.Net MVC2, C#, VB.Net, and
• Visual Studio 2008, 3.5 programs (UI to Database level - MVC) using designated product technology architecture and frame works.
• Provide technical design, coding assistance to the team to accomplish the project deliverables as planned/scoped.
• Perform Research and Development on newest technical components and make recommendations such as report engine, UI frame work, security, open-source etc.

Confidential, Norcross, Ga

SQL Developer

Responsibilities:

• Consultant SQL Developer consultant of a two member team responsible for designing, developing, and maintaining an executive management and accountability system which includes the following responsibilities:
• Design and development using T-SQL, and SQL Server 2008 procedures, query performance tunings and SSIS packages.
• Creating Reports using the SSRS Report Builder Application utilizing the Report Builder and/or using versions of Microsoft Visual Studio with the included Business Intelligence Projects plug-ins installed
• Develop underlying data models and databases.
• Develop, manage and maintain data dictionary and or metadata.
• Ensure compliance of standards and conventions in developing programs.
• Participated in Design, Develop and implement complete life cycle of data warehouses and creating cubes.
• Translate business requirements into software applications and models.
• Resolve TSQL Query execution and troubleshoot complex issues with existing Scripts.
• Perform and execute data extraction, transformation and loading New Data.
• Maintain and manage all versions of data models for production, testing and developing databases
• Creating Store Procedure and Triggers as requested for new and existing systems