6/5/2023 0 Comments Caboodle database![]() Architect the data warehouse technology and solutions serving internal and external customers.Performed Day-to-day DBA functions on SQL Server environments. ![]() ![]() C reate d IBM Cognos & Confidential Clarity training documentations and train co-workers.Designed and developed data ELT back-end processes using Oracle Data Integrator 12c for financial and clinical applications and Tableau reporting.Migrated the Cognos 8.4.1 infrastructure from old to new environments.Supported the Confidential 2014 Clarity & Caboodle ETL & Database Administration in PRD environment.Provided Caboodle ETL development and created custom Clarity SSIS packages and tables for data integration Non- Confidential data in Caboodle for Pharmacy, HealthPlans, Outside Billers providers, using SSIS & SSAS.Analyzed the EMR data mappings, created sql scripts and extracted the discrete Scanned Images and Documents data for the last 10 years from the old legacy source EHR system into flat files format, validated & imported the extracted output files to DataFirst.Performed Day-to-day remote DBA functions on Confidential SQL Server environments: monitoring, troubleshooting, business needs support, SSIS development, tuning of SQL query, supported reporting needs.C reate d Confidential Clarity, Caboodle and Reporting technical material s and train ed co-workers.Developed Confidential Reporting Workbench & Crystal reports logical modeling and presentation solutions.Provided Caboodle ETL development and created custom SSIS packages and tables for data integration Non- Confidential data in Caboodle.Analyzed & supported reporting needs, tuned and optimized existing Confidential Crystal reports sql queries.Performed day-to-day Confidential Clarity & Caboodle Administration, ETL Development & data conversion : monitor and resolved Clarity & Caboodle ETL & DB’s performance issues, troubleshoot extract error messages, load failures, SU upgrades, BI SSIS & SSAS cube development, evaluated and translated clinical requirements into necessary IT specifications for reports, dashboards, and workflows.Applied Confidential Special Updates (SU) for Clarity in TST & PRD environments, supported the systems performance (Console, Compass & Hyperspace), created and scheduled Clarity ETL extracts, resolved Clarity ETL performance issues, troubleshoot extract error messages, load failures, data and table issues, maintained custom KB-SQL code and etc.Provided activities related to the Confidential Accordant project: installed Confidential Clarity & Caboodle POC & TST environments & SlicerDicer, performed cutover Confidential settings from POC to TST, maintain custom KB-SQL code to deliver accurate data, supported crystal reports development needs.NET, Component Services Manager, Erwin, BizTalk Server, TOAD, Crystal Reports, Infoview, Visual SourceSafe, Legato Disk Extender, Veeam 8.0, SSIS, SSRS & SSAS Tools: Oracle Data Integrator Studio 12c, Tableau, Idera (SQL Diagnostic Manager), Talend, Qlickview, Quest (Foglight, Spotlight & Performance Manager), Veritas, Tivoli, MOM, Visual Studio. Languages: PL/SQL, Transact-SQL, Exasol, MS Visual Basic 6.0, VB.NET, C#, HTML, ASP, XML, VBScript and JavaScript, Web Services, VMWare vSphere Proven ability to communicate and work well with co-workers, end-users and clients on all levelsĭatabases: MS SQL Server 2014/2012/2008 R2/2005 & Oracle 12c/11g/10g/9i, MS Access 7.0/2000/2003.Excellent analytical, management, self - managing, logical and troubleshooting skills.Over 6 years of experience on Confidential Clarity & Caboodle Administration, ETL Development & data conversion, Confidential Crystal Report, Radar & Reporting Workbench. ![]()
0 Comments
Leave a Reply. |