Publicis Sapient

Data Engineer

Lance Perry

Resource for management focused on the intersection of data and user experience available immediately. 
Partner with companies to understand user needs and expectations and define/refine the user experience and data analysis for each project. Analyze datasets to come up with an engaging presentation of data in the form of dashboards, reporting tools, and reports. Create dashboards and reporting tools for internal reporting purposes. Interact with users to determine architecture and to ensure functionality on mobile, tablet, desktop, and web platforms. Measure effectiveness through user research and data to improve data integrity based on findings.

Data Analyst & Developer

Capital One

Programmed in SQL (SnowSQL), Scala (Spark SQL) and Python (PySpark) to create complex queries to extract data from various unstructured and structured sources including S3 buckets, relational data warehouses, and resilient distributed datasets (RDD) using data frames. Spun up multiple EC2, Lambda, and EMR clusters to run jobs for data pipeline creation. Created software microservices through ECS containers and Lambda functions for custom software solutions. Programmed in Python, using Numpy and Plotly and Dataframe libraries, and Scala, Dataframe libraries, mini-programs utilizing AWS resources optimally and efficiently.

Eaton Vance

Programmed in PL/SQL for custom reporting of information for traders and sales/marketing personnel. Created functions, procedures, and packages for custom data transformation and cleansing. Converting PL/SQL code into T-SQL for implementation for production environment. Created custom procedures and function for data transformation and cleansing. Provided on support for data warehouse issues. Self-managed product deliverables based on business needs. Provided custom T-SQL code for ETL jobs using a automatic ETL tool called ESP.

Senior Data Engineer

USAA

Created dashboards in Tableau and Datastage jobs for ad hoc and timely reports. Constructed complicated queries in Netezza, Hadoop, Microsoft, and IBM databases. Met with stakeholders virtually and domestically for requirements gathering and analysis of project needs. Created, debugged, and tested ETL jobs for errors and provided patches so jobs ran effectively. Scheduled jobs using Control-M reporting tool for automatic reports. Customized Tableau dashboards based on user and business needs. Presented findings and information to internal stakeholders. Provided on-call support for complicated IT matters. Scripted in Python and Linux for configuration of automatic processing ETL jobs.

Casenet, LLC

Constructed complicated T-SQL queries in SQL Server to build custom reports and dashboards for internal end users. Created a rich internal knowledge base for documentation and reporting purposes. Met with stakeholders and gathered requirements for knowledge acquisition and transfer. Debugged, tested, and honed complicated T-SQL queries of existing application for Centene custom application, TruCare. Optimized web dashboard for ad-hoc reporting. Wrote Cron jobs to develop automatic reports for clients. Provided on-call support for complicated IT matters.

Weston & Sampson

Constructed data collection forms with HTML and Javascript using Zerion proprietary software iData Collect. 
Built custom templates for reporting of state and private entity civil engineering reports using Jasper Report  systems
Constructed semi-complexive and complexive SQL queries to hone data collection
Met with internal and external stakeholders to gather requirements and provide support on reporting tools
Built customized Excel workbooks utilizing Microsoft Access and Power BI to provide insights and data discovery for stakeholders

Application Engineer

Procter & Gamble

Constructed advanced queries for data retrieval from a MS SQL database for data management purposes. Leveraged Power BI, Power Query, and Power Pivot to create dynamic reports for trend analysis, seasonality, product behavior, segmentation, and statistical analysis / modeling

Analytical Engineer

Boston Product Management Association (BPMA)

Created wireframes and user stories for new membership registration page. Updated usability and functionality to align with the latest design and user interface standards. Coded new features for product page using HTML, CSS, JS, and jQuery. Assisted with ongoing maintenance, interoperability tests, and design infrastructure for updating CMS

Webmaster (Volunteer)

Natixis Global Asset Management

Configured workflows for existing MS SQL databases containing financial research, sales, and marketing material on client accounts to Salesforce CRM. Created reports and dashboards for marketing and sales teams using Visual Force pages and Lightning components. Designed and tested new user interfaces for internal use as financial research and analysis tools for fund managers and financial planners

Application Developer

Great team player. Love team work. You got a team, I want to be on it.

Offers a unique combination of engineering and analytics expertise to help managers enhance their applications both by presenting complex data in compelling ways and using statistical information to determine effectiveness. Recent and diverse experience integrating business intelligence and visual presentations. Excellent research, analysis, and synthesis skills.

Tech Skills:
HTML/ CSS/ JS/ PHP, SQL, Tableau, Bootstrap/ Angular, MySQL, Salesforce, Balsamiq, JasperReports, Microsoft Office, Photoshop/ Illustrator/ InDesign, Wordpress, Google Analytics, Zerion Software, Power BI, Access, SSIS, SPSS, SSRS, R, R-Studio

Key Skills:
Data Analysis, Statistics, Data Modeling, User Experience (UX),	User Interface (UI), User-Centered Design (UCD), Google Analytics, Business Intelligence, Testing, Research & Analysis, Database Development,	Interface Design, Dashboards & Reporting,	Content Management,	Mobile / Responsive


Taplio

Lance Perry's Linkedin Analytics

Lance Perry

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Lance Perry's Linkedin Analytics

Lance Perry

Want to drive more opportunities from LinkedIn?

Lance Perry's Linkedin Analytics