Dynamic and results-driven Business Intelligence developer with 15 years of experience in designing, developing, and implementing business intelligence solutions. Well-versed in Agile methodologies and practices, ensuring efficient project delivery and adaptability to changing requirements. Passionate about cultivating collaboration as a cornerstone for team development. Eager to leverage skills in data warehousing, self-service analytics, and cross-functional team leadership as a BI manager, lead BI, or data analytics leader. Creative and proficient at crafting interactive ad-hoc and automated reports, as well as designing portals and dashboards to analyze data effectively. Skilled at identifying trends and opportunities that can positively impact the enterprise and empower decision-making from the results. Skilled in optimizing data retrieval processes and ensuring data accuracy and integrity. Expert at complex SQL queries from multiple database sources for the purpose of answering business questions.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Business Intelligence Developer
Amerisure Insurance Company
04.2015 - Current
As part of Amerisure Advantage Project, responsibilities include coordinating contractors and stakeholders to develop new Billing reports and update existing ones. This involves conducting quality code reviews, managing code migration, coordinating User Acceptance Testing (UAT) approval process, and scheduling reports using Tidal.
Participated in WebFOCUS upgrade project, which involves migrating code to WebFOCUS 9.2, setting up new servers, and coordinating User Acceptance Testing (UAT) and Production migration
As part of Claim Center Upgrade, responsible for coordinating and reviewing test plans, preparing test data and cases, verifying application against specifications, and documenting results for unit integration and QA testing.
Played crucial role by developing and maintain 7 ARAS control reports which helps to capture precise data needed for comprehensive analysis and decision making by delivering these reports to User Email along with Report Library.
Coordinating with Business and Product owners to prioritize backlog to inclusion in sprints or Program increments (PIs.)
Offering comprehensive mentorship to new colleagues, aiding them in quickly acclimating and excelling in their roles
Establish best practices and standards for BI development and data governance
Working with stakeholders to outline business requirements and transform them into technical specifications
Updating BI Interactive Portals with new reports which provides access to Claims data as well as Operational and regulatory Reporting
Using PL SQL Developer to write SQL Queries for backend testing
Interface with customer to understand requirements and analyze specifications
Resolve Complex Reporting Issues
Utilize Report Caster to schedule and distribute developed reports to Report Library
Analyze, Document and Transform user requirement as per technical Specs
Create and customize various reports using WEBFOCUS GUI tools like Report Assistant and report Painter as per business requirements
Worked on Data Servers, Graphs, MRE, Info Assist, Excel Pivot tables, Active Reports, Drill downs, Complex Parameterized reports, proficient in SQL, JavaScript.
WebFOCUS Developer
Ford Motor Credit Company
04.2011 - 04.2015
Conducted thorough analysis of Business Objects universe to facilitate seamless data retrieval within WebFOCUS
Played key role in design and development of 3 WebFOCUS applications using WebFOCUS Developer Studio
Formatted reports according to user specifications, employing drill-down functionalities, functions, and formulas
Created reports with multiple data providers and developed Info Assist Business Views for Ad hoc reporting
Designed compound reports to consolidate multiple reports into single cohesive document
Implemented synonyms using data adapters and conducted in-depth analysis of master files for reporting and design purposes
Developed customizable Dashboard Templates, providing foundational framework adaptable to specific business needs
Enhanced database performance by optimizing performance through shortcut joins, improving query efficiency
Utilized focus coding to implement diverse styles in reports to align with project requirements
Developed and debugged complex stored procedures in MS SQL Server, utilizing cursors for efficient data processing
Collaborated with Information Builder's technical support team to address tool-related issues effectively
Leveraged WebFOCUS dashboards for comprehensive managerial analysis of multiple reports
Provided technical assistance and conducted user training sessions to ensure smooth adoption and utilization of reporting tools.
WebFOCUS Developer
Hess Corporation
10.2010 - 01.2011
Objective of this project is to Install, Configure and secure WebFOCUS environment and converts existing Crystal Reports to WebFOCUS reports
Created advanced-level reports featuring drill down capabilities to provide extensive detail
Proficient in developing interactive dashboards using WebFOCUS Visual Discovery Analytics, implementing Pass-through SQL for SQL query execution, and integrating JavaScript for user parameterization in interface pages
Collaborated with Client Management and IT Staff to gather functional requirements, guiding the development of applications
Worked closely with development teams Onsite and offsite to manage MRE domains, users, and groups, conducted unit testing with summarized test data, and delivered technical support and user training
Key Results: Converted close to 30 crystal reports into WebFOCUS Reports
Developed Reports for Sales Department to analyze Sales trends in USA
Designed Sales Dashboard and Analytical tools to enable users to get real-time updates on business Performance on demand.
Education
M.S. in Software Engineering - Software
Startford University
Falls Church, VA
10.2009
Bachelor of Technology -
JNTU
Hyderabad
04.2007
Skills
PL/SQL
ORACLE 8i/9i/10g
JavaScript
Business intelligence tools
SQL Programming
Report Design
Data dashboard design
Project Management
Business Analysis
Visualization techniques
Agile
Cross-Functional Collaboration
Agile development methodologies
Certification
Project Management Professional (in renewal process)
Timeline
Business Intelligence Developer
Amerisure Insurance Company
04.2015 - Current
WebFOCUS Developer
Ford Motor Credit Company
04.2011 - 04.2015
WebFOCUS Developer
Hess Corporation
10.2010 - 01.2011
M.S. in Software Engineering - Software
Startford University
Bachelor of Technology -
JNTU
Similar Profiles
Ashley Archey AllenAshley Archey Allen
Commercial Lines Underwriter/Marketing Underwriter at Amerisure Insurance CompanyCommercial Lines Underwriter/Marketing Underwriter at Amerisure Insurance Company