Business Intelligence Data Analyst

Sowmya C

San Diego, CA ***** 317-***-**** **********@*****.*** linkedin.com/in/sowmya-c-80aaa8122/

Expert Business Intelligence Analyst & Data Analytics Specialist

“Expertise in complex statistical analyses, data integration strategies, and custom reporting solutions – enabling strategic healthcare decisions and operational efficiency.”

Experienced Business Intelligence Specialist and Data Analyst with a proven track record in the healthcare and banking sectors.

Expert in data integration, statistical modeling, and healthcare data management.

Proven ability to steer EDI program development and automation, transform complex business requirements into tailored datasets, and support data-driven decision-making processes.

Leverage strong management skills and the ability to lead high-performing teams, align technology with business goals, and deliver customer-centric solutions.

Looking for a development and/or management role within the healthcare industry to leverage my versatile expertise in driving data-driven strategies and operational efficiency.

CORE COMPETENCIES

Business Intelligence Data Integration & Analysis EHR (Electronic Health records) EPIC Cogito Analytics Module Dashboard Creation Project Management OBIEE reporting tool Data Visualization SQL Programming & Python Scripting Healthcare Data Management EDI Program Management BI Publisher Data Mapping, Data Mining, Data Science, & Data Loading BI Quality Assurance (QA) Training & Development Strong Organization Skills Data Management Concepts

TECHNICAL SKILLS

BI Data Warehouse: SSRS, SSIS Databases: MS SQL Server, MS Access, Oracle Version Control: TFS, Subversion (SVN)

Languages: Python, Perl, T-SQL, PLSQL Reporting/ETL: SSRS, SSIS, SSAS, Report Builder, BI publisher,Tableau Desktop, Power BI

Others: SQL Server Data Tools, BIDS, SQL Server Management Studio, Visual Studio, MS Office (Microsoft Excel, Word, PowerPoint), Share Point, JIRA, HP ALM, SPSS, Stata, SAS, OBIEE

PROFESSIONAL WORK EXPERIENCE

Sharp Health Plan; San Diego, CA

EDI Developer/ Sr.Systems Analyst October 2024 – Current

Work with business analysts and stakeholders to understand data requirements and develop technical solutions.

Create and maintain EDI solutions for healthcare-related transactions, such as enrollment (834) and claims (837).

Develop and optimize SQL queries and stored procedures to support data processing and reporting.

Resolve EDI-related issues to ensure data integrity and accuracy. Work with internal and external teams to ensure system compatibility and data consistency.

Environment: SQL/PL-SQL, Python, Microsoft SQL Server,Oracle, Sharepoint, Epic systems, Power BI, Tableau

D&K Engineering; San Diego, CA

Sr. Business Intelligence/ETL Developer August 2022 – October 2024

Led a high-performing reporting team of 2, overseeing reporting needs for the operations, supply chain, and manufacturing departments; streamlined business intelligence processes to enhance operational efficiency.

Developed 6 high usage dashboards that helped in identifying excess inventory and leading to 950K of additional revenue, prioritizing the list for inspection of shop orders based on demand, metrics of NCR’s (non-conformance orders) and eventually leading to streamlining the operations.

Developed reports to cater to the needs for HR management with visibility into time and attendance and brought efficiency in payroll which resulted in efficient tracking of part-time employees and contractors.

Optimized report performance through expert development of SQL queries for generating tables, views, and indexing, concurrently ensuring robust monitoring and management of SQL, SSRS, OBIEE, PowerBI and SSIS jobs to swiftly troubleshoot and rectify issues.

Led training sessions on dashboard usage and utilization for users. (Demos, Developed Documents for reports and dashboards)

Environment: SQL/PL-SQL, Python, Microsoft SQL Server,Oracle, JIRA, Power BI, Tableau, Microsoft Looker

Borrego Healthcare; San Diego, CA

EDI Program Management/BI Developer February 2018 – August 2022

Directed the development, automation, and management of comprehensive Electronic Data Interchange (EDI) programs, translating complex business requirements into tailored datasets for diverse stakeholders, and ensuring data-driven decision-making processes. Experience in working & Radar dashboard development with EPIC Cogito Analytics module and EPIC EHR (electronic health records) system.

Led & managed electronic data interchange (EDI) program with pharmacies: Walmart, CVS and Walgreens. Successfully developed and deployed data automation of jobs using SSIS and SSRS. Leveraged Power BI to build dashboards and reports for TELEHEALTH resulting in increased usage of virtual appointments resulting in cost savings of $1.6M dollars.

