SUMMARY:

• Having 6 years of experience in Banking, Medical and Retail segments as a Confidential SQL Server database developer that includes database Analysis, Maintenance and Development of Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server Reporting Services (SSRS), Datamart and Data Transformation Services (DTS).
• Experience in SQL Server and T - SQL in creating Tables, Triggers, Views, Indexes, User defined functions, Stored Procedures and relational database models.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Efficient in Extract Transform Load (ETL), Creating, Configuring, Deploying and Testing, Creating and managing Event Handlers and User Defined variables for SSIS packages.
• Expertise in using Package Configuration Wizard to configure SSIS packages.
• Extensive knowledge in managing and automating Control flow, Data flow, Events and Logging programmatically using .Net framework for SSIS packages.
• Expertise in Debugging, Error Loading, Error handling and Production Support for SSIS.
• Expertise in performance tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in creating Report Models for building AD hoc reports using SSRS.
• Expertise in creating different types of reports like Pie Chart, Drill-Down, Drill-Through, Crosstabs, Conditional, Sub reports and formatting those reports.
• Experience in handling Parameterized reports and Cascade Parameterized reports in SSRS.
• Expertise in populating dimension, fact tables, and data marts using SSIS packages.
• Extensively worked in designing and developing cubes using SQL Server Analysis Services (SSAS).
• Experience in creating Cell Level Security in Cubes using SSAS.
• Experience in migration and recreation of existing Dimensions and Cubes using Star Schema to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Expertise in defining Referenced Relationships and creating Hierarchies in SSAS.
• Experience in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Proficient in Power Pivot, Power View, Power BI and Excel data connections.
• Experience in generating periodic reports based on the statistical analysis of the data using Power Pivot, Power View and power BI.
• Experience in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT, Dimensional Tables and Operational Data Store (ODS).
• Excellent knowledge in Scheduling Jobs and Alerts using SQL Server Agent.
• Developed models, reports and dashboards using Microsoft Power BI Stack.
• Experience in different types of reports including Tabular Forms, Matrix (Cross Tab Report) form, Conditional, List Items, Charts and Sub Reports.
• Experience in Software Development Life Cycle (SDLC) processes including analysis, Design, Programming and testing.
• Manage the Datamart configuration in Treasury Unit.
• Experience in managing Alerts, operators and Scheduled Jobs through SQL Server Agent.
• Involved in optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Good team performer, strong interpersonal and communication skills with self-motivation and initiative person.

TECHNICAL SKILLS:

Operating System: Windows Server 2008/2008R2/2012/2016, Windows 10/7/XP SP2and UNIX.

Data Warehousing/ BI Tools: SQL Server Business Intelligence Development Studio (SSIS, SSAS, SSRS and DTS).

Database: Confidential SQL Server 2008/2012/2014, MS-Access 2010/2007 and Oracle 11g.

Tools: Confidential Visual Studio 2010/2012/2015/2017, Power BI, Crystal Reports and Confidential Excel.

Programming Languages: T-SQL, PL/SQL, VB Script, C#, C++ and Java.

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

MS SQL BI Developer

Roles and Responsibilities:

• Wrote user requirement documents and developed Functions, Indexes, Stored Procedure, Views and Triggers for automation. Converted fast views into EUP views and validated data.
• Gathered end user requirements and developed applications and different functionalities depending on the requirements.
• Created standard reports, cross tab reports and drill-through reports.
• Generated reports using global variables, expressions and functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Uploaded reports to the report manager and organized them into folders.
• Generated and formatted reports using Global Variables, Expressions and Functions for the reports. Designed and implemented trendy report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Deployed the generated reports directly on the client’s workstation.
• Created shared dimension tables, hierarchies, levels, cubes and aggregations on Confidential OLAP/Analysis Services (SSAS).
• Contributed in creating ETL designs and provided end users an easy accession to data marts.
• Maintained data marts up-to-date and in accordance with company’s requirements and practices.
• Create data marts and load data into dimension and fact tables by creating SSIS packages.
• Designed and supervised overall development of Data Mart and Oracle-hosted dimensional models.
• Enhancing performance using optimization techniques normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch process and scripts.
• Responsible for ETL operation using SQL Server Integration (SSIS) and worked with users in training and support.
• 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 for further data analysis.
• Have good hands on experience working with FTP component in SSIS and used configuration manager to retrieve the passwords.
• Worked on Power BI and prepared dashboards to make it more attractive and explored data in a variety of ways and across multiple visualizations using Power BI.
• Created any calculated columns and measures using DAX in Power BIbased on report requirements.
• Developed models, reports and dashboards using Power BI stack, Power Pivot and power query.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters, monitored scheduling jobs and alerts.
• Developed SSIS templates, which can be used to develop SSIS packages such a way that they can be dynamically deployed into Dev, Test and production environments.
• Reviewed cube with end user and changing the cube according to their requirements.
• Created components, tools, techniques, methods and procedures used in an OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer.

