SUMMARY:

• Over 8 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server 2012/2008/2005 /2000, SQL Server Integration and Reporting services.
• Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.
• Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.
• Well versed with Tableau 9.0
• Requirements Gathering & Analysis.
• User Acceptance Testing.
• Extensive SQL Development experience in Banking and Human resources industries with a strong understanding of data & analytics.
• Contributed to build business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity.
• Applied technical skills using Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Build and maintain SQL scripts, indexes and complex queries for data analysis and extraction.
• Investigated issues, ensured that the root problem is understood, and developed and implemented effective long - term root cause solutions.
• Experience in creating drill down, drill through and linked reports using SSRS (SQL Server Reporting Services)
• Design and develop SSIS packages, store procedures, tables, views, and functions, implement best practices to maintain optimal performance.
• Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects. Capable of handling responsibilities independently as well as a proactive team member.
• Ability to work with multiple groups on accomplishing common goals under tight deadlines. Good communication skills, self-motivated, quick learner and team player.

TECHNICAL SKILLS:

Databases:: SQL Server 2000/2005/2008 R2, MS Access 2000, MS Excel, Oracle 8

Programming Languages:: T-SQL, PL/SQL, C, C++, HTML, XML, Java

Operating Systems:: Windows 98/2000/2003/ XP/NT/Vista, UNIX

IDE & BI Tools:: SQL Server BI Development Studio (BIDS), MS Visual Studio 2012/2008/2005

ETL Tools:: SSIS, SSRS

Data Visualization tools: Tableau 9.0

Reporting tools:: Crystal Reports 8.0

PROFESSIONAL EXPERIENCE:

Confidential, Chanhassen, MN

Senior BI developer

Responsibilities:

• Maintained the Confidential dashboard for all reports and was responsible for all admin related functions.
• Contributed to build business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity.
• Partnered with developers to automate manual processes, saving time and money while decreasing errors
• Created ad-hoc reports using SQL server 2008 Reporting Services (SSRS) as per the business need.
• Implemented complex business requirement in backend using efficient stored procedures
• Performance tuning of SP’s
• Scheduled and maintained routine jobs, tasks, and alerts.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created SSIS Packages for transformation of data and scheduled them.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
• Executed and tested required queries and reports before publishing in Tableau.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Mentored Junior developers.

Confidential, Minneapolis, MN

Senior SQL Server Developer/SSIS/SSRS Analyst

Responsibilities:

• Creating and enhancing hundreds of SSRS reports to support the reporting needs of various divisions, using stored procedures, views and functions.
• Migrated the SSRS reporting system from Rels title servers to Dataquick servers.
• Creating SSIS packages for scheduled jobs and one-time data loads to support reporting needs.
• Creating ad-hoc queries for data analysis and one-time reports.
• Creating reports and performing data analysis to support the migration from an in-house business system to a new third-party business system.
• Running manual reporting processes to generate reports that require more hand-holding.
• Working with the development team to locate new data items for reports.
• Performance enhancement of slow queries.
• Production support, such as failed data loads that require job rerun, with subscription rerun.
• Running loads and queries to append additional data to business data in a spreadsheet.
• Creating, modifying and maintaining report subscriptions.
• Converted a difficult to maintain Access reporting process into much easier to maintain and understand SSIS packages and SSRS reports.
• Converted Report Builder reports to SSRS reports.
• Making modifications and updates to a Report Builder model. Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Generated parameterized/Drilldown reports using SSRS .

Confidential, Minneapolis, MN

SQL Server Developer/SSIS/SSRS(Consultant)

Responsibilities:

• Gathering requirements from the client, scheduling meetings for detailed analysis .
• Created ad-hoc reports using SQL server 2008 Reporting Services (SSRS) as per the business need.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions.
• Scheduled and maintained routine jobs, tasks, and alerts.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Implemented failure alerts using email in SSIS.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Generated parameterized/Drilldown reports using SSRS .

Confidential, St Paul, MN

SQL Server Developer

Responsibilities:

• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL code
• Created stored procedures, views, tables, functions etc for analysis purpose.
• Mapping of fields from Layout file of the acquired bank to the SSIS package.
• Performed daily tasks including backup and restore to work with latest data for analysis.
• Used Fuzzy lookup, Conditional Split, Derived Column, Audit, Script task for cleansing of data which we receive form acquired banks to convert into Confidential format.
• Analyzing and uploading data into Mainframe and formatting the data using ETL.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Performance tuning of SQL queries so reports don't time out using temp tables,functions stored procedures etc.

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Estimating work effort and documenting the task.
• Developed complex queries for various HR/Payroll modules using T-SQL.
• Developed Demographic files for various clients using T-SQL.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Designed Stored procedures,Cursors,Triggers for various purposes using T-SQL
• Created stored procedure for Import/Export formats using T-SQL.
• Optimized Queries to avoid time out.
• Improved reports in terms of design and to avoid time out.
• Testing of Code on Development server and auditing it in production and Client support.

Confidential

SQL Server Developer

Responsibilities:

• Reconciling data between internal vs. internal system as well as internal vs. external system i.e.
• Custodian/Bank vs. ML Internal system. Data received from the Business analyst from US to UK is first
• Separated into closing balances, Cash Movements, Exec Trades, Open Trades, Stock
• Positions, Stock movements.
• Developed SSIS packages for data cleansing and transformations
• Develop stored procedures, Triggers using T-SQL.
• Created Cursors, UDF, Views using T-SQL.
• Created SSIS packages for data movement and downloading files from FTP Server
• Created Sql jobs for automation.

Confidential

SQL Server Developer, Crystal reports

Responsibilities:

• Involved in Modules requirement study
• Developed the HR module right from scratch
• Developed several Query parameters windows for the ease of search functionality
• Developed common modules for database connection and several common functions.
• Development of Master pages in ASP.NET.
• Developed Security Credentials for users Authentication
• Several reports according to the requirement.
• Database Connection using Disconnected Architecture from ADO.NET
• Created UI Documents and Technical Documents for the project
• Involved in Unit testing.
• Database development of scripts and Stored Procedures using SQL 2000/2005 using T-SQL
• Debugging and tuning (parameterizing) the queries.
• User controls developed according to the need.

Confidential

VB,SQL Server Developer, Crystal reports

Responsibilities:

• Dynamic creation of Databases, tables and related information and transfer of data in respective tables. Automatic Installation of MSDE at clients place during setup. Creating databases, tables at runtime and transfer of data automatically from various backends.Activex Dlls created for common functionalities
• Involved in Designing, developing and testing the software and implementing at client places.
• Creating reports according to the need
• Various classes developed for common functionalities
• Used various kind of validation using .net validation, JavaScript and regular expression.
• Created UI Documents and Technical Documents for the project
• Developed Security Credentials for users Authentication
• Database Connection using Disconnected Architecture from ADO.NET
• Created Complex Queries, Stored procedures, Triggers, Cursors, Views using T-SQL.