Integration Specialist Business Analyst

Sushma Dasari, MBA

Buffalo, NY 716-***-****

********@*****.*** https://www.linkedin.com/in/sushma-dasari-mba

Solutions Architect Data Geek

Over 19 years of corporate IT experience with a strong understanding of complex and interdependent business requirements, and over 8 years in project and team leadership as a Solutions/Data Integration Architect providing senior level risk avoidance guidance to project teams to mitigate threats to existing business processes.

As a solutions and Data Integration specialist, able to understand the business conditions - downstream effects, business requirements, coding needs, system upgrades including new technologies and estimate project hours and delivery schedules to fit within the budgeted project cost.

Lead the strategy supporting different streams of data, storage and disaster recovery, quality of data, business glossary, master data management and data warehouse, data visualization, infrastructure, security needs and developing cost-based analysis for budgeting purposes.

Experience

Independent Health Association, Buffalo, NY Dec. 2019 – Present

Working on the Big Data team

oTo build their Data Lake on AWS S3, using AWS Glue, AWS DMS, AWS LakeFormation and AWS Lambda

oTo build Reporting and Analytics Database on AWS Redshift and AWS Athena

oEnable the Data Scientists and Analysts to perform Analytics and Self-Service data mining, using AWS Analytics Web Services.

Currently also working on the on-premises Big Data project, built on Hadoop Ecosystem, using HIVE, NiFi and HDFS

Collaborating with key stakeholders and internal teams to define solution design, architecture principles, standards and guidelines, and blueprints.

CSS HEALTH, Buffalo, NY Oct. 2018 – Sept. 2019

Collaborate with the Product team and facilitate requirements gathering.

Develop robust solutions to meet the immediate and long-term needs of the business customers.

Participate in RFI and RFP processes for Vendor Evaluations and keep them updated.

Research and select the available vendors for Data Visualization and Data Warehouse software and tools. And deciding which offers the optimal cost and quality for the company.

Created the best practices for data loading and extraction.

Developed star schema data models in Data Warehouse, ETL scripts and validated results with end users.

Build a Data Warehouse for Reporting, Analytics and Self-Service, for internal and external customers, using AWS web services stack like DMS, S3, Glue (Python scripting), Redshift and Lambda.

Authored and configured the visualization and dashboards in Tableau and AWS Quicksight to meet the needs of the Business Requirements.

Collaborate with key stakeholders and internal teams to define solution architecture principles, standards and guidelines, and blueprints.

M&t Bank, Buffalo, NY Jan. 2018 – Oct. 2018

Solution Architect, AVP

Manage the team members of the projects effectively and within the required parameters set by the Resource managers and project budget. This also includes the setting project team goals and providing feedback on their performance reviews.

Built Business processes and capabilities, Application and Technology ecosystems using ArchiMate EA framework.

Create, refine and oversee execution of internal process of the Architecture functions.

Demonstrating leadership skills in portfolio management, enterprise change management and project management

Design and implement solutions, by collaborating with key stakeholders and internal teams to define principles, standards and guidelines and blueprints.

Comprehend business strategies and requirements and develop necessary designs and plans to ensure projects and satisfy those needs.

Actively listen to client problems and needs to implement that information when creating solution plans

Provide advice and make decisions about which technologies would be suitable to use for various projects

Collaborate with project managers and other staff members to develop budgets and timelines for solutions

Assess and evaluate risk as required

Mentor, educate, and train colleagues as requested

Strong negotiation skills, along with influence and conflict resolution.

Participating in budget allocation and analyzing

Clinical Support Services, Buffalo, NY 2017 to 2017

Data Architect

Design, create, deploy and manage company’s data architecture, using MYSQL, AWS Quicksight, and AWS Cloud Server and determine solutions for data requirements, maintain a data dictionary, revise and enter definitions and act as the company advisor on data.

Create models to depict trends in the customer base and the consumer population and analyze data to create business reports and analytics and mentor the technical team.

HealthNow, BlueCross BlueShield WNY, Buffalo, NY 2014 – 2017

Senior Solution Architect

Analyze business and technology challenges, assess costs, and suggest solutions.

Design and execute proof-of-concept for critical enterprise capabilities, including building business case with costs, benefits, and efficiency measures.

Collaborate with key stakeholders and internal teams to define solution architecture principles, standards and guidelines, and blueprints.

Translate business requirements into systems qualities and repeatable design strategies and patterns, such as adaptability, scalability, availability, and reusability.

Ensure development and incorporation of architecture with other layers.

Consistently monitor the scope of projects.

Create robust and custom solutions to meet specific business needs.

Outline current and future architecture, including traceability from business and IT strategies to suggested technologies, using SPARX (UML and Archimate 2 framework).

Coordinate with architects and business experts across IS to translate key strategic objectives into actionable and governable roadmaps and designs.

Provided technical leadership for Architecting 3rd party and custom developed software solutions using .NET, C#, SQL, SOA, Single Sign-On (SAML), MQ, and Message Broker.

