SUMMARY

• Highly motivated Business Intelligence Professional using SQL Server 2016/2014/2012 and Microsoft Technologies.
• Experience in MS SQL Server 2016/2014/2012 , SSRS, SSAS, SSIS packages.
• 6 Years of strong experience in IT industry as SQL Server Developer in Tax, Financial & Banking, Health care domains.
• Strong conceptual, analytical, and design skills and excellent communication skills with leadership qualities.
• Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Successfully extracted Data from Different Databases like Oracle, DB2.
• Expert in Migrating DTS Packages to SSIS.
• Created SSIS Packages to import and export data from Excel Spreadsheets, ACESS, Text files and CSV files
• Well Experienced in Generating parameterized reports in SSRS.
• Expertise in creating SQL server Reports using SSRS.
• Extensive experience in basic and advanced report creation with thorough knowledge of report serving architecture. Experience in creating various types of reports(table, chart, list and matrix report)
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Experience with BI visualization tools such as Power BI, Tableau.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes dimensional modeling and reporting tools.
• Hands on experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, Stored Procedures user profiles, relational database models, cursors, data dictionaries, and data integrity
• Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, Table Variables
• In depth knowledge of TSQL
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc)
• Expertise in Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Database Mirroring, Optimizing and Tuning of SQL Queries.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in Cube designing in Business Intelligence Development Studio using SSAS.
• Strong experience in defining Referenced relationships in SSAS. Technical Skills

TECHNICAL SKILLS

RDBMS/Database: MS SQL Server 2016/2 R2/2008, MS Access,Oracle, DB2.

Programming Languages: VB.net, T-SQL, HTML, XML, C, C#, Visual Studio 2015/2010/2008

ETL Tools: SSIS, DTS,SQL Profiler, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling

Reporting Services: Power BI, Excel, VBA, SQL Server Reporting Services, Crystal Reports

SQL Server Tools & Packages/BI tools: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, MDX, ETL, SSIS, SSAS, SSRS

Office Tools: MS-Office 2016/2010/2007

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL/BI Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the database from heterogeneous sources.
• Gathered, analyzed and documented business requirements and developed Business Requirement Documents and Functional Requirement Specifications.
• Extract, transform, load, process, evaluate and maintain integrity of client-provided data.
• Programming and developing utilizing ETL tools, which extract raw payroll files, transform payroll data to current system specifications, and export load-ready files for system import.
• Performing regular quality assurance review of all assigned client data files and reporting all applicable issues to the business owner for review and resolution by the client.
• Programming with T SQL, SSIS, Clover ETL
• Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Built dashboards in Power BI
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: SQL Server 2016/2014, Power BI,MS Access, MS Excel,Clover ETL tool, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential, Jersey City, NJ

SQL/BI Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous sources.
• Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
• Developed and maintained critical applications for sales auditing team by balancing sales and settlements of credit amounts with the bank on a day to day basis.
• Wrote stored procedures and UserDefine scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts and SSRS reports.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast and Union all etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Worked on multidimensional data modeling.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Involved in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Participated in Databases Architecture and data modeling design.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Worked on Tableau to build reports as per business requirements.
• Built dashboards in Power BI
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.

Environment: SQL Server 2008R2 & 2012,T-SQL,Tableau,MS Access,MS Excel,&, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential - Long Beach, CA

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improved data load performance by analyzing database design and query plans.
• Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Documented different stages of data transformation, procedures and scripts.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: SQL Server 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Crystal Reports 8.0, VB Script.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Deployed SSIS packages and Reports to Production Servers. worked on migration of packages from DTS to SQL Server Integration Service (SSIS)
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Reports
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: MS SQL Server 2008, Visual Studio 2007, Visual studio.NET 2003, VSS 2005