We provide IT Staff Augmentation Services!

Sql Data Warehouse Develope Resume

Overland Park, KS

Professional Summary

  • Over 8 years of IT experience in MS SQL server application development, RDBMS design and modeling, creating and deploying SSIS packages in development, test and production environments. Data Warehouse experience across multiple IT sectors such as; Telecom, Health Care and Transportation on multi large-scale and highly visible projects. Experienced in SQL Server versions: 2012, 2008 R2, 2008, 2005, 2000
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Skilled in scheduling and tracking ETL projects throughout SQL Server Agent and Job Activity Monitor.
  • Created database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors on Microsoft SQL Server 2000/2005/2008.
  • Strong T-SQL Server 2000/2005/2008 Developer Skills including writing Stored Procedures, User-Defined Functions, Triggers, Views and Indexes.
  • Experience in monitoring SQL Server performance tuning using SQL Profiler (Dead Locks/Long running queries), Query analyzer, Database engine tuning wizard, Index tuning wizard, windows Performance monitor, Client/Server Connectivity.
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Strong understanding of relational data structures, theories, principles, and practices Data Analysis, Data mining, Data Integrity management, metrics management and reporting.
  • Proficient in Installing SQL Server 2000/ 2005/2008/2012 and configuration of their tools.
  • Experience in data warehousing Analysis Service (OLTP and OLAP) and Creation and deployment of cubes on SSAS.
  • Good report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Strong experience in scheduling and deploying reports on report manger and developing User reports and management reports using MS SQL Server Reporting Services (SSRS).
  • Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
  • Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using MicroStrategy, Tableau and SQL Server Reporting Services (SSRS).
  • Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
  • Strong technical skills across various RDBMS technologies such as MySQL, Oracle database, SQL Server, Analysis Services, Netezza and Teradata
  • Experience with MPP and high performance data warehouse environments such as Netezza and Microsoft PDW (Parallel Data Warehouse)
  • Working knowledge of Apache Hadoop and developing with Hive and MapReduce
  • Work closely with Clients/Requirement Team to define data requirements for reporting warehouse.

Skills

Operating Systems

Windows 2000 Server, Windows 2000 Advanced server, Windows 2003, Windows 2008 , Windows NT 4.0, Windows XP, Windows Vista.

Environment

SQL Server 2005/2008/2012 ,Netezza,Microsoft PDW, SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, Analysis Services, Web Reports, VS.NET, PL/SQL, Business Objects 4.0, XI 3.1/XI R2/6.x/5.x, WebI, Designer, Performance Manager, Dashboard Manager, Crystal Xcelsius.

Languages

C,C++, PL/SQL,T-SQL

RDBMS

SQL Server 2005/2008/2012 ,Netezza,Microsoft PDW, Oracle 11Gi

Application

MS SQL Server Management Studio, Business Intelligence Development Studio, MicroStrategy, Tableau.

Database Query Tools

MS SQL Server Query Analyzer, SQL Profiler, ETL, Toad for SQL

Database Softwar

Professional Experience

Confidential

Role : SQL Data Warehouse Develope

Project Description:

Job Responsibilities:

  • Involved in the Sprint’s Network Vision initiative covering 3G CDMA&EVDO modernization and 4G LTE from the OEM (Original Equipment Manufacturer) data standpoint as well as CM(Corporation Management) for reporting purposes
  • Interact with multiple groups: Sprint and Ericsson Services National RF engineers, Requirement Teams from vendors (Lucent, Moto, Ericsson and Samsung) and Windows Team System Admins.
  • Monitoring and analyzing KPIs to identify areas of investigation to reduce Lost Calls, Ineffective Attempts, Failed connection attempts, Dropped Connections.
  • Conduct network performance Data Analysis to troubleshoot and fix network problems relating to network capacity and switches.
  • Review, create and correct mapping documents as well as revise the code (TSQL) for the SSIS packages.
  • Work closely with Clients/Business Analysts to define data requirements for reporting warehouse.
  • Provide the ETL production status of the system in the daily Flux Health meeting.
  • Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.
  • Responsible for creating and deploying SSIS packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
  • Experience in migration of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using Replication, BCP, DTS, Bulk Insert and SSIS utility.
  • Develop custom report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using MicroStrategy, Tableau and SQL Server Reporting Services.
  • Used Advanced Query Tool(AQT) to check the queries on Netezza and used to generate statistics on huge data.
  • Assist end users in setting up Excel data cubes and using the PowerPivot add-in
  • Created Views for specific columns on a table to maintain privacy of a customer data.
  • Created Indexes to get the high level performance.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Develop advanced shell scripts, SQL scripts in support of database operations
  • Create, modify, update shell scripts to automate deployments, tear-downs, and maintenance/updates as needed
  • Designed SSIS packages for synchronizing the data between two different servers.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Responsible for gathering Business Requirements and System Specification from users.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services (SSRS).
  • Experience in the design, development and maintenance of different cubes using SSAS.
  • Involved in the post deployment maintenance of reports and cubes and Created and scheduled jobs for various tasks.
  • Developing ETL Frame work to extract and load the data from multiple databases from SQL Server 2008 to File Server and File Server to work flow Job System SQL databases.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), MicroStrategy, Tableau, Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5, MS Excel.

