Resume

Sign in

Data Manager

Location:
Loveland, OH
Posted:
October 12, 2019

Contact this candidate

Resume:

Tirumala BKR Kamisetty (Balu)

Email: adako9@r.postjobfree.com Mobile: 732-***-****

PROFESSION:

A strongly motivated professional with 15 years of Information Technology.

Experience in Provider, Pharma and Health Care Domains by working for Express Scripts, Walgreens, BCBS, CTCA, Kroger, Anthem clients.

Interacted with business to understand the requirements and prepared Design documents.

Managed teams of 5-10 people having Business Analysts, DBAs, developers, and web service administrators, test engineers, Network Engineers and UI developers on various IT projects.

Worked closely with data stewards, ETL developers, and business analysts - demonstrating the ability to partner and maintain information to translate downstream consumption

Experience in KPI Dimension Analysis, Data Anomalies Discovery Strategies, Data Quality Implementation strategies.

Data Quality tooling to profile the project source data, define or confirm the definition of the metadata, cleanse and accurately check the project data, check for duplicate or redundant records, and provide information on how to proceed with backend ETL processes

Provided summary results of data quality analysis to data stewards - to make decisions on how to measure business rules and quality of the data.

Exposure on End-to-End Exception Management (Exception Transformation, Human Task, Informatica Analyst) life cycle through IDQ.

Good understanding of existing systems to identify Data Anomalies and implement the Data Quality Rules in IDQ Developer.

Lead and mentored teams in various phases of project – planning, execution and control.

Good experience on various profiling strategies like Column, Primary key, join Profiling, Score carding and KPI.

Experience in Siperian (Informatica MDM) by creating Landing tables, Staging tables, Trust Settings, and Matching.

Experience in MS SQL Server Data base Administration Activities (Log Shipping/Database Mirroring/Replication/Backups/Maintenance and other support activities).

Researched all available technologies, determined suitability and provided guidance on the best solution for the project at hand.

Guided team members by offering support, advice and best practices recommendations throughout the project implementation.

Well-versed with Software Development Life Cycle (SDLC) process which includes Analysis, Designing, Developing, Testing and Implementation.

Exposure on Extraction, Transformation and Loading of data directly from different homogeneous and heterogeneous source systems like Excel, SQL server, Oracle and Flat files.

Planned, Scheduled, managed and controlled a Software build through different stages and environment.

Worked closely with Business team to understand and finalize the requirements for the releases.

Effective communication skills with an ability to learn and quickly master new technology.

CORE COMPETENCIES

Program / Portfolio/ Project Management, Agile Scrum Master Analysis & Business Consulting.

Functional & Technical Specs & Designs, QA & Regression Testing.

Defect Tracking and Reporting.

SDLC Development.

LEADERSHIP/MANAGEMENT

Facilitate weekly program /project status and Review meetings with Business Executive leadership and Stakeholders.

Productivity improvement, Issue & Risk Mgmt.

Client Relationship Management.

Business Process & Workflow Design.

Internal & Offshore Team Coordination.

Training, Coaching & Mentoring.

Offshore development Management.

Internal & Offshore Team Coordination.

Client /Vendor project management.

CERTIFICATIONS

Certified Scrum Master with Cert. ID: 000991456 and Certification Expires: 29 September 202

Informatica Certified Professional as Informatica Data Quality 9.x Specialist with Cert. No. 005-000306

EDUCATION:

Master of Computer Applications in SMIT College at Madras University, Chennai

B.Com Computer Applications in ASNM Government Degree College at Andhra University, Visakhapatnam.

TECHNICAL EXPERIENCE SUMMARY:

Languages: C#, ASP. NET

Database: Microsoft SQL Server, Oracle, Teradata, Mainframes

Data Warehousing: Microsoft Analysis Services, SQL Server 2005 Integration Services

Informatica, IDQ

Test Directories: VSTS, VSTF, QC

Tools: DevOps, AWS, IBM Initiate Data Governance

PROFESSIONAL EXPERIENCE

Project Title: Anthem Digital Voice Actions

Tools: Node.js, Typescript, AWS and Google Firebase

Client: ANTHEM Loc: MASON, OH, USA

Role: Project Manager/Scrum Master Apr 2019 – till date

Drive the Google Actions (Anthem Google Actions) project as PM and Scrum Master from Planning to Completion.

