SUMMARY:

• Project Coordinator coordinating and managing multiple IT Security projects with diverse experience in Business Modeling, Document Processing, and EDI, Mapping, HIPAA Regulatory changes and Application Integration in healthcare domain. Have experience with analysis and review of software, prepare Business Requirements Document (BRD) and Functional Requirements Document (FRD).
• Experienced in gathering business requirements, JAD Sessions, Gap Analysis, UML diagrams, Process Flows, Business Documentation, Claims Processing & Testing and Claims Adjudication for Medicare and Medicaid, Data Mapping/Modeling, Trizetto Facets and Medical Billing.
• Works closely with Senior Project Manager/Program Manager to coordinate and accomplish tasks. Worked in all types of software development methodologies mostly Agile (Scrum), RUP and Waterfall.
• Highly motivated self - starter and capable of working independently.
• 7 plus years of experience as a Project Coordinator with IT knowledge and have complete knowledge on all phases of the Software Development Life Cycle (SDLC) gained in a var i e ty of d oma i ns, inclu d i ng Ba nki n g, Health care and Pharmaceutical industries.
• Maintains version control and provides administrative support for project management information system
• Experienced in performing GAP analysis, SWOT analysis, Cost benefit analysis, Risk analysis.
• Hands on experience in analyzing and documenting Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Use Cases and Requirements Traceability Matrix.
• Comprehensive knowledge on Waterfall, RUP and Agile methodologies.
• Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012s/2008R 2/2008/2005/2000 in Development, Test and Production Environments with various business domains.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent analytical skills in understanding the business process (AS-IS and TO-BE), understanding the functional requirements and translating them to system requirement specifications.
• Experienced in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions. Conducted Requirement Gathering Sessions and interviewed Subject Matter Experts, gathered detailed functionality aspects of business process and updated the information to the requirements in an easily comprehensible format
• Extensive experience in creating business process flow diagrams, UML (Unified Modeling Language) tools to create Activity, Sequence, Use Case, Class, and Collaboration diagrams
• Good understanding of testing tools, such as QTP and Test Director.
• Developed Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios in Quality Test Professional (QTP).Extensive experience in HP Quality Center, Jira and Bugzilla, Microsoft test center.
• Participated in project activities like Task Kickoff, Project Monitoring, and Project Closure etc.
• Have knowledge of Version Control, Configuration Management and Change Control procedures.
• Well experienced in working on MS Word, MS PowerPoint, MS Excel, MS Visio and MS Project
• Excellent verbal, written, interpersonal and communication skills with strong analytical abilities to perform well both independently and as a team player.
• Worked Extensively on ETL process using SSIS package.
• Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple table’s inner and outer joins, stored procedures.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS)
• In depth knowledge in Agile, Scrum, Waterfall, Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Experience working with coding schemes ICD, CPT, LO INC, NDC, SNOMED.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Updates Project status, issues/risks, next steps, accomplishment, budget etc. in Portfolio and Project Management tool on a weekly basis.
• Utilize the State’s Project Portfolio Management (PPM) tool (Changepoint) on all projects.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Experience in Credit Analysis, Credit rating calculations and redesigning the application
• Experience in the ETL (Extract, Transform and Load) of data into a data warehouse
• Experience using MSBI for data extraction, data transformation / analysis and reporting to stakeholders at different levels in the organization
• Plans and coordinates work with teams. Designs and implements project plans. Generally work with other IT managers and IT technical teams. Relies on experience and judgment to plan and accomplish goals
• Works under the direction of the project manager and reports to a project and program manager.
• Project Management Methodology (PMM) and System Engineering Methodology (SEM), based on Industry standard PMI framework and SEI’s CMMI framework.
• Has experience in OCM (organizational change management), Go-live support, including cut-over activities
• Expertise in preparing Test Strategy, defining scope and objections; Test Plan, Test Cases and Test Scripts for Manual testing, Test deliverables, Defect tracking approach and resolution, Entry and Exit criteria, Test Summary Reports, Unit Testing, Integration Testing, Regression Testing, performance testing etc.
• Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.

TECHNICAL SKILLS:

Business Analysis: Requirement Analysis, detail design, Business Rules, data flow, diagrams, Data definition table, data modeling, system integration, and team Building