Confidential

Role : SQL Data Warehouse Developer

Job Responsibilities:

  • Developed hospital measure analysis dashboard using Universe and WEBI.
  • Design and developed universe for measure analysis dashboard and reports.
  • Developed Pie charts, bar graphs, line graphs, comparative graphs and trend graph in WEBI reports.
  • Worked closely with account managers and business managers in calculating requirements for implementation on Business Objects 4.0.
  • Worked on Business Objects Security as per the Client requirement.
  • Developed Performance Management Dashboards to set goals, measures and monitor KPI for Balance Scorecard initiatives.
  • Created new Universes on Business Objects 4.0 relating to HR.
  • Worked on Web Intelligence 4.0, Crystal Reports Enterprise 4.0 and Dashboard Designer 4.0.
  • Experienced in BOE Migrations from BO XI and BO XI R2 to XIR3.
  • Developed documents like BOBJ Security, Xcelsius, Webi & Universe Designer etc.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Designed SSIS packages for synchronizing the data between two different servers.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Responsible for gathering Business Requirements and System Specification from users.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services (SSRS).
  • Experience in the design, development and maintenance of different cubes using SSAS.
  • Involved in the post deployment maintenance of reports and cubes and Created and scheduled jobs for various tasks.
  • Developing ETL Frame work to extract and load the data from multiple databases from SQL Server 2008 to File Server and File Server to work flow Job System SQL databases.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, Analysis Services, Web Reports, VS.NET, PL/SQL, Business Objects 4.0, XI 3.1/XI R2/6.x/5.x, WebI, Designer, Performance Manager, Dashboard Manager, Crystal Xcelsius.

Confidential

Role : SQL Server BI developer

Job Responsibilities:

  • Involved in creating the log files to track the bugs raised as a part of development and while in the production.
  • Identified damage on the general operational condition of bridges and monitored bridges structures using wireless sensor nodes
  • Analyzed the existing application and wrote technical specification document for the reports associating with the application.
  • Worked on WCF Service layer to retrieve data from the SQL Server.
  • Analyzed the requirements and created model classes accordingly to be used in the application.
  • Used Visual Studio 2005 BI tool to create SQL server reporting services (SSRS) reports.
  • Responsible for Database Script updates and Query writing related all the modules

Environment: Microsoft SQL Server 2005/2008, SAP business objects, Business Intelligence ETL Development Dashboard/Crystal Report, BI applications/Data Warehouse/Data structures, MicroStrategy, Programmable Logic Controller (PLC), Visual Basic/Oracle.

Confidential

Role : SQL Server Developer

Job Responsibilities:

  • Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed
  • Wrote Triggers and Stored Procedures.
  • Evaluated Database Performance and performed maintenance duties such as Tuning, Backup and Restore.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Successfully designed and implemented SSIS packages to transfer data within servers.
  • Developed custom reports using SSRS/SQL Server BI studio.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Managing and configuring logins to SQL Server, database user accounts, permissions.
  • Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
  • Troubleshooting, Monitoring and Tuning the SQL Server for optimum performance.

Environment:

Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, DHTML, PL/SQL, TOAD v9.5, MS Excel.

Hire Now