TECHNICAL SKILLS:

• MSSQL Server 2005/2008/2012 ETL/SSIS/SSRS 2005/2008/2010 Data Modeling/Design
• SAP BusinessObjects/Crystal Reports TFS/VSS FTP/SFTP/SSL
• VB.Net

PROFESSIONAL EXPERIENCE:

Sr. SQL Developer

Confidential, Irving, TX

Responsibilities:

• Automated several ETL data processes and reports by utilizing Microsoft SQL T - SQL stored procedures and SSIS/SSRS 2010 that included but not limited to T-SQL queries, variables, cursors, stored procedures, and views. Month-end data processing time was reduced from 10 business day down to 4 business days.
• Worked with IT colleagues as well as Subject Matter Experts to implement new Insurance Policy Underwriting required financial data reporting through SAP BusinessObjects XI R4.
• Followed normal SDLC standards from design specifications to user acceptance and communicated with the business units to ensure data feeds/reports were error free and met data requirement specifications.
• Updated existing technical and reporting documentation to include data workflows, graphics, and detailed step by step procedures.
• Assigned required project tracking system ticket numbers for any helpdesk issues/troubleshooting and/ or new IT projects. Created detailed technical specifications and release documentation for assigned projects.
• Worked effectively and rapidly with IT colleagues to assist and resolve all IT/ETL error related issues.
• Converted numerous MS Access 2003 reports into automated ETL processes utilizing SSIS 2010 and SAP BusinessObjects.

Datawarehouse Developer

Confidential, Richardson, TX

• Worked closely with the Business Analysts, Business Subject Matter Experts, and fellow IT colleagues to complete system requirements, technical specifications and process documentation for various data warehouse projects to qualify and define the project requirements as well as document the development.
• Developed ETL and data warehousing solutions with Microsoft SQL Server product and services that involved using T-SQL queries, CTEs/temp tables, stored procedures, user functions, and views.
• Reviewed and analyzed the scope of the business problems presented and helped identify viable technical solutions.
• Worked on a team/project to develop wealth management ETL and data warehousing solutions with Microsoft SQL Server products and services including SSIS/SSRS 2008.
• Created detailed technical specifications and release documentation for assigned ETL and reporting projects.
• Strongly followed published development standards and database best practices that resulted in consistent implementation of project components.
• Ensured data integrity, performance quality, and resolution of SSIS data load failures and SSRS reporting issues.

Senior Analyst

Confidential, Irving, TX

• Analyzed and designed moderately complex reports to satisfy management requirements by incorporating MSSQL 2005 and SSIS/SSRS 2008.
• Developed ETL solutions for the collection and processing of financial data required for daily operational reporting.
• Followed business standards for processes and procedures including, but not limited to table structures, relationships, coding, testing, debugging, implementation and documentation.
• Assisted DBAs with regards to all ETL/Reporting error related issues.

ETL SQL Developer

Confidential, Irving, TX

• Automated numerous clinical/medical information reports via Crystal Reports for business users in a timely manner.
• Developed numerous member/clinical/provider ETL and reporting solutions with Microsoft SQL Server products and services as well as SSIS/SSRS 2005 and SAP Crystal Reports.
• Incorporated company standard error-handling procedures within all ETL and reporting projects.
• Assisted with customizing billing/claims payment system with the federally mandated HIPAA required EDI claim format (837P) and the EDI remittance format (835).
• Followed standard SDLC processes by developing data requirements/specifications for both internal and external customers, writing numerous technical documents, providing data quality review and testing, and implementing approved data solutions.
• Worked closely and effectively with fellow IT colleagues and project management staff to provide a tightly integrated IT system and assisted with Help Desk support staff regarding all IT related issues.

Clinical System Analyst

Confidential, Dallas, TX

• Created ad hoc report requests and enhanced standard State of Texas DSHS weekly and monthly Crystal Reports XI report requests and provided the State of Texas NorthStar member enrollment information in a timely manner.
• Data extracts (claims/clinical/enrollment) were provided by utilizing DSHS’s Data Warehouse and MSSQL 2005 SSMS components which included T-SQL queries, cursors, views, functions, and stored procedures.
• Communicated with upper management and external customers including the State of Texas DSHS staff to gather data requirements, developed technical specifications, and provided data and report solutions.
• Wrote and updated technical documentation for the numerous Data Warehouse projects as well as established standardized reports.
• Assisted all business end-users and management with all PC-related software and hardware issues and resolved the issues in a timely manner.

Confidential, Dallas, TX

Business Systems Analyst

• Utilized Microsoft SQL Server 2000 ETL Developer Tools to determine the best solution for data requests.
• Communicated on all levels with Confidential users to gather data requirements, establish technical specifications, provide data review and testing, and implement data solutions.
• Developed numerous automated Crystal Reports 10/XI reports for different users’ requests. Implemented and maintain MS Business Solutions Dynamics SL EDI (810, 850, and 855) files between Confidential and their customers in order to provide accurate fast purchase order/invoice turnaround.
• Provided technical documentation for numerous Information Technology on-going projects and already established standardized reports as well as write knowledgebase articles for fellow IT associates.