We provide IT Staff Augmentation Services!

Sql Server Bi Resume

Addison, TX

Summary

  • Over 7+ years of IT experience in Analysis, Design, Implementation & Administration of Business IntelligenceSolutions with Microsoft SQL server 2008/2005/2000 with various business domains like Financial, Banking, Insurance Sector.
  • Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2005/2008.
  • Extensive experience in SQL Sever 2008/2005 with Business Intelligence in SQL Server Reporting Service and SQL Sever Integration Service.
  • Excellent skills in designing Logical and Physical Modeling using ERWIN Tooland ER Studio.
  • Excellent in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Actively involved in migration of SSRS reports from SQL 2000 to SQL 2008/2005 and migration with DTS to SSIS 2008/2005.
  • Proficient in OLTP, OLAP and Data warehousing Design concepts
  • Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions, and Process Documentation.
  • Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL
  • Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2008/2005
  • Expert in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS.
  • Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
  • Thorough understanding of KPI, using MDX queries, Data mining structures.
  • Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, adhoc reports, parameterized reports, interactive reports & custom reports
  • Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
  • Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
  • Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes
  • Self learning ability and Leadership Quality.
  • Good teamplayer, strong interpersonal and communication skills combined with self motivation, initiative and ability to think beyond to achieve better performance.

Technical Skills:

Databases Tools

SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools

Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools

SQL Server Reporting Services (2008/2005/2000), MS Access, MS Excel

Database

MS SQL Server 2008/2005/2000, MS Access, Oracle 9i/8i

Programming

T-SQL, C, PL-SQL

Web Technologies

HTML, CSS

Operating Systems

Windows (95/98/2000), Windows 2003 Server, Windows XP, Windows Vista

Other Tools

MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN

Professional Experience

Confidential, Addison, TX Dec 2011 - Till Date
Role: SQL Server BI Developer

Confidential, is one of the leading financial servicing firms providing banking facilities in United States. It supports for variety of services including consumer banking, cooperate banking, mortgage loans and wealth management.

Responsibilities:

  • Designed and implemented Stored Procedures and Triggers for automating tasks.
  • Monitoring of History and Current Records by implementing Change Data Capture on the tables.
  • Loading flat files everyday and storing them in Archive by renaming the files with current date.
  • Updating about 25 columns in each table by implementing complex queries, stored procedures as required by the business logic.
  • Creation of Indexes and applying triggers.
  • Application of Recursive CTE\'s where required.
  • Created SSIS Packages to pull data from iSeries and load into SQL Server Tables
  • Implementing Package Configurations for the package for making it to work in different servers.
  • Designed Complex Cubes, KPI\'s, Partitions.
  • Mapped each KPI with Multiple data sources, threshold values, bending methods, and indicators.
  • Optimized Complex queries using Indexes and execution plan.
  • Generate SSRS reports by using complex queries.
  • Developed flowcharts for complex stored procedures.
  • Implemented normalization techniques on different databases.
  • Developed Multi dimensional Objects (Cubes) using MS Analysis.
  • Deployed data mart to various environments as required by the business logic.
  • Deployed SSIS Packages to different environments.
  • Loading data from various sources like ,flat files, to SQL Server database Using SSIS Package
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
  • Design and create report models based on users' requirements, explain and train users to use report builder to generate their own personalized reports.
  • Created SSIS Packages to migrate slowly changing dimensions
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in SSAS.
  • Designed and Developed Unified Dimensional Model (UDM) in SSAS to combine data from multiple databases to single model.
  • Loading data from MS Access to SQL Servers.
  • Deployed SSRS Reports inSharePoint for web based access for multiple end users.
  • Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
  • Created reports usingstored procedure and also involved inscheduling, creating snapshotsand subscriptions for the reports SSRS.

Environment: MS SQL Server 2005/2008, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, Query Analyzer, MS Office 2003, Oracle 9i/10g,Erwin 4.0, MS Access.

Client: Confidential,Atlanta, GA Sep 2010 - Nov 2011
Sr. MS SQL Server / BI Developer

Description: Alere gives medical professionals and consumers the tools they need to make more informed healthcare choices. Our primary areas of interest are in cardiology, women's health, infectious disease, oncology and drugs of abuse, and we see exciting opportunities to develop innovative healthmanagement programs.

Responsibilities:

  • Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
  • Configured IIS along with the Network team
  • Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
  • Copied Flat files and Excel files from FTP to Shared drives using FTP task in SSIS.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
  • Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Created SQL Server Reports based on the requirements using SSRS 2008.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Created complex reports which involve more number of groupings and multi-value parameters
  • Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Created multiple reports with drop down menu option having complex groupings within the report.
  • Loading the data from various databases i.e., from MS Access, Oracle, iSeries to SQL Servers.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix
  • Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Troubleshooting performance issues and fine-tuning queries and stored procedures.
  • Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Scheduling the SSIS packages and Jobs.
  • Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, MS SQL Server-2008/2005 Enterprise Edition, MS Access,SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, FTP, IIS Erwin, Performance Point Sever, Office-2007, MS Excel, ProClarity Analysis.

