A SSAS Developer is a SQL server analysis service developer who works with Data Warehouse projects. The job description entails developing solutions and supporting the business with robust solutions and providing data and reports that support numerous functions including metrics, dashboards, and data discovery. Other key responsibilities are listed on the SSAS Developer Resume as – developing and improving solutions that surround spanning data processing activities; developing and improving MS Analysis Services Cubes; collaborating with other teams within the organization; mentoring colleagues and devising technical solutions; maintaining documentation for all process implementation, and adhering to and suggesting improvements for coding standards and improving best practices.
Top-most skills that can highlight a resume include – experience in installing MSSQL server, skillful in developing constraints, defaults, and triggers; excellent knowledge of analyzing data warehouse; solid knowledge in developing cubes using partitions, KPI’s and in extraction migration of data; and knowledge of writing complex logical algorithms in Macros using VBA. A degree in computer science or IT is commonly required.
Summary : Over 7+ years of strong experience in the IT industry as a MS SQL Server Developer/BI Developer. Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation. Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server Skillful in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
Skills : ETL, OLAP, OLPT, SQL Server.
Description :
PNC provided its services in Retail Banking, Asset Management Group, Corporate & Institutional Banking and Residential Mortgage Banking.
Provided risk management, investment system outsourcing, and financial advisory services to a growing number of institutional investors.
Project involved automation of PNC's Liquidity Coverage Ratio (LCR) calculation projected to be reported daily.
Created complex Stored Procedures, functions, tables, temp tables, views and using T-SQL and PL/SQL.
Created complex SSIS packages to extract data from Oracle and Teradata sources using Attunity adapters.
Extensively used variables and expressions to change values at runtime.
Used system and user variables for logging package and task level information and displayed the status in a Java application.
Experience
7-10 Years
Level
Management
Education
Bachelors
Ssas Developer Resume
Headline : Hardworking, organized, Ssas Developer professional with a proven background delivering sensible business technology solutions on time and under budget while working as a team member or team leader.
Skills : Organizational Skills, Leadership.
Description :
Demonstrated an understanding of business requirements & business concepts.
Experienced working with a team using Git.
Experienced with Build/Release Pipelines in Azure DevOps.
Hands-on experienced in MS SQL to write complex, highly-optimized queries across large volumes of data, database design, data warehouse design, query performance tuning and writing stored procedures.
Knowledged and experienced with full SDLC lifecycle.
Experienced in working in Agile teams, and working independently with Business stakeholders providing solutions and regular updates.
Knowledged of data models, ETL and data warehouse processes.
Experience
5-7 Years
Level
Executive
Education
Bachelor Of Electrical Engineering
Jr. Ssas Developer Resume
Summary : Developer to drive, implement and architect the SSRS/SSAS report environment for our client. This is a contract to hire opportunity which allows the candidate and the client to get comfortable with one another.
Skills : ETL, OLAP, OLPT, SQL Server, SSRS,SSIS.
Description :
Ability to demonstrate an understanding of business requirements & business concepts.
Experienced working with a team using Git.
Experienced with Build/Release Pipelines in Azure DevOps.
Responsible for analysis, design, development, deployment and support of enterprise systems such as EDW and BI on multi-tier environment.
Designed and developed Data Models using different modeling techniques.
Designed and Developed ETL processes and maintain data integrity.
Facilitated Data exchanges and Business Intelligence (BI) needs.
Experience
7-10 Years
Level
Management
Education
Bachelors
Ssas Developer III Resume
Headline : Helping the client design, build, stabilize and deploy a Microsoft Business Intelligence solution for a large 12 million record flat file using SQL Server, SSIS, SSAS, SSRS, Participate in customer team meetings and conversations with client personnel to understand business and technical requirements including requirements definition, schema design, ETL (SSIS), cube design and development (SSAS), end-user presentation (via analytic reports, graphs, scorecards, etc.), testing, deployment, and post-deployment support.
Skills : Developing Skills, Testing Skills.
Description :
Interacted with SME's and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
Well-versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
Experience
5-7 Years
Level
Executive
Education
Bachelors
Ssas Developer II Resume
Summary : Over 6+ years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Health Care and Insurance. Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions. Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.
Skills : T-SQL, Query Analyzer, DTS Designer, SAS Clinical.
Description :
Fully integrated suite of hosted products and sales support services are custom designed for the needs of the clients, leveraging the vast industry experience to meet current and future needs.
Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
Involved in installation and configuration of MS SQL Server 2012.
Created and modified complex TSQL batches/stored procedures.
Defined Check Constraints, functions, indexes, synonyms and views.
Involved in creating new stored procedures and optimizing existing queries and stored procedures.
Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
Experience
7-10 Years
Level
Management
Education
Bachelor Of Electrical Engineering
Ssas Developer II Resume
Objective : Bachelors degree and 14 years of related experience; Masters degree and 12 years of experience; or 18 years of experience will satisfy degree and experience requirements, ETL developer with 3+ years demonstrable experience using SSIS , T-SQL with SQL Server 2008 - 2012
Skills : SSAS, Data modeling.
Description :
Created and maintained a variety of related artifacts (e.g., requirements, process models or diagrams, data matrices, project deliverables).
Planed for and conducted implementation activities.
Demonstrated strong oral and written communication skills, with the ability to communicate technical topics to management and non-technical audiences, as well as interface with the customer and Northrop Grumman management on a daily basis and compile periodic reports.
Became knowledgeable on the HIPAA policies and procedures for the program and ensure awareness of HIPAA breach process. Understand your role in HIPAA compliance and be able to execute that role in an effective manner.
Developed, analyzed, and evaluated information/data to create and maintain business intelligence that supports the strategic objectives of the outreach team.
Experienced with SQL Querying.
Experienced with Production Models & troubleshooting skills.
Experience
2-5 Years
Level
Executive
Education
Bachelors
Ssas Developer I Resume
Summary : Dynamic IT Professional with more than 8 years of experience in system analysis, design, development and implementation of Database and Data Warehousing systems using SQL Server R2/ 2012, SSIS, SSRS and SSAS. Experienced in developing client/server Business intelligence (BI) database application. Experienced in designing, developing, documenting, and testing of ETL jobs in Data Warehouse and Data marts.
Skills : Managing Skills, SAS Developer.
Description :
Operated the world famous fashion shopping search website: Shopstyle.
Created, maintained, and optimized data objects like indices and schemata.
Developed logical and physical model for schemas.
Created standard data documentation, such as ERD and Flow Diagram.
Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
Created copies of operational Databases using the replication of the database on to the new database using the wizard.
Created Stored Procedures, Triggers, Tables, Views and other T-SQL code ensure efficient data retrieval.
Experience
7-10 Years
Level
Management
Education
Bachelors
Assistant Ssas Developer Resume
Summary : Working on a team helping to define and develop requested business intelligence deliverables, Work on a team to synthesize business intelligence and trend/benchmarking data to generate standard or custom reporting that supports recommendations for action readily consumable by business owners.
Maintain and update business intelligence methods, databases, dashboards, tools or systems, Work with SSAS 2014-2016 to build and extract data from data cubes.
Skills : Business Management, Supervising Skills.
Description :
Provided technical support for existing business intelligence tools and systems.
Performed application testing, configuration management, and documentation.
Performed SQL Server Administration and scripting.Develop ETL processes for data warehousing and automated tasks.
Built SSRS dashboards and reports using Visual Studio and/or Report Builder.
Developed Real Time and specific reporting for Outreach.Communicate technical report conclusion and data driven strategies to Field employees and Executive level data consumers.
Developed data mapping strategies and CRM navigation.
Developed and adjust relationships between business processes, data collection and data analysis for efficiency and accuracy.
Experience
7-10 Years
Level
Management
Education
Bachelors
Ssas Developer/Admin Resume
Summary : Over 8 +Years of extensive IT experience as a Microsoft SQL Server Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Finance and HealthCare.
Skills : Creative Skills, Developing Skills.
Description :
Served the needs of the community and the City, COA work in partnership internally and with other departments' IT business units across the organization to deliver and sustain state-of-the-art technology solutions.
Designed and created Data Warehouse to develop reports.
Created SSIS packages to pull the data from Oracle in to Data Warehouse.
Created packages to do the incremental loading twice a day in to the data warehouse.
Created DB objects like stored procedures, tables, views etc.
Converted DTS jobs to SSIS packages.
Used new features available in SSIS, improved the process and performance of DTS Jobs.
Experience
10+ Years
Level
Senior
Education
Bachelors
Ssas Developer Resume
Summary : Server Analysis Services (SSAS) Developer will develop solutions required to support the business with robust solutions that provide data, analytics, and reports, which support numerous functions including metrics, dashboards and data discovery. Designs, analyzes, develops, codes, tests, debugs and documents solutions to satisfy business requirements. Proficient in data warehouse development skills spanning multiple design techniques.
Skills : SQL Business Intelligence, Data warehousing, SQL server Database Programming.
Description :
Headquartered in Pittsburgh, Pennsylvania Responsibilities: Created DB Objects like Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
Worked on Performance point server and created management reports.
Monitored SQL jobs to increase the performance at job level and CPU usage level and also involved in the performance tuning of Indexes.
Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel spreadsheets, flat files and vice versa.
Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages.
Extensively worked on mappings, incremental data loading, and SSIS transformations that include: lookup, filters, aggregators, scripts, multicasts, derived (not limited).
Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
Creating an account is free and takes five seconds.
You'll get access to the PDF version of this resume template.
Choose an option.
Sign up with Google
Sign up with Facebook
Sign up with Linkedin
This helps us make sure you're human and prevents spammers from abusing our services.
By continuing, you agree to our Privacy Policy and Terms.
Unlock the Power of Over 10,000 Resume Samples.
Take your job search to the next level with our extensive collection of 10,000+ resume samples. Find inspiration for your own resume and gain a competitive edge in your job search.
Get Hired Faster with Resume Assistant.
Make your resume shine with our Resume Assistant. You'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want.
Get Noticed with Resume Templates that Beat the ATS.
Get past the resume screeners with ease using our optimized templates. Our professional designs are tailored to beat the ATS and help you land your dream job.