SUMMARY

• Over 10 years of IT industry and 8 years in Health Care/Clinical trial data experience involved in analysis, design, testing, implementation, maintenance, production support with good analytical skill and problem solving.
• Experience in Data warehouse and Business Intelligence (BI) projects involving in Perform and manage development and implementation of TED, PCDW & HL7 Solution for US Department of Defense Health care system.
• Experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications.
• Experienced in SQL Server DTS/SSIS packages to import, transform and load (ETL) data between databases and external data sources.
• Excellent experience in ETL(SSIS) and REPORTING (SSRS, PowerBI)
• Experience as clinical data analyst in developing, managing, storing and retrieving data for driving solutions in clinical trials.
• Expertise in managing projects from start - up to close-out. Hands on expertise on end-to-end aspect of Data Management (CRF Design, DB build/Validation, Edit Checks, UAT, Data Management Plans, Study execution - SAE/Lab Recon, EDC cleaning, Listing review, Medical Coding and Close out activities - DB transfer and DB lock).
• Expertise in the EDC systems (Oracle9i, MediData, Oracle Clinical, SQL, eTMF, CTMS, Veeva Vault, IxRS,)
• Experience in implementation of Best Practices, use of Microsoft Visio Professional for Process flowcharts etc.
• Experience in managing outsourced vendor studies.
• Proven track record of managing and delivering successful clean locked databases.
• Experience on Data Warehousing using Business Intelligence tools such as Business Objects, Informatica and Crystal Reports.
• Experience in Amazon AWS Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, AMI, SNS, RDS, IAM, Route 53, Auto scaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, Security Groups.
• Experience with ETL development and implementation.

TECHNICAL SKILLS

Databases: Oracle9i, Medidata Rave, Oracle Clinical, SQL Server, Ms Access

SAS Tools: SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ODS

SAS Procedures: Proc Freq, Means, Lifetest, Format, Contents, DataSets, Compare, Print, Summary, Univariate, Sort, Transpose.

Operating System: Windows … Professional/Windows 7/Windows 8

ETL Tools: Informatica, SSIS, BODS

Virtualization: VM Ware, AWS.

Office Tools: MS-Office … Word, Excel, Power Point, MS Access

BI Tools: Cognos 8 BI Suit, SSRS, Business Objects 4.1/4.0/XI3.3/3.2/3.1/XI R2/6.5.1

Languages: SQL, PL/SQL, UNIX shell scripting, C, C++,R, Python.

PROFESSIONAL EXPERIENCE

Confidential

ETL/Clinical Data Analyst

Responsibilities:

• Worked on various studies including Phase I to III studies.
• Design,deploy,andmaintainvariousSSRSReportsinSQLServer.
• Write Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple serversandresources.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database EngineTuningWizard
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Transformation Developer.
• Developed complex Crystal, Web Intelligence and Desktop Intelligence Reports.
• Created reusable Mapplets and used them in different mappings
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects.
• Tracked study progress and issued periodic status reports
• Have good understanding about using proc report and generating customized outputs using SAS ODS.
• Updated database to correct errors
• Working within the Standard Operating Procedure (SOP) system, including departmental
• Accurate and timely upload and data entry of Clinical Documents, Case Report Forms, and Clinical Study Agreements into Electronic Trial Master File System (eTMF) via uploading or using Batch Browser
• Provide computer and program support on all levels for the Clinical Study group
• Prepare files for FDA audits
• Reviewing and processing clinical trial data to ensure the accuracy and consistency of clinical databases.

Confidential

ETL/SAP Consultant

Responsibilities:

• Configured user groups/sub-groups & assigned profiles thereby restricting un-authenticated access to resources.
• Responsible for overall Business Objects infrastructure maintenance, applying Patches, Service Packs, and Monthly HotFix (MHF) to upgrade the BO environment.
• Designed, gathered and analyzed user report requirements, meeting business heads for gathering user requirements.
• Provide support to all SAP business objects and provide appropriate upgrade on environment.
• Worked on 24/7 support model on rotation basis for BO environment performance and customer issues.
• Worked on Tomcat configurations and Web layer deployment of Business Objects InfoView and CMC.
• Perform the administration of end users, created new users, user groups, roles and assigning privileges.
• Worked on Administration tasks of BO such as security setup, creation of BO objects (folders, groups, scheduling of reports etc.)
• Perform configuration and tests to all business objects.
• Coordinate with solution architect and prepare appropriate architecture for business objects.
• Worked on performance, tuning for scheduled and preview of reports. Worked on Security setup, roles, user folder security and other administration tasks.
• Involved in performance tuning of reports that were running slowly. Performance tuning was executed Confidential the report level, designer level and database level.
• Tested and migrated the reports and objects from development to production environment.
• Interacting with the business team for the requirements gathering and other technical issues fixes in the environment.
• Administer and supervise configuration of all business objects.
• Worked on architecture and planning of Business Objects 3.1 for DEV, QA and PROD environments.
• Responsible for User Administration: Troubles shoot & manage users, train users, enforce security privileges to the repository.

Confidential

Lead ETL Developer

Responsibilities:

• Created Informatica/ETL design documents as per the requirements and high-level design document
• Worked extensively with transformations such as Lookup, Joiner, Aggregator, Filter, Sorter and Update Strategy to create several mappings
• Used different transformations to move data from application source to data warehouse as per the business requirements
• Used Workflow Monitor to monitor the workflows as they are executed and used the information provided to troubleshoot sessions and improved session performance
• Created shell scripts for better handling of incoming source files like moving file from one directory to another directory, extracted information from file names such as date for continuously incoming source
• Involved in performance tuning of ETL
• Created Database Triggers, Stored Procedure, Functions and Packages
• Used SQL Loader for data loading
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts
• Extensively used all the features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Hands on experience on Data Warehousing using Business Intelligence tools such as Business Objects, Informatica and Crystal Reports.
• Created complex reports using Crystal Reports XI.
• Extensively working using SDLC and deployment of database and ETL objects and reports
• Involved in training the support team and resolved post production issues teams

Confidential, Newark, NJ

Data warehouse Developer

Responsibilities:

• Analyze, design, construct and implement the ETL jobs usingInformatica
• Extracted Data from Different Sources by usingInformatica
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations. Templates creation utilizing Impromptu.
• Cleanse the source data, Standardize the Vendors address, Extract and Transform data with business rules, and built Mapplets usingInformaticaDesigner.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes andInformaticasessions and batches
• Created Users, user groups, database connections and managed user privileges using supervisor.