It Analyst Systems

ARCHANA KUDRIMOTI

**************@*****.***

SUMMARY:

Experienced IT Analyst with over 20 years of expertise across technical and business domains, with a strong focus on the Insurance and Healthcare industries. Proven ability to bridge the gap between IT solutions and organizational goals by combining deep technical knowledge with strategic business insight. Adept at working with various databases and business intelligence tools to analyze, interpret, and report complex data, driving efficiency, innovation, and informed decision-making. Recognized for excellent communication skills and the ability to effectively collaborate with cross-functional teams and stakeholders. Technical Skills:

Cloud & Big Data:

• AWS (Athena, S3, Parquet)

• Azure SQL Database, Cosmos DB, Azure Data Lake Storage (trained) Data Transformation & Analytics Engineering:

• dbt (Data Build Tool)

Programming & Scripting:

• Python

• Java

• Perl

• SQL, T-SQL, PL/SQL

• PrestoSQL

• Unix Shell Scripting

• Jupyter Notebooks

Databases & Data Management:

• Microsoft SQL Server (MSSQL)

• Oracle (including Oracle Forms, Oracle Reports, Oracle Financials, Oracle APEX)

• AWS Athena

• Epic Systems (Clarity, Caboodle, Cogito, COSMOS,RADIANT)

• Cerner (including PowerChart)

• Redcap

• DBeaver

• TOAD

Business Intelligence & Reporting:

• Power BI

• MicroStrategy

• Tableau

• Business Objects

• Oracle Reports

Development & Version Control:

• GitHub

• CVS (Concurrent Versions System)

• CGI (Common Gateway Interface)

• Jira

Productivity & Collaboration Tools:

• Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, Access)

• Microsoft Teams

• Slack

• Windows and Mac Operating Systems

Healthcare & Compliance:

• Epic Systems (Clarity, Caboodle, Cogito, COSMOS)

• Cerner PowerChart

• HIPAA Compliance

• CITI (Collaborative Institutional Training Initiative) EXPERIENCE:

Emory University, OIT Data Solutions, Atlanta, GA

Information Technology Analyst

03/01/2013- Present

Summary:

Experienced Informatics Analyst and Subject Matter Expert (SME) with a strong record of leading and delivering high-quality, HIPAA-compliant applications and data solutions on time, within scope, and in full alignment with regulatory and organizational standards. Leads multidisciplinary projects in a versatile capacity, successfully performing as a Business Analyst, Project Manager, Information Architect, Data Analyst, and Database Administrator to deliver complex, high-impact solutions. Drives efforts to ensure that informatics systems align with and advance the research objectives and mission of Emory University. Build strong collaborations with subject matter experts and acquire extensive expertise across multiple lines of business. Champions the exploration and adoption of emerging technologies by developing proof-of-concepts and promoting their use to enhance organizational capabilities. Experienced in managing highly-complex technical teams, mentoring other analysts by sharing technical expertise, ensuring regulatory adherence, and the development of standard operating procedures. Always proactively willing to support and assist the team to achieve project goals. Skilled in developing new subject areas within business intelligence tools by leveraging physical data sources and adapting to evolving user requirements. Working expericnce with uploading data into datamarts using the concepts of ETL and running a log of the Audit trail reports to track dataflows. Proficient in creating strategies to maintain data standards, manage metadata, and apply biomedical informatics principles, technical standards, and methodologies to meet research-specific needs and outcomes. Experienced in creating architecture documentation for current and proposed informatics solutions. Creative and adept at designing tactical strategies to meet client goals and building flexible, secure reporting infrastructures that support diverse business and research requirements.

Key roles and responsibilities:

• Serve as a liaison between Emory Hospital and Emory University to facilitate collaboration and information exchange supporting research, operations, and data quality initiatives.

• Embedded Business Analyst for the Radiology Department, advancing research objectives by accessing, analyzing, and developing tools to process and interpret large-scale (Big Data) datasets.

• Solely managing the initiative to build a data mart for the Electrophysiology Department, which includes data migration from the legacy system and EPIC. This architecture supports the generation of reports and dashboards that provide access to de-identified datasets.

