SUMMARY

• 8+ years of professional experience in the software development field with specialty in Business Intelligence solutions primarily with the Microsoft SQL Server BI platform.
• Extensively worked in Agile methodologies by embracing project management best practices.
• Extensive experience in Database design and development using SQL Server 2008/2012/ 2016/2017/2019 / SSIS/SSRS/SSAS.
• Expertise in developing OLAP cubes using SSAS, with required partitions and aggregations to optimize cube performance and usability.
• Expertise in T - SQL (DDL, DML), Joins, indexes, views, stored procedures and database triggers to implement security and business logic.
• Extensive experience in using Extraction, Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS).
• Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.
• Experienced in developing different types of reports like Ad hoc reports, matrix reports, tabular reports and drill down reports using SSRS.
• Experienced in developing BI reports and dashboards using Power BI and Pyramid Analytics.
• Experienced in creating custom calculated measures using (DAX) in Power BI and (MDX) in and Pyramid Analytics.
• Experience in Query Optimization, troubleshooting procedures and T-SQL codes.
• Experienced in interacting with end users and gathering business requirements.

TECHNICAL SKILLS

• MS SQL Server 2008/2012/ 2016/2017/2019
• MS SQL Reporting Services
• MS SQL Server Analysis Services
• MS SQL Server Integration Services
• Oracle SQL Developer
• Pyramid Analytics
• Power BI

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Developer

Responsibilities:

• Worked on the design and development of a new Data Warehouse for the organization.
• Worked on the development and maintenance of multiple process for the data warehouse.
• Designed and developed multiple cubes using SSAS.
• Actively involved in the development and maintenance of multiple ETL packages using SSIS.
• Developed several complex scripts using T-SQL.
• Worked extensively on creating triggers, stored procedures, views etc.
• Worked extensively on creating reports and dashboards using SSRS, Power BI and our in-house reporting suite in the CRM.
• Developed custom calculated measures using (DAX) in Power BI to satisfy the business needs.
• Provide analytical, complex and specialized client service analysis using Power BI dashboards.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• As the Lead Developer in the Reporting team played a leadership role in mentoring and training junior members of the team.

Environment: Windows OS, MS SQL Server 2016/2017/2019 , MS SQL Server Analysis Services, MS SQL Server Reporting Services, MS SQL Integration Services, Power BI.

Confidential

BI Developer

Responsibilities:

• Developed new OLAP cubes and modified existing cubes using SQL Server Analysis Services.
• Created Views in the database with various transformations using MS SQL Server to be used as dimensions in the cubes to obtain desired results.
• Created calculated fields and named queries within the cubes using different functions.
• Successfully created cubes using both star schema and snow flake schema.
• Partitioned the cubes and created aggregations as per performance requirements.
• Created dynamic partitions for some cubes to enable limited storage of data.
• Trouble shooting Problems and monitoring performance by using SQL server profiler. Pre-actively identifying the problems before user complaints.
• Created bioXL reports using Pyramid Analytics v5.3 and v5.4 for multiple projects.
• Created bioPoint dashboards for reports in Pyramid Analytics v5.3 and v5.4.
• Created reports using MS SQL Server Reporting Services for multiple projects.
• Extensively worked on Cross Tabbed and Matrix reports using SSRS.
• Created processing packages for various cubes using MS SQL Integration Services to ease cube refresh for each month.
• Created Stored Procedures which generated the necessary Fact and Dimension tables and Functions that allowed performing necessary calculations depending upon the requirements.
• Creating datasets and querying in Oracle SQL developer.
• Provided training for the Pyramid Analytics tool to the Underwriters, Business and other developers.
• Helped in training interns and other developers on SSAS cubes.
• Created SSRS reports using SSAS cubes as source, writing the dataset queries in MDX.

Environment: Windows OS, MS SQL Server 2008R2/2012, MS SQL Server Analysis Services, MS SQL Server Reporting Services, MS SQL Integration Services, T-SQL, SQL Server Business Intelligence Development Studio, SQL profiler, Oracle SQL Developer, Pyramid Analytics.

Confidential

MS SQL Server Developer

Responsibilities:

• Assisted in the Analysis and Design of database.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Created Stored Procedures which generated the necessary Fact and Dimension tables and Functions that allowed performing necessary calculations depending upon the requirements.
• Developed logical and physical data model using MS Visio and mapped the data into database objects.
• Designed and created different ETL packages using SSIS from Oracle source to SQL server 2008R2.
• Created SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets.
• Designed and implemented SSIS packages for data integration.
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them.
• Designed and implemented indexing to optimize transactional and reporting performance.
• Created and assisted in maintaining various OLAP cubes using MS SQL Server Analysis Services.

Environment: Windows OS, MS SQL Server 2008R2, MS SQL Server Analysis Services, MS SQL Server Reporting Services, MS SQL Integration Services, T-SQL, SQL Server Business Intelligence Development Studio, SQL profiler, Oracle SQL Developer.