SUMMARY:

• 3 years of experience as SQL Developer, Business Intelligence focus on various business solution strategies through SQL Server Integration, Analysis, Reporting Services (SSIS, SSAS, and SSRS), Data Warehouse, OLTP and OLAP Databases.
• Complete understanding and participated in full Software Development Life Cycle (SDLC) process.
• In - depth knowledge on Transact-SQL (DDL, DML, DCL), Design and normalization of the database tables and Relational Database Management Systems.
• Optimized code and improved efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Strong SQL development skills including writing Stored Procedures, Views, Constraints, Indexes, Triggers, CTE and User Defined Functions when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Designed, developed and tested the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems
• Collected data from various sources and used multiple transformations in SSIS to meet the business requirements
• Used SQL Server Integration Services (SSIS) to extract data from various formats such as text files, Excel spreadsheets to SQL Server databases to overcome the transformation constraints.
• Experience in providing Logs, Error handling using Event Handler, and Performance Tuning in SSIS packages using Row, Block and Unblock Transformations.
• Used SQL Server Agent to create jobs, SQL Mail, Alerts and SSIS Packages schedule
• Experience in Microsoft Reporting Service (SSRS) with expertise in Report authoring, Report management, Report delivery and Report security.
• Experience in developing reports such as Custom, Tabular, Matrix, Adhoc reports.
• Used SQL Server Reporting service (SSRS) in Business Intelligence development studio to distribute reports in multiple formats.
• Expert in creating parameterized, Drill down, Drill through, sub, Linked, Snapshot, Cached, adhoc reports using SSRS.
• Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors.
• Experience in Database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Strong knowledge of ETL processes using UNIX shells scripting, SQL, PL/SQL.
• Worked with SSAS to design and develop cubes and partitioned cubes.
• Good Knowledge Shell Scripts(PowerShell/Unix) for running database scripts
• Used Team Foundation Server (TFS) as a Source code control.
• Experience in using TFS (Team Foundation Server). And demonstrated attention to detail, creativity, with excellent time management, team development

TECHNICAL SKILLS:

Languages: SQL, T- SQL, HTML, XML, C, C#, Unix shell scripting

Databases: SQLServer2012/2008R 2/2008/2005/2000/7.0, MSAccess,PL/SQL,Oracle10/11g

Analysis/Reporting Tools: SQL Server Reporting Service, SQL server Cognos, Power play Transformer

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Informatica

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2007/2003/2000, Rally, JIRA, TFS, PPM, Microsoft Visual Studio.NET 2012/2014, Power BI

Operating Systems: Windows 10/8/ 7 /98/2000/2003/ XP/Vista, Unix

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

SQL Server/BI - Developer

Responsibilities:

• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Understanding Business Logic and Writing Stored Procedures for implementation of the application.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Provided status and communicated risks associated with the project in our Sprint meetings
• Played lead role by helping Team with development tasks, mentoring other developers and project planning in an agile environment
• Involved in upgrade of SQL Server 2008 to SQL Server 2012.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse from heterogeneous databases/data sources.
• Created SSIS packages using transformations like conditional split, data conversion, derived column, lookup, join, merge join, sort, union all, multicast, slowly changing dimension, in SSIS as per the clients Requirement.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and to data marts
• Generated multiple enterprise reports using SSRS 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.,
• Implemented database standards and naming convention for the database objects and documented the processes for maintaining the database for future reference.
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Worked closely with IT project managers, programmers, and testers.
• Knowledge on OBIEE reporting services

Environment: SQL Server 2008R2 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent technologies like SSIS,SSRS, Microsoft Office 2007/2008/ 2010/2012/2014, SDLC SharePoint 2007, PowerPivot.

SQL Server /BI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Created database objects like tables, views, indexes, stored-procedures, triggers and user defined functions.
• Developed Backup and Restore scripts for SQL server 2005
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Built an automated inventory of all the SQL servers using SSIS and SSRS services.
• Created DTS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat files
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services 2008.
• Involved in Performance Tuning on Production, Staging and Test Servers and Involved with maintenance of ACTIVE/PASSIVE Cluster in Production Environments.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedure
• Installing, configuring troubleshooting SSRS and SSAS related problems
• Maintained SQL Server versioning through installs and upgrades of database instances
• Experience in creating ad hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: MS SQL Server 2005/2008, MS Access, Oracle 9i, Windows 2000/2003, Microsoft SQL server Visual Studio 2005/2008, BIDS 2008, ERWIN, XML, UNIX and Crystal reports, Microsoft Office 2007 .

SQL /BI Developer

Responsibilities:

• Actively involved in gathering and analyzing requirements.
• Started working as developer and created advanced stored procedures
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Deployed SSIS packages and Reports to Production Servers.
• Migrated data using ETL Tool in SSIS
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Diagnosed SQL Server database issues, including performance, and data integrity issues
• Installing, configuring troubleshooting SSRS and SSAS related problems
• Maintained SQL Server versioning through installs and upgrades of database instances
• Monitors database environment daily to address and reduce database errors
• Performing DBA functions, installing, configuring and supporting database systems.
• Participated in Databases Architecture and data modeling design.

Environment: MS SQL Server 2005, SSRS, SSIS, C#, DTS/SSIS, Microsoft SQL server Visual Studio 2005, MS Business Intelligence Development Studio 2005.