Data Professional Experience
Resume:
JERRY ALEX
Data/Business/SAS Analyst
Project / Database Management Application Development Data Analysis and Integration SAS Programming Innovative and charismatic IT professional with a Spartan like mindset seeking to implement advanced analytical and automation solutions to drive the business needs of an organization in the most cost effective and tech savvy manner. Embraces new technologies, and always on the lookout for efficiency improvement and striving for top results. Carries an unquenchable passion with an obsessive mindset to out-perform and go the extra mile than what is required.
CORE COMPETENCIES
Data Analysis & Applications Development Project Planning & Management Quality and Productivity Improvement Technology Needs Assessment & Solution Team Building & Leadership Software Development & Design Programming Practices and Techniques System Analysis Real-Time Database Management Systems Web/Database Servers IT/Web-Based Media Support Content Development
Metadata Processes Grid Architecture UX/UI Design Digital Marketing TECHNICAL ABILITIES
Operating Systems UNIX, Windows, Linux, DOS
Languages BASIC, C/C++, Java2, JavaScript, Visual Basic, Perl, CGI, PHP, SQL, PL/SQL, HTML, XML, T- SQL (Beginner), Windows Scripting, Python – Beginner, D3.js Networking Novell
Netware3.x
Databases Oracle, Access, MySQL, MS SQL
Server
Software Business Objects Crystal Reports, Developer 2000, MS Office, Macromedia (Dreamweaver, Flash, Fireworks), Microsoft Visual Studio, Eclipse, NetBeans, HighCharts, Pinnacle 21 Enterprise Other Familiarities Adobe Photoshop 9 CS4, Adobe Illustrator, Xara 4.0, ColdFusion Markup Language, Microsoft Project, WordPress CMS, Cloud Computing, AWS, CANVA, Joomla, Microsoft Studio
Statistical Software SAS – (Exceptionally Proficient in BASE SAS, SAS/CONNECT, SAS/ODS, SAS/MACROS, SAS/GRAPHS, SAS/AF, SCL - SAS Component Language, SAS EG, SAS Studio, SAS Management Console, SAS Grid), R - (Beginner) PROFESSIONAL EXPERIENCE
TEVA Pharmaceuticals West Chester PA (Contractor through Axelon Services Corp) Sr. SAS Analyst Feb 2016 – Present) Rejoined TEVA as a part of Data Management Global Programming team and resume the responsibilities as a senior programming lead to develop, maintain, supervise and author global macros for Data Operations and Data Management
Take the lead in developing new macros to assist DMPL with QC tasks of external data and aCRF
Initiate the re-deployment of internal applications by taking charge of the developmental process and adapting the applications to new technological modifications
Increase existing batch macro efficiencies from 68% to 92.38%
Re-engineer programs for faster processing times and increased efficiencies
Serve as a lead to other programmers and help them with their programming tasks
Present and introduce new macro functionalities developed in-house to the departmental teams 2810 Welsh Rd, Philadelphia PA 19152
Cell: 267-***-**** ***********@*******.***
JERRY ALEX • Cell: 267-***-**** • ***********@*******.*** • 2 P a g e
(Professional Experience Continued)
Analyze ETL processes, involving Oracle, SQL Server and SAS
Spearhead the process of implementing an in-house define.xml package creation process using SAS toolkit architecture
Design, develop, implement and supervise macro libraries that are specifically designed for FDA submission checks
Administer and train users on Pinnacle 21 Enterprise system
Oversee the day to day operations on Study Data Portal (An in-house built visualization platform by me) to help with data analysis for clinicians, data managers and statisticians
Introduce high level programming structures such as HASH, PROC FCMP and other methods focused on smooth integration with 3rd party applications and overall batch processing
Design and implement macro that checks data consistencies between the data and the define package
Implement a process and programming logic to parse the aCRF and check for annotations and data co- relation
Oversee and supervise data leads in implementation of programming SOP’s and proper execution of departmental and data check specific macros
Celgene Corporation Berkley Heights New Jersey – (Contract) Programmer, (Systems and Applications Support – SaAS Dec 2014 – Feb 2016)
Execution and support of Systems and Applications Support (SaAS) strategy and ensure alignment with department strategy
Provide technical support to users within the department for systems and 3rd party applications, including answering/resolving user issues pertaining to the system and/or programming environment
Support to the development, validation, maintenance and enhancement of Celgene global macros as well as training on the same
Participate in the development, validation and maintenance of standard programs e.g. data review programs, TLGs, patient profiles as well as training on the same
Participate in the implementation of standard naming convention for directories, programs, outputs and macros provide on-going training and monitor for adherence
Monitor department computing environment for compliance to Celgene standards and best practices
Participate the creation of automated tools to assist with monitor for adherence/compliance to Celgene standards and best practices
Conduct periodic audits on the data files to ensure compliance to standard processes as well as best practices
Identify efficiencies/optimization needed in technology and propose/share solutions /or utilities to improve the same across the department
Proactively anticipate problems, identify root causes and work with manager to implement creative solutions
Lead cross functional system related projects as assigned
Participate in the development of department or cross-functional SOPs, Working Practices and best practices for the department
Participate in cross functional initiatives and ensure that change management is implemented
Provide guidance to IT and make decisions for resolving programming related tickets
Work with IT to approve and execute server/software Change Requests (CRs) as well as on system upgrades
Maintain user access, in collaboration with the IT department, to the data files including the locked datasets
Interact with CROs at a portfolio level in the development of standard programs
Participate in assessing CRO programming processes for regulatory compliance and alignment with Celgene standards and industry best practices
JERRY ALEX • Cell: 267-***-**** • ***********@*******.*** • 3 P a g e
(Professional Experience Continued)
TEVA Pharmaceuticals West Chester PA
Sr. SAS Analyst Oct 2011 – Dec 2014)
Apply analytical skills to critique the current SAS architecture
Analyze ETL processes, involving Oracle, SQL Server and SAS
Planned, developed and executed production macros to increase program efficiency by 85.9%
Learn the pros and cons of the production system and counsel the client on better techniques to present and manage data to both external and internal clients
Examine XML schemas
Engineered the use of dataMontage software, using JAVA and XML, to display clinical study data based on clinical program(s), to produce aggregate and individual study reports rapidly increasing functional project efficacy.
Programmed - study specific graphs as per client needs - Graphing such as Spaghetti Plots, Bar Plots, Line Graphs, Data Points etc.
Evaluate the current data-presentation system to conceptualize a better system with faster, secure and efficient data processing tasks.
Evaluate and process study data by applying various checks to make sure data is SDTM compliant and prepare AdaM datasets for statisticians and clinicians alike
Lead a team of 5 people, including supervision of external vendor, to oversee the development and implementation of a custom visual platform to display clinical data to clinicians, statisticians and upper level management – to better visualize and understand data – 90% data efficiency with 98.5% data quality checks – efficient reporting system in conjunction with Oracle CTMS. Principal Consultant Resolvit Resources
COLLEGE BOARD NY, NY
SAS Analyst (Apr 2011 - Sep 2011)
Analyze existing SAS modules, making relevant changes where necessary, to enhance processing time while making data retrieval efficient
Meticulous study of pre-written complex SAS procedures and arbitrate the need to apply OOP concepts to reduce program length, thereby maintaining code efficiency and sustainability
Perform analytical study run on existing modules to retrieve data via complex analysis for adhoc report generation
Initiate program documentation where lacking to aide in better understanding of the procedures and events involved with data processing
Involved in data processing and analysis using queries on MS SQL Server. JERRY ALEX • Cell: 267-***-**** • ***********@*******.*** • 4 P a g e
(Professional Experience Continued)
PHARMACEUTICAL PRODUCT DEVELOPMENT (PPD) Wayne, PA Sr. Data Analyst (Mar 2010 - Mar 2011) Embraced a leadership role by partnering with biostatisticians in engineering a system, focused on automating experimental clinical results data, based on requirements provided by the statisticians, resulting in faster data analysis process with 100% accuracy. The resulting system demonstrated a solid flexible framework, mimicking OOP concepts, which can be easily integrated with future systems that are similar in nature and/or sub-modules.
Selected Accomplishments:
Instituted the development of an automated SAS processing system to help biostatisticians better analyze experimental clinical data, resulting in dramatic increase of productivity equipped with 100% efficiency and decreased processing times.
Exercised a framework based on OOP concepts that will enable the integration of macro plug-ins designed for specific objectives and tasks
Diversify the processing system by developing and implementing complex SAS procedures to load data from source and create study specific datasets, which are used as source datasets for report generation in PDF, XML and CSV formats
Systemize complex routines for data scrubbing, data cleaning, data modeling (logical and physical), data extraction and transformation of data to meet the statisticians needs
Re-engineer the initial processor system to incorporate efficient coding techniques by applying SAS- one-liners whenever possible.
Projected, devised and oversaw the development of same system as a batch process thereby eliminating the need for any manual interaction.
Author SAS utility macros whenever possible to demonstrate the use of multiple-inheritance and minimize unnecessary coding statements
Remodel the current SAS system developed on Windows platform to work efficiently on an HP-UX PA- RISC platform
Design and implement a SAS utility macro for graphing standard curve points for multiple assays and output the results in pdf format
Suggested and developed a working prototype of automated program documentation accessible through a web browser
Implemented a through documentation procedure
Practiced heavy documentation techniques by introducing system flowchart designs and related system process documentation
Investigated and fixed several issues and proactively suggested new output formats to satisfy the Statistician’s requirements
Researched, Analyzed and presented the need for a web interface that will link the current automated SAS process through a web interface – eliminating the need for a statistician to have knowledge of SAS
Implemented an extensive code debugging procedure using a series of DATA _NULL_ and %PUT statements
Used procedures like PROC SORT (CNTLIN), PROC PRINT, PROC REPORT, PROC NLIN, PROC FCMP, HASH, PROC UNIVARIATE and PROC SQL
JERRY ALEX • Cell: 267-***-**** • ***********@*******.*** • 5 P a g e
(Professional Experience Continued)
WHARTON RESEARCH DATA SERVICES Wharton School of Business UPENN Philadelphia PA Data Analyst (Oct 2007 - Mar 2010) Partnered with the senior technical director to learn SAS and spearheaded the process of automating data update tasks by initiating data reorganization, resulting in reduced manual data interaction and 100% accuracy in automated data check processes. Upon successful grasp of SAS skills, authored a paper and presented at Coder’s Corner at the NESUG conference held in Pittsburg on September 2008. Selected Accomplishments:
Designed, developed and implemented SAS trace module that tracks the client’s data usage across various platforms and reports the duration of access time by each client on a particular dataset.
Presented the above work at Coder’s Corner in 2008 NESUG conference held in Pittsburg on September 2008.
Authored the paper “The History of How, Who, Which, What, Where – Utilizing the SAS® Trace Module!”, which was used for the presentation at the Coder’s Corner
Developed a financial web application that incorporates an excel financial spreadsheet, prepared by Robert W. Holthausen (a distinguished Wharton faculty and chairperson of Accounting), as a template that automatically analysis the financial data from COMPUSTAT.
Preside over the design, coding, testing, debug and documentation of programs used for data extraction, dynamic web access, and comprehensive report generation.
Instrumental in initiating and implementing several technical improvements to existing data update and checking procedures, which significantly increased accuracy and performance by (5 to 10 times)
Perform data assessment, analyze program specifications for conversion purposes and develop a contingency plan to catch data errors.
Create, implement and present new methods of data analysis and visualization using SAS/ODS (pdf, html, rtf, excel and text)
Automate the process of data conversion across multiple platforms (SOLARIS to LINUX and vice- versa)
Strategically plan and coordinate with research directors on composing web applications for clients to dynamically access financial data
Specializing in the development and implementation of automated systems for faster and efficient data collection; procedures reporting; information submission, storage, and retrieval; and formal report and web content production.
Participate and work with fellow team members to brain storm, arbitrate and implement new ideas for data analysis to further enhance current program efficiency for both web and offline environments JERRY ALEX • Cell: 267-***-**** • ***********@*******.*** • 6 P a g e
(Professional Experience Continued)
EDUCATION
Drexel University Philadelphia, PA Bachelor/Masters Combined Program of Science in Biological Sciences and Computer Sciences 2013
Massachusetts College Of Liberal Arts North Adams, MA Bachelor Of Science in Computer Science & Biology September 2000 - May 2004
Aptech Computer School Bangalore, India Advanced Diploma in Software Engineering Minor in Database Administration
Contact this candidate