Software Engineer Business Intelligence
Resume:
Alpesh Patel
San Tan Valley, AZ • 602-***-**** • adzakj@r.postjobfree.com
Software Engineer [Alteryx] & Operations Specialist
Data Mining, Project Management, Process Optimization
Expertise in providing data-driven and action-oriented solutions for challenging business problems
Business Intelligence Analyst with 8+ years of invaluable experience in project development, operations, and data analytics. Proven success in contributing to on-going delivery support and improving client engagement. Expertise in query development, workflow design, and production job automation. Ability to optimize operations, identify business development opportunities along with solid skills in problem-solving, critical decision making, and communication. Proficient in recommending procedural changes, providing internal and external training, and implementing data mining techniques to produce deliverables from structured and unstructured data.
Areas of Expertise
Client Delivery & Inquiry Support • Data Integration • Automated Job Management
Training & Knowledge Transfer • Team Development & Mentoring
Quantitative & Qualitative Analysis • Client and Vendor Relations • Driving Actionable Insights
Project Management • Time Management • Communication
Technical Skills
SQL • Hadoop • QlikView • Tableau • Autosys • Alteryx • JIRA • Microsoft Office Suite, Snowflake
Professional Experience
ICON PLC/SYMPHONY HEALTH – Phoenix, AZ
Software Engineer / Alteryx Developer / Data Analyst 2021 - Present
Support and build Alteryx workflow/app for the organization which is involved of internal and external client reports / deliverables. Understanding of modeling and transforming data for reporting & data visualization using Alteryx tools, SQL, VBA, Hadoop, Tableau, Microsoft Office Suite etc. Provide ad-hoc analysis for management and innovate new “information products” deliverables. Identify new opportunities for automation or embedding algorithms into existing business processes.
Conduct statistical analysis and draw insightful decisions to present to both technical and non–technical stakeholders.
Develop new and modify existing SQL code based on the requirements to generate data reports.
Manage end to end complex data migration, conversion, and data modeling (using Alteryx, SQL), and create visualization using tableau to develop high quality dashboards.
Support in gathering requirements from the business partners and develop Business Requirement Document.
Create workflows to fetch data from different sources to HDFS using Alteryx and Schedule jobs.
Maintaining Alteryx Server and Alteryx Designer with new version of updates.
Experience in dealing with Apache Hadoop components like MapReduce, HDFS, Hive, Pig, Sqoop, Big Data, Pivotal HD, Alteryx.
Create Alteryx Server usage report to monitor workflow/app of failures and unexpected errors which would require prompt solution fix as well as update maintenance.
ICON PLC/SYMPHONY HEALTH – Phoenix, AZ
Business Intelligence Analyst II 2018 - 2021
Develop query statements for data extraction across multiple data sets, implement job automation, and produce reports for internal and external clients. Effectively review accuracy of data, compile research conclusions, and recommend procedural changes. Provide production support, initiate independent data analysis, and document findings to support internal teams. Guide and conduct training of employees on various topics.
Extract valuable insights by employing SQL for extraction and exploration of large-scale structured and unstructured data.
Introduce transparency in data patterns and market events for the client; uphold data integrity and develop effective tools for customer utilization in liaison with peers.
Collaborate and effectively communicate with cross-functional teams (customers, internal IT teams, offshore, etc.) to understand business needs; ensure data integrity and workflow efficiency.
Provide recurring quality validations (QC) and on-going support of clients and projects.
Monitor and ensure the on-time resolution for internal support tickets.
Private Label Integration: Worked on high visibility clientele such as AbbVie, BMS, Genentech, and Novartis. These projects included working directly with vendors, finalizing requirements, and setting up on-going processes. Once implemented, over saw process and enhancements, offshore knowledge transfer, and inquiry support. All the above was performed under minimal supervision.
Vendor Focus: Retail Prescription, Medical/Hospital Claims, Non-Retail Warehouse, Demographics, and specialty pharmacy data sources: Biologics, Onco360, Special Care, Best Options, Liquid Hub, Optum, Accredo, Eyelogics, Epsilon, Prometrics, etc.
ICON PLC/SYMPHONY HEALTH – Phoenix, AZ
Business Intelligence Analyst 2015 - 2018
Directly responsible for ensuring client satisfaction and gathering business requirements from customers to translate them into clear, concise, and functional reports. Discussed and gathered requirements from business stakeholders including operations, development, product management, and QA. Provided professional expertise for all levels of consulting process while collaborating with clients during requirements, analysis, and delivery. Supported custom analytics through the implementation of proprietary data and methodologies within a collaborative and entrepreneurial environment.
Manipulated and/or built new query statements to perform data extraction across multiple data sets and platforms.
Produced tool extracts and reports to provide deliverables to customers that are clear and efficient.
Worked with business and product owners to define business and system-level requirements that will be used by developers for creating and enhancing applications/dashboards.
Performed analysis to confirm data types, quality, and integrity meet business standards.
Identified implementation tasks, data dependencies and proposed timing for project planning.
Documented business requirements that effectively capture client’s business objectives and accounts for data nuance.
Drug Team Consultant: Worked closely with colleagues to understand existing processes with the goal of transitioning from Mainframe to MDM. This included creating 40+ SQL queries from scratch, validating table content, and investigating anomalies. In addition to this, focused on learning corporate table structure and becoming familiar with healthcare data.
Retail Team Consultant: Devoted a significant amount of time to learning retail knowledge and processes involved with development and production workflows. This included, working additional hours and sometimes on weekends to meet high profile client SLAs. Additionally, established strong working relationships with Production Support, Offshore Retail, and the CE Team.
References:
Satish Mullapudi
Senior Manager, IT Operations
ICON PLC / Symphony Health
4130 Parklake Avenue, Suite 400
Releigh, NC 27612
adzakj@r.postjobfree.com
Satish Mullapudi is my current manager. He can talk about my professional development and career growth in the company. Under his supervision, I created a unique and creative Alteryx job and app which improved timing efficiency for client deliverables.
Ryan Weaver
Associate Principle
Real Chemistry
adzakj@r.postjobfree.com
Ryan Weaver witnessed my development and client communication skills getting better with time. He can testify to my great organizational skills and work ethic, along with ability to learn quickly, and not buckle under pressure.
Pradeep Raju
Novartis
I worked with Pradeep Raju as a colleague at PRA Symphony Health on multiple projects with internal organizations as well as supporting client requests and new projects. He can talk about my work ethic, creative thinking, and time management skills.
Contact this candidate