SUMMARY:

• Expertise in MS SQL Server, MS Office Suite, MS Project, MS SharePoint, Visio
• SQL Programming and coding, Database design principles, Scripting, MS - Access Database Management and relational database development skills, VBA, Reference Manager Bibliographic Software
• Expertise in subversion control, a source control software for Microsoft windows.
• Basic knowledge of statistical software such as SPSS & SAS language and statistical procedures.
• Seminar presentations and projects in Systems Development.
• Positive attitude and dedication to work.
• Fluent in all aspects of English language.
• Excellent computer applications, programming and analytical skills.
• Ability to communicate with individuals at various levels within the organization and external clients.
• Excellent critical thinking, questioning, and listening skills; superior attention to detail.
• Time management skills for managing multiple tasks simultaneously, while completing work within allocated time frames.
• Responsible for design, implementation and modification of multiple research databases.
• Expertise in the design, development and maintenance of databases and systems using database monitoring tools
• Understanding of data and table management
• Collect, organize, manipulate, integrate and analyze of data from variety of sources.
• Assist in investigating and gathering data.
• Provide appropriate documentation for research
• Assist in preparation of materials for publication and work on different projects
• Compile data for research reports, assist with summary and analysis tasks, assist in preparing graphs and tables
• Develop or modify complex databases.
• Ensure appropriate documentation for all development and modification.
• Ensure the integrity and security of institutional data and patient records
• Experience with data management, versioning of data, backups, etc
• Perform data analysis and problem solving in the healthcare environment.
• Interact with Doctors, nurses, Investigators etc on understanding/defining their information needs and work towards meeting those needs.
• Brainstorm with functional teams and recommend optimal way to collect, store, retrieve and analyze the data.
• Translate business requirements into the technical specification documents.
• Concentration in Software Technology and Systems Management
• Coursework Windows, DOS, LAN, Microsoft Office Suite, Unix, C, VBA, Foxpro, RDBMS (Relational Database Management Systems), SQL,Sybase

Confidential

Database Analyst

Responsibilities:

• Responsible for performing database and maintenance design of over 35 databases over the last 5 years on different research protocols while utilizing his knowledge of database/software validation, up-to-date querying tools and various relational database structures and methodologies.
• Working on several clinical databases based on various research grants. Responsibilities in this position includes assisting with the management and analysis of medical research data for patients diagnosed with cancers using different MS SQL server to author programs and codes to maintain, analyze and update medical research data.
• Working knowledge and conducting MS Access-based database programming utilizing Visual Basic applications (VBA) programming language to manage multiple research databases.
• Working on database management and validation. Substantial expertise in managing large databases with current querying tools and relational database structures and methodologies.
• Responsible for coordinating protocol research information management of assigned tasks within the Department of Confidential and Cancer Control with independent decision-making authority.
• Systems in collaboration with principal investigators and the Department Chair.
• Attend database build meetings with end users to determine database design and requirements, as well as future updates.
• Utilize various applications (such as MS Access 2010 and MS SQL Server 2008) and programming languages to build, maintain and update large databases, review database designs and ensure the consistency of standards, procedures and content.
• Implement code to realize system design and develop programs to assess data content, interpret results and verify accuracy.
• Participate in data migration activities between legacy systems and new database applications.
• Assemble, manipulate, analyze, and disseminates data. Serve as the primary individual responsible for the integration of information from various disparate systems. (DB)

Confidential - Nashville, TN

Database Analyst

Responsibilities:

