sr business intelligence developer resume example with 8+ years of experience
JessicaClaire
, , 609 Johnson Ave., 49204, Tulsa, OK100 Montgomery St. 10th Floor
Home: (555) 432-1000
Cell:
resumesample@example.com
:
Professional Summary
Successful SQL/BI/ETL Developer & Designer with 8 years of experience.
Focus on creating clean, robust code with exceptional security while meeting and exceeding customer demands.
Development and Support of Business Intelligence using Power BI, SQL Server, SSAS, SSIS, SSRS, Power BI, Informatica and Tableau.
Worked in various SDLC processes like Agile Scrum and Waterfall methods.
Provided training on Power BI and ETL to citizen developers and also involved in complex reports design.
An excellent Review, Analysis and Problem resolving skills in Technology for Financial, Commercial, HealthCare and Pharmaceutical domains.
Work History
Sr. Business Intelligence Developer, 07/2017 to Current Arthur J Gallagher & Co. – Arlington, TX,
Worked with diverse team of developers(12),business analysts and SMEs to determine/implement requirements for critical Financial applications integrating with Azure Cloud using Agile Workflow.
Developed complex ETL packages to extract and transform data from various sources like Flat files, Oracle, Progress, SQL server and load data to different destinations using SSIS/Informatica.
Created and automated SSIS packages to migrate data from legacy system(Progress) for Bank's de-customization to .Net applications which saved close to quarter million dollars.
Developed/Modified complex Informatica/SSIS packages for Ad-hoc, small and medium projects to analyze and strategize critical Financial decisions.
Designed and created MDX queries to retrieve data from cubes using SSIS.
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Used SSIS/Informatica to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
ETL workflows designed in DTS for overall data transfer from OLTP to OLAP with help of SSIS.
Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve passwords.
Involved in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations.
Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
Worked on complex Stored Procedures, Functions, Views and SQL queries.
Implemented various Audit Trail(CDC) for critical application based on business needs.
Created User Defined Functions to encapsulate frequently and commonly used business logic making system more modular, secured and extensible.
Worked on extracting and encrypting/decrypting sensitive data from Office of Finance(OOF) in Web Services using SSIS.
Worked on UI Data pop and Meta-data for populating data in EXCEL(Pivot) using SQL macros.
Created various SSRS reports using Report Parameters, Drop-Down Parameters, Multi-valued parameters, Debugging Parameter issues, Matrix reports and charts.
Developed Query for generating drill down and drill through reports in SSRS 2017.
Identified and worked with Parameters for parameterized reports in SSRS 2017.
Responsible for scheduling subscription reports with subscription report wizard.
Involved in modifying existing reports in SSRS and Exact ERP system.
Created reports in SSRS with different types of properties like chart controls, filters, Interactive Sorting, SQL Parameters etc.
Designed and implemented automated deployments for Database, SSIS, SSRS using Azure DevOps and TFS.
Created Power BI Reports and effective visualizations to publish them to Power BI service.
Created executive level Power BI reports for managing internal projects and pulled in data from Azure data lake for internal business users.
Expert in creating and designing SSIS Packages for Integration and Migration of data from XML, Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS, Log Shipping, DTS, Bulk Insert and BCP.
Involved in developing applications using ASP .NET /C# /SQL Server.
Created/Scheduled and implemented over 50 Jobs in Control -M(BMC) which is very critical for accounting run of organization.
Administered SQL server by creating user logins, dropping and locking logins, monitoring user accounts, creating groups, granting privileges to users and groups.
Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.
Sr.SQL BI/PowerBI Developer, 01/2016 to 07/2017 Gep – Houston, TX,
Assessed platform statistics to create customized, data-intensive BI analytics.
Extensively developed various Power BI reports using interactive Visualizations on Import Connection and published to Power BI service.
Developed reports on both Power BI report server and Power BI service.
Developed multiple custom visuals for various business teams using Power BI desktop.
Worked on complex DAX/MDX queries for facilitating calculated columns and measures in Power BI/SSRS reports which are extensively used by business users for day to day analysis.
Worked on embedding reports in critical Web Applications.
Added data sources to Power Bi gateway and mapped users to data source and created work spaces to add admins, members so can have access in Power BI Service and create self service dashboards.
Managed content packs, apps and workspaces with user access in Power BI service.
Extensively worked on migrating more than 50 SSRS reports to Power BI.
Created Scopes in cube to provide flexibility for users to see revenue in their local currencies.
Created SSRS and developed shared data sets for generating drill down, drill through reports.
Created multiple customized, on-demand, ad-hoc reports involving complex queries which involved in analyzing multi-dimensional reports in SSRS/Power BI.
Created roles and implemented security at department level to allow/restrict users to view data depending on departments belong to.
Designed ETL Packages to extract, transfer existing data into SQL Server from different environments for SSAS cubes.
Created dimensions in performance point server.
Imported data into Performance point server from SQL database through Flat files.
Consolidated data from OLTP databases into OLAP using SSIS as ETL.
Created parameterized stored procedures to implement business logic.
Created views on database for better performance and security.
Created SQL jobs and scheduled them for nightly loads.
Created SSIS package to get data from share point and load Cubes.
Deploy SSRS reports in Microsoft Office share point server.
Created archival jobs to archive last # iterations of data.
Involved in creation of reports using SSRS and Configuring SQL Server Reporting Service(SSRS).
Created workflow items in version control system (Visual Studio TFS) to assign work to team.
Tuned performance by making use of clustered and non-clustered indexes.
Rebuilding Indexes and Tables as part of performance tuning exercise.
Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
Performing query plans and making sure each and every query is using appropriate useful indexes.
Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
Created UTP document and performed unit test processing.
MDX queries to retrieve data from cubes using SSIS.
Created/Scheduled over 60 jobs in Tidal for refreshing cubes and multiple cyclical jobs to move critical data for business end users.
Environment: Microsoft SQL Server 2012, SSIS 2012, SSRS 2012, SSAS 2012, Visual Studio 2012, tableau 10, tableau 9.0, Planning Business Modeler, Microsoft Office share point 2007, windows 7, .NET Framework, C#, VB.
Monitored assessment software for performance, security and database availability throughout lifecycle.
Wrote and optimized SQL statements to assist business intelligence practices.
Sr.SQL BI/Tableau Developer, 08/2015 to 01/2016 Inventiv Health – City, STATE,
Designed application that collects client transaction volumes for WSS Custody and Sub-Custody products, applies unit costs, and produces monthly export to T&SS Costing system (CIIS).
Excellent Knowledge of HIPAA(Health Insurance Portability and Accountability Act) transaction codes such as 270/271(inquire/response health care benefits), 276/277(claim status), 470(benefit codes), 835(payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
Created Volume Automation to enable import and maintain unit costs and other reference data, as well as providing summarized MIS reports for administrative/integrity purposes.
Created functions and developed procedures to implement application functionality at database side for performance improvement.
Created Tableau wireframes for various lines of business.
Lead team of 3 tableau developers in assigning work to meet quality and deadlines.
Utilizing tableau server to publish and share reports with business users.
Built Stories in Tableau with various Data points to narrate data to end users.
Created and published Tableau Dashboards into Tableau Server.
Created action filters, parameters for preparing dashboards and worksheets using Tableau.
Created and Modified T-SQL stored procedures/triggers to validate integrity of data.
Created DTS and SSIS packages.
Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
Created SSIS package to get data from different sources, consolidate and merge into one single source.
Created ETL package for data conversion using various transformation tasks.
Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
Created dashboard to show business performance.
Created partitions and designed aggregations in Cubes.
Created perspectives in SSAS and configured security levels for Cubes.
Designed KPI's in SSAS and imported them to Excel.
Created datasets for reports using T-SQL and stored procedures.
Responsible for maintaining cubes using SSAS and populating cubes with data.
Responsible for Query optimization and Performance tuning.
SQL BI Developer, 12/2012 to 08/2015 Glasko Smith Kline – City, STATE, India
Involved in analysis, design and development of projects to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
Gathered business requirements, defined and designed data sources, data flows, data quality analysis, worked in conjunction with data warehouse architect on development of logical data models.
Created ETL packages using SSIS to move data from various heterogeneous data sources.
Created critical SSRS reports for analysis which increased sales by 12% for organization.
Created logs for ETL load at package level and task level to log number of records processed by each package and each task in package using SSIS.
Implemented error handling and roll back process in ETL load.
Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
Used XML and environmental variables in package configuration for Deploying SSIS packages.
Created region level security in reports to prevent users of one region from seeing data of different region and implemented subscriptions for Reports using SSRS.
Created Cross-Tabs, Drill-down and Sub-Reports using SSRS.
Deployed RDLs to Report Server.
Created Jobs Performance report that queries system tables to track duration of each job and weekly-average duration using SSRS.
Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
Designed SSAS cube to hold summary data for Targit dashboards.
Created User Defined Hierarchies depending on business requirement using SSAS.
Responsible for maintaining cubes using SSAS and populating cubes with data.
Created different measure groups and calculations using SSAS.
Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
Scheduling Jobs and Alerting using SQL Server Agent.
Created datasets for reports using T-SQL and stored procedures.
Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
Planned and engineered REST web services to manipulate dynamic datasets.
Completed full redesigns of existing websites to improve navigation, enhance visuals and strengthen search engine rankings.
Reviewed code to validate structures, assess security and verify browser, device and operating system compatibility.
Skills
Power Apps(4)
XML Web Services(3)
HTML(2)
Web API(2)
SQL Profiler(5)
Performance Tuning(7)
Database Design(5)
Data Modeling(4)
Data Migration(6)
Jira(4)
Confluence(4)
Control-M(4)
Tidal(3)
QNXT(3)
MS Access(3)
Visio(5)
Enterprise Architect(4)
BCP(5)
Visual Basic(3)
Agile(5)
Waterfall(3)
Education
Bachelor of Science: Electronics and Communication Engineering, Expected in to Andhra University - Vizag, India, GPA:
Certifications
Microsoft Power BI
AZ-900: Azure Fundamentals
AWS Certified Developer – Associate
,
Achievements & Events
Won Scrum champion of Month multiple times at IT Department level.
Scrum developer training in FHLB Dallas.
Trained citizen developers to excel in Power BI, SSRS and Power Apps.
Attended various SQL server sessions organized by Microsoft.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.