Sql/bi Analyst Resume
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