Leveraged Tableau OBIEE, BI publisher to build dashboards for Covid lab order management & Covid Vaccine - resulting in better patient outcomes and reducing 7% age emergency room visits. Developed patient alert systems within the vaccine management data program, identifying high-risk patients, thus contributing significantly to patient care and outcomes.

Leverage Power BI to build dashboards and reports for referrals resulting in better collaboration with referring physicians and hospitals. Delivered performance reports for all clinical sites and their staff to respective clinic managers, fostering transparency and facilitating performance improvement initiatives.

Collaborated with local universities and the CA public health department, providing pivotal data for research studies while also generating ad-hoc and performance reports for quarterly and annual auditing, interacting with C Staff and other executives.

Delivered performance reports for all clinical sites and their staff to respective clinic managers, fostering transparency and facilitating performance improvement initiatives.

Developed ad-hoc reports and performance reports for quarterly and annual auditing (UDS/ HRSA and OSHPD.)

Enhanced user competency and data-driven decision-making through the development and delivery of tailored training sessions on dashboard usage and utilization for stakeholders, clinic managers, and staff.

Environment: SQL/PL-SQL, Python, Microsoft SQL Server, Oracle, JIRA, JavaScript, OBIEE, Power BI, BI Publisher,Tableau Desktop

Deutsche Bank; Chicago, IL

Product Owner/BI Developer February 2016 – January 2018

Acted as ITAO/Product Owner for crucial internal banking applications: Impact, Measurabl, and Procure to Pay, managing and prioritizing product backlogs while seamlessly acting as a liaison between product and development teams.

Leveraged SSRS and SSIS, to design and develop tailored reports, packages for asset management and banking invoices.

Leverage Tableau to build dashboard for portfolio analysis and asset performances all over USA/Canada.

Spearheaded testing initiatives for internal bank applications, developing comprehensive Test Scenarios and Test cases in HP ALM, ensuring robust application performance and stability.

Provided unwavering 24/7 support for ongoing tickets/incidents pertaining to internal banking applications, ensuring minimal disruptions and fostering client satisfaction.

Successfully developed and managed a comprehensive project work plan in JIRA, efficiently tracking incidents/issues, ensuring timely resolution, and minimizing system downtime.

Environment: SQL/PL-SQL, Java, Microsoft SQL Server, JIRA, HP-ALM, Tableau Desktop

Pfenex Inc.; San Diego, CA

Software/Database Analyst April 2014 – September 2015

Engaged in comprehensive comparison and analysis of sequencing data derived from two distinct platforms: Sanger’s and 454 Pyrosequencer, providing insightful data interpretation for decision-making

Extracted requisite data from complex sequencing files employing Python and Perl scripting, demonstrating proficiency in data manipulation and extraction, and facilitating smooth data analysis operations.

Environment: SQL/PL-SQL, Python and Perl scripting, WEMBOSS, RAST, Excel, MS Access

EARLY CAREER EXPERIENCE

Research Assistant San Diego State University SDSU; San Diego, CA

Technical Business Analyst Medusind Solutions; India

EDUCATION & PROFESSIONAL DEVELOPMENT

Master’s in Bioinformatics and Information Systems San Diego State University; San Diego (May 2012 – Dec 2014)

Master’s in Biotechnology University of Madras; Chennai, India (July 2009 – June 2011)

Bachelor’s in Computer Science Osmania University; Hyderabad, India (June 2005 – June 2008)

Certification in Data Visualization & Data Analysis University of California; San Diego, CA (Aug 2017 – June 2018)

AWS Certified Solutions Architect – Associate Amazon Web Services (AWS) (March 2018 – March 2022)

PROFESSIONAL MEMBERSHIPS, AFFILIATIONS, & VOLUNTEER WORK

Team Lead & Active Volunteer CRY Child Rights & You (January 2013 – Present)

Lead the San Diego Chapter of Child Rights and You (CRY) - • Led and oversaw every aspect of the event process, including strategic planning, budgeting, risk assessment, resource distribution, on-site coordination, reconciliation, and post-event evaluations. Directed a dedicated team of volunteers for multiple CRY events, which attracted crowds ranging from 200 to over 2000 attendees, yielding net profits between $30,000 and $200,000 per event.

Contact this candidate