SUMMARY

• Over 5 years of in - depth experience in database design, development, administration and maintenance of ETL, SQL Server 2016/ 2014/2012/2008 /2008 R2 large scale databases.
• Involved in all phases of SDLC (Software Development Life Cycle).
• Proficient working experience with SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Extract Transform Load ETL development using SQL Server on Integration Services SSIS and SQL Server on Reporting Services SSRS.
• Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Experience of SQL, especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators.
• Knowledge of Materialized Views.
• Experience in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Cubes and calculated measures for OLAP cubes.
• Managing security by creating and granting Roles and Privileges to users.
• Experience in developing external Tables, Views, Joins, Cluster indexes and Cursors.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in creation of table partitioning by range, list, hash, composite methods and Indexes for managing large tables.
• Developed new Reports which are used to extract data from different systems and criteria.
• Automated the process through the UNIX Shell Scripting and auto sys job scheduling.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.

TECHNICAL SKILLS

Operating Systems: UNIX, LINUX, Windows Server 2014/2012/2008 , Windows XP, Windows Vista

Databases: SQL, T-SQL, Oracle, MS Access

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS). rEPORTING Tools: SQL SERVER REPORTING SERVICES, MS EXCEL, CRYSTAL REPORTS, POWER BI lANGUAGES: HTML, C#, .Net wEB TECHNOLOGIES: HTML, DHTML, XML, XSL, Java Script (Validation), CSS mETHODOLOGIES: AGILE, SCRUM, Waterfall

PROFESSIONAL EXPERIENCE

Confidential

SQL/ETL DEVELOPER

Responsibilities:

• Database design and development including Tables, Primary and Foreign Keys, Indexes and Stored Procedures.
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
• Migrating databases to SQL server and involving in rewrite codes and validate after migration.
• Developed, monitored and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS SQL server reporting services and SSAS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Involved in SQL Server Configuration, Administration, Implementation and Troubleshooting for Business work. Migrated existing self-service reports and adhoc reports to Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems. Used workflow manager for session management, database connection management and scheduling of jobs.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.
• Developed T-SQL for maintaining, developing and creating database and fine tune Stored Procedures and Queries to improve performance of system.
• Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Maintained a series of UNIX Shell Scripts to manage batch order processing.
• Tune SQL statements using hints for maximum efficiency and performance, create and Maintain/modify SSIS Packages, mentor others with the creation of complex SQL Statements, perform data modeling and create/maintain and modify complex database Triggers and Data Migration scripts.
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
• Documentation of the business process through Designer.
• Created, debugged, and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.

Environment: SQL Server 2016/2014, SQL Developer, SQL Loader, TOAD, UNIX, Sun Solaris’s Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS,, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Data Factory, Visual Studio, C#.

Confidential

SQL/SSIS Developer

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Working on the ETL side of the process to load data into database from different servers.
• Created partitions for parallel processing of data.
• Created functional/non-functional requirements via JAD sessions.
• Designed data integration process and collaborate with business analyst for various project needs.
• Developed complex stored procedures and functions to perform data profiling and business calculations.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Optimized the logic in procedures, functions, and triggers.
• Enhanced the performance of inefficient queries with SQL profiler and DTA.
• Utilized SQL server table configuration to configure package properties.
• Devised complex expressions for calculations, groupings, filters, and formatting contents of SSRS reports.
• Developed UNIX Shell scripting for job automation and daily backup.
• Documentation of the business process through Designer.
• Writing backend stored procedures.
• Writing event driven Triggers, Functions and Packages as needed.
• Writing SQL queries, Cursors using embedded SQ.
• Testing and debugging of the applications.
• Separating of tables and indexes on different locations. Reducing Disk, I/O Contention.
• Extensive Use of Pragma Autonomous Transactions.

Environment: MS SQL Server 2012/2014, BIDS, SSIS, SSAS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA, TFS, SQL Developer

Confidential

ETL developer

Responsibilities:

• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs.
• Created and Scheduled jobs to send the data to PCG, Destiny and Tip Web on daily basis.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract, transform and load jobs.
• Developed different types of Tabular, Matrix, Drilldown, Drill Through reports to PCG and SAP team using SSRS.
• Deployed SSRS reports to 2008 report manager and exported them to desired formats like Excel, pdf etc. for end user access.
• Scheduled Reports to run the reports Hourly, Daily, and Monthly according to client requirements for the periodic analysis.
• Created tables, views, stored procedures, functions in SQL Server.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in the development of new Procedures, Functions, Packages, Triggers and updating the old ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and with their relationships.
• Developed new Forms which are used to extract data from different systems and criteria. The results are written to a flat file.
• Performed unit testing of data extraction forms.
• Prepared technical specifications document for the Procedures which is used to update the purchase order information from one database to another database.
• Used Database Trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Created Indexes and Sequences for faster retrieval of the customer information and enhance the database performance.
• Used shell scripting in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Created Documentation of development code and the test cases involved.

Environment: MS SQL Server 2008 R2/2005, MS SQL Server Integration Services (SSIS) 2012/2008R2/2008, MS SQL Server Reporting Services (SSRS) 2008R2/2008, ETL,SQL Server Business Intelligence Studio(BIDS), AZURE, T-SQL, Power BI, SharePoint, Tableau.