SUMMARY:

• Confidential Certified programmer with over 12 years of experience with strong emphasis in Analysis, design, development, validation, testing and implementation of Confidential in Healthcare, Financial, Pharmaceutical and clinical industry.
• Having experience with Confidential Business Intelligence tools like Web Report Studio, OLAP Cubes, Information Maps, and Stored process, Microsoft ADD - Ons, Confidential PORTAL, Confidential Enterprise Miner, Confidential BI Dashboards and Enterprise Guide.
• Extensive workings experience in Confidential /BASE, Confidential /STAT, Confidential /ACCESS, Confidential /INTR, Confidential /CONNECT, Confidential /ODS, Confidential /GRAPH, Confidential /MACRO, Confidential /SHARE and Confidential /SQL.
• Advanced knowledge of statistical models such as clustering , segmentation , predictive modeling , ANOVA , regression analysis , decision tree , CHAID , neural networks and survival analysis .
• Experience in UNIX Korn Shell scripting for process automation.
• Experienced in creating and automating the reports using Confidential Microsoft Add-In.
• Learnt and created Confidential Visual Analytics reports using Confidential Visual analytics.
• Extensive experience in extracting data from various databases like Teradata, Oracle and..
• Having experience in writing the ETL scripts to extract and analyzed the data.
• Experienced in understand and Automate the System.
• 3 years of Confidential administrator experience.
• Thorough knowledge of Confidential and involved in all Phases (phase I, II, II, IV) of Clinical trials.
• Having knowledge of Core ASP, ASP. Net, C#., Java, EJB, JSP, Servlets, JDBC, Java Script, JQuery, D3, CSS3, Ajax.
• Experienced in preparation of design documents, technical specification documents, Test Plans, Test Cases and Functional testing.
• Self-starter and self-learner, Proficient in problem solving and delivering realistic and practical solutions. Enthusiastic, innovative and challenge oriented written and verbal communication skills, self-learner, self-starter and a good team player.

TECHNICAL SKILLS:

Confidential Tools: SAS8/9.4, Confidential /BASE, Confidential /MACRO, Confidential /SQL, Confidential /STAT, Confidential /INTR, Confidential /GRAPH, Confidential /ACCESS, Confidential /ODS,, Confidential /CONNECT, Confidential /SHARE, Migration (V8 to V9)

Confidential BI Tools: Web Report Studio, Enterprise Guide, OLAP cubes, Information Maps, Stored Process, Confidential Microsoft Add-ins, Confidential Forecast Studio, Confidential Portal, and Confidential BI Dashboard.

Languages: C, C++, Java, ASP. Net, ASP, SQL, PL/SQL, HTML, DHTML, Java Script, JSP, AJAV Servelets, VB Script, and XML

Databases: Oracle 10g/9i/8.x, Oracle Clinical, Teradata, MS SQL server2005/2000, MS Access 2003/2000

Operating systems: Windows NT/2000/XP, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential

EpiQuery Consultant

Responsibilities:

• Discrete additions to EpiQuery (EQ), an interactive website that allows epidemiologic analysis.
• Designing a more intuitive website, that includes Data, Statistics page, graphs and maps.
• Developed Statistical methods using Confidential /R.
• Worked with different program to get Survey data from different data source.
• Used different Confidential PROCS and statistical PROCS to extract and analyze the data.
• Created bar graphs, trend charts using Confidential Stored procedure procedures for HIV, TB, Syndromic, YRBS, CDSC, CHS, WTC and STD Modules.
• Implemented the MIDDLE TEIR framework to secure the online Stored Process application using Confidential, JSP, HTML, CSS and JavaScript.
• Used complex Confidential macros to pull and analyze the data from the data tables to generate the report based on the user section.
• Created User Interface for HIV, TB, Syndromic, CD, and STD modules using HTML and JavaScript, option to choose type of analysis, year/Trend.
• Considering and implementing innovative techniques to accomplish the goals of this project.
• Design working internal sites, providing a testing environment and demonstrating the sites as developed.
• Built and implemented Architecture to implement the middle tier secure site for EpiQuery applications.
• Provide analysis in the development and support of project and data analysis.
• Interacted with Program partners, gather the requirements and create the report specifications.
• Extract data from data sets and analyze using the Confidential /STAT procedures.
• Create the prompts and dynamic drilldown reports and Graphs using Confidential Stored Procedures.
• Assisted the team to develop the child care KPI reports.
• Developed reports using Proc/Report, Proc/Sort, Proc/Format, Proc Transpose, Proc compare and Proc/SQL.
• Used proc SQL to pull the data Confidential datasets for different levels and creates summarized population denominator and numerator datasets.
• Created neighborhood map using proc gmap. Created user friendly maps for Syndromic module by displaying the different age groups in different TABs using JQuery
• Used D3.js, AJAX for more visualization interactive data display.
• For STD module analyzed the data to check the confidentiality of the data, based on which the data will be suppressed.
• Worked on YRBS (Youth Risk Behavior Surveillance ) data, and updated the module functionality.
• Prevented the Cross site scripting using input validation code for EpiQuery application.
• Create SSO Confidential logon to secure the application from the SQL Injections .
• Automated the data generation process for each module for yearly data.
• Automated the data checking process for all the modules using Confidential PROC COMPARE, nested MACROs, VB script.
• Automated the data Generation process which runs yearly and users who doesn’t know Confidential can generate the yearly data and work with the applications.
• Worked with Confidential to resolve data security issues like Cross site scripting and SQL injections.
• Involved in interview process for selecting the Confidential consultants for the EpiQuery department and also involved in the code review of the Confidential applications.
• Prepared the project document to explain flow of the project.

