SUMMARY

• 7 years of experience as Microsoft Business Intelligence Developer involved in developing solutions using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Acquainted with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expertise in developing SQL Server databases with T - SQL for constructing Triggers, Tables (DDL), Joins, Cursors, User Functions, Views, Indexes, User Profiles, Relational Database Models (RDBMS), data dictionaries and data integrity.
• Hands-on experience with Star & Snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Experienced in implementing various logic using objects like Tables, Joins, Views and Constraints using Data Definition Language (DDL), Data Manipulation Language (DML).
• 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 Logical and Physical Database design & development, Normalization and Data modeling using ERWIN and SQL Server Enterprise Manager.
• Experience in designing and developing complex reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and Ad-hoc reports for Business Users using SQL Server Reporting Services (SSRS).
• Experience with SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard for monitoring and tuning MS SQL Server performance.
• Proficient in SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
• 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.
• Designed and developed QlikView and Qlik Sense dashboards by extracting data from different sources like SQL Server, Excel files, Oracle, SAP, Flat Files, XML Files.
• Good Communication and interpersonal skills with strong ability and experience in seeking solutions effectively in challenging environments.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, Unix

Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio, BCP, Team Foundation Server (TFS)

ETL & Reporting: SSIS, SSRS, SSAS, Excel, Power View, PowerPivot, Tableau

Databases: MS SQL Server, Oracle, MySQL, MS Access

Database Modeling: MS Visio, Erwin

Languages: SQL, T-SQL, C, C++, C#, .NET, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

MSBI Developer

Responsibilities:

• Responsible for gathering requirements, analysis, design, functional & technical specification, coding, testing and documentation of new module development.
• Used teh Business Process Modeling (BPM) to GAP Analysis to bridge teh gap between business processes.
• Created SSIS Package Configurations and maintained teh Tables by editing teh values of teh variables as per teh requirement.
• Developed teh packages with monitoring features and logging so dat audit information of teh packages and their execution results are loaded in to teh audit table.
• Worked on teh row count transformation and Event Handlers control flow to populate teh special Log tables with high level SSIS package execution.
• Developed Informatica mappings for data loads, business rules development, data cleansing.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Designed packages including direction of Data Flow, Column Mapping, Data Dictionary, Metadata Flat file Source & Destination, and OLEDB Source & Destination using SSIS.
• Created different Facts and Dimension tables to increase teh performance of complex SQL queries dat are used in SSRS reporting.
• Involved in performance tuning of MDX queries for efficient reporting performance.
• Reverse engineered backend database to change teh T-SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance drastically.
• Developed services to store SQL Server data in to Cloud base data warehousing by using Microsoft Azure and Amazon Web Services (AWS) Redshift.
• Implemented data and storage management solutions in Azure, SQL Azure, Azure files, Queue storage, Blob storage
• Configured teh Azure storage accounts to enable soft delete and enabling teh Encryption for teh data at rest by using teh keys provided by Microsoft.
• Used TFS for maintenance and status of teh developers for development of application.
• Created various types of performance reports from teh TFS server database using SSRS.
• Created Non-Clustered Indexes on new servers for enhancing teh performance of teh queries.
• Created dashboards in Power BI using DAX expressions to deploy them using content pack.
• Responsible for monitoring SQL Error Logs, scheduling Tasks, Database Activity, and eliminating Blocking and Deadlocks.

Confidential, Edison, NJ

BI Developer

Responsibilities:

• Collected requirements from business users and transforming them into logical and physical database designs.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.
• Migrated tables from old data warehouse to new database for transaction history of teh app.
• Created DAX calculated columns in power pivot worksheets to extract, import and join data dat coming from different sources.
• Developing SSIS packages dat upload multiple Flat files using For-Each Loop Container and other control flow tasks like File System task, FTP task, Send Mail Task, Script Task.
• Used Data Transformation Services (DTS) and ETL tools to populate data from various data sources, creating packages for different data loading operations for application.
• Gained understanding of OLAP processing for changing and maintaining warehousing optimizing dimensions and hierarchies and adding aggregations to cube.
• Involved in writing MDX queries and performance optimization of SSAS cubes for calculated members and measure groups.
• Responsible for Implementation of tagging on all teh Azure resources to logically organize teh resources.
• Created Docker Containers and managed Azure Container Registry with Kubernetes Service.
• Responsible for incident management from job monitoring to Root-Cause Analysis to issues resolution.
• Responsible for performance tuning and optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Worked with QlikView & Sense objects like Multi Boxes, Straight tables, Combo charts, Pivot tables, Pie charts, Bar charts, Scatter charts, Containers, Line charts, Line objects, Buttons.
• Worked with Qlikview dashboard and automated daily data loads of QVW documents using QlikView Publisher
• Migrated QlikView applications to production environments and handled performance tuning
• Created reports to retrieve data using function, views, stored procedures and T-SQL code using parameters.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Worked on deploying and scheduling Reports using SSRS and Tableau as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared teh Layouts by placing teh fields to teh appropriate place according to teh requirement of teh final Report.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.
• Responsible for scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Confidential, SFO, CA

