SUMMARY

• Over 10+ years of experience as Microsoft BI developer, database developer and data analyst with Microsoft SQL Server 2016/2012/2008/ 2005 , SSIS/SSRS/SSAS, OLTP, OLAP (Different environment such as Production, UAT, and development).
• Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, Go live and Post Go Live Support.
• Experience in different phases of Project Life Cycle (Analysis, Design, Implementation, Testing, and Debugging new/existing client - server based applications.
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Developed several Electronic Data Interchange (EDI) Parsers for different Medicaid feeds like 820, 824, 835 and 837 using C# and T-SQL
• Designed and Developed Risk Adjustment Process tool, which allows analyze the Risk and helps to outreach providers on their members.
• Expert in designing (development) and deployment of SSIS package from various sources like MS access, oracle, Excel, Microsoft SQL Server, flat file, and XML.
• Proficient in performing various SSIS data transformation task such as Look-ups, Fuzzy Look-ups, Aggregate Functions, Merge Join, Conditional Spilt, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.
• Proficient in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages using SQL server agent.
• Expert in creating various types of complex reports using SSRS (SQL server reporting services) such as Drill-Down, Drill-Through, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Expert in Designing and deploying reports on the portal as per the end user requests using web interface, SharePoint and report manager.
• Experience in reporting services configuration manager to configure and maintain Report Manager, Report server, Send emails to the end user, and Scheduling reports.
• Proficient with T-SQL (DDL, DML, DCL, and TCL) in implementing Complex Stored Procedure, Indexes, Views, Table Variables, Triggers, Nested Queries, Joins, Cursors, and user and system defined functions
• Excellent experience in MS SQL Server database and ETL capabilities using SQL Server Business Intelligence Studio (BIDS) and SQL Server Management Studio (SSMS).
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Experience in creating visualizations and reports using SSRS Charts.
• Collaborated with Business Analysts, Web development team and End-users on database solutions.
• Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment.

TECHNICAL SKILLS

Modeling Tool: MS Visio, SQL Server

Methodologies: SDLC Waterfall, Scrum, Agile methodology.

BI Tool: SSIS, SSRS, Report Builder, SharePoint

Database Tools: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), Team Foundation Server, Visual Studio, UltraEdit

GUI /Tools: MS Word, MS Excel, MS PowerPoint.

Database & Query Tools: SQL Server 2016/2012/2008/ R2/2005, Oracle 10g, MS Access, DB2/400

Operating Systems: DOS, Windows 98/95, Windows XP, UNIX, Windows 10.

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Risk Adjustment Data Analyst IV

Responsibilities:

• Developed Several Electronic Data Interchange (EDI) Parsers for different Medicaid New Jersey State feeds like 820, 824, 835 and 837 using C# and T-SQL
• Developed Several SSRS reports for Executives Decision Making and for Data Reconciliation purposes and integrated with SharePoint
• Developed Medicaid Risk Adjustment Management Tool (SSRS, SQL Stored Procedures, MS SharePoint) for clinical review and outreach.
• Built operations dashboards (SSRS, SQL stored procedures, MS SharePoint) for monitoring encounters processing, completion rates and backlogs.
• Developed Several SQL Server Jobs (SSIS, SQL Stored Procedures) for automated data loads from New Jersey State and other Vendors into and out of SQL Server.
• Developed several tools using C# to automate manual process like files moving, emails on executive and data reconciliation reports.
• Identified issues in encounters processing and worked with vendor teams to resolve them to reduce the revenue backlog.
• Mentored and Trained several team members in .Net and SQL Server.

Environment: s: SQL Server 2016/2012, T-SQL, SSRS, SSIS, C#, SharePoint, Visual Studio, EDI.

Confidential, Pennington, NJ

Application Developer/On-Call & Prod Support

Responsibilities:

• Developed Several SQL Server Jobs (SSIS, SQL Stored Procedures) for automated data loads from New Jersey State and other Vendors into and out of SQL Server.
• Developed Several SSRS reports for Executives Decision Making and for Data Reconciliation purposes and integrated with SharePoint and SQL Server Reporting Services.
• Developed and Maintained (ASP.Net, C#, SQL Server) Member Centric Intranet Application.
• Developed and Maintained (ASP.Net, C#, SQL Server) Provider Centric Intranet Application.
• Developed several tools using C# to automate manual process like files moving, emails on executive and data reconciliation reports.
• Many enhancements have been done to the existing business application as requested by business users through Request Tracking System (RTS).
• Involved in Weekly on-call and production support
• Lead Disastrous and Recovery Exercise from IT point of view
• Developed an application to download Users, Groups, and Users Groups data from Active Directory (LDAP) into SQL Server database for daily and weekly updates
• Migration of back-end processes on all related servers while one of SQL servers was being migrated between AD domains.
• Created SQL CLR Assemblies using C# for general FTP solution which works for both secure and regular ftp operations.

Environment: s: ASP, ASP.Net 1.0/2.0/3.5, MVC, C#, ADO.NET, SSRS, SSIS, JavaScript, XML, XSD, CSS, HTML, Visual Studio, IIS, SQL Server 2005/2008, MS Access, COM, LDAP.