SUMMARY:

• 7+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server in Development, Data warehouse, Test and Production Environments on various business domains.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS).
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience with T - SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience in Using multiple join statements to retrieve data from multiple tables.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Advance knowledge of Excel 2013 using PivotTables, Power Pivot, and Power View.
• Experience in Performance tuning and SQL Profiler of SQL Server.
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
• Experience in different phase of Software Development Life Cycle (SDLC) of development of applications.
• Experienced in upgrading SQL Server 20 /2012 and data migration among versions.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005/2008/2012 via SQL Server Integrated Services.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Experienced working with different Source and Version Controlling Systems such as Visual SourceSafe (VSS), SVN and Team Foundation Server (TFS).
• Implemented error handling and roll back process in ETL load.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, SQL Server Configuration Manager, Database Engine Tuning, Dynamic Management Views and Functions.

RDBMS: MS SQL Server 2005/2008/2012/2014 , MS Access.

ETL: SQL Server Integration services.

Programming Languages: TSQL, PL/SQL, Java.

Operating Systems: Windows Vista Business/Ultimate, Windows 7 Ultimate, Windows 10.

DBA Tools: Import/Export, SQL Loader, SQL Server Management Studio (SSMS), SQL Server, Business Intelligence Studio (BIDS), Enterprise Manager, Team Foundation System(TFS).

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Sr. SQL Developer

Responsibilities:

• Develop Custom integrations to meet internal and external requirements of customers using Microsoft SQL Server.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Identified the data source and defining them to build the data source views.
• Looked at the reports and fixed bugs in stored procedures.
• Extensively worked on views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Experience working on Salesforce for Administration Purposes.
• Written T-SQL queries for the retrieval of the data.
• Wrote T-SQL queries using inner join , outer join , and self joins , merge join . Also implemented functionality for removing duplicate records like using CTE and ranking function.
• Communicating with the Business analysts to discuss about the requirement and provide the customer with right data.
• Writing and debugging T-SQL, stored procedures, views and user defined functions.
• Have successfully worked on multiple projects Parallerlly to meet the deadlines.
• Responsible for gathering /refining requirements from the customer for developing reports.
• Practical exposure to Power BI features as a part of putting DAX to work in our data models and visualizations.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Improved Report Performance and performed unit testing.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in ER diagrams both physical and logical using Erwin mapping the data into database objects.
• Tuned SQL queries using execution plans better performance and query optimization.
• Created a cube using multiple dimensions and modified the Relationship between a Measure group and a dimension using SSAS.
• Extensively used Teradata SQL Assistant to extract data from Data warehouse.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Drill Down, Drill through, parameterized cascaded reports.
• Perform data mappings and develop ETL solutions to extract and load data from various source ERP systems for staging databases.
• Created Tableau dashboards with interactive views, trends and drill downs along with user level security.
• Implementation of data mapping by writing various T-SQL queries on database.
• Implemented and enhanced existing reports like group by, drilldown, drill through, sub-reports, list, tabular, matrix, navigation reports, standard parameter, cascading parameter and multivalve parameters.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014), Tableau desktop 9.2/10.1, Erwin, Windows 2010, MS Excel, XML, SQL Server Profiler, Power Pivot, TFS (Team Foundation Server).

Confidential, Maryland Heights, MO

Sr MSBI Consultant

Responsibilities:

• Lead the design, development and maintenance of custom reports using BIDS/SSDT and Report Builder.
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.
• Develop complex MDX, stored procedures, function table and views to generate various drill-through, drill-down reports, with dynamic grouping capability, parameterized dynamic Dashboard/Scorecard and link and pass the selected parameter values it to its sub reports using SSRS. Scheduling the jobs to send the reports.
• Creating Data bases, tables, views, indexes, Writing Stored Procedures.
• Create SSAS Cube as per the business requirement.
• Involved Cube development like creating Named Queries, Dimensions, measures, calculations, partitions in measure group, dimension relations, Table mapping, Aggregations and Browsing the cube.
• Involved in daily Stand-up Meeting like Scrum Call.
• Involved in entire business by knowing the up to date business requirements from the business users and Business Analyst.
• Good Interaction with client on weekly basis.
• Worked on processing the cube as per the needed.
• Created Jobs in SSIS to run the process in cube and to get data from the data source.
• Involved in Some admin works like creating user access logins to particular users and providing access to the Database.
• Done unit Testing by writing MDX queries and re-checking the data is getting matched or not.
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Monitoring Jobs and Investigate Failures.
• Extensively used Package Configurations while deploying the SSIS packages from DEV- Stage, Stage - Prod environments.
• Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.
• Create and update SSIS Packages to pull data from source to destination database.
• Worked on Bug Fixing.
• Worked on Deployment as per the needed.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.
• Implemented complex business logic with case, cast, convert, CTE using T-SQL.

