We provide IT Staff Augmentation Services!

Sr Sql Bi Developer Resume

4.00/5 (Submit Your Rating)

FL

SUMMARY:

Over 7 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment. Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
  • In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
  • Experience in creating dashboards, scorecards and building reports using performance point server 2007.
  • Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
  • SQL Server 2000/2005/2008 RDBMS database development including T-SQL programming.
  • SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • ETL implementation using SQL Server Integration Services (SSIS).
  • Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
  • Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
  • Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Involved in DBA activities such as backups, restores, replication etc.
  • Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
  • Excellent communication skills, analytical skills, understand business requirements in various domains.
  • Knowledge about coldfusion.
  • Hands on experience on internet information services (IIS)
CERTIFICATIONS

  • Microsoft Certified Technology Specialist in SQL Server.
  • Brain Bench Certified in SQL Server.
TECHNICAL SKILLS

Hardware: HP/Compaq ML 380 Servers, Dell Power edge series
Database: SQL Server 2000, 2005,2008, Oracle 10i
Operating Systems: HP UNIX, Windows XP/2000/2003.
Programming Languages: SQL, PL/SQL, C,java
BI Suite: SSAS, ProClarity, SSRS, MOSS, PPS,Hyperion
ETL TOOLS: DTS, SSIS, Informatica 7.1.3/6.2
Database Tools: DBArtisan, SQL Litespeed.

SCM Tools: Visual Source Safe, Star Team.

Professional Experience:

Confidential, FL Dec 11-Till date
Sr SQL BI Developer

Description: The Supply Chain Transportation operations team currently utilize ad-hoc tools running on local machines for purposes of report generation across the various Office Depot Transportation Systems. The Transportation Reports Automation project will enable utilization of the Office Depot Enterprise Data warehouse (i.e. Teradata) and Business Intelligence architecture to achieve flexible and standardized reporting as a sustainable model. In this Project an existing SQL Server 2000 Cube will be replaced by SQL Server 2008 Cube.

Responsibilities:

  • Installation and configuration of SQL server 2008.
  • Analyzing the business requirements and building logical and physical data models.
  • Designing several ETL process to load data from different sources.
  • Extensively used Teradata SQL Assist in constructing User Functions, Views, Indexes.
  • Extensively used stored procedures and SQL joins in construction of dimension Tables using Teradata SQL Assist.
  • Created SSIS Packages to make use of Slowly changing Dimensions to load the dimension views,
  • Interacted with the Project Managers and the Field Managers who would be using the application the most.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
  • Involved in Analyzing, building and testing of OLAP Cube. Extensively involved in the SSAS storage and partitions, and Aggregations.
  • Created Calculated Measures using MDX Querying. Assigned different security roles to the cube.
  • Created several SSIS Packages to Process the cube with scheduling.
  • Worked with different methods of logging in SSIS.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Involved in Extensive scripting using C#.net.
  • Building UAT and Test environments using Production back ups.
  • Created a Cognos package to build repots using the developed Cube.
  • Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise.

Environment: SQL Server 2008 Enterprise Edition, SSIS, MDX, OLAP, OLTP, DB2, C#.Net, SSAS, Teradata SQL Assist, Cognos, Windows Server 2003.

Confidential,Richmond, VA Jul 10 – Nov 11
Sr SQL BI Developer

Health Management Corporation, Inc. helps employers improve and maintain the overall health and wellness of their employees by offering a comprehensive suite of integrated health care solutions including lifestyle and disease management programs, health coaching and an extensive library of personalized health education tools.

Responsibilities:

  • Installation and configuration of SQL Server BI Tools.
  • Analyzing the FTA’s and the business requirements and building logical and physical data models.
  • Creating three step ETL process to get the files from the server and load the data into database.
  • Designing several ETL processes to Load data from Text or Excel Files
  • Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Designing of SSIS Packages to get data files fromFTPandSFTPServer and decrypting thePGPfiles,batch processingof incoming data and purging of old files
  • Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created Packages in SSIS with error handling.
  • Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
  • Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
  • Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
  • Involved in creating Dimensions, KPI, Measures and calculations in SSAS 2008.
  • Worked with different methods of Logging in SSIS.
  • Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
  • Generation of reports from the cubes by connecting to Analysis server from SSRS.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Created complex Stored Procedures to validate and process the incoming data.
  • Used C# to merge multiple XML reports, convertXMLto HTML format usingXSLTfiles and sending Validation Report emails.
  • WrittenPower shell scriptsto purge files
  • Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
  • Scheduling execution of ETL Packages using SQL Server Agent.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, MDX, ProClarity, OLAP, OLTP, DB2, ASP.Net 3.0, Ado.Net 3.0, C#.Net, SSAS, T-SQL, SSRS, Windows Server 2003

Confidential,Columbia, SC Jan 10 - May 10
Sr SQL Developer (SSRS/SSAS )

Description: The project is about building a Web Application for the Department of Child Support Enforcement. This project will help in replacing the old legacy system (DOS) to a more user friendly environment for efficient data entry and Reporting Purpose.

Responsibilities:

  • Installation and configuration of SQL Server 2008.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.
  • Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
  • Involved in Migration of SSRS 2005 to SSRS 2008.
  • Interact with the Business Admin and gather the requirements and analyzed.
  • Interacted with the Project Managers and the Field Managers who would be using the application the most
  • Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
  • Experience in Programming AMO OLAP advanced objects like KPI’s and Perspectives.
  • Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
  • Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
  • Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
  • Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i,Hyperion 11.1,Performance Point Server 2007.