Processes/Technologies: Rational Unified Process (RUP), Clear case, Use Cases, Workflow and UML

Methodology: RUP, Agile, Scrum, Waterfall, Rational Requisite Pro and Clear Quest, ASAP

Applications/Tools: Rational Rose, MS Office, MS Project, MS Visio, Remedy, Change point, Quality Center, Snow, DOORS, SQL Server Reporting Services (2000/2005/2008 R2, 2012, 2014), MS Access, MS Excel

ERP: SAP ECC 6.0

CRM: Salesforce

Database: Oracle 7.x/8i/9i, SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

Programming languages: C, C++

Operating Systems: MS-Windows 9x/NT 4.0/2000, UNIX

Applications/Tools: MS Office, MS Project, MS Visio, JIRA, LSMW, Remedy Quality Center, Snow, DOORS

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Project Coordinator / Jr. Project Manager

Responsibilities:

• Worked on EDI files 837 (Claims), 835 (Institutional, Professional and Dental) and 820 (Premium)
• Interacted with business, channel marketing team and finance team to gather requirements.
• Followed different software development models like waterfall and scrum.
• Updates Project status, issues/risks, next steps, accomplishment, budget etc. in Portfolio and Project Management tool on a weekly basis. maintains version control and provides administrative support for project management information system
• Created functional requirements document epics user stories etc.
• Communicating with developers to make sure time and budget constraints are being followed.
• Executed various SQL Queries to perform the backend testing.
• Generated reports on daily sales, product based sales, agent level sales etc through Crystal reports and SSRS
• Worked on UAT side of pharmacy/ formulary listing mobile app project for 2013.
• Worked as release coordinator. Analyzed the impacts of the project, dependency and sequence for production.
• Maintaining CMS, MED-D, HIPAA compliance. Maintaining PFI (personal financial information), PHI (personal health information) and complying other business rules specific with J&J.
• Interacted with the Business Team on continues basis, coordinated meetings with the vendor
• Provided Daily Status reports to the Business owner, Project executives & Team, Monitor and control the project without schedule slippage
• Analyzed requirements of the existing systems and suggested the improvised business process model.
• Worked on Mobile Application for member enrollment for various different groups on different operating system like Android and IOS.
• Responsible for creating GUI mock screens for Mobile App in IOS system using IPad and IPhone.
• Assigned work efforts of different tracks to the team member, mentoring the teams and resolving day to day issues.
• Involved in doing end to end testing for various functionality for Mobile Applications with IOS and Android devices like IPhone, IPAD, and Samsung.
• Worked closely with the project Managers and assisted in creating project timeline with MS Project.
• Perform Extensive EDI testing on X12/4010 837,835, 270 etc., worked with state vendor to validate inbound /outbound EDI transactions to Facets.
• Designed, analyzed and performed integration and wrote system requirements on FACETS.
• Set claims processing data for different FACETS Module.
• Interacted with the development team on regular basis to ensure and balance practicalities with innovative and efficient business systems solutions
• Works under the direction of the project manager and reports to a project and program manager.
• Extensively worked with Member/Subscriber and HIPAA Privacy Facets application groups.
• Involved in creating documents and diagrams for Membership Enrollment according to the HIPAA 834 Compliance Standards for Membership Enrollment.
• Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Enrollment, Claim Processing and Subscriber/Member module.
• Set claim processing data for different Facets Module.
• Gathered requirements and developed process flows diagrams in accordance with Medicare and Medicaid rules and regulations pertaining to the Facets configuration and evaluated the impact of proposed changes.
• Worked on Data Mapping to map Facets data to outbound eligibility extracts Conducted Gap Analysis of requirements, generated workflow process, flow charts
• Defined and documented the vision and scope of the project.
• Conducted one on one interviews with high level management team and participated in the JAD Session with the SMEs.
• Participated in weekly status meetings to present status and in corporate any digressions from the original scope.
• Carried out a thorough target organization assessment and risk and impact analysis
• Analyzed “As is” and “To be” system state to show the current and proposed functionalities of the system using MS Visio.
• Worked with the clients on the final signing process in the User Acceptance stage

Environment: s: HP Quality Center, MS Visio, Mercator, HIPAA validator, Instream, BizTalk, MS office, Serena Business Mashups (Defect Management Tool), SQL, VB script.

