SUMMARY:

• Multi - faceted solutions provider with an impressive history of transforming business requirements into innovative database solutions.
• First-rate database engineer with extensive qualifications in all facets of information systems methodology from conceptual design through implementation, quality review, documentation, user training, and enhancement. SharePoint designer and implementer; facilitating collaboration within the organization. Skilled report designer; turning raw data into usable knowledge. Demonstrated ability to prioritize multiple, conflicting tasks and meet operational deadlines in an ambiguous, fast-paced environment.
• Respected as a dedicated, results-oriented project manager as well as an inter-organizational team player.
• Looking for a continuously challenging position with the opportunity to make an impact and develop professionally.

TECHNICAL SKILLS:

Languages: HTML, VB.Net, Transact SQL, CSS, Knowledge of Javascript, C#, XML

Reporting:: Tableau, Crystal Reports XI R2, Knowledge of SSRS

Web: Visual Studio. NET Professional 2010

Database: SQL Server 2008-2012, SSIS, SSAS

ETL: SSIS, Informatica

General: Microsoft Office 2016 (Access, Excel, Outlook, PowerPoint, Word, Publisher), Microsoft Visio 2016, Microsoft InfoPath 2010

PROFESSIONAL EXPERIENCE:

Sr. Solutions Development Analyst

Confidential,Austin, TX

Responsibilities:

• Profile incoming health care data to transform before importing into current databases and EDW.
• Create databases as needed from idea to implementation; including creating ERDs, business process diagrams and database schemas and building the physical database and testing functionality.
• Architect and Develop ETL processes using SSIS and Informatica Powercenter.
• Provide support/guidance to other ETL developers on architecture standards and processes.
• Technical Team Lead for creation and implementation of Provider master data management system in 6 months. Also developed database, SSAS cube and Excel pivot tables for this solution.
• Key ETL developer in data profiling, integrating membership and claims data from five third party administrators into EDW and data validation within 5 months.
• Re-architected Provider Risk Analytics project to reduce data latency from several months to monthly data flow.

Sr. Developer

Confidential,Austin, TX

Responsibilities:

• Responsible for maintenance and development of internal Medicaid related systems within the department.
• Troubleshoot and resolve user issues with Windows applications, backend SQL Server databases and Access databases.
• Add new functionality to Windows applications as needed.
• Design queries and stored procedures for SQL Server databases.
• Maintain and update Microsoft Access databases.
• Create and update Crystal Reports as needed.

Sr. Software Developer

Confidential,Austin, TX

Responsibilities:

• Responsible for all internal development for three companies; including database, web and report.
• Project managed all development projects from idea to implementation.
• Planned, executed, managed and tested integration of new applications into existing systems and software throughout the enterprise.
• Designed, implemented and maintained all Microsoft SQL database systems.
• Responsible for development and maintenance of all internal custom .NET websites.
• Responsible for design and development of Corporate Intranet for three companies created with SharePoint Server 2007, technical support and training.
• Wrote business requirements, technical specifications, database design documentation and on-line help content and conducted user training as part of various development efforts.
• Created reports for all areas of company using Crystal Reports.
• Responsible for all phases of product life cycle for all in-house developed software and web sites.
• Spearheaded extensive Marketing System project providing a tool for lead generation collaboration, work projection and trend analysis. System encompassed web development, database development and report and form creation.
• Developed electronic Accounting job cost reports to replace paper reports. Re-engineered management report delivery process by developing an automated delivery solution. Solution reduced labor costs; reduced printing costs by 50% and provided managers an output format that could be used for further analysis and forecasting.
• Project manager of SharePoint implementation. Responsible for needs discovery and design of SharePoint Corporate Intranet and job sites and immersing SharePoint into company culture enabling enterprise-wide communication and collaboration. Configured mobile apps on iPhones to make SharePoint site data available to field users.
• Developed and implemented electronic pay stub delivery solution using Crystal Reports, Microsoft SQL and CRD; eliminating printing and mailing costs for direct deposit employee paystubs.

Business Analyst

Confidential,Austin, TX

• Provided day-to-day support for users’ financial application system (Costpoint) issues; escalating issues to software vendor support or corporate technical staff as needed.
• Assisted users in creating individual queries/reports to provide them information (Cognos ReportNet)
• Managed software projects to implement new procedures/processes for the users.
• Created functional specifications based on user requirements for development and data configuration changes.
• Worked closely with super users to identify problem areas and future enhancements for financial application.
• Unit tested developed interfaces and reports and test patches applied to software.
• Analyzed system data for issues using database querying tools (SQL Talk/SQL Developer).
• Designed system process business flows for corporate documentation.

Application Support Specialist

Confidential,Austin, TX

• Provided day-to-day support for mission critical production systems - handling application system issues, database integrity, system security, answered user queries and monitoring applications to ensure maximum system uptime. Systems include Microsoft Solomon & TeamTrack.
• Responsible for Database Administration functions for all support application databases and company projects as needed.
• Maintained and implemented new functionality to company’s Business Portal (SharePoint).
• Created program management and other financial reports increasing efficiency of monthly analysis and other reporting processes using Crystal Reports.
• Developed and maintained up-to-date electronic documents on system configuration, application security, program code modifications and enhancement, problem tracking, and user documentation.
• Worked with other departments to provide project management, business impact assessments, and/or technical support related to the selection, installation, and management of application software systems.
• Researched additional functionality in current applications to determine benefits to the company infrastructure.

Application Integration Specialist

Confidential,Hampton, VA

• Performed Database Administration functions for managing all Corporate Enterprise databases using SQL Server 2000.
• Evaluate, plan, execute, manage and test integration of new applications into existing systems and software throughout the enterprise.
• Wrote specifications, documentation and on-line help content and conducted user training as part of various development efforts.
• Integrated Windows SharePoint application into company culture enabling enterprise-wide communication and collaboration.
• Created web-based employee, financial and program management reports reducing supply costs by 25% and enabling management to make more timely decisions using Cognos Impromptu and Crystal Reports.
• Implemented new budgeting software (Prophix) enabling Finance Manager to perform forecasts on data and provide a more detailed view of spending overages.
• Provided application support to all levels of the organization.
• Developed interfaces between applications using Microsoft Access and Microsoft SQL Server to share data.
• Ensured that development and integration planning and practices are aligned with strategic business goals and the company’s overall strategic vision.