SUMMARY

• Over 9+ years of strong SQL Server Developer and Business Intelligence experience.
• Expertise in MS SQL Server 2016/2012/2008 R2/2008/2005 and Business Intelligence including SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SSAS.
• Expert in planning, modeling, designing, developing, implementing, administering and maintaining MySQL, Microsoft SQL Server 2012/2008R2/2008/2005 databases.
• Highly proficient in the use of T - SQL and MySQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Developing reports on SSAS & SSRS on SQL Server (2008/2008R2/2012.
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables.
• Proficient in Joins (Inner join, Left Outer, Right Outer Joins, Full join and Cross join) and Indexes.
• Experienced in database design, performance tuning, data modeling & working with databases.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Proven expertise in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services and experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column, DQS, Fuzzy Lookup, CDC splitter in SSIS.
• Proficient in SQL Server and MySQL Performance tuning and Query Optimization.
• Expert in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.
• Proficient in creating and managing roles and security of reports and scheduling Subscription of Reports using SSRS.
• Expert knowledge and experience with managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Experienced in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Knowledge on SCRUM to solve defects and monitor daily progress.
• Strong leadership, communication, problem-solving and multi-tasking abilities.
• Participated in weekly status meetings and coordinated with developers to Resolve/close defects.
• Have ability to effectively interact and coordinate with the team to meet the project related deliverables.
• Excellent Analytical Problem Solving Skills, Written and verbal communication skills.
• Capable of quickly adapting to new challenges and environments.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment and working well under pressure.

TECHNICAL SKILLS

• SQL Server 2005/2008/2008 R2/2012/2016
• SVN
• TFS (Team foundation Server)
• JIRA
• SQL Server Business Intelligence Development Studio (BIDS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• SQL Server Agent
• SQL Server Profiler
• Database Engine Tuning Advisor
• Report Builder
• DTS
• SharePoint
• Office Word
• Excel
• Access
• PowerPoint
• Visio
• T-SQL
• XML
• Windows

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. SQL Server BI Developer

Responsibilities:

• Involved in gathering requirements, performing source system analysis and development of ETL jobs to populate data from the transactional data source to the target Data warehouse.
• Created new database objects like Stored Procedures, Functions, Indexes, SQL Joins, Statements, Clustered and Non-Clustered index and Views using T-SQL in Development and Production environment on SQL Server
• Used OLEDB Source, Excel, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Currently working in Agile, Scrum, stand up meetings, Sprints, Backlog grooming sessions. Optimized SSIS Packages. Reverse engineering and prepared documentation.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, DQS, Fuzzy Lookup, CDC Splitter, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Deployed SSIS projects to the Integration Services catalog and configured those using Parameters.
• Involved in complete SSIS Life Cycle - creating SSIS packages, building, testing, deploying and executing.
• Worked on Change data capture (CDC) control task and CDC Splitter in SSIS 2012.
• Successfully loaded data from different data sources (Oracle database, Excel spreadsheet, XML and flat file) into SQL Server database using SSIS package
• Created SSIS package to run the ETL process needed for daily/weekly/monthly refresh which includes multiple source systems involving complex stored procedures to support new features and reporting needs.
• Added Data Taps in SSIS at run time without modifying the packages to review the data before loading into destination.
• Used SSIS parameters at package level and project level to configure packages for different environments.
• Expertise in using different transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
• Created matrix, parameterized and tabular reports with drill down, drill through and drop down menu using SSRS.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Generated reports using Global Variables, Expressions and Functions in SSRS.
• Configured SSIS Packages using run time parameters and Configuration file.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Scheduled tasks to run every day to update changes in the base tables.

Environment: MS SQL Server 2012/2016, Windows, SSIS, SSRS, T-SQL, SVN, JIRA, OLTP, MS Office 2010, Excel 2010, Microsoft Visual Studio 2010.

Confidential, San Jose, CA

Sr. SQL Server BI Developer

Responsibilities:

• Worked with Business Users and Business analyst in gathering requirements and preparing the functional and technical documentation.
• Used Temporary tables, table variables in Stored procedures to simply complex queries
• Optimized queries by analyzing different query options, and indexing strategies.
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using SSIS.
• Created ETL packages that reads Product, Vendor, and Order data from an FTP server into a SQL Server database.
• The solution also validated incoming Data and performs notifications when jobs complete.
• Created SSIS packages to load data from Heterogeneous sources like Flat files, CSV files and Excel.
• Implemented custom logging to keep track of the packages being run automatically. Configured the packages to run on different servers using Package Configurations.
• Created packages in SSIS with error handling using Event handlers.
• Used various transformations in SSIS like Lookup, Derived Column, Union all, Merge to modify the data which is stored in various forms efficiently.
• Scheduled SSIS packages using SQL Server Agent.
• As part of a team, created various reports according to the business requirements. Individually authored, installed, deployed and managed reports using SSRS 2008.
• Generated drill through, drill down which projected data as per the user requirements using SSRS.
• Redesigned older reports in Crystal reports to meet the changing requirements to cater and provide business solution to the end user using SSRS 2008.
• Implemented Conditional formatting using Expressions in SSRS 2008.
• Created Parameterized reports using Text and Stored procedures as source in SSRS.
• Used report model project and Report Builder 3.0 to generate ad-hoc reports using SSRS 2008
• Deployed SSRS reports to share point server and also used Excel services in Share point application.
• Managed subscriptions and data-driven report subscriptions to provide timely reports to the clients and end users, also created snapshots to reduce loading time.
• The order data loaded into the SQL Server was used to generate reports and charts using the SSRS 2008 reporting functionality (Tablix control, charting features).

Environment: SQL Server 2012/2008R2, MS Excel 2007, MS SQL Query Analyzer, Crystal Reports, SQL Profiler, ETL, MS SQL Server Reporting Services, MS SQL Server Analysis Services.

Confidential, Springfield, NJ

SQL Server BI Developer

Responsibilities:

• Based on the data models created all the objects in the database including tables, views, keys and constraints
• Generated reports using MS SQL Server Reporting Services 2008
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server.
• Generated various Report models on Views and deployed them on to the production reporting server.
• Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Created standard report Subscriptions and Data Driven Report Subscriptions
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Reviewed and fine-tuned stored procedures and triggers before production migration.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services, SQL Profiler, Query Analyzer, MS Office.

Confidential, St Louis, MO

SQL Server BI Developer

Responsibilities:

• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Monitored physical implementation of database into SQL Server 2005 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQLcode andSQLjoins for applications followingSQLcode standards.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases and Managed database portioning across multiple disks.
• Query optimizations (TSQLor Query Analyzer) using query analyzer and Index tuning wizards.
• MonitorSQLError Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files intoSQLserver2005 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.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Migrated (import & export/BCP) data from Text to SQL Server.
• Assisted in complete back-up of database and restored the database from Disaster Recovery.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2005/2008, DTS, T-SQL, VSS, XHTML, XML, Windows Server.

SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Performed Backup and restore of databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Queries, Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Performed daily database backup & restoration and monitor the performance of Database Server.
• Create joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Installed and Configured SQL Server on development server for designing and testing.

Environment: SQL Server 2005, T-SQL, SQL Server Enterprise Manager, DTS Designer, SQL Profiler.