SUMMARY

• Hands on experience as BI/SQL Developer in visualizing reports using Power BI, Database Design, Development, ETL Implementations, Designing, Developing and Support of OLAP/OLTP/ Data Warehousing system and MS SQL and Microsoft Visual Studio (SSIS, SSAS, SSRS).
• Experience in Agile project management methodology with multiple releases, Sprints &Scrums
• Hands on experience in developing reports using Power BI Desktop and publish them to Power BI services and Power BI Report Server available through in Power BI Premium;
• Hands on experience in creating powerful intuitive and interactive dashboards and ad hoc reports;
• Significant experience creating Audit Log report, to manage how reports are being used, when, Who and for wat purpose being used, to control Power BI Report Server Subscription, most consumed reports, teh number of user and/or to trouble shoot for any issue;
• Experience in Power BI admin portal to manage Office 365 and Tenant Setting; Run usage matrix data to capture usage information and track reports and dashboard capacity usages in Power BI.
• Familiar with premium capacity management which involves Creating, Assigning and Deleting Admins and making changes for optimum capacity performance.
• Familiar with Power BI Report builder to develop Paginated reports.
• Embedded Power BI reports into SharePoint Sites and configured Power BI Workspaces;
• Experience in managing Power BI Subscription and managing users to access Power BI Reports;
• Proficient in teh use of Data Analytics Expressions (DAX) and Power Query
• Experience in authoring or co - creating custom visuals for Power BI Desktop & Report Server
• Significant experience in Conceptual, Logical and Physical Modeling.
• Extensive experience in Normalization and Denormalization modelling techniques
• Hands on experience in using SQL Server and T-SQL for developing Stored Procedure, Tables, Triggers, User Defined Functions, Indexes and SQL Join;
• Significant experience in writing SQL Views, Temporary Tables, Common Table expressions (CTE), Sub-Queries to perform CRUD operations and maintaining Data Integrity using constraints;
• Hands on experience in query optimizing by creating clustered, non-clustered and column stored indexes, by creating durable in memory tables and natively compiled stored procedures.
• Hands on experience in creating and Configuring ETL packages using SSIS with various transformations and tasks for data migration from different file source to destination.
• Hands on experience on teh concept and principals of Data Warehouse (DW) using Fact Table, Dimension Table, Star and Snowflake schema modelling.
• Experience in writing T-SQL query in populating Dimension and Fact tables in Data Warehouse from staging tables using Incremental approach;
• Experience working with business owners to gather and define requirements for report generation
• Experience in Developing high performing, reliable, and scalable Self Service (SS) BI solutions
• Aptitude to learn new subjects and emerging technologies and articulate their business implication

TECHNICAL SKILLS

Databases: MS SQL Server 2008R 2/2012/2014/2016/2017/2019, Azure SQL

ETL Tools: DTS (Data transformation services), (SSIS)SQL Server Integration Services

Reporting Tools: Power BI Desktop, Server & Service and Report Builder and SSRS

Data Mining Tools: SQL Server Analysis Services (SSAS)

Language skills: Transact SQL (T-SQL), My/SQL, PL/SQL, Python, C#, Visual Basic

Quantitative Statistical Tools: SPSS, STATA and R

Other Tools and Techniques: Office365,SharePoint, InfoPath Designer, Nintex Forms and Workflows, CSS, HTML, Slack, Trello, TFS (team foundation server).

Statistical Methods: ANOVA (Analysis of Variance), Multiple Regression Analysis, Chi-Square, Time-series Analysis, Correlation and R-Square.

PROFESSIONAL EXPERIENCE

Confidential, New Haven, CN

BI Developer

Responsibilities:

• Develop complex reports using Power BI Desktop, connecting live with Analysis Services and publish them on Power BI Report Server.
• Designed and developed different Ad Hoc reports with complex custom measures and columns using DAX to enhance power BI functionality and satisfy users requirements.
• Understood underlying data sources, data structures, and business use cases to ensure reports meet organizational and client needs.
• Manage Audit Log for report server by developing report using direct query with report server.
• Created Audit Log report, to manage how reports are being used, when and who used and for wat purpose being used. It was intended to control Power BI Report Server Subscription, most consumed reports, teh number of user and/or to trouble shoot for any issue.
• Designed and developed page navigation pane using bookmarks, buttons and Selection pane to smoothly navigate through different report pages.
• Implemented Cross Report Drill through using query string parameter by adding filter to teh URL.
• Designed advanced Power BI solutions using DAX to dynamically generate a report URL column to prefilter other report pages with in teh same or in a different PBIX.
• Implemented Synch Slicers for report level slicers by making them visible or hidden to users.
• Assist users in their Self-Service BI application.
• Customize Power BI Report themes using JSON file to satisfy company standards.
• Prepared report specification documents for reports and prepared Mock-ups.
• Manage subscriptions to access power BI reports on teh report server
• Designed a report page on teh report server using Button to “Website Accessibility Page” for compliances and consents.

