Professional Summary
Over * years of Business Intelligence professional experience with MS SQL Server 2014/2012/2008/2005 and worked extensively on Integration services (SSIS), Reporting services (SSRS), Analysis services (SSAS), Tableau and Power BI.
Implementation and Support of various applications in OLTP, Data Warehousing, and OLAP applications.
Experience in installation, up gradation and configuration of MS SQL Server database.
Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) also expertise in working with Crystal Reports.
Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
Experience in creating packages to transfer data between Oracle, MS Access and Flat files to SQL Server using SSIS.
Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
Worked extensively with Data migration, Data cleansing, Data profiling, and ETL Processes features for data warehouses.
Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, Star Schema / Snowflake Schema, FACT and Dimensional Tables.
Experience in creating Stored Procedures, Triggers, Views and Functions.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
Preparing Dashboards using calculations, parameters in Tableau.
Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow.
Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs.
Technical Skills
Languages
SQL, T-SQL, PL/SQL. C, C++, C#
Databases
SQL Server 2005/2008 R2 /2012, Oracle 10g/11g, DB2, MS Access
Reporting Tools
SQL Server Reporting Service (SSRS), Tableau, Power BI
ETL Tools
SQL Server Integration Services (SSIS)
Analysis Tools
SQL Server Analysis Services (SSAS)
Operating Systems
Windows Vista/7/8/10, Unix
Project Experience
T-Mobile, Parsippany, NJ Jun ‘13 – Till Date
Sr. MS SQL/BI Developer
Responsibilities:
Created Stored Procedures, Triggers, Views and Functions for the application.
Written T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries and Stored Procedures.
Worked on SSIS Package and coordinated with ETL developer’s team to ensure data extracted, transformed and loaded according to the specified requirements.
Used Import/Export wizard to move data into multiple servers.
Created batch files for the SSIS packages to execute from the command line.
Scheduled SSIS packages to run on a scheduled basis using Windows scheduler.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Developed several Complex Reports using SQL Server Reporting Services (SSRS).
Created Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
Trouble shooting of Reports by cross checking the Report Layouts, Datasets, Stored Procedures and SSIS Packages.
Created Technical specification documents for each SSIS package developed.
Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
Created snippets to maximize the efficiency in writing the code.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Developed Tableau workbooks from multiple data sources using Data Blending.
Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables in tableau.
Utilized Microsoft PowerBI for data modelling and building dashboards.
Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
Defining data warehouse (star and snowflake), fact table, cubes, dimensions, measures and ETL structure.
Environment: Microsoft SQL Server 2012 Enterprise Edition, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Management studio, Power BI, Tableau, SQL Server Integration Services (SSIS), C#.net.
4G Identity Solutions, Hyderabad Dec ‘11 – May ‘13
Programmer Analyst
Responsibilities:
Involved in the Data modeling, Physical and Logical Design of Database.
Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
Modified the existing mapping SQL scripts as per the client needs.
Created SSIS packages to import/export sales data to/from the excel sheets, flat files, XML files or other databases as per the user requirements.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
Created Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
Created reports with Analysis Services Cube as the data source using SSRS.
Environment: Microsoft SQL Server 2005, Management Studio, Windows XP, MS Access, Oracle 10g, Excel, PL/SQL Developer.