• As a full stack business intelligence developer for Dell, I have worked to understand the requirements of several products within dell, had comprehensive discussions with the business users, architects and team members, in order to develop dynamic and robust solutions in the process mining domain using Celonis for process mining, Streamsets for ETL and Microsoft business intelligence suite for the backend.• Worked extensively on Celonis process mining tool modules such as event collection, transformation, process analytics, action engine and studio to derive insights that can be used by business to make informed decisions.• Developed various complex transformation scripting in sql by using the data that has been extracted from various sources such as splunk, Teradata, green plum etc, to generate activities and cases that form the framework for the data model used in Analysis.• Scheduled and tracked the execution of celonis transformation jobs with full and incremental loads as per business requirements. Scheduled data model loads to provide data for process analytics.• Developed complex data pipelines using streamsets to extract data from various sources like Teradata, green plum, splunk etc and ingest it to production sql server.• Extracted data from various sources using streamsets components such as directory, expressions evaluator, field flattener, field merger, field pivoter, field type converter, jdbc lookup, jdbc producer, local fs, pipeline finisher executor. Developed jobs that perform historical load and incremental load and scheduled and monitored the jobs.• Led a data enablement project for a product through streamsets to extract more than 2 billion records and successfully completed the project. Provided root cause analysis and fine tuned the pipelines to resolve these issues for the future and backfilled the data. • Created databases, tables, cluster/non-cluster index, unique/check constraints, views, stored procedures & triggers.

• As the Business Intelligence Developer for St. Louis public Radio, I have helped the station understand its radio, digital (website, mobile, app, streaming and podcast) audience and donor base with my work on data collection, ETL, data analysis, data visualization and web analytics, under the supervision of the Director of Marketing & Digital Media. • Developed more than 30 key interactive and automated data visualization reports by collecting data from various sources like Google Analytics, Google AdWords, Facebook, twitter etc. and performing data cleansing and using effective data visualization techniques. These reports give insights into our performance and allow leadership to make informed decisions. • Participated in all phases for building a Data Warehouse for analysis, requirement gathering, Design and Development of code.• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Slowly Growing Target, and Simple Pass through Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.• Developed stored procedures and functions in SQL Server• Designed, developed, tested, and maintained Tableau functional reports based on user requirements. • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau. • Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently. • Created different KPI using calculated key figures and parameters. • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. • Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.

• As a BI Developer, I have worked with business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications.• Maintained the database schema and all project in Team foundation server(TFS) source code control.• Performed Extraction, Transformation and Loading (ETL) of data flows using SSIS with complex integration of SQL Server tables, oracle, flat files, excel files, comma separated files (.CSV) sources, and MS access files.• Expert in writing T-SQL, working with DTS (Data transformation services) data cleansing, data scrubbing and data migration.• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components.• Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches.• Hands on experience in writing SSIS script/script component task using C#, VB script for customized data manipulation of complex SSIS packages.• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.• Created report snapshots to improve the performance of SSRS.• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures & Triggers.• Tested to optimize the Stored Procedures and Triggers to be used in production.• Actively involved in Normalization & De-normalization of database.• Was involved in performance tuning of the Database.• Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on monthly and weekly basis.• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports. • Designed SSAS cubes for all the developed DataMart models and identify measures with proper aggregate functions applied. • Utilizing a variety of SQL based tools, BI tools, and Reporting tools to inform business decisions and actions. • Generated variety of business reports using MS SQL Server 2008/2012 SSRS including matrix report, parameter report, dashboard with charts and drill down function.• Create innovative executive dashboards, scorecards, and weekly/monthly reports on the status of key business performance indicators (KPI) using tableau.• Attending group meeting twice a week to discuss problems occur during someone’s work, trying to improve my technical skills by analyzing data, simplifying SQL codes, and improve the performances of the projects.• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.• Involved in performing database Backup and Recovery.