AHSAN UL HAQUE

** ***** **

North Brunswick, NJ *8902

732-***-**** (mobile)

advt5o@r.postjobfree.com

SUMMARY

· Proven IT professional possessing over twenty years of software development, project management, data modeling, data wrangling, data cleansing and data analytics experience and thorough understanding of the full development life cycle in a process-driven environment

· Significant software engineering experience including requirements analysis, software design, development, integration & testing, data warehouse design & implementation, project management, end user & technical documentation, training and support

· Excellent verbal and written communication skills with experience working in a team-oriented environment and independently

· Extensive experience with creating and analyzing technical documents as well as efficiently organizing shared resources

· Educationally qualified with a Bachelor of Science in Computer Engineering at Rutgers University, College of Engineering

· Completed the Biopharma Education Initiative graduate level Clinical Trials Informatics Certificate Program at UMDNJ

· US Citizen

TECHNICAL SKILLS

Languages Visual Basic for Applications, Visual Basic, SAS, C++, C, Java, SQL, PL/SQL, Pro*C, Fortran, Smalltalk Databases MS Access, Oracle, Teradata, SQL Server, Informix, Gupta SQLBase, Btrieve Operating Windows 10/7/XP/2000/NT, MS DOS, Novell Netware, Systems Sun Solaris, HP-UX, NCR MP-RAS UNIX, IBM AIX, BSD UNIX on Pyramid, DEC/VMS Methodologies Object-Oriented Analysis and Design (OOAD), Component Object Model (COM), Capability Maturity Model (CMM), Waterfall Development Model, Agile Development Model Software Dimensional Insight/RWJBH ProDiver/DivePort, GE Centricity BI, Cognos Impromptu/PowerPlay, MicroStrategy Familiarity DSS, Epic EMR, IDX/athenahealth EMR, Salesforce, Tableau, Crystal Reports, ERwin, Visio, InstallShield, pkgmk, Adobe Acrobat, ClearCase/DDTS, Rational Purify, MKS Source Integrity, MKS Toolkit, nTools (SCCS), OnTrac, Exchange/Outlook, Word, Excel, PowerPoint, Lotus Notes, Framemaker, MS Edge, Chrome, Internet Explorer PROFESSIONAL EXPERIENCE

Rutgers Health Group-Robert Wood Johnson Medical School, New Brunswick, New Jersey Programmer Analyst I (9/02-present)

· Analyze and develop requirements for various projects related to financial analysis of healthcare billing/productivity data.

· Design, develop, test and support software for a data warehousing application which manages medical billing for a multi-specialty group practice in Visual Basic for Applications & SQL in Windows 10 environment.

· Create, analyze and maintain data in a MS Access data warehouse using VBA and embedded SQL.

· Design, develop and maintain data pipelines to streamline flow of data from source systems to end user reports.

· Maintain code and processes which apply ETL (extract, transform and load) processes to import data from production billing systems (IDX/athenahealth EMR in DEC/VMS and Epic EMR), salary/expense systems (PeopleSoft), benchmark data

(MGMA/AAMC), CMS Physician Fees, CMS RVUs and other sources into the MS Access data warehouse.

· Maintain code which updates mapping tables and data dictionaries used to standardize and consolidate disparate data.

· Design and develop MS Access and MS Excel reports at the plan, division, program and provider levels.

· Develop and maintain statistical reports which include KPIs to measure business performance.

· Help develop dashboards in BI applications to make data more accessible to users at varying levels.

· Perform ad-hoc analysis of billing, productivity and expense data using SQL queries in MS Access and MS Excel.

· Perform contract analysis to determine impact of proposed changes in fees on current business at the procedure level.

· Perform productivity analysis of provider relative value units (RVUs) based on CMS data for multi-specialty medical practice.

· Developed and maintain model and produce monthly reports for Patient Quality Reporting Initiative (PQRI) analysis.

· Help develop external systems and processes (at GE Healthcare/Meridian & RWJBH) related to RHG-RWJ data flow.

· Provide guidance to other development, systems analysis, project management and finance staff to improve the process of software development and the analysis and development of business requirements.

· Develop technical documents to facilitate processes which lead to consistent data analysis and reporting. Ahsan ul Haque

Resume

F&A Data Systems, East Brunswick, New Jersey

Programmer Analyst (4/02-9/02)

· Designed, developed and tested software for a retail application which handles warehouse automation and control in C and SQL in IBM-AIX and Windows 2000 environments.

· Utilized Vermont Views to develop GUIs and database interfaces for updates to existing functionality.

· Created, analyzed and maintained data in Oracle using SQL*Worksheet, SQL*Plus and Pro*C. Wrote embedded SQL queries in C to interface with Oracle.

· Provided technical product support for development and documentation staff. Telcordia Technologies, Piscataway, New Jersey

Software Developer (9/00-1/02)