Confidential, Boston MA

Project Coordinator / Jr. Project Manager

Responsibilities:

• Performed requirement gathering for Incremental reporting for Asia Pacific ( APAC ) business region by actively soliciting, analysing requirements and prepared the requirements specification document for the Securities Principal DataMart application to facilitate the business expansion. Designed the business requirement collection approach based on the project scope and SDLC Methodology
• Updates Project status, issues/risks, next steps, accomplishment, budget etc. in Portfolio and Project Management tool on a weekly basis.
• Project Management Methodology (PMM) and System Engineering Methodology (SEM), based on Industry standard PMI framework and SEI’s CMMI framework. maintains version control and provides administrative support for project management information system
• Gathered requirement for consolidation of Transactions and Positions loads data of Asia Pacific business region
• Created data mapping documents, data transformation rules and maintaining data dictionary, data-migration, data mining and interface requirements documents
• Analysis of existing operations and makes recommendations for the improvement and growth of the Data Centre Infrastructure
• Performed data analysis to derive data access, data extraction and data delivery rules .
• Worked on strategies to meet the Service Level Agreement signed with the clients to deliver the reports in the stipulated time frame
• Works with stakeholders to define business and systems requirements for new technology implementations.
• Designed and created new set of daily and monthly reports for Securities Finance Tax and Compliance group for the internal business users
• Facilitated Joint Application Development ( JAD ) sessions for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy and to collaborated resource allocation and project completion.
• Developed information cycle diagrams, data flow diagrams, in Ms Visio .
• Works under the direction of the project manager and reports to a project and program manager.
• Performed extensive requirement analysis including Data analysis and Gap analysis
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work to develop prototype, Use Cases, UML diagrams for overall system that provided scope of work for technical team.
• Scheduled and lead reviews to obtain final approval from all stakeholders.
• Managed change requests by updating requirement documents as per business user feedback and changes, involved in generating test plans and test specifications as per business requirements.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Reviewed the Technical Analysis Documents to ascertain technical changes are aligned to scope the business requirements.
• Reviewed the Test cases with SQA team
• Designed and implemented SQL queries to extract data for analysis, QA Testing and Report / Data Validation using SQL Developer.

Environment: s: HP Quality Center, MS Visio, Mercator, HIPAA validator, Instream, BizTalk, MS office, Serena Business Mashups (Defect Management Tool), SQL, VB script.

Confidential

Project Coordinator

Responsibilities:

• Configures, implements, and maintains information systems/applications.
• Partners with business leaders on research, design, build, configuration and operation of niche platforms (e.g. Financial Systems, Risk Systems, Sales Tracking Systems).
• May use subject matter or functional expertise to create test cases, kick off technology business processes, and other technology configuration activities.
• Preparing, updating CCAR reports
• Project Management Methodology (PMM) and System Engineering Methodology (SEM), based on Industry standard PMI framework and SEI’s CMMI framework.
• Updates Project status, issues/risks, next steps, accomplishment, budget etc. in Portfolio and Project Management tool on a weekly basis. maintains version control and provides administrative support for project management information system
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies.
• Created Business Requirements Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers. Gathered user and business requirements through interviews, surveys and prototyping.
• Created Use Case Diagrams, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues. Implemented SOA concepts (search oriented architecture) for the application and implemented search engine based techniques.
• Helped prepare Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Modeled cash flows for securitized transactions containing wide variety of underlying asset classes. Responsible for creating proprietary Excel-based models to calculate bond waterfalls, over collaterization and interest coverage ratios, and several other portfolio criteria.
• Collected user requirements to create a technological platform to perform transaction -related asset level due diligence, analytics and cash flow modeling, structural and document review.
• Assisted developers to create a platform for compliance reporting tie-out process and to review note valuation reports prepared by CDO corporate trusts on a monthly/quarterly basis.
• Responsible for translating Business Requirement Documents into functional specifications and test plans. Closely coordinated with both users and developers for arriving at mutually acceptable solutions.
• Lead the process throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology. Utilized guidelines and artifacts of RUP to strategize the implementation of Rational Unified Process effort in different iterations and phases of software development life cycle.
• Created documents of the use cases and created the use case, activity, logical, component and deployment diagrams using MS Visio and Rational Rose to communicate clearly with the development teams.
• Redesigned web services methodology for the application while implementing reusability from different servers. Liaised with the technology team to derive Functional Requirements.
• To better define the rationale for the new process compiled Vision and Scope documents. Prepared reports for process improvements and trend analysis
• Responsible for Risk Analysis to detect the risks associated with the development of the new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
• Played a pivotal role in conducting Functional testing, Regression testing, Integration testing, Smoke testing and UAT (User Acceptance Testing)
• Regular discussions with developers to make them understand the use cases and function requirements of the client. Excellent Ecommerce applications / websites experience.
• Works under the direction of the project manager and reports to a project and program manager.
• Responsible for supervising work activities (Development, Testing) to ensure that they are well-performed, coordinated among team members and consistent with the approved work plan.
• Coordinated the design phase with the architects in improving the efficiency of the project.
• Worked with QA team in identifying test cases/test data and lead the business team for UAT.
• Documented all custom and system modification. Assigned problems to appropriate software development team for fixes. Tracked problems from start to correction and test.
• Interacted with technical team in allowing them to make a better navigational plan for the project flow which would further make a better user interactivity tool for the application.
• Signed off progress and completion reports which were then submitted to project management on a weekly basis.