• Development of ETL process to upload data in a timely manner using Oracle PL/SQL and writing cron jobs to manage the process of automation.

• Writing necessary reports to run the logs to track the logging on the ETL process and Audit reports.

• create modular, version-controlled SQL transformations with automated testing, documentation, and data lineage tracking within ELT workflows using DBT.

• Serve as Project Manager to lead diverse, cross-functional teams across Emory to develop creative, real-time data solutions that address critical business and research needs. I partnered with the BMI team to implement RTA database. I was instrumental in designing and building the backend data marts and dashboards for the university’s COVID-19 response. This high-impact project enabled timely access to vital data during a critical public health crisis.

• Continuously gaining knowledge of healthcare business terminologies such as ICD-9, CPT codes, and related classification systems to enhance data analysis and reporting accuracy. Contributed to data migration and system updates during ICD code transitions and enhancements.

• Familiar with following Institutional Review Board (IRB) processes and protocols to ensure compliance with research ethics and regulatory requirements, while actively staying updated on policy changes and best practices.

• Build and maintain strong collaborative relationships with clients, physicians, research associates, professors, statisticians, and clinical staff to gather business requirements, perform data analysis, and develop effective Business Intelligence tools. My work includes building secure data pipelines using AWS (Athena, S3), SQL, and Python, creating visual reports with Tableau, Power BI, MicroStrategy and streamlining processes for request handling across multiple departments.

• Design and deliver innovative data architectures, develop data marts, and create HIPAA- compliant reporting solutions that provide secure, user-friendly access to encrypted data while applying biomedical informatics principles, technical standards, and methodologies to support research-specific goals. I have contributed to multiple research projects, including collaborations with the CDC, and played a key role in institutional initiatives such as the development of CRADLE—a clinical research data lake leveraging AWS services.

• Design and develop visual reports, dashboards, pivot tables, and interactive graphs to support timely, data-driven decision-making, while scheduling and automating report generation based on user-defined frequencies and evolving requirements to ensure timely delivery.

• Provide user training for custom-built applications (in RedCap), create data reports and models, and deliver solutions within project scope, timelines, and budgets.

• Work with diverse data types and formats to ensure accurate, comprehensive, and high- quality analyses.

• Streamline request submission processes and task management workflows to improve cross- departmental communication and operational efficiency.

• Consistently apply creative problem-solving strategies to design innovative, user-friendly solutions that enhance data accessibility, streamline workflows, and improve user engagement. One notable project, MEWS, empowered ICU teams by providing critical data on patients' vital signs and sepsis indicators.

• Mentor team members by sharing technical knowledge and conducting training sessions on emerging technologies to foster continuous learning, encourage adoption of new tools and methodologies, and promote team growth through active knowledge sharing.

• Contribute towards building prototypes as proof of concept for new and enhanced technologies to evaluate feasibility and drive innovation. Designed prototypes, particularly for the AWS project to evaluate, refine, and optimize tools for both organizational and research use.

• Keep management regularly updated through one-on-one meetings, team meetings, and status reports to ensure transparency and alignment.

• Ensure thorough documentation of all processes, workflows, and solutions to maintain clarity, support knowledge sharing, and facilitate ongoing project management and compliance.

• Always proactively willing to help the team and contribute to its success.

• Oversee end-to-end project management, ensuring the successful and timely delivery of data solutions aligned with organizational goals.

Technologies Used:

AWS Athena (PrestoSQL), S3, MSSQL, SQL, PLSQL ORACLE, PYTHON, TOAD, MICROSTRATEGY, RedCap, EPIC Hyperspace, PowerChart, TABLEAU, PowerChart, PowerBI, Cerner, Caboodle, Clarity, Oracle APEX, JIRA, Github, Slack, Mac, Windows iHealth Technologies, Atlanta, GA

Application Developer

03/01/2008 – 1/2013

Key roles and responsibilities:

