Data Engineer/Data Analyst/Tableau Developer Resume

SUMMARY

Developed an optimized and efficient code base for the User Interface servicing fixed income traders for a leading asset management system
Defined Use cases from requirements and helped convert them into report specifications
Created Unit testing, System testing, and Performance testing for enterprise deployments and conversions
Provisioned servers for production, UAT and development environments including replication, mirroring and clustering
Extensive experience in MS, SQL - Server 2016 (T-SQL) database design and development in writing Constraints, Indexes, Views, and Stored Procedures
Analyze tables and structure of company s databases to establish knowledge of data for accurate retrieval and use in report writing

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer/Data Analyst/Tableau Developer

Responsibilities:

Design, develop, deploy and maintain large scale Tableau dashboards for Product Insight, Devices and Networking, and Cox Premise Equipment
Design and develop Oracle SQL objects including tables, views, and stored procedures to support Peregrine project, CPE and PACE
Created industry standard marketing workflow using customer churn, net promoter score NPS, and campaign responses in every step of the sales funnel
Analyze and provide ETL recommendations for Informatica workflows
Migrate SAS workflows to Tableau for PACE project
Lead system discovery meetings with end-users, stakeholders, and business owners to ensure dashboard requirements, accuracy, and responsiveness
Optimize queries to ensure responsiveness for reduced production windows and high velocity volume growth

Confidential

SQL Developer/ETL/DBA

Responsibilities:

Designed and developed Enterprise Data Platform and Data Warehouse solution for efficient use in reporting
Design, develop, maintain, schedule and enhance ETL processes with Lending Club, Moody’s Analytics, Wells Fargo, Covius, DeFi, Conduent, and FIServ
Developed integration workflow strategy for multiple disparate systems including mainframes, web, scanned documents and relational databases
Routinely interacting with end-users, stakeholders, and business owners and involved with every phase of development lifecycle from requirements gathering to implementation and user training
Develop T-SQL code, stored procedures, views, functions, and other database objects to supply data for downstream applications and fulfill business requirements
Develop and maintain code review, process flow diagrams, runbooks and technical documents including ERWIN data models and data dictionaries
Championed the use of best practices by architecting and implementing IT standards and processes regarding knowledge share, data warehousing, data governance and documentation
Design, create, revise and manage reports generated from operational and analytical systems using SSRS, Tableau, Power BI, and Crystal Reports
Developed and integrated Credit Risk Model objects using R for Risk Management
Provisioned replicated environment for real-time consumption of third party Originations data
Implemented Transparent Data Encryption, partitions and various SQL Server functionalities in production environment
Established scheduled database monitoring including index usage, fragmentation, blocking, and long-running queries
Create annual hardware roadmap based on projected database usage and pending application implementations and user base
Administered Tableau server including creating User Rights Matrix for permissions and roles, monitoring report usage and creating sites for various departments
Conduct root cause analysis and resolve production and data issues
Convert legacy reports from SAS, Looker, Access, Excel and SSRS into Azure Power BI and Tableau
Adhere to compliance and industry standards for consumer lending data management
Created web applications using the Microsoft stack
Created Tableau dashboards, datasets, data sources and worksheets

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship