SUMMARY

• Over 8 years of professional experience on designing, development and implementation of applications related to HealthCare, Banking, Financial and Retail Domains.
• Strong Experience in Microsoft (MSBI) Business Intelligence, ETL Data Warehouse, OLTP & OLAP usingSQLServer Integration Services (SSIS), Reporting & Analysis Services (SSRS & SSAS) and MS SQLServer(2005,2008,2012,2014,2016).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Clustering, T - SQL, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Extensive Experience in RDBMS concepts such as creating databases and variousSQLserver objects like schemas, tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE (common table expression), Table Variables and Stored Procedures.
• Developed physical data models, created DDL (Data Definition Language) scripts and DML (Data Manipulation language) scripts to manipulate theSQLDatabase.
• Experience in data analysis SQLserver database development and maintenance, data modeling that support day to day business operations and auditingof database foruser transactions, login and database actionandremoving orphan users.
• Involved in Backups, Query optimization, Disaster recovery methods, High availability methods, creating Emails, jobs, alerts and in performance tuning, usedSQLprofiler.
• Experience in data migration (using tools like Bulk Insert, DTEXEC, and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server. Used Performance tools likeSQLProfiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Involved in the development of scripts for loading the data into the tables in Enterprise Data Warehouse EDW and to load the data from source to staging and staging area to target tables using Fast Load, Multi Load.
• Creating SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.
• Extensive Experience in ETL Data Warehouse Ralph Kimball Methodologies for supporting Data Extraction, Transformation and Loading processing using MSSQL Server Integration Services (SSIS) and Loaded process from Heterogeneous / Homogeneous Data Sources, performed Data Verification, Data Cleansing, Data Integration, Data Import & Export.
• Expert in merging Data from various complex Data sources, Populating Dimension and Fact tables in Data warehouses, Cleaning and Standardizing the data loaded into OLTP and OLAP databases using SSIS.
• Applied various Transformations such as Lookup, Fuzzy Lookup, Merge, Merge Join, Conditional split, Multicast, Derived column, Cache, Slowly Changing Dimension (SCD Type1, Type2, and Type3).
• Experience in design and implement processes for deploying, managing and extracting data for reporting usingSQLReporting Services SSRS.
• Experience in creating Report models for Adhoc reports, Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table (List), Matrix (Crosstab), Charts, Sub-Reports, Indicators, Bar Graphs & Line Graphs, Dashboards, Ad-hoc and Crystal Reports using SSRS.
• Expert in Data visualization and Data analyzation using Power BI.
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection.
• Robust MS Access and Excel skills with powerPivot, pivot table, Pivot Chart, PowerView, Power BI, VLOOKUP Functions, and Formulas.
• Experience in importing multiple data source into Tableau, created charts, tables, Adhoc reports and visualization design.
• GeneratedTableauDashboards with filters, quick filters, context filters, global filters, parameters and calculated fields onTableaureports.
• Built and deployed CUBES usingSQLServer Analysis Services (SSAS) Built dimensions, measures, hierarchies, calculated attribute, KPI, perspective, partitions, actions and MDX query.
• Expertise in creating Partitions, Design Aggregations, Perspectives and Cell Level Security using SSAS.
• Experience in Creating, Modifying Measures, Dimensions Attribute relationships, and Hierarchies.
• Experience in performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Experience on Teradata development and OLAP operation with Teradata database.
• Performed application level DBA activities creating tables, indexes and monitored and tuned Teradata BETQ scripts using Teradata Visual utility.
• Experience working with Teradata parallel transporter, Fast Load, Multi load, SQL Assistant, DDL and DML commands.
• Proficient in Multi-Dimensional Data Analysis, Data Modeling.
• Experience working with Azure SQL Database Import and Export Service.
• Experience Microsoft Azure date storage and Azure Data Factory, Data Lake.
• Experience implementingDashboardsandScore Cardsusing Microsoft Performance Point Server and integrated with share point.
• Strong Development experience in Classic ASP/VB scripts.
• Good Analytical and programming skills in VB, ASP.Net, VB script and Java Script.
• Hands on experience in project management tools like Team Foundation Server (TFS), Clear case and VSS.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio
• Experience in usingthird party toolsforData modelingSQL Diagrams,Erwin, for Backup Solutions SQLLiteSpeed,for performanceFoglightand for alertingIdera.
• Extensive Experience in Software Development Life Cycle (SDLC) Methodologies such as JIRA, Waterfall, AGILE, SCRUM, RUP (Rational Unified Process), Extreme Programming, Iterative Development, System Analysis & Design concepts.
• Ability to handle Multiple Tasks, Self-Motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Ability to Quickly grasp and Master new concepts and technologies.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2014/2016, MS Access.

Programming Languages: T-SQL, C, C#, .NET Java, Oracle.

Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), DTS, SQL Server Analysis Services (SSAS), MS Visio, Power BI, Tableau.

