PROFILE SUMMARY

• Over 9+ years of Experience in Data Warehousing and MS Business Intelligence applications design, development 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 2000/ 2005/20 .
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Confidential, clustering, relational database models, data dictionaries, and data integrity.
• Experience in Interacting with Business users to analyze the business process and transforming requirements, performing ETL, documenting and rolling out the deliverables.
• Responsible for creating SQL datasets for Power BI and Ad - hoc Reports.
• Working directly with stakeholders for requirements gathering and developing various decision making Dashboards.
• Hands on experienced developing dashboards and reporting visualization using Power BI Pro and connected to Azure SQL Database, Azure SQL Data Warehouse.
• Created various kinds of reports using Power BI Pro based on the client's needs and worked on Tabular CUBEs, PowerPivot, Power Query and Power View.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Expertise in creating Dashboards Scorecards, Tiles, views, pivot tables, charts, for further data analysis.
• Expert on creating complex Sub Queries, Joins, cumulative queries for multiple kind of reports.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using SSIS.
• Experience in data migration (using tools like Bulk Insert, DTEXEC and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server.
• Knowledge of risk management principles and practices.
• Expertise in creating SQL server Reports using SSRS 2005/2008/2012 .
• Expertise in creating ReportModels for building Ad hoc reports using SSRS.
• Hands-on development experience in .Net based Applications
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Experience in developing SSAS projects using MDX in MSSQL Server 2005.
• Experience in Designing, Building the Dimensions, cubes with start 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 the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• 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.
• Experience in creating XML files and XSD schema files.
• Developed reports using global variables, expressions and functions using SSRS.
• Excellent knowledge on Object Oriented Analysis and Design concepts.
• Excellent time management and strong team player.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

TECHNICAL SKILLS:

ETL Tools: Visual Studio 2013 (SSIS, SSAS), Informatica Power Center 9.1

Reporting Tools: SSRS, Power BI & PRO, SAP BO, Crystal Reports and Tableau

Data Modeling: Erwin, Rational Rose, and Microsoft Visio

Database: MS SQL Server 2014/2012/2008 r2/2008/2005, Oracle 11g/10g/9i, Teradata, MYSQL, IBM Informix 9.x

Programming Languages: SQL, PL/SQL,T SQL, C# Scripting, PowerShell Script

PROFESSIONAL EXPERIENCE:

Confidential, Glendale, CA

SQL Server Developer

Responsibilities:

• Developed complex programs in T - SQL\PL-SQL, writing Stored Procedures, Confidential and Queries with best execution plan.
• Created new tables, written stored procedures, Confidential for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modificationand adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming .
• Designed and developed SSIS Packages to extract data from various data sources such as Access database,
• Excel spreadsheet, and flat files into SQL Server 2008 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.
• Involved in ETL Production support, worked with developers to fix issues and make sure the jobs are run on time.
• Used ActiveBatch to deploye the ETL jobs in sequence.
• Created PowerShell Scripts to Preprocess validation of flat files.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• 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.
• Created Position and Transaction OLAP Cubes for various measure groups and dimensions to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Involved in performing database Backup and Recovery

Environment: s: MS SQL Server 2014, Visula Studio 2013, SSIS, SSRS, SSAS, MDX, T-SQL, Oracle 10g, MS-Office, ActiveBatch, PowerShell Scripts.

Confidential, Redmond, WA

SQL Server Developer

Responsibilities:

• Developed complex programs in T - SQL\PL-SQL, writing Stored Procedures, Confidential and Queries with best execution plan.
• Created new tables, written stored procedures, Confidential for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and Confidential to be used in production.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modificationand adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming .
• Strong experience in writing MDX queries for reporting.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008 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.
• Development of .NET batch applications which processes high volume of data.
• 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.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Created Position and Transaction OLAP Cubes for various measure groups and dimensions to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Involved in performing database Backup and Recovery
• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Used Performance Point services to build rich Dashboards and aggregating content from multiple sources in Sharepoint.
• Development of Power Pivots using Pie charts, Bar Charts, cross tabs and sub reports to achieve the client

Environment: s: MS SQL Server 2012, SSIS, SSRS, SSAS, MDX, T-SQL, Oracle 10g, MS-Office, Power View, Power Pivot, Power Query, Power Map, Sharepoint Server 2013

Confidential, Colleyville, TX

SQL DBA/ Database Developer

Responsibilities:

• Developed complex programs in T - SQL\PL-SQL, writing Stored Procedures, Confidential and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2000/2005/2008
• Defined Check constraints, Business Rules, Indexes, and Views.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• 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.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Developed Query for generating drill down and drill through reports in SSRS 2008/2012.
• Uploaded reports on to the report manager and organized them into folders.
• Understanding of current Risk management tools and techniques.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• 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 the migration of SQL Server 2008 databases to SQL Server 2012.
• Perform Capacity Monitoring and short and long-term Capacity Planning in collabor

Environment: MS SQL Server 2012/2008/2005/2000/7.0, DTS, SSIS, SSRS, SSAS, T-SQL, Excel, Oracle10g

Confidential

SQL Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database Confidential and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server IntegrationService (SSIS) packages to populate data from the 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 Spreadsheets to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SSIS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Worked as a student liaison to promote Risk Management major to students and corporate contacts
• Created Dimensionsand cubes with star schemausing SQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drillmode using tables, financial tables, crossestabs and chart.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and 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 the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• 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.
• Responsible for testing to optimize the procedures and Confidential to be used in production. Involved in project planning also schedule for dat

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

Confidential

SQL DBA/ Database Developer

Responsibilities:

• Experience in support and management of databases, systems, applications and Application Development.
• Experience in Implementation of Production environment Hardware requirements and application support.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Extensive exposure to creation of databases, objects, stored procedures, Confidential, security, DTS (i.e. Import and Export), BCP, Transact - SQL, and SQL Server Agent and SQL Server profiler.
• Experience in planning and implementing the Replication of MS SQL Server 2000 Databases and databases Backup recovery strategy.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Experience on working with BRP (Business recovery plans) and EPP exercises (Emergency prepared plans)
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server and database to another database.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Exposure in analysis services.

Environment: Windows 2000 Advanced Server, SQL Server 2000, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, Windows Performance Monitor.

Confidential

Information System Engineer

Responsibilities:

• Involved in migration of SQL server 2000 to SQL server 2005 using Upgrade Advisor.
• Designed SSIS packages to transfer data between servers, load data into database,archive data file from different DBMS s using SSMS/SQL Enterprise Manager on SQL Server 2005/2000, deploy the data, and scheduled the jobs to do these tasks periodically.
• Tuned SQL Statements using Indexes, Stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non - Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the sales and production, customer and connection details, payment history by giving the related parameters.
• Responsible for tuning and configuration of production and development servers.
• Created the stored procedures, views and scripts for application development.
• Worked with DBCC commands to check physical and logical consistency of the databases.
• Performed quality assurance by using tools and testing of SQL server environment.
• Created various reports using SQL Server 2005 Reporting Services.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005/2000, SQL Profiler, SQL Data Collector, Job Activity Monitor, MS office 2003, SSIS, DTS, T-S

1