SUMMARY:

• 3+ years of SAS statistical programming experience or equivalent (for clinical trials is desirable).
• Broad understanding of SAS and other industry - standard software products for SDMP.
• Strong system administration skills, understanding of application security, performance and tuning.
• Knowledge of change management procedures and version control.
• Ability to effectively communicate designs and decisions to peers, customers and management.
• Experience implementing and using SAS Enterprise software, create standards, and manage code promotion to production environment.
• Strong analytical and problem-solving skills.
• Prior experience in the pharmaceutical industry is preferred.
• Preferred but not required: JMP (Pro), PASS
• Bachelor degree in a quantitative field, preferably Computer Science, Information Technology or related field.
• 5+ years of experience in systems support, user support, customer support or of enterprise class software.

PROFESSIONAL EXPERIENCE:

Confidential

Postgres Database Developer

Responsibilities:

• Solid understanding of database design principals
• Minimum 1 year experience with Postgresql 9.3
• Solid understanding of query execution plans
• Mastery of ANSI SQL and/or PL - SQL
• Good SQL scripts skill including SPs, PSQL scripting & functions
• Good performance tuning skills
• Ability to proactively identify, troubleshoot and resolve production database systems issues.
• Solid background using UNIX operating systems - RedHAT or CentOS
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
• Experience in replication
• Hands-on experience on database administration, backup recovery and troubleshooting
• Problem-solving skills
• Ability to thrive in a fast-paced, deadline-sensitive environment

Unix Engineer

Confidential, Joliet, IL

Responsibilities:

• Integration, testing and on - going support of 24x7x365 systems.
• Installation and support of operating system, software and patches.
• Installation and support of application software and patches.
• Perform Unix Systems Administration for Solaris systems.
• Coordination of activities with team members, users and management.
• Creating or updating systems documentation as changes occur.
• Offering direction to less-experienced peers.
• Comfortable performing multiple tasks on multiple systems.
• Participating in on call rotation.

Confidential, Round Lake IL

SAS Administrator

Responsibilities:

• Providing design/direction/support of applications software used by SDMP, including but not limited to SAS, by performing planning/building/operations.
• Performing SDMP software and hardware administration duties and providing technical leadership.
• Providing support to customers by troubleshooting problems with SAS and other software applications / environment and providing technical solutions, including SAS BI, JMP, and PASS.
• Leading continuous improvement projects and delivering quality software solutions in a timely and cost effective manner.
• Researching alternative technical solutions for changing business needs of SDMP customer base.
• Orders, license control & tracking, installation, etc., of additional software as needed.
• Collaborate with business and technical partners to identify and scope the opportunities, quantify cost, outline potential value, benefits and constraints.
• Serve as escalation point for all user production issues, requests, and concerns.
• Conduct root cause analysis for SAS and other SDMP software performance, outage and process issues and drive team to implement solutions, preventative actions, controls, and monitoring.
• Manage daily issues, request tickets, drive run environment improvements and make appropriate recommendations working with management, vendor team, external application / infrastructure vendors and end - users.
• Oversee all aspects of SAS environment including installation, patching, backup, access control, day-to-day monitoring.
• Define and lead Quality Assurance and Quality Control processes in CD&O Department. Ensure compliance to quality system methodology and development of quality metrics.
• Create guidelines, processes and standards to ensure high overall quality of product and incident free deployment.
• Instruct and guide the team to ensure that appropriate processes and documentation are in use. Ensure compliance to the defined standards. Actively look for opportunities to modify and enhance standards per the needs of the department.
• Proactively understand Compliance Requirements and integrate them into SDLC, represent the team during Compliance Audits and ensure compliance.
• Provide pre- and post-implementation documentation.
• Diagnose software and hardware problems and workarounds.
• Document, report, track and implement fixes for software and hardware problems with appropriate vendor.
• Learn other clinical IT applications and provide technical support

CA Clarity Developer

Confidential . Alpharetta, GA / Hoffman Estates, IL

Responsibilities:

• Should be good in Requirements gathering (pay attention to details)
• Understand the requirements and convert them into Logical Data Model (Hierarchies)
• Must understand the concept of Slowly Changing Dimensions and should know how to architect them in Microstrategy.
• Experience working with capturing reporting on Current and Historical Data.
• Experience working with Transformations.
• MicroStrategy Developer (Required skills)
• Experience working with Complex reports.
• Experience with Report Services Documents (Dashboards).
• Experience with Rolling Metrics, Nested Metrics, Relationship Filters, etc..
• Experience with VLDB Properties (multi - pass sql, hints, etc)
• Work on Tuning reports with Performance issues.
• Experience with Narrowcast Server. Should be able to create Static and Dynamic Subscription sets.
• End User
• MicroStrategy Administration (some flexibility here but should be familiar with concepts)
• Experience with Upgrades, regression testing, etc..
• Experience with setting up Narrowcast Server.
• Experience with Object Manager
• Experience with Intelligence Server / Web Server administration.
• Experience with Security roles, Security Filters, User management, Access Control Lists, etc..
• Experience with Enterprise Manager
• Database Skills
• Good Oracle SQL writing skills
• Good Oracle SQL tuning skills
• MicroStrategy Nice to haves
• Setup of Unix iServer and web server in NT
• Experience with Command Manager
• Basic Qualifications (minimum requirements to qualify for this job must haves)
• A minimum of 2-3 years experience in the below areas:
• Excellent written and oral communication
• Experience in financial services or highly regulated industry
• Knowledge of software design
• Knowledge of software development processes
• Knowledge of software maintenance processes
• Excellent organizational, problem solving and analytical abilities