SUMMARY

• Around 8 years of total IT experience with SQL Server Database 2016/2014/2012/2008 R2/2008/2005 development, providing T - SQL Programming, BI Tools ETL - SSIS, Reporting - SSRS and database administration.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Synonyms, Cursors, Functions and Joins.
• Extensive knowledge and experience in developing scripts usingT-SQ for querying against databases.
• Expertise in implementing business logic usingTriggers, Views and Stored Procedures.
• Good knowledge of Database Administration operations like Installation and configuration, Backup, Restore and excellent knowledge in Transact-SQL (DDL, DML, DCL).
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).
• Adept in creating ad-hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports.
• Experience in writing SSRS Expressions and SSRS Configuration, deployment for single server environment.
• Experience with Microsoft Power BI to build and maintain the reports and dashboards with Excel, SSAS, Flat File, SQL Server and SQL Azure data sources.
• Experience in configuring report manager for creating report subscriptions, snapshots, and caching.
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Experienced in providing 24X7 production support for critical ETL processes and strategic financial reports.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multiload)
• Testing the basic operations, validations and functioning of the pages.
• Good interpersonal communication, problem solving, documentation and business analytical skills. A multi-tasking analytical thinker with the ability to work on fast paced work Environment.
• Expert in creating and deploying ProClarity and Dashboards, reports.
• Conversant with all phase of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS

Programming Languages: T- SQL, HTML, MDX, DAX, C, C++, PL/SQL

Databases: SQL Server 2016/2014/2012/2008 R2/2008/2005, SSAS, MS Excel, MS Access, Microsoft SQL Azure

ETL Tools: SSIS, SSRS, Crystal reports, Power BI, Tableau

Data Modelling Tools: Microsoft Visio 2003/2007/2010 , Erwin and Power Builder

SQL Server Tools: SQL Server Management Studio, Microsoft Visual Studio 2015/2010 (Data Tools)

Data Warehousing & BI: Star Schema, Snowflake Schema, Facts & Dimensions Tables

Operating Systems: Windows XP/2007, Windows server 2003/2012/2008

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

SQL / Power BI Developer

Responsibilities:

• Involved in database development usingstored procedures, triggers, viewsandcursors.
• CreatedDatabases,Tables,Cluster/Non-Cluster Index,Unique/Check Constraints,Views, Stored Procedures, Triggers.
• Wrote efficientstored proceduresfor the optimal performance of the system.
• Monitored performance and optimizedSQLqueriesfor maximum efficiency.
• Responsible for Creating and ModifyingT-SQLstored procedures/triggersfor validating the integrity of the data.
• Createdindexedviews, and appropriateindexesto reduce the running time for complex queries.
• To keep track of data manipulations usingAuditfunctionalities.
• Generated custom and parameterized reports usingSSRS.
• Created reports that call sub reports inSSRS.
• Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing ComplexSSRSReports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets usingT-SQLandStored Proceduresand involved inData visualization.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Provided 24X7 production support to ensure timely and error free delivery of reports.

Environment: MS SQL Server 2016/2014/2012/2008 R2, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7

Confidential, Phoenix, AZ

MS SQL Developer

Responsibilities:

• Developed complex T-SQL Stored Procedures, Functions, Tables, and Views, Indexes and other SQL joins and statements to extract required data from servers across loactions and load them into local databases.
• Created database objects like tables, views, indexes etc. using T-SQL statements. Created and modified stored-procedures, triggers, cursors. Created & managed the Database Users, Login Ids and Security.
• Wrote different complex SQL queries including inner, outer join and update queries.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created Views to reduce database complexities for the end users. Created Stored Procedures to load data in different tables.
• Designed SSIS Packages to load data from differnt sources like excel, flat file, csv etc.
• Provoided 24X7 support to ensure all the data warehousing activities were completed and reports were up-online.
• Debugged T-SQL queries for performance tuning. Ensured the entire ETL process completed within the deadline time and investigated various stages and reasons for delays.
• Designed complex and custom reports using SSRS with drilldown features, sub reports, charts.
• Modified existingSSISpackages to meet current business needs Environment.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Used various Transformations like merge, sort, and aggregate in SSIS Dataflow.

Environment: MS SQL Server 2008R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SSDT, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, Eagan, MN

MS SQL Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Created linked, unlinked and on-demand sub Reports.
• Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Created User Defined functions for sharing formulas across multiple reports.
• Modified existing reports according to requirements of the end users.
• Gathered business requirements from customers and created status reports.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, T-SQL

Confidential

MS SQL Developer

Responsibilities:

• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Performed DBA roles like backups and created jobs in SQL Server.
• Developed many Tabular Reports, Matrix Reports, and Drill down Reports, Sub-Reports, Drill Through, and Parameterized Reports using SQL Server Reporting Services (SSRS).
• Developed parameterized reports, linked reports, matrix and tabular reports with drill down and drop-down menu option.
• Deployed the generated reports on to the Report server and fine-tuned the database objects to ensure efficient data retrieval.
• Worked on with Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager.
• Good experience interacting with end users for understanding bussiness processes and implementing the same through T-SQL for process automation.
• Identified and defined the Datasets for report generation.
• Provoided 24X7 support to ensure all the data warehousing activities were completed and reports were up-online.
• Created SQL Server reports using SSRS, tasks included defining requirements, design, develop, test, implement and maintain reports.
• Developed parameterized reports, linked reports, matrix and tabular reports with drill down and drop-down menu option.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler. Established backup and recovery of SQL reporting services

Environment: MS SQL Server 2008, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS)

Confidential

SQL Server Developer

Responsibilities:

• Created tables and wrote stored procedures usingSQL Server 2005.
• Created Reports and designed graphical representation of analyzed the data.
• Extensively worked on various SSRS Chart, Tabular and Matrix reports for Product data management
• Involved in enhancements of existing site and bug fixing activities.
• Developed ETL’s using transformations like Merge, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Derived column, Copy Column, Conditional Split, Data Viewer, Union All, Script Component, Character Map transformations to develop Packages.
• Designed screen shots for the frontend users and handled the backend.
• Involved in checking of coding standards and code review for application code.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Created joins for complex queries involving multiple tables.
• Developed and modified existing reports as per the business requirements.

Environment: SQL Server 2008, SSIS, HTML, XML,SSRS