PROFESSIONAL SUMMARY:

• Over Eight years of experience as a Business System Analyst with solid understanding of Business Process Flows, Case Tools, and Business Analysis.
• SAS Developer/ Data Scientist with Eight years of SAS/R/Python programming experience, providing statistical programming support for multiple clinical research projects in pharmaceutical, biotechnology and contract research organization (CRO) industries
• Experienced in full Software Development Life Cycle (SDLC) from Business Requirements gathering, creating Functional and Design documents, test scripts and business case development to rollout and maintenance.
• Wide experience in various industries like Education services, Health care, banking, and insurance agency.
• Experience working on multiple projects simultaneously.
• Excellent Communication and Analysis skills. Experience working with Business users to analyze and document Business Requirements and Functional documents.
• Good understanding of process identification, definitions, documentation, and project management methodologies.
• Strong skills in Power Designer tool with Requirements model, Business Process model and various Object Oriented Models.
• Strong Knowledge of UML Use Case Diagram, Sequence Diagram, Collaboration Diagram, Activity Diagram, Class Diagram, State Diagram, Package Diagram, Component Diagram, and Deployment Diagram.
• Solid business, communications, and presentation skills; adept at creating, editing, and coordinating extensive communication networks (facilitation of joint application design (JAD) sessions and interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations, e - mails, etc.), to keep executive staff and team members apprised of goals and project status.
• Worked with various development, testing, data management teams and Solution architects to develop various Functional documents, Business Process Models, Data models and information flows.
• Experienced in developing initiation, Scope documents, Business Requirements, Gap Analysis documents, Functional Requirements, functional specifications, test documents, User and System documentation, process work flows, and implementation plans, including creating test plans and scripts, and managing test execution and issue reporting / resolution.
• Experienced in Health care industry and customizing the software according to the HIPAA regulations and worked in the National Provider Identifier (NPI) Piece.
• Advanced skills on data cleaning and manipulation using procedures such as PROC SUMMARY, PROC SORT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC PRINT, PROC REPORT, PROC TABULATE, PROC COMPARE, PROC CDISC  and many SAS data steps such as ARRAY, MERGE, SET, etc.
• Five-year experiences in developing advanced analytical toolkits & algorithms using SAS and R.
• Used SAS 9.4 Grid Manager, for effectively managing the use of SAS® Enterprise Guide® in a grid environment.

TECHNICAL SKILLS:

Languages: SAS, C, C++, C# version 2.0, Visual Basic. NET, Python, R

Business Tools: Power Designer 12.1, MS Office Visio Pro 2003, RUP 2003, Rational Rose 2002, UML Smart Draw version 7.50, MS Project 2003, PVCS Version Manager, Microsoft Visual SourceSafe .

Operating Systems: Windows 9x, 2000, NT, XP, DOS

Databases: Oracle SQL Developer 1.2.1, MS-Access 2003, SQL SERVER, MySql

Internet Technologies: TCP/IP, HTML, XML 1.0, WML 1.2, MS-Front Page 2003

Office tools: MS Office (Word, Excel, Power Point, Access and Visio)

PROFESSIONAL EXPERIENCE:

Confidential, Michigan, Detroit 

Sr. Business Analyst

Responsibilites:

• Assist and support in the planning, coordinating, developing, validating and implementing of approved projects which are Divisional and/or Corporate in scope in order to enhance the overall efficiency of operational procedures, methods, controls, and performance.
• Gathered Business Requirements from the Core Program Management team and the stakeholders for the Revised GRE General Test.
• Captured all of the Business Requirements in Power Designer 12.1 tool.
• Analyze process and/or expedite operational transactions and provide timely resolution of problems.
• Maintained list of internal issues and assigned them to responsible parties.
• Captured and maintained all the Business Rules, Issues etc for the Business Requirements in the Power Designer model.
• Captured Meeting Minutes and action items for each of the Stake holder meetings.
• Base lined the Business Requirements document and managed various Change Requests.
• Created various Functional Requirements documents like Business Process Flows, Use case diagrams in Power Designer and reviewed with the Business.
• Designed various User facing Screens and reviewed the content with the User Experience Group.
• Participate in systems testing, develop procedures/controls and provide recommendations for the ongoing improvement of the updated process.
• Provide leadership team with status of projects, issue, communicate and recommend policy decisions to achieve project objectives
• Produce routine and non-routine reports, presentations, letters communications and graphics
• Assist personnel (both internal and external) by answering questions, supplying information and training. Represent department and division as requested on work groups and special assignments.
• Develop and maintain an effective working relationship with customers or partners
• SAS (BASE, Macros, STAT) - SQL.
• Strong Analytical Skills (using SAS, Oracle, SQL, Microsoft products, etc.).
• Analytical experience and trending. Demonstrated ability to research issues, perform root cause analysis, compare/contrast, and implement problem resolution.
• Identified various stakeholders for different functional area.
• Constantly reviewed all the Business Requirements with the internal team, stake holders from various functional areas and made all the necessary changes.
• Generated various Business Requirements Reports for different functional areas of the stake holders.
• Maintained hours used for the project in People Soft 8.
• Maintained various documents for the project on SharePoint to share within the team.
• Created a Weekly status report and updated the manager with the status of the project.