Confidential, Columbia, MD

Database / BI Developer

Responsibilities:

• Designed and developed dynamic and complex reports and dashboards using Power BI Desktop and Publish it to Power BI Services and SharePoint Sites;
• Administered Power BI admin portal to manage Office 365 and Tenant Setting; Run capacity usage matrix data to capture usage information and track reports and dashboard usages in Power BI.
• Managed Power BI Subscription and give users permission to access Power BI reports;
• Created calculated measures in tabular model using DAX Queries to enhance Power BI functionality;
• Imported data from various sources such as MS SQL, Flat files, MS excel etc. to generate extensive reports and visualizations that give meaningful insights to teh business.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures, SQL joins and other T-SQL code.
• Optimizedthe performance of queries with modification in T-SQL queries,creating sub queries, CTE, Views and temporary tables, partitioning tables, establishing joins and creatingindexes.
• Worked with development teams in teh design and modification of physical databases to host memory optimized tables and Natively compiled stored procedures.
• Created ETL packages to migrate data from different data sources to staging tables by performing complex transformations using SSIS;
• Designed Data Warehouse Star and Snowflake schemas using Oracle Data Modeler
• Maintained historical data in Data Warehouse using Slowly Changing Dimension in MS SQL;
• Created Complex stored Procedures MS SQL 2017 to transform Data and load teh data from staging tables to Data Warehouse Dimension and Fact tables with incremental load.
• Developed Ad Hoc Report Model using SQL Server Analysis Service Tabular Model
• Worked with end-users to halp identify issues and to refine requirements
• Established and maintained working relationships with team members across teh organization

Confidential, Arlington Hts. IL

MS SQL / BI Developer

Responsibilities:

• Planned, designed, developed, tested, Debugged, monitored, & troubleshoot BI solutions.
• Analyzed functional specifications and assist in designing potential technical solutions.
• Performed impact analysis for systems/database modifications
• Developed and update report specifications to reflect technical implementations and modifications
• Assisted in teh development, execution, and documentation of system and integration test plans
• Wrote relational and multidimensional database queries
• Used T-SQL for creating various database Objects like Tables, View, Functions and Stored Procedure
• Developed SQL Queries to perform CRUD operations from multiple tables using joins
• Developed ETL workflows to load data into Dim & Fact tables usingSSIS Packages
• Created SSIS Packages using control flow tasks like Execute SQL Task, Data Flow Task, and FTP Task, Execute Developed SSIS packages using Lookup Transformations, Condition Split, Aggregate, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Worked extensively on Data Mapping Data Profiling for data integrity;
• Employed slowly changing dimension (SCD) to track changes and maintaining historical data;
• Developed summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Created Sub-reports, drill down, Summary, Parameterized and Ad-hoc Reports using SSRS.

Confidential, Washington D.C.

ETL /Database Developer

Responsibilities:

• Created Stored Procedures, Triggers, Functions, Tables, Views, SQL joins and other T-SQL code.
• Created SSIS process design architecting teh flow of data from various sources to teh target.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008R2.
• Used various tasks in control flow and data flow to cleanse and filter inconsistent data.
• Conducted and automated ETL operations to Extract data from multiple data sources, transform inconsistent and missing data and load it into teh Multi-dimensional data warehouse.
• Used Notification services to generate error messages and send them to teh user through e-mails.
• Developed T-SQL query to populate Dimension and Fact tables in Data Warehouse;
• Experience in building star schema and snowflake schema based on teh business data requirement.
• Designed report template for future use and Created custom and Ad hoc reports using SSRS.
• Maintained teh table performance by normalization and by implementing indexes on teh tables;
• Created Partition Tables based upon Partition Functions and Partition Schemas;
• Identified teh data sources and created source to target mapping documents to be used by teh packages in SQL Server Integration Services (SSIS).
• Used Notification services to generate error messages and send them to teh user through e-mails;
• Created incremental data load task using SQL Server Integration services
• Made various report and query parameters to create parameterized reports using SSRS 2008.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.