oTo review and validate the Google Actions new functionalities provided by Anthem to implement the Anthem voice skills (Balance amount of HSA/HRA, Co-pay/Co-insurance, Deductible, Out of Pocket Max, Provider(Dentist Near Me), Order My ID card and “Ask Anthem what’s new” to hear a list of my newly added functionalities.

oUser can easily say to Google device or through Google app and they can view their Anthem skills respectively.

Working hand in hand with Ascendum Onsite Delivery Manager & Anthem Technical Manager (Digital Voice Assistance Business Systems) and other Anthem Key stake holders across voice skills platforms.

Help and Mentor project team members working.

Facilitate team organization and ceremonies (e.g., sprint planning, daily scrums/stand-ups, sprint/iteration reviews/demos and retrospectives).

Identify and remove any impediments/distractions that interfere with the team’s ability to deliver against their commitments.

Actively manage the scope planning, execution, Monitoring & Controlling, Stakeholder Management and Closure.

Attend DVA Internal PI meetings and create Jira Agile and Kanban dashboards working with other Scrum Teams. Create, monitor and track schedule sprint epics, user stories, sub tasks, issues, risk, resources, big pictures (Gantt) for overall Project tracking & Monitoring purposes.

Monitor Sprint release and team progress using metrics including team capacity and velocity, burndown and burnup charts using Jira (Agile, Kanban Dashboards etc.)

Coordinate and work with Subject Matter Experts (SME) in IDQ to document existing process, research best practices, resolve issues and mitigate risks by effectively communicating with immediate Sr. Manager and Key stake holders in the spirit of continuous improvement.

Coordinate Change Management Infra / Jira tickets, Project Deliverables (Google Actions Code, Bug fixes, New Project End deliverables etc.) with Anthem IT team for Scheduled monthly releases both for QA & Production Migration.

PROFESSIONAL EXPERIENCE

Project Title: HR DQ

Tools: IDQ 10.2, SQL Server, Mainframe, SAP

Client: KROGER Loc: Blue Ash, OH, USA

Role: Project Manager May 2018 – Mar 2019

Working closely with Business SME’s and stakeholders to project meets the deadlines

Responsible for the design of data quality solution using standardized platforms and tools.

Developed the functional and Technical design documents for the data quality application process

Responsible for the implementation of end-to-end data quality controls and reports, including the development of new metrics and controls models in accordance with business/regulatory requirements.

Performed Human Resource Data Quality assessment and provided the recommendations for modification or creation of business rules based on the data results.

Provides tactical and strategic direction in the areas of business intelligence analytics, data mining and visualization and assessment of data quality and consistency across platforms, products and business areas.

Documented at functional level on how the procedures work within the data quality applications.

Actively manage the Scope, planning, execution, Monitoring & Controlling, Stakeholder Management and Closure.

Monitor Sprint release and team progress using metrics including team capacity and velocity, burndown and burnup charts using Jira (Agile, Kanban Dashboards etc.)

Coordinate and work with Subject Matter Experts to document existing process, research best practices, resolve issues and mitigate risks y effectively communicating with immediate Sr. Manager and Key stake holders in the spirit of continuous improvement.

Coordinate Change Management Infra/Jira tickets, CIS approval & Project Deliverables (HR IDQ Code, Bug fixes, New Project End deliverables etc.) with HR IT & IDQ team for Scheduled monthly releases both for QA & Production Migration.

Lead, managed and mentored the project team.

Client: CHAMBERLAIN Loc: Oak Brook, IL, USA

Role: Data Quality Lead Jun 2017 – Apr 2018

Roles and Responsibility: IDQ Lead

Analyzed and translated client’s needs into an industry-leading enterprise data architecture that seamlessly integrated the current system and data asset with the new strategy.

Developed the vision for Data Quality improvement strategy that satisfied current needs and adapted to future needs as new sources of data input and requirements for data output were easily identified.

Responsible for designing, testing, deploying, and documenting data quality procedures and their outputs.

Documented at functional level on how the procedures work within the data quality applications.

Implemented Matching and Consolidation process as part of De-Duplication analysis.

Implemented Data Cleansing and Standardization process as part of Conformity process.

Implemented Exception Management process for bad records as part of accuracy analysis.

Lead, managed and mentored the project team.

Managed co-ordination of the stakeholders and working groups engaged in project work.

Provided status reports to project sponsors.

Worked closely with users to ensure the project met the business needs.

Monitored project progress and performance.

Identified and analyzed the process in which a defect originated and implemented solutions to prevent future occurrences of similar defects.

Analyzed and reported defect information to assist management with risk management, process improvement and project management.

Client: Solar Turbines Loc: San Diego, CA, USA

Project Title: Solar MDM May 2016 – May 2017

Role: IDQ Lead

Roles and Responsibility:

Worked closely with Business users and stake holders to ensure the project meets business needs.

Managed and lead the project team.

Provided status reports to Business users and Project sponsors.

Analyzed source data and provided detailed analysis to data analysts and Business for decision making in implementing Data Quality Rules.

Developed Data Quality improvement strategy, which was adapted for future needs as new sources of data input and requirements for data output are identified.

Implemented Data Quality rules for each attribute across all domains as per business requirements.

Profiled (Column Profiling on Master attributes prescribed by business) the data extracts (Flat files supplied by client) by applying these rules and generated the profile reports and drilled down reports (for invalid data) for each extract.

Responsible for conducting technical training for new resources.

Assigned tasks to team members as part of mentoring activities.

Prepared Data Quality Analysis reports along with observations and recommendations.

Developed different IDQ objects to implement quality of source data according to business requirements.

Implemented Matching and Consolidation process as part of De-Duplication analysis.

Implemented Data Cleansing and Standardization process as part of conformity process.

Implemented Exception Management process for bad records as part of accuracy analysis.

Documentation at functional level on how the procedures work within the data quality applications

Helped Testing Team on UAT and Production Environments releases

On-Site and Off-shore Team Co-ordination.

Client: BCBS Loc: Jacksonville, FL

Project Title: Florida Blues Aug 2015 – Jan 2016

Role: IDQ Lead

Roles and Responsibility:

Conducted Data Profiling and assisted with Data Quality Architect, data stewards and Business for the Data Quality Implementation

Analyzed the source data and provided detailed analysis for client or business approval.

Implemented Data Quality rules and applied them to applicable profile objects.

Created Deduplication Analysis of data entities from different source systems.

Created Exception Management process for Bad records as part of accuracy analysis

Worked in validating the ETL logic (business rules) for populating data from Legacy sources to data warehouse.

Documented at functional level on how the procedures work within the data quality applications.

Helped Testing Team for releases on UAT and Production Environments.

Offshore Team Co-ordination.

Client: Cancer Treatment Centers of America Loc: Goodyear, AZ

Project Title: CTCA May 2015 – Aug2015

Role: IDQ Lead

Roles and Responsibility:

Conducted Data Profiling and assisted with DQ Architect, data stewards, Business stake holder for the reIMAGINE Data Foundation Layer

Data Profiling and De-Duplication Analysis of data entities from different source systems

Created Data Quality usecases.

Identified Data Anomalies and Patterns

Built Data Quality Scorecard

Functional level documentation on how the procedures work within the data quality applications

Helped Testing Team with releases on UAT and Production Environments

Offshore Team Co-ordination.

Client: Walgreens Loc: Deerfield, IL

Project Title: Electronic Health Records Oct 2013 – Apr 2015

Role: Project Lead

Roles and Responsibility:

Worked closely with Business users and stake holders to ensure the project meets business needs.

Managed and lead the project team.

Provided Daily/Weekly Status Reports to Business and stake holders.

Managed and coordinated with partners and working groups engaged in project work.

Managed relationships and co-ordinate works between different teams at different locations.

Conducted Release Readiness Reviews, Milestone Reviews and Business Go/No-Go Reviews.

Produced Deployment, Run Books and Implementation Plans.

Communicated release details and Schedules to the Business as required.

Lead and coordinated the Go-Live activities including the execution of the deployment Plans and Checklist.

Client: Express Script Loc: Hyderabad, IND

Project Title: ESI Initiate MDM Mar 2010 – Oct 2013

Role: Consultant

Roles and Responsibility:

Support audit/review of automation, and manual review/remediation of work-queue master data decisions in resolving the Tasks.

Prescriber Adding/Updating records through Initiate Inspector as per the business requirements and submitting the request to HMS/SS/DEA/CAMP source systems.

Prepared Data Analysis reports along with our observations and recommendations

Creating Audit reports for Member Data Analysis issue and share it to Business

Resolving the tasks based on the priority and timely updating the status to the client

Linking Prescriber to the correct EID/ Prescriber from Inspector. De-Linking Prescriber if it’s not linking to correct EID and Link them to correct EID.

Monitoring Daily Scheduled and adhoc jobs

Coordinating with Business stake holders to verify and correct the Prescriber Member attributes

Regular interaction with Data Governance Team to report the critical issues.

Client: Microsoft Loc: Hyderabad, IND

Project Title: PSIT OPS Jan 2007 – Aug 2009

Role: SQL DBA

Roles and Responsibility:

Analyzing and troubleshooting the SQL Server processes and jobs.

Configuring and troubleshooting Replication, Mirroring, Clustering and Log shipping issues.

SQL standalone/Cluster Installations

Solving Disk space, Log files full and database file full related issues on SQL servers.

Proactively working on Performance and Blocking issues on servers by auditing Databases.

Maintaining of Backup Strategies using SQL Lite speed and Compress options.

Applying SQL Hotfixes, builds, Cumulative updates on servers as appropriate.

Helping Development and Test teams for releases on UAT and Production environments.

Client: ZLAPS Loc: Hyderabad, IND

Project Title : Organization and Human Resource Planning Jun 2004 -Nov 2006

Role : Software Engineer

Roles and Responsibility:

Involved in analysis and study of functional specifications and understand the functionality of the system

Involved in coding and design.

Analyzing and troubleshooting the SQL Server processes and jobs.

Configuring and troubleshooting Replication, Mirroring, Clustering and Log shipping issues.

Applying SQL Hotfixes, builds, Cumulative updates on servers as appropriate.

Monitoring Daily Scheduled and adhoc jobs

Involved in Functional Testing, Security Testing, Integration Testing and System Testing.



Contact this candidate