PROFESSIONAL SUMMARY:

• Over 5 Plusyears of extensive experience and hands on working knowledge in various domains of IT industry as SQL/MSBI/PowerBI 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 usingMS - 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 PowerBI 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 SQLServer, DTS, SSIS, SSAS and SSRS.
• Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, user profiles, relational database models.
• Experience in developing Custom Reports, Parameterized reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Involved in Every stage of Report authoring, managing, developing, deploying.
• Experienced in using global variables, expressions and functions for the reports.
• Involved in designing and developing enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in writing MDX queries and in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Good Working experience in designing STAR, SNOW FLAKE Schemas, database modeling, logical and physical database design using Erwin and Knowledge of how the Kimball approach has been implemented in the Microsoft BI tool.
• Strong knowledge and exposure tocreatingJobs, Alerts, SQL Mail Agent and scheduled SSIS Packages.
• Involved in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard
• Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.
• Excellent Communication and interpersonal skills.

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.

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, Topeka, KS

MSBI/ SSIS 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).
• Exclusively used SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Worked extensively with SSIS for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS packages for transforming data from warehouse to mart, to import data from source systems, or transfer data from one server to another.
• Designed daily/weekly/monthly SSRS reports utilizing multiple types of reports including sub reports, Drill Through/Drill Down, and Cascading Parameterized Reports.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Worked on creating pipelines in ADF to trigger existing SSIS package deployed in SSIS Catalog through LIFT and SHIFT Existing SSIS Package method in V2 of Azure Data Factory.
• Used various sources to pull data into Power BI such as SQL Server, SQL Azure, Azure Data Lake store, Analysis service, Excel etc.
• Generated Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Used Power View and Power Map to visualize reports in Power BI.
• Used Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Coordinated and attended every day standup's/scrum/agile meetings and weekly sprint meetings to evaluate completed work.
• Worked efficiently on Agile Methodology and Microsoft Team Foundation Server (TFS).

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, Des Moines, IA

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.
• Used One Drive for storing different versions of Power BI report.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS
• Created or modified Databases, tables, indexes, views as per the requirement and analysis of records that are integrated from call records, online filing records.
• Designed, implemented and tested SSIS packages to load the records from multiple sources like Flat file, xml files and SQL server
• Performance tuning of SSIS packages and debugging, error handling using breakpoints, checkpoints used send mail task to notify the appropriate department regarding the progress.
• Modified various views, stored procedures, indexes which were affecting the performance

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, Minneapolis, MN

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.

Confidential

Data Analyst

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.

Environment: MS SQL Server, Microsoft Windows