We provide IT Staff Augmentation Services!

Ms Sql Server Bi Developer Resume

4.00/5 (Submit Your Rating)

San Ramon, CA

Summary:

  • Over 7 Years of IT Experience in Business Intelligence Technologies and Database with Extensive.
  • Knowledge in ETL Process and Reporting Services using SQL server 2008/2005, SSIS and SSRS.
  • Proficient in developing ER diagrams, logical and physical data modeling and Dimensional Data Models using Erwin tool and Visio.
  • Experience in writing complex TSQL Queries (DDL and DML) involving various tables to create and maintain database objects like Stored Procedures, Triggers, user defined functions, Views, Indexes.
  • Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle).
  • Expertise in migrating data from MS SQL Server 2000 to 2008 R2 and Converting DTS packages to SSIS packages.
  • Extensive knowledge in designing on-demand and scheduled reports for business analysis or management decision reports using cascading parameters, Parameterized reports, report models for Ad-hoc reports using SSRS.
  • Expert in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SSRS based on Relational and OLAP databases.
  • Constructed Cubes based on data volumes mostly adhering to Star Schema. Has strong knowledge of Data Warehousing, Star Schema, Snow-Flake Schema, Fact and Dimension Tables using SSAS through the use of T-SQL and multi-dimensional expression (MDX) queries.
  • Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005, in creating groups and measures, KPIs, and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
  • Experience in MS SQL Server installation, configuration, performance tuning, error handling, query optimization, backup/recovery.
  • Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production.
  • Ability to quickly adapt and learn, works well in team environment as well as independently with minimum supervision.
  • Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

Education:
Bachelors in Computer Science.

Skill Set: 
MS SQL Server 2000/2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Analysis Services 2005/2008, MS SQL Server Integration Services 2008/2005, Business Intelligence Development Studio (BIDS), MS Access,C, HTML, MS Visio 2003, Windows server 2000/2003/2005/2008, Crystal Reports 10/8.5/8.0, Visual Studio 2005/2008, T-SQL, DTS, ERWIN4.0/4.1/4.2/7.2, MS Office, MS Frontpage.

Projects Summary:

Confidential, San Ramon, CA Aug 2010 - Present 
MS SQL Server BI Developer / SSRS/SSIS
Confidential, incorporated in California in 1905, is one of the largest combination natural gas and electric utilities in the United States. Based in San Francisco, the company is a subsidiary of PG&E Corporation. A web based application is developed for customers to conveniently submit, manage and track the details of maintenance requests. It also helps support personnel to submit applications, view status, print reports and download documents securely over the internet on a 24/7 basis. Involved in generating SQL Server Reports such as parameterized and drill down reports using global variables and deploying reports directly on client’s workstation.
Responsibilities:

  • Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS on Windows Server 2008.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Worked with database objects like Tables, views and indexes.
  • Created ad-hoc reports using SQL server 2008 Reporting Services (SSRS).
  • Uploaded SQL Server 2008 Reporting Services (SSRS) RDL files to SQL Server 2008.
  • Migrated all DTS packages to SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Services like Execute DTS 2000 package task.
  • Played a major role in production support of SSIS jobs.
  • Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SSIS data flow tasks like Data conversion, Conditional Split, Derived Column, Multicasting
  • Provided Full Reporting Life Cycle support using MS SQL Server Reporting Service 2008.
  • Created parameterized, drill down and aggregation type of reports in SSRS 2008.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Gauged the effectiveness and efficiency of existing reporting systems. Developed and implemented strategies for improving and further leveraging these reports in order to transfer/convert existing Reports to SQL Server Reporting Service.
  • Performed Report Testing and Verification as per Internal Reporting system requirements.
  • Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
  • Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
  • Applied Security to Web Server and Database Server that affects Report server installation. Managed role-based security to reports and reporting resources.
  • Responsible for back up and Restoration of SQL Reporting Service.

Environment:
Windows XP, MS SQL Server 2008, MS SQL SSRS 2008, MS SQL SSIS 2008, BIDS, Excel, Acrobat Reader.

Confidential, Piscataway, NJ Aug2009 to Aug 2010 
MS SQL Server BI Developer/SSIS/SSRS/SSAS
Confidential. is New Jersey’s largest, provider-sponsored Managed Care Organization that offers self-funded PPO, HMO network, point of service (POS) network, and open access health plans; third party administration (TPA) services, provider network access, care management services, and a workers’ compensation product. 
Responsibilities:

  • Worked on the complete life cycle of the project from design to implementation.
  • Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
  • Data Analysis and Designed the logical and physical model architecture for database.
  • Interacted directly with the various SME for gathering the business requirements.
  • Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business.
  • Convert data from Legacy system to SQL Database.
  • Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Data Migration from Flat files, CSV, MS-Access, Excel and OLE DB to SQL Database.
  • Using SSIS, loaded XML data to the Database tables.
  • Generated XML files from Database tables.
  • Used Informatica to pull data from Sales Audit OLTP and load it in SQL Data Warehouses for reporting purposes.
  • Created /modified and maintained the ETL packages- Extraction, Transformation and Loading of data from various Database tables i.e., from Source Tables to Mapping the Target table in respective databases.
  • Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, Sybase, EXCEL sheets, CSV format and used complex data conversion to target.
  • Scheduling and monitoring the regular jobs and ETL packages.
  • Used ADO.net connection, .net and C# code in SSIS Script task.
  • Involved in Query optimization, performance tuning and index creation.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Used SSRS to create reports, customized Reports, on-demand reports.
  • Database Backup and restoring the database.
  • Worked in Database Security, Replication, Log shipping activities.
  • Validating and Testing of the Database data, SQL codes and application (White box and Black box).
  • Prepared Documentation of the system.

