Data Analysis Production Support

JEFFERY MELAMED

Richboro, PA 215-***-**** **********@*****.*** www.linkedin.com/in/jeff-melamed-66a89b80

PROFESSIONAL SUMMARY:

Experienced and detail-oriented BI Analytics and Data Analysis professional with 18+ years of expertise in data structures, programming, and statistics. Strong background in production support, financial investigation, and claims/enrollment. Proven ability to collect, clean, and interpret data to solve complex problems. Skilled at identifying improvement opportunities and supporting strategic initiatives. Effective communicator, experienced in mentoring junior developers and managing multiple projects independently.

EXPERIENCE:

04/2006 – 12/2024 Independent Blue Cross, Philadelphia, PA

Sr. BI Developer (10/2020-12/2024)

Expertise in designing and optimizing complex SQL queries and data models in Google BigQuery to drive actionable business insights and support data-driven decision-making.

Developed business transformation and mapping rules by performing thorough analysis of source data to define the data model as well as responsible for data integration and verification testing.

Strategically utilized GenAI and prompt engineering techniques to develop automated testing suites in Python, reducing testing time by 40% and accelerating time to market for data-driven solutions.

Took the initiative to leverage GenAI techniques and develop working prototypes in Python in order to streamline presentations to stakeholders and management.

Mentored junior BI developers by offering project feedback, participating in code reviews, and providing training in areas of expertise.

Developed, validated, and executed complex queries, reports, and data analyses to answer business questions for internal customers.

Interpreted results and made recommendations to business areas based on findings.

Routinely used statistical methods during analyses and visualized data to accurately reflect the intended message, including limitations.

Reported and helped troubleshoot data quality issues during data profiling, testing, or validation.

Leveraged extensive knowledge of Agile and DevOps frameworks to ensure efficient and continuous project delivery.

Participated in strategic departmental initiatives and industry advisory/user groups.

Shared important and relevant information with the team, proactively offering suggestions, resources, and removing barriers to help the team accomplish its goals.

Sr. Business System Analyst (8/2008-10/2020)

Applied technical expertise in data management tasks (SQL intensive), including data loading, validation, converting data formats, and building detailed queries for data extracts.

Created ETL processes using SSIS, custom SSRS reports, and data visualizations with Tableau.

Acted as the analytics expert in meetings and discussions with stakeholders, operating independently.

Articulated analyses and insights in both oral and written communications, including presentations to non-technical stakeholders.

Demonstrated initiative and organizational skills, inspiring trust and confidence to maintain outstanding customer relationships.

Formed close partnership with stakeholders to gather accurate project requirements and define scope on projects of all sizes.

Collaborated with internal partners to design and develop reporting solutions and analytic studies to support business needs.

Planned projects and request completion tasks, providing time and effort estimates based on requirements gathering.

Managed multiple projects independently, demonstrating strong organizational skills.

Led cross-functional teams in the implementation of business process improvements, ensuring alignment with organizational goals and enhancing operational efficiency.

Business System Analyst (4/2006 – 8/2008)

Partnered with business and clinical areas to use analytic expertise for data-driven decision-making.

Worked with production support, corporate financial investigation (CFID), medical and RX claims, and enrollment.

Assisted in determining business requirements by working with business clients and creating mappings for developers.

Conducted data analysis on raw and processed data for new product/services and interface development.

Identified potential problems, performed analysis, and collaborated with business areas to develop solutions.

Followed all department policies and procedures, including request intake/fulfillment, change management, and data governance practices.

Analyzed, designed, developed, and tested specialized software products using RPG LE, CL, SQL, PL/SQL, MS Access, and various tools and utilities for AS400

EDUCATION: Razzakov Kyrgyz State Polytechnic University,

M.S. in Mechanical Engineering

TECHNICAL SKILLS:

Data Management: SQL, PL/SQL, T-SQL, Google BigQuery, DB2, AS400, RPG LE, CL

Programming Languages: Python, VBA

Data Integration & ETL:SSIS, SSRS, Tableau, Teradata, Data loading, validation, conversion, ETL

Data Analysis & Visualization: Data analysis, data visualization, Tableau, MS Excel, MS Access, Macros

Contact this candidate