SUMMARY

• Over 5 Plus years of extensive experience and hands on working knowledge in various domains of IT industry as SQL/MSBI/Power BI Developer.
• Hands on experience in different versions of MS SQL Server with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Extensive experience with all phases of Software Development Life Cycle in different environments like Healthcare, Banking, Insurance, and Information Technology.
• Application knowledge in software development life cycle (SDLC), Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Experienced in Extraction, Transformation and Loading (ETL) process using MS - SSIS, DTS application tools.
• Experience in Handling Heterogeneous data sources, databases Oracle, IBM DB2 and XML files using SSIS.
• Strong experience in design, develop and deployment of the SSIS packages and SSRS reports using SQL Server Data Tools.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Well versed in Using MDX/DAX Queries to retrieve data from Analysis Services Cubes.
• Explore d data in a Variety of ways and across multiple visualizations using Power BI Desktop and Service.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS.
• Migrate existing data into the Power BI.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Used Microsoft Azure date storage and Azure Data Factory, Data Lake. Worked on creating Azure Data Factory for moving and transforming the data.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX)
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Well versed in managing and administrating Power BI Service app workspaces, user roles, publishing apps and setting data sources on enterprise gateways.
• In-depth understanding in client requirement Analysis, Logical design, development, Testing, Deployment, Support and Maintenance of business applications using SQL Server, DTS, SSIS, SSAS and SSRS.

TECHNICAL SKILLS

• RDBMS/DBMS: MS SQL Server, MySQL, Oracle and MS Access
• Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T - SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio
• Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Tableau, Excel.
• Programming Languages: T-SQL, PL/SQL, HTML, Windows Scripts
• Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SSAS, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL .

SQL SSIS / Power BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) including system study, interaction with users & management, designing, coding, testing and deployment of the system.
• Worked as an SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Creating table indexes and constraints to ensure data integrity and enhance query processing.
• Actively involved in requirements gathering/analysis, meetings with Business and provide description about the analysis and approach.
• Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
• Created and developed SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a time depending on requirements. Also, used SSIS to move data from text files to SQL Server.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Environment: MS SQL Server, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intact, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel.

Confidential, Dallas, TX.

SQL BI Developer

Responsibilities:

• Studied design documents and understood the business needs and the requirements for the project. Involved in discussion, peer review sessions to come up with an optimal design plan.
• Participated in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Designed and implemented Row Level Security & Roles for SSAS Tabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Created Dashboard and the App Workspace for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.

Environment: MS SQL Server, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Power BI Desktop, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel.

Confidential, Tracy, CA.

SQL Server/ MS BI Developer

Responsibilities:

• Worked in a scrum team that hold a standing up meeting every day, and Retrospective & Sprint Planning every two weeks
• Organized JRD meetings to gather business requirements from business users and SMEs.
• Created complex views statements with joins, sub queries, and correlated sub queries.
• Created complex SQL queries, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Wrote SQL queries and stored procedures to generate data for reports.
• Designed SSAS cubes on an existing data mart for slicing and dicing data from different perspectives as per the business requirements.
• Designed and demonstrated JSON Theme for standard customized visualization in Seattle Children's Power BI team like line chart, Card, Table, and KPIs.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data-to-data warehouse databases and deployed with minimal changes using XML configuration file.
• Generated matrix reports, drill down, and drill through, sub reports.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Created cubes in SSAS and build MDX queries to query cubes and to access cube's data.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.

Environment: MS SQL Server, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, T SQL, SQL Profiler, XMLA, MS Excel.