SUMMARY

• Over 12 years of experience in Project Management, Database Administration, Database Analysis, Designing, Data modeling (Logical and Physical) developing, mapping, Testing, Implementation, Documentation, Customizing and maintenance of software applications.

TECHNICAL SKILLS

Project managing skills: Leadership, communication, budget planning & management, planning skills, time & team management, risk management, negotiation skills, personal organization.

Project managing tools: MS Project, Jira, Service Now, Version One, MS Teams, Skype for Business, Office 365, SAP PPM

SAP Technical: SAP S4 HANA, BW/BI, HANA Data Molder, HANA Studio, HANA Migrations, SAP BASIS, Solution Manager, SAP Cloud ALM.

Testing tools: ALM, HP Quality Center, Mercury Quality Center

SAP Functional: SAP SD, OTC, PTP, MM, FICO, CONCUR, HR, PP, PPM, PM, ISU

Software: SDLC, Accelerated SAP, MySAP, ASAP, Agile, Waterfall.

DB Skills: HANA, Oracle, MSSQL

IT Tools: Windows, Mac, Linux, MS office, MS Project, Power BI, Visio, HP/Mercury Quality Centre, C, C++, Java, Pl/SQL.

Cloud services: Microsoft Azure, AWS, VMWare.

PROFESSIONAL EXPERIENCE

Confidential

Project Manager

Responsibilities:

• Worked under Waterfall and Agile Methodology. involved in various project management activities like requirement analysis, project planning, project scoping, resource allocations, project risk/impact analysis & mitigation plans, scope/change control management, project monitoring, and SOX Compliance.
• Lead all project management activities including project planning, risks, scope, budget, resource allocations, testing and quality control; built, deployments, deliverables, and budget tracking.
• Collaborated with business and technical stakeholders to identify, manage project risks.
• Created, maintained and statues’ project schedule on a weekly basis.
• Project status updates meeting with stack holders.
• Set deadlines, assign tasks, monitor progress, and help project team to prioritize workload.
• Identified and resolved issues and conflicts (includes prioritizing work) within the project team.
• Ensured adherence to SLA and reviewed project deliverable.
• Responsible for program management to ensure aims and objectives are met.
• Responsible for bringing in lessons learnt, reusable artefacts like cut - over plan and recommending best practices in S/4HANA conversion program Servers as a champion within the client business community to communicate and enable the program objectives.
• Responsible for escalated issue resolution and risk mitigation
• Manages and directs day to day program activities and resources.
• Contributes to establishing Program Management office procedures and standards.
• Develops and manages overall work plan including tracking deliverables, milestones and schedule manages issues, risks, and scope to ensure identification, escalation and resolution in a time efficient manner.
• Responsible for overall program delivery against agreed scope, schedule, and budget
• Coordinates overall program resources planning and staffing, ensuring business engagement towards adoption.
• Manage team members to ensure the work is performed effectively and productively, ensuring cross stream collaboration.
• Provide support to Innovation lead for planning innovation roadmap and delivering agreed upon innovations.
• Oversee development of all project deliverables, ensuring completeness and quality.

Operations and Maintenance of Applications of Clinical Databases

Confidential

Responsibilities:

• Involved in Creating Database schemas, Design Database, Review, analyzes, and modifies programming systems including encoding, testing, debugging, and installing Clinical software systems.
• Responsibilities include Oracle Database Upgrades, apply PSU patches and Critical patch sets.
• Install and Configure Oracle Database, Listener configuration, maintain Data Dictionary, Create, and maintain User accounts/administration.
• Involved in project phases for installation and maintenance for newly acquired applications.
• Manage Quality Assurance/Regulatory personnel related to clinical trial data and other clinical data.
• Create system models, specifications, diagrams, algorithms, flowcharts to provide direction to software development.
• Create the database, tables, table spaces, data objects, primary and referential Integrity constraints to establish the relationship of the tables and perform any existing Code issues,
• Materialized views, setting privileges, indexes, user logins, passwords (security), tuning, optimizing queries, develop PL/SQL triggers/stored procedures and functions, packages.
• Oracle Database and OFM Middleware Upgrade from 10g to 11g provided support for Oracle upgrade, application installation and operation, and database implementation.
• Enhance existing Code, Conduct Walkthroughs, testing, implementation, Spec docs, User training and documentation, Managing and Support of the application. Created Ad hoc/Formal reports based on User requests to
• Participate in system testing activities, to include the verification of test scripts, cases, scenarios, and data as well as the execution of system integration testing and system acceptance testing.
• Enhance existing Code, Conduct Walkthroughs, testing, implementation, Spec docs, User training and documentation, Managing and Support of the application.
• Created Ad hoc/Formal reports based on User requests to produce output in .html, .xls, .pdf, and list formats. Integrate application modules.
• Created simple to complex ad-hoc reports using SQL Plus and TOAD for the business users.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Design and write SOP related to data maintenance as per regulatory agencies.
• Knowledge and maintenance of Clinical data as per GLP, GCP and GMP.

