A Senior BI Developer takes responsibility for accumulating data from multiple sources in an efficient data warehouse and designing enterprise-level solutions. Other related duties are listed on the Senior BI Developer Resume as – designing and planning BI solutions, debugging, monitoring, and troubleshooting BI solutions; creating and deploying reports; writing relational and multidimensional database queries; deploying and maintaining database servers. The job description also includes – evaluating and improving existing BI systems; conducting troubleshooting on BI models; generating and delivering quality reports to customers and performing QA checks on reports.
The most sought-after skills include – experience in data warehouse design, working knowledge of BI technologies; strong problem-solving and analytical skills; strong attention to detail; the ability to work in a team; and good communication skills. Apart from proven work experience, a bachelor’s degree in computer science, engineering, or related field.
Summary : Over 8 years of Industry experience in Data warehousing experience with Microsoft SQL Server SSIS/SSRS/SSAS/MOSS OLTP and OLAP. In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics. Extensive experience in creating interfaces using SSIS in MS SQL Server and its different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Configuration Manager.
Skills : Cognos, Business Intelligence, Databases, Data Warehousing, Team Leader.
Provided the broadest range of healthcare cost containment solutions in the industry - all to help payers like you improve performance.
Adapted that solution to state agencies and then to Medicaid managed care organizations.
Created SQL Server Reports based on the requirements using SSRS 2014/2012.
Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
Experienced in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2012/2008 (SSAS).
Partitioned tables to handle better data comparison in staging Worked directly with business users to get requirements and feedback on the on-going .
Reviewed designed and coded Test and validate solutions to ensure continuous accuracy, front end ease-of-use and integration with existing resources .
B.S. Computer Systems
Senior Bi Developer III Resume
Summary : Cognos Solution Architect with 10 years of end to end project development of various BI applications Architected, designed and implemented multiple Analytical solutions with Cognos Vast experience in requirement gathering from business In-depth knowledge in Framework Manager modeling Designed and developed various dashboards and complex reports Experience in deploying the Cognos applications into test and live environments.
Skills : SSIS, SSRS, SSAS, ETL, SQL, T-SQL, PL SQL, Cognos BI, Data Warehousing, Business Intelligence.
Generated Views, reports and dashboards (Tiles from multiple reports) using Power BI Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions, Fact and Aggregate tables.
Created staging database for temporary processing of data, consolidating data and loading into target database using SSIS.
Developed SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Union All, Sort and Execute SQL Task to load data into Database.
Developed data modeling & visualization using tools such as Power BI, Tableau, etc.
Collaborated closely with business partners to understand requirements, design and develop a data model that best fits the users needs.
Developed and maintain technical documentation for all designed solutions.
Maintained existing data solutions, reports & dashboards, and identify and act upon opportunities to improve the system process flow, performance and technical efficiencies.
Senior Bi Developer II Resume
Headline : Having around 8 years of IT experience in Database development and maintenance for Telecommunication, Financial Services and Health Care domains. Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) which includes Use Cases, Sequence, State and Activity diagrams, Data mapping, participated in architectural design and class design.
Skills : SSIS, SSRS, SSAS, ETL, SQL, T-SQL, PL SQL, Cognos BI, Data Warehousing, Business Intelligence.
Involved in requirement gathering and providing solutions to generate state files.
Experienced in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
Experienced in writing PL SQL queries to perform various database operations in Portico.
Experienced in creating and managing stored procedures, indexed views, UDF's, Triggers, Database Constraints to meet business requirements.
Exposured on Power Pivot.
Developed operational analytics using descriptive, predictive, and prescriptive models accordingly to improve business outcomes using data warehousing & analytic solutions.
Created ad-hoc data models, reports and analysis as needed to support business requirements.
Bachelors Of Engineering
Senior Bi Developer I Resume
Summary : Business Intelligence certified professional with 13+ years of experience as a Business Intelligence Consultant with BI Suite development, integration and support experience Business Intelligence experience includes: Architect/Developer: Design and develop MicroStrategy BI solutions BI Engineer: Implement and integrate BI product Suite Support Engineer: Maintain and support BI product Suite Administrator: Upgrade and enhance up to and including MSTR v 10.
Skills : OBIEE, BI Publisher, Weblogic DAC, SQL, BI Administration Tool, Oracle Data Integrator 11g, Unix.
Designed and developed the reports and dashboards according to the standards agreed.
Regulatory Reported for Basel I, II & III-- Senior BI Developer Extract the required data, and deliver the standards reports to Central Bank of Egypt (CBE) which are revised by CBE and passed to Basel Committee on Banking Supervision.
Provided 360o business views from different perspectives such as Gender, Income Salaries, Demographic Info, Age Bracket, which merchants the customers usually use their cards.
Designed and developed the reports, dashboards to help the business users in validating and cleansing all the customers and accounts corrupt or inaccurate data.
Worked on DW and reporting part for Spirit Airlines Translated business requirements into technical solution concepts and designs and provide .
Experienced on data warehousing architecture, modeling, and development.
Actively supported Reporting project life-cycle activities including gathering requirements, testing, issue tracking, documentation, and project write ups.
Assistant Senior Bi Developer Resume
Summary : Responsible for Working with ETL developers and data analysts to identify develop and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis.
Worked with Finance members to develop business requirements, project deliverables, business architectural models, and use-case scenario specifications; communicates issues, concerns, risks and project information as needed.
Met regularly with business partners to provide updates, acquire business decisions, and validate scope and direction.
Partnered with project managers to track projects and update the schedule status regularly in accordance with deliverable schedules.
Worked with individuals across different Finance groups to facilitate the creation or modification of reports and data as needed.
Provided business support for internal team and partners on new and existing customer Reporting initiatives.
Provided design recommendations for data and reporting solutions including development approach, solution integration and platform utilization.
Delivered lead managing offshore developers on Reporting related projects (Small Enhancements) assignments.
Associate Senior Bi Developer Resume
Objective : Over 7 Years of extensive experience in SQL Server Development (2012, 2008R2, 2005) including writing T-SQL Programming, SSIS and SSRS. Experienced in creating Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency.
Skills : Sql Server, SSIS, SSRS, SSAS, Azure Data Factory.
Involved in system analysis & design of the Enterprise data warehouse implementation Created various database tables and procedures to update and clean the old data.
Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
Reviewed and approved sign-off of developers reporting related test documentation in a Change Management Process.
Bachelors In Technology
Senior Bi Developer/Manager Resume
Summary : Over 9 years of diverse experience in IT industry (Banking and Financial services, Insurance and Health Care domains) involving all stages of SDLC for N-Tier, Three-Tier applications in Client/Server and Web based applications with major focus on Microsoft .NET Applications and MSBI Extensive hands-on knowledge of Visual Studio ASP.
Skills : MSBI And .Net, Sql Server, Sql Server.
Designed data models using Erwin data modeler version 9.5.
Responsible for database design and maintenance.
Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables.
Worked on Views, Stored procedures, table valued functions, Triggers.
Involved with team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.
Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning.
Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files , Csv files and Excel files.
Senior Bi Developer/Specialist Resume
Summary : Senior BI Developer (Cognos & MS BI) with 9+ years of working experience in Business Intelligence systems with an emphasis on data warehousing solutions. Demonstrated skills include: project management, requirements analysis, Installation and Configuration, ETL design, Cognos Administation, Metadata modeling, Report development, enhancement and performance tuning and workload automation.
Skills : Cognos, SSIS, SSIS, SSRS.
Designed and developed SSIS interfaces for Customer Master, Payroll Process and Sales Audit process etc., and created jobs using SQL procedures and different types of sources like Oracle, SQL Server and Flat files and FTP connections.
Used different tools like For Each loop, Sequence Container and Derived Columns and Data Conversion and Script task etc, in Control and Data flow stages.
Designed and Developed the Framework Manager models using stored procedures, Relational tables and published in to server.
Created SQL Server Reports based on the requirements using SSRS 2012.
Ability to analyze and document business requirements, solve problems, and model current and future state Finance business/reporting processes.
Ability to perform basic project management functions and work independently to prioritize workload and handle multiple responsibilities and deadlines
Demonstrated ability to collaborate, communicate, build relationships, mentor and influence a community of reporting and data professionals across Finance business areas.
BE In Electronics
Senior Bi Developer/Supervisor Resume
Summary : Over 6 years of experience working with Business Intelligence and data visualization tools with Specialization on Cognos 8.x, 10.x and Tableau 8.x, 9.x. 4 years of experience working with Tableau Desktop and Tableau Server. 5+ years of working experience in Cognos8 & 10 BI tools using Cognos Framework Manager, Report studio, Query studio, Active Reports, Workspace and Workspace advanced.
Skills : MS Office, Proven experience as a BI Developer or Data Scientist.
Actively worked with Business Partners and Designers to get the Requirements and create High level Application Design.
Prepared Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
Accessed and changed extremely large datasets through filtering, grouping, aggregation, and statistical calculation.
Consulted with customers and inside partners to accumulate necessities and set milestones in the research, advancement, and execution periods of the project lifecycle.
Developed, organized, managed and maintained graph, table, slide and document templates that will allow for efficient creation of reports.
Created cubes using packages which are built in framework manager.
Created users, users groups and maintained user access rights in Tableau.
Certification In Details
Senior Bi Developer Resume
Objective : Over 8 years of wide-ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc. Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS) Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File.
Skills : MS SQL Server 2005/2008/2012, Oracle 10g, Teradata,.
Worked with Cardinal was a great experience.
Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task.