SUMMARY:

Data Analyst with 5 years of experience in SQL Server, data Analysis, enterprise data warehousing, business intelligence, predictive analytics, statistical modelling, Optimization techniques and data visualization fields.

TECHNICAL SKILLS:

• Oracle ARGUS, ARISg, Microsoft Office (Word, Excel, PowerPoint, Access, Outlook, Visual Studio), Windows Vista, Windows XP, Windows 7, Macintosh
• SQL Server, Postgres, AWS Cloud, Teradata, Control M, Hadoop, T - SQL

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Migrated Commercial Hadoop Application to One lake using Python and Spark.
• Worked on Nebula to register/Edit the Business and Technical datasets.
• Worked on Jenkins jobs to create, Deploy and rehydration of infrastructure.
• Arow Monitoring and Worked with respective teams to remediate data issues.
• Responsible for providing daily and weekly reports to the immediate supervisor and actively involved in weekly meetings to discuss project status.
• Database Migrations to AWS Cloud.
• Data Analysis using SQL Server databases and Hadoop.
• Loaded marketing contact history to SQL data mart to create a single source of marketing activity; a foundational requirement for contact optimization strategy.
• Understand and document technical requirements from clients
• Define Migration strategy to move application to cloud.
• Develop architecture blueprints and detailed documentation, including required Cloud Services (such as EC2, S3) and tools;
• Design the AWS network architecture including VPN connectivity between on - premise applications and subnets
• Design and implemented HA & Multi-AZ strategies for S3 and EBS Data.
• Set up required processes, services and tools around cloud
• Responsible for the building of the environment and migration plan & Leveraging appropriate AWS services & Validating the environment to meets all security and compliance controls
• Created Ad-hoc MSSQL scripts to identify gaps between legacy and future state data environments.
• Created SQL queries and stored procedures and daily ETL via SSIS.
• Created automated reports of marketing exclusion criteria audits for lending and deposit customers across legacy and future state data environments and over time.
• Good experience in outlier analysis, binning methods, normalizing data, resolving inconsistencies and redundancies
• Reviewing source systems and propose data acquisition strategy
• Closely Working with Data modeler on conceptual, logical and physical model designs.
• Code Deployment to higher Environments
• Developed Process to extract data using SSIS, Python and Tableau.
• Understanding the business requirements and functional specifications of the client module
• Planning the test activities and preparation of test scenarios as per customer requirements
• Coordinates activities between onsite and offshore testing team and other teams like Development, 3rd Party vendors of client.
• Participate in root cause analysis for mitigating risks and impacts within the AWS infrastructure environment
• Evaluate data management, data quality and data access processes for gaps, inefficiencies and opportunities; provide recommendations for improvement
• Develop prototypes and run experimentation for business intelligence tools, solutions, and techniques
• Assist in development of standards and policies for business intelligence framework
• Experience in writing test scripts with Java/Ruby scripting language.
• Working on AWS for DDE code migration to cloud.
• Converted Ab-initio jobs to arrow, created arrow jobs for commercial data services based on business requirements.
• Migrated Ab-initio jobs to cloud.
• Proficiency with service now, GitHub, Jenkins and Nebula.

Technical Skills: AWS, SQL Server, Tableau, SSIS, Python, Linux, Windows, Office, T-SQL, Control-M.

Confidential, Nashville TN

Clinical Data Analyst

Responsibilities:

• Assist in the processing of expedited safety reports (ESRs).
• Worked on SQL Server SSRS for reporting and pulling data from various sources.
• Maintenance of adverse event tracking systems.
• Writing Python scripts for ETL process.
• Set-up and maintenance of project files, core process files and central safety files.
• Assist with the reporting of ESRs to clients, regulatory authorities, ethics committees, investigators and Confidential project personnel, if required, within study specified timelines.
• Provide administrative support to PV&DSS personnel (e.g. word processing, proof-reading and editing correspondence/documents, mailings, filing, faxing, photocopying and archiving etc.)
• Participates in the triage process for incoming documents to insure timely and effective medical and scientific evaluation of adverse event information
• Assist in the maintenance of files regarding adverse event reporting requirements in all countries.
• Work within the Standard Operating Procedure (SOP) system, including departmental Work Instructions (WIs).
• Build and maintain good PV&DSS relationships across functional units.
• Ensure submission of client-related documents is sent to the client within designated timeframes (e.g. SAE reports, ESRs, PSRs, Safety Management Plans (SMPs)).
• Assist the DSA/Sr. DSA in preparation of materials needed for client and/or investigator meetings.
• Any other duties as assigned by management.

Confidential

Clinical Data Analyst

Responsibilities:

• Participates in the triage process for incoming documents to insure timely and effective medical and scientific evaluation of adverse event information
• Request follow-up information from consumers, and health care professionals and requests clarification from foreign affiliates according to specific report types using both global and local SOP timeframes
• Reviews adverse event documents prepared by the Patient Safety personnel for accuracy, completeness, and validity prior to submission to the FDA
• Enter and maintain accurate tracking system for all AE reports (CRIMSON/Jasper)
• Have a broad understanding of Surveillance activities and the impact on individual case or group of cases can have on product labeling
• Assumes responsibility for completing special projects (i.e.DSURs, PSUR table preparation)
• Supports Safety Surveillance, Safety Support - Compliance and Marketing Company and US Medical Affairs and the US Clinical Teams
• Demonstrates ability to communicate effectively with personnel of various disciplines regarding aspects of product inquiries and collection of safety data
• Reflects the Patient Safety philosophy of being a team player and supports the development of those individuals within the department
• Working knowledge of technology required for Patient Safety

Confidential, New York

Analytical Chemist

Responsibilities:

• Analyzing samples from various sources to provide information on compounds.
• Using analytical techniques and instrumentation, such as GC, HPLC, Ion Chromatography and spectroscopy.
• Interpreting data and adhering to strict guidelines on documentation when recording data.
• Developing techniques for the analysis of drug products.
• Validating methods and equipment.
• Reporting scientific results using wide range of analytical techniques, instrumentation and software.
• Hands on experience with Empower software by waters to work with HPLC