Business Intelligence Manager Resume
Birmingham, AL
PROFESSIONAL EXPERIENCE:
Confidential, Birmingham, AL
Business Intelligence Manager
Responsibilities:
- Lead the development activities for business intelligence solutions including supervising daily operations of a team of BI, Report, and ETL Developers
- Apply knowledge of database design, ETL data flow, and business intelligence reporting techniques to lead the development of solutions in transforming data into reporting solutions
- Gather Business Intelligence requirements from clients and key department managers to build business requirements and processes to develop, support, and modify existing systems
- Manage projects and request through JIRA Kanban
Environment: and technical skill highlights: SQL, TimeXtender/Discovery Hub, SQL Server, Qlik, JIRA
Confidential, Birmingham, AL
Business Intelligence Manager
Responsibilities:
- Manage the build and maintenance of division data warehouse and reporting
- Participated in end - to-end implementation of property and casualty data warehouse including the design using star-schema, ELT data build, and the development of new end-user reporting
- Develop and manage a wide range of Tableau and Business Objects Webi reports from individual ad-hoc to dashboards that track underwriting activity, profitability, goals, and forecasting
- Meet with business management and underwriters to define requirements, provide estimates, and deliver reporting product
- Perform complex SQL queries for research, ad-hoc reporting, and testing to SOX standards.
- Performed beginner and advanced Business Objects training for end-users
- Developed Campaign Management process that includes creation of email distribution input for e-mail marketing software and ties responses to underwriting activity in Campaign Data Mart
- Developed ingestion process for agent policy feeds that in addition to staging for source system includes error resolution functionality
Environment: and technical skill highlights: SQL, Sunopsis/ODI ELT Tool, IBM DB2 on iSeries (formally AS/400), Tableau, SAP Business Objects BI Platform, BO Dashboard (formally Xcelsius), ERWIN
Confidential, New York, NY
IT Business Analyst
Responsibilities:
- Research, define, and document business requirements for Corporate Trust projects
- Facilitate project meetings with business partners to understand and define requirements
- Manage system enhancement request
- Provide testing and problem resolution
Environment: and technical skill highlights: SQL, VB Macros
Confidential, New York, NY
IT Business Analyst
Responsibilities:
- Facilitate meetings with business management and underwriters to gather and define specific business requirements for system enhancements
- Translate business requirements into functional and business process design, and workflow for system programming
- Conduct and participate in walkthrough of requirements with developers and management
- Perform QA testing and document results for audits
- Maintain documentation to include business requirements, business process flows, table configurations, system designs, test plans & scripts, communication plans, and training documents
- Provide production support with research and resolution of application or data related issues
Environment: and technical skill highlights: IBM DB2 on iSeries (formally AS/400), SQL, Microsoft Office, WINS Insurance Software
Confidential, Saint Louis, MO
Programmer/Business Systems Analyst
Responsibilities:
- Served as part of Enterprise Solution Design Team that analyzed and set rules to convert data from AT&T business customers to multiple billing media
- Client contact to define requirements for bringing in new providers to AT&T’s Enterprise database
- Extensive testing of final product to ensure data met quality standards
- Point of contact for functionality agreements between different areas of system environment
- Used existing COBOL programs and SQL to aid in mapping, testing, and defining new system requirements
- Wrote VB Macros to expedite mapping process
Environment: and technical skill highlights: XML, DB2, File Aid, QueryMan, SQL
Confidential, Little Rock, AR
Programmer/Analyst
Responsibilities:
- Participated in all phases of software development life cycle for major projects as COBOL programmer
- Responsibilities included upgrading ALS/AF software for increased functionality, running and supporting batch cycles, testing final product, and development of system change controls
- From business requirements, wrote technical requirements and created extract files for numerous vendors
- Provided system incident research, resolution, and documentation of solution
Environment: and technical skill highlights: Mainframe, COBOL, JCL, ALS/AF, File Aid, Max, Endeavor, API/RPI