SUMMARY:

• Skilled in Business Systems Analysis, Product Management, Project Delivery, Information Architecture, Data Modeling, Enterprise Data Architecture, Data Quality, Master Data Management, Data Governance Framework, Organizational Risk, Regulatory Compliance, Business Intelligence, Data Warehousing, Data flow analysis, Process flow analysis and mapping, Data Profiling, Data Modeling, development using ETL & BI tools and technologies, development of business metrics & KPIs, Data Quality Metrics, Source - to-Target mapping, source system analysis, suggesting solutions to complex and large data system problems.
• Strong interpersonal, coaching, mentoring, team management, release and delivery management skills.
• Proficient in delivering using Agile as well as Waterfall methodologies.
• Passionate about developing synergies between business and technology.
• Strong analytical ability, problem solving ability, presentation and communication Skills.
• Strong techno-functional experience across Genomics, Bioinformatics, Bio-banking, Clinical Research, Pharmaceuticals, Aviation, Oil & Gas, Manufacturing, Banking & Finance and Healthcare Insurance domains, in working with complex data environments, Data warehousing/Business Intelligence methodologies, tools & technologies.
• Six Sigma Rigor and Deployment in Software (DMADV, DMAIC). Six Sigma Green Belt Certified
• Asserting enterprise wide best practices in systems integration, BI, Data warehousing and data management.
• Stakeholder management, backlog management, requirement prioritization.
• Leading and directing user meetings at all levels (Mid-senior, Senior as well as corporate level) for scoping, gathering and collation of requirements.
• Leading and directing technology teams for testing, development and post production support.
• Data Acquisition, collation, Information dissemination and access strategy.
• Enterprise wide Data Governance, Data Modeling (ER Studio®, ERWin), Data Architecture, Data Management, Information Management and Analytics delivery.
• Design, development, testing, deployment and post-delivery support.
• Data Quality and Master Data Management. Source System Analysis and ETL strategy, data movement, staging, cleansing and conforming strategy.
• Business Analysis, Dataflow analysis, BI Business Analysis, Data Profiling, Information Flow analysis, System analysis, Source Systems Analysis, Data Analysis, Feasibility Analysis.
• Strong in architecting and implementing BI and ETL Frameworks. In depth understanding of relational and multidimensional database architecture.
• Requirements management using TFS, Azure DevOps, Trello, Jira.
• SQL, RDBMS, MDDB (Oracle, Teradata, MS SQL Server), Source-to-Target Mapping.
• Data formats and standards like XML, JSON, TSV, GFF3, VCF
• Creating Technical Specifications from Business/Functional requirement and Traceability Matrix.
• Quality processes, quality assurance, CMM, Software Development Life Cycle (SDLC) and Agile methodologies.
• Good mentoring, coaching, presentation, verbal and written communication skills.
• Currently working as Sr Business Systems Analyst with Confidential ’s Center for Individualized Medicine (CIM) working closely with researchers, bioinformaticians and genetic counselors to effectively bridge the biology-technology divide.
• Have worked as Sr BI/Reporting Business Systems Consultant in Pharma Contract Management function with Confidential .
• Worked as Data Governance Solution Architect/MDM Consultant in the Wholesale Banking Group with Confidential for their Enterprise-wide Master Data Management, Data Governance and Information Improvement Program.
• Have worked with clients like Confidential, delivering Regulatory (EPA) Reporting strategy for Corporate Health & Environment Safety, Confidential, Blue Cross Blue Shield of Texas, Confidential .
• Have led technical teams ensuring technical delivery and resource management at GE Healthcare Services, Confidential .
• Strong hands-on experience in BI/OLAP and ETL (Extraction-Transformation-Loading), Multi-dimensional design, OLAP modeling & prototyping, tuning & optimization.
• Strong experience and thorough understanding various components of an Enterprise Information Architecture i.e. Source Systems, Data Warehouses, Operation Data Stores, Data Marts, Data Models, User Interfaces, Reporting platforms.
• Strong experience in organizational data acquisition, dissemination and access strategy.
• Strong experience and Understanding of Agile, SDLC, project management and roll out methodologies and production support environment.
• Strong experience in working with teams and users across the globe (offshore-onsite model).

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, MN

Sr. Business Systems Analyst

Responsibilities:

• Created product vision, product backlogs, MVP Concepts.
• Created complex workflow analysis.
• Supported the stakeholders in the bioinformatics, regulatory and product conceptualization.
• Effectively bridged the biology-technology gap by translating between researchers, genetic counselors, bioinformatics specialists, regulatory SMEs, product owners and IT.
• Gathered, prioritized groomed requirements from diverse stakeholders in a cross functional clinical laboratory landscape
• Analyzed processes, relevant subject areas in Oracle's HDW (Healthcare Data Warehouse) framework.
• Integrated genetic sequencing data (VCF) from external vendors into in-house system, i.e. Oracle TRC (Translation Research Center).
• Worked with mobile phlebotomy service provider to integrate data and systems with the bio-bank.
• Bridged the gap between bio-statisticians, clinical researchers and IT by analyzing the data dissemination & information management process of the Bio-banking/research systems that support translational research activities across various research programs.
• Conceptualized various report metrics for bio-bank's top management for them to be able to get a unified view of the operations.
• Provided Key Inputs towards Data governance and Master Data Management in clinical/pre-clinical research.

Environment: SQL, JIRA, Trello, TFS, MS Azure, XML, TSV, JSON, GFF3, VCF, NGS Workbench (Clinical tool used to assess genomic findings and document notes), RoQCM (Tool used by labs to asses sequencing quality metrics)

Confidential, South San Francisco, CA

Sr. BI/Reporting Business Systems Consultant

Responsibilities:

• Led and directed development (ETL and Reporting) team for modifications and enhancements to the reports and reporting schema architecture.
• Planned, managed, supervised and led the development, QA, UAT and deployment efforts towards on time delivery.
• Gathered, Analyzed, Scoped and Managed users’ reporting requirements. Translated business requirements to technical & functional specifications, Data models, ETL logic, S2T maps, reporting specifications.
• Created specification for Enterprise reporting for new reports as well as for enhancements for the reports and reporting schema.
• Provided inputs towards Enterprise DW and reporting architecture, development, deployment and testing strategy.
• Identified, escalated and managed closure of data quality issues with the datawarehouse and source system (Revitas® Flex)
• Consulted toward buy Vs build decisions.
• Provided Key Inputs towards Data Governance & Management.

Environment: /Tools: Oracle®, SQL, ER Studio®, HP ALM®, JIRA, Remedy, Business Objects®

Confidential, San Leandro, CA

Sr. Data Governance & MDM Consultant

Responsibilities:

• Created Functional and Business Requirements for Rejection, Cleansing, Exception and other Quality ‘rules’ across various systems of records based on Regulatory and BASEL Guidelines.
• Created Data Models for Data and Generic Rules infrastructure for the Rules Engine using ER Studio.
• Analyzed the AS-IS and TO-BE systems process of C&I (commercial and Industrial) and CRE (Commercial Real Estate) regulatory reporting as out lined in FR Y19-Q per BASEL guidelines.
• Directed Technical teams for implementation and testing of the rules in the rules engine.
• Suggested Improvements to System of Record Data models.
• Created Functional and Business requirements for Data Quality Metrics.
• Created Process flow diagrams for AS-IS and TO-BE Data.

Environment: Oracle®, SSIS, Informatica® (PowerCenter, Data Quality, Analyst), ER Studio®, HP ALM®

Confidential, San Ramon, CA

Sr. BI Solutions Architect/Systems Analyst

Responsibilities:

• Conducted as-is and to-be analysis for corporate information acquisition and dissemination process (for Criteria Pollutants and GHG) while working very closely with C-Level Confidential Corporate HES officials.
• Led requirement-gathering sessions with senior and mid-senior business unit officials across the globe to gather requirements for Air, Water and Waste modules
• Conducted ‘tool usage’ assessment across various deployment sites across the globe to assess how the tool is being used and how it might impact data access, data acquisition and data dissemination needs.
• Conducted in-depth ‘hierarchy analysis’ and suggested solution approaches to ‘non-conformed’ hierarchy problem from Enterprise-wide Master Data & Data governance perspective.
• Conducted in-depth process flow analysis and data flow analysis for GHG and VoC reporting.
• Suggested options for scoping and feasibility of environmental reporting Data mart/s in a complex Essential® deployment landscape within an already ‘siloed & fragmented’ environment by asserting Data Governance best practices.
• Suggested data and information access strategy in the light of current and future state of deployment.
• Effectively worked with a complex processes/systems/business environment to elicit, assert and prioritize the ‘must have’ vs. ‘nice-to-have’ requirements at all levels of the organization.
• Created various renditions of the Process flow and Data flow documents in complex, technology and business environment in the midst of system integrations and upgrades.
• Facilitated with Data Governance effort and assert best practices
• Conducted Data Model reviews on already deployed Essential Audit™ Data Mart.
• Interfaced with SMEs, architects and deployment teams (of Essential®) across Confidential .

Environment: SSIS, Rover Reporting, ER Studio Source System/s: IHS Essential Suite®, IHS Essential Air™, IHS Essential Waste™, IHS Essential Water™, IHS Essential Compliance Manager™, IHS Essential Audit™, CGERS

Confidential, Dallas, TX

Sr. Business Systems Analyst/Data Analyst

Responsibilities:

