Senior BI Developer Resume Samples

Description :

1. Provided the broadest range of healthcare cost containment solutions in the industry - all to help payers like you improve performance.
2. Adapted that solution to state agencies and then to Medicaid managed care organizations.
3. Created SQL Server Reports based on the requirements using SSRS 2014/2012.
4. 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.
5. Experienced in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2012/2008 (SSAS).
6. Partitioned tables to handle better data comparison in staging Worked directly with business users to get requirements and feedback on the on-going .
7. Reviewed designed and coded Test and validate solutions to ensure continuous accuracy, front end ease-of-use and integration with existing resources .

Experience

10+ Years

Level

Senior

Education

B.S. Computer Systems

Description :

1. 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.
2. Created staging database for temporary processing of data, consolidating data and loading into target database using SSIS.
3. 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.
4. Developed data modeling & visualization using tools such as Power BI, Tableau, etc.
5. Collaborated closely with business partners to understand requirements, design and develop a data model that best fits the users needs.
6. Developed and maintain technical documentation for all designed solutions.
7. Maintained existing data solutions, reports & dashboards, and identify and act upon opportunities to improve the system process flow, performance and technical efficiencies.

Experience

10+ Years

Level

Senior

Education

Computer Applications

Description :

1. Involved in requirement gathering and providing solutions to generate state files.
2. 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.
3. Experienced in writing PL SQL queries to perform various database operations in Portico.
4. Experienced in creating and managing stored procedures, indexed views, UDF's, Triggers, Database Constraints to meet business requirements.
5. Exposured on Power Pivot.
6. Developed operational analytics using descriptive, predictive, and prescriptive models accordingly to improve business outcomes using data warehousing & analytic solutions.
7. Created ad-hoc data models, reports and analysis as needed to support business requirements.

Experience

5-7 Years

Level

Executive

Education

Bachelors Of Engineering

Description :

1. Designed and developed the reports and dashboards according to the standards agreed.
2. 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.
3. Provided 360o business views from different perspectives such as Gender, Income Salaries, Demographic Info, Age Bracket, which merchants the customers usually use their cards.
4. Designed and developed the reports, dashboards to help the business users in validating and cleansing all the customers and accounts corrupt or inaccurate data.
5. Worked on DW and reporting part for Spirit Airlines Translated business requirements into technical solution concepts and designs and provide .
6. Experienced on data warehousing architecture, modeling, and development.
7. Actively supported Reporting project life-cycle activities including gathering requirements, testing, issue tracking, documentation, and project write ups.

Experience

10+ Years

Level

Senior

Education

Data Warehouse

Description :

1. 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.
2. Met regularly with business partners to provide updates, acquire business decisions, and validate scope and direction.
3. Partnered with project managers to track projects and update the schedule status regularly in accordance with deliverable schedules.
4. Worked with individuals across different Finance groups to facilitate the creation or modification of reports and data as needed.
5. Provided business support for internal team and partners on new and existing customer Reporting initiatives.
6. Provided design recommendations for data and reporting solutions including development approach, solution integration and platform utilization.
7. Delivered lead managing offshore developers on Reporting related projects (Small Enhancements) assignments.

Experience

10+ Years

Level

Senior

Education

Computer Applications

Description :

1. Involved in system analysis & design of the Enterprise data warehouse implementation Created various database tables and procedures to update and clean the old data.
2. 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.
3. Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
4. Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
5. Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
6. Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
7. Reviewed and approved sign-off of developers reporting related test documentation in a Change Management Process.

Experience

2-5 Years

Level

Executive

Education

Bachelors In Technology

Description :

1. Designed data models using Erwin data modeler version 9.5.
2. Responsible for database design and maintenance.
3. Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables.
4. Worked on Views, Stored procedures, table valued functions, Triggers.
5. Involved with team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.
6. Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning.
7. 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.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. 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.
2. 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.
3. Designed and Developed the Framework Manager models using stored procedures, Relational tables and published in to server.
4. Created SQL Server Reports based on the requirements using SSRS 2012.
5. Ability to analyze and document business requirements, solve problems, and model current and future state Finance business/reporting processes.
6. Ability to perform basic project management functions and work independently to prioritize workload and handle multiple responsibilities and deadlines
7. Demonstrated ability to collaborate, communicate, build relationships, mentor and influence a community of reporting and data professionals across Finance business areas.

Experience

7-10 Years

Level

Management

Education

BE In Electronics

Description :

1. Actively worked with Business Partners and Designers to get the Requirements and create High level Application Design.
2. Prepared Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
3. Accessed and changed extremely large datasets through filtering, grouping, aggregation, and statistical calculation.
4. Consulted with customers and inside partners to accumulate necessities and set milestones in the research, advancement, and execution periods of the project lifecycle.
5. Developed, organized, managed and maintained graph, table, slide and document templates that will allow for efficient creation of reports.
6. Created cubes using packages which are built in framework manager.
7. Created users, users groups and maintained user access rights in Tableau.

Experience

7-10 Years

Level

Management

Education

Certification In Details

Description :

1. Worked with Cardinal was a great experience.
2. 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.
3. Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
4. Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
5. Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
6. Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
7. Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task.

Experience

2-5 Years

Level

Executive

Education

Bachelors