SUMMARY

• Self - motivated, technically proficient data scientist wif over 5+ years of professional experience and proven expertise in teh field of data analysis, migration projects and programming for healthcare, financial and pharmaceutical organizations. Strong interpersonal skills coupled wif sharp business acumen, highly capable of communicating key information regarding ongoing projects to executives wif clarity and vision.
• Efficiently transformed business requirements into system solutions. Extensive experience writing SAS codes in major platforms such as UNIX and Windows. Extensive experience in extracting large amounts of data (tens of millions of records) from various databases such as Teradata, MS SQL Server 2005/2008, Oracle 9.i/8i.
• Strong experience in defining ETL processes, data migration, data mapping, data profiling, modeling, validating and performing gap analysis. Adhere to good systems agile development methodology. Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Experience working wif SAS Enterprise Guide for performing analysis and generating reports. Experience working wif JIRA tool for change management.
• Great deal of experience generating reports using numerous SAS procedures such as PROC SQL, PROC REPORT, PROC SUMMARY, PROC MEANS, PROC FREQ, PROC TABULATE and PROC PRINT.
• Strong experience in documenting business requirements. Great deal of experience in writing and/or modifying SQL queries. Experience utilizing SAS procedures, Macros and other SAS tools for data extraction, data cleansing, data loading and reporting. Analyzing teh data, DB creation, applying database constraints and making teh data ready-to-load onto teh database.
• Hands-on experience in developing SAS codes for extracting data from Flat Files, Excel spreadsheets, external RDBMS tables using LIBNAME and SQL PASS-THROUGH facility.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows XP/7/8, MS-DOS.

Database: SQL Server, Teradata, Oracle.

SAS Skills: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ETL, SAS/CONNECT, SAS Enterprise Guide, SAS DI Studio, SAS Visual Analytics.

Other: MS Office Suite, MS Project, MS Visio, Subversion, Python, Tableau, SQL Server, MySQL, PostgreSQL

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst/ Data Operations Programmer

Responsibilities:

• Used GIT/subversion for source code control and wrote custom scripts for daily full and partial metadata/workspace server backups. Involved in SAS programming, extensively used SAS data steps and PROC Sql pass through.
• Ensure all key operational metrics are met, particularly in teh area of service quality, productivity and overall efficiency.
• Use management console to check teh Status of teh Object Spawner, SAS Workspace Servers, and SAS Stored Process Servers.
• Perform and automate SQL server version upgrades and patch installs. Designed, developed and maintained relational databases.
• Interface wif Biostatistician to validate business requirements/requests for analysis and present intermediate and final analytical results. Modified macros for report generation using SAS Macros as per teh requirements.
• Enhances clients data marts and teh enterprise data warehouse by working closely wif internal and external teams. Participates in strategic planning to improve teh organization’s ability to produce reports and data requirements for end-users

Confidential

Data Analyst

Responsibilities:

• Maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Assist in creating process logging and new monitoring tools, integrity reports, and mapping tools.
• Extensively used MIGRATE procedure and validation tools in SAS GRID environment. Used PROC MIGRATE to copy and moves libraries from source location (Linux) to target location (Windows).
• Extensively involved in post-migration validation and documented results as part of teh change control process. As part change control process, maintained a complete history of changes and kept a complete record that can be used for auditing and tracing.
• Collaborate on a team of 5 to complete software development life cycle (SDLC) for different simultaneous and sequential migration projects.
• Utilized SAS Enterprise Guide for analyzing data and publishing dynamic, interactive reports for teh team. Worked wif large data sets (30+ million records) and transactional data.

Data Analyst

Confidential

Responsibilities:

• Hands on experience wif SAS LASR Analytic Server using distributed computing environment. Load tables into teh server by using teh SAS LASR Analytic Server engine and teh LASR procedure from a SAS session that has a network connection to teh cluster. Well Versed in VA reports, used designer view, data builder to create custom reports in Visual Analytics.
• Performed ETL using SAS GRID Data Integration Studio and register library and server metadata, performed promotion (full/partial) using batch scripts/SAS macros, setup coding and data warehouse standards. Used subversion for source code control and wrote custom scripts for daily full and partial metadata/workspace server backups. Used management console to check teh Status of teh Object Spawner, SAS Workspace Servers, and SAS Stored Process Servers.
• Modified existing datasets using simple Base SAS Concepts such as SET, MERGE, UPDATE, PROC SORT and conditional statements. Merged datasets using both PROC SQL Joins and DATA STEP MERGE based on teh data.
• Performed extensive statistical analysis on teh extracted data using SAS/STAT procedures such as PROC FREQ, PROC MEANS, PROC SUMMARY, PROC UNIVARIATE, PROC ANOVA, PROC TABULATE and PROC TRANSPOSE.

Data Analyst

Confidential

Responsibilities:

• Involved in developing, testing, and writing programs and reports according to business specifications. Worked on UNIX Shell Scripting (Korn Shell) for automation of processes.
• Communicated wif 6 team members to document methodology, including data reports and model results, and shared noledge wif teh Project Manager. Extensively worked on process validation and documentation. Implementation of end to end ETL process.
• Merged datasets using both PROC SQL Joins and DATA STEP MERGE based on teh data. Developed complex SAS Macros in UNIX and Windows Environment to simplify SAS code and TEMPeffectively decrease coding time.
• Utilized Base SAS concepts such as teh MISSOVER and TRUNCOVER option in teh INFILE Statement, to work wif missing values in Flat Files. Developed analytics models using SAS Enterprise guide and web reporting solution that was scalable wif regards to data volume, attributes selection, reporting frequency and report selection using SAS Stored Process, SQL server, shell scripting and python.

VOLUNTEER WORK

Confidential, New York, NY

Responsibilities:

• Presented multiple presentations to teh NGO’s UN youth program/projects at teh UN-Youth Assembly.
• Facilitated networking events to recruit student for NGO’s UN Summer Youth Program. Provided documentation, briefings, research, and analysis, wif particular reference to work of teh General Assembly’s 72nd session and supported teh efforts of teh office in covering it. Assisted in reporting on teh Executive Boards of UN entities, thematic debates at teh General Assembly, including on teh High-Level Panel on teh Political Declaration on teh commitments on HIV/AIDs.
• Volunteer One Brick
• Volunteer Blue Crest Rehabilitation Center
• Participated in Olympic Day Run International Olympic Committee (JUAN ANTONIO SAMARANCH)