• Designs, develops, modifies and implements database systems programs and applications using MS SQL, T-SQL, Data Modeling and Relational Database design
• Primary responsibility and oversight for multiple research databases of over 20 million hospitalized & outpatients and patient admissions with over 40 millions of rows of data within the National Veterans Affairs (VA) Health system from all over US.
• Involved in dynamic data transformation of large body of SQL scripts built on region database schema to C# on the national corporate data warehouse schema using the Entity Data model framework.(C# LINQ to SQL)
• Actively writes SQL queries with minimal supervision from faculty supervisors.
• Serve as technical resource to users and others in the research group in the area of database management
• Administrates and trains staff and faculty in data storage and subversion source control repository, and administrates the system
• Liaison with information architects to develop data models for the repository
• Supervises Informatics and clinical research fellows for database manipulation, data cleaning, and analysis activities
• Assigns work and establishes priorities to ensure deadlines are met
• Tracks investigator and staff action items related to the databases
• Actively identifies and participates in training, education and development activities to improve own knowledge and performance to sustain and enhance professional development
• Data sourcing, data mapping and managing metadata
• Documenting and analyzing workflow and clinical processes.
• Provide database programming support and troubleshooting and review process design
• Develop requirements for data mapping and data transformation processes.
• Work with Information architects to develop data models for the data repository.
• Able to generate reports during the ongoing research process.
• Database Cleaning and Optimization
• Working with students, fellows and faculty members who need to access the data for research work and assist with coding.
• User of electronic health record software CPRS (Computerized Patient Record System)
• Managing subversion control and assigned as ProjectLocker Wiki/SQL Script Repository Administrator
• Operations and maintenance of standard, routine queries
• Additional tasks related to data extracts, automated operations and SQL queries as required
• Screen medical charts
• Update documentation on current tools and datasets.
• Track progress towards goals.
• Generate regular reports on status of data projects and ongoing assignments.
• Compile documentation of program development and revisions in a timely manner.

Confidential - Nashville, TN

Research Analyst I

Responsibilities:

• Relational database programming and application development with responsibility for database design and maintenance with Access Visual Basic programming for clinical databases
• Design and creating data entry screens and utilities and maintain database systems using Access
• Data Analysis and documentation of research data, data coding and database management of clinical research data.
• Help developing forms that will collect the appropriate data.
• Maintain data files, error checking and updating data files.
• Design, code, test and document data entry, processing and validation systems to support data registries to include maintenance of existing systems as well as research and development for enhancements
• Maintain databases and enter study related data into a research database.
• User of StarPanel Clinical Data Repository which is Confidential ’s integrated web based application that allows access to electronic medical records.
• User of REDCap (Research Electronic Data Capture) which is a secure, web-based application designed exclusively to support data capture for research studies.
• Route questionnaires record information and distribute results using established procedures
• Develop utilities to perform data collection and cleaning tasks as needed including mapping data to project specifications, verification of external data to internal files, identifying data quality problems and documenting site specific issues
• Create data validation programs appropriate to clinical and statistical requirements.
• Assist with recruiting and interviewing study participants
• Updated database files and maintained study participants records.
• Provide appropriate documentation for research.
• Assists in the preparation of materials for publication.
• Regular editorial assistance in the preparation of manuscripts for publications working on Endnote and reference manager bibliographic software according to accepted practices.
• Collect and organize data from a variety of reference sources and perform preliminary analysis.
• Prepare charts, graphs and tables according to accepted research practices.
• Work with all members of the project team includes doctors, nurses, clinical investigator on a regular basis to ensure the highest quality data and utilities are produced and to ensure meeting project needs in a timely manner.
• Work with the project statisticians to create quality analyzable databases.
• Serve as liaison to clients regarding special request and operational issues as they arise.

Confidential

Dy. Manager, Market Development

Responsibilities:

