We provide IT Staff Augmentation Services!

Sql Sever Bi Developer Resume

2.00/5 (Submit Your Rating)

Milpitas, CA

Professional Summary:

  • 7+ years of IT experience in the design, development, working experience MS SQL Server 2008/2005(SSIS, SSAS, SSRS)/2000/7.0, Database Migration, Database Administration, Physical/Logical design, T-SQL, Performance-Tuning, Troubleshooting, Backups and Restore of databases.
  • Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Created SQL Server reports using SQL Server Reporting Services (SSRS).
  • 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 extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
  • Experience in OLAP, ODS, Snowflake schema, Star schema, ETL, MDX, Data mining, DBMS and Data Modeling.
  • Expertise in ETL tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse)environment
  • Experience in generatingDrill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
  • Experience with SQL Admin activities such as Installation, Configuration, maintenance, support, backup, recovery, Log Shipping, Performance Tuning of SQL Server
  • Experience in building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server.
  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects
  • Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
  • Experience in generatingDrill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008
  • Expertise in generating reports using Business Objects 6.5/XI, Crystal Reports and SQL Server Reporting.
  • Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, testing and implementing on production servers.

Education:

  • B.S, Electronics & Communication Engineering Confidential University

Technical Skills:
Languages: T-SQL, PL/SQL, C, C#, Java, HTML, XML, VB script.
Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX
RDBMS/ Databases: MS SQL Server 7.0/2000/2005, Oracle 8i/9i
Data Warehouse Tools: OLAP, SQL data transformation services (DTS)
Data Modeling and ETL tools: ERWIN, Informatica.
Reporting Tools: Microsoft reporting server, Business Objects, Performance Point
Microsoft Technologies: VB.Net, ASP.NET.
SharePoint Products and
Technologies: MOSS 2007, WSS v3, SharePoint Designer 2007 and BizTalk.

Professional Experience:

Confidential, Milpitas, CA Jul ’10 PRESENT
Role: SQL SEVER BI DEVELOPER

Confidential,designs, manufactures, and sells Internet protocol (IP)-based networking and other products related to the communications and information technology (IT) industry and provide services associated with these products and their use. The Company provides a line of products for transporting data, voice, and video within buildings. Its products are designed to transform how people connect, communicate, and collaborate. Its products are installed at enterprise businesses, public institutions, telecommunications companies, commercial businesses, and personal residences.
Responsibilities:

  • Analyzed and designed software and database solutions.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Worked on other packages of the SQL server 2005 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracleusing SSIS.
  • Created data mapping between two distinct models.
  • Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • 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
  • Involved in Installation, Configuration of Share Point Form in Cluster Environment.
  • Designed and developed Star and Snow Flake Schema as a data analyst.
  • Reviewed Cube with End user and changing the cube and documentation according to their requirements.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Created Indexes, Constraints and Rules on database objects.
  • Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
  • Performed tune to optimize SQL queries using SQL profiler and query analyzer.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Involved in developing and modifying VB and XML reports for exporting the reports to web application.
  • Wrote T-SQL code for creating cursor and handling the data validations.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Created new XML tags in order to execute new business rules.
  • Implemented site information architecture utilizing various SharePoint resources including Document Libraries, Lists, Form Libraries, Content Types, Column, Information Management Policies and Version Controlling.

Environment: MS SQL Server 2005/2008, SSAS, SQL Server Reporting Services 2005/2008, SSIS, Front Office 8.3 / 10.2 / 10.3, Windows XP / NT / 2000/2003, MS Office 2003/2007.

Confidential,Atlanta, GA Aug09-Jun10
Role: SQL BI Developer (SSIS, SSRS, SSAS)

The CONFIDENTIAL, web site allows customers to shop in a virtual shopping mall, checkout items from different shops, manage accounts for each shop separately etc.CONFIDENTIAL, reports provide in-depth analysis for evaluating business relationships, making decisions about important transactions, researching competitors and suppliers and planning for sales calls.
Responsibilities:

  • Database planning in relation to physical and logical data architecture.
  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Helped in DesigningBusiness Models as per requirement for SQL 2005 Analysis Services cubes.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005 from different environments for the SSAS cubes.
  • Designed Fact tables, Dimension tables, scheduled transfer data from real time database to data warehouse and databases.
  • Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2005 Reporting Services.
  • Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services.
  • Deployed SQL Code and Reports (SQL 2005 Reporting Services) To QA\\Dev\\Prod.
  • Participated in Database Design and Code Reviews to ensure optimum Performance
  • Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
  • Converted/Created SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
  • Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
  • Migrated Objects (Stored Procedures, Views) from Oracle to SQL.
  • Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
  • Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
  • Responsible for database backups, data replication, encryption and database security
  • Managed user access, created and managed new security accounts.
  • Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
  • Supported OLAP team for providing data from SQL Servers.
  • Assisted with various ad hoc query requests.
  • Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005 Enterprise, T-SQL, VBScript, MS-Excel, XML, SSIS, SSRS, SSAS, MDX, OLAP, ErWin, Microsoft Visual Studio 2005, Windows 2000/2003/NT/XP.

Confidential,Charlotte, NC Jul08 Jun09 Role: SQL SEVER SSIS/SSRS DEVELOPER

Confidential, provides a full range of commercial & individual banking products and services. It is open 7 days a week with extended and holiday hours. Customers can also access account information 24 hours a day, 7 days a week with Totally Free Online Banking & Bill Pay, Cash Management Services, 24/7 Customer Service Center, automated Telephone Banking and an extensive ATM network. My responsibilities in this bank were to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various bank databases in both development and production environment.

Responsibilities:

  • Installed and Configured SQL Server 2008 along with Integration Services (SSIS) and Analysis services(SSAS)
  • Worked closely with Marketing Director and General Manager to understand business process and gather business requirements.
  • Designed dimensions/tables and the requisite relationships, designed partition tables and partition views by using Erwin to meet business requirements in SSAS.
  • Designed and developed SQL SSIS Packages to extract data since 2005 from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Designed and created cubes in SSAS.
  • Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
  • Depending on business logic as per architects idea analyzed and developed reports in (SSAS,SSRS,SQR)
  • Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
  • Analyze business and technical requirements, as well as data warehouse data models(SSIS,SSAS SSRS,SQR), to understand the detailed data management requirements
  • Writing reports using Microsoft Reporting Services (SSRS) and SQR query reporter.
  • Develop scripts for the creation of the physical data warehouse database schema(s), data security and protection, managing performance, performing backups/ restores, and archiving data in SSIS, SSAS.
  • Implement analysis service database maintenance procedures and backup schedule in SSAS.

Environment: Windows 2003, MS SQL Server 2005, ETL, SSIS, OLAP, OLTP, SSAS, SSRS, SQR, T-SQL, Microsoft Visual Studio.Net 2005 and VB.Net

Confidential, Woodbury, MN Mar07 Jun08 Role: SQL SEVER SSIS/SSRS DEVELOPER

Confdiential,deals with life insurance, which is basically two types, Term Insurance and Cash value Insurance. Both of them contain different terms depending on policy and pay benefit if anyone dies during the term and has protection for each premium. I also dealt with team leaders of various underwriting departments who needed help with reinsuring a form of non-proportional reinsurance that provides coverage for losses resulting from an accident or natural disaster involving more than one insured.
Responsibilities:

  • Installing different hot fixes for deadlocks, blocking and indexes.
  • Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
  • Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracleusing SSIS.
  • Experience in mapping multiple related systems.
  • Designed the system architecture that is used to structure, plan, and control the process of developing an information system
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.
  • Used BCP command line utility to replicate a database.
  • Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
  • Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data.
  • Experience in migrating some of the DTS packages in to SSIS.
  • Used Recompile and with option query hints to avoid parameter sniffing problems.
  • Improved query performance by adding covered indexes, adding file groups..
  • Creating and managing schema objects such as tables, views,joins,clusters, indexes,functions,procedures, triggers & maintaining Referential Integrity.
  • Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
  • Developed reports using SSRS 2005 and Crystal reports. Used table control, matrix control for cross tab reports.
  • Configured Reporting Services in SQL Server 2005.
  • Created standard Reports and Cross Tab Reports and Drill Through reports.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Created different chart reports helped in analyzing perfmon counters using SSRS 2005.
  • Troubleshooting performance issues with Fragmentation using Profiler, System Monitor and DMV’s.
  • Configured nodes and virtual server to set up Active/Active Clustering.
  • Import Data from MS-Access Database and XML to SQL Server Database.
  • 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
  • Involved in Installation, Configuration of Share Point Form in Cluster Environment.

Environment: SQL Server 2000/2005, Enterprise Edition, SQL, Enterprise manager, SSRS 2005, SSIS 2005,Spotlight,MS SharePoint, MS Access 2000 & Windows2003/2000platform, C#,VB.NET,ASP.NET.

Confidential, Bangalore, India.Mar06 Feb07 Role: SQL SERVER DEVELOPER/DBA

Confidential, provides different financial services. The scope of the project that I worked on was to facilitate in the maintenance and development of the application, which supported personal banking on wealth management, asset management dealing with different types of accounts and services

Responsibilities:

  • Upgraded SQL Server 7.0 to SQL Server 2000. Also Performed SQL Server 2000 Installation
  • Worked on Client/Server tools like SQL Server Query Analyzer to administer SQL Server
  • Created Database Maintenance Planner for improving the performance of SQL Server which covers Database Integrity Checks, Updated Database Statistics and Re-indexing
  • Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
  • Designed DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database
  • Data migration (import & export - BCP) from Text to SQL Server
  • Clustered Server and Load balancing to maintain the Redundancy of Servers.
  • Configured IIS Server for the XML programming which was a new level of SQL 2000.
  • Configured Exchange Server for sending automatic mails to the respective people when a jobfailed or succeed

Environment: Microsoft SQL Server 2000/7.0, Microsoft Windows 2000 Server, Microsoft Visual Basic and Microsoft Access 97/2000.

Confidential, Hyderabad, India Jun05 Feb06 Role: JR. SQL SERVER DEVELOPER

Confidential, is one of the largest banks inIndiaproviding 24 hour’s service.UTI bankdeals in retail and corporate banking services. I started my IT career with this project as a Jr SQL Developer.

Responsibilities:

  • Data transfer between Development, Testing and Production databases.
  • Actively designed the database to fasten certain daily jobs, stored procedures.
  • Provided support to development staff about database related issues.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation
  • Scheduled database backup and performed full, incremental and differential backups of database and transactional logs
  • Alteration of tables and fields as per requirements and recreation of indexes.

Environment: SQL Server 7.0/2000, T-SQL, Query Analyzer, Windows NT/2000 server.

We'd love your feedback!