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 using SQL Server Integration Services ( SSIS ), Reporting & Analysis Services ( SSRS & SSAS ) and MS SQL Server(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 various SQL server 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 the SQL Database.
• Experience in data analysis SQL server database development and maintenance, data modeling that support day to day business operations and auditing of database for user transactions, login and database action and removing orphan users.
• Involved in Backups, Query optimization, Disaster recovery methods, High availability methods , creating Emails, jobs, alerts and in performance tuning, used SQL profiler.
• Experience in data migration (using tools like Bulk Insert, DTEXEC, and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server. Used Performance tools like SQL Profiler, 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 using SQL Reporting 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 power Pivot, pivot table, Pivot Chart, Power View, Power BI, VLOOKUP Functions, and Formulas.
• Experience in importing multiple data source into Tableau, created charts, tables, Adhoc reports and visualization design.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Built and deployed CUBES using SQL Server 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 implementing Dashboards and Score Cards using 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 using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL LiteSpeed, for performance Foglight and for alerting Idera .
• 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, Rancho Cucamonga, CA

BI Developer/SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base based on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler. Involved in database and log backups & restoration, backup strategies, scheduling.
• Developed the Teradata Macros, Stored Procedures to load data into Incremental/ staging tables and then move data from staging into Base tables.
• Involved in creating a Data model for a centralized data warehouse using ERWIN and Microsoft VISIO.
• Created and configured Workflows, Work lets and sessions to transport the data to target tables.
• Created packages using SSIS to extract the data from different flat files (.txt, .csv, .xlsx) and loaded to tables in SQL Server 2012/2014/2016 .
• Created SSIS packages to load data to Staging and Data mart tables in SQL SSMS 2012.
• Created configuration files in SSIS 2012 to deploy packages in different environments like DEV, TST, and PROD.
• Used TFS (Team Foundation Server) to maintain all packages and reports created.
• Involved in performance tuning of TSQL queries and Stored Procedures. Created jobs, alerts using SQL Server Agent to run SSIS packages periodically.
• Developed Data marts for the faster analysis.
• Created automated integration jobs to transfer data from source systems into stage tables.
• Experience implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point.
• 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 into SQL Server.
• Deployed SSIS packages to SQL 2012/2014/2016 and scheduled jobs to extract data from sources on daily basis.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files, and XML files to staging database and from staging to the target Data Warehouse database.
• Created and Scheduled jobs to send the data to PCG, Destiny and Tip Web on daily basis.
• Developed several types of Tabular, Matrix, Drilldown, Drill Through reports to PCG and SAP team using SSRS .
• Deployed SSRS reports to 2012/2014/2016 report manager and exported them to desired formats like Excel, pdf etc. for end user access.
• Scheduled Reports to run the reports Hourly, Daily, and Monthly according to client requirements for the periodic analysis.
• Created MDX and DAX Queries from Tabular model for SSRS Reports.
• Conducted Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology .
• Enhanced the Medicaid encounter (837) and enrollment (834) companion guides, enhanced requirements, co-authored test plan, and developed test data via SQL and manual editing (ETL).
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Implemented complex DAX calculations for SSAS 2014 Tabular model.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS .
• Designed and Configured Dimensions, Attributes, Hierarchies, KPIs, Aggregations and Cube Partitions.
• Involved in Tabular Data warehouse and DAX operations for SSAS and OLAP databases.
• Worked on creating Azure Data Factory for moving and transforming the data.
• Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations
• Developed U- SQL Scripts for schematizing the data in Azure Data Lake Analytics .
• Maintain and support various SSRS reports using DAX and MDX queries
• Updated issues status and requirements status on JIRA and loaded the documents and automation code in Subversion control system for source code control.

Environment: Teradata, MS SQL Server 2016/2014/2012/2008 R2/2005, MS SQL Server Integration Services ( SSIS ) 2012/2008R2/2008,Dynamics AX MS SQL Server Reporting Services ( SSRS ) 2012/2008R2/2008, SQL Server Management Studio (SSMS), ETL,C#,ASP.Net SQL Server Business Intelligence Studio (BIDS),ERWIN, AZURE, T- SQL, Power BI , DAX, JIRA , Power Pivot.

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, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server 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 into SQL Server.
• 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 in SQL scheduler as SQL server 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.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 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 and SQL queries.
• 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 using SQL Server 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- SQL Queries, debugging.

Environment: Teradata, Informatica power center 9.1/9.5,MS SQL Server 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

M S 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 using SQL Server 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 using SQL Server 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 on SQL Server 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 of SQL Server Analysis Services ( SSAS ), design/change/deploy OLAP Cubes.
• Installed MS SQL server 2005 and MS SQL server 2008 on windows 2003/2008 servers, applied Service packs and Security fixes. Implementing database standards and naming convention for the database objects.
• Created SQL Scripts for data loads and upgrades for data migrations and data validations.
• Developed and scheduled DTS packages for each system Interface using SQL code 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 into SQL Server.
• 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 other SQL Joins 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-SQL Scripts 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 through SQL 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 monitor SQL Agent 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: SQL Server 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 configured SQL Server 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-SQL queries to retrieve data from various tables.
• Managed up gradation of DTS packages to SSIS packages.
• Created SSIS 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-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, 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: MS SQL Server 2005/2008, T-SQL, Windows Server, Erwin, SQL Server Profiler, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS , DTS, OLTP, XML, Visual Source Safe (VSS).