SUMMARY

• 7+ years of experience in data modeling, database design, administration, system analysis, development, implementation, programming of client - server applications and database systems using SQL Server 2000/2005/2008/2008 R2/2012, support of MS SQL Server.
• Extensive experience in data modeling, ETL (extract, transform and load), database design, development, tuning, optimization, and reporting.
• Application knowledge in software development life cycle (SDLC), agile, scrum, UML, waterfall, and project management methodologies.
• In-depth knowledge in ER modeling and dimensional modeling (star and snowflake schema) building dimension and fact tables.
• Explore data in a variety of ways and across multiple visualizations using power BI.
• Worked on power BI which acts like a cloud service that works with excel to provide a self-service BI.
• Responsible for creating SQL datasets for power BI and Ad-hoc reports.
• Used SSRS to create customized reports, on-demand reports, ad-hoc reports and was also involved in analyzing multi-dimensional reports.
• Expert on creating multiple kind of power BI reports and dashboards.
• Created, maintained & scheduled various reports in power BI like tabular reports. Migrate existing data into the power BI.
• Built user defined functions in SSRS using VB script.
• Experience in providing logging, error handling by using event handler, and custom logging for SSIS packages.
• Analyzing and extracting data by means of power query, pivot tables, MS excel, power BI.
• Far-reaching experience in designing, developing, and delivering business intelligence solutions using power BI.
• BI, SQL server Integration services (SSIS), analysis services (MDS), and reporting services (SSRS).
• Achieved data cleaning, data validation, and data analysis using data analysis expressions (DAX).
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Familiarity in data modelling (logical and physical design of databases), normalization and building referential Integrity constraints.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated.
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Expertise in solving dead locks/long running queries using performance monitor and SQL profiler.
• Good knowledge of data marts, operational data stored (ODS), MDM, OLAP, dimensional data modeling, star schema modeling, snow-flake modeling for FACT and dimensions tables using analysis Services.
• Performed test and deploy code across various SDLC environments.
• Created dashboard pages in share point server that use different types of web parts and excel services for reports.
• Built scorecard/dashboard pages in performance point server (PPS).
• Managed database security and implemented encryption/compression for sensitive data in the database.
• Expertise in business Intelligence process for data Integration and migration services.
• Created dimension types such as standard dimension, parent-child dimension, and role play dimension in SSAS.
• Experience in report generation using server reporting services (SSRS) from relational databases and OLAP cubes.
• Worked on creating multiple SSRS reports in drill-through mode and cross tab reports
• Created reports using stored procedure and Experience in building Reports on analysis services cubes (SSAS).
• Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, C, XML, HTML, DHTML, HTTP, Shell Scripting

RDBMS Servers: MS SQL Server Denali,2014,2012,2008R2,2008,2005,2000

DWH / BI Tools: SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Power BI, TALEND, Informatica, Visual Studio, Cognos, Crystal Reports.

Database design tools and data modeling: ERWIN 4.5/4.0, star schema/snowflake schema modeling, fact & dimensions, normalizations.

Packages: MS Office, Microsoft Office Suite, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, AWS

Tools: and Utilities: SQL Server Management Studio, T-SQL, OLAP, TFS, SQL Server Profiler, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS), Power Pivot, Excel Power Pivot, GitHub, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

Databases: Oracle 11g, MySQL, SQL, MongoDB, Cassandra, Azure SQL Database

Operating System: Windows, Linux, Unix, Mac, Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Power BI Developer

Responsibilities:

• Stored procedures, views were created depending on the project requirement.
• Deployment scripts were built soon after the developing each project.
• Created SSIS packages using pivot transformation, fuzzy lookup, derived columns, condition split, term extraction, aggregate, execute SQL task, data flow task, and execute package task etc. were created to generate underlying data for the reports and to export cleaned data from excel spreadsheets, text file, MS access and CSV files to data warehouse.
• Developed DAX measures in power BI to generate calculations ad-hoc.
• Developed tabular, matrix, chart, drilldown reports and parameterized, cascaded reports, MDX, DAX scripts, Store procedure s in SSRS Reports also deployed them into report builder.
• Executed complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed and implemented Row level security & Roles for SSAS tabular model and deployed into SQL SERVER ANALYSIS SERVER 2016.
• Coordinating with business users in analyzing business requirements and translating them to technical specifications.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Generate reports in power BI preview portal applying the SSAS tabular model via analysis connector.
• Made 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.
• Published power BI reports in the required originations and prepared power BI dashboards available in web clients and mobile apps.
• Depending upon the necessity troubleshooting the SSIS/SQL job Agent.
• Shaped page level filters, report level filters, visual level filters in power BI based on requirements.
• Developed Azure Data factory pipelines to move the data from source systems and transform the data in azure blob storage and created ADLA USQL jobs to transform the data in Azure.
• Worked with the different teams from the offshore and onshore for the production support and maintain the SQL data and SSIS packages and SQL agent jobs with 24/7 on call tech support and resolved the issues.
• Automated the SSIS packages using the SQL server agent jobs and octopus.
• Accountable on behalf of deploying the application for the integration, functional and user acceptance testing.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.

Environment: SQL Server 2014/2016, SQL Server Business Intelligence Development Studio, 2013,2015, SSIS, SSRS 2014/ 2016, T-SQL, .Net, Share Point 2013, VSTS Dashboard, T-SQL.

Confidential, Columbus, OH

Sr. MSBI Developer

Responsibilities:

• Worked in production environment in order to solve data issues in production database of OLAP and OLTP systems.
• Scripted T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Thorough knowledge in converting complex business logic into database design and maintaining it by using SQL tools like stored procedures, user defined functions, TSQL, triggers, views.
• Increased the performance of database by inspecting long running SQL queries and then creating suitable indexes on the tables.
• Built SSIS packages to obtain data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Used majority of the transformations, tasks, containers present in SSIS which include fuzzy grouping, derived column, conditional split, aggregate, lookup, row count, merge join, union all, multicast, sort, copy column, data conversion and other transformations during development.
• Built MDX queries and data mining expression (DMX) queries for analysis services & reporting services.
• Updated functional specification and technical design documents. Reviewed the existing OLTP system(s) and created facts, dimensions, and star schema representation for the data mart.
• Developed tabular model infrastructure in SSAS for various lines of business and created over different interactive dashboards using various visualizations in power BI desktop.
• To work toward designing OLAP/MOLAP SSAS, identify the dimensions, to plan schema designing strategy for implementing Cubes.
• Created views in DataMart’s on SQL server to support the reporting requirements.
• Defined relationships between dimensions and measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Data warehouse, business Intelligence architecture design and develop. Designed the ETL process from various sources into Hadoop/HDFS for analysis and further processing.
• Using power BI connect live to analysis service models for both tabular and multidimensional cubes and involve data migration from oracle to HDFS.
• Fetching data from different files with the help of query editor in power BI.
• Working with import and direct query, creating custom table in the power BI and merging and appending queries remove and split columns, choosing required columns in the data.
• Used various data visualizations by connecting power BI desktop to various data sources, working with different transformations, applied steps in query editor.
• MDX programming, DAX expressions, analysis, and business forecasts.
• Worked on adding tiles and images to the dash boards using power BI services.

Environment: Microsoft Visual Studio, Microsoft SQL Server 2012/2014/2016 , Server Integration Services 2012, SQL server Reporting Service 2012, Server Analysis Services 2012, XML, GitHub, Excel, SSDT, Windows Server, RDBMS, Windows XP, PL/SQL, Microsoft VSTS 2012, Windows7,10.

Confidential, O Fallon, MO

Sr. SQL Server/Powe BI Developer

Responsibilities:

• Involved in the requirement analysis, design phase and development phase of agile SDLC model system.
• Implemented 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.
• Expertise in SQL SERVER 2005, 2008R2, 2012, Share point 2012, SSRS 2005, 2008, 2012, SSIS, power BI, tableau, excel and TFS etc.
• Developed, supervised, and deployed SSIS packages for dynamic ETL flow to validate, extract, transform and load data into database.
• Participating in vendor selection for all BI platforms (MDM, Data Platform, and BI Reporting/Analytics) through RFP creation and review.
• Performed full load & Incremental load with several data flow tasks and control flow tasks using SSIS.
• Experience in designing and developing power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Developed and designed the different visualizations Charts, Line Charts, Pie Charts, Maps, Tiles, Cards, Images, Power View, tables, multiples visualization, Bubble and scatter chart, key performance indicator using Power BI tool.
• Involved in logical & physical data modeling.
• Created position and transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (loan position, commitment schedule, loan journal entry, loan journal entry period zero, time, loan, account, portfolio, property, business unit, borrower, journal entry demographic, journal entry line Item etc.) to address the business needs using SSAS.
• Created OLAP cubes to analyze multi-dimensional data stored in fact tables and dimension tables using SSAS.
• 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.
• 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.
• Developed parameterized, drill-through, and drill-down reports to get monthly customers account details and profits using SSRS.
• 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.
• Experience in using tableau Desktop and involved in preparation of user stories to create compelling dashboards to deliver actionable insights.
• Extensively worked on ETL packages to extract, transform, and load data from different sources like Excel, Flat files, Execute SQL Tasks, Data Flow Task, Derived Columns Tasks.
• Design and implement data warehouse solutions for SQL server databases including replication strategy and active-active and active-passive clustering.
• Created in extracting and transforming data (ETL) from azure database and creating packages using SSIS, Import, export data, bulk Insert and BCP utilities.
• Formatted the reports using the global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Performed data analysis and data profiling using SQL on various sources systems including SQL Server 2008.
• Improved performance by creating clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL SERVER 2000/2005/2008/2008 R2,2012, T- SQL, Power pivot, MS Excel 2010, Share point 2012, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), VB.NET, Visual Studio 2010, Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio.

Confidential

BI Developer

Responsibilities:

• Generated SSIS packages to load data into data warehouse database from source systems.
• Acquired data from Oracle, csv, excel and text files and loaded into destination tables.
• Created packages using complex transformations and control flow tasks such as script, File System, bulk Insert, FTP, send mail tasks, merge, merge join, look up, union all etc.
• Constructed logging files and configuration files to deploy packages from development to production environment.
• Created jobs and schedules to automate the process of running packages in SQL server.
• Formalized complex summary reports using SSRS to show region and channel wise sales.
• Developed Stored procedures as per the requirement to increase the query performance.
• Migrated excel reports to SSRS with added functionalities.
• Designed and developed pivot charts, car charts and pie charts which meet the business requirements.
• Automated the delivery of reports using subscriptions in SSIS.
• Built report models to facilitate client making Ad-hoc reports using report builder option in report manager web tool.
• Reviewing and testing the packages and fixing the errors.
• Generating complex transact SQL (T-SQL) queries, sub queries with the help of SQL server constraints such as (primary keys, foreign keys, defaults, check and unique etc.).
• Using analytical and troubleshooting skills performed tuning and optimization to achieve rapid issue resolution in large-scale production environments which are located globally.

Environment: MS SQL Server 2005, Microsoft Visual studio 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Visual Studio 2010, MS Office.