PROFESSIONAL SUMMARY:

• 6 (six) years of experience in IT experience as Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT)
• 3 years of experience in developing data visualization using Tableau Desktop versions 8.1/9.x/10, Tableau Reader, Tableau Public, and Tableau Server.
• 3 years of experience in data analysis and developing interactive dashboards using Power BI Desktop and Web.
• Involved in Business Analysis of the OLTP and OLAP data and in decision support. Extensive in database Programming.
• Experience in data warehousing such as dimensional modelling, ER modelling, star and snowflake schemas, data marts, fact and dimension tables identification, and Operational Data Store (ODS).
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources and integrates data based on business logic and to load into data warehouse.
• Experience in working/migration of data with SSIS (SQL Server Integration Services) as an ETL tool for Data integration services and business applications. Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion
• Maintaining the log and Audit information in SQL tables, experienced in providing logging, error handling by using event handler in SSIS.
• Experienced in building SSAS cubes and Dimensions with different acritudes and data sources for business intelligence and writing MDX Scripts.
• Creating Named Queries and Named calculations. Creating Dimensions, Hierarchies and levels, Star and Snowflake schemas using SSAS.
• Having knowledge in Data Modelling, Data Mapping, Table Normalization, Optimization and Tuning, RDBMS concepts and constructs, Kimball and Inmon Data warehousing methodologies.
• Extensive experience in Data Migration between homogeneous & heterogeneous systems using various tools (DTS Import/Export Data, Bulk Insert and BCP, SSIS)
• Mastered in creating solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop or Power BI.
• Experienced in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Experienced in using python (Pandas, NumPy) for data analytics.
• Proficient in technical writing and presentations and a good team player.

EDUCATION: Master’s in engineering, Cornell University, NY

TECHNICAL SKILLS:

Analytical Tools: Power BI, MS Excel (VBA), SSAS, Power Query

Reporting Tools: Tableau, MS SSRS

RDBMS: MS SQL Server 2005/2008 R2/2012/2016, MS - Access, MySQL, Oracle

ETL Tools: SSIS 2008R2/2012

Programming Languages: T-SQL, MySQL, R, Python

Operating Systems: Windows server 2008R2/2012

Software and Tools: MS Visio, MS Office, R Studio, Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

SQL/BI Developer

Responsibilities:

• Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database
• Created Packages which includes Control flow tasks, Data flow tasks, Event Handlers, Breakpoints and Checkpoints in SSIS.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Used Package Logging feature to troubleshoot problems that occurred during the execution of the package during run-time.
• Identified the problems in the data and fixed them on the data flow and validation objects of SSIS. Whenever a new pattern of data problem appears on the incoming data, the problem is logged into the log file, and data is analyzed and immediate solution is provided, validated and implemented into production.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Used Kimball methodologies to build dimensional model in Datawarehouse.
• Scheduled the SSIS Packages to be run on different environments and monitored the process.
• Added custom logging to new and existing SSIS package to track performance of runtime process.
• Created Reports using SSRS Dashboard - Parameterized, Drill Through, Drill Down, Link, Chart, Gauge report based on parameter and scheduled Monthly, Quarterly, Daily reports.
• Created summary and executive dashboards using Power BI Desktop and deployed reports to Power BI Service.
• Developed OLAP cubes using SSAS and calculating measures and dimension members in SQL Server Analysis Services using multidimensional expression (MDX), mathematical formulas, and user-defined functions
• Performed Database administration tasks such as taking backup of tables and databases, Restore a database by moving data from one database of a server to another database of a server using import and export.
• Created various stored procedures using Dynamic SQL, advance T- SQL techniques like Common Table Expressions, ranking functions etc using SSMS.
• Created logical mapping documents and converted into physical mapping document.
• Worked on de-duplication data using SSIS and T-SQL.
• Created User defined functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.

Tools & Technologies: SQL Server, SSIS, SSRS, Excel, Power BI Desktop/ Web, Visual Studio

Confidential, Newark, NJ

SQL /Tableau Developer

Responsibilities:

• Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and TSQL procedures in SQL SERVER.
• Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, MDX queries.
• Involved in some business project of fields of real estate, energy, technology and healthcare.
• Designing current database by add tables, relationships, creating stored procedures, views and performance tuning of SQL queries.
• Developed SQL queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Designed, developed, tested and maintained Tableau functional reports based on user requirements
• Developed Tableau reports using Combo charts, Heat Maps, Box and Whisker charts, Scatter plots, Geographic maps and Histograms
• Developed donut charts for analysing sales planning data and different KPI's using Table calculations and calculated key figures, manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Line, data building Groups, Hierarchies and sets
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked and generating various workbooks and dashboards extracting data from various sources such as Oracle, SQL Server and data files using data blending and joins.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Generated dashboards with quick filters, parameter and sets to handle views more efficiently.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Designed and developed ETL (Extract, Transform and Load) to populate data from various sources using SSIS
• Data Warehousing Design experience and Kimball Methodologies.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent
• Delivered SSRS reports using drill-down capabilities and graphical representation using charts and dashboards

Tools & Technologies: Tableau desktop 10, Tableau Reader, Tableau Public, SQL Server, SSIS, SSRS.

Confidential, Kansas City, KS

SQL BI/Tableau Developer

Responsibilities:

• Analysing different user requirements and coming up with specifications for the various database applications
• Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.
• Implemented the Snap Shot View as extra layers for high availability of data while the ETL process loading the data in to the SQL Database.
• Developed SSIS packages to extract data from sites (Flat Files, Excel Files OLEDB to Sql Server) and load the data into the Data warehouse.
• Publishing sheets and dashboards on server using Tableau Desktop.
• Generated complex reports utilizing the features like Hierarchy, new Calculated Columns, Drill functionality, Tables, Graphs, Line Charts, Bar Charts, Pie Chart, Donut chart, Gantt chart, and KPI chart by using Tableau.
• Determine, document and implement Tableau Data Source Model for large data sources.
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks.
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Hands on experience in Performance Tuning, Query Optimization

Tools & Technologies: SQL Server 2012, MS Access, Visio, BIDS, SSIS, SSAS, SSRS, Visual Studio,Tableau

Confidential, Manhattan, KS

SQL BI Developer

Responsibilities:

• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.
• Involved in Disaster recovery, database maintenance plan and Implemented replication.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in Performance tuning and Query Optimization.
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS). Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS. Designed and implemented stylish report layouts.
• Experience modelling and designing Relational Databases, Star Schemas, and cubes (Kimball).
• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Designed and developed different type of reports including tabular forms, matrix form, conditional, list items, charts and sub reports, drill down reports.
• Developed advanced reports with functions, formula, parameterized reports, sub reports, cross tabs, ranking and conditional formatting.
• Scheduled the reports to run on a daily and weekly basis and then review in Excel Spread Sheet
• Created OLAP models based on dimension and facts for efficient loads of data based on Star Schema structure.
• Created lots of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyse performance.
• Used Data-Mining tools in SSAS to make prediction, scenario analysis to simulate the future price of the company so that can make the best decision.

Tools & Technologies: SQL Server, SSRS, SSAS, SSIS, SQL Profiler, Power BI.

Confidential

SQL BI Analyst

Responsibilities:

• Involved in Planning, Defining and Designing database using data modelling tool on business requirement and provided documentation.
• Developed Logical and physical data model using data modelling tool and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and subqueries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Tools & Technologies: MS SQL-Server 2005/2008, ETL Strategies, BI tools.