Technologies: Power Designer 12.1, Share Point, PeopleSoft, MS Visio 2003.

Confidential, Atlanta, GA

SAS Programmer /Business Analyst

Responsibilities:

• Developed and reviewed SAS programs and output for the management and reporting of clinical trial data. Utilized SAS based systems to assist and facilitate Clinical Data Management activities.
• Base lined the Business Requirements document and acquired sign-off.
• Captured and maintained various Business Rules, Issues, Assumptions, Dependencies, and Risks etc in the Power Designer.
• Created various Functional documents like Application Requirements, Object Oriented Model (Use case diagrams) in Power Designer.
• Generated various Screen Flow Diagrams and involved in the actual Screen design with the User Experience group.
• Worked with the Data Management Group and created the Conceptual Data model.
• Tied the Business Requirements to the corresponding Use case and generated Traceability Matrix.
• Generated various Power Designer reports of the Business and Functional requirements on demand.
• Maintained various documents for the project on SharePoint to share within the team.
• Practiced preparation of Programming Plans, study set-up and review of study specific documents.
• Performed routine quality check on datasets, DDDs, aCRF to ensure their accuracy according to the client specifications.
• Developed SAS programmable edit checks to assist in data review as needed. Answered QA audits in an accurate and timely manner.

Environment: SAS V 9.4, Linux, Windows XP SAS Base, SAS Stat, SAS Graph, SAS SQL, SAS Macros, SAS Access, MS-Excel, Power Designer 12.1, Share Point, PeopleSoft.

Confidential, Washington, DC 

Risk Analyst - CDO Clinical Development & Ops/ SAS Administrator

Responsibilities:

• Developed a pre-processing trend model to isolate and monitor credit risk metrics (PD, LGD, EAD) for corporate-wide loan portfolios, created monthly trend reports using Excel VBA, reduced production time by 40% and ensured data integrity (SAS/SQL, Access, Excel VBA).
• Reviewed the existing User Manual and Help documentation.
• Organized various meetings with the I-OPS application SME to discuss its current capabilities and enhancements already in progress.
• Reviewed the relevant User and System documentation for ITP application and met with respective SME.
• Created a Gap Analysis document to identify the differences in high level functionality between the ITP and I-OPS and indicated the Gaps.
• Also compared the high-level system operating requirements between the two applications.
• Reviewed the Gap Analysis document with the Business and incorporated their feedback.
• Created a list of Enhancements for the I-OPS system based on the Gap Analysis document.
• Constructed static consumer debt (credit card) data pools and calculated credit-score-bucket transition probabilities, delinquency and charge-off rates for loan performance tracking and further predictive default and correlation modelling (SAS, Excel).
• Researched capital simulation models and prepared input data tables for measurement of risk capital through Monte Carlo-VaR methodology to satisfy capital adequacy requirement.
• Streamlined and aggregated non-modeled portfolio data across disparate systems and sources with SAS/Access.
• Supported the analysis and reporting functions that surrounded the Risk Management processing. Created, modified, or enhanced three functional areas of assessing the Value at Risk or "VaR".
• Proposed an earnings-volatility Excel model to indicate corporate credit downgrade risk.

Environment: SAS V 9.4, SAS V 9.2, Linux, Windows XP SAS Base, SAS Stat, SAS Graph, SAS SQL, SAS Macros, SAS Access, MS-Excel

Confidential, Round Lake, IL

SAS Programmer /Lead Business System Analyst

