SUMMARY

• Experienced in Database Design, Data Analysis Development and business intelligence of Microsoft SQL Server 2000/2005/2008/ 2012/2014/2016
• Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS), Team Foundation Server.
• Experience in Creating and writing complex SQL and T - SQL queries, Views, Indexes, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Proficient in DW, OLTP, OLAP, Relational Database Systems (RDBMS),Data Analysis, Data Modelling, Normalization, Multi-Dimensional (Star) and Snowflake logical and Data Warehousing Design concepts.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience indeveloping,monitoring, extractingandtransformingdata usingDTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in creating jobs,SQLMail, Alerts and schedule SSIS Packages usingSQLServer Agent.
• Worked in AGILE/SCRUM methodology in development of Database Objects in SQL Server 2005/2008/2012.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided bySSISsuch asData Conversion,Look Up, Conditional Split,Bulk Insert,Aggregate, Mergeandunion all.
• Experience in Crystal Reports, MS Access and report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in creating OLAP cubes, OLTP, identifying dimensions, attributes, hierarchies and calculating measures and dimensions usingSQLServer Analysis Services (SSAS).
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables.
• Worked in Creating DAX Expressions and implement Partitions in Tabular models
• Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power Query integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.
• Worked on PowerBI in creating dashboards and reports and visualizing data.
• Experience in creating reports from scratch using Power BI from Excel workbook dat contains Power View sheets.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS Tabular, DTS), OLAP, OLTP,T-SQL,DAX,MDX,No-SQL.

Reporting Tools: SSRS 2012/2008/2005/2000, Crystal Reports XI/X/9/8, Excel, Tableau, Power BI.

Database: MS SQL Server 2014/2008/2005/2000, Oracle 10g/9i/8i, MYSQL, MS-ACCESS, Teradata

Programming: C, C++, Visual C++ 6.0, C#,.Net, VB.Net, PL/SQL, TSQL.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE

Confidential, Washington

Senior Database Developer

Responsibilities:

• Involved in gathering business requirement and technical specifications and design documents for developing the data warehouse.
• Backend database development in MS SQL Server, writing complex queries, performance tuning of stored procedures, constructing views, triggers, cursors, UDFs.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Implemented Data Cleansing, Incremental Data Loading, Logging, Data Analysis, Event Handling and Error Handling.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2012/2016.
• Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on various projects on automating the ETL process from different data sources to SQL server using SQL Server Agent and C#.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting
• Scheduled and maintained daily and monthly loads of classified data through jobs, tasks, and alerts.
• Worked on PowerBI in creating dashboards and reports and visualizing data in hierarchy level
• Worked on Bar, Pie, Guage charts, slicers, KPI, table and matrix visualizations and implemented row level security as per the requirement.
• Experience in creating content packs to publish dashboards to user groups or an organization.

Environment: Azure,Windows server 2007,DW,Python,MS SQL Server-2012/14/16 Enterprise Edition, Kimball,MSExcel,ETL,SSIS,SSRS,TSQL,.NET,DTS,SQLProfiler,C#,OLTP,Office2007,NoSQL,Subversion.

Confidential, Washington

SQL/Power BI Developer

Responsibilities:

• Involved in gathering business requirement and technical specifications and design documents for developing the data warehouse.
• Experienced on writing complex queries, performance tuning and optimized SQL queries using D-SQL T-SQL, SQL Profiler in SQL Server 2012/2014/2016 and deployed code in cloud base environment like AWS.
• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Worked on delivering source control, tracking work item, Team Foundation Build, reporting with the help of Team foundation Server.
• Experience in Performance tuning and monitoring tools like SQL Profiler and SQLDIAG.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
• Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.
• Implemented Data Cleansing, Incremental Data Loading, Logging,Data Analysis, Event Handling and Error Handling.
• Created SSIS(ETL) Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc
• Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Created various types of reports such as sub reports, Tablix and Matrix usingSQL Server Reporting Services and also created Parameterized Reports and crystal reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Designed and architected Report Layout including both simple and complex report using SSRS 2005 and SAP report development.
• Created reports on both cascading and standard parameters.
• Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors.
• Experienced in using DAX Expressions to creating calculate fields in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular Model Projects(SSAS).
• Experience in creating SSAS Tabluar models by importing from various data sources like SQL Server, Excel..etc
• Worked on creating DAX Calculated Columns, KPI’s, Hierarchies on Tabular analysis service model.
• Created calculated measures using MDX and DAX implementing business requirement.
• Experience with database design, table partitioning, T-SQL, and performance monitoring and tuning.
• Experienced working on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database.
• Expertise in OLAP and OLTP and Datawarehouse Concepts.
• Worked on PowerBI in creating dashboards and reports and visualizing data.
• Creating Gateway and publishing reports to users according to the client requirement.
• 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.
• Worked on Cloud platform Azure for storage applications.
• Implemented Row level Security to restrict the access to users.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

