We provide IT Staff Augmentation Services!

Business Intelligence Technical Lead Developer Resume

Milwaukee, WI

SUMMARY

  • 7+ years of IT working experience in MS SQL Server 2008/2012 as ETL/SSRS/SQL Developer.
  • Highly proficient in teh writing T - SQL queries for developing complex Stored Procedures, Triggers, and Functions.
  • Highly proficient in creating Tables, Views, Indexes and other DDL/DML statement writings using T-SQL.
  • Highly proficient in database, data mart and data warehouse implementation.
  • Highly proficient in building various SSIS packages to complete different Extraction, Transformation, and Loading (ETL) tasks.
  • Highly proficient in designing SSIS packages to Extract data from various data sources: EXCEL, ACCESS, Flat File and other databases.
  • Proficient in complete ETL cycle including data analysis, database design, data mapping, data conversion and data load.
  • Proficient in designing reports using SSRS and Report Builder based on data warehouse which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.
  • Proficient in SQL query performance tuning and optimization.
  • Experience in working wif business analysts, data architects and application developers.
  • Experience in performance tuning and debugging of SSIS packages also schedule jobs for SSIS packages to run on specific routine.
  • Hands on experience in BI integration of MS SharePoint.
  • Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades.
  • Excellent verbal and written communication skills combined wif interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

Databases Technologies/Tools \Utilities/Applications \: MS SQL Server 2008/2012, MS Access, \MS Visual Studio 2008/2010, Report \ SQL Server Integration Services (SSIS), \Builder 2.0/3.0, MS PowerPivot, MS \ SQL Server Reporting Services (SSRS), \SharePoint, MS Office Suite, MS Visio\:

Programming Languages \Operating Systems \: T-SQL, C#.NET, HTML, Java Script, \Windows XP/7/8/2008R2/2012\CSS\:

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Business Intelligence Technical Lead Developer

Responsibilities:

  • Designing and developing new database structures and entities to support different analysis and reporting requirements.
  • Creating and managing tables, views, indexes, constraints, triggers and stored procedures.
  • Designing and developing SSIS packages to perform ETL operations from teh current client systems, FileMaker Pro and Access, to SQL database.
  • Developing reports in Report Builder 3.0 and SQL Server Reporting Services based on teh client requirements.
  • Working wif client for requirements validation, User Acceptance Testing and deployment
  • Working across multiple departments wifin teh Information Management Services Division.

Environment: SQL Server 2008R2/2012, SQL Server Management Studio, Visual Studio 2008/2010/2013, Team Foundation Server, Share-Point, SQL Server Integration Services, SQL Server Reporting Services and Report Builder 3.0

Confidential, Milwaukee, WI

MS SQL Developer

Responsibilities:

  • Design, implement and maintain database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, defaults and complex SQL statements.
  • Involved in designing and developing data warehouse and data mart to support different analysis and reporting requirements.
  • Design, create and optimize stored procedures to support application functionalities.
  • Design, create and optimize complex SQL statements to support data extraction tasks in SSIS packages.
  • Develop SQL scripts for performance tuning and job scheduling.
  • Worked wif business team to discuss user stories and turn them into technical requirements.
  • Create entity relationship diagram to support database design and re-design using MS Visio.

Environment: SQL Server 2008R2, T-SQL, Visual Studio 2010/2015, SQL Profiler, SQL Server Integration services, Team Foundation Server, MS Visio, Share-Point

Confidential, Bethlehem, PA

MS SQL Server Developer/ SSRS /SSIS Developer

Responsibilities:

  • Interacted wif users to gather business requirements.
  • Involved in creation of database objects like schemas, tables, clustered and non-clustered indexes, views, functions, triggers and stored procedures.
  • Created SQL scripts for tuning and scheduling.
  • Implemented teh automated processes for teh activities such as database backup processes.
  • Designed SSIS packages for extracting teh data from different data sources: ORACLE, EXCEL, ACCESS, Flat Files and load them into teh appropriate tables in teh database and data warehouse to complete various ETL tasks.
  • Worked wif development team to optimize application specific database operations and implement security restrictions.
  • Designed, Developed and Deployed reports using SSRS.
  • Developed single value and multi valued parameterized reports for business users using SSRS.
  • Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using SSRS.
  • Used Report Builder to doAd-hoc Reporting.
  • Responded to and resolve database access and performance issues.

Environment: SQL Server 2008R2, T-SQL, Windows 2008R2, Visual Studio 2008, Oracle, Report Builder 2.0, SQL Profiler, SQL Server Integration services, SQL Server Reporting services, Team Foundation Server, Visio, Share-Point

Confidential, PA

MS SQL BI Developer

Responsibilities:

  • Implemented ETL using Bulk Insert, createdSSIS packagesto extract data from OLTP to OLAP systems and Scheduled Jobs to run packages and stored procedures.
  • Designed and developed different kinds of SSIS packages to extract useful information from various data sources: EXCEL, ACCESS, FLAT FILES and other database.
  • Transferred data from variousOLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012.
  • ImplementedEventHandlersand Error Handling inSSISpackages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting teh business standards using various transformations in dataflow such as Fuzzy /Exact Lookups, Data Conversion, Conditional Split and Slowly Changing Dimension etc.in SSIS.
  • Designed and developedmatrix, chart and tabular reportswifdrill down,drill throughand drop downmenu inSSRS.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan wif SSRS and PowerPivot.
  • Performed maintenance duties likeperformance tuningand optimization of queries, functions and stored procedures.
  • Optimized teh database by creating various clustered, non-clustered indexes and indexed views.

Environment: SQL Server 2008/2012, T-SQL, SQL Profiler,SSIS, SSRS, XML, Visual Studio 2008/2010,PowerPivot 2010, MS SharePoint 2010

Confidential, Wayne, NJ

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

  • Developed SSIS packages to Extract Transform Load (ETL) from various OLTP databases
  • Designed index, statistics and optimized queries by using execution plan for performance tuning of teh database.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Based on teh required reports, identified various data sources and established teh connections using SSIS and constructed data source view.
  • Created parameterized reports for teh channel partners and clients, formatted teh report layout for teh requirement of teh end users in SSRS.
  • Createdreports, Cross-Tab reports,Drill Down/ Drill Through reports& Summary reports by UsingSSRS.
  • Deployment of teh developed reports on to teh server for teh end users.
  • Implemented Ad-hoc Reporting using Report Builder
  • Generated Daily, Weekly and Monthly reports for teh analysis of managers and end users.

Environment: Windows Server 2008, MS SQL Profiler, MS SQL Server 2008R2, MS Visual Studio 2010, T-SQL, SSIS, SSRS, Report Builder 3.0

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

  • Involved in logical and physical development of teh database using Erwin data modeling tool and MS Visio.
  • Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL queries for applications.
  • Managed index, statistics and optimizing queries by using execution plan for tuning teh database.
  • Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Created multiple SSIS packages for transferring teh data from different formatted source files loading into SQL Server database.
  • Implemented data transformation and standardized tasks in BIDS to meet teh data processing requirements.
  • Designed and implemented stylish report layouts.
  • Generated multiple reports using SSRS.
  • Developed multiple Drill-down and Drill-through reports in SSRS.
  • Generated Reports using Global Variables, Expressions and Functions for teh reports.
  • Identified and worked wif Parameters for parameterized reports in SSRS.
  • Responsible for scheduling teh subscription reports wif teh subscription report wizard.
  • Looked at teh reports and fixed bugs in stored procedures.
  • Monitored Scheduled jobs and alerts.

Environment: MSSQLServer 2008, T-SQL, BIDS, SSIS, SSRS, Visual Studio 2008, ERwin, MS Visio

Confidential

.Net Developer

Responsibilities:

  • Involved in teh project initiation and requirements gathering phase during teh meetings wif client.
  • Designed and Developed Database for teh new Web application in SQL Server 2008.
  • Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL SERVER data sources.
  • Extensively worked wif designing and developing reports using SQL Server Reporting Services (SSRS)
  • Stored Procedures were extensively used for database operations like Select, Insert, Update and delete.
  • Master pages were used to provide consistent design all over teh application.
  • Cascading Style Sheets (CSS) were extensively used all over teh application to provide rich user interface.
  • Extensively used Dataset, Grid View controls to display and manipulate data
  • Customized teh sites by using AJAX and CSS
  • Writing effective queries, stored procedures and views.
  • Created classes, interfaces, properties, methods, user controls in C# using ASP.NET.
  • Implemented user authentication by forms based.

Environment: MS Visual Studio 2008, C#, ASP.NET, ADO.Net, HTML, CSS, MS SQL Server 2005

Hire Now