Client: Confidential, South Field, MIJul 2009 - Aug 2010
MS SQL Server / BI Developer

Confidential, is a multinational telecommunications corporation. We have consistently provided innovative, reliable, high-quality products by creating new solutions for consumers and businesses and by driving innovation in the communications and entertainment industry.

Responsibilities:

  • Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
  • Deployed SSRS Reports in SharePoint for web based access for multiple end users.
  • Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Created SQL Server Reports based on the requirements using SSRS 2008.
  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Created complex reports which involve more number of groupings and multi-value parameters
  • Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
  • Created multiple reports with drop down menu option having complex groupings within the report.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix
  • Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Troubleshooting performance issues and fine-tuning queries and stored procedures.
  • Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Scheduling the SSIS packages and Jobs.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages
  • Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Share Point Sever, Office-2007, MS Excel, ProClarity Analysis.

Client: Confidential, Mechanicsville, VA Aug 2008 - Jul 2009
Sr. MS SQL Server / BI Developer

Description: Owens & Minor Inc. Headquartered in Richmond, Virginia, is the leading distributor of medical and surgical supplies to the acute-care market and a leading provider of healthcare supply-chain management solutions.

Responsibilities:

  • Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.
  • Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
  • Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
  • Scheduled SSIS Packages for loading Facts and Dimensions.
  • 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
  • Involved in updating slowly changing dimensions strategies.
  • 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.
  • Designed and built OLAP cubes to meet reporting needs.
  • Responsible for identifying and defining Data Source and Data Source views.
  • Created cubes and defined the dimensions.
  • Responsible for defining calculated members.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
  • Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
  • Defined attribute properties in a Parent Child Dimensions.
  • Used Joins to write queries that retrieve data from more than one table.
  • Responsible for hiding and disabling attributes and attribute hierarchies.
  • Developed reports that deliver data from cubes.
  • Created and managed subscriptions for the reports.
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
  • Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
  • Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, PROCLARITY, MDX, T-SQL, MS Visual Studio 2005.

Client: Confidential, Chicago, IL Oct 2007 - Jul 2008
Sr. MS SQL Server / BI Developer

Confidential, is a global chemical and oil company. Amoco Corporation is active in three main fields within the petroleum, natural gas, and chemical industries.

Responsibilities:

  • Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
  • Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
  • Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
  • Created Indexes to get the high level performance.
  • Performing the ETL operations to support the data loads and transformations using SSIS.
  • Involved in migration from Oracle to SQL Server 2005 using SSIS.
  • Developed Cubes using SQL Analysis Services (SSAS).
  • Deployment of SSAS Cubes to the production server.
  • Generation of reports from the cubes by connecting to Analysis server from SSRS.
  • SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Implemented automated backup and database maintenance / cleanup jobs.
  • Managing Logins, Users, Roles and User permissions.
  • Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services.
  • Created various Tabular and Matrix Reports using SSRS.
  • Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), MS SQL Analysis Services(SSAS), Windows 2000/XP, Oracle 7.0.

Confidential,Hyderabad, India Jan 2006 - Sep 2007
SQL Server Developer/SQL Server DBA

Description: Confidential, formerly UTI Bank, is a financial services firm that had begun operations in 1994, after the Government of India allowed new private banks to be established. Axis Bank one of the largest private sector financer in India for Agriculture loans.

Responsibilities:

  • Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
  • Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
  • Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
  • Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
  • Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
  • Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Created Cubes and used basic MDX to retrieve the result set for Calculations.
  • Worked on advanced dimension Design and Cube design.
  • Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
  • Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Involved in deployment of SSRS reports on the SharePoint Portal.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Wrote stored procedures to get the fields required for the reports.
  • Created datasets using stored procedures and reports using multi value parameters
  • Created sub reports, bar charts and matrix reports.

Environment: SQL Server 2005 / 2000(2003 ,64 bit edition of SQL server 2000), DTS, Microsoft Business Intelligence Development Studio, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.

Confidential, Madras, India Feb 2005 - Dec 2005
SQL Server Developer

Description: LIC is one of the leading providers of auto, home and life insurance in INDIA. As a consultant at LIC for the Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning), developed and helped to implement HRMS that is designed to handle the human resource activities for the organization. HRMS is a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, leave or absence, payroll data, and change of certain business rules required development of new modules to the system.

Responsibilities:

  • Created Database as per the requirement of the bank to maintain the student records using SQL server 2000
  • Maintained and supported the SQL Server databases as a developer helping administrator
  • Involved in the Data modeling, Physical and Logical Design of Database
  • Created tables, indexes, sequences, constraints, triggers and procedures
  • Written Stored procedures and triggers to implement business rules
  • Involved in integration of the front end with the SQL Server backend
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation
  • Maintained disaster recovery Backup and Re-Indexing was implemented to increase the performance
  • Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database
  • Created documentation as required

Environment: MS SQL Server 2000, T-SQL, DTS, MS-Excel, MS-Office, Oracle8i and C.

Education: Bachelor's in Electronics and Communication Engineering

Hire Now