SUMMARY

• Qualified and skilled Analyst - Data Management, Data Governance, Metadata Management, Data Stewardship, Business Analyst and MDM professional with 7+ years of experience in Supply Chain, Banking, Insurance, Healthcare and Retail domains
• Expertise in databases and writing SQL queries
• Well-versed in Data Governance principles, processes and framework for metadata and data quality
• Experience in interacting with business users, support teams across multiple nations for understanding both IT and business reporting requirements and document generation
• Excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project
• Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
• Proficiency in performing SWOT, GAP, Root Cause, Impact and Cost Benefit Analysis
• Have good skills in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams and Class Diagrams
• Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents
• Data visualization expert with proficiency in producing interactive dashboards and reports by utilizing business intelligence tools in agile environment
• Hands on experience with ETL, Hadoop, Business Intelligence and Data Governance tools such as, Tableau, IBM IGC, Informatica Enterprise Data Catalog and Collibra
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
• Extensive knowledge of Software Development Life Cycle with complete understanding of various phases such as gathering requirements, change management, Analysis/Design, Development and Testing
• Proficient in designing, capturing, consolidating, and maintaining key metrics with Agile and Scrum Protocols

TECHNICAL SKILLS

TOOLS: Collibra, Informatica Axon, Splunk, Microsoft Azure, JIRA, iTrade, Tableau 2020.2.1, MDM Informatica, Teradata Power Center 10.1, Enterprise Data Catalog (EDC), Alation, ETQ, FoodLogiq, Rapid Miner, Micro strategy, Microsoft Power BI, Google Analytics, SQL Server Management Studio, Microsoft office suite (O365), MS Visio, MS Project, SAP, Linux, Axure RP

TECHNIQUES: SDLC Methodology, RUP, Agile, Scrum, Regression, Decision Tree, Naïve Bayes, Clustering, ETL Testing

DOCUMENTATION: Business requirement document, Use case document, Software requirements Specifications, UML Diagrams

DATABASE: MySQL, MS SQL Server, Teradata 15.10

LANGUAGES: SQL, HTML5, CSS3, Java Scripts, R, Python

PROFESSIONAL EXPERIENCE

Business Data Analyst

Confidential

Responsibilities:

• Defined and implemented data strategies, policies, controls, and programs to ensure the enterprise’s data accuracy, completeness, security, and reliability by collaborating with experts; contributed in saving of 1.2 million dollars per year
• Streamlined data integrity & quality by interacting with stakeholders, product owners, and business constituents to better understand requirements and work towards achieving the desired output, in support of company’s initiatives
• Collaborated with business stakeholders to develop and document policies and procedures surrounding Data Stewardship and Data Governance
• Applied EDM (Enterprise Data Management) and DG principles to create an efficient and effective data management environment that serves multiple business units in their pursuit of a data-driven organization
• Established a formal EDM, MDM (Master Data Management) and DG program that creates effective engagement between EDM, business operations, delivery teams, and IT
• Lead the Data Governance committee, recruit new data stewards from the line of business and departments, and work with them to ensure data standard across the organization
• Maintenance of datasets and data roles in the Enterprise Data Catalog - additions, updates, and deletions
• Performed onboarding, transition, and education of Confidential stakeholders for the Data Stewardship Roles at the enterprise (Data Owner, Data Steward, Data Custodian)
• Conducted quarterly Data Owner meetings to communicate upcoming Data Governance initiatives, processes, policies and, best practices
• Onboarded multiple LOB users into the enterprise metadata management product and implemented data stewardship for Enterprise Data Stewardship (EDS) team
• Managed metadata ingestion (manual and automated) from different sources
• Lead the Planning and Execution of Data Quality projects (support ongoing and new)
• Engagement with key stakeholders on Data Quality goals, requirements, and timeline
• Responsible for writing data policy and strategies for all incoming data
• Participated in the design, implementation and distribution of operating procedures
• Developed functional specifications and system design specifications for project engagements
• Maintained project documentation via established project management tools (such as, Confluence, JIRA, and SharePoint)
• Managed, analyzed, and resolved data initiative issues and data quality issues and manage revisions needed to best meet internal and customer requirements while adhering to published data standards
• Assisted in data management, governance, and data quality of data requirements with other functional data owners to ensure functional data integrity across the operation of financial systems is consistent and meets stated business rules
• Visualized Splunk dashboard, reviewed error messages, research and troubleshooted issues, and resolve accordingly
• Automated and optimized processes to increase efficiencies by 90% by configuring automated alerts in Splunk
• Monitored daily reports coming from MicroStrategy, Splunk and Tableau for discrepancies and report to the users
• Developed and published customized interactive reports and dashboards, report scheduling using Tableau server
• Built interactive Tableau dashboards and worksheets to observe trends, KPIs and scorecards
• Created Tableau workbooks from multiple data sources using Data Blending
• Coordinated with ETL team by retrieving files from SFTP logs and uploading it into Informatica server and make data available
• Cleaned and standardized different supplier categories by profiling, validating; and map data by utilizing MDM Informatica

Data Governance Analyst

Confidential

Responsibilities:

• Executed a holistic, multi-pronged approach to embedding Enterprise Data Management, Master Data Management and Data Governance principles and practices across the enterprise
• Responsible for Enterprise Data Management “Data Governance Analyst” duties; Working with senior leadership in setting strategic priorities, setting milestones, reviewing progress, writing and documenting data policies and control policies, and reporting status
• Provided Subject Matter Expert to the DG council to develop the Data Standards and Rules for Master Data
• Collaborated with Enterprise Data Architect, Business users, and Stakeholders to finalize the Operating Model to be used to govern Data in Collibra DGC
• Served as Subject Matter Expert on implementation and maintaining Collibra Data Governance Center
• Establishment of Data Catalog and shop-for-data feature in Data Governance tool
• Created Communities, sub-Communities and other Collibra Domains
• Implemented various Asset types: Business Assets, Technology Assets, Data Assets and Governance Assets
• Prototyped GDPR and CCPA associated Policies, Standards, and Business Rules in Collibra for business understandings
• Partnered with data domain teams to support front line data security activities through data understanding and early identification of data security requirement
• Integrated Collibra with other enterprise tools: Tableau, Data Quality Tool, Data Catalogue Tool, Application mgmt. Solution
• Worked with CDI (Customer Data Integration) team to identify opportunities to populate Enterprise Data Dictionary
• Promoted data security practices across the data community
• Lead cross-functional initiatives to mature data security capabilities
• Collected Business Requirements by interacting with Users, Engineers, Project Manager to understand business processes
• Conducted GAP analysis while successfully re-engineering key business processes to increase operational efficiency, and alignment of business unit objectives
• Served as a key liaison within business, IT and other departments
• Supported / drove development of presentations, as needed, across various audiences
• Formulated procedures for data extraction, transformation, and integration of customers and location data
• Created data sets and performed data validation and data cleansing using SQL queries while maintaining data integrity and reducing data redundancy; thereby optimizing data quality
• Cleaned old financial data and uploaded required data into new systems using SQL queries
• Managed spreadsheets and maintain data concurrency and consistency to ensure accurate data availability for managers and decision-makers
• Performed data analysis using pivot tables in Excel and provided insights for the entire supply chain and operations department to track key metrics and achieve analytical goals
• Implemented dataset joints using Tableau and ensured data quality to identify and visualize key performing indicators to increase 35% efficiency by providing ad-hoc data reports
• Collaborated with C.R.M. team to identify trends to enhance customer support and channel profitability
• Delivered financial models, marketing dashboards, reports, and analysis to track monthly trends to boost company’s profitability by 30% and make processes efficient

Data Analyst

Confidential, New Jersey

Responsibilities:

• Conducted descriptive analysis using student dataset on performance, attendance, behavior, and achievement outcomes
• Managed large structural data and executed data manipulation queries using MySQL to extract various data requested data by departments
• Facilitated database from obtained datasets and generated data mapping, logical data modeling and used SQL queries
• Collaborated with marketing team on boosting admission by 9% based on students interests project by extracting and delivering required data & information using public data sources
• Assigned sentiments to multiple datasets and determined how to display and share information for end-user reporting (internal & external), KPIs and analytics capability. Observed trends of sentiments by time series analysis
• Gathered university research data, transformed and prepared visual reports using Tableau to track the progress and funding by departments
• Produced briefings, tables, charts, mapping, graphs and materials for research evaluation based on the data
• Utilized google analytics to generate monthly website traffic report, analyzed what people are searching for on the site, uncover top and bottom content
• Constructed reports based on the data that summarized KPIs and helped marketing team on boosting admission by 9%
• Prepared budgetary reports and charts for presentation to the Board of Trustees, or as requested by the University or external entities and assisted curricular committee in decision making and planning by providing insights of the analysis