SUMMARY

• Creating competitive business advantages and bottom - line impacting initiatives through cutting-edge technologies, innovative application and database development.
• Talented senior BI developer with comprehensive experience delivering high-quality technical solutions to global organizations.
• Demonstrated strengths in project management, business analysis and real-time database modelling.
• Provided industry insight and technology expertise in automation new initiatives for healthcare/print industry.
• Energetic IT professional with excellent work ethic.

TECHNICAL SKILLS

Software: SSIS/SSRS, VB.NET, ASP.NET, ADO.NET, XML, XSLT, VBA, T-SQL, PL-SQL, OLE Automation, iTextSharp .NET PDF library, ExcellWriter component, Web Services, SharePoint Designer.

RDBMS: MS SQL Server 2000/2005/2008/2014 , Oracle8i, MS Access, DB2.

Hardware/Operating Systems: Microsoft Windows NT, 2000, XP.

PROFESSIONAL EXPERIENCE

SR. Application Developer

Confidential

Responsibilities:

• Built SSIS complex package that integrates FedEx web services shipping functionality through transformation script component. Scrubbed demographic data provided by JP Morgan to ensure timely and accurate shipments of accounting documents. Created tracking reports for business users using conditional split task.
• Converted VB6 application to BIDS project, fully integrated with new requirements.
• Read and loaded data from XML files utilizing Script Component as source. Improved performance of processing HBCBS Commercial contracts 6 times by developing code with
• ITextSharp PDF library. Generated documents based on data from XML or Excel.
• Merged and modified pages from existing PDF document. Used XML Task to format xml utput from stored procedures as an html e-mail message with built in table of counts.

SR. Programmer Analyst

Confidential

Responsibilities:

• Led the project that will automate the generation and distribution of Excel monthly reports for Sales department that are based on the Sales SharePoint site. Built SSIS package to incorporate the data into a data warehouse utilizing SharePoint List Source (SharePoint adaptor installed).
• Worked on improving of Recertification Daily Update process that runs nightly and resets statuses for qualified Child Plus members. Wrote TRD document to adjust present logic to new business situation. Modified code in complex stored procedure that enables Income Change Applications correctly feed recertification Extensions of Facets database.
• Designed and developed Customer Service Top 10 report using Crystal Report and Infoview Tools. Analyzed and pulled complex data from Facets database, improved performance of the report by doing performance tuning in stored procedure.
• Worked with Facets extensions VB.NET windows custom applications and TFS.

System Programmer Analyst

Confidential

Responsibilities:

• Migrated multiple databases from SQL server 2005 to SQL Server 2008(64 Bit OS). Set up database and server level permissions. Transferred logins and passwords. Moved jobs and operators. Created proxies to enable SQL Server Agent functionality across the network.
• Worked with Microsoft VSA to connect to different Data Sources, using managed/unmanaged connections in Script Component.
• Served as an SQL server expert in the DocScience Group to implement best practices, real world guidelines and tips for optimization and normalization of databases.
• Improved reliability and streamlined Mass mailing Go Paperless internal workflow. Processed campaign custom data by loading it into SQL server database and splitting it by
• Paper/Paperless flag. Generated Scrub and Index Files to be sent to vendors.
• Obtained member information by Consuming Web Services in SSIS Script transformation component.
• Wrote meta-data directly to the HIP portal utilizing web service calls. Built the file to be submitted to ExactTarget for e-mail process.

Application Developer

Confidential

Responsibilities:

• Worked with the team for a new Contract Auto Assign Project that automated the process of assigning various types of contracts on daily basis. Automations targeted QBLUE contracts module, registered trademark of QCSI, Inc. Due to the large anticipated volume of attached contracts and constant updates for the new ranking methodology and performance based reimbursement structure it was decided to include new process to the existing contract auto assign utility.
• R esponsible for low-level design, analysis, coding and testing of Quality Recognition process, that assigns corresponding types of contract to the providers based on performance level attributes, networks, indicators, regions and programs.
• Extensively used SQL Query Analyzer and Enterprise Manager to review schema of QBLUE, QMACS databases. Developed stored procedures with enabled control and balance technique. Created complex correlated sub quires utilizing different predicate functions and CASE statement.
• Wrote queries that linked multiple base and intermediate working tables by constructing outer/inner joins (INSI compliant syntax) and using various date & format functions. Built logic that populates contracts by analyzing provided attributes - performance levels (data loaded from CREPRO feed) using Transact SQL cursor loops.
• Developed DTS package with multiple consequent steps to reflect the flow of QRP process.
• Participated in the coding of console application designed to update XML data table (BizTalk Data) using VB.NET SQLDataReader, XmlDocument, XmlElement

Confidential

Responsibilities:

• Responsible for technical design, coding and implementation of the new Healthcare product: CDH MyWay 2006.
• Did analysis to match collected data to file specifications and mapping documents, write specks for the system architecture. Built Common module that populates, massages and formats data used in three feeds sent to different partners.
• Created stored procedure utilizing table variable to store and spin data in text format to final destination.
• Created DTS packages scheduled and run through BMC for Outbound/Extract File processing.
• Used Control and Balances technique to control correct number of counts and each step of the processes.
• Designed database objects: tables, indexes and constraints, enforcing Referential Integrity.