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