Team Lead Business Intelligence Manager Resume
Harbor, FL
SUMMARY:
Results - driven, dedicated, and highly accomplished hands-on leader with exceptional IT experience in application management, data analysis, management of off-shore resources, project management, software development and testing.
EXPERIENCE IN GOVERNMENT, FINANCIAL, AND TELECOMMUNICATION INDUSTRIES AS FOLLOWS:
- Application Manager
- Project Management
- Team Building
- Business Analyst
- ETL Processing
- Strategic Planning
- Architectural Lead
- Data Warehousing
- Offshore Development
RECENT COMPUTER SKILLS:
SQL Server 2005/2008R2/2012, SSRS, SSAS Analysis Services (both Multi-dimensional and Tabular), Power BI, Azure, Tableau, QlikView, SAP Business Objects, SSIS, PaaS, Visual Studio 2008/2013, Data Modeling, Visio, OLAP development, ETL processing, VB.NET, JavaScript, ASP, HTML, MDX, Direct Query, Microsoft Team Foundation Server (TFS), Beyond Compare, Pivotal Tracker
PROFESSIONAL EXPERIENCE:
Confidential, Harbor, FL
Team Lead Business Intelligence Manager
Responsibilities:
- Virtual One Stop and GSI Unemployment System are web-based applications used by States across the country for assisting job seekers in finding employment and obtaining unemployment benefits.
- Interviewed, hired, trained and am currently managing Business Intelligence Team, responsible for all agile Confidential reporting solutions for unemployed job seekers and unemployment Confidential ETA Reporting.
- This includes over 600 reporting solutions, including SSRS RDLs, .NET RDLCs, .NET search pages, Cloud Dashboards, Tabular Analysis, OLAP Multi-dimensional Analysis including creation of calculations needed for Forecasting, Universe creation via ETL development, and Ad-Hoc reporting Tools, tasks managed via Agile tool Pivotal Tracker, team discussions Confidential daily SCRUM meetings.
Confidential, Tampa, FL
Application Programming Manager
Responsibilities:
- Interviewed, hired, trained, and was Independence and Compliance (I&C) Development Lead (Oracle DB) for the Confidential application, interacting with a Java frontend. .NET, Oracle 11g, ETL, Data Warehousing, Informatica, Cognos, Lotus Notes, PerForce, DB Artisan, Eclipse, WebLogic, Cruise Control, DB2, Erwin Modeler, Visio, Documentum, Requisite Pro, JTest, Fortify360, WinSCP, Siteminder
- Participated in initial Vendor Selection meetings for I&C Rules Engine and Data Integration (Purisma) tools.
- Assisting in Project Planning (Project Server), establishing Task Estimates and Scheduling to insure alignment/availability and proper resource staffing.
- Was recognized for leading the translation of client facing business conversion requirements and Confidential data models into strong ETL conversion designs. In order to keep Staff off the new Production environment, established data warehouse from ETL processing to an IBM Cognos interface with data pre-mapped and labelled with business friendly terms for easy Staff navigation.
- Lead Confidential offshore tasks of new development ( Confidential, Uruguay), implementing both low level and high level design documentation, tasked and reviewed prior to implementation.
- Was representative (Global) for Independence and Compliance (I&C), Architectural Data Model Review Committee
- Was SME for Confidential, ETL Data Conversion, Rules Engine Team, Confidential Reconciliation, and I&C Architecture.
- Was US IT Representative for the Big 4 Financial Firms’ " Confidential " performing roles of Architect/BA/PM/Tech Lead on Firm Contribution
Confidential, Odessa, FL
Software Engineer
Responsibilities:
- Design, creation, and support of external 3-tier interactive client website (Reports) ASP.Net / VB.Net / Ado.Net / XML / HTML / Javascript / SQL Server 7.0 / Crystal Reports 8.5 Interact with end-users on reporting design and application ASP.Net / VB.Net / Ado.Net / XML / HTML / Javascript / SQL Server 7.0 / Crystal Reports 8.5
- Design/implement circuit board testing software via data acquisition module for Engineering and Production departments VB6 / SQL Server 7.0 / Crystal Reports 8.5 Design, develop and support internal company software, database design, and reporting VB6 / SQL Server 7.0 / Crystal Reports 8.5
- Design, creation, and support of billing program VB6 / SQL Server 7.0 / Crystal Reports 8.5
Confidential, St. Petersburg, FL
Programmer Analyst
Responsibilities:
- Design, maintain, administer and document multiple adhoc database system designs Access 2000 / ODBC SDK 2.0 C++ / SQL Server 7.0 / MS-DOS / VBA ·
- Capture and trend call center information off Lucent switch for E-Business reporting ASP / ADO / CenterVu 8.0 / IEX TotalView / Telemate / SQL Server 7.0 / Crystal Report Writer 7.0 / Access 2000 / VPN ·
- Analyze and implement solutions for daily call-routing comparisons utilizing pass-through queries and stored procedures (database analysis through entity-relationship models and database schemas)
- Access 2000 / SQL Server 7.0 / Excel 97 / VB6
Confidential, Jacksonville, FL
Programmer - Contractor Modis
Responsibilities:
- Created Confidential financial database according to client specs Access 7.0 / SQL Server 6.5 / Transact-SQL / Excel 7.0 / VB5
- Documented methods and procedures and trained end-users on the functionality of their new system
- Confidential design / Word 7.0 / PowerPoint 7.0
Confidential, Jacksonville, FL
Systems Analyst
Responsibilities:
- Maintained end-user support for problems and enhancements of current database Access 7.0 / Transact-SQL / Excel 7.0 / VB5 ·
- Created instances and developed database backend; designed stored procedures and pass-through queries (utilizing ODBC drivers) to link the two platforms Developer
- Oracle7 / Access 7.0; SQL Plus and SQL Navigator
Confidential, Jacksonville, FL
Senior Team Supervisor
Responsibilities:
- Responsible for development and upgrade of system databases (including triggers and stored procedures DBA: Oracle7 / Access 7.0; VB5, PL SQL / Transact-SQL · I nternal contact of financial/system reporting and forecasting for both Service and General Managers DB2 / Access 7.0 / CMS / Oracle7 / IEX ·
- Gathered and forwarded weekly/monthy Conversant reporting information to Client Oracle7 / Excel 7.0 / DataDirect ; PL SQL ·
- Developed and produced accurate weekly/monthly ERF package reports Batch job runs, RTN/DNIS Mapping, Oracle7, DataDirect ·
- Programmed and designed new queries and reporting materials to capture new Conversant/VDN data per Client's specifications through established partnerships with CMS, CCDM, Conversant, and Confidential groups, along with System Support DataDirect / Oracle7 / Confidential