• Developed systems/data Integration strategy, ETL strategy, data staging, movement and aggregation strategy, enterprise information dissemination and access strategy in the light of the merging environments.
• Engaged with the stakeholders to create and collate requirements across various functions, create KPI Lineage, definitions.
• Defined and managed scope by eliciting, asserting and prioritizing the ‘must have’ vs. ‘nice to have’.
• Integrated closely with the users and the technical teams to maintain cohesion on the project efforts.
• Created various renditions of the Process flow and Data flow documents in extremely complex, technology and business environment in the midst of business system integrations and upgrades.
• Led Data Governance efforts to assert best practices in DG & MDM
• Defined data lineage capture approaches hence defining metadata standards across systems
• Created Technical Definition Documents (S2T mappings) defined technical requirements
• Created and suggested Short-term, Mid-term and Long-term Data integration strategies and best practices in the light of the AS-IS environment and the expected TO-BE environment
• Provided solutions architecture inputs and suggested/refined architecture approaches, data flow strategies to facility optimum information delivery.
• Provided technical input to refine/create technical approaches towards the delivery of artifacts.
• Guided testing teams to arrive at test strategies and test case development.
• Created and suggested BAU solution availability strategy during integration exercise.

Environment: Teradata, Oracle Datastage, Cognos, Ab Initio, Essbase, Tableau, Xcelcius, JIRA.

Confidential, Dallas, TX

Business Systems Analyst/BI Business Systems Analyst

Responsibilities:

• Devised the information system integration, implementation and deployment strategies across the organization for projects.
• Devised and formulated testing strategy for BI Projects.
• Analyzed and documented the information dissemination strategy across the organization.
• Developed BI roadmaps and approaches for BI/Data warehouse Projects.
• Elicited, analyzed, developed, gathered, documented, managed & maintained requirements and traceability matrix.
• Provided implications of different requirement and solutions approach scenarios to the stakeholders.
• Created BRDs (Business Requirement Document), Data Transformation & Source-to-Target Mapping Documents (which were inputs for Modeling, ETL/BI/OLAP teams).
• Created as-is, to-be, gap-analysis, business process flow and data flow documents, specific to the mergers and integrations.
• Collated information about the systems, and interfaces between them.
• Interfaced and liaised with technology and functional teams zealously promoting building good relationships between business and technology stakeholders.
• Liaised between the Enterprise Data Governance, Business stakeholders, Data Stewards and technical teams to manage KPI Creation/Requirements and Delivery.
• Negotiated towards a consensus on a common set of requirements and solutions approach from stakeholders ensuring coherence in concepts, ideas, and approaches among diverse stakeholders.
• Facilitated and supported Quality Assurance (QA) and User Acceptance Testing (UAT) efforts.
• Guided the On-Site and Off-Shore BI/ETL technical teams, providing inputs to the Technical Design efforts.

Environment: s/Tools: Teradata, Datastage, Cognos, IBM Profile Stage®, SQL Server 2000, DTS, Ab-Initio, ER Studio®, ERWin

Confidential - IT, Milwaukee, WI

Operational Excellence Lead Consultant

Responsibilities:

• Led design, development, testing, implementation and production deployment of reporting solutions (Cognos cubes & reports and Informatica ETL) in a complex high data volume environment in an off-shore onsite model.
• Led the DW/BI project planning efforts and managed DW projects.
• Gathered requirements and prepared functional specifications, technical specifications, test plans, use cases, interface specifications.
• Managed Enterprise-wide KPI Definition/Creation & Delivery, Conformed Dimensions and Master Data.
• Maintained and facilitated communication with end-customers to ensure customer satisfaction.
• Analyzed and scoped the extent of the enhancement and exhaustive downstream impact from BI/OLAP (Cognos, BO), ETL (Informatica®), to the source to create change/enhancement documents.
• Analyzed and resolved data incongruity issues across information interfaces.

Environment: Oracle 8i/9i, Informatica®, BO, Cognos®, ERWin Source System: Oracle Apps®, Seibel CRM ®

Confidential

Module lead/Team Member/ Developer

Responsibilities:

• Analyzed the reporting needs for GE Healthcare and built a migrated BI model in Cognos from an existing Business Objects based system
• Designed, developed and delivered Cognos Catalogs, Cognos Architect Model, Impromptu Reports, Transformer model, Cognos Cubes and Drill through Reports. Conceptualized, designed, developed, published and optimized cubes and reports to UNIX IWR and PPES server.
• Created and executed unit test plans/scripts to find errors and confirm reports/cubes meet specifications. Worked with users for validation and then deployment to production.
• Managed change control & configuration of BI Artifacts
• Provided core technical assistance with troubleshooting reports/cubes by responding to inquiries and questions from stakeholders

Environment: Oracle 8i/9i, Informatica®, BO, Cognos®, ERWin

Confidential

E-Business Consultant

Responsibilities:

• Interfaced with the clients to gather requirements, designed business process flows, created Software Requirement Analysis and Specification and High Level Design.
• Managed Software Processes, Execution, Testing, Implementation and roll out.