PROFESSIONAL SUMMARY:

• Over 6+ years of Experience in Data Warehousing and Business Intelligence applications (MSBI, Power BI) and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL Server 2016/2014/ /2005/2000 .
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, relational database models, data dictionaries, and data integrity.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS), SQL Server Integration Services (2005/2008), SQL Server Data Tools (2012/2014/2016 ).
• Generated reports using SSRS, Excel (Pivot) dat could be used to send information to diverse group of users.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Experience with, Power Pivot and Dashboard Designer.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including teh measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in Relational, Multi - Dimensional (Star) and Snowflake logical modeling.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Adept at using Microsoft Visual Studio with .NET Framework.
• Experience in combining data from different sources by using of Power Query
• Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views etc.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism.
• Worked on Oracle development tools like SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, and used TOAD(Tools forOracleApplication Development) in many development projects.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL, Visual Studio
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Expert in DAX Functions
• Create reports in Power BI preview portal utilizing teh SSAS Tabular via Analysis connector.
• Experience in developing SSAS projects using MDX in MSSQL Server 2005.2008.
• Experience in creating XML files and XSD schema files.
• Expertise in creating Dashboard Reports to support end users using SSAS and Power BI.
• Expert in performance tuning of teh reports.
• Expert in performance tuning of PLSQL.
• Good knowledge of Object Oriented programming and Scripting languages.

TECHNICAL SKILLS:

Programming Languages: C#, Java, java script

Web Technologies: Knowledge about HTML, DHTML,XML, Python

Databases: SQL Server 2016/2014/2012/ 2008 R 2/2008/2005/2000, MS Access, Oracle 11g/12c, MYSQL

Database Tools: SQL Server Management Studio, Azure, .Net, DAX Functions, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, SQL Server Analysis Service, ETL, Power BI.

Reporting Tools: SQL Server Reporting Services, MS Excel, MS Access, Visual Studio, Data Modeling.

Application Packages: MS-Front Page, Microsoft Office Suite, SSIS, SSAS, SSRS, Microsoft Project Server, Share point Server.

Operating System: Windows 2008R2 Server, Windows Server 2012, Windows Server 2016

PROFESSIONAL EXPERIENCE

Confidential, Newark, CA

SQL Power BI Developer

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gatheird business requirements, defined and designed teh data sources, data flows, data quality analysis, worked in conjunction with teh data warehouse architect on teh development of logical data models.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for teh clients.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Used XML and environmental variables in teh package configuration for Deploying SSIS packages.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Jobs Performance report dat queries system tables to track teh duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed SSAS cube to hold summary data for dashboards and OLAP Analysis
• Created User Defined Hierarchies depending on teh business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate teh cubes with teh data.
• Created different measure groups and calculations using SSAS.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2000, MS SQL 2008/2012/2014, SSIS, SSRS, Power BI, Power Pivot, Windows 2000 Advance Server, PLSQL, XML, T-SQL, MS .Net Framework MS Excel, SharePoint Portal Server 2003/2007, ETL, Visual Studio MS Access.

Confidential,Malvern, PA

MS SQL/SSIS/SSAS Developer

Responsibilities:

• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints
• Adding logins, roles, groups to teh Window NT and MS SQL Server and maintaining proper security procedures.
• Created SSIS packages to get data from different sources, consolidate and cleanse teh data and merge it into one single source.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Created SSIS/DTS packages for Finance application dat would transfer data among servers and perform other data transformations; scheduled teh same SSIS packages by creating teh corresponding job tasks.
• Responsible for ETL operations using SQL Server Integration Services (SSIS) and Worked with users in training and support and also 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.
• Built SSIS Packages for Processing cubes and Dimensions.
• Developed Custom Sales, Inventory and financial reports for seasonal, quarterly, monthly and weekly using SSRS.
• Strong MSSQL Server Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• Creating SSIS packages with ETL.
• Developed various kinds of Tabular, Matrix, Drill-down, Drill-through, Charts, and web receiving reports using SSRS. Responsible for scheduling teh reports based on teh subscriptions defined.
• Generated and formatted Reports using Global Variables, Expressions and Functions, designed and implemented stylish report layouts.
• Responsible for creating dimensional and fact tables and building cubes using SSAS.
• Responsible for maintaining and tuning existing cubes using SSAS.
• Worked with teh Planning team to forecast teh business requirements.
• Experience in Designing, building teh Dimensions, Cubes on star and snowflake schema using SQL Server Analysis Services (SSAS) for business analysis.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Maintained 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 Backup and Recovery Strategies, and Disaster Recovery Plan.
• 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

Environment: XML, T-SQL, MSSQL Server 2008, SQL Server 2008, Power BI, SSIS, SSRS, SSAS, ETL, Data Modeling Visual Studio, ETL, OLAP.

Confidential, Boston, MA

SQL/Power 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 with new features of SQL SSIS.
• Designed ETL packages dealing with 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).
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Designed visualizations with DAX Functions in Power BI.
• Built MDX queries and Data Analysis Expression (DAX) queries for Analysis Services & Reporting Services.
• Created Dimensions and cubes with 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 and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also 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, PLSQL, DTS, SSIS, SSRS, SSAS, T-SQL, Excel, Visual Studio, OLAP, Power BI, DAX functions.

Confidential

SQL / Web Developer

Responsibilities:

• Involved in teh life-cycle of teh project, me.e., requirements gathering, design, development, testing and maintenance of teh database.
• Setup new SQL Server instances.
• Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
• Performed query optimization and tuning, debugging and maintenance of stored procedures.
• Provided database security by using role base authorization on accessing data.
• Used System tables and stored procedures to retrieve metadata.
• Administered teh database using SQL Server Enterprise Manager.
• Performed troubleshooting operations on teh production servers.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Developed user friendly GUI using HTML.

Environment: SQL Server 2000, DTS Package, SQL Server Enterprise Manager, .Net, SQL Server Query Analyzer, HTML.