• Primarily responsible for data collection, database management and analysis of the newspaper market data for the entire Eastern India with the skills on MS Access database programming.
• Advanced work needed use of MS office programs or Applications as Word, Excel, Outlook Access, and PowerPoint.
• Worked with research methods, sampling, and analytic software.
• Conceptual understanding of data storage in relational and or flat file environments.
• Provide data analysis and client support as part of team conducting outcomes and studies for media customers.
• Participated in the development of new business proposals and assisting on other on-going project work as needed.
• Work closely with project team members (Officers/Analysts, News Agencies, Retailers, Assistants, Advertisers) to complete research projects that meet clients' needs.
• Design, implement and maintenance of databases used by decision makers, stakeholders, staffs for making appropriate decisions in launching of newspapers in potential areas based on the facts.
• Research and extract data from various sources to support the development of research proposals, project analysis plans, project specifications, and client deliverables.
• This may include literature review, accessing a variety of publicly available coding systems.
• Perform data investigation on diagnostic, descriptive, and statistical output during course of research project.
• Expertise in building custom reports and monitoring of sales and trade data using Access
• Create modify and enhance Access databases reporting tool by importable table and exporting data, running reports, updating data table, develop database structures, design forms and reports and creating queries.
• Ability to create evaluation applications to describe market competitiveness and data trend using simple statistical, spreadsheet and presentation software and preparing study visit reports as required
• Competency with business process improvement methodology and flow charting software.
• Complete ad-hoc research and analytic projects to identify opportunities for continuous improvement and resulting recommendations to the supervisors.
• Create and maintain excel spreadsheets in alignment with the various business requirements
• Graphical representation of the sales & marketing data for trade meets and events and conferences
• Provide leadership to Asst Mangers and officers and design tools to assist in management of databases. This includes project coordination, development and technical support of multiple databases.
• Provides effective leadership in media industry information, benchmarks and analysis that enable organizations to manage costs, improve performance and enhance the quality of newspaper
• Collaborate and consult with higher management to analyze problems, recommend technology based solutions and design computational strategies for a wide range of newspaper promotions
• Recommend new business opportunities, new systems and processes and suggests improvements in operations
• Update research database and provide tuning and query support and optimization as needed
• Ability to analyze, interpret, synthesize and present complex market data reports effectively
• Solid judgment, sensitivity and discretion in handling confidential information effectively
• Ability to collaborate effectively with colleagues and staff particularly in support of newspaper houses goals and initiatives
• Collaborating information on product performance, market presence and brand position vis-à-vis competition with a view to fine tune sales and marketing strategies
• Study the prospective market trends for newspaper launch and provide a detail prediction of circulation forecasts in different states of India
• Ability to manage several projects simultaneously, set priorities and meet multiple deadlines
• Collaborate routinely with clients to develop prospect identification
• Design and implement segmentation strategies to uncover new prospects
• Identify new prospects using traditional and novel research technique tools using periodicals and electronic resource screening
• Create and maintain systems that directly support internal and external customers by translating business objectives into supporting technology resources.
• Draft deliverables for client presentation (reports, technical memoranda, posters, podium presentations, and manuscripts).
• Attend and present at client presentations when requested.
• Support training and orientation of new hires to Media Operations

Senior Sales Officer

Responsibilities:

• Worked with Confidential ’, chain of news agencies from different states of India and responsible for data collection, data management and data analysis of news agencies performances using Microsoft Access.
• Worked on MS office programs such as Excel, Word, Outlook and PowerPoint for variety of data management work.
• Word required familiarity with newspaper industry systems, knowledge of publishing houses research methods and work on basic statistical analysis using computer applications
• Perform data entry by updating information in a database and files and design forms to display and enter data and reports for printing.
• Graphical presentations of sales and marketing plans and circulation performances to managers using Ms-Graphs/charts
• Conducted variety of independent investigations in the planning, development and implementation of various market data
• Gather requirements from a variety of sources regarding all new development and future modifications
• Implement operational improvements approved by senior management
• Screen reader records and interview readers on different established protocols
• Collect market information and data through strategic planning, database management and distribution infrastructure for news agencies and assigned target setting for the group.
• Documentation and analyzing workflow in newspaper data processes for different regions
• Work with advertisers, Confidential ’, new agencies in support of institutional research efforts in the form of analyzing, reporting, data exploration and interpretation
• Participate in the start-up and maintenance activities related to newspaper research studies including regulatory paperwork and study budget preparation with managers to identify research procedures versus of care procedures
• Formulating and implementing sales commercial systems to provide timely feedback and structured information
• Managing statistics and data management of news performance
• Data analysis of trade promotions and competition analysis
• D.O.B