Jessica Claire
- Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
- (555) 432-1000
- resumesample@example.com
Professional Summary
- Highly motivated, innovative lead Data Engineer with 8+ years of extensive technical knowledge in OLTP, data modeling and data warehousing
- Experience with dimensional, rational, logical and physical data modeling
- Successfully driven several database management and ETL projects with lead role from concept of implementation
- Expertise with retail domain and handling supply chain data
- Highly recognized for great system performance improvement skills
- Design and Development of real-time & batch data processing
- 6+ years of experience on Microsoft technology stack (T-SQL, SSIS, SSAS, SSRS, MDX, DAX, Power Pivot, and Power BI reports)
- Experience in using Google Cloud and Big Query
- Works with Data Integration developers to develop Data Integration Workflows and load processes
- Create documentation and formulate training approach to assist business users and IT members in designing & effectively using the solutions developed
- Provides technical consulting to application development teams during application design and development for highly complex or critical projects
Skills
|
|
Work History
Senior Data Engineer, 05/2019 to Current
Factset Research Systems Inc. – MA, State,
Factset Research Systems Inc. – MA, State,
- Developed real time dashboard for Executive Directors+ on wayfair supply chain data model
- Built robust warehouse for wayfair supply chain system, and responsible for migrating from Vertica to Google Cloud
- Built real time dashboards with no-downtime using Kafka, GCP, Data Studio
- Provided technical expertise and created software design proposals for upcoming components
- Built foundational data layer consolidating and cleaning data from multiple sources in supply chain, which is used for reporting across supply chain
- Expert in python to parse data and handling data flow across entities using python
- Expert in Google Cloud technologies Big Query and Materialized views
- Work with business in proactive way to identify and raise data issues
- Designed and implemented delta and incremental loads through out
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to drive wayfair business
Lead Data Engineer, 03/2017 to 05/2019
Verizon Communications – Alexandria, LA,
Verizon Communications – Alexandria, LA,
- Mentor Data Engineers, providing guidance and resources for their development. Perform spot checks to monitor work quality
- Responsible for architecture to development of end to end data warehouse application for Mindshare
- Create documentation and formulate on boarding process of DRAW application to stake holders
- Migrated existing application from SQL 2008 to SQL 2012 and improved performance by 60% and security
- Created SSAS cube and Tabular models using star schema
- Built C# application to use Predictive Algorithm ‘Microsoft Solver Foundation’ for driving business decisions on client budget allocation
- Built robust system and database with best coding practices and to accommodate future change requests
- Started introducing Big Data and cloud technologies, built proof of concept model in migrating data to Big Data
Senior BI Developer, 01/2017 to 03/2017
American Medical Association – Washington, DC,
American Medical Association – Washington, DC,
- Support existing ETL and data loading process
- Develop ETL for new data feeds
- Create tabular model solutions
- Create Power BI reports with security
- Help team with Power BI technical learnings
- Create DAX and VB scripts for Excel reporting and calculated members
- Create test and verification documents
- Create understanding and guidelines documents for business users
- Complete deployment to production and verification
Business Intelligence Developer, 09/2015 to 12/2016
Sequoia Benefits – New York, NY,
Sequoia Benefits – New York, NY,
- Develop Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
- Use SSIS for data processing on daily basis and automation
- Deployed SSIS packages to Automic UC4 tool, for automation and scheduling
- Create tabular SSAS cubes for fast retrieval of data
- Understand legacy OBIEE reports, and coming up with data points
- Re write complete legacy OBIEE reports in new technology using PowerPivot and tabular models/ SSRS reports
- Create test and verification documents
- Create understanding and guidelines documents for business users
- Use SharePoint for maintaining reports, documents and project details
Business Intelligence Developer, 02/2015 to 09/2015
Sequoia Benefits – San Mateo, CA,
Sequoia Benefits – San Mateo, CA,
- Development of data warehousing and reporting solutions from multiple sources including DART, Vizu, Facebook, Kenshoo, Mediamind, Pointroll and others
- Proposed new solutions for optimizing report refresh times
- Lead the module of migrating databases from SQL 2008 to SQL 2012 along with SSIS packages and catalog system
Senior BI Developer, 01/2012 to 01/2015
American Medical Association – Chicago, IL,
American Medical Association – Chicago, IL,
- Joined as Intern and promoted to BI Developer in 6 months and promoted to Senior BI Developer in 2 years with exceptional performance
- Lead a team of 5 people, and interacted with client every day
- Conducted training sessions and knowledge transfers to new team members
- Developed Excel PowerView and PowerPivot reports for data analysis
- Created Coded UI solutions for daily refreshing of Excel files from source
- Scheduled Coded UI solutions from windows task scheduler
- Implemented slowly changing dimension Type 1 and Type 2
- Experience in migrating databases from on premises systems in to windows Azure SQL database
- Experience in working with Azure SQL database
- Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues
- Extensive usage of SQL Profiler and Analytics for query optimization and maintenance
- Created Reporting database from mart which contains separate tables as per chart needs
- Understand requirements and come up with data warehouse architecture to build robust reporting platform
- Involved in performance tuning of tabular models
- Worked on UI technologies .Net, SharePoint, HTML, JavaScipt and CSS
- Involved in DBA tasks like replicating database, maintaining server configurations and database tuning
- Implemented Cube Security, Row level security, ETL mails
- Created tabular models with dynamic partitions
- Scheduled daily refresh jobs from SQL Server agent, and provided support in case off ETL failure
- Provided support to down streams regularly who are using reports
- Implementing slowly changing dimensions to maintaining Historical data in required dimension table
Education
Master of Science: Information Technology, Expected in 05/2012
International Institute of Information Technology - Hyderabad, India,
International Institute of Information Technology - Hyderabad, India,
Bachelor of Science: Information Technology, Expected in 07/2009
Kakatiya Institute of Information Technology - Warangal, India,
Kakatiya Institute of Information Technology - Warangal, India,
Certifications
- Microsoft SQL Server 2012: Querying Microsoft SQL Server 2012 (70-461)
- Microsoft SQL Server 2012: Administering Microsoft SQL Server 2012 Databases (70-462)
- Microsoft SQL Server 2012: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)
- Microsoft SQL Server 2012: Implementing a Data Models and Reports with Microsoft SQL Server 2012 (70-466)
- Microsoft SQL Server 2012: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467)
- Programming in HTML5 with JavaScript and CSS3 (70-480)
- Microsoft SQL Server 2008: Database Development (70-433)
- Microsoft SQL Server 2008: Business Intelligence Development and Maintenance (70-448)
- Developing Windows Azure and Web Services (70-487)
- Developing Microsoft SharePoint Server 2013 Core Solutions (70-488)
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume scorecould be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
resume Strength
- Clear Contact Info
- Completeness
- Length
- Personalization
- Target Job
Resume Overview
School Attended
- International Institute of Information Technology
- Kakatiya Institute of Information Technology
Job Titles Held:
- Senior Data Engineer
- Lead Data Engineer
- Senior BI Developer
- Business Intelligence Developer
- Business Intelligence Developer
- Senior BI Developer
Degrees
- Master of Science
- Bachelor of Science
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
*As seen in:As seen in:![Forbes]()
![CNet]()
![Business Insider]()
![Mashable]()
![The New York Times]()