Environment: Enterprise Architect 6.5, Oracle 10g, MS Project, MS office suite, Java, J2EE, JSP, HTML, JavaScript, Agile methodology (SCRUM), Rational Rose, UML, primavera, UAT, WebSphere.

Confidential, Dallas, TX

Project Coordinator

Responsibilities:

• Constantly interacted with the Product Director at Telnet for the enhancements and discussion on the changes. maintains version control and provides administrative support for project management information system
• Extensively worked on their 835 Institutional, 835 Professional, 835 Dental, 820 premium
• Analysis on the EDI file structure, for Telnet, for 835 and 820 EDI transactions.
• Constantly interacted with the Product Director at Telnet for the enhancements and discussion on the changes.
• Updates Project status, issues/risks, next steps, accomplishment, budget etc. in Portfolio and Project Management tool on a weekly basis.
• Analysis on EDI files 820 for the Telnet clearing house, which had various clients
• Created a Gap analysis on Web Native Institutional (WIN), Web Native Professional (WIP), Denial Manager, and recommended changes for the goal of providing the customers with GUI interface and customer satisfaction,
• Interacted with one of their important Client, provider Yale for the usability and current challenges that are faced usability point of view.
• Worked on 837, 270, 271, 835 Transactions
• Works under the direction of the project manager and reports to a project and program manager.
• Documented all the changes for the enhancements and recommended changes.
• Worked on the Institutional and Professional Claims, Design of the real time transaction
• Created screen mockups and wire frames for prototypes for the applications of the different products.
• Analyzed the current state and provided recommendations for the future state of the products.
• Documented the Screen inventory of the products and analyzed the best go forward approach
• Created Visio Diagrams for the entire architecture

Environment: MS Office Tools, Windows XP, MS Project, Quick Test Pro, Requisite Pro, MS Visio, Clear Case, Visual Studio, MS-SharePoint

Confidential

Project Coordinator

Responsibilities:

• Implemented the importation and exportation of data using XML and deployed robust IBM DB2 stored procedures and functions to increase cost savings and reduce resource utilization
• Mapped and created relational logical and physical data models from multiple external systems for effective data warehousing which reduced data retrieval time by almost 80%
• Participated in user meetings, gathered business requirements & specifications for the Data- warehouse design
• Designed ETL architecture to process large number of files and created high level design
• Mentored and led a team of three associates to implement end-to-end delivery of SDLC, including establishing deliverable scope, maintaining high output quality and ensuring customer satisfaction
• Managed customer relationships and services in a global delivery model and assisted clients in making data driven solutions to solve business problems
• Setting up environments to be used for testing and the range of functionalities to be tested as per technical specifications
• Responsible for different Data mapping activities source systems to Teradata
• Coordinated in the database changes needed for the front-end development team, explained and guided them on the database architecture and objects for effectively assessing the database
• Identified database inconsistencies like duplicate objects and coordinating with various teams to decide on the appropriate action to be taken
• Updates Project status, issues/risks, next steps, accomplishment, budget etc. in Portfolio and Project Management tool on a weekly basis.
• Worked extensively on SQL querying using joins, Alias, Functions, Triggers and Indexes
• Generated SQL scripts and deployed databases including installation and configuration
• Participated in walk-throughs, inspections, reviews and user group meetings for quality assurances
• Hands on experience in SDLC, involved in various phases like requirements, Analysis design, Development and testing

