SUMMARY:

To obtain a Business Intelligence position. I work well in fast - paced environments that require learning concepts quickly and applying them efficiently. I enjoy working with people to analyze problems, conceptualize solutions, and implement changes.

TECHNICAL SKILLS:

Data Modeling: Oracle, Netezza, SQL Server, SAP HANA, Teradata

ETL: Informatica, SAP Business Objects Data Services, SQL Server Integration Services, Alteryx

Dashboards: Tableau, SAP Dashboards, SAP Lumira, SAP Design Studio, Microsoft Power Pivot

Reports: SAP Business Objects Web Intelligence, SAP Explorer, SAP Crystal Reports

Universes: Information Design Tool, Universe Design Tool

Predictive Analytics: R, SAP Predictive Analytics

Programming: SQL, PL/SQL, C#, Visual Basic, PowerShell, Bash, VBA Macros, R-Script, JavaScript

Geocoding: Alteryx

BOBJ: SAP Business Objects Server, BO Data Services Server

DBA: SAP HANA, Oracle, DB2, MS SQL Server

SAP Basis: SAP ECC, Solution Manager, Netweaver, BW on HANA, Portal

OS: AIX, Red Hat Linux, SUSE Linux, Windows Server

Audit: Interworks

Other: Tableau Server, R Server

Documentation: Write up SOPs, POCs, end-user guides/tutorials

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• Lead Tableau Developer for MMA department; focus on automation, scalability, R&D, IP
• Solution & develop architecture for Tableau navigation page linking to standardized dashboards
• Create proprietary Tableau dashboard templates to standardize dashboards & automate dashboard creation
• Architect Tableau back-end connections to facilitate flexibility & scalability across multiple clients
• Develop back-end SQL Server data models to optimize dashboard performance using referential integrity
• Optimize query performance for big data in the health care field; assess execution plan & tune db
• Create macros in Alteryx for Geocoding territories & leveraging predictive analytics
• Use multiple scripting languages to automate publishing dashboards and taking screenshots of dashboards
• Leverage Interworks to mass audit & QA over 50 dashboards simultaneously
• Work with clients to standardize data for consumption in Tableau, Alteryx, SQL Server
• Solution and create proprietary Tableau Sankey Charts, Bivariate Maps, and Templates
• Develop best-practices for dashboards to optimize performance, scalability, automation, documentation
• Train clients and end-users to develop and leverage Tableau dashboards

Confidential

Process Analyst

Responsibilities:

• Reporting lead and ETL lead for all Clarity data
• Work with lead data architect to design Netezza data warehouse
• Design star schema for financial portfolio data mart within Netezza database
• Determine how to maintain data integrity and handle slowly changing dimensions
• Write SQL Queries against Oracle, Netezza, MS Access to automate Tableau dashboards
• Create tables, views, and stored procedures in Netezza for ETL and Front-End reporting
• Collaborate with universe architects to design/modify Business Objects universes for Clarity
• Create Business Objects Web Intelligence reports leveraging multiple universes
• Develop fully automated dashboards in Tableau and publish to Tableau Server
• Combine excel spreadsheets and custom SQL queries to create dynamic reports in Tableau
• Create reports & dashboards from multiple sources using Microsoft Power Pivot
• Develop workflows in Informatica to transform data (surrogate keys, SCDs) and map from source to target
• Setup Infrastructure for Tableau Server; add users, groups, projects to facilitate enterprise usage
• Gather, analyze, report on metrics in an agile environment
• Work with management to standardize processes, data quality, data dictionary, and version control
• Train end-users on how to use Business Objects, Tableau
• Document data requirements, definitions, and procedures for all ETL and Reporting workflows

Confidential

BI Consultant

Responsibilities:

• Consult on multiple projects as Lead ETL Developer, Infrastructure Architect, BI Developer
• Design relational databases and star schemas based on client requirements in SAP HANA
• Collaborate with PMs and business users to determine data warehouse requirements
• Write SQL queries to leverage SAP HANA’s calculation engine and SQL engine
• Use SAP Predictive Analytics to create visualizations with data science functionality
• Develop stored procedures in SQL script to automate ETL
• Create attribute views, analytical views, calculation views, and scripted calculation views for reporting
• Create Business Objects Universes to facilitate front-end reporting
• Audit/modify universes for query performance improvement and data quality
• Create jobs in data services that fully automate staging, loading, deltas
• Add control tables, exception tables, and error handling logic to fully automate ETL jobs
• Create scripts to pull flat files from FTP, transfer to data-load directory, e-mail notification on completion
• Write ETL scripts to implement global variables, invoke stored procedures, truncate tables
• Automate scheduling and running jobs via the ETL management console; alternatively use batch files
• Add TNS connections, ODBC connections, datastore connections; ensure ETL jobs map correctly
• Install & configure Data Services and create central repository for version control
• Create Tableau dashboards based on ad-hoc requirements
• Integrate R into Tableau dashboards to add predictive analytics to current reporting
• Setup & administrate R server to allow dashboards to be developed and viewed on the web
• Create Web Intelligence reports for ETL & reporting purposes, Crystal reports for auditing purposes
• Derive business requirements independently based on a given data-set and create dashboards accordingly
• Write SOPs and end-user guides documenting all business processes
• Install, update, and configuring Business Objects Server & BOBJ Client tools
• Administrate and support Business Objects, SAP HANA, and BW on HANA
• Install, secure, upgrade, and setup infrastructure on Tableau Server
• Configure R to work with HANA & Tableau. Setup security.
• Install and administrate Windows Server 2008, Red Hat Enterprise Linux, SUSE Linux
• Database Administrator for SAP HANA, Oracle, MS SQL
• See projects below:

Confidential

ETL Developer

Responsibilities:

• Develop logic to automate delta loads
• Modify previously created delta logic to allow date ranges to be input variably
• Create batch files to automate running ETL jobs
• Execute ETL jobs across UAT/PROD landscapes using management console
• Create TNS connections and configured datastores to connect to UAT & PROD
• Add error handling tables and logic to delta ETL jobs
• Add control table and logic to delta jobs
• Create scripts to execute stored procedures and refresh views within ETL jobs

Confidential

Lead ETL Developer & Infrastructure Architect

Responsibilities:

• Lead a team of six off-shore ETL developers in creating and supporting ETL workflows
• Develop delta logic for dimension tables and fact tables
• Develop logic for slowly changing dimensions and surrogate keys
• Write SQL logic against a Netezza database back-end to improve ETL performance
• Create PowerShell scripts for SAP Data Services to automate E-mail & FTP features
• Setup infrastructure & security on Business Objects server
• Schedule daily backups of ETL jobs, HANA environments, & Business Objects environments
• Assess & optimize complex HANA analytic and calculation views
• Create crystal reports to reflect BOBJ user activity
• Handle Business Objects & HANA promotions and version management

Confidential

Lead Infrastructure Architect

Responsibilities:

• Install SAP BI Edge 4.0 SP6 on Red Hat Enterprise Linux
• Configure backend connection to HANA from Information Design tool
• Configure backend connection to HANA from Universe Design tool
• Install Business Objects Client Tools 4.0 on Windows
• Create backend connection to data-source from Oracle

Confidential

Dashboard Developer

Responsibilities:

• Configure Tableau Server for full integration with R Server
• Develop complex salesforce worksheets & dashboards in Tableau
• Develop Tableau dashboards integrated with features from R

Confidential

Infrastructure Support

Responsibilities:

• Modify existing business objects infrastructure based on business needs
• Configure Business Objects to optimize performance based on server architecture
• Develop infrastructure rules to facilitate administration

Confidential

ETL Support

Responsibilities:

• Work with client and lead ETL developer to determine data loading requirements
• Assist in developing and executing data loads by mapping data from source to target
• Monitor existing data loads for quality assurance

Confidential

SAP Basis Consultant

Responsibilities:

• Responsible for configuring, tuning, securing, and monitoring ECC, BI systems
• Perform database support/administration: backup/archive, query optimization
• Provide OS support/administration: analyze system logs, resolve issues
• Work with clients to model data to accommodate business needs
• Tune and optimize existing SQL queries to leverage DB2 and SQL Server db architecture
• Monitor existing workflows to ensure timely and accurate data loads
• Work with ETL developers to troubleshoot loading issues and modify existing ETL processes
• Collaborate with business users to determine relevant metrics for dashboards
• Work with developers to troubleshoot issues in existing dashboards
• Create Web Intelligence reports to display overall system health
• Develop Web Intelligence reports containing relevant KPIs to monitor system performance
• Work with clients to develop actionable system monitoring processes
• Work with business users to determine and improve relevant KPIs

Confidential

Mortgage Banker’s Assistant

Responsibilities:

• Create a relational database to store and track prospective clients, warm leads, and appointments
• Setup tables to store and monitor outgoing calls, relevant information, and sales performance
• Work with Business owner to define metrics for assessing sales health and performance
• Write SQL queries to facilitate data analysis based on ad-hoc requests
• Create data models that assess sales representatives’ performance
• Create processes that load business data into the database
• Create dashboards to facilitate data gathering and appointment setting
• Create reports displaying overall company performance and individual sales reps performance
• Call prospective clients and warm leads looking to start or refinance a mortgage

Confidential

Loan Servicing Specialist II

Responsibilities:

• Analyze mortgages to determine if changes in foreclosure status will impact claims
• Assess previous and upcoming expenses incurred and claim maximum amount
• Determine relevant metrics that indicate loan servicing performance and improvement
• Meet with management to discuss leveraging BI for process improvement

Confidential

Financial Representative

Responsibilities:

• Design personal database to track and assess individual performance
• Create data models that calculate individual performance statistics
• Write SQL queries aggregating historical performance
• Create processes to load and track historical data
• Create dashboards and reports to display portfolio statistics and performance
• Meet with clients and build financial portfolios for clients based on their needs
• Create financial models and forecasts that predict future net-worth
• Resolve problems for new and existing customers in person and over the phone