SUMMAY

• Over 12 years of IT experience in application/database development/maintenance and technical support
• Experience in major database technologies such as Microsoft SQL Server, Oracle, DB2/400, MS Access
• Focus on Microsoft suite of tools including .NET/ASP, TFS, SharePoint, DTS/SSIS/SSAS/SSRS with SQL Server 2002/2008/2012, MS Access, MS Excel automation with VBA
• Industry experience in Pharmaceutical and Health Insurance/Care, Auditing areas
• Strong Data / Application development experience (6+ years) using T - SQL, ASP.NET, and C#
• Business Intelligence/reporting experience with SSAS, SharePoint, and Business Objects
• Ability to work independently and as a team player delivering results within agreed timeline
• Customer service focus with managing multiple customer demands at the same time
• Adaptable to change, with an eagerness towards learning and growing capabilities

TECHNICAL SKILLS:

Languages: T-SQL, Python 3.0, R 3.4.3, ASP.NET 3.5/4.0, C#, VB6.0 / VBA, XML, Java, BAPI (SAP), PL-SQL

Web Technologies: Java Script, jQuery, XML, Web Services, JBoss

Software Platforms: MS Visual Studio 2010/2005, TFS/VSS, RStudio, Salesforce.com, jupyter

Databases: SQL Server 2014, 2012, ORACLE 12c, 11g, 10g, 9i, DB2/400, MS Access

CRM: Salesforce.com, Custom-built CRM using SharePoint 2010, PegaSystems GSPM/PCS

Manufacturing Automation Systems: Electronic Batch Record Systems, ERP, LIMS, ELN, MES, MCAS, SCADA

ETL/ OLAP/BI Tools: SSIS, SSAS, Business Objects 5.1

Dashboard: Crystal Reports10/8.x, SSRS, Excel automation using VBA, Qlik Sense, Power Pivot, Tableau

Healthcare Coding Standards & EDI: HL7, X12, 837, 834, 270, 271

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

SSIS/SQL Developer Consultant

Responsibilities:

• Developed and supported multiple Projects using SQL Database, Oracle, and SSIS, C #.NET, R and MS BI tools:
• Developed SQL Database Applications, ETL, and Job Automation using SQL Server and C#.NET tool.
• Worked on Data Extract, Load and transformation (ETL) from different data Sources in Agile environment and multiple competing priorities.
• Worked with different Data Scientists and Auditors for providing required data in specific format from different data sources using SSIS, SSAS, R, Python, C#.NET, SQL Server.
• Worked on OSA Financial application and CIW revenue Qlik Sense Dash board based on CIW data warehouse database and automated data refresh using SSIS.
• Worked on All Payers Claims Database (APCD5.0 and ACD6.0) to Extract, Load, and Transformation (ETL) of terabytes data.
• Maintained, modified, optimized OSA data warehouse using SSIS, SQL Server which minimizes the downtime and maintenance time.
• Worked on Risk Distribution Center (RDC) application, which is used to generate Risk Score for the Audit of different Agencies of Commonwealth based on different Risk Model Rules.
• Worked on OSA Financial Data and Commonwealth data warehouse, which are used to keep the track of time sheet, people, Audit status and history of all Audits.
• Participated and worked in Teammate Audit Application and OSA data warehouse upgrade;
• Participated in Test implementation by creating ASP.NET application and MS SQL database on AWS cloud platform as a part of POC

Confidential, Framingham, MA

Principal Consultant

Responsibilities:

• Analyzed existing deployment/decommissioning processes, identified gaps, and addressed those gaps through simplification and process improvements. Researched and studied installation configuration settings for production deployments. Gathered client and environment specific configuration settings in templates and created production deployment documentation.
• Tested deployment plans by installing Java based Orion Rhapsody Integration Engine 4.1, Rhapsody IDE, and Rhapsody Management Console in HL7 windows environment. Configured HL7 customer account in Rhapsody IDE and deployed it into the development environment.
• Maintained, supported and monitored multiple applications in the production environment.

Confidential - Shrewsbury, MA

SharePoint Consultant

Responsibilities:

• Gathered new business requirements and modified system design specifications.
• Modified site definition added and configured web parts.
• Imported/Exported data between excel and SharePoint lists and added content as per the requirements.
• Created custom permission using groups and roles in SharePoint 2010.
• Created documentation for better maintenance and support.
• Developed SharePoint Reports/ Views.

Confidential - Worcester, MA

System Admin/Application Support Specialist

Responsibilities:

• Gathered business and functional requirements, developed/configured, and tested in the dev environment.
• Created traces using SQL Server profiler to find long running queries and modify those queries as a part of performance tuning operations.
• Utilized TFS source control to check in /out and promote codes to production.
• Used HP Service Center Software to manage the testing/defect tracking.
• Created Ad-hoc reports and dashboards in SharePoint 2010.
• Designed ETL data flows using SSIS; created mappings/workflows to extract data from Oracle database and migrated/loaded to SQL Server 2012.
• Designed and develop new SSAS Tabular Models and provided Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.

Confidential - Boston, MA

Software Engineer

Responsibilities:

• Performed requirement analysis/gathering.
• Modified code, developed SQL queries, stored procedures, and triggers using SQL Server 2008.
• Utilized SQL Server profiler to track performance issues and modify SQL queries to improve performance.
• Created, deployed and automated the patient data KPI reports for different departments using SSRS.
• Provided post-go live support until steady state and transitioned support to the outsourced service provider.

Confidential -Westborough, MA

Programmer/Analyst

Responsibilities:

• Worked with business users directly to gather requirements.
• Configured, tested and implemented code changes to productions.
• Developed reports using SQL Server Reporting Services (SSRS).
• Analyzed and modified X12 EDI formats transactions to comply with HIPAA.

Confidential, Bedford, MA

Systems Consultant

Responsibilities:

• Used SSIS import/export wizard for performing the ETL operations.
• Loaded data from different sources such as flat file, Excel, and Oracle to SQL Server 2008 using SSIS.
• Created target database structures, mapped data to target and loaded the data from source.
• Created SSIS packages to pull data from Excel and import in SQL Server.
• Created automated jobs using SQL Server Agent and monitored their execution.
• Collaborated with teams and clients to ensure that the changes were fully tested pre go-live.
• Worked in Agile/Scrum environment to manage concurrent change requests.

Confidential

Systems Engineer IV/IC

Responsibilities:

• Created SSIS Package to transfer the in-SQL server 2008 during product change over setup.
• Designed, developed and deployed reports in MS SQL Server 2008 using SSRS and Crystal Report.
• Created reports with Analysis Services Cube as the data source using SSRS.
• Scheduled automated jobs using SQL Server Agent..