Environment: SAS8, SAS9.4, Confidential /BASE, Confidential /MACROS, Confidential /SQL, Confidential /GRAPH, Enterprise Guide7.1, Confidential /INTR, JavaScript, JSP, JAVA, JAVA Servelets, D3.JS, JQuery, AJAX, Oracle, VB Script, HTML.

Confidential

Decision Support Consultant

Responsibilities:

• Provide analysis in the development and support of various moderately complex projects and data analysis. Analysis would include: health care cost and utilization trends, clinical and condition management analyses, health care cost containment, quality measurement, predictive modeling and general research and decision support activities.
• Consult with divisional staff on moderately complex programming issues. Develop moderately complex macros/programming and procedures for divisional use.
• Provided On call support, If Production issues arise.
• Designs and develops moderately complex applications and analyses. Recommends innovative approaches to analytical investigations.
• Called upon to assume a project leadership role, mentoring lower-level analysts through all stages of project design and analysis.
• Analysis of market oriented medical management efforts, both internal and in cooperation with external vendors, as well as the development and evaluation of the methodological design and success of marketing and clinical initiatives and programs.
• Gathering initial requirements for marketing projects, preliminary analytic design, programming, testing, interpretation, and presentation of results.
• Developer USER friendly online dashboard and Reports using incorporated web technologies in Confidential Using Confidential /INTR.
• Automated the yearly, quarterly, monthly and weekly report.
• Created Listing and reports created from Confidential datasets using Crystal reports.
• Provide information content to eCast Channel 1 and the Command Center in support of the HPO’s strategy for information transparency, single source of truth and monitoring of Key Performance Indicators (KPIs).
• Supported extracted and created reports from multiple platforms, applications and tools like OSCAR, RADAR, PEGA, ACE, ECS, ICIS, CDHProd, EDW, OPIS, Insinq, CentreVue, PeopleSoft HR, ITS, ERS, Teradata, Oracle, DB2, IMS, mainframe files, Confidential, EasyTrieve, Cognos, MS Access.
• Involved in the data checking or validation process for ACE to EDW transition.
• Used Enterprise Miner for taking data and converting them into required Confidential datasets. Also used the Confidential Forecast Studio for appropriate analysis of data for different Forecasting models.
• Used various Statistical Procedures like PROC FREQ, PROC REG, PROC ANOVA and PROC GLM to analyze data and generate reports.
• Worked creating on Claims reports, Membership reports, Enrollment reports, AD-HOC or scheduled recurring reports, Claims Compliance Reporting & Real Time Claims Reporting (Claims Platform Support), Claims & Service Reporting
• Scheduled the daily workforce reports and monthly membership reportson the Unix system.

Confidential

Confidential Administrator/ Architect.

Responsibilities:

• Attended the Confidential institute Confidential administrator trainings .
• Confidential Administrator and Programmer using Confidential Administration, programming and reporting in Healthcare industry.
• Adding users, registering tables, etc. using Management Console;
• Installation of client applications and Troubleshooting technical problems.
• Strong experience working with Oracle on Unix using command line and GUI SQL tools.
• Tracking applicable Confidential hot fixes and creating implementation plans for respective Confidential modules and applications
• Monitoring Confidential Server resources and reporting usage(s)
• Identifying performance and recommending/implementing tuning of active Confidential environment(s) providing projected capacity shortfalls.
• Designing, implementing, and maintaining security on Confidential Metadata and Linux for users
• Designing, implementing, and executing the change control and promotions tasks in Confidential
• Establishing best practices and guidelines for Confidential BI usage
• Provide guidance and assistance to Confidential Developers on operational and technical issues; interfacing with the Confidential Institute for Support on administrative and system issues
• Creating and implementing upgrade plans
• Occasional after hour support when system OS and hardware maintenance and applying Confidential hot fixes and upgrades occur.
• Act as a liaison to Confidential Technical Support for Confidential users at the clients site
• Reviewed, validated, documented and mentored Confidential Admin and team regarding Confidential environment.

Environment: SAS8, SAS9.2, Management Console.

Confidential, Clinton, NJ

Confidential Programmer Analyst

Responsibilities:

• Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired data sets.
• Responsible for creating permanent formatted Confidential data sets.
• Generate tables, listings and graphs, including Patient Demography and Characteristics, Adverse Events, Laboratory etc.
• Responsible for Performed Data analysis, statistical analysis, generated reports, listings, tables and graphs using Confidential Tools - Confidential /BASE, Confidential /MACRO, Confidential /GRAPH, Confidential /SQL and Confidential /ACCESS.
• Performed data validation, program validation and corrections of the datasets, reports, lists and tables created.
• Developed efficacy and safety tables using Proc Report.
• Designed the graphs using Confidential Greplay.
• Successfully designed and implemented statistical analysis and reporting for Phase I, II and III Clinical Trials.
• Created Confidential reports using the PROC Report for the NDA submission as per the FDA regulations and company standards.
• Worked with Statisticians and Data Managers on various studies of drug phases.
• Explained the purpose and functions of complicated Confidential programs to non-statistical personnel, and was responsible for ensuring the validity and accuracy of data analysis.
• Formatted HTML and RTF reports, using Confidential - output delivery system ODS.
• Involved in preparing technical specification documents based on user requirements.
• Involved in validation, unit testing, integration testing and acceptance testing.

Environment: SAS9, Confidential /BASE, Confidential /MACROS, Confidential /ACCESS, Confidential /SQL, Excel/Access2000, Oracle9i, Windows XP Professional and UNIX.