Senior Business Intelligence Developer Resume
3.00/5 (Submit Your Rating)
Orlando, FL
SUMMARY:
- An accomplished IT professional with 12+ years of proven experience leading high - value technology, engineering, and development projects for large enterprises.
- Expert in managing the end-to-end project lifecycle, from requirements gathering to development, deployment, and user support.
- Adds value by partnering cross-functionally with internal and external stakeholder groups to deliver the highest levels of quality, productivity, and efficiency, leveraging data to support business growth.
TECHNICAL SKILLS:
Operating Systems: UNIX, LYNIX, WINDOWS
Data Bases: Teradata, Oracle, MSSQL, INFORMIX
Open Sources: Big Data HDFS
Programming: SAS, SQL, Hive, Python, Scala, Unix shell scripting
Tools: SAS, SAS Data Integration Studio, Tableau, Hadoop, Teradata Administrator, Teradata SQL Assistant, TOAD Datapoint, Github, Global Scape EFT, Hue, Adobe Campaign Manager
PROFESSIONAL EXPERIENCE:
Confidential, Orlando, FL
Senior Business Intelligence developer
Responsibilities:
- Developed and implemented the ETL process using SAS, Teradata, and Hadoop to access data from various sources to populate data repository.
- Created data schemas by mapping respective tables in Teradata repository in Adobe campaign management, further utilized by workflow managers.
- Oversaw Teradata, Adobe Campaign, SAS, UNIX, and Global Scape EFT environment to ensure all systems were up and running so business partners were not impacted.
- Created BI environment with SAS/EG and SAS Information portal.
- Integrated data from various sources (Teradata, Hadoop, Greenplum, Oracle, ODBC) and different forms of write back data to enable users to access and visualize using SAS and Tableau.
- Managed metadata, including setting up to access various diversified data sources and open source data.
- Performed user management, setting up access controls for SAS users on UNIX, using SAS Management console based on roles and responsibilities.
- Took the lead in creating various stored processes to support users with the handling of projects efficiently; wrote UNIX Shell and SAS Scripts to automate jobs and SFTP files.
- Created a centralized data repository into Adobe campaign management applications so campaign managers could quickly generate workflow, visualize messaging, and deploy data to email/direct/SMS service providers
- Successfully designed and deployed the data repository on Teradata for easily accessible data to Adobe campaign environment; migrated 10TB of data and database objects from one Teradata environment to another.
CRRM Performance Metrics
Responsibilities:
- Leveraged a strong understanding of the complete business process to gather requirements and develop a data model that met strategic objectives.
- Designed, developed, and completed the ETL process, and implemented using SAS scripts.
- Maintained key involvement in the process and data migration from Oracle to Teradata, as well as the design and development of an intranet security system for OLAP applications and MIS reports.
- Utilized advanced Tableau features: data blending, quick filters, actions, hierarchies, LOD calculations, and custom geocoding.
- Created multidimensional OLAP cubes and published using SAS portal for Business Analysts and marketing executives.
- Defined new projects based on user requirements and modifications to the existing projects with SAS Enterprise guide, resulting in a new reporting and analysis environment.
CRRM Performance Metrics
Responsibilities:
- Automated complete processes with integration of UNIX Shell and SAS Scripts; converted Informix SQL scripts to SAS programs.
- Provided end user support on an ongoing, day-to-day basis through administration and maintenance of metadata and data repository using SAS Enterprise Guide.
- Configured Apache web server and tomcat application for SAS/IntrNet and SAS/WebAF applications.
Enterprise Wide Data Warehouse
Responsibilities:
- Created routines to load data warehouse for Professional, Institutional, and Pharmacy claims; additionally, created SAS routines for edit check, range checks, and other validation processes adhering to existing business rules in UNIX.
- Simplified programming complexities for other developers by writing various parameter-driven generic macros.
- Played a key role on multiple cross-functional teams, driving quality audits and training and administering users on software implementation.
- Oversaw the development and reporting of time sensitive, quarterly, monthly, and weekly reports to business partners and government agencies in a range of formats.
- Led monitoring and provided ongoing support of critical data warehouse load processes, ensuring 100% compliance with Sarbanes-Oxley (SOX) regulations.
- Compiled detailed documentation for programmatic logic used for automating the data validation and loading process.