Environment: Confidential SQL Server 2014/2016 Enterprise Edition, T-SQL, DTS, SSIS, SSRS, SSAS, SQL Server Query Analyzer, Business Objects, XML, ActiveX, Oracle, C#, SQL Server BIDS, Confidential Visual Studio 2017/2015, Confidential Access 2016, Power BI and Windows 10/Server 2012/2016.

MS SQL Server /SSIS/SSRS/SSAS Developer

Roles and Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations and executed the packages using the execution package.
• Conducted data migration processes in the SQL server environment using SQL Server Integration Services.
• Extracted data from various operational systems including flat files, spread sheets and RDBMS like SQL Server and Oracle.
• Conducted and automated the ETL operations to extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multidimensional Data Warehouse.
• Created copies of operational databases using the Import/Export Wizard and OLAP/OLTP environment.
• Crated complex ETL packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created ActiveX script to execute VBScript.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages .
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for deploying, scheduling jobs, alerting and maintaining SSIS packages.
• Created parameterized, cascaded, drill-down, drill-through and cross -tab reports using SSRS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Confidential Analysis Services.
• Designed SSAS cube to hold summary data for Targit Dashboards and developed cued with star schema.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
• Created roles using SSAS to restrict cube properties.
• Configure reports using the Datamart Extraction Viewer
• Reduction of Datamart projects by streamlining development strategies at ETL layer for single and disparate data sources.
• Datamart architecture functionalities created for easy maintenance from centralized architecture base.
• Implemented Datamart Architecture, developer methodology, and consolidation strategies resulting in 85% reductions in project costs.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Environment: Confidential SQL Server 2014 Enterprise Edition, Confidential Access 2013, Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), Confidential Visual Studio 2012/2015, ActiveX, Crystal Reports, Oracle, Confidential Visio and Windows Server 2012.

MS SQL Server /SSIS/SSRS Developer

Roles and Responsibilities:

• Created DTS Packages to copy tables, schemes, views and to extract data from Excel using SSIS.
• Designed, created and deploying SSIS packages for transferring data from flat files, excel spreadsheets and heterogeneous data to and from SQL server.
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Worked on migrating some of the DTS packages into SSIS.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Created complex stored procedures, SSIS packages, triggers, views and other SQL joins for an application.
• Enhanced query performance by adding covered indexes and adding file groups.
• Creating and handling schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers and maintaining referential integrity.
• Created standard reports, Cross Tab reports and Drill-Through reports.
• Developed reports using SSRS and crystal reports. Used table control, matrix control for cross tab reports.
• Created reports using Global Variables, Expressions and Functions for the reports.
• Created different Chart reports helped in analyzing performance counters using SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Imported data from Confidential Access Database and XML to SQL Server database.

Environment: Confidential SQL Server 2012/2014 Enterprise Edition, Confidential Visual Studio 2012,Integration Services(SSIS), Reporting Services (SSRS), Confidential Access, IIS 8.0, VBScript, Excel and Windows Server 2012.

MS SQL Server Developer/DBA

Roles and Responsibilities:

• Installation of SQL Server 2012 and creation of database objects.
• Partially involved in system study and database designing.
• Responsible for developing GUI screens.
• Facilitated simplified access of database for end users using De-normalized views and created triggers on them to maintain to database integrity.
• Writing stored procedures and triggers based on the requirement.
• Involved in creating Database, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Created views consisting of computed columns to facilitate easy user interface.
• Involved in Job scheduling and alerts.
• In depth working knowledge of ODBC.
• Established backup and recovery procedures for database and implemented automated jobs for backup.
• Coding, testing and designing of ActiveX Controls.
• Designed different kinds of transactions for the application.
• Developed C# windows application with oracle backend. Development included creation of new build process and creation of Oracle stored procedures and packages.
• Implemented and maintained database security.

Environment: Confidential SQL Server 2008 R2/2012, Confidential Access 2010, Integration Services(SSIS), Confidential Visual Studio 2010/2012, DTS, T-SQL, Oracle 11gR2 and Windows Server 2008R2.