We provide IT Staff Augmentation Services!

Sr. Bi Developer Resume Profile

2.00/5 (Submit Your Rating)

Denver, CO

SUMMARY

  • Excellent communication and interpersonal skills and has ability to handle multiple tasks, can take initiative to handle responsibilities independently as well as a proactive member of a team.
  • Generate reports using Analysis Services Database.
  • Ability to create cubes using SQL Server Analysis Services.
  • Adept in using MS-Office tools.
  • Possess expertise in supporting and troubleshooting very large databases.
  • Experience in creating reports with Report Builder and Report Server Project Programming Reporting Services.
  • Expert in Generating reports using SQL server reporting services.
  • Expert in installation of SSRS and report server configuration.
  • Extensive knowledge of Relational Database Management Systems
  • Expert in strategically implementing the indexes such as Clustered index, Non-Clustered index, covering index appropriately on data structure to achieve faster data retrieval.
  • Proficient in implementing business crucial logic and implementing them in backend using efficient stored procedures and functions.
  • Expertise in importing and exporting the data between homogenous and heterogeneous systems using various Extraction Transformation and Loading ETL tasks.
  • Experienced in OLTP/OLAP environment with SQL Server 2000/2005/2008.
  • Proficient in using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Excellent T-SQL Programming skills and in depth knowledge in query optimization performance tuning.
  • Proficient in SQL Server developing Stored Procedures, Triggers, Cursors, T-SQL Statements, User Defined Functions and Views.
  • Expertise in Creating Databases based on Functional Requirements and System Design.
  • 7 years of experience in the IT industry, with a wide range of experience in Database Administration, System Analysis, Design, Development, Testing Support of MS SQL Servers in Production, Development environments Replication Environments.
  • Strong analytical and problem solving skills coupled with excellent written and verbal skills.

TECHNICAL SKILLS

Databases: SQL Server 2008/2005/2000/7.0/6.5, MS Access 2003/2007, MySQL

Languages: ASP.Net, ADO.Net. SQL, T-SQL, HTML, VB Scripts, XML, MS- FrontPage

Microsoft Office Tools: Power Point, Word, Excel, Visio

Web Servers: IIS

Operating Systems: Windows 2003/2000 Server, Windows 95/98/2000/XP, Windows NT, UNIX, Linux

Tools and Packages: SQL Management Studio, Enterprise Manager, SQL Reporting services, Query Analyzer, SQL Server Integration Services, SQL Server Analysis, PostgreSQL, Microsoft Performance Point Server 2007, Brio, Crystal Reports, Business Objects, BIDS Helper

Automated Tools: Test Director, Win Runner, Load Runner, QTP

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI Developer

Responsibilities:

  • Participated in developing the design, development and implementation strategy by working on deliverables such as Logical and Physical Architecture and Process Architecture and Created database for the new application.
  • Installation and configuration of SQL Server 2008 Database and Business Intelligence Development Studio.
  • Actively participated in gathering user requirements and system specifications
  • Architect the whole migration process, designed and maintained ETL Design Documents based on Mapping Use Case documents.
  • Designed SSIS packages to load hundreds of source files and make sure that it first loads into staging and then to normalized tables.
  • Designed high performing SSIS packages to include error handling.
  • Designed and developed an automated process in SSIS to load data on a monthly basis using SSIS over a secured FTP SFTP link.
  • Created SSIS packages and stored procedures to load billions of records in batches thus reducing the transaction log and improving performance.
  • Maintained Revision history in the tables that loads data from SSIS packages.
  • Migrated data from flat file to SQL Server 2008, using Cache Transform for lookup, Data Profiling Task to load the data in a temporary SQL Server Table, Merge command in Execute SQL Task to load data to a Warehouse.
  • Involved in writing scripts for archiving files into the particular folder and unzip files by using Script Task.
  • Created monthly, quarterly and ad-hoc reports to facilitate sales data and membership group details to compare data against Vendor Supplied Reports.
  • Created maintenance reports by using various components like Grouping, Sorting, Filters, and Navigation.
  • Created Bookmarks in the reports and having hand's on experience in writing expressions.
  • Developed Linked reports and Sub reports as per user and business specifications.
  • Used Analysis services extensively to build Cubes over dimensional model
  • Used MDX queries to extract data out of cubes
  • Worked on building the cube using cube wizard in analysis services, refreshed the cube on regular basis and giving the permission on the cube to users
  • Created Cubes and performed Cube Partitioning in SSAS.
  • Involved in modifying existing Dimensions and partition of cube.
  • Scheduled report delivery in formats like PDF, excel file, CSV and text files by creating subscriptions on the report server to business users as a IE request or as a mail attachment.
  • Worked on performance tuning the queries that are used for querying VLDB.
  • Created Package configuration for SSIS packages for moving Packages across various environments like Dev, SI, QA, UAT and Prod.

Environment: Visual Studio 2005/2008, SQL Server Management Studio, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Business Intelligence Development Studio, SharePoint Portal Server 2007, MS Office.

Confidential

Database Administrator and BI Developer

Responsibilities:

  • Worked as a Database administrator and BI developer.
  • Worked extensively on creating stored procedures and functions.
  • Migrated data from legacy database to the SQL Server.
  • Created Dynamic Tables and SQL queries.
  • Designed SSIS packages for extracting the data from multiple data source and load into the appropriate tables in the database.
  • Redesigned the SSIS packages for optimizing the time in production environment.
  • Created SSIS package by using various tasks and tested in DEV, QA, and PROD environment.
  • Upload data in database by using SSIS DTS package SAP, Flat Files, HTML files and SQL Server .
  • Expertise in using tasks like Conditional Split, Derived Column, Fuzzy Grouping, Merge etc.
  • Created SSRS reports by using components like grouping, sorting, filters, and Expression Builder.
  • Designed layouts and Created Template in reports for future use.
  • Build the conceptual and Logical model for the Data Mart using Visio.
  • Involved in Gathering the requirements and Designing the Reports using Crystal, WebI and DeskI.
  • Worked with the Crystal Enterprise Administrator for determining the rights and authorizations of report users.
  • Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
  • Involved in Creating LOV's, Business Views, Data Elements, Data Foundations, Data Connections using Business View Manager.
  • Published Reports to CMC Central Management Console and involved in Scheduling and exporting the reports in different Formats.
  • Used VSS for the Version Control for updating any package and Stored Procedures.
  • Involved in developing the design, development and implementation strategy by working on deliverables such as Logical and Physical Architecture and Process Architecture and Created database for the new application.
  • Generated scripts for the current database and do the aggregation for the new system.
  • Deployed all the reports and SSIS packages on to the SharePoint Portal.
  • Created Web page on SharePoint for our team and deployed all files in it.
  • Worked extensively with all the BI tool set in Visual studio 2005.
  • Used MDX queries to extract data out of cubes.
  • Used Analysis services extensively to build Cubes over dimensional model.
  • Designed Stored Procedures for Adjustments calculations.
  • Perform Unit testing for the current system.
  • Created reports by using SSRS 2005. Created sub reports, graphs, matrix control for cross tab reports, linked reports Ad hoc reports using Report Model Projects.
  • Created DFD using Microsoft Visio.
  • Created reports for the use of administration.
  • Migrating SQL Server 2000, MS Access Excel reports to SQL Server 2005.
  • Deploy reports on to the SharePoint Portal.
  • Involved in writing scripts by using Script task in SSIS to update the database.
  • Used VSS for updating the latest version if any changes applicable in the file or package.
  • Used the Model-View-Controller Agile principles for designing the TMS website.

Environment: Visual Studio 2005, SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server 2000 DTS, T-SQL, SQL Server reporting services SSRS , SQL Server Integration Services SSIS , Power Point, Office, SQL Server Analysis Services SSAS , Excel 2003/2007, MS Access, SharePoint Services, Crystal Reports, Visual Studio .Net 2005, MS Performance Point Server 2007 .

Confidential

Database Developer/DBA

Responsibilities:

  • Maintaining records in Excel Spread and exporting data into SQL Server Database using SQL Server Integration Services.
  • DDL Scripts for generating Tables, Views, Functions.
  • Added/Changed Tables, Columns, Triggers and using T-SQL
  • Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
  • Scheduling Jobs, Backups and Restore database
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
  • Performance tuning, query optimization and execution plan of queries for better performance.
  • SSRS installation and report server configuration.
  • Developed reports using SSRS 2005. Used table control, matrix control for cross tab reports.
  • Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
  • Writing and testing stored procedures.

Environment: Visual Studio 2005, SQL Server Management Studio, T-SQL, SQL Server reporting services SSRS , SQL Server Integration Services SSIS , MS Power Point, MS Office, MS Excel.

Confidential

Database Developer/DBA

Responsibilities:

  • Designed and developed Front-end using C .NET and populating data into the Back-end SQL Server Database.
  • DDL Scripts for generating Tables, Views, Functions.
  • Added/Changed Tables, Columns, Triggers and T-SQL code.
  • Using Views, Triggers and Stored procedures for updating the existing and new data.
  • Created cursors and user defined functions, Indexes to speed up the queries.
  • Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
  • Scheduling Jobs, Backups and Restore database.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
  • Used ADO.NET datasets, data readers and data adapters in data access layer.
  • Using ASP.NET with VB and a SQL Server back end, constructed several forms and reports.
  • Designed and Developed all extract transform and load ETL code and staging tables.
  • Designed SSIS packages to pull data from Snapshots of production server to development server.
  • Created a Log Database/ file to capture the SSIS events and used it to Perform Debugging of packages.
  • Used several control flow items and data flow transformations in the SSIS to create ETL packages for data integration.
  • Created Reporting databases and necessary tables required for Reporting.
  • Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
  • Generated reports and designed templates for daily login, agents and shops all around United States.
  • Designed templates to keep track of registered students, courses taken by them and grades received.
  • Wrote and executed Unit test cases and implemented manual white box testing to test individual features and performed module and system testing manual Integration and Black Box testing
  • Used complex SQL queries and joins for data consistency checking.
  • Performed Data integration testing.
  • Performed Database objects validation per the business rules.
  • Tested database, Stored Procedures and found and tracked defects.

Environment: Visual Studio 2005, HTML, VBScripts, C , Visual Source Safe, XML, SQL Server 2005, T-SQL Stored Procedures, MS-Reporting services, SQL Server Integration Services, Test Director, ODBC, Power Point, Office , Excel, Crystal Reports.

Confidential

SQL Developer/DBA

Responsibilities:

  • Actively participated in gathering business requirements and system specifications from users.
  • Database architecture design and modeling.
  • Designed and created new database.
  • Designed DTS package, DTS import/export for transferring data between different databases.
  • Created DTS packages for transforming data from various data sources.
  • Daily backups of transaction logs and scheduling jobs to perform this task.
  • Extensively used T-SQL statements to write complex queries.
  • Extensively used stored procedures, wrote new stored procedures and modified existing ones and tuned them such that they perform well.
  • Made proper use of indexes to enhance the performance of individual queries and enhance the stored procedures.
  • Wrote stored procedures, triggers and custom functions.
  • Proper use of views to prevent unauthorized access.
  • Tuned SQL queries using execution plans for better performance.
  • Set up heterogeneous data source subscription using OLEDB/ODBC.
  • Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers.
  • Generated reports of transactions and services provided using SQL Server Reporting Services.

Environment: Windows 2000 Advanced Server, SQL Server 2000/7.0, Query Analyzer, T-SQL, MS-Reporting Services, MS Office Components, C .NET, SQL profiler, DTS, Crystal Reports.

We'd love your feedback!