Environment:MS SQL Server 2008/2012 (Denali), SSIS 2008, SSRS 2008, SSAS 2008, Unix Shell Scripting, Java, ORACLE 11G, DB2, TOAD, TFS 2010, MS Visio, MS Access, T-SQL, Dynamic SQL, MDX, C#, VB Script, .Net 4.0, XML, SharePoint.
CONFIDENTIAL, Mettawa, IL Jan 2008 to Aug 2009 
MS SQL Server BI Developer/SSIS/SSRS/SSAS
CONFIDENTIAL Bank USA, National Association, with total assets of $194 billion, serves 3.1 million customers through its personal financial services, commercial banking, private banking, asset management, and global banking and markets segments. It operates more than 300 bank branches throughout the United States. Project involved creating packages to load data and consolidate data for users. The consolidated warehouse stores data from different services and used for generating reports for the company’s financial use.
Responsibilities:

  • Involved in design and development of technical specifications of the project and developed the prototypes.
  • Developed T-SQL queries for table creation, wrote stored procedures, views, triggers, and tested tables in company’s BI star schema structure.
  • Designed, developed, and debugged stored procedures in MS SQL Server 2005 to load the data into consolidated data warehouse.
  • Created SSIS packages to load insurance data received from different insurance agents and other locations into consolidated data warehouseusing Derived column, Lookups, Fuzzy Lookups, Conditional split,Execute SQL Task, Data Flow Task, and Execute Package Task.
  • Used MDX queries for pre calculated measures and created report model on SSAS cubes as well as changing default configuration on existing cubes.
  • Created report Model using T-SQL queries on SSAS Cubes as well as changing default configuration on existing Cubes.
  • Involved in setting up hierarchies and defined scope of analysis for providing drill down/ drill through options in the reporting environment.
  • Developed reports out of the consolidated data warehouse for the business users using MS SQL Server Business Intelligence Development Studio (BIDS) 2005 (SSRS).
  • Involved in migrating data from Windows Server 2005 to Windows Server 2008 environment.
  • Implemented security for the reports, user tabs, report models and folders in the report manager at the application, database and the report manager level.
  • Tested, debugged and developed the technical documentation for the company reporting applications.

Environment:
MS SQL Server 2005/2008, T-SQL, MS SQL Server Reporting Services, SSRS Report Builder, ASP.Net 2.0, Visual Studio 2005, Window Server 2005/2008, MS SQL Server Integration Services, SSAS, XML.

Confidential, San Francisco, CA June 2006 to Jan 2008 
MS SQL Server ETL Developer
Confidential is the leader in secure, cloud-based eDiscovery software for corporations and law firms to simplify electronic discovery (e-Discovery) in response to litigation, regulatory inquiries and internal investigations.This project is devised to have a single system of record for HR data and a centralized solution for reporting key HR metrics to e-Staff and eventually to all managers across the enterprise. The business group requirements are met with the use of Enterprise Data warehouse. The process loads the employee details, hiring details, job details etc to produce a set of reports with SSRS that includes headcount analysis reports, termination reports, and AWF consultants’ reports.
Responsibilities:

  • Involved in Source data analysis and extensive involvement in ETL development.
  • Mapped the logical and physical models, identified different subject areas and also identified the tables that fall in those subject areas.
  • Developed scripts for stage and history tables.
  • Developed packages and involved in implementing a security model in SSIS to load the tables in DM.
  • Written queries to create the views for the dimensions to have initial load in DM.
  • Developed the job batch control packages for integrating the developed interfaces.
  • Created Master package to load HR DM jobs which calls other packages and procedures.
  • Resolving issues which are related to the development phase and testing phase.
  • Responsible for ETL code migration across Dev, QA and Prod environments.

Environment:
MS SQL Server 2005 Enterprise Edition, MS SSIS 2005, DTS, T-SQL, Windows Server 2003,Erwin 4.0., Microsoft .NET framework 2.0.

Confidential,San Jose, CA Nov 2005 to June 2006 
MS SQL Server ETL Developer
Confidential is an award-winning mechanical contractor based in the heart of California\'s Silicon Valley, specializing in design, fabrication and installation of HVAC systems. The project involved migrating to the MSSQL DB from existing excel based system for the raw materials of duct fabrication, the project cost, employer’s details.
Responsibilities:

  • Worked as a developer role on MS SQL Server 2000, MS Excel databases (using DTS, T-SQL, scripts, stored procedures and views).
  • Developed Logical and physical database (using normalization, dimension Modeling and Enterprise manager).
  • Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
  • Worked on MS SQL Server tasks such as data loading, BCP, DTS, Instances, Linked Servers and Indexes.
  • Automated many operations by scheduling multiple DTS packages using jobs.
  • Compressed data files by removing empty database pages and updating index statistics.
  • Developed and edited many complex reports with Crystal Reports 10.
  • Designed and implemented user login and security.
  • Optimized long running Stored Procedures and Queries for effective data retrieval.
  • Involved in project planning, scheduling for database module with project managers.

Environment:
MS SQL Server 2000 Enterprise Edition, MS Access, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, Crystal Reports 10.

We'd love your feedback!