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 noledge and Experience in dealing wif 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 dat 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 teh development of scripts for loading teh data into teh tables in Enterprise Data Warehouse EDW and to load teh 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 teh 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 wif 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 wif 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 wif Teradata database.
• Performed application level DBA activities creating tables, indexes and monitored and tuned Teradata BETQ scripts using Teradata Visual utility.
• Experience working wif Teradata parallel transporter, Fast Load, Multi load, SQL Assistant, DDL and DML commands.
• Proficient in Multi-Dimensional Data Analysis, Data Modeling.
• Experience working wif 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 wif 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 wif strong problem solving and analytical skills and total commitment to teh 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 teh definition of teh 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 teh 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 teh 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 teh data into teh 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 teh SSIS packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh 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 dat accept parameters.
• Created Parameterized Queries, generated Tabular reports, sub reports, Cross Tabs, drill down reports using Expressions, Functions, Charts, Maps, Sorting teh data, Defining Data sources and Subtotals for teh 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 teh end users.
• Wrote custom tasks using C# wifin 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 teh SSIS jobs inSQLscheduler asSQLserver agent job for daily, weekly and monthly loads.
• Created Parameterized reports and Linked reports and thorough noledge 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 wif teh using of SSIS.
• Created SSIS Packages using teh concepts of incremental loading and slowly changing dimensions
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control wif teh 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 teh corresponding job tasks.
• Created reports from teh 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 teh 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 teh requirements.
• Designed and implemented Dashboards and Scorecards wif business KPIs using Performance Point Server and published them Via Power BI.
• Worked wif SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.
• Designed and Built Cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs usingSQLServer Analysis Services (SSAS).
• Optimized teh query performance on SSAS Cube by following teh 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 wif 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 teh completeness of batch processes, scripts and processes.
• Supported Application Development team wif 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 wif power pivot for executive management for data insights as per business requirements.
• Performed key role in understanding teh business requirements and designing and loading teh 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 teh reports in SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports, and linked reports using SSRS and integrated into teh web front end.
• Created teh 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 teh 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 wif 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 teh report parameters and created teh reports based on teh requirements using SSRS.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Wrote custom tasks using C# wifin 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 teh Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact, and Dimension tables.
• Created very complex SSIS Packages wif considering all teh best practice like error handling, logging, configurations, deployments, maintenance.
• Involved in Analyzing, designing, building &, testing of OLAP cubes wif 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 teh granularity of teh 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 teh 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 teh Centralized Data Warehouse.
• Designing Tables, SSIS Packages, Stored Procedures, Functions and Views to deliver snapshots of Report data every once in month to teh 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 teh centralized data warehouse.
• Using Import/Export Wizard to generate SSIS packages dat migrates data from various sources to a Staging database.
• Rationalizing teh existing SSIS Packages and other ETL processes to improve performance and maintain data quality.
• Preparing SSIS Package Models to extract data from teh source systems and load it into teh new Data warehouse.
• Designing SSIS Packages wif 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 wif teh company's SharePoint server.
• Preparing SSRS Reports wif Report subscriptions and Email Delivery mechanisms throughSQL Scripts dat run on Report Server Databases.
• Developing an automated testing process dat validates data between teh source and target systems and generates reports on teh same.
• Providing Production support to monitorSQLAgent Jobs, Report Deliveries, ETL issues and technical Change Requests.
• Cleaning up data wifin teh 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 wif teh business analyst in translating business needs and requirements into functional design specifications.
• Designed and normalized teh 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 teh parameters.
• Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
• Built complex multi-sectional reports wif charts and drill down capabilities.
• Developed SQL queries and stored procedures to execute teh backend processes using SQL management Studio.
• Verified and formatted teh report layout for teh various reports.
• Created report models for ad hoc reports when teh user wants to see teh reports on teh 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 teh 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 teh 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).