Software Engineer Data

SUMMARY

A strong software engineer with over ** years of experience building technology solutions to business problems in various industries such as Healthcare, Insurance, Manufacturing and Finance.

Strong expertise in developing BI & Analytical solutions providing clients tools to make better informed decisions.

Proficient in all aspects of the software development process – conceptualization, prototyping, component design, program design and coding, test driven development using automated unit testing.

Proven track record of successfully designing and implementing various software product features from inception to delivery of the product.

Excellent skill in designing and developing back end systems that consume and publish data using various forms of interfaces and web services.

Strong expertise in developing User interfaces and managing the data input streams.

PROFESSIONAL EXPERIENCE

Senior Developer, Aon May 2016 – Till Date

Role & Contribution:

Designed & developed Analytical Solutions using Bayesian analysis for Catastrophic Risk modeling in Reinsurance.

Developed and designed Enterprise Risk Management Tool using regression modeling to score and identify future at risk entities for several Banking clients.

In charge of maintaining and enhancing existing Data warehouse processes.

Managing satellite development teams to ensure timely product delivery.

Successfully implement Cashflow predictive analysis of future mortgage rates for the life time of a property Loan.

Work with Actuaries to develop new processes and enhance existing data models to improve system efficiency.

Developed usage reports for the executives to make informed decisions of the products like traffic monitoring, future product improvements.

Research and Implemented R technology to improve on legacy SQL systems to generate Reports to help understand Russell Indexes for clients to Analyze company trends and its future behavior.

Team Lead, Valence health May 2011 – May 2016

Role & Contribution:

Designed and implemented process to import HL7, EDI and EMR data feed into the warehouse.

Implemented and managed the data layer exchange to various products and reporting applications using Java, Microstrategy, C#, .NET, SAS.

Successfully Implemented Rule based engine to cleanse and load input data streams to the data warehouse.

Led and assisted requirement gathering sessions with business users and translated it into Technical requirements for development team.

Successfully led a team of Database Administrators and developers.

Played integral part in designing and developing various Data warehouse components.

Worked as a principal SQL server DBA, data modeler and component designer for the final product.

Led and successfully performed various code refactoring and optimization sessions.

Served as an integral part for recruiting new developers and mentored new hires.

Business Systems Analyst, Vensoft Inc Aug 2010 – Apr 2011

Role & Contribution:

Successfully Designed and Implemented EMR and Claims processing for healthcare institute following the HIPPA 4010 and HL7 regulations.

Designed a process to capture data from various data sources and stored it onto a Central repository using SSIS.

Designed and implemented the backend of the system to support the data warehouse.

Created Procedures and Triggers to perform complex database transactions.

Developed Claims and Patient reports in SSRS.

Assisted QA team in the development of the functional and integration test cases also provided testing environment for User Acceptance testing for the Claims Processing form.

Technology Analyst, University of Illinois at Chicago Oct 2008 – Aug 2010

Role & Contribution:

Successfully Implemented web system to develop the process of online reporting.

Developed Web Content Management system for University of Illinois campuses using SharePoint.

Developed Inventory database to maintain and monitor the software licenses.

Developed KPI and dashboards using SharePoint and .Net to measure how different sites were used.

Prepared and implemented a complete SDLC (System Development Life Cycle) Project Plan.

Designed and developed various Faculty contribution reports which were useful in registering faculty activity for the academic year.

Managed Web data for all the Office of University of Illinois campuses.

Analyzing the statistics using SPSS of the University Website to strategize Web page content.

Developed Website for Midwest Latino Health Research, Training and Policy Center.

Senior Software Engineer, Patni Computers Ltd. Dec 2006 – July 2008

Projects- GE Supply, GE Money (US), GE Capital Fleet Services

Role & Contribution:

Developed various applications to support the existing Mainframe based Supply system.

Developed and provided Support for the EDI applications.

Leading and mentoring a small group of team members.

Successfully Designed and implemented Mainframe based Audit process for GE Money Credit Cards.

Automated the Credit card Bill checking procedure on DB2.

Active participation in requirement gathering process to understand the scope of the project.

Leading and Mentoring 2 of the Audit Modules & Educating the Non-IT team about the various auditing types.

Performed Gap analysis for the already constructed process flows.

Successfully Analyzed and Prepared High level documents for the various Business effecting programs to reengineer the existing from COBOL into JAVA.

EDUCATION

Master of Science (Management Information Systems)

University of Illinois at Chicago Aug 2010

Bachelor of Engineering (Computer)

Ram Rao Adik Institute of Technology Mumbai University May 2006

TECHNICAL SKILLS

Web Design: HTML, XML, JavaScript, ASP.Net, CSS.

Languages: C#, Java, VBA, PHP, COBOL, CICS, ADSO, JCL,.

Database: SQL Server, Oracle, MySQL, Access, IDMS, DB2,

Data Analysis, Processing & Reporting Tools: R, SPSS, SSRS, SSIS, SAS.

Contact this candidate