Director Business Intelligence, Compensation Resume
Lawrenceville, GA
SUMMARY:
- Strong experience in leading and supervising the business intelligence department
- Results - oriented with proven records of business intelligence and analytics experience
- Experience in working with business intelligence tools, advanced visualization tools and applications
- Proficient in various computer languages and programming
- Strong analytical, statistics, organizational, and computer skills
- Excellent knowledge of both relational databases and data warehouse architecture
- Experience with hiring, mentoring, and supervising team
- Excellent in converting business requirements into a robust technical design
- Excellent facilitating skills, and proven ability to partner with leadership in solving complex problems.
- Experienced in designing and implementing robust ETL and BI systems
- Experience in defining BI Vision & Roadmap for various business functions
TECHNICAL SKILLS:
- Enterprise Data & Business Intelligence Architecture
- Data Integration: Data Warehouse and ETL. Data Cleansing, Staging, etc
- Develop complex ETL mapping using in Informatica PowerCenter.
- Developing report using Tableau, Cognos and OBIEE
- Experience with data architecture development.
- Experience in data integrity, security and application performance.
- Experience in creating technical specifications and manages test case development.
- Experience in data modeling design and Analysis.
- Experience in troubleshooting, technical support, report design, knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
- Preparing Dashboards using calculations, parameters in Tableau.
- Informatica, Tableau, ODI, Dimensional data modeling, ETL Applications, UNIX, Linux, Oracle, Designing and mapping workflows, SQL Queries, Oracle PL SQL
WORK EXPERIENCE:
Confidential, Lawrenceville, Ga
Director Business Intelligence, Compensation
Responsibilities:
- Oversaw development, improvement, and management of worldwide compensation payment platform,
- Oversaw, developed and implement database systems for worldwide compensation calculations and payments
- Oversaw, design and implement all business Intelligence reporting systems and applications
- Provides technical support to business intelligence platform, diagnosed and resolved problems on same.
- Led development and implementation of the company's central commission calculation system reports with all new metric-unified warehouse reports for sales, compensation, commission, marketing and revenue management.
- Responsible for architecting, scoping and developing all analytics and reports used on commission and compensation for the company.
- Refined corporate data handling for and commission and compensation reporting
- Manage team responsible for data acquisition, data modeling, and data presentation
- Provided a roadmap for data architecture, data governance, business intelligence and analytics
Confidential, Plano, TX
Business Intelligence Manager / Tableau Server Administrator
Responsibilities:
- Partner with Departments COE Managers to develop Reports and implement analytics strategy
- Coordinated with various stakeholders and management for execution of project appropriately.
- Prepared project scope and informed higher management on a regular basis.
- Developed project plans, prepared a schedule and ensured work according to same.
- Effectively apply Agile software development process, managing entire business intelligence development life cycle from concept through definition, development, and market delivery for new Reporting tool System
- Lead teams of developers to provide the reports, measurement of the metrics, dashboards and business intelligence to the product group that they are responsible
- Building, implementing and optimizing operational Reports delivery models
- Manage a wide variety of customer-data focused ad hoc analyses involving complex experimental designs, fast-turn BI information requests, and extensive business unit engagement across the enterprise
- Develop data integration solutions leveraging multiple disparate sources
- Support individual projects
- Ensure data security and privacy
Confidential, Charlotte, NC
Lead BI/ Sr. Tableau Developer / Consultant
Responsibilities:
- Provides leadership to deliver creative and efficient technical business intelligence solutions.
- Converts business requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing to enable and support managing operating systems.
- Designs and creates data views with SQL and influences decisions regarding infrastructure and back-end data solutions in order to enable evolving analytical needs.
- Designs and develops Teradata data structures based on reporting requirements.
- Utilizes Business Intelligence applications and products to develop executive dashboards and operational scorecards.
- Leads the development of strategic plans for projects of high business complexity.
- Works with delivery managers to design business solutions by applying the right technology.
- Works with development team to transform requirements in to solutions design.
- Works with the business to ensure conformity to business objectives.
- Monitors project metrics for early detection of significant deviations in quality, cost, or schedule
- Monitors and reports all project risks and issues; leads mitigation and resolution efforts to limit risks
- Facilitates scrum and status meetings
- Coaches and mentors’ individuals on the project teams and provides feedback on performance to their leaders
Environment: Tableau Desktop 9x, Tableau Server 9x, Teradata
Confidential, Johns Creek, GA
Developer / Data Analyst
Responsibilities:
- Designed DW tables, scripts and ETL mappings.
- Use Tableau to create Dashboards in latest Design and Presentation.
- Created Rich Dashboards using Tableau Dashboard and prepared user stories to create compelling Dashboards to deliver actionable insights.
- Created visualization for human resource department analysis.
- Creation of metrics, attributes, filters, reports, and Dashboards.
- Created advanced chart types, visualizations and complex calculations to manipulate the data
- Worked on the development of Dashboard reports for the Key Performance Indicators for the top management
- Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
- Documented and maintained ELT specifications and processes.
- Analyzing Business requirements and translation into data modeling requirements.
- Develop aggregated Tables for Tableau to consume using PeopleSoft database and Informatica PowerCenter.
- Designed and implemented ETL processes and associated data structures for Data Staging, Slowly Changing Dimension (SDC), and Surrogate Key Generation.
- Testing and modifying codes for quality.
- Good exposure on Data Modeling and Data analysis.
Environment: Tableau Desktop 8x, Tableau Server 8x, Tableau Reader, OBIEE 10g, 11g, Informatica Power Center 8.1.1/7.1.2 , ODI 11g,12c, SQL Developer, Oracle 10g/9i/8i, MS SQL Server 2000/2005,2008, TIBCO.
Confidential, Statesboro, GA
Project Manager
Responsibilities:
- Setting budgets and approving project scales and deadlines with clients.
- Setting up weekly internal and external meetings on progress.
- Maintaining client relationships.
- Responsible for detecting, examining, measuring and supervision project risks.
- Confirming that projects conform to agile methodology and required standards.
- Producing project definitions to include validated functional requirements, scope, roles, responsibilities, budgets, timescales and resources.
Environment: Tableau Desktop, MS SQL Server 2000, Microsoft Office
Confidential
Information Security analyst
Responsibilities:
- Conduct network vulnerability assessments.
- Identify system vulnerabilities and develop alternative plans and security procedures.
- Create gap analysis report using Tableau
- Use Tableau to develop endpoints and hit count report base on location, and business unit.
- Detect machine with missing security endpoints.
- Assist in troubleshooting tier two security problems.
- Monitor the security of critical systems.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Organized meetings with the various teams to develop use cases and document them.
Environment: Tableau Desktop, Tableau Reader, Microsoft Excel, Microsoft Access, HTML, CSS.