· Designed, developed and tested software for a telecommunications application which monitored network performance using C++/C and SQL in HP-UX, Sun Solaris and Windows NT environments. Interfaced with business and technical liaisons to gather and clarify requirements of the various user constituents. Modified the application to enable processing of 64-bit data to leverage the advantages of newer network elements. Thoroughly analyzed the large code base before making the appropriate modifications.

· Worked with a small team to develop GUIs and database interfaces for new functionality using Motif in Sun Solaris and Windows NT environments. Analyzed and implemented user requirements using new and existing code as appropriate. Created, analyzed and maintained data in Oracle using SQL*Plus, SQL*Net, PL/SQL and Pro*C. Wrote embedded SQL queries and implemented data access classes in C/C++ to interface with Oracle.

· Utilized nTools (SCCS) and OnTrac to maintain source files and track modification requests. Provided feedback to improve the process of software configuration management and the handling of modification requests. Wrote UNIX shell scripts to facilitate tasks for testing and building applications.

· Provided technical product support for systems engineering, development, testing and documentation staff. Training was provided for other staff in the functionality of existing systems and infrastructure. Technical feedback of systems functionality was provided for systems engineering, testing and documentation staff. NCR Corporation, Woodbridge, New Jersey

Senior Software Engineer (8/97-9/00)

· Designed, developed and tested software for a Customer Relationship Management (CRM) data warehousing suite of applications in Windows 95/98/NT and NCR MP-RAS UNIX environments. The applications facilitated the management of churn, growth and promotional campaigns for the telecommunications industry. Understood and analyzed the logical and physical data models utilizing a star schema in view of business requirements using ERwin. Worked with a team to develop the front end for the CRM data warehousing applications in Visual Café using Java and a JDBC-ODBC adapter to interface with Teradata. Coordinated the off-site development and integration of some modules. Created and analyzed data in Teradata using BTEQ, FastLoad and MultiLoad.

· Coordinated the integration of user interfaces/reports developed in Cognos Impromptu and PowerPlay. Analyzed and modified these Cognos deliverables as part of the data warehousing suite. Addressed technical issues related to the functionality and issues related to backward compatibility of Cognos products with Cognos consultants.

· Managed a multi-site international project for the internationalization and localization of applications which included a Java user interface and Cognos Impromptu/PowerPlay reports. Facilitated knowledge transfer to a European team of developers, coordinated the team’s work and the integration of the resulting deliverables.

· Worked on the extraction of data from diverse sources including Teradata and externally acquired demographic databases. Utilized various tools in the extract, transform and load (ETL) process including the export of data from external sources and from Teradata, manipulation of data in Excel and data translation within Teradata.

· Participated in the design of a CRM data warehousing application targeted for the retail industry which utilized Visual Insights Advizor for developing decision support interfaces. Gained an understanding of COM (Component Object Model) development.

· Utilized ClearCase and ClearDDTS to maintain source files and track modification requests. Provided guidance to help manage the integration of different source branches. Designed the structure for the storage of source files for the internationalization and localization project so that the same source tree can be used to build the different localized versions. Maintained UNIX shell scripts to facilitate builds and create production disk images.

· Used InstallShield, UNIX pkgmk and other tools to build applications for testing and production. Defined procedures to ensure consistency and quality in the build process for different applications.

· Provided technical product and system support for development, testing and documentation staff. Mentored other staff to facilitate understanding of existing functionality and processes. Ahsan ul Haque

Resume

Multinational Computer Models, Fairfield, New Jersey Software Engineer (10/91-8/97)

· Designed, developed and tested software for client/server financial applications using Visual C++ and SQL in a Windows NT environment. Managed the development of a major application which was marketed to various clients. Developed algorithms which implemented complex calculations which were often within a schedule with multiple occurrences. Utilized object-oriented design techniques to model these algorithms in an efficient manner. Worked on several development projects to supplement and enhance existing systems based on user requirements.

· Created, analyzed and maintained data using Oracle, SQL Server and Gupta SQLBase. Utilized stored procedures to process data. Maintained a data dictionary which interfaced with software systems and included the definition of structures for the database and user interface objects.

· Designed, executed and debugged automated regression scripts for testing of functionality. Analyzed and compared the results of the execution of these scripts to previous results to determine change in functionality.

· Utilized MKS Source Integrity to maintain archives of source file changes. Used MS Access to maintain records of bug fixes and source changes in parallel.

· Provided technical product and system support for clients and other staff. EDUCATION Bachelor of Science, Computer Engineering, 1991 Rutgers University, College of Engineering, Piscataway, NJ Completed various coursework at the graduate level in Computer Engineering Rutgers University, College of Engineering, Piscataway, NJ Completed graduate level Clinical Trials Informatics Certificate Program, 2011 UMDNJ, Biopharma Education Initiative (BEI), Newark, NJ REFERENCES Available on request

Contact this candidate