Data Analyst Power Bi
Resume:
Rashmi Mishra
****************@*****.***
Role: Sr. BI Developer/ Sql Developer
Professional Summary:
•7+ years of IT experience working in SQL environment including development System Analysis, Design, Implementation, Power BI environment, Data Warehouse, Administration and Support of MS SQL Server in Production and Development Environments.
•Experience installing, configuring, managing, backup, recovery, monitoring and troubleshooting SQL Server.
•Experience in Performance Tuning and Query Optimization.
•Experience in Mirroring, Log Shipping, Database Partitioning, Replication and Clustering.
•Experience in creating Tables, Procedures, Functions, Views and other database objects using SQL and PL/SQL.
•Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and reporting tools.
•Experience in writing Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
•Experience in converting MS Access queries to SQL Server queries.
•Extensive Experience in tuning the performance of Stored Procedures and long running queries.
•Experience in Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
•Hands on experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues and expertise in Production migration of new releases and Enhancements.
•Expert in VBA code and applications and created reports using SSRS with MS SharePoint.
•Experience in Database Backup, Recovery and Disaster Recovery Procedures.
•Experience in coordinating the work with offshore team.
•Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.
•Experience in creating different Power BI Reports across multiple visualizations.
•Experience in developing Custom Calculated Measures using DAX in Power BI to satisfy business needs.
•Proficient in Designing Power BI data visualization cross tabs, maps, scatter plots, pie, bar and density charts.
•Experience in installing and configuring Enterprise gateway and Personal gateway in Power BI.
•Experience in Tableau Server and Tableau Desktop in various versions of Tableau 9.x/10.x
•Strong knowledge in designing and developing Qlik Sense dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.
•Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
Integration Services (SSIS):
•Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
•Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Oracle, Flat file, CSV, SAP S/4 HANA, Azure) by using multiple transformations provided by SSIS.
•Proficient in usage of SSIS Control Flow items (For Each Loop, For Loop & Sequence container, execute package, execute SQL tasks, Script task, send mail task) and transformations (Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast).
•Hands on experience on ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
•Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
•Deployed SSIS packages to different environments.
Reporting Services (SSRS):
•Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
•Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
•Experience in using SQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
•Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
Analysis Services (SSAS):
•Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services.
•Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
•Experience in creating and managing SSAS Tabular models, creating Dimension Tables and Fact Tables.
Technical Skills:
SQL Server Tools
SQL Server Management Studio, Enterprise Manager, Query Analyzer, Profiler, Export & Import (DTS)
Programming Languages
C#.Net, VB.Net, SQL, T-SQL, PL/SQL, HTML, XML, AWS, Bootstrap, JQuery, Mainframe
Databases
MS-SQL Server 2000/2005/2008/2012/2014/2016, MS Access 2007 &2010, Oracle 7.x to 11g/12c, Amazon Redshift, Netezza
Operating System
ETL Tools
Windows NT, 2000 Advanced Server/ Enterprise Server 2003/, Win XP Prof/Standard, Win 98, HP UNIX 10.x, Solaris 8.x and UNIX.
MS SQL Server Integration Services (SSIS), Informatica
Reporting Tools
MS SQL Server Reporting Services, SSRS, Crystal Reports, Power BI Desktop, Tableau, ThoughtSpot, Qlik Sense,Business Objects XIR2, PS Query, BEX Analyzer, Web -Application Designer, Report Writer, Cognos 7.0.
DB Design Tools
ERWIN
Office Suite / Tools
MS SharePoint2010/2013, MS Office (Word, Excel, Power Point, Access) 2007/2010
Professional Experience:
Client: NCS Pearson Malverna PA June 2022– Present
Role: SQL/MSBI Developer
Responsibilities:
•Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
•Involved in identifying the project stakeholder goals and defining project scope.
•Identified business objectives and the corresponding business requirements.
•Created database maintenance plans for monitoring database integrity and performance.
•Optimized Indexes for better performance by analyzing their Query Plans.
•Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
•Developed User Defined Functions for giving Scores and views for the application.
•Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
•Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
•Maintained Batch logging, Error logging tables and handled errors using Event handlers.
•Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
•Created Customized reports using Power BI.
•Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
•Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
•Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
•Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters
•Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
•Created applications and utilities using PL/SQL.
•Designed Perspectives and Hierarchies in SSAS Tabular model.
•Deployed Power Pivot model to SQL server Analysis services tabular instance.
•Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
•Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
•Formatted the reports using the Global variables and expressions.
•Developed Power BI Reports and Dashboards from multiple data sources using data blending.
•Developed Custom Calculated Measures using DAX in Power BI to satisfy business needs.
•Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
•Installed and configured Enterprise gateway and Personal gateway in Power BI.
•Developed Power BI Reports and Dashboards from multiple data sources like SAP S/4 HANA, Azure, Oracle
•Implemented Row Level Security by defining various constraints for User Roles.
•Developed Power BI Paginated Reports.
•Created Qlik Sense dashboards using different objects like List Boxes, Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Bar charts, Combo charts, Straight tables, Pivot tables, Buttons, Containers.
•Reviewed and fine-tuned stored procedures and triggers before production migration.
•Developed Tableau visualizations and dashboards using Tableau Desktop.
•Created scripts to load data into ThoughtSpot.
•Created Worksheets and Pin Boards as per the business requirement using ThoughtSpot.
•Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
•Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
•Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.
Environment: MS SQL Server 2016, T- SQL, PowerPivot, MS Excel 2016/2014, SSIS, SSRS, SSAS, Power BI, Qlik Sense, SQL Server Business Intelligence Development Studio, AWS, MS Project, Oracle, PL/SQL, Amazon Redshift,XML, TFS, VSS, Erwin 8.0/MS Visio 2010,Tortoise, SVN.
Client: Nov 2021 – Jan 2022
Role: BI Developer/ Sql Developer Trigent Software Solutions LTD, Bangaluru India
Description: The project involves working on the Migration of Legacy Data to SQL Server Database which connects to the Application. Optimize the existing processes to make it cost efficient by using SQL BI Strategies.
Responsibilities:
•Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
•Identified business objectives and the corresponding business requirements.
•Created Business Use Cases and corresponding Atomic Use Cases.
•Rebuilding the indexes at regular intervals for better performance.
•Involved in Capacity Planning for databases.
•Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
•Developed User Defined Functions for giving Scores and views for the application.
•Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
•Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
•Maintained Batch logging, Error logging tables and handled errors using Event handlers.
•Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
•Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
•Designed SSIS to create ETL Packages to extract, transfer, load (ETL) existing data into SQL Server, Data warehouse databases from different environments for the SSAS cubes.
•Involved in SSIS packages Up-gradation from 2008 to 2012.
•Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
•Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters
•Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
•Developed Power BI Reports and Dashboards from multiple data sources using data blending.
•Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
•Installed and configured Enterprise gateway and Personal gateway in Power BI.
•Developed Custom Calculated Measures using DAX in Power BI to satisfy business needs.
•Implemented Row Level Security by defining various constraints for User Roles.
•Designed Perspectives and Hierarchies in SSAS Tabular model.
•Writing complex DAX functions in Power Pivot.
•Used various sources to pull data into Power Pivot model.
•Deployed Power Pivot model to SQL server Analysis services tabular instance.
•Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
•Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
•Formatted the reports using the Global variables and expressions.
•Reviewed and fine-tuned stored procedures and triggers before production migration.
•Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
•Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
•Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.
Environment: MS SQL Server 2012, T- SQL, PowerPivot, MS Excel 2007/2003, SSIS, SSRS, SSAS, Power BI, SQL Server Business Intelligence Development Studio, MS Project, Oracle, PL/SQL, XML, TFS, VSS, Erwin 8.0/MS Visio 2010,Tortoise, SVN.
Client: Symbiosys, Visakhapatnam, India Jan 2020 – Nov 2021
Role: SQL Server Developer
Description: A mission-driven, nonprofit organization dedicated to leveraging technology innovation to improve consumer access to eligible health and human services, working on App, their health and social services enrollment application used in several states.
Responsibilities:
•Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
•Involved in identifying the project stakeholder goals and defining project scope.
•Managed customer expectations for project outcomes to ensure full understanding of risks, trade-offs and scope alterations.
•Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.
•Performance tuning of the stored procedures, User defined functions and long running queries.
•Automated the ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa using SSIS.
•Analyzed and designed business processes as per the business requirements with SSRS reports.
•Created various dynamic reports using SSRS and Crystal reports.
•Involved in SSIS packages Up-gradation from 2005 to 2012.
•Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS) and used the SSAS as source for generating parameterized reports in SSRS.
•Used ROLAP tools to access the data in a relational database and generate SQL queries to calculate information at the appropriate level when an end user requests it.
•Created reports and Data access from MDX and OLAP.
•Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
•Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008 Integration Services (SSIS).
•Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and Views to other databases or files with proper mapping.
•Migrating SQL Server 2008 databases into SQL Server 2012.
•Applied conditional formatting in SSRS to highlight key areas in the report data.
•Involved in migration of crystal reports to SSRS 2008.
•Identified the dimension, fact tables and designed the data warehouse using star schema and created complex reports using IREPORTS tool.
•Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
•Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
•Created calculated measures and dimension members using multi-dimensional expression (MDX).
Environment: MS SQL Server 2005/2008, OLAP, ROLAP, Visual Studio 2005/2008, Windows 2007, Windows XP, T-SQL, XML, Crystal Reports, SSAS, SSRS, SSIS.
Client: Hexaware Technologies, Chennai, India July2017–Dec2019
Role: SQL Developer
Responsibilities:
•Implemented the database for production and marketing purpose.
•Designed databases for OLTP applications
•Created tables, indexes and constraints.
•Performed administration tasks of Database Mirroring, database backups and restore servers in SQL Server 2005.
•Enhancing and deploying the SSIS Packages from development server to production server.
•Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
•Created Triggers, Stored procedures for implementing the business logic.
•Managed Database files, transaction log and estimated space requirements.
•Configured and monitored database application.
•Designed and implemented several complex reports
•Designed VB forms using the forms and crystal reports were made for business reporting purpose.
•Created stored procedures for module integrity and application.
•Wrote database triggers in T-SQL to check the referential integrity of the database
•Managed ongoing activities like importing and exporting, backup and recovery.
•Administered of all SQL server database objects, logins, users and permissions in each registered server.
Environment: SQL server 2000, Visual Basic 5.0, Win NT.
Contact this candidate