Environment: SQL Server 2008R2/2012/2014, SSIS, T-SQL, SSRS, SSAS, Team Foundation Server TFS), Windows Server 2008R2/2012, SharePoint 2013, Crystal Reports 9.0.

Confidential, Richmond, VA

SR BI Consultant

Responsibilities:

• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Develop complex MDX, stored procedures, function table and views to generate various drill-through, drill-down reports, with dynamic grouping capability, parameterized dynamic Dashboard/Scorecard and link and pass the selected parameter values it to its sub reports using SSRS.
• Creating Data bases, tables, views, indexes, Writing Stored Procedures.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Creating Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Worked on Individual Axis, Blended Axis and Dual Axis concept while working with reports.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Use Power pivot to extract, import and join data that coming from different sources and use DAX to create new calculated measures and make this available in Clients SharePoint Site.
• Import own data through Power BI connects to the SaaS sources you use (such as Microsoft Dynamics, Google Analytics, Salesforce, and many more) and automatically creates dashboards and reports for you. You can also import Excel workbooks from OneDrive or your computer.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• Extensively used Package Configurations while deploying the SSIS packages from DEV- Stage, Stage - Prod environments.
• Create and update SSIS Packages to pull data from source to destination database.
• Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.
• Scheduling the jobs to send the reports. Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.
• Interact with the implementation MS SQL Server T-SQL scripts for ETL to enhance delivery of existing and future reporting solutions.
• Implemented complex business logic with case, cast, convert, CTE using T-SQL.
• Implemented Binning & Blending concepts in my Tableau Reports.
• Monitoring Jobs and Investigate Failures.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Environment: SQL Server 2000/2005/2008 R2/2012, T-SQL, PL/SQL, Tableau, Windows Server, TFS, Power BI, SharePoint 2010, SSIS/SSRS/SSAS 2014, SSMS 2014, TFS, Oracle SQL Developer.

Confidential, Sunrise, FL

MS SQL Server Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
• Designed the Entity Relationship (ER) models and logical data (LDM), physical data (PDM) models in Power Designer based upon the design documents.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2008.
• Designed, modified and troubleshoot SSIS packages.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Modeling new fields/tables in Operational Data Store (ODS) as per new requirements.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Used SSIS to load data from various sources into on SQL Server 2008 database and created packages.
• Involved in debugging, tuning and configuration of SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Running and Scheduling SSIS Packages.
• Experience working with SVN to manage code development, tracking and deployment on servers.

Environment: SQL Server 2008, SQL Server Integration Services 2008, SQL Server Analysis Services, T-SQL, SQL Query Analyzer, Power Designer, Visual Studio, T-SQL, SVN.

Confidential

SQL Server Developer

Responsibilities:

• Created/designed reports using SQL Server Reporting Services per user requirements.
• Develop documentation of database architecture, system processes and procedures. Create, review and produce migration scripts of database objects from development to production environments.
• Managed Enterprise and Distributed Data Warehouses in Developmental and Production Environments using SQL 2008.
• Responsible for writing SQL queries, Procedures, Functions and Database triggers.
• Good Experience in Tuning and Optimization of T- SQL stored procedures.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Extensively used the SSIS package to write the data from the flat files into tables.
• Extensively used Explain Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Different database triggers were created and stored in the database and fired off when contents of database were changed.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related outages.
• Deployed and Scheduled the Reports in Report Manager.
• Build and maintain complex SQL queries using T SQL for data analysis, data mining and data manipulation. Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.

Environment: MS SQL Server 2008/2005, T-SQL, PL/SQL, Windows 2008 Server.

Confidential

SQL Developer

Responsibilities:

• Worked on stored procedures, triggers, functions and views.
• Involved in Index operations (Rebuild & Reorganize) and database maintenance.
• Reviewing and Execution of Test Cases.
• Coordinating the Developing activities with the development team And QA team.
• Enhancements of the existing code according to client requirements.
• Worked on Bug Fixing in the system.
• Performance tuning and Code review: Responsible for code review of the database objects like Stored procedures, triggers, functions and views.

Environment: Microsoft SQL Server 2005, SSMS 2005.