Project Manager Sales
Resume:
NISHTHA JAIN
*** ****** **. *** #*** Ridley Park PA 19078
Email: *************@*****.*** Mobile: 703-***-****
RELEVANT TECHNICAL SKILLS
SQL skills: SQL developer, Toad, SQL loader, SQL Plus, OraLoader, SAS, Insight, MS Excel- Pivot Tables
and Vlookups, MS Project, MS Visio, SQL, Teradata, AQT, IMS system, WK system
Languages- C, C++, Java, HTML
Databases- SQL, DB2, MS Access, Oracle
Dashboard and Cloud Experience– Confluence, JIRA, Sales force, ACT, Magento, Netsuite, Trac
Methodologies – Sequential and Iterative methodologies such as Kanban, Agile, Waterfall model, UML,
Business and data modeling
Operating System- Windows, Unix, Macintosh
Product Skills: Rollout of software product, product Campaigning, product manuals, Managing product
meetings
Marketing Skills- Market Research, Market analysis, Competitor Analysis, Marketing Strategy,
Designing marketing materials such as promotional flyers, booth, Email blasts, Market campaigning, e-
Marketing, Lead generation, Trend analysis
Software skills- SQL Server Management Studio, End notes, Webpage Interface Designing, Website
designing, Adobe Photoshop, adobe In design, Microsoft SharePoint, Illustrator, Dreamweaver
Business Skills- Client Relations, Quote Generation, Project Management, Writing user Stories, Vendor
Management, Scrum meetings, user stories, use cases, cross functional teams management
Finance - Budgeting and pricing analysis, Budget planning, Investment stock portfolio analysis,
Financial analysis, Balance sheets, Sales analysis
Documentation- Product manuals documentation, Journal editing and proof reading, Editing business
documents, formatting and editing government and commercial proposals, Designed Phase I SBIR and SBA,
laboratory SOP’s
WORK EXPERIENCE
AILERON SOLUTIONS LLC, CONSHOHOCKEN, PA
January 2014- Present
Healthcare/ Marketing Data Analyst
Ensures the accuracy and integrity of databases.
Analyzes and identifies anomalies within claims database systems, resolving both routine and complex data
issues.
Designs and defines the “data package” including technical requirements for dataset definitions, data
validation, data extraction, transformation and integration.
Load data into oracle/ production database using SQL loader. Excel at loading data from FLAT files (such as
space delimited, pipe delimited, comma separated, tab delimited etc.) and other databases.
Creating data table and indexing them
Write/design SQL queries to execute complex analysis and Quality control on the data
Creates a standard process for data feed that are received, analyzing the data and running QC checks on the
data( claims data- both facility and hospital level claims)
Recognizes market trends within the data, allowing for a proactive communication approach to internal and
external clients.
Implementation of quality control measures, procedures and tools will be necessary in this role
Identifies and implements methodologies to circumvent repetitive issues, which occur within the work
structure.
Involved in creating new and updating existing analytical programs and tools.
Develops or modifies moderately complex information systems.
Involved in detailed Gap Analysis & high level solution, wherein data business requirements were identified,
to be incorporated into the different business modules respectively
INDEPENDENCE BLUE CROSS (PRINCETON INFORMATION), Philadelphia, PA
September 2013- December 2013
Senior Business Data Analyst/ PM
Implemented new products and system enhancements by providing data and recommendations to assist in
evaluating the impact of the proposed benefit, system or process changes.
Performed complex analysis of the data (inpatient and outpatient claims for specific ICD9 proc codes) for
defective medical device recall.
Worked extensively on 837(I) claims processing systems.
Researched, analyzed and interpreted qualitative and statistical data and provides technical assistance to other
staff, departments and stakeholders.
Identified issues to be researched, determining affected areas, estimating the impact and leading the
resolution.
Used advanced data analysis methods by writing complex SQL queries to perform and manage complex
analysis of quantitative and qualitative data.
Implemented best practices in survey development, multivariate statistical modeling, and/or thematic analysis
of qualitative data using AQT.
Interpreted the financial impact of decisions made by retrieving and analyzing claim costs, revenue and/or
other relevant data using SAS and Teradata
Independently managed the retrieval and analysis of data, and issues that may arise on multiple tasks or
projects with limited management involvement.
Acted as a resource for other members of the department/division on business issues and may be responsible
for training and guidance of other employees.
DR. FIRST INC., Rockville, MD, December 2012- September 2013
Business Data Analyst/ Project Manager, Patient Innovations (Healthcare- IT)
Imported, cleaned, transformed, validated or modeled data with the purpose of understanding or making
conclusions from the data for business decisions and client market campaigning ( data is drug data and patient’s
claim data)
Ad hoc reporting querying DrFirst and client databases using SQL for product campaign execution and
revenue generation
Write SQL queries for conducting specific analysis
Assured quality of new product/ software application by testing for bugs and error and reporting them
Ran marketing campaigns for the new product i.e the toolbar by acting as a liaison between the sales team,
marketing team, enterprise group, partners group, product team and DBA team
Worked with manager, other team members, and/or other partners, to continuously review departmental
processes, procedures, tools and other resources to ensure best practices, optimal efficiencies and effectiveness
across the team and department
Effectively implemented HIPAA compliant procedures in the workflow
Knowledge of ICD-9, ICD-10, LOINC, SNOWMED codes and understanding of patients claim data
Drove the product rollout in cert and production environments for specific user application
Analyzed marketing trends and drug data and NPI data to address issues based on understanding of current
business needs
Maintained functional expertise for web analytics, database analytics and tools in best practice.
Worked closely with marketing team to develop marketing materials such as FAQ, training materials and
videos for the partners and end users and wrote product documentation
Involved with gathering business requirements and convert them into business stories and then conduct scrum
meeting to write them
Responsible for account management of PI vendors and clients
Recommended data strategies and marketing tactics on basis of analysis outcomes.
ADVANCED BIOSCIENCES LABORATORIES, INC., Rockville, MD, June 2012- November 2012
Marketing/ Project Manager(CRO/CMO/Biotechnology)
Identified unique product opportunities with ABL’s catalog sales, analyzed markets, technologies and
the competitive landscape
Implemented highly effective marketing campaign for online catalog of ABL product sales and
promotion
Created marketing materials such as flyers and marketing packets for sales force team and client
visits
Drove up sales by designing and launching new marketing strategy for catalog products.
Successfully carried out emails blasts as a part of marketing campaign using salesforce.com which
increased the sales and flow of orders
Updated the website catalog and gave it a fresh look by making it more user friendly
Successfully implemented first price change for product line in last two years by doing extensive
market analysis and budgeting and making annual sales and revenue projections
Successfully maintained conference database which immensely helped in planning
budget and short-listing conferences to exhibit
Received and fulfilled all incoming catalog orders via phone, website and fax to include
organizing and tracking shipment and deliver quotes to clients and maintain client relationships
Edited and formatted government and commercial proposals using endnotes software
TISSUE GENE INC., Rockville, MD, December 2011-May 2012
Marketing Research Specialist (Biotechnology)
Conducted market research for the worldwide orthopedic market for the marketing campaign
Updated market analysis and competitor analysis for each of the company's product candidates
Compiled, edited and documented marketing profiles for the competitors
Assisted in the development of market strategy for two products to effectively penetrate their respective
markets
Collaborated with team’s director in proposing indications for potential buyers
Assisted the business in judging the possibility of entering an agreement, undertaking a project, purchasing
or advertising assets or planning growth etc. Help the business take sound decision
Maintained the research database, renew and improve it from time to time and make sure safe storage
Prepared and delivered various internal business presentations
MC DONOUGH BUSINESS SCHOOL, Washington DC, August 2011- May 2012
Marketing Research Data Analyst (Business and Research)
Compiled, classified, tabulated, and recorded data collected from special studies and analyze research
material using online data, library resources, Factiva, journals, etc.
Copy edited journals and proofread the data that has been researched
Formulated and followed various research quality and control procedures
Collaborated with professor and facilitate in preparation of presentations, manuscripts and project related
topics
BIOMERIEUX, New Delhi, India, January 2011-July 2011
Business Analyst (Biotechnology)
Lead and formulate systems scope and objectives relative to system and development requirements
Conduct analysis and working proactively with business clients to identify and define IT / Business system
initiatives and optimization opportunities;
Formulate and define system opportunities through research and fact-finding combined with an understanding
of applicable business processes, systems, and industry requirements
Facilitate consultative-type interviews and cross-functional workshops to clearly define IT projects, including
product scope, objectives, costs, benefits, risks, functional requirements, technical requirements,
resource/skill requirements, and deliverables.
Lead the requirements gathering for identity preservation systems development
Develop business use cases and detailed business, functional and Technical requirements
ACCENTURE, Bangalore, India, July 2009- December 2010
Associate Software Engineer, Client- Healthcare Insurance Company (US BASED)
Developed, delivered and managed technology-based business solutions to their clients across industry
sectors
Designed software applications to meet both functional and technical requirements
Provided project management support and participated in training program in Java, UNIX, SQL, HTML,
C++, C as well as Project Management foundations
Gained basic understanding of SDLC (Software Development Lifecycle)
Effectively lead analytical projects by coordinating all stages of the development life cycle.
Effectively lead analytical projects by coordinating all stages of the development life cycle.
Supported the development of effective management programs.
Developed and implemented plans to measure and report on corporate-wide health care delivery cost and
utilization trends.
Manned for adhoc analytics including modeling of benefit scenarios using SAS and SQL
Created and presented analyses of complex data projects explaining trends.
Provided technical support, training and guidance to application end users.
SIR GANGA RAM HOSPITAL, New Delhi, Janrary 2009- June 2009
Data Management / Specialist (Healthcare- Hospital)
Conducted and prepared medical budget to actual analysis.
Manned for ad hoc analytics including modeling of benefit scenarios.
Worked effectively as data expert for department.
Supporting and maintained corporate initiatives and projects that require analysis of health plan data.
EDUCATION
Georgetown University, Washington DC, May 2012
Masters of Science in Biotechnology (MS), GPA: 3.38/4.0
Amity University, Amity Institute of Biotechnology, India, June 2010
Bachelors of Technology in Biotechnology (B. Tech), GPA: 3.84/4.0
Contact this candidate