Web Technologies: XML, HTML, JavaScript.

Application Packages: MS Office Suite, MS Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Glen Allen, VA

SQL Server Developer

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their business efficiency and troubleshooted various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logics and created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension transformations.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created Dimension tables, Fact tables and designed cubes using SSAS.
• Responsible for implementation of data viewer grids, SSIS Logging, error configurations for error handling the SSIS packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both Development and Production environments.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed and maintained complex canned reports using SQL Server 2013 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, sub reports, Cross Tabs, drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2013.

Environment: SQL Server 2014, Visual studio 2013, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), C#, IIS, VB.Net, Erwin

Confidential, Dublin, OH

SQL Server/BI Developer

Responsibilities:

• Supported Batch and Online processes involving development, enhancement and support of T- SQL procedures, views, triggers and query tuning.
• Responsible for developing processes, automation of maintenance jobs, tuningSQLServer, locks and indexes configurations, administeringSQLServer security,SQLServer automatic.
• Extensively created and used various Teradata set Tables, Multi Set tables, global tables, Volatile tables, temp tables.
• Created Data ware house from scratch using Kimball methodology.
• Created cubes on top of Data warehouse for self-reporting by the end users.
• Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files intoSQLServer.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Developed SSIS ETL packages to meet data flow needs.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs inSQLscheduler asSQLserver agent job for daily, weekly and monthly loads.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs & building platform with the using of SSIS.
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control with the using of Team Foundation Server.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• DesignedSQLSSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files intoSQLServer 2005/08R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created reports from the OLAP cubes using SSRS.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX andSQLqueries.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Worked with SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.
• Designed and Built Cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs usingSQLServer Analysis Services (SSAS).
• Optimized the query performance on SSAS Cube by following the recommended best practices.
• Developed ad-hoc queries using SSAS cubes, data warehouses and data marts as data sources.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.
• Created jobs and scheduled jobs using SQL Server Agent.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring T- SQLQueries, debugging.

Environment: Teradata, Informatica power center 9.1/9.5,MS SQLServer 2008/ 2012/2014/2016, MS SSIS, SSRS, SSAS, Tableau,T-SQL,AZURE, PowerBI,DynamicAx2012,Excel,Oracle 9i,ASP.Net,C#MS Visio, ERWIN, Windows 7, MS Office, Team Foundation Server (TFS).

Confidential, Wayne, NJ

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
• Writing queries to generate reports for analysis of data usingSQLServer Reporting Services (SSRS), Report Builder.
• Designed User Interface using ASP.NET, C #. Written Business Layer in C and wrote web service Interfaces using C#. NET, ADO.NET
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset usingSQLServer 2014 Analysis Services (SSAS)
• Exported reports from crystal to PDF and Microsoft excel formats.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
• Performed key role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Involved in various projects related to Data Modeling, System/Data Analysis, Design, and Development for both OLTP and Data warehousing environments.
• Worked heavily onSQLServer database to extract data and build Business reports.
• Generated Reports using Global Variables, Expressions, and Functions for the reports in SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports, and linked reports using SSRS and integrated into the web front end.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Experience setting up reporting platforms ground up in Microsoft technology stack (Share point, SSRS, SSAS, DAX, MDX, T- SQL, Dimensional Modeling, SSIS)
• Project includes extracting, transforming, loading data from ERP database in OLAP cubes.
• Implementation ofSQLServer Analysis Services (SSAS), design/change/deploy OLAP Cubes.
• Installed MSSQLserver 2005 and MSSQLserver 2008 on windows 2003/2008 servers, applied Service packs and Security fixes. Implementing database standards and naming convention for the database objects.
• CreatedSQLScripts for data loads and upgrades for data migrations and data validations.
• Developed and scheduled DTS packages for each system Interface usingSQLcode in combination with VB ActiveX scripts and built-in DTS transformations.
• Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
• Identified and added the report parameters and created the reports based on the requirements using SSRS.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files intoSQLServer.
• Built and published customized interactive dashboards utilizing Excel Power BI.
• Expertise in writing performance MDX, DAX queries against cubes for SSRS datasets.
• Extensively used DAX patterns and design patterns for configuring Currency calculations, snapshot measures, time series calculations.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact, and Dimension tables.
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, maintenance.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Created complex Stored Procedures, Triggers, Cursors, Tables and otherSQLJoins and Statements for Applications by using T- SQL.
• Involved extensively in designing of OLTP database.
• Created schemas, keys and indexes considering the granularity of the data.
• Designed Data flows, Workflows, and jobs to load data from source to target in BO Data Integrator.
• Iteration planning for new features and user stories in Agile Development methodology.
• Deployed SSIS packages and Reports to Production Servers.

Environment: MS SQL Server 2005/2008/2014/2016, Visual Studio 2008/2005, Reporting Services (SSRS 2008), Business Intelligence Development Studio (BIDS),ERWIN, ASP.Net, C#, MS Office 2007,T-SQL, MS Access, ETL, Performance Point Server 2007, MS Excel.

Confidential, Dallas, TX

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Analyzing the Source Database servers, data profiling and generating Database ER Diagrams.
• Creating a Data model for a centralized data warehouse using ERWIN and Microsoft VISIO.
• Generating T-SQLScripts to Create Schemas, Tables and Views for the Centralized Data Warehouse.
• Designing Tables, SSIS Packages, Stored Procedures, Functions and Views to deliver snapshots of Report data every once in month to the respective Business user's team.
• Development of Survey based platform using ASP.Net, C#.
• Creating a Dynamic Stored Procedure using MERGE Statements to incrementally load data from multiple database servers to the centralized data warehouse.
• Using Import/Export Wizard to generate SSIS packages that migrates data from various sources to a Staging database.
• Rationalizing the existing SSIS Packages and other ETL processes to improve performance and maintain data quality.
• Preparing SSIS Package Models to extract data from the source systems and load it into the new Data warehouse.
• Designing SSIS Packages with for Each Loop Containers, Script Tasks and Precedence Constraints for dynamic data load from various store Point of Sales Systems to a central Above-store Database.
• Developing new SSRS Reports for Back Office Users and integrating those with the company's SharePoint server.
• Preparing SSRS Reports with Report subscriptions and Email Delivery mechanisms throughSQL Scripts that run on Report Server Databases.
• Developing an automated testing process that validates data between the source and target systems and generates reports on the same.
• Providing Production support to monitorSQLAgent Jobs, Report Deliveries, ETL issues and technical Change Requests.
• Cleaning up data within the other relational database systems and generating new Report Models to improve user interactivity and selectivity.

Environment: SQLServer 2012/2008 R2, SSIS, SSRS, SSAS,C#,ASP.Net 2.0/3.5, DAX, DTS packages, Power Pivot, Visual studio 2010/2008, Crystal reports, T-SQL, Tortoise SVN 1.7.10, Red Gate 10.0, Window 7 Professional, Agile.

Confidential, Center Valley, PA

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Worked with the business analyst in translating business needs and requirements into functional design specifications.
• Designed and normalized the databases and created different objects like Tables, Views, Stored Procedures and UDF s on MS SQL Server 2008R2.
• Designed and Developed different type of reports including: Tabular forms, Matrix (Cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Defined parameters for parameterized reports and implemented cascading of the parameters.
• Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
• Built complex multi-sectional reports with charts and drill down capabilities.
• Developed SQL queries and stored procedures to execute the backend processes using SQL management Studio.
• Verified and formatted the report layout for the various reports.
• Created report models for ad hoc reports when the user wants to see the reports on the fly.
• Created SSIS packages to create static tables for reports.
• Involved in performing Extraction, Transformation and Loading (ETL) using SSIS.

Environment: Windows 2007, MS Visio 2003, MS SQL Server 2008R2, SSRS 2008R2, SSIS, T-SQL, MS Office 2007.

Confidential

MS SQL Developer

Responsibilities:

• Installing, configuring, administering and securing production and non-production servers. Installed and configuredSQLServer 2008 on the server and client machines, provide connections and manage databases.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQLqueries to retrieve data from various tables.
• Managed up gradation of DTS packages to SSIS packages.
• CreatedSSIS packages to extract data from Excel File, Flat Files, and Text Files and Comma Separated Values (CSV) files using various transformations.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using SQL Server Reporting Services (SSRS).
• Fine-tunedSQLqueries for maximum efficiency and performance using MSSQLProfiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizard.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.

Environment: MSSQLServer 2005/2008, T-SQL, Windows Server, Erwin,SQLServer Profiler, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS, DTS, OLTP, XML, Visual Source Safe (VSS).