SUMMARY:

• Dynamic and results - driven BI Developer with Around 5+ years of experience in BI, Databases, AWS and Azure in addition to the right set of skills and attitude to get the job done. Looking forward to associate with a vibrant organization, to fully utilize my knowledge and skills which conduce to the overall growth of the organization.
• BI professional with rich experience in Data Analytics, Databases, Cloud and Scripting.
• Extensive experience of assisting in the development and upgrading of applications, tool optimization, user authentication and tool deployment.
• Extensive experience in MySQL and MSSQL Server with creating, managing and optimizing queries.
• Experience in creating and deploying parameterized reports using power BI.
• Experience in setting up embedded analytics development environment in Power BI.
• Worked on installation and up gradation of applications on Azure using Power BI.
• Embedded the content from Power BI and promoted the solution to production on Azure.
• Extensive knowledge and experience working in Agile-Scrum methodologies.
• Experience in creating views and models using SQL Server.
• Experience in creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.
• Strong understanding of Data warehouse concepts, ETL (SSIS, SSRS, SSAS), Fact Constellation, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling and dimension tables, physical and logical data modeling.
• Experience in Requirement Gathering, Technical Consulting, Process Mapping, Client interaction.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Developed, monitored and deployed SSIS packages.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Visual Studio.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Handled more than 1000 VM's in Public Cloud Azure Infrastructure in Deployments and
• Configuration Upgrades across Azure platforms and sub components with new builds and releases.
• Excellent organizational skill, highly efficient and a good eye for detail. In addition to that, also can play a key role in analyzing problems and come up with creative solutions as well as producing methodologies and files for effective data management.
• Good communication skills and report making.
• Good knowledge on Java and object-oriented concepts.

TECHNICAL SKILLS:

Databases: MySQL, MSSQL Server 2012/2008/2005 , Oracle, PLSQL, MS Access and MongoDB.

Programming Languages: C, C++, Java, Shell, C#, VB.NET, Python and Hadoop.

Software Tools and CLoud: Informatica, Rational Rose, Bugzilla, QTP, Selenium, MATLAB, Visual Studio, SAP, Tableau, Alexa skillset, SSIS, SSRS, AWS and Azure

Operating Systems: Windows Server 2012/2008/2003 , UNIX and Macintosh.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Power BI Developer / SQL BI Developer

Responsibilities:

• Developed and publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Developed ETL, using SQL Server 2008 R2/2012 Integration Services to migrate data from Oracle data source into SQL Server 2008 database and creating complex SSIS packages, DTS Packages.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Strong experience in Database design and multi-dimensional modeling (star schema and snowflake schema), data cleansing, scrubbing and integration.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Used Node.js (Typescript) to perform REST calls , to integrate apps with a Power BI dashboard in real-time. Also, integrated Power BI tiles and reports into apps.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including the current-status,
• MIS reporting & MDX Scripting experience with SSRS
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using SSRS and deployed them in Native mode.
• Monitor database performance and analyze issues, primarily with Microsoft SQL Server 2012/2014.

ENVIRONMENT: MSSQL Server 2012/2008/2005 , Power BI, MSBI (SSIS, SSRS), Scripts, AWS BI Analytical tools, Agile and SCRUM.

Confidential, Pittsburgh, PA

Power BI / SQL BI Developer

Responsibilities:

• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using
• Data Warehouse Design, ETL, BI, Client/Server applications.
• Responsible for building reports in Power BI from the Scratch.
• Worked on installation and upgradation of applications on Azure using Power BI.
• Embedded the content from Power BI and promoted the solution to production on Azure.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, CSV.
• Developed Power BI reports using query logic based on business rules, and visuals selected by Clients.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Expert in creating Star schema cubes using SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Experience in creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.
• Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibilities.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Provided maintenance and development of bug fixes for the existing and new Power BI Reports.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Used Microsoft Power BI Power Query 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.
• Handled more than 1000 VM's in Public Cloud Azure Infrastructure in Deployments and
• Configuration Upgrades across Azure platforms and sub components with new builds and releases.
• Worked on Azure Active Directory. Microsoft Azure date storage and Azure Data Factory, Data Lake, Big Data on Azure.
• Migrated SQL server to MS Azure cloud. And extending domain services to Azure.
• Worked with DAX queries in building expressions for various business calculations.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created different types of User-defined functions and stored procedures using T-SQL, ETL, data profiling, data quality and clean ups for SSIS packages.
• Created SSIS packages to populate data from various data sources.
• Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Developed Complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created, deployed report schedules and subscriptions. Managing and securing reports using SSRS.

ENVIRONMENT: MSSQL Server 2012/2008/2005 , Power BI, MSBI (SSIS, SSAS, SSRS), Scripts, Azure and Agile.

Confidential, Huntsville, AL

SQL MSBI Developer

Responsibilities:

• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Integration Services (SSIS).
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Deployed SSIS packages with package/project deployment models for testing and production.
• Wrote custom support modules for upgrade implementation using Pl/SQL, Unix Shell Scripts.
• Optimized report performance with caches and snapshots using SSRS.
• Proactively resolve issues to drive quality and system performance improvements across the application.
• Calculated Tables, Custom transformations (M-language) and Dynamic KPI (DAX) are used.
• Used basic statistics functions that are available in DAX to provide insights on descriptive analytics.
• Participate in cross-team information sharing resources and work to identify risks early in the development process.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers and maintaining Referential Integrity.
• Customized columns and tables utilizing Named calculations and Named queries in SSAS.
• Developed stored procedures with advanced programming techniques includes minimal logging, accurate execution plans and index seeking methodologies

ENVIRONMENT: MSSQL Server 2012/2008/2005 , MSBI (SSIS, SSRS & SSAS) and Scripts.

Confidential

SQL Database Developer

Responsibilities:

• Experienced with Drug and pharmaceuticals industry.
• Used ER mapping techniques to establish rules associated with the data sets.
• Used classification to classify future objects.
• Created documentation that shows the implementation of database, and how data extracted from
• Heterogeneous files. Involved in altering of tables and indexes.
• Installed, configured and maintained, 2008R2 SQL Servers, virtual and standalone environments.
• SQL server performance tuning, backup and recovery, replication, index maintenance, security, and troubleshooting.
• Developed moderate stored procedures, views, user defined functions, indexes, and constraints.
• Developed and supported Relational Database Management Systems (RDBMS).
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services.
• Created various SSIS packages to load health care Eligibility transactional data from various health care payers.
• Created various reports using SSRS for both internal use and clients.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine-tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Created necessary templates for various requirements gathering and documentation.
• Responsible for creating SSRS Report development of a new Solar Soft database for the Management team.
• Knowledge of Microsoft Office Suite
• Analyzed Query statements by using Estimated Execution plan, Tuning Advisor.
• Performed backups and recovery.
• Performance Tuning.
• Index maintenance, Disk Storage, Database shrinkage.
• Wrote transact SQL utilities to generate table insert and update statements.
• Wrote Shell scripts for automation of jobs, system monitoring and error reporting.
• Performed the administration of the Domain Name Server and configuration of the Database Files.
• Wrote bash shell scripts for getting information about various Linux servers.
• Installed and Configured Send mail Utility on UNIX Servers.
• Modified scripts using sh, ksh and bash for day-to- day administration.
• Automated tasks using bash shell scripts.

ENVIRONMENT: MySQL, DBMS, Shell Script Apache, bash, ksh and sh