Database Developer/Administrator

Confidential

Responsibilities:

• Creating workspace and grant user privileges and Create Website for regional team.
• Identifying schedule of tasks to implement design, and transition project to production maintenance, Create, update, and maintain databases, create, and maintain scripts using SQL and PL/SQL. Involved in Data Migration, prepare scripts and perform dry runs.
• Schedule and perform data loads and error checking to populate databases at regular intervals, perform detailed data analysis and troubleshooting as needed.
• Support LIMS application for user support and user accounts including application support.
• Developed procedures to migrate spatial data to space-delimited SQL*Loader formatted files. Developed script that was scheduled to move data files via FTP. Analyzed performance issues with wait events.
• Designed oracle stored procedures, cursors, and triggers to perform data operations.
• Involved in designing and development of an Inventory application for keeping track of Inventory, taking online orders from users, and generating reports from online thru UNIX shell scripts in the backend.
• Performed through data profiling by using the Investigate stage of Quality Stage and by writing PL/SQL queries to identify and analyze data anomalies, patterns, inconsistencies etc.
• Worked with different Sources such as Oracle, MS SQL Server and Excel, Flat files.
• Write PL/SQL stored procedures and functions to manage data, queries for necessary requirements, and triggers for data automation.
• Installed, security, and maintenance of Unix/Linux based systems.
• Used Data Stage Administrator to create Repository, User groups, Users, and managed users by setting up their profiles and privileges.
• Responsibilities included data modeling, data mapping, data analysis, data migration, preparing functional, technical specifications and coding, design high level flow diagrams, develop batch scripts, SQL Scripts, HTML page structure, content, programming, graphics, web form pages for
• consultants pay roll systems preparing functional, technical specifications design high-level flow diagrams.
• Deploying reports for the Intranet application, generating reports according to the requirement, provide user training,
• Optimizing, performance tuning, mentoring, Coordinating, and monitoring. In addition, libraries, templates, SQL scripts and stored procedures, user/technical documents were developed to improve performance and to assist in administering the development environment.
• Designed DataStage Jobs to extract data from XML files using XML input stage, Used XML transformer stage to cleanse and transform the data to load it into the Data Mart.
• Worked under GDP and 21CRF part 11 Guidelines.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.

Research Assistant

Confidential

Responsibilities:

• Statistical analysis using SPSS (Multiple regression and path analysis, Hypothesis testing T-test, ANOVA, chi-square
• Preparation of chemicals needed for the Experiments.
• Guiding project members with Analysis of samples, data reviewing and report drafting.
• Maintenance of database and statistical analysis of the various projects.
• Clinical Trial Manager (CTM) managed multiple projects going in the Research.
• Calibration of lab instruments and preparation of quality documents (COA’s).
• Preparation of lab documents and manuals for the undergraduate’s laboratory work.
• Inspection of laboratory instruments and setup lab for the undergraduates.
• Clinical Research Organizations (CRO) in managing various protocols and case reports and as a budget keeper in the ongoing projects.
• Expertise in analyzing and coordination with clinical trial data, generating reports, tables, listing and graphs.
• Optimized performance using data validation data cleaning on Clinical Trial data using statistical procedures.
• Involved in writing standard operating procedures (SOP) for reviews and approvals.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.