- Having6.10yearsofProfessionalExperienceinITinvolvedinvariousphasesofdevelopmentand implementing SSIS packages to get data from different sources consolidated and merged into one single sourceto generateReports andVisualizationsusing BusinessIntelligenceTools.
- Designed and implemented relational databases, data marts and developed reports to allow users to easily access data.
- Developed reports with consistent drill-down functionality including Drill-down report and Summary report.
- Adopt in developing, publishing and scheduling Power BI reports as per the business requirements.
- Able to properly understand the business requirements and develop data models accordingly bytakingcare oftheresources.
- Good in developing and deploying the packages in SSIS.
- Created Dynamic time-based calculations like MTD, QTD, YTD, Prior, % YoY etc.
- Created Custom columns, Conditional columns, various measures, Partitions, Aggregations and KPI’s.
- Created Bookmarks in Power BI to move from one page to other page for easy navigation and creating Interactive visuals, publishing, refreshing & scheduling dashboards.
- DevelopedPowerBIReportsusingSlicerfilters, DAXcalculations, Bookmarks, DrillThrough andpublishedinPowerBIService.
- Having good experience with Power BI automation in exporting and distributing Power BI reports.
- Experienceincreatingarelationshipbetweentablesbyusingrelationshipsandcalculationsoncolumns andmeasuresusingDAXfunctions.
- Expert in developing Power BI reports and dashboards from various Data Sources like Databases, Excel files. And data design, data modeling (star-schema modeling, snowflake schema modeling, and fact & dimension tables), development, implementation, In Power Bi.Created highly efficient and complex reports, dashboards using Power BI Desktop by using of create attractive & interactive visualizations, using custom visuals and prepare dashboards.
- KnowledgeonSQLserver-SQLcommands, SetOperations, Joins, Views, CTE, StoredProcedures.
- Participates in the design and maintenance of the Database Management System (DBMS) including data modeling, extraction, cleaning, aggregation, transformation and validating the data to ensure accuracy and consistency.
- Good in database concepts like joins, sub queries, views, and procedures.
- Excellent skillsinunderstandinginbusinessneedsandconvertingthemintotechnicalsolutions by transforming the data into visuals and reports.
- Having basic knowledge on python and Linux.
Reportingtools : Power BI desktop, MSBI (SSIS, SSRS),Python
Database : MicrosoftSQLserver,Mongodb
Operating Systems : Windows Family and Linux
Project Name : Retail Analytics
Environment: MSBI, Power BI, SQL Server
Role : Developer
Torrid is one of the country's largest retail store chains having thousands of stores in US. This project helps to micromanage efficient, high-performance decision support systems, which integrate and aggregate the data from sales data from all of its stores and measure the effectiveness of the sales by reporting key performance indicators like profits generated. This solution provides the retailer's thousands of store managers with up-to-the-minute analysis. This project helps to analyze the business transactions and information. Apart from this project I had worked on three more projects in same module (Her Universe, Hottopic and Blackheart).
- Interacted with Business Analysts and stake holders to gather business requirements.
- Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc.
- Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
- Worked on DAX expressions like filters, time intelligence functions, mathematical functions and created calculated columns and measures using DAX expression in Power query.
- Responsible f