Sr. Architect/Developer/Administrator - IQVIA - Durham, NC
(2015-05)
Lead team in providing application support for distinct BI products, in 10+ environments, encompassing 50K+ reporting objects, over 10,000 users, and 500+ schedules.
- Lead several upgrades and migrations (major and minor versions) of the analytical products (Business Objects, Power BI, Tomcat and SQL Server).
- Managed user roles, permissions, and licenses for both products.
- Designed and deployed highly interactive dashboards and reports, improving data accessibility and driving key strategic decisions for internal stakeholders.
- Spearhead effort to consolidate data sources into a centralized data warehouse, reshaping strategy to solving business problems through root cause analysis and proactive responses based on predictive analytics, improving the quality of customer experience and data discrepancies.
- Provided end-to-end design and development of the services, processes, policies, and procedures.
- Drive efficiency through delivery of self-service technology options, allowing for teams to access on-demand data for ad hoc and ongoing reporting needs.
- Implemented row-level security to restrict the data based on the user roles.
- Trained users with new functionality and features available to make informed decisions.
- Implemented SSO and Integrated tools with other products for seamless integrations.
- Engineered the global governance, security frameworks, and capacity planning for both SAP BusinessObjects (3x/4.x) and Power BI environments; orchestrated complex multi environment BO upgrades while strategically leading the modern legacy to cloud transformation by migrating on-premises Business Objects components, universes, and WebI workflows into optimized Power BI Premium datasets and hybrid gateway architectures.
BI Architect - BCBSNC - Durham, NC
(2008-04 - 2015-05)
Led team in conceptualizing and implementing innovative processes and technical solutions to maintain and retrieve analytical healthcare data with focus on user experience, productivity, and performance while maintaining healthcare privacy regulations and standards; and driving productivity gains through decreasing maintenance and required application upgrades.
- Set standards for completion of project deliverables through implementation of lean methodology and redefining the SDLC process.
- Partnered with business unit to gather business requirements and utilized technical solutions to transform processes, eliminating 2000+ hours of manual efforts each year.
- Created client savings through consolidation of product licenses and negotiating vendor contract rates, achieving $120K costs savings each year.
- Reshaped organization of the analytical object repository through migration and decommission of corporate data warehouse (CDW) to enterprise data warehouse (EDW), leading to improved user navigation and access to applicable diagnosis codes and other operational items along with the elimination of duplicate objects.
- Achieved centralization of analytical product support and minimized object redundancy through streamlining of processes, resulting in single point of contact to address concerns and decreased in cost associated with software licensing.
- Recognized for improved customer experience throughout the organization by introducing self-service technical tools, generating usage dashboards for executive leadership teams allowing for improved decisioning and transparency.
- Functioned as liaison between application and vendor support to ensure cohesive support in place while administering support for firms' analytical product tools and communicating application health to management team via on site monitors and reporting.
- Formed Center of Excellence and provided support for multiple tools and data related queries.
- Developed a process and introduced new technologies to store and retrieve the analytical content.
- Written programs to collect the metadata of all reporting objects and created dashboards to identify data sources, duplicate reports, and consolidation data sources and reports.
