We provide IT Staff Augmentation Services!

Sql/bi Analyst Resume

2.00/5 (Submit Your Rating)

Dallas, TX

SUMMARY:

  • Persistent IT professional with an experience of over 6 years in performing data analysis, data profiling, cleansing, validation, and verification with SSIS tasks/transformations and SQL scripts
  • Skilled in optimizing issue resolution procedures for large - scale production environments in SSIS.
  • Expertise in creating reports such as ad-hoc, drill-down, drill-through, cross-tab, sub-reports, tabular, parameterized reports and cascade parameterized reports utilizing SSRS.
  • Demonstrated excellent communication, analytical and negotiation skills in the completion of projects.

TECHNICAL SKILLS:

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, Azure Storage

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL/BI Analyst

  • Collaborated with project manager, developers and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
  • Participated with team members to understanding the database and generating various interactive reports.
  • Developed the logical and physical data model and designed the data flow.
  • Performed normalization of the existing OLTP systems to speed up the DML statements execution time.
  • Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application and Reports team during development.
  • Designed and optimized SQL batches to perform bulk operations in the OLTP environment.
  • Incorporated SSIS packages to load data into the data mart with star schemas.
  • Integrated data from multiple sources such as SQL table, XML files and flat files into the staging area.
  • Worked on SSIS packages performance tuning, error handling, and re-running of failed SSIS packages utilizing checkpoints and scripting.
  • Managed the execution and security of SSIS packages on the Integration Services Server.
  • Enhanced different cube objects such as KPI’s, calculations and perspectives as per the requirement.
  • Created content packs utilizing Power BI services to share reports/dashboards to groups.
  • Published the Power BI reports to different workspaces as per the business requirements.
  • Identified and created KPIs in Power BI such as food stock, turnover rate, gross profit and carrying cost.
  • Created variety of reports utilizing SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report.
  • Generated and published on-demand and scheduled reports with SSRS for business analyses and managerial decisions.
  • Implemented TFS for version control and change management of BI solution for cross-functional communications.

Tools: & Environment: SQL Server 2016, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, Erwin, TFS, Power BI, SQL Profiler, DTA

Confidential, Irvine, CA

BI Analyst

  • Collaborated with the business stakeholders towards understanding and prioritizing the business requirements.
  • Followed quality guidelines and procedures along with necessary documentation
  • Integrated the work tasks with relevant teams for smooth transition from testing to implementation
  • Identified and mapped various data sources and their targets successfully to create a fully functioning data mart.
  • Created and maintained logical data model for the project representing entities, attributes, data relationships, primary and foreign key structures.
  • Scripted T-SQL queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & database triggers.
  • Optimized queries by modifying T-SQL queries and eliminated redundant data.
  • Designed and developed SSIS packages to extract data from multiple data sources and loaded data into destination tables.
  • Created SSIS packages for data profiling and cleansing with multiple tasks/transformations.
  • Optimized the performance of SSIS packages with non-blocking transformations and multiple properties.
  • Implemented a multi-dimensional database utilizing OLAP cubes and applied appropriate storage mode.
  • Designed interactive dashboards utilizing slicers, filters and various data visualizations in Power BI.
  • Implemented DAX expressions to create customized calculations, measures and hierarchies in Power BI Desktop.
  • Assigned row level security (RLS) filters to users/groups for reports/dashboards on Power BI services.
  • Installed, configured and managed Report Server and scheduled report delivery using data driven subscriptions in SSRS.
  • Participated in utilizing Team Foundation Server (TFS) for the version control and project co-ordination.

Tools: & Environment: SQL Server 2012, Erwin, SSDT, SSIS, SSAS, SSRS, Power BI, T-SQL, Erwin, MS Excel, TFS, DTA

Confidential, Irvine, CA

SQL BI Analyst/Developer

  • Organized business requirements gathering sessions and translated the business requirements into system / technical requirements.
  • Assisted in designing and optimizing complex stored procedures to perform data profiling and auditing in the pre-staging database.
  • Established multiple isolation levels with lock mechanisms to avoid deadlocks.
  • Optimized performance in relational and dimensional database environments by making proper use of indexes and partitioning techniques.
  • Created the ETL strategy from source to destination utilizing a staging area for data cleansing and loading.
  • Participated in creating packages with SSIS tasks, transformations, and containers.
  • Utilized tasks such as Execute Process task, Execute Package task and Execute SQL tasks in SSIS for different business operations.
  • Configured parameters and deployed packages on the production server with the project deployment model.
  • Optimized slowly running cubes utilizing hierarchies, attribute relationships and aggregations in SSAS.
  • Developed SSRS reports utilizing relational databases and OLAP cubes.
  • Successfully automated report deliveries to multiple recipients with subscriptions in SSRS.
  • Generated SSRS reports with parameters and embedded functions with expressions.
  • Utilized different visuals such as table, matrix, bar chart and cards to represent interactive data in Power View.

Tools: & Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSDT, SQL Profiler, Erwin, DTA, Power View

Confidential, Santa Ana, CA

BI Developer

  • Collaborated with business users for business requirements enhancement through JAD sessions.
  • Outlined multiple constraints in logical phase of the data modeling life cycle.
  • Designed logical and physical data models utilizing the Erwin data modeler tool.
  • Wrote CTEs and ranked functions to remove duplicate records in OLTP tables.
  • Assisted in the modification of temporary tables and indexes to optimize stored procedures.
  • Analyzed source OLTP systems and created data mapping documents for the ETL process.
  • Created and developed packages with multiple transformations to cleanse data and apply business rules.
  • Created SSAS cubes and aggregations to facilitate quick response from the reporting application.
  • Delivered SSRS reports on daily and weekly basis utilizing subscriptions.
  • Created Power Pivot models by extracting data from different sources in Excel.

Tools: & Environment: SQL Server 2008 R2, T-SQL, SSIS, SSRS, SSAS, BIDS, SQL Profiler, MS Visual Studio, Erwin, MS Excel, Power Pivot

Confidential, Irvine, CA

SQL Developer

  • Transformed business requirements into technical and functional specifications.
  • Wrote stored procedures, functions and triggers per requirements.
  • Performed normalization and de-normalization of existing tables, thereby improving query processing.
  • Created functions to provide custom functionalities according to the requirements.
  • Designed stored procedures to implement data profiling, data validation, and verification.
  • Optimized slowly running queries and procedures utilizing SQL profiler and DTA.
  • Assisted in the development of SSIS packages to extract data from sources such as SQL Server OLTP, excel, and flat files.

Tools: & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSIS, SQL Profiler, DTA

We'd love your feedback!