PROFESSIONAL SUMMARY

• Over 8 years of IT experience as a developer in Data Warehousing and Business Intelligence background using teh Microsoft SQL Server Suite of products in various sectors which primarily include Healthcare, Financial and retail industries.
• Experienced in working through all phases of SDLC involving Requirement analysis, Software design, Development, Implementation, Testing and maintenance.
• Extensive experience in using SQL Server 2000/2005/2008 for Database Design, Data Modeling and T - SQL Development.
• Expert in working wif Business Intelligence Development Studio (BIDS) for Developing and Implementing ETL Packages using SSIS, generating Complex Reports using SSRS and configuring data source views and creating hierarchies using SSAS.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints for various business applications involving complex business logic and functionality.
• Expertise in creating Databases, Complex Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Excellent noledge of using System Variables and creating User-Defined Variables, PackageConfiguration wizard to configure SSIS Packages.
• Worked extensively in Designing, Developing and deploying various kinds of reports using SSRSusing relational and multidimensional data and in creating Report Models for building Ad hocreports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Administering, Managing and Troubleshooting Reporting services.
• Created Reports wif complex formulas and to query teh database for Business Intelligence.
• Expert noledge connecting Microsoft Azure-based Power BI to various data sources.
• Experienced/Expert at data visualization and advance calculations (Aggregate, Date, Logical, String, Table) using Azure-based Power BI (all devices)
• Expertise in implementing DAX functions for fact calculations for efficient data visualization in POWER BI.
• Expertise in integrating Hive wif POWER BI.
• Experience in creating reports in POWER BIdesktop preview portal utilizing teh SSAS Tabular via Analysis connector.
• Experience in deploying data intensive POWER BIdashboards to SharePoint team site as per business requirements.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Well Versed in creating Dashboard Reports to support end users using SSAS.
• Expertise in creating Cell Level Security, Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience in creating automated administrative functions such as data loading and unloading, backing up and restoring databases, copying SQL Server databases and teh objects they contain, copying SQL Server objects, upgrades and creating Filegroups/Transaction Logs.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Extensive noledge in optimizing teh code and improving performance by Tuning TSQL queries, performing maintenance tasks using techniques like re-indexing and recompiling stored procedures.
• Aware of SDLC procedures, Change control methodologies, problem management and escalation procedures.
• Expertise in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2012/2008/2005/2000.
• Excellent communication, interpersonal and analytical skills combined wif good analytical and problem-solving skills and ability to work on own besides being a valuable and contributing team player

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows, Linux

LANGUAGES: C, C++, C#, T-SQL, PL/SQL, MDX, DAX, HTML, XML

TOOLS: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDSVisual Studio 2012/2008

BI Tools: Informatica, SSIS, SSRS, SSAS,POWER BI Erwin

DATABASES: MS SQL Server 2000/2005/2008/2014/2016, MS Access, Oracle 9i/10g

Version Control Tools: GIT

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server, MS-Project 2012/2008

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr SQL BI /SSRS/ SSIS/ SSAS /POWER BI Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries wif teh best execution plan.
• Tuning T-SQL queries to upgrade SQL Server performance using SQL Server 2014/2016.
• Developed User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secure and extensible.
• Developed physical data models using ERWIN/ ER Studio and maintaining teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed Query for generating drill down and drill through reports in SSRS 2012.
• Uploaded reports on to teh report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for teh reports.
• Identified and worked wif Parameters for parameterized reports in SSRS 2012.
• Used ProClarity for accessing and analyzing cubes and dimensions, also worked on integration of SharePoint wif SSRS.
• Worked in connecting to Hive using Hiveserver2 and export hive use Hive data to create Power BI dashboards.
• Designed and developedPowerBIgraphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI to create various analytical dashboards dat depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Utilized Power Query in Power BI to Pivot and Un-pivot teh data model for data cleansing and data massaging.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Deployed data intensive Power BIdashboards to SharePoint team site as per business requirements
• Used SSIS to create ETL packages to validate, extract and transform using techniques such as Data Conversion, Conditional Split, Bulk Insert, merge and union all, and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Has good hands on experience working wif FTP component in SSIS and used Configuration Manager to retrieve teh passwords.
• Experience in Designing, Building teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• MigratedSQL2014 Databases on Cloud usingSQLServerAzure.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure teh completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked wif Exception handling wif @@error and wif Try/catch.
• Administered teh SQL server by creating user logins, dropping and locking teh logins, monitoring teh user accounts, creating groups, granting privileges to users and groups.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Configured MERGE Replication using Snapshot agent and Merge Agent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
• Managed teh migration of SQL Server 2008 databases to SQL Server 2014.
• Provided day-to-day administration tasks like space and log management along wif developing Backup and Recovery Strategies, and Disaster Recovery Plan
• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration wif development resources and System Administrators.

Environment: MS SQL Server 2012, Windows 7, MS-Excel, Business Intelligence Development Studio(BIDS), Erwin,POWER BI, MS Visual Source Safe, FTP Communication, MS-Visual Studio, Oracle 10g, UNIX, XML, XSLT, ADO.Net., Microsoft Azure,HIVE

Confidential, Jacksonville, FL

