• Core member of Data Extraction Services Team, which is responsible for the design and development of Java Service API, which is intended to retrieve data from Oracle database and return it in XML format to the end users. End users are basically consumers, who built front end application using these XMLs.

• Lead a team of 3 engineers in an Agile, Scrum methodology to ensure quality code delivery.

• Design, develop best practices and perform end to end testing for building Web based RESTful API services for Cerner HL7 FHIR (Fast Healthcare Interoperability Resources) for retrieving Patient information using JAX-RS (Java API for RESTful Web Services / Jersey).

• Design, develop and test synchronous and asynchronous multi-threaded application in Java to improve performance and monitor the health of Cerner’s platforms and systems.

• Automating testing using both Test Driven and Behavioral Driven Development in Java (Junit / Mockito / PowerMockito) & Scala.

• Monitoring Performance tuning on the Java heap dumps using Java Mission Control and Flight Recorder and analyzing Java Garbage collectors.

• Branch and merge code repository for SVN (Subversion), Git & Beyond Compare.

• Developed Splunk infrastructure for the team, and wrote Splunk queries that continually monitors Client and Internal server logs and reports if any failure occurs to mitigate any risk.

• Participate in peer to peer code review via Atlassian Crucible.

• Oversee project workflow, mentor new associates, organize relevant issues and following team activities using JIRA.

• Created new processes & maintained existing database processes in an OLAP (DSS) datawarehouse.

• Created and maintained ETL Tools, Tables/Views, Triggers, Functions, SQL stored procedures/queries/codes.

• Developed and scheduled SQL Server Integration Service (SSIS) packages & jobs to update analytical Database Servers (MS-SQL Server 2008, MS Access, MySQL, Oracle) and extract information.

• Wrote complex Adhoc / SQL queries with T-SQL & PL/SQL and integrated various systems using SQL Server Analytical Services & SQL Server Reporting Services to form a data warehouse or data marts.

• Built and generated reports using Crystal Reports 2008 & PowerView using PowerPivot and MS Excel.

• Extracted data from multiple data sources, transforming them via standardization, data mining, cleaning, data repair & matching and manage all technical aspects of ETL process using SQL Server Integration services (SSIS).

• Built a true Dimension and Fact model (STAR / Snowflake) schema for various datawarehouse systems.

• Built OLAP Cubes (Dimensional Table modeling) along with MDX queries facts to support UHS in decision making for the Healthcare Industry & Services.

• Administered executive dashboard for the OLTP dataflow across the HIPAA compliant hospital.

• Created and deployed SharePoint templates, master pages, workflows, sites, pages, lists, libraries, scopes, views, columns.

• Trained and assisted the financial & clinical teams to use the Business Intelligence & Development tools.

• Developed various web applications across the hospital department using OLAP / OLTP database (ASP.NET using C#).

• Performed data replication & off-line backup protection through nightly updates