Assure enterprise application integration by selecting tools, specifying shared data and code resources, defining interfaces and data-flows, and monitoring progress.

Independent Health Association, Buffalo, NY 2005 – 2014

Lead Solution Architect, 2010 – 2014

As a Solution Architect led strategic initiatives.

Collaborated with Project Managers and technical directors to provision estimates using CBA document, developed overall implementation solution plan, served as lead to implement the installation, customization, and integration efforts.

Led development of formalized solution methodologies.

Provided architectural guidance on new and in-flight LOB specific projects.

Oversaw all phases of project life cycle, from initial kickoff through requirements analysis, design and implementation.

Provided quality assurance for services within the solution area.

Worked closely with C-Level Stakeholders, Business owners, Users, Customer and Business Analyst to prepare Business Requirement Document (RSD).

Implemented best practices or reusability techniques, for Technical Solution and code development.

Managed a team of direct reports who drove service lines.

Assisted staffing coordinators who defined project team requirements.

Worked with Delivery Services Director to define overall expertise needs to recruit new staff members.

Worked with the Director of Delivery Services to establish professional development needs for practitioners.

Mentored and guided junior technical resources.

Senior Informatica Consultant, 2005 – 2010

Developed B2B, EDW and MDM data extracts, using Informatica 8.1/9.5 Power Center (Designer) utilizing Informatica Power Center including Mapping, Sessions and Workflows for in-build transformations.

Performed data analysis and data profiling, using tools like PL/SQL and TOAD and worked on homogeneous and heterogeneous databases like ORACLE, MS-SQL Server, DB2/400, Flat files and XM.

Developed stored procedures using SQL/400 and PL/SQL, performed data quality analysis using Informatica Data Quality.

Computer Skills, LLC / Systems Personnel, Buffalo, NY

Sr. IBM/AS400 Consultant, 1999 – 2010

Developed complex business applications (programs) and reports using RPG/400, RPG III/IV (ILE), COBOL/400, COBOL ILE and COBOLSQL for companies in various industries including financial, services, retail, manufacturing and health care. On-site assignments were a minimum of 6 months in length.

Independent Health Association, 2002 - 2010

Baillie Lumber Company, 2002

Sherwood Harsco and HSBC Bank USA, 2001

Euronet Services, Arksys Division, 2000

Catalyst Direct Inc.,1999 - 2000

Education

University at Buffalo, Buffalo, NY – Masters 0f Business Administration (Executive MBA)

Andhra University, Visakhapatnam, India – Bachelor of Science, Commerce,

National Institute of Information Technology (NIIT), India – Honors System Management

Special Projects

Data Warehouse (Reporting and Analytics) Medication Therapy Management

Provider Credentialing extracts (CACTUS)

Provider reimbursement and incentives (Pay for performance and Per Member Per Month) extracts and reporting (SQL, UCDS and PAYSPAN)

Clinical Editing tool installation and rules configuration (McKesson ClaimsXten)

Prior Authorization automation and tool installation (CareRadius and CareAffiliate)

Patient Care Management (Case Management/Disease Management/Utilization Management) automation.(CareRadius)

Master Data Management implementation (Enterprise Master Patient Index (EMPI), (IBM Initiate Master Data Service 9.x)

Upgraded Informatica (ETL) from v8.1 to 9.1, and Similarity to Address IDQ

Installed Informatica (ETL) versioning tool (Team Based Development), Underleau (Automated Informatica code review tool), RedHat Linux operating system

Data Warehouse enhancement

Healthcare Effectiveness Data and Information Set (HEDIS), Data Mart load

Provider Fraud and Abuse Data Mart Load and reporting

Provider Eligibility and Payments extracts and loads (EDI ANSI X12 834 and 835)

Technical Skills

AWS Webservices

Data Visualization

Languages

DMS, Transfer SFTP, S3, Lambda, Glue, LakeFormation, Redshift, Athena and QuickSight

Tableau and AWS QuickSight

RPG/400, RPG III/IV (ILE), COBOL/400, COBOL ILE and COBOLSQL

ETL

Informatica Power Center 9.5/7.1.3/6.2 and IDQ (Data Quality)

MDM (Master Data Management)

IBM Initiate Master Data Service 9.x

Databases

Oracle 9i/11 g, DB2/DB2-400, MS-SQL Server and MS-Access

Reporting

Crystal Reports and fundamentals of Cognos

Operating Systems

MS-DOS, UNIX and IBM OS/400

IBM-AS/400 Tools

Hawkeye(Search engine) and Alldon CMS (Version Control)

Other

Query/400, SQL/400, PL/SQL Developer and Toad

Training Certifications

AWS Certified Cloud Practitioner Dec’2023

AWS Certified Solutions Architect – Associate Dec’2023

Hadoop Fundamentals

ArchiMate 2 Certified - Certification #2338

Informatica Power Center Designer Tool versions: 9.0/8.0/7.3 (from Informatica)

Certificate course in IBM AS/400 from SRI Research & System Development Pvt. Ltd., India

Contact this candidate