We provide IT Staff Augmentation Services!

Bi Analyst/ Sql Server Developer Resume

Boston, MA

SUMMARY

  • 8+ years of experience in working on BI solutions, Database Design, Analysis, Development, and Support of Microsoft SQL Server /2012/2008R 2/2008/2005/2000 .
  • Hands on experience with performing various SSIS (SQL Server Integration Services) data transformation tasks like Derived Column, Data conversion, Merge, Bulk Insert, Data Mining, Look - ups, Fuzzy Look-ups, OLEDB Command, Conditional Splits and Event Handlers, Error HANDLING etc.
  • Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters etc.
  • Experience in creating Analysis services databases, data sources, data source views, named calculations, named queries, dimensions, cubes, calculations.
  • Experience in Excel data analysis to provide data cleansing support and validation of data for presentations, Metrics and reports of information.
  • Good experience in creating objects such as Databases, Tables, Stored Procedures, Triggers, Cursors, Constraints, Indexes, Full-text Indexes, Views, Indexed Views, T-SQL Merge Command in Microsoft SQL Server 2008R 2/2008/2005/2000
  • Optimized the database by creating Clustered, Non-clustered and Full-Text Indexes.
  • Expertise in Installation, Configuration, Upgrading packages
  • Strong knowledge and experience of linked servers, Bulk Insert, Open rowset functions
  • Experience working with Microsoft Team Foundation Server
  • Involved in package migration from DTS packages to SSIS packages, running the Microsoft upgrade advisor tool
  • Strong knowledge of star schema, snow flake schema in dimensional modeling and their usage in different data modeling design
  • Strong knowledge and experience working with Slowly Changing Dimensions, type 0, type 1, type 2 and inferred dimensions.
  • Dealt with performance of packages at different levels of package execution
  • Strong knowledge and experience in error handling of SSIS packages using transactions, check points(package restart ability features), break points and error logging procedures
  • Experience in creating tabular, list, matrix reports(templates of Tablix data region) and writing queries to perform drill down operations in SSRS
  • Experience with parameterized reports and custom reporting using SSRS
  • Created SSRS projects and reports in BIDS, sort, drill down data and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions
  • Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.
  • Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Experience in conversion of packages from legacy systems (DTSàSSIS) and migrating, deploying the packages across Dev./UAT/Prod environments.
  • Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
  • Excellent analytical/Communication Skills, Team Play and very much result Oriented.

TECHNICAL SKILLS

Web Technologies: HTML, JavaScript, CSS, XML, XSLT

IDE's & Tools: Visual Studio 05/08/10, MS Visio, Erwin

Database: MS SQL Server 2005/2008/2008 (R2), Access 2003/2007/2010

SQL Server Tools: SSMS, BIDS, SQL Server Profiler, Performance Monitor

BI(ETL/Reporting): SSIS/SSRS

Programming Languages: C#, VB.NET, T-SQL

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

BI Analyst/ SQL Server Developer

Responsibilities:

  • Created Stored Procedures, Triggers, Views and Functions for the Application. Extensive testing on the Performance of the Stored Procedures.
  • Developed complex T-SQL code for the application conversions.
  • Transferring the data from SQL server 2000 to SQL Server 2005 using SSIS.
  • Wrote the Letter Extract Functions and Stored Procedures in SQL Server 2005 the result should be is in Xml.
  • Wrote the stored procedure to call the Functions.
  • Migrated data from legacy Databases in Sql 7.0,2000 to Sql server 2005.
  • Migrated data from SQL Server 2005 to Xml.
  • Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
  • Created backup/restore and disaster recovery plans for production servers.
  • Developed and implemented change control procedures to manage system modifications/upgrades.
  • Created billing reports using SSRS.
  • Backing and Restoring of Databases on Scheduled basis.
  • Worked with DBA to set-up the security roles for developers and end-users.
  • Extensive testing on the Performance of the Stored Procedures.
  • me has set up Replication Environment for Development and Production Servers.
  • Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Created datasets using stored procedures and reports using multi value parameters.
  • Created sub reports, bar charts and matrix reports.
  • Developing a Report as per user requirement using MS Reporting Services
  • Published reports as PDF formats.

Environment: MS SQL Server 2005/2000, Windows 2003 Server, Transact-SQL, DTS, SSIS, SSRS, ERWIN, Business Intelligence Development Studio.

Confidential, Phoenix, AZ

SQL Server Developer

Responsibilities:

  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Developed Stored Procedures, Functions and Database Triggers.
  • Developed reports using SQL Server Reporting Services (SSRS)
  • Created Stored Procedures, Triggers, Views and Functions for the Application. Extensive testing on the Performance of the Stored Procedures.
  • Imported various Sources, Targets, and Transformations using Transact-SQL Server
  • Developed complex T-SQL code for the application conversions.
  • Wrote and integrated Stored Procedures to generate the Reports.
  • Created, updated and maintained ETL technical documentation.
  • Created Adhoc reports upon request using SSRS.
  • Used relational sources and flat files to populate the data mart.
  • Migrate the data from Oracle database to SQL server 2005 database using SSIS.
  • Transferring the data from SQL server 2000 to SQL Server 2005 using SSIS.
  • Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers
  • Perform data transfer and database transfer for server relocation, using DTS.
  • Created backup/restore and disaster recovery plans for production servers.
  • Developed and implemented change control procedures to manage system Modifications/upgrades.
  • Extensive testing on the Performance of the Stored Procedures.

Environment: MS SQL Server 2000, SQL Server 2005, Enterprise Manager, T-SQL, DTS, Windows2003, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

  • Interfaced with Business users for better understanding the reporting requirements.
  • Interfaced with the client as part of the Requirements engineering team to finalize the project scope.
  • Involved in Database design including optimizing the database schema, creating database indexes and coding database procedures/queries.
  • Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages
  • Implemented SSIS for data transformation logic process.
  • Designing and building data load procedures, using MS SQL Server SSIS
  • Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse

Environment: MS SQL Server 2000/2005, Windows 2000/2003, Sybase, Excel, TSQL, Microsoft Visual Studio 2005,SQL Reporting Services, SQL integration services.

Confidential, Atlanta, GA

BI Trainer and Business Development Manager

Responsibilities:

  • Generated reports using SSRS that could be used to send information to diverse group of users.
  • Developed ad-hoc reports using Report Builder.
  • Developed Report Model so that the end users can create their own reports using Report Builder.
  • Developed various kinds of interactive reports like Drill Down reports, Aggregate reports, reports containing parameters and groups.
  • Developed reports with Cascading Parameters, Sub reports.
  • Developed Charts and Graphs reports.
  • Developed reports using SSRS and published as PDF formats. UsedReporting Services (SSRS)to schedule reports to be generated on predetermined time.
  • Tuning the database servers, when the user reports that a particular region is running slow.
  • Created and monitored the jobs to perform tasks such as database cleaning, backups, data loading.
  • Excelled in vendor management and enrolled Prosoft / SSG as prime vendor for several Major Prime vendors like CDI, Virtual Tech Gurus, Insight Professionals, HCL, Rose IT, Techno Source, K Force, Collective Group, GDH, TEK Systems, TenTek, Matrix, cognizant, Collabra, and several other vendors.
  • Also revived the direct client relationships with Georgia State Government, Macy’s and Home Depot and continue to get requirements from these direct clients.

Confidential, Deerfield Beach FL

SQL Developer

Responsibilities:

  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
  • Defining/creating and handling Data Sources, shared data sources and Parameterized Reports in SSRS 2005
  • Implemented SSIS packages for the exchange of data between different data sources
  • Defined and processed the Fact table & Dimensions using SSIS
  • Successfully migrated data from multiple environments into SQL Server 2005 using BCP, Bulk Insert and SSIS Packages
  • Used ETL tool SSIS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping
  • Involved in extracting data from multiple data sources, perform multiple complex transformations and land data into SQL Server Tables
  • Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters
  • Worked on Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005
  • Created multiple reports with drop down menu option having complex groupings within the report
  • Troubleshooting performance issues and fine-tuning (Performance Tuning) queries and stored procedures
  • Assist the Development staff with the testing and implementation of the application
  • Query Optimization with SQL Profiler for better performance.
  • Designed and implemented stored procedures and triggers for automating tasks.

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, SQL Profiler

Confidential, Atlanta GA

SQL Server Developer

Responsibilities:

  • Involved in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
  • Involved in Database Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS(SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors and Triggers.
  • Involved in SQL Server Integration Services (SSIS).Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
  • Involved in troubleshooting of existing SSIS Packages.
  • Implemented SSIS for data transformation logic process.
  • Designing and building data load procedures, using MS SQL Server SSIS.
  • Involved in SQL Server Reporting Services (SSRS).
  • Involved in converting crystal reports to SSRS reports.

Environment: MS SQL Server 2005, Windows 2003,IIS, .NET, Enterprise Manager, SQL Query Analyzer, ASP, Visual Source Safe, SSIS, MS SQL Server Integration Services, SQL Server Reporting Services

Hire Now