SUMMARY

• Over 5 years of experience as a Business Intelligence Developer in SQL Server 2012/2014.
• Excellent T - SQL Developer skills including store procedures, Triggers, Table, User defined functions, views, indexes, SQL joins and performance based query writing.
• Extensive experience in using of SQL server constraints, SQL Server Database design, Database maintenance, developing T- SQL queries, CTE using SQL server to facilitate data manipulation and data consistency.
• Expertise in high level design ofSSISpackage for integrating data from heterogeneous sources (excel, CSV, flat file, Text format data) and data conversion process.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experience in managing alerts, operators and jobs throughSQLServer Agent.
• Experience inNormalization and De-normalization.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2012/2014.
• Strong experience in designing high level ETL architecture for overall data transfer from the OLTP-Online Transaction Processing to OLAP with the help of SSIS.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server using SSIS.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experience in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSISPackages.
• Experienced in handling Slowly Changing Dimensions while loading data into data warehouse.
• Experience in Building cubes using SSAS.
• Experience in Performance Tuning SSISpackages by using Row Transformations, Block and Unblock Transformations.
• Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads.
• Extensive experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS).
• Experience in upgrading and migration of SQL Server 2000 to SQL Server 2012/2014.
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
• Root cause analysis (RCA) - analyzing application and system log files to determine the cause of issue.
• Excellent interpersonal and communication skills with a readiness to take challenges with proven ability.
• Worked with multiple Business Departments and IT teams to capture requirements and to help implement solutions.
• Implemented error handling and troubleshooting using various error tables whenever required.
• Having a good knowledge about the quality related documents and procedures.

TECHNICAL SKILLS

Programming Languages: T-SQL, MySQL, Python, Oracle SQL.

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010, GIT.

GUI: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010, 2012, Tableau, SSRS, Power BI.

Operating Systems: UNIX and Windows

Platforms: Windows 98/2000/2003/ XP/NT/Vista/7/8.1/10, Windows Server 2003/2003 R2/2008/2008 R 2/2012/2014/2016, UNIX

ETL Tools: SQL Server Integration Services(SSIS), DTS, Import/Export Wizard.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SQL Server SSIS\SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Installed and configuredSQLServer 2012\2014 andSQLServer Reporting Services.
• Created and maintained database objects (tables, stored procedures, and views).
• Optimized the performance of queries with modification in T-SQLqueries, normalized tables, established joins, and created indexes.
• Experienced in working with many complexSQLqueries using joins and date functions to generate various reports.
• Involved in generating and maintainingSQLscripts.
• Created complex stored procedures for complex reports developed usingSSRS2012\2014
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snowflake schema.
• Designed and developedSSISPackages to import and export data from MS Excel,SQLServer 2012\2014 and Flat files, XML Files.
• UsedSSISto create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Worked with different Control flow tasks in creatingSSISpackages especially For Loop and For Each Loop containers with ExecuteSQLand Script Tasks.
• Created stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files toSQLserver staging tables.
• Creating tabular models based on the requirement using Visual Studio 2012.
• Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors usingSQLServer Integration Services (SSIS) 2014.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split and derived column and Script tasks.
• Extensive testing on the performance of the stored procedures.
• Built multi fact table cubes using SSAS.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Developed Tableau reports and effectively used data blending feature in tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Designed and developed Power BI dashboards for Risk and Marketing teams to analyze dialer drop out reasons, Conditional declines, Campaign summaries and trial balance comparisons.

Environment: Unix, Sun Solaris OS, SSIS, SSRS, Windows, T-SQL, Tableau, Power BI.

Confidential, Atlanta, GA

SQL Server SSIS\SSRS Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Designed high level ETL architecture for overall data transfer from the source server to the destination server which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata usingSSIS.
• DevelopedSSISPackages to load data into database and flat file using SSMS 2008 R2 and BIDS 2008.
• Responsible for creatingSSISpackage which extract data to single flat file from different data-source.
• Created Log Files to troubleshoot package failure errors.
• Responsible for maintaining and scheduling packages.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Designed ETL architecture for overall data transfer from source server to the enterprise services warehouse.
• CreatedSSISpackages to load customer information from flat file.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata usingSSIS.
• Worked with a combination of multiple Dataflow Transformations to build packages inSSIS.
• Troubleshooting of processes, issues and errors inSSISPackages to improve their performance.
• Worked with MasterSSISpackages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Worked with other team members to document systems and process environments.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• AdministeredSQLServer security,SQLserver automatic e-mail notification andSQLServer backup strategy and automation.
• Responsible for elevating and automating successful code to production environment.
• WroteSQLqueries and stored procedures to generate data for reports.
• Deployed and configured the reports in the Report Server.
• Created Parameterized reports, Cross-Tab reports, Drill Down reports by using SSRS.
• Created and Implemented triggers in T-SQLto facilitate consistent data integrity of the database.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Designed and developed Power BI dashboards for Data visualization.
• Used Tableau to visually analyze data and create concise and actionable dashboards publishing on SharePoint and NAS drives.

Environment: SSRS, Windows, T-SQL, SSIS, Power BI, Tableau, SharePoint.

Confidential

SQL Developer

Responsibilities:

• Developed AdvancePL/SQL packages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingSQL Navigator. Generated server-sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive data base processes.
• Developing the code as per the solution given.
• Provide solution to the problems.
• Following the SDLC stages for development and fixing the bugs if found any in the development stage itself.
• Handled batch process like COM, MCAP, CAP and LTP for usage processing.
• Handled Order management system and implementing troubleshooting techniques during exceptions and TUXEDO server management.
• Analyze the errors in error tables, rectifying and reporting to leads.
• Analyze issues raised in Production.
• Giving Automation Walk-through to Client.
• Daily client interactions regarding team status and escalations.
• Blended data from different information sources by utilizing connecting component as a part of Tableau Desktop.

Environment: Oracle SQL, PL/SQL, basics Pro *C, basics of UNIX and java, Excel, Tableau.