SUMMARY

• Around 8 years of experience in SQLServer, database design, development and maintenance
• Experience in gathering business requirements and implementing in SQL
• Proficient in MS SQLServer BI suite, SSRS, SSIS and SSAS
• Experience in gathering supply chain data and transforming the data using SSIS
• Proficient in query optimization and performance tuning using execution plan , activity monitor and DMV and DMF
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, scripts,calls,forms, tables, user profiles, relational database models and data integrity, SQL joins and query writing
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML
• Extensive experience in Visual Basic
• Experience in designing STAR and SNOW FLAKE Schemas.
• Extensive experience in OLTP/OLAP environment
• Experience in setting up replication and database maintenance task such as backups and performance tuning
• Created reports in SSRS of type drill down, cascading, parameterized, tabular, charts and matrix
• Hands on experience in creating complex SSIS packages. Extensive experience using various transformations like Lookup, Derived Column, Conditional Split, Sort, Union All, and Cache Transform in SSIS while transferring data from different sources into the destination files
• Create and manage subscriptions, report delivery using report manager
• Create dashboards and self-service reports in Tableau 7
• Creating and integrating efficient business solutions using Object-Oriented SOA

SOFTWARE SKILLS

• Languages: PL/SQL, T-SQL, VB, C
• Database: Oracle 11g/10g, MS Access, MS SQL Server 2012/2008/2005
• Tools: SQL TOAD, MS Office, Visual Studio 2008, Tableau 7,Cognos

Work Summary

Confidential

Senior BI Developer

• Create and maintain subscriptions for automatic delivery of reports
• Create Excel based pivot ,charts and trends and activity to management
• Work on designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets to and from SQL Server
• Created macros in Excel using VB
• Move data across different environments using SSIS. Create packages to support business processes and loading incremental data into data warehouse
• Tune the sql used behind the reports for faster execution using executions plans. Create clustered and non-clustered indexes as needed, and clean up inefficient code
• Extensive experience in using DMV and DMF to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance
• Strong SQL Server Development skills including writing Transact-SQL T-SQL Queries, Stored Procedures, Triggers, User Defined Functions UDF , Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constraints, Rules and Default Values.
• Extensive experiences in developing Normalization, Stored Procedures, Views, Triggers, ETL processes, relational database theory and Complex Queries on SQL Server 2005/2008
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using Bulk Insert Task in SSIS

Confidential

Senior BI Developer

Responsibilities:

• Generated actionable reports showing trends for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Created subscriptions to automate report delivery
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Scheduled jobs using SQL agents to run daily, weekly and monthly
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQLServer using SSIS and also used BCP and Bulk Insert.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• SQL/VBA database performance monitoring, tuning, and analysis.
• Used VB to create forms that accept user input
• Optimized reports using VB
• Developed VBA code to automate data collection and integration processes
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Used SSIS tasks such as data flow, script, data profiling etc. as per the requirement
• Performance tuning ofSQL queries and stored procedures using SQLexecution plan, activity monitor, profiler, data management view and data management functions
• Analyzed existing Stored Procedures Triggers and increased modularity by splitting them into smaller chunks
• Wrote stored procedures to get the fields required for the reports.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views
• Created datasets using stored procedures and reports using multi value parameters
• Deployed the reports in to the report server and manage folders according to the security roles
• Installing SQLServer 2008 as necessary on different environments and teammates
• Performed changes to transactional replication as necessary to the subscriptions when schema changes are done
• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Confidential

BI Developer

• Designed and developed SQLSSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLserver 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 extracting data using SSIS from OLTP to OLAP
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule DTS/SSIS Packages
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and OLTP Database.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and Package configuration.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created clustered and non-clustered indexes on tables to speed up queries and analyses using SSMS
• Designed and created cubes in SSAS.Deployed and processed SSAS cube weekly to update information by using SQLServer Agent.
• Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts
• Used reports elements such as table, matrix, tablix to create cross tab reports handled sub reports and defined query for generating drill down reports.
• Wrote queries for ad-hoc reports for analysis of data Writing reports using Microsoft Reporting Services SSRS
• Develop scripts for the creation of the physical data warehouse database schema s , data security and protection, managing performance, performing backups/ restores, and archiving data.
• Implement analysis service database maintenance procedures and backup schedule

Confidential

SQL Developer

• Designed dimensions/tables and the requisite relationships, designed partition tables and partition views by using Erwin to meet business requirements.
• Created SQL Server Reports based on the requirements using SSRS 2005.
• Identified and defined the Datasets for the report generation.
• Identified the database tables for defining the queries for the reports.
• Wrote SQL queries for various drill down reports.
• Designed various report layouts.
• Experienced in sorting the data, defining subtotals for the reports.
• Defined parameters for parameterized reports.
• Created roles for the reports though report manager.
• Created and modified stored-procedures, triggers, views.
• Created database objects such as tables, views, stored procedures, indexes etc.
• Provided index tuning as required for performance improvement of the Applications.
• Created new jobs and monitoring the daily scheduled jobs.
• Tuned the SQL scripts that are dependent on slow running applications.
• Stress tested the server for performance measures using Load Runner.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Created Database and database objects in SQLServer 2005.
• Reviewed all DTS packages in SQLServer 2000 and migrated to SSIS.
• Used SSRS to develop business perspective reports.
• Created managed the database users', login IDs and security.
• Daily Monitored the Schedule Database maintenance jobs.
• Restored databases on the servers.