E: ad1z80@r.postjobfree.com 415-***-**** A: San Francisco, CA 94109

PROFESSIONAL SUMMARY

BI Developer with 8+ years of progressive experience in SQL development, Power BI programming, ETL warehousing, SSIS/SSRS development, Azure engineering, and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

WORK HISTORY

GEICO - Senior BI Developer

Chevy Chase, MD

04/2021 - Current

SKILLS

Analyzed existing SQL queries to identify opportunities for improvements.

•

Designed and implemented T-SQL queries for reporting, complex solution development and stored procedures.

•

Extracted transformed and loaded data from sources systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL. Data Ingestion to one or more Azure Services

(Azure Data Lake, Azure Storage, Azure SQL) and processing the data in Azure Databricks.

•

Created, maintained and scheduled various reports in Power BI like Tabular Reports.

•

Used different methods of logging in SSIS building, publishing customized interactive reports and dashboards, report scheduling using Power BI.

•

• Performed regular database backups to prevent information loss. Designed and developed customized extract, transform and load (ETL) applications per client specifications.

•

Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.

•

Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.

•

• Automated BI reports for secure virtual server environment. Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.

•

• Developed custom database objects, stored procedures and

• SQL Server Integration Services (SSIS)

• Data Warehousing and Analytics

• T-SQL Coding

• Data Extracting

Extraction Transformation and

Loading (ETL)

•

• Power BI

• Business Intelligence Analysis

• Business Intelligence Data Modeling

• SQL Reporting

• Data Integrity

• Azure Data Tools

• Data Modeling

• Performance Improvement

• Database Management

• Reporting Analytics

• Transforming Data

• Developing Databases

• Client Requirements

• Report Writing Skills

• Team Support

CI / CAMILLA ILKHAM

Saxon Global Services - BI Developer

New York, NY

09/2020 - 06/2021

Adobe - ETL Developer

New York, NY

09/2018 - 05/2020

delivered application support.

• Developed and managed dashboards using Azure platform.

• Generated reports, updated spreadsheets and presented results. Improved data gathering, analysis and visualization procedures with strategic optimizations.

•

Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.

•

Designed and developed customized extract, transform and load (ETL) applications per client specifications.

•

Wrote and optimized SQL statements to assist business intelligence practices.

•

• Built databases and table structures for web applications. Corrected, modified and upgraded software to improve performance.

•

Authored code fixes and enhancements for inclusion in future code releases and patches.

•

Coordinated deployments of new software, feature updates and fixes.

•

Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.

•

Designed and implemented scalable applications for data extraction and analysis.

•

Documented software development methodologies in technical manuals to be used by IT personnel in future projects.

•

• Conducted data modeling, performance and integration testing. Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.

•

Developed next generation integration platform for internal applications.

•

• Tuned systems to boost performance.

Investigated new and emerging software applications to select and implement administrative information systems.

•

Assessed platform statistics to create customized, data-intensive BI analytics.

•

• Automated BI reports for secure virtual server environment.

• Designed and developed analytical data structures. Responded to specific BI requests by creating data packets with requested information in easily understandable formats.

•

• Oversaw database upgrade, backup, recovery and migration. Created data analysis tools to allow teams to query acquired information for unique details.

•

• Wrote and optimized in-application SQL statements. Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.

•

Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.

•

Designed and created ETL code installations, aiding in transitions from one data warehouse to another.

•

Chime - SSIS/SSRS Developer

San Francisco, CA

02/2015 - 08/2018

Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.

•

Interpreted data models for conversion into ETL diagrams and code.

•

• Trained in coding for numerous Data Warehousing solutions. Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.

•

Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.

•

• Designed data models for complex analysis needs.

• Managed identification, protection and use of data assets. Documented and communicated database schemas using accepted notations.

•

Developed and modified programs to meet customer

requirements.

•

Collaborated with multi-functional roles to communicate and align development efforts.

•

Completed quality reviews for designs, codes, test plans and documentation methods.

•

• Mapped data between source systems and warehouses. Cooperated fully with product owners and enterprise architects to understand requirements.

•

• Coordinated troubleshooting support for warehouse personnel. Participated in team projects, demonstrating an ability to work collaboratively and effectively.

•

Managed time efficiently in order to complete all tasks within deadlines.

•

Selected methods and criteria for warehouse data evaluation procedures.

•

Tested software applications and systems to identify enhancement opportunities.

•

Performed systems and data analysis using variety of computer languages and procedures.

•

Documented data warehouse architecture to guarantee capacity met current and forecasted needs.

•

Contact this candidate