Environment: SQL server 2008/2012 and mainframes, Kanban, Agile Methodology, MS Office (Word, Excel, Access, PowerPoint, Visio Outlook), SSIS, SSRS.

Confidential

Credit / Compliance Analyst

Responsibilities:

• Verifies all aspects of Client Identification Program (CIP) and necessary account opening documents are provided and in accordance with know Your Customer (KYC) and Bank Secrecy Act (BSA) standards.
• Completes extensive due diligence investigations using public and private databases in accordance with Anti-Money Laundering (AML), BSA and other regulatory standards to assist business units and prevent operational and reputational risks.
• Conducts enhanced due diligence research in attempts to find derogatory/background information used to aid client advisors' decisions in initiating, maintaining or closing business relationships.
• Performed thorough, in depth risk assessment to determine borrower's credit worthiness and ability for repayment.
• Analyzed tax returns, credit reports, for red flags and fraud detection. Also reviewed information and related documentation to ensure compliance with credit union policy and procedures.
• Performed verifications (deposits, employment and rent/mortgage) and calculations (income) per client stipulations.
• Updates Project status, issues/risks, next steps, accomplishment, budget etc. in Portfolio and Project Management tool on a weekly basis.
• Streamlined operations by running daily reports versus weekly, which improved visibility of transactions and helped ensure compliance was maintained at all times.
• Performed income verification analyzing irregularities, and monitored for fraudulent documentation.
• Responsible for reviewing new account applications, gathering credit references and determining if a credit line will be offered to the customer
• Evaluate payment plans and determine whether proposals meet both customer and company needs
• Recommend proposals to management if they meet company guidelines and satisfy both customer and company
• Determine the long-term needs of the customer and manage product distribution based on these needs

Confidential

Sr. Relationship Officer

Responsibilities:

• Processed Mortgage, Home, Commercial and Personal loans with 0% errors and accurately disbursed within Turn-around-Time (TAT) by ensured the National Electronic Funds Transfer (NEFT), Real Time Gross Settlement (RTGS) and cheque payments made to customers within set time frame with 100% accuracy.
• Partnered with Service Manager on completing control tasks on a timely manner. Performed daily and monthly audits on all cash vaults and ATMs
• Promoting all direct bank channels and ensuring customer is utilizing the same.
• Handled walk-in customers, resolved customer complaints on multiple queries, escalations, feedbacks, foreclosure of loans.
• Provided expert financial advice on mortgage and both educational and personal loans.
• Ensured optimal level of Income generating Product Group Holding (IPGH) is exceeded.
• Ensure that individual customers are grouped and Customer to Group (CTG) ratio is maintained on the portfolio.
• Regular contact is maintained with all portfolio customers to generate business.
• Ensuring that customer make HDFC as their primary bank.
• Used profiling analysis tools to identify cross sell opportunities and makes outbound sales calls typically by phone to increase product per customer ratio
• Ensure that the marketing analytics list on possible attrite, is called and retained.
• Ensure that the bench-mark sales per day is met.
• Secured accurate processing of data and assessing completeness and accuracy of reports on customer data, credit score, loan eligibility, pending documents, loan disbursement.

Confidential

Sr. Personal Banker

Responsibilities:

• Planned and executed comprehensive sales development strategy to successfully ignite growth and profits by promoting the sales of Retail Banking Products of ICICI like (Demat Trading Accounts / Savings Accounts / Fixed Deposits / Loans / Insurance Products) for individual customers.
• Identified and made sales referrals to commercial business, recommended alternative channels, cross-selling, banking services and products for Confidential partners.
• Maintained, acquired and developed banking relationships for over 200 premier business clients growing balances and increasing profits by improving cash.
• Delivered basic product training, security and operational procedures to new employees.
• Reviewed, managed and reduced miscellaneous losses and teller differences from 98% to 47%.
• Ensured smooth functioning of the system and eliminated the bottlenecks in the standard operating procedures by worked closely with the Business Development Unit.