• Worked with clinical trial datasets and clinical reporting in phase I - phase III studies using SAS.
• Worked with various Research Scientists and Psychometricians and prepared various Solution design and Proposal Development planning documents for presenting to the client.
• Defined and recommended solutions that address IIM’s criteria including analysis of the benefits, feasibility, timeline implications and qualitative costs vs. objectives.
• Responsible for manipulating, transferring and managing clinical trial data in SAS. Working with SAS Analysts in clinical data programming and data processing.
• Broadly involve in analyzing and coordinating clinical trial data, generating reports and TLG’s.
• Successfully designing and implementing statistical report processes for regular data collection and clinical data analysis. Analyzed Phase I, II and III Clinical Trials.
• Functioning with Data Management Group to create data clean and data validation listings. Using Edit checks regularly for the detection of new errors and the identification of data points with outstanding Data clarification requests (DCR). Use of Last-Observation-Carried-Forward (LOCF) method for clinical trial analysis for handling missing data and dropouts.
• Handling the tasks of extracting data from the database using SAS Access, SAS SQL procedures and creating SAS data sets.
• Apply Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Gathered various documents on background of IIM and their objectives for the CAT test and shared with the internal team.
• Posted various project related documents on SharePoint.
• Prepared a presentation with various options for the Computerization of the CAT and the feasibility and the Risks for each of the options.
• Got feedback on the presentation from various members of the team.
• Gathered information of the Competitors in the bid.
• Handling the maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for creating Reports and Graphs.
• Assigning the tasks for creating new datasets from raw data files using import techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Produced complex and reusable Macros and widely used existing macros and developed SAS programs for data cleaning, validation, and analysis for report generation. Tested and debugged existing macros.
• Generating Tables, Graphs and Listings for clinical study reports and regulatory submissions; Participated in preparing study results as well as ISS and ISE for FDA submissions using SAS.
• Using PROC SQL extensively to perform queries, join tables.
• Working with Bio-statisticians to analyze the results obtained from various statistical procedures like PROC ANOVA, GLM and mixed models.
• Acting as a bridge between Data Management and Clinical department communicating with users, programmers and management.
• Attending project team meetings, worked with bio-statisticians, data management team, and clinical research managers as appropriate. Worked on multiple projects simultaneously and met the deadlines as and when required.

Environment: SAS V 9.3, SAS V 9.4, Linux, Windows XP SAS Base, SAS Stat, SAS Graph, SAS SQL, SAS Macros, SAS Access, MS-Excel, share point, PeopleSoft

Confidential, Madison, WI

SAS Programmer/ Clinical Data Analyst 

Responsibilities:

• Utilized SAS proc and other SAS applications for data updates, data cleansing and reporting
• Preparing and Classifying Clinical Trial Data
• Importing Relational Databases and Clinical Data Management Systems
• Transforming Data and Creating Analysis Data Sets
• Creating Tables and Listings and Common Clinical Trial Graphs
• Performing Common Analyses and Obtaining Statistics using PROC FREQ and PROC UNIVARIATE
• Exporting Data to the FDA using the SAS XPORT and creating XML Files

Environment: SAS 9.3, SAS V9.2, SAS BASE, SAS SQL, SAS ODS, Windows XP, Excel/Access 2000.

Confidential, MA

Clinical Data Analyst

Responsibilities:

• Utilized SAS proc and other SAS applications for data updates, data cleansing and reporting
• Preparing and Classifying Clinical Trial Data.
• Importing Relational Databases and Clinical Data Management Systems
• Transforming Data and Creating Analysis Data Sets
• Creating Tables and Listings and Common Clinical Trial Graphs
• Performing Common Analyses and Obtaining Statistics using PROC FREQ and PROC UNIVARIATE
• Exporting Data to the FDA using the SAS XPORT and creating XML Files

Environment: SAS V8, SAS V9.2, SAS BASE, SAS SQL, SAS ODS, Windows XP, Excel/Access 2000.

Confidential, TX

SAS Programmer

• Worked with clinical trial datasets and clinical reporting in phase I - phase III studies using SAS.
• Responsible for manipulating, transferring and managing clinical trial data in SAS. Working with SAS Analysts in clinical data programming and data processing.
• Broadly involve in analyzing and coordinating clinical trial data, generating reports and TLG’s.
• Successfully designing and implementing statistical report processes for regular data collection and clinical data analysis. Analyzed Phase I, II and III Clinical Trials.
• Functioning with Data Management Group to create data clean and data validation listings. Using Edit checks regularly for the detection of new errors and the identification of data points with outstanding Data clarification requests (DCR). Use of Last-Observation-Carried-Forward (LOCF) method for clinical trial analysis for handling missing data and dropouts.
• Handling the tasks of extracting data from the database using SAS Access, SAS SQL procedures and creating SAS data sets.
• Apply Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Handling the maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for creating Reports and Graphs.
• Working with Bio-statisticians to analyze the results obtained from various statistical procedures like PROC ANOVA, GLM and mixed models.
• Produced quality customized and ad hoc reports by using PROC TABULATE, REPORT and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Generating reports either in HTML, PDF or RTF format according to the client specifications.
• Acting as a bridge between Data Management and Clinical department communicating with users, programmers and management.
• Attending project team meetings, worked with bio-statisticians, data management team, and clinical research managers as appropriate. Worked on multiple projects simultaneously and met the deadlines as and when required.

Environment: SAS 9.2, Linux, Windows XP SAS Base, SAS Stat, SAS Graph, SAS SQL, SAS Macros, SAS Access, MS-Excel.