• Involved in all the new maintenance tasks assigned to the Data Warehouse team. Involved in the design, development, testing and implementation of the code in the various environments.

• Working with the Business Analysts, Project managers to understand the business requirements and provided information about the existing database model and business logic for the projects that needed enhancements and prepared technical documents thereof.

• Supporting the testing team by sharing the unit test results and by providing the SQL/Unix scripts necessary for comparison of data in various environments like Develop, QA, UAT and Production databases.

• Working with the DBA’s and Team leads by providing release documents with the information on the script changes that needed to be applied to the production systems. As a developer successfully compiled the scripts to the development, UAT and QA environments. CVS manager maintains all the scripts/documents.

• Communicated on a regular basis with the Java front end team during the design, development, and testing phases of a project. Performed impact analysis on all the database related information coordinated the maintenance project with the java team.

• Worked mostly individually on small projects and schema maintenance. Been a part of the large teams for the projects that impacted more than one business area.

• Generated reports for the users to view the data in various databases in SQL and Business Objects. Written SQL reports for the ad hoc reporting. Developed BO Universe based on the database schema and created reports. Written stored procedures for BO reports that involved that complex database logic. Maintained the security and access information of users. Worked mostly on the Medical Policy reporting requirements. Been a part of the various BO upgrades and report conversion activities. Gained familiarity with Xcelsius.

• Involved in ICMS, BRAT, BLAPP, Rules, Report Runner, MONET, WEBTOOL_SO, CITMART, DARE and the day-to-day maintenance of the changes in the health care system. Currently on the ICD9 to ICD10 conversions, 5010 health care privacy system. Also participated in the various software/hardware conversion projects of the company. Technologies Used: Oracle 10g, SQL, PL/SQL, Unix, Business Objects, CSV, Windows United Healthcare Inc, Trumbull, CT

Sr. Programmer Analyst

10/08/2000-02/2008

Key roles and responsibilities:

• Solely responsible for requirement analysis, database design, development and maintaining database repository.

• Proactively maintained and ownership of schema.

• Built and maintained frontend applications using Oracle forms and generating reports.

• Involved in Oracle migration projects and code version control maintenance.

• Played a vital role in database upgrade projects.

• Wrote necessary SQL code to improve performance and UNIX batch shell scripts.

• Built Java Beans in Eclipse, used CGI and Pearl for interacting with C++ scripts to create a workflow for application development.

• Wrote pre-session and post-session SQL commands and UNIX scripts for workflows to capture the metadata from session logs for auditing purposes.

• Converted functional specifications into technical specifications.

• Acted as technical lead in absence of the lead and helped the team to bring the project to an end and signed off on the project for successful completion.

• Developed/maintained applications using Oracle utilities like triggers, cursors, pl/SQL procedures, and functions.

• Enhanced the logics in existing java scripts and java beans.

• We participated in weekly end user meetings to discuss data quality, performance issues to improve data quality and new requirements.

• Oversee large volumes of data and tuned their performance.

• Attend and resolve any issues logged in by the user in the frontend application by training them.

• Worked closely with the TL/Managers to troubleshoot applications issues.

• Designed, developed, analyzed, and provided active support to Quality Team in the implementation of HIPAA compliance for Health Care Industry.

• Analyzed in the Business areas of Group, Member Enrollment, Group Renewal and Billing and developed also customized the applications using Oracle Tools.

• Involved in coordinating the activities of the team, scheduling, and planning team meetings to discuss specifications depending on requirements.

• Demonstrated capability in presentation to end users as a part of training, knowledge transfer. Ability to communicate and work with people of distinct levels of the organization.

• Participated in Training Sessions on various Oracle Modules conducted by Oracle Corp. Technologies Used: SQL, Oracle reports, PL/SQL, Perl, Python, CGI, C++, Shells, Windows

EDUCATION:

• Masters in Commerce and Master diploma in Computer Science.

• Certified in SQL by Oracle

• Certified in Python by New Horizons

• Certified in Power Bi by New Horizon

• Certified in Cogito, Caboodle, Clarity by Epic

Contact this candidate