Manager Project
Resume:
Mamta Yerram
734-***-**** + *************@*****.***
___________________________________________________________________________
_________
Summary of Qualifications
V Certified Epic Professional with experience in full implementation
lifecycle of an inpatient EMR
V Over 10 years of professional experience in all phases of software
development lifecycle, from gathering requirements to testing,
implementation and support, mainly in the field of Epic Application,
Business Intelligence and Data Warehousing
V In depth knowledge of hospital operations in a multi facility health
system
V Leadership Activities - Assign appropriate resources, mentor and train
new inpatient report writers and programmers on the team
V Acted as liaison between the medical informatics and various
inpatient/HOV departments - Neuro Oncology, Nuclear Medicine and
Dialysis
V Ability to provide technical solutions that satisfies Epic end users
by identifying risks and opportunities for Epic Model system
enhancements
V Identify potential issues and communicate them to the senior
management
V Closely work with Inpatient/HOV Manager, Senior management (director
and AVP), hospital quality department and clinics to provide
appropriate support to end users
V Assist Inpatient manager in planning projects and resources
V Technical Project Manager for implementing Inpatient/HOD Reporting
Workbench - Lead analysis, project plan and implementation
V Technical lead for various Inpatient Projects - Device Integration,
OBIX, LDA flowsheets
V Experience in various reporting tools - Reporting Workbench, Clarity
and MyEpic Administrations
V Expert in configuring Epic functionality for various Inpatient
departments
V Data Warehousing ETL experience using Informatica Power Center
7.1/6.2/5.1, Power Mart expert level skills in developing strategies
for extraction, transformation and loading mechanism.
V Extensive experience in Relational Database Systems designs like
Oracle, SQL Server, MS Access; Multi dimensional application and
database development experience with SQL, SQL PLUS and Stored
procedures.
V Team player with excellent communication and problem solving skills
EPIC CERTIFICATIONS
> Inpatient Clarity Data Model - Spring 08
> Reporting Workbench Report Writer Administration - Summer 09
> Chronicles Programming - Spring 08
> Chronicles Install Utilities - Spring 08
> Hyperspace Configuration - Spring 08
> MyEpic Administration - Summer 09 (Trained)
> Clinical Decision Support Masters - Summer 09
(Trained)
TECHNICAL SKILLS
Databases: DB2, Oracle, SQL Server, Oracle 8i, 9i, MS-Access
Data Modeling: Erwin 3.1, 3.5.2, ER Studio (Star Schema Modeling,
Snowflake Modeling)
ETL Tools: Informatica Power Center 8.5//7.1/6.2/5.1, Power Exchange, and
Informatica Power Mart
Business Intelligence Tools: Microstrategy 7.5, Cognos, Crystal 10, 2008
Testing Tools: Mercury Quality Center/Test Director 8.0
Programming Languages: Mumps programming, C/C++, SQL *Plus, PL/SQL, SQL
*Loader, XML, HTML, UNIX shell scripting, TOAD,
Embarcadero Rapid SQL 7.3
Operating Systems: Windows 9x/NT/2000, UNIX (Solaris, Linux)
Education Masters in Computer Applications - graduated 2002
Masters in Science - graduated in 2010
National Institute of Information Technology
PROFESSIONAL EXPERIENCE
Northshore University Healthsystem, Chicago, IL
Aug ' 08 - present
Sr. Programmer Analyst - Epic Inpatient/HOV Team
Responsibilities:
. Inpatient/Outpatient Analyst
. Technical lead for implementing biomedical device integration
with Epic. Used vendors - GE and Philips
. Inpatient Lead for Meaningful Use reporting
. Technical Lead for implementing OBIX device integration for
fetal monitoring system for Labor and Delivery units
. Participated in full lifecycle implementation of a new hospital
. Create CPOE Orders - create order sets, Navigators
. Configure various Patient Summary reports - print groups, used
print group encyclopedia on epic userweb
. Expert in various Epic build- smart forms, smart text, smart
phrases
. Expert in configuring PAF columns using the custom code
. Clinical Documentation - build flowsheets, resource for
implementing LDA flowsheet rows
. Knowledge of configuring menus and controlling the security
based on various user roles
. Provide weekly on-call schedule support for four different
hospitals
. Technical Lead for implementing Reporting Workbench
. Lead 10+ RWB report writers in various Epic modules- Inpatient,
Ambulatory, PB, ADT
. Implemented reporting workbench for inpatient by analyzing the
reporting need of various inpatient units
. Very enthusiastic participation in establishing the overall
infrastructure of RWB by co-ordinating with senior management
and reporting steering committee.
. Developed various RWB reports to monitor the daily documentation
compliance to meet Hospital Quality
. Well versed in setting up the infrastructure of RWB - report
Queues, various RWB security classes
. standardize the reporting process across the organization -
developed report design spec., design development, migration and
change control
. Maintain RWB report library on Share Point site
. Through knowledge in working with report templates, query
templates, report models, report parameters, report mover
. Conduct weekly RWB report writer meetings for peer review
. Clarity Report Development
. Inpatient technical lead for Meaningful Use Reporting
. Involve in Decision Support meetings for Meaningful use and
evaluate the current workflows to meet the need of Meaningful
use of her
. Analyze the current workflows and modify the build to make sure
the data is captured discretely for reporting purposes
. Developed Inpatient flowsheet documentation compliance reports
for Meaningful use
. Developed and maintained various clinical reports based on the
data stored in clarity and chronicles
. Proficient in using SQL queries and Stored procedures to
incorporate complex logic into reports like filtering, sorting
or calculations
. Used sub reports and parameters
. Chronicles/Cache Programmer
. Ad-hoc reporting - well versed in Chronicle searches
. Workflow Engine (UCW) rules - configure UCW rules to modify the
workspace of users
. Order Transmittal - setup order transmittal rules and mapping
for various new department builds
. Developed custom programming code to enhance the Epic Model
System functionality
. Decision Support - Analyze the reporting need for Hospital
Quality
. Patient Station - maintain inpatient patient station
. Import/ Export records to masterfiles
. ETAN - migrate printgroups and reports across the environments
during upgrades
. Clear Patient locks, device locks, print queues - user support
during programmer on-call
Environment: Epic Spring '08, Epic Summer '09, Oracle 10g, Crystal 10,
Crystal 2008, UNIX, Share Point, Ms-Visio, Ms-Project
T-Systems of North America, Auburn Hills, MI
Jun '07 - Jul '08
ETL Technical Lead
Responsibilities:
. Develop high level approach from business requirements and prepare
comprehensive technical documents
. Experienced in using different sources - relational tables, flat
files, XML files, .csv files and Excel spread sheets
. Determine the job scheduling and prepare documentation for the job
scheduling team to set up the new ETL jobs
. Unit Testing - Identify the test cases fro different business
scenarios and ensure that individual units of source code are working
properly
. Use SQL queries to build the test cases
. Assist QA team with data preparation, TCM preparation
. Provided valuable insights into the project as Subject Matter Expert
. Interacted with Business users for any clarifications on the business
requirements
. Co-ordinate with off-shore technical lead as needed
. Performed Integration testing
. Provide on-call support to production system to resolve any issues
. Work with developers, DBAs and system support personnel in automating
successful code to production
. Involved in System Design, Development and Integration phases of the
project
. Involved in system integration testing (between the SQL and ETL parts)
. Follow the procedures - designing document, high level diagrams,
implementation and unit testing
. Involved in data set up for QA environment
. Helped the junior ETL Developers and QA testers
Environment: Informatica PowerCenter 8.5, Power Exchange 5.2.2, Windows NT,
UNIX, Oracle 9i, TOAD 8.0.
Blue Cross Blue Shield of Michigan, Detroit, MI
Jul '06 - Apr '07
Sr. Informatica Developer
Responsibilities:
. Expert using Power Exchange and Change Data Capture process
. Used Informatica repository manager to backup and migrate metadata in
Development, Test and Production systems.
. Tuned existing code, by partitioning the sources, optimizing the SQL
query in Source Qualifier and Lookup transformations, rearranging jobs
in the schedule based on dependencies, rearranging sessions in the
workflow to improve session performance.
. Developed Informatica mappings incorporating the business rules using
various transformation objects and the Informatica transformation
language.
. Created complex ETL jobs as per the business requirements
. Supported on various test cycles like Integration, System and User
acceptance tests
. Attended business user sessions to request/validate the enhancements
for the current project.
. Provided feedback and recommendations to various teams on a database/
data warehouse Perspective
. Created mappings to generate the statistics for the dataflow and also
email notification when a particular load doesn't meet the SLA.
. Performed code migrations as part of weekly/monthly Change request
releases.
. Determined appropriate action by referencing defined operating
policies and procedures and using proven approaches.
Environment: Informatica PowerCenter 7.1.3, Power Exchange 5.2.2, Windows
NT, UNIX, Oracle 10g, DB2, TOAD 8.0.
Volkswagen of America, Auburn Hills, MI
Jun '05 - July '06
Informatica Consultant
Responsibilities
. Created Process and Technical Design Documents for the mappings that
are built to load data from Oracle tables to fixed width flat files
and to purge the Database tables.
. Implemented parameter variables in the mappings.
. Worked on data sources such as Oracle and flat files.
. Performed the troubleshooting when the workflows failed in loading the
data.
. Created different transformations such as Source Qualifier,
Expression, Joiner, Aggregator, Lookups, Filters, Stored Procedure,
Update Strategy and Sequence Generator.
. Performed the Coding, Unit Testing, System Testing and Integration
Testing for the individual components of the project.
. Used Test Director to report the defects during the System Testing and
Integration testing
. Involved with QA people in developing the test cases.
Environment: Informatica PowerCenter 7.1.3, Power Exchange 5.2.2, Test
Director 8.0, Windows NT, UNIX, Oracle 10g, TOAD 8.0.
Company : Excellent It Solutions, Troy, Michigan
Jan '03 - May '05
Data Warehouse Developer/Analyst
Clients : AIG Insurance, New York; Americhoice Health Services Inc.,
New York
Responsibilities
. Worked along with the Business Analysts for requirements gathering,
business analysis, and testing and project coordination.
. Written Test scripts and Test cases for testing and enhancements which
were used by QA for unit testing and integration testing.
. Involved in designing the data model using ERWIN and generated the DDL
for DBA to implement the tables in the development and production
environment.
. Maintained the repository, created users, user groups and security
access control using Informatica Repository Manager.
. Performance tuning of the ETL - by utilizing dynamic cache for
Lookups partitioning the sessions.Check and Tune the performance of
application for optimum system performance.
. Maintain and enhance the application to meet all the required business
needs, mainly to optimize the supply vendors cost.
. Studied the existing environment and accumulating the requirements by
querying the Clients on various aspects.
Environment: Informatica Power Center 6.2, Oracle 9i, SQL, PL/SQL, TOAD.
Fobahn Technologies, India
May '00 -
Dec '03
Datawarehouse Developer
Responsibilities
. Loading data to oracle data file from flat files using SQL*Loader.
Generated schema and enforced the security rules. Developed Crystal
reports.
. Created database in optimal flexible architecture.
. Tuned the SQL queries with EXPLAIN PLAN and SQL Trace.
. Created users, granting roles, privileges, quota to users.
. Developed scripts for creating of database, tablespaces, rollback
segments, schema objects tables/views, sequences, indexes, synonyms,
referential integrity constraints, roles/profiles,
procedures/packages/triggers.
Environment: Oracle 7.x, PL/SQL, SQL*Plus, Export, Import, SQL*Loader,
SUN
Solaris, Windows NT
Contact this candidate