SQL BI /SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Provided SQL Server Database Administration and Development at Wells Fargo in support of a financial distributed and replicated storage system wif a multi-terabyte data store.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used T-SQL to manipulate and architect to produce results for users.
• Involved in design, development and implementation of SSIS, SSRS and SSAS.
• Developed SQL SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server 2012 using different transformations like a derived column, sort, and aggregate transformations.
• Imported data into Performance point server from SQL database through csv files
• Consolidated data from OLTP databases into OLAP using SSIS as ETL.
• Managing various mortgage processes across different reports and provided primary Admin and production support for these reports.
• Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports. Designed Drill through Ad-hoc Reports.
• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Designed complex data intensive reports in Power BIutilizing various graph features such as gauge, funnel, line better business analysis.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• 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.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Created Scopes in teh cube to provide flexibility for users to see revenue in their local currencies.
• Created roles and implemented security at teh department level to allow/restrict users to view data depending on teh departments they belong to.
• Created partitions and designed various storage modes to increase teh performance of cubes using SSAS.
• Created dimensions in teh performance point server.
• Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them wif teh SQL Server agent job scheduler.
• Tuned teh database to perform efficiently by managing databases using teh options to grow or shrink database files and monitor teh size of teh transaction log.
• Tuned teh performance of SQL queries and Stored procedures using SQL Profiler. Involved in teh database and log backups & restoration, backup strategies, scheduling.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Worked on upgrading/changing all teh database objects from 2005 to make them compatible to teh schema changes in 2012.
• Performing query plans and making sure each query is using appropriate useful indexes.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created UTP document and performed unit test processing.

Environment: Microsoft SQL Server 2012, SSIS 2012, SSRS 2012, SSAS 2012, Visual Studio 2012, Power BI, Microsoft Office Performance Point Server, Planning Business Modeler, Microsoft Office share point 2007.

Confidential, Iselin, NJ

BI DEVELOPER/SSIS/SSRS/SSAS

Responsibilities:

• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Designed and implemented processes for deploying, upgrading, managing, archiving, and extracting data for reporting.
• Advised optimization of queries by looking at Execution Plan for better tuning of teh database.
• Responsible for rebuilding teh indexes and tables as part of performance tuning.
• Extract, Transform and Load (ETL) source data into respective target tables to build teh required data marts.
• Created SSIS packages for prophet application dat would transfer data among servers and perform other data transformations.
• Experience in creating complex SSIS packages using proper control and data flow elements wif error handling.
• Tested, Cleaned and Standardized data meeting teh business standards using Fuzzy/exact lookups using SSIS tasks.
• Created SSIS Packages to pull data fromSQLServer and exported to Excel Spreadsheets and vice versa.
• Fine-tuned SSIS packages, SSRS reports and stored procedures dat take long time for execution.
• Created Cross-tab, Drill-Down, Drill-Through and Sub-Report using RDL, promoted RDLs to Reporting Service server.
• Deployed and uploaded teh SSRS reports to SharePoint Server for teh end users and involved in enhancements and modifications.
• Created expressions in SSRS to provide flexibility to users by providing them wif variety of options for seeing teh business information in tables/charts etc.
• Developed reports using complex formulas and to query teh database to generate different types of ad-hoc reports using SSRS.
• Created teh dataset in SSRS for calling teh stored procedures and passed teh parameters to teh dataset.
• Involved in designing partitions in Cubes on time for Improvement in performance using SSAS.

Environment: MSSQLServer 2012/2008/2005, SSIS, SSRS, T-SQL, ETL, SharePoint Designer 2010, Visual Studio 2010, MS Office 2007.

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Gathered end-user requirements and developed applications and different audit functionalities depending on teh requirements acting both as a system analyst and an application developer.
• Wrote user requirement documents and developed functions, indexes, stored procedures, views and triggers for automation. Converted fast views in to EUP views and validated data.
• Used Team Foundation Server (TFS) as a tool for teh repository of codes and version control, also maintains test scripts and documentation following teh standards.
• Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed physical data models using ERWIN and created DDL scripts for database schema and objects.
• Developed query for generating drill down and drill through reports in SSRS 2012.
• Uploaded reports on to teh report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for teh reports. Designed and implemented stylish report layouts.
• Identified and worked wif Parameters for parameterized reports in SSRS 2012.
• Used ProClarity for accessing and analyzing cubes and dimensions, and worked on teh integration of SharePoint wif SSRS.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Deployed teh generated reports directly on teh client’s workstation.
• Created Books and views using ProClarity.
• Experience in Designing, Building teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure teh completeness of batch processes, scripts and processes.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked wif users in training and support and has experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Has good hands on experience working wif FTP component in SSIS and used Configuration Manager to retrieve teh passwords.
• Managed teh migration of SQL Server 2005 databases to SQL Server 2008/2012.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.
• Experience in Installing and Configuring SQL Server Active/Active and Active/Passive clusters, monitored Scheduled jobs and alerts.
• Implemented and successfully tested Log shipping in SQL Server 2008 and SQL Server 2012.

Environment: MS SQL Server 2012/2008, T-SQL, DTS, SSAS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server Query Analyzer, MDX, SQL Server BIDS, MS- Visual Studio 2005.

Confidential,

SQL BI Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server Integration Service packages to populate data from teh various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS packages and modified teh packages wif new features of SQL SSIS.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server.
• Backing up, restoring system & other databases as per requirements, and scheduled those backups.
• Used SQL Server Profiler to trace teh slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008, DTS, SSIS, SSRS, SSAS, T-SQL, Excel

Confidential

Jr. SQL Developer

Responsibilities:

• Analyzed business requirements and build logical data models dat describe all teh data and relationships between teh data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized teh implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules wifin teh development team.
• Modified database structures as directed by developers for test/develop environments and assist wifcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at teh server.
• Provided back-end support for functional testing and performance testing.

Environment:SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS