SUMMARY:

• 6 years of IT experience Healthcare, Financial and Banking domains for designing, Data analysis and Data Models, implementation and maintenance of project standard with databases and data warehousing environments.
• Working experience as a Data modeler and Data Analyst and Business Analyst with good proficiency in OLTP, OLAP and ETL Environment. 
• Excellent experience in delivering Quality Conceptual, Logical and Physical Data models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Proficient in designing star & snowflake schemes as per BRD’s. 
• knowledge Master Data Management (MDM) and generating reports from it.
• Comprehensive knowledge and experience in process improvement Normalization/de - normalization.
• Experienced on R programming for Statistical analysis and data visualization..
• Expertise in documenting Business Requirements Document (BRD), Project Requirement Document (PDD), Functional specification document (FSD).
• Developed Risk Analysis Reports and RACI matrix for various risk domains.
• Interacting and Interviewing with Stakeholders for business requirement gatherings.
• Expertise in generating GAP analysis and UML diagrams.
• Experience in doing Risk Analysis and Risk Management, Impact Analysis and Change Management, Resource Planning, Gantt charts, SWOT and Cost Analysis.
• Experience in working with JIRA, Ticketing system., a project management tool to manage the scrum process of development.
• Generated Governance and oversight framework documents for Data governance and quality process.
• Worked on Data Standards, Data Definitions with key structural breakdown.
• Good knowledge on USFDA, WHO, ISO, HIPAA, 21 CFR part 11.
• Exposure on BCBS 239 regulations, Banking guidelines.
• Hands on experience for reviewing and analyzing the Electronic Health Records (EHR).
• Generating the UAT Test Plans, maintaining the Traceability Matrix and assisting in Post Implementation activities.
• Experience on Data profiling, Data Analysis, Data Cleansing and Data Governance.
• Experienced in running ETL job scripts.
• Proficient on SQL Server, ORACLE, Microsoft CRM, Dynamics AX other relational and non-relational databases.
• Experienced in SQL.DML Functions, Indexes, Triggers, Materialized views.
• Worked in various environments like Ab initio, Informatica, ERWIN, Sybase power designer.
• Developed project plans and data process flow with Microsoft Visio and Microsoft Project.
• Generated dashboard reports from as a Salesforce, QlikView.
• Excellent problem solving and analytical skills with a proven ability to learn and understand new technologies efficiently. 
• Effective team worker and can carry out individual tasks to meet the deadlines effectively. 
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), AGILE and WATER FALL Methodologies.

TECHNICAL SKILLS:

RDBMS: Oracle 11g, Microsoft SQL Server14.0, Teradata R15, Microsoft CRM MS Access and SAP(MM).

Tools: Erwin 9.6, Sybase 14.0, Ab initio 3.1, Collibra 5.0, R 3.1, JIRA.

Data Specialties: Data Analysis, Data cleansing, system Analyst, Enterprise Data, Design and Modeling, Data extraction, ETL Job reports.

Reporting Tools: Tableau8.2, Qlickview, Salesforce.

MS Office Tools: Excel, Access, Word, PowerPoint, Project, Visio.

Languages: PL/SQL.  

Operating Systems: Windows 10/7/ XP.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC     

System Analyst/Data Modeler

Responsibilities:

• Involved in data quality and data governance for the line of business.
• Participated in creating conceptual and physical modelling with ERWIN for the flow of data.
• Created Business required documents(BRD’s), Project definition documents(PDD’s) to streamline the project value.
• Produced project plan and roadshow documents for project execution.
• Used Referential data and transactional data for generating the Ad-hoc reports and executed the weekly reports.
• Designed slowly changing dimensions(SCD’s) for various line of business to maintain data transparency.
• Supported Master Data applications from different legacy systems using Ab initio MDM.
•   Worked for requirements gathering and solution architecture for MDM initiatives. 
• Worked on Logical, physical and conceptual data modelling.
• Reviewing Metadata documents produced by other teammates, checking compliance with Data Owners and stewards.
• Interviewing Stakeholders for preparing BRD and FSD and interaction with architects to understand the high level key decomposition and data flow development.
• Used Collibra tool for data governance to maintain Data dictionary, Reference data, catalog, policies.
• Generated Risk reports and RACI matrix for the Referential data.
• Designed Data marts through ERWIN from Kimball’s Methodology.
• Involved in designing SNOWFLAKE schemas in OLTP.
• Designed Data sets from source data and metadata. Used Ab initio software for generating metadata reports.
• Proficient in writing SQL queries, generating triggers, execution of DML functions and creating indexes on data.

Environment: Erwin9.6, PL/SQL, Ab initio, Collibra 5, Teradata15.4, Office 2013.

Confidential, Eagan, MN    

Data modeler

Responsibilities:

• Involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Database triggers, Materialized views, Views) for data model.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata. 
• Designed different type of STAR and snowflake schemas with Sybase power designer.
• Defined and processed the facts, dimensions. Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Worked with Oracle in a multi environment.
• Involved in Data quality and governance for making raw data take to legal data.
• Worked on forward and reverse engineering by maintaining data standards.
• Implemented slowly changing dimension methodologies, for the creation of ad-hoc reports.
• Design Data models for development of new transactional systems.
• Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data Definitions and Data Dictionary.
• Enforced referential integrity in the OLTP model for consistent relationship between tables and efficient database design.
• Worked under Agile Methodology with Kanban system for closing the tickets raised during maintenance.
• Reviewed various BRD’s and FSD’s for designing the business models.

Environment: Sybase power designer 14.0, Informatica, Office 13, Tableau.

Confidential

Technical Business Analyst

Responsibilities:

• Generated business product based analysis documents for clients.
• Involved in process of preparing documents for technical, client interaction and logistics.
• Prepared product based cost analysis document to the management.
• Used ‘R’ For graphical statistical interference of data.
• Worked in reviewing and presenting document on USFDA, ISO guidelines for client interaction.
• Organized technical Meetings with clients and technical people.
• Generated Reports from Microsoft CRM and Microsoft AX.
• Involved in Data cleansing for normalizing the data in database.
• Created Client data in Microsoft CRM database.
• Prepared Non-Functional documents as per technical specifications of clients.
• Generated Invoices, Purchase orders and client site specification documents.
• Produced Change management policy documents as per guidelines to develop company business requirements.
• Created Gantt Charts, CHARTER and Pivot tables.
• Generated GAP analysis, Risk and Impact assessments for the process flow.
• Organized Scrum Meetings, quarterly JAD sessions.

Environment: Microsoft CRM, Microsoft Dynamics AX, Office7.

Confidential

Quality Systems Analyst

Responsibilities:

• Involved in implementation / remediation of Quality Systems, to comply with cGMP and achieve business expectations / organization goals, with balanced approach.
• Active member in up gradation of plant documentation to corporate quality requirements.
• Reviewing BMR’s, MMR’s and providing GAP analysis for product manufacturing process and Quality systems.
• Responsible for preparations of Standard Operating Procedures (SOP), process validation, protocol reports.
• Giving approvals for the documents in SAP environment through QMS
• Responsible for filling of customer’s questionnaire.
• Involved in preparing Change management documents (CMD), Risk assessments and process flow diagrams with Microsoft Visio.
• Involved in providing GAP analysis for various product based documents.