We provide IT Staff Augmentation Services!

Sql Server / Qlikview Developer Resume

South San Francisco, CA

SUMMARY

  • Over 8 years of IT experience in various sectors, including Pharmaceutical, Financial and Retail as a SQL Server Developer that includes Database Design and Development of MS SQL Server 2012/2008/2005/2000 .
  • Involved in all phases of Software Development Life Cycle (SDLC).
  • Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client - Server & Business Intelligence (SSIS, SSAS, SSRS) applications.
  • Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
  • Expertise in writing and debugging Stored Procedures and Triggers in SQL Server and PL/SQL.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
  • Upgrade DTS packages to SQL Server Integration Services (SSIS).
  • Expertise in Data Transformation Services (DTS) in SQL Server 2000.
  • Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experienced in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experienced in SQL Server Analysis Services OLAP Cubes, and Data Mining.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
  • Used SQL Server reporting services 2005/2008 for generating reports.
  • Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
  • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
  • Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2005/2008.
  • Experience in creating Dashboards using QlikView.
  • Planned and implemented MS SQL Server Security and database access.
  • Experience in Database Mirroring, Log Shipping, Database Replication, CDC and Database Snapshots
  • Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008.
  • Knowledge on Active Directory Administration.
  • Good understanding of Change Control process.
  • Experience in installing and configuring third party backup/restore tools like Quest litespeed and Idera SQLSafe.
  • Troubleshoot performance issues and bottlenecks using Performance Monitor and Profiler for monitoring dead locks and long running queries.
  • Carried out database consistency checks using DBCC commands.
  • Experience in Data Center Migrations and Server consolidation
  • Configured database mail to send messages when jobs failed in SQL Server 2005.
  • Proven experience in applying Service Packs and hot fixes.
  • Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
  • Ability to quickly adapt and learn, work in-groups as well as independently with minimum supervision.
  • Excellent communication skills highly motivated and result oriented professional.

TECHNICAL SKILLS

  • MS SQL Server 2012/2008/2005/2000
  • SQL Server Management Studio
  • Business Intelligence Development Studio (BIDS)
  • Data Tools
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
  • ETL
  • PL/SQL
  • Microsoft Team Foundation Server (TFS)
  • MDX Queries
  • SQL Server Profiler
  • MS Visio
  • MS Project
  • MS Office
  • Automate 9.0
  • QlikView

PROFESSIONAL EXPERIENCE

Confidential, South San Francisco, CA

Sql Server / QlikView Developer

Responsibilities:

  • Involved in requirements gathering for the dashboards, Troubleshoot Data issues and validate the data sources.
  • Responsible for creating source to destination data mapping documents and architecting ETL solutions using SQL server integration services (SSIS).
  • Responsible for unit testing & deploying code to production.
  • Responsible for scheduling ETL (SSIS) packages using SQL server job scheduler.
  • Involved in performance tuning of SQL queries & SSIS packages.
  • Responsible for creating Qlikview Dashboards and creating triggers for dashboard refresh.
  • Responsible for maintaining user access to the dashboards & Licensing Users for access.
  • Created a Technical Design Documents for the projects development.
  • Responsible for providing Oncall support for 24/7 server availability.
  • Responsible for coordination & communication with the offshore team for the project development effort.

Environment: Windows server 2008, Oracle 11G, SQL Server 2012, Qlikview 11, Excel, SSIS, SSRS.

Confidential, San Francisco, CA

SQL BI Developer

Responsibilities:

  • Created the list of dimensions and Measures as per the User’s requirements.
  • Created complex queries for database auditing purposes.
  • Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
  • Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
  • Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
  • Created the SSAS cube using complex MDX calculations and Dimension mappings.
  • Created new views in order to populate the SSAS Cube.
  • Created SSIS Packages and scheduled them using Automate Tool for loading the data to the SSAS Cube.
  • Worked towards the improvement of overall Cube performance.
  • Implemented and automated the QA process to compare the results from the cube to that of the Data Warehouse using SSIS.
  • Involved in the process of creating Sales Dashboards using Qlikview.

Environment: Windows 7, MS SQL Server 2012, Data Tools, SSAS, SSIS, Qlikview.

Confidential, Richmond, CA

Sr. SQL BI Developer

Responsibilities:

  • Participated in entire SDLC process. Followed waterfall process for the project.
  • Interacted with Business Users to gather the requirements.
  • Improved and improvised the system by rectifying existing bugs and implementing new features.
  • Created new stored procedures, indexed views, user defined functions in accordance with client requirements.
  • Monitored the database consistently on the production server.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
  • Responsible for installing and configuring SQL Servers on both Physical and Virtual (VMWare) Servers.
  • Providing day-to day to support and monitoring SQL Servers performance.
  • Monitor Disk space and suggest reasonable estimates for additional space.
  • Automate database refresh from prod to test as needed.
  • Configured SQL mail Agent for sending Automatic emails on Errors.

Confidential

Lead Developer

Responsibilities:

  • Entirely responsible for the SQL Server Upgrade from SQL 2005 to SQL 2008 R2.
  • Was in constant interaction with the ITSD for base lining the hardware as well as software requirements for the SQL upgrade.
  • Actively involved in planning the recovery models for the upgraded SQL Server.
  • Involved in setting up a maintenance plan for the periodic backups of the SQL Database.

Confidential

Lead Developer

Responsibilities:

  • Entirely responsible for implementing critical reports in SSRS.
  • Proposed a cost effective Business Intelligence model to the client.
  • Involved directly with the Business Users, to gather information to be reported.
  • Created scheduled subscriptions as per the User’s requirement.

Environment: Windows XP/2003 Server R2, MS SQL Server 2005/2008 R2, SSRS.

Confidential, Oakland, CA

MS SQL Server Developer SSIS

Responsibilities:

  • Worked with Business Analysts and Users to understand the requirements.
  • Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
  • Created and managed complex batch jobs.
  • Created complex queries for database auditing purposes.
  • Extensively used different SQL joins in order to produce quality result sets.
  • Imported data into the database using SSIS.
  • Used various transformations during the data import.
  • Manipulated the imported data using various stored procedures and functions.
  • Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Responsible for automating Weekend server maintenance Tasks including index Maintenance.
  • Carried out database refresh using backup and restore in SQL Server.
  • Applied Service Packs and hot fixes on SQL Servers.
  • Configured SQL mail Agent for sending Automatic emails on Errors.
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.

Environment: Windows XP/2003 Server R2, MS SQL Server 2008, SQL Server Reporting services, SQL Server Integration Services, Management Studio.

Confidential, San Francisco, CA

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

  • Migrated Data from MS SQL 2005 to MS SQL 2008.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL.
  • Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
  • Created packages to migrate data from different data sources to Data warehouse.
  • Created packages for database maintenance.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
  • Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
  • Created SQL Server Reports using SSRS 2005 for the clients.
  • Created parameterized reports for the brokers and clients.
  • Deployed the developed reports and upgraded the system.
  • Deployment of the developed reports on to the server for the end users.
  • Fine-tuned the existing SQL queries for maximum efficiency and performance.
  • Supported 24/7 for the production system for post deployment Reports on the server.
  • Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: Windows 7/XP, MS SQL Server 2008/2005, SQL Server Reporting services, PL/SQL, SQL Server Integration Services.

Confidential, Overland Park, KS

Sr. MS SQL Server SSIS/SSRS Developer

Responsibilities:

  • Involved in planning, defining and designing data based on business requirements and provided documentation for the public data collected.
  • Designed SQL queries involving multiple tables using inner and outer joins.
  • Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
  • Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
  • Created complex expressions using Cascading parameters, Drill-Through reports, Parameterize reports and report models for Ad HOC reports using SSRS based on client requirements.
  • Created Sub-Reports, Drilldown-Reports for the clients.
  • Created high quality reports, dashboards and analytics to meet the needs of various business clients such asOperations, Sales, Customer Service, Finance, and Executives.
  • Created complex packages using SSIS and scheduled them on a timely basis.
  • Created SSIS packages to clean and load data to Data warehouse.
  • Created package to transfer data between OLTP and OLAP databases.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to Data warehouse.
  • Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
  • Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
  • Designed and written the queries in the query builder for retrieving the data.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
  • Created and tuned stored procedures, triggers and tables.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
  • Performed database administration and management activities in a safe, recoverable and professional manner that ensured the optimal operation of all database environments.
  • Planned and scheduled the online/offline backups.
  • Performed query plans and made sure each and every query was using appropriate indexes.
  • Carried out database and log backups and restoration, backup strategies and scheduling backups.
  • Backed up master and system databases and restored them when necessary.
  • Responsible for identifying long running queries on the server and Coordinating with users for optimization.
  • Maintained log shipping and performed DBCC commands for database consistency.
  • Automated the Index maintenance taking in consideration the Fragmentation Levels.
  • Provided knowledge transfer to the company’s SQL programmers.

Environment: MS SQL Server 2008/2005, Reporting Services (SSRS 2005/2008), Integration Services (SSRS 2008), Business Intelligence Development Studio (BIDS), MS Office 2007.

Confidential, Miami, FL

MS SQL Server Developer SSIS/SSRS/SSAS

Responsibilities:

  • Responsible for installing and configuring MS SQL Server along with Visual Studio on a network domain system.
  • Created SQL Server Reports using SSRS 2005 for the manager and the brokers involved.
  • Created parameterized reports for the brokers and clients.
  • Formatted the report layout for the requirement of the end users.
  • Deployment of the developed reports on to the server for the end users.
  • Deployed the developed reports and upgraded the system.
  • Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Defined relationships between Dimensions and Measure groups.
  • Created Fact, Dimensions and represented them in Star Schema.
  • Identified Data Source and Data Source Views for cubes.
  • Using MDX created calculated members for customized calculated measures.
  • Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
  • Documented all database objects, procedures, views, functions & packages for future references.

Environment: Windows XP, T-SQL, MS SQL Server 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005,ERWIN.

Confidential, Jersey City, NJ

MS SQL SSIS/SSRS/SSAS Developer

Responsibilities:

  • Designed the data ware house structure and developed data models using the Erwin tool.
  • Developed Full Analysis Life Cycle Project.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Wrote T-SQL code for creating cursor and handling the data validations.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
  • Created packages for extracting data from OLTP to OLAP.
  • 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.
  • Responsible for Dimension Modeling using the data modeling tools like Erwin.
  • Created Multi-Dimensional Expression (MDX) and OLAP cubes.
  • Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
  • Managed index and optimized queries using execution plan.

Environment: MS-SQL Server 2005, MS SQL Analysis Services 2005, T-SQL, MS-SQL Server Reporting Service 2005, Erwin.

Confidential

MS SQL Developer

Responsibilities:

  • Development of SQL scripts for backup restore.
  • Creation of stored procedures for application development.
  • Performance tuning of SQL statements using stored procedures and indexes.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Replication of data using transactional method.
  • Created crystal reports, ODBC and database connections.
  • Worked with Oracle and MS SQL Server databases to create complex reports.
  • Formatting of reports for various output formats as per the convenience of the end users.
  • Scheduling of alerts.
  • Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
  • Disaster recovery and database maintenance planning.
  • Created crystal reports and hosting it in the web for the users.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, Crystal Reports.

Hire Now