SQL BI Developer

Responsibilities:

• Involved in gathering requirements and analyzing teh requirements related to teh project.
• Wrote complex SQL queries involving multiple tables from different databases using Joins, Stored Procedures, Temporary tables, functions.
• Worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data.
• Scheduled package execution using SQL Server Management Studio to execute packages on a daily and weekly basis.
• Developed SSIS ETL packages using data warehouse architecture model by creating fact tables role playing and conformed dimensions.
• Used ETL to implement teh slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpaved Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/SQL Server Logging for all SSIS packages.
• Responsible for Analyzing requirements, designing, maintaining and updating data models using Erwin.
• Created package configuration in XML and used to deploy packages into SQL server.
• Identified teh Issues dat occur during teh package execution by redirecting teh rows from source component to error output.
• Created data sources, data source views, dimensions, measures, measure groups, key performance indicators (KPI), perspectives, partition aggregations. And deployment and processing SSAS objects.
• As part of Business Intelligence and Reporting team, played a key role in Development and Maintenance of SSRS Reporting Environment.
• Used Temp Tables to reduce teh number of rows for joins, to aggregate data from different sources for different reports, Created Complex Charts and Drill Down reports using SSRS.
• Created Views, Materialized Views to get teh values dynamically using joins and other SQL queries from teh multiple tables.
• Created MDX queries to retrieve data from teh cube and also to display SSRS reports.
• Designed and developed SQL codes for Tableau Reporting.
• Manually ran SQL Jobs which generates teh Weekly, Monthly and Quarterly reports after making sure dat teh input data acquired or not.

Confidential, Kirkland, WA

SQL Developer

Responsibilities:

• Interacted with business users for understanding and gathering business requirements and involved in project planning.
• Wrote complex stored procedures to get data from servers & generated reports on dat data.
• Performed data transfer from files in remote server to folders in another server using FTP.
• Generated various reports like Matrix reports, Tabular reports, and Drill down reports.
• Built teh report models, created a wide variety of interactive reports for business users in SSRS and deployed teh reports in various formats depending on teh user requirements.
• Designed reports and tuned them for optimal performance when using Multiple Parameters.
• Transform teh data from teh staging database and perform teh transformation using teh Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled teh Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Managed teh use of disk space, memory and connections.
• Prepared of project documentation.
• Worked with application developers in data modeling.
• Created materialized views and normal views as per requirement.
• Imported data from PeopleSoft to MS SQL Server database.
• Developed with a focus on structured query language, T-SQL, Stored procedures and triggers, automating and improving repetitive data tasks so they are more efficient.
• Reviewed and fixed issues related to pre-existing SQL queries, Ensured all database servers and Backups
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.

Confidential, Westfield Center OH

SQL DBA

Responsibilities:

• Worked in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
• Performance Tuning of theSQLServerin OLTP, Web based, Production and Development environments including teh usage of Performance Monitor and Profiler Trace to monitor, and use Index Tuning Wizard to create proper indexes.
• Identified teh performance bottlenecks like CPU, Memory, and me/O and tuned and improved teh overall performance of theserverfor many clients.
• Responsible for Setup and maintaining Log shipping, Mirroring Replication.
• Installed, Authored, Managed and Deployed Reports using SSRS.
• MonitoredSQLserverperformance on regular basis, and gatheird data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• UsedSQLProfiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning ofSQLServerandSQLcode.
• Involved in improving teh performance of SSRS reports to complete teh report in a timely manager by debugging and indexing history tables.
• Utilized SSIS packages functionality to create complete ETL Process using scripts, stored procedure, Functions and Transformation of Data in BIDS.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• ConfiguredSQLServerswith appropriate settings to resolve various resource allocation & memory issues.
• Reviewed T-SQLcode written by developers to follow better standards, procedures to optimize for better performance before QA deployment.
• Installed, Configured, Developed and Deployed SSIS packages.