Environment: Windows server 2007,DW,MS SQL Server-2012/14/16 Enterprise Edition,TFS,ETL, SSIS, SSAS, SSRS, T-SQL,.NET, DTS,SOAP, REST Web Services, AWS,SQL Profiler,DAX, Azure,C#,OLAP, OLTP, Office-2007, Team Foundation Server(TFS),Azure,MS Excel,PowerBI, Kimball,SAP, SQLDIAG.

Confidential, Texas

SQL Power BI/SSRS/SSAS Developer

Responsibilities:

• Worked in AGILE methodology in development of Database Objects in T-SQL, SQL Server 2005/2008/ 2008 R2/2012.
• Involved in analysis of Report design requirements and generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Added subscription and snapshot option to deployed reports for end users.
• Expertise in Creating SSRS reports using Report Designer as well as Report Builder and crystal reports.
• Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
• Designed Subscriptions and Security for Reports.
• Created reports on both cascading and standard parameters.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Worked on Tableau to create extensive eye-catching reports according to the client requirement.
• 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.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• ImplementingDashboardsandScore Cardsusing Microsoft Performance Point Server and integrated with share point.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas..
• Developed Aggregations, partitions and calculated members for cube and SSAS Tabular Model as per business requirements.
• Designed Dimensional Modeling using SSASpackages for End-User. Created Hierarchies in Dimensional Modeling.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.
• Developed normalized Logical and Physical database models to design OLTP.
• Created a cube and Tabular Model using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Experience in creating reports and dashboards from scratch using Power BI from Excel workbook dat contains Power View sheets.
• Sound Experience and understanding of SSAS, DAX, Tabular Model,OLAP and OLTP cube, Data mining and Architecture.
• AppliedInmonER model for the enterprise data warehouse. Used dimensional model for data marts. Created data marts as physical separation from enterprise data warehouse and built them for departmental uses
• Experience in creating OLAP cubes, identifying dimensions, KPI’s, attributes, hierarchies and calculating measures and dimensions usingSQLServer Analysis Services(Tabular and cube Models).Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
• Designed, Build the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS). .

Environment: SQLServer 2012/2008R2/2008,SQLBI Suite (SSAS, SSIS, SSRS),ETL,Inmon, Report Builder,Power BI, MS Excel,SQLProfiler, MDX,DAX, MS Office, Visual Studio, Tableau,OLAP,OLTP.

Confidential, Texas

MSBI Developer

Responsibilities:

• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
• Developed, monitored and deployed SSIS packages.
• Developed normalized Logical and Physical database models to design OLTP.
• Created indexes both non clustered and clustered indexes in order to maximize the query performance.
• Modified queries and stored procedures to improve the performance.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions
• Generated multiple enterprise reports like SSRS and Crystal report, worked on Tableau.
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix usingSQL Server Reporting Services.
• Involved in creating MDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP,DAX, Tabular Model, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Environment: MS SQL Server 2008,Report Builder, T-SQL,Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),DAX, OLTP, SQL Server Analysis Services (SSAS), MS Excel, Windows 7, Crystal Reports, Data Migration, Toad,Tableau.

Confidential, MD

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Extensive experience in developing T-SQL Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Performed Data Modeling in ER Studio 9.0 in the initial stages of the project.
• Developed T-SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
• Created SSIS packages to do incremental data load and logging.
• Met SLA’s fine tuning the SSRS and long running ETL queries.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Worked on dimensional data modeling, dimensions and facts for OLAP cubes configured report server environment and deployed reports to the database.
• Worked on creating cubes, calculations, KPI's, deploy of cubes using SSAS.

Environment: SQL Server /2012/2008 R2/2008,OLAP,OLTP, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SQL Server Profiler 2008.

Confidential, California

MSBI Developer

Responsibilities:

• Developed normalized Logical and Physical database models to design OLTP.
• Created indexes both non clustered and clustered indexes in order to maximize the query performance in T-SQL.
• Modified queries and stored procedures to improve the performance.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
• Generated multiple enterprise reports like SSRS and Crystal reports.
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix usingSQL Server Reporting Services.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008/2005,T-SQL, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, Windows XP, Crystal Reports.

Confidential

SQL Developer

Responsibilities:

• Involved in all phases of SDLC, and gatheird business requirements from business people.
• Creating complex T-SQLStored Procedures, Functions, Triggers, Cursors, Tables, and Views and otherSQLjoins and statements for applications.
• Worked extensively on DTS Package designs for Import/Export from various Data Sources.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Auditing using triggers.
• Involved in Physical and Logical design of the databases.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Created and maintained Data Transformation Service (DTS) packages for migrating data.
• Used SQL Profiler to debug T-SQL and slow running queries
• Maintained Client relationship by communicating daily statuses and weekly reports.
• Monitored performance and optimized SQL queries for maximum efficiency.

Environment: MS SQL Server 2000/2005, T-SQL, Windows 2000 server, DTS, SQL Profiler.