Confidential,Phoenix, AZ Jun 09 - Dec 09
MS SQL Server Developer

Description: Blue Cross Blue Shield of Arizona is a local, independent and not-for-profit health insurance company headquartered in Phoenix. Founded in 1939, the company has more than 1,500 dedicated employees throughout its Phoenix, Tucson, Tempe and Flagstaff offices. Providing health insurance products, services and networks to more than 1 million Arizonans, Blue Cross Blue Shield of Arizona offers various health plans for individuals, families, and small and large businesses. Blue Cross Blue Shield of Arizona also offers Medicare supplement plans to individuals over age 65.

Responsibilities:

  • Involved in Migration of SQL Server 2000 to SQL Server 2005.
  • Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services
  • Analyzed the project environment and sub systems of the project, and prepared a high level documentation for application designing.
  • Interact with the clients and gather the requirements and analyzed.
  • Responsible for gathering business requirements, developing and reviewing of design documents
  • Did trouble shooting of Client connections, viewing error log and applications.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Transferred data (ETL) to Data ware house Environment using SSIS.
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases
  • To analyze long running queries and tune the same to optimize application and system performance.
  • Maintained the database consistency with DBCC at regular intervals.
  • Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.

Confidential,NY Nov 08 -May 09
MS SQLServerDeveloper/SSIS/SSAS.

Description: Credit Suisse Group is a world-leading financial services company, advising clients in all aspects of finance, around the world, around the clock. Credit Suisse foundation in 1856, Credit Suisse has continuously set new standards in service and advice, grown our expertise, and created intelligent solutions in response to changing client needs.
Responsibilities:

  • Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Building UAT and Test environments using Production back ups.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Wrote store procedures to generate account statements for different types of accounts
  • Involved in migration of SSRS from SQL 2000 to SQL 2005
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, MS Access,Oracle 9i, Sybase.

Confidential,New York, NY Aug 07 - Oct 08
MS SQL server developer/DBA

Description: CNA is the 7th largest U.S. Commercial Insurer and the 14th largest U.S. Property & Casualty Insurer. The application is useful for vendors and lawyers for the internal acceptance of the policies. The application receives the input data from online booking policy customers. The data can even manually be entered by staff once when the lawyers approve in the presence of customers and edit according to the needs of the policies requested by the customers. Auto Quote Generation, Quote Submissions, Policy Renewals, Reinstatements, Reissues, Coverage Charts, Endorsements, Conditions, Regular Solicitation Processes for its products, sub-products and their corresponding coverage limits are the aspects involved.

Responsibilities:

  • Analyzed the requirements and selected the appropriate fact tables/created fact tables
  • Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
  • Created the storage type (ROLAP),Created cubes for Business Intelligence
  • Involved in writing MDX Scripts for the OLAP CUBES.
  • Creating Static Reports using MDX queries and creating MDX Base Report Definition.
  • Experience in building and maintaining Data marts. Created roles for using the cubes
  • Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
  • Transferring data between XML document and SQL server
  • Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
  • Actively involved in Normalization & De-normalization of database
  • Materialized views, dimensions and stored outlines for optimal performance
  • Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
  • Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
  • Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, ERwin, XML, VB.NET, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential,Hyderabad, India Dec 05 - Jun 07
MS SQL Developer/DBA

Description: Activity starts with registering the project with DGFT (Director General of Foreign Trade).When the project is registered with DGFT all the details of the project and materials to be imported need is provided. After verifying the documents, Import license is given by DGFT. Foreign exchange department in BHEL gives the inputs (Import license details) for projects registered with DGFT.

Responsibilities:

  • Developed the Functional specification documentation for the modules to be developed.
  • Worked with SQL and PLSQL to create Tables, Views, and Triggers and stored Procedures.
  • Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
  • Responsible for tuning T-SQL procedures, triggers and other database objects
  • Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
  • Designed and developed DTS packages for transferring data from flat files and Access files
  • Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
  • Developed windows based applications in VB.net 2003 for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports
  • Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters
  • Used informatica for ETL process.

Environment: T-SQL, SQL Server 2000, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler, Informatica.

Confidential,Hyderabad, India May 05 – Nov 05
SQL Programmer

Mysore Bank Limited, started operations in July 1984. Mysore bank was incorporated with the objective of extending international standard modern banking services to various sectors of the society. Pursuing its objective, Mysore bank provides a full range of commercial banking services through its 19 points of representation across the country and over 170 reputed correspondent banks across the globe. It offers a full range of banking products and services in Wholesale and Consumer banking, catering to a wide range of customers encompassing individuals, mid-market local corporate, multinationals, large public sector companies, government corporations, airlines, hotels.

Responsibilities:

  • Created new tables, written stored procedures for Application Developers and some user defined functions.
  • Created SQL scripts for tuning and scheduling.
  • Performed data conversions from flat files into a normalized database structure.
  • Created and managed users, roles and groups and handled database security.
  • Created Triggers to enforce data and referential integrity.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
  • Data migration (import & export – BCP) from Text to SQL Server
  • Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Performed development support, document reviews, test plan, integration of the system.
  • Creation/ Maintenance of Indexes for fast and efficient reporting process.
  • Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
  • Creation/Deletion of Linked Servers.
  • Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: SQL Server 2000, T-SQL, PL/SQL, TOAD.

We'd love your feedback!