We provide IT Staff Augmentation Services!

Sql Server Developer/bi Developer Resume

Warren, MI

SUMMARY:

  • Over 8+ years of experience as a MS SQL Server Developer working on large - scale enterprise and performance critical applications.
  • Strong technical knowledge in MS SQL Server development including DTS, SSIS Strong technical knowledge on SQL SERVER 2005, 2008R2, 2012 and 2014 tools for importing data, data transformation and Export in different destinations.
  • Knowledge in constraints, containers, variables, parameters in SSIS and implementing variables in SSIS expressions in control flow and dynamic connection managers.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
  • Hands on experience in MS SQL Server, Teradata, Oracle and Tableau and Power pivot.
  • Extensive experience in creating complex functions, stored Procedures, views and SQL statements for applications using T-SQL, Dynamic SQL and PL/SQL.
  • Utilizes data visualization tools to make clear and concise visual representations of data
  • Use Tableau Desktop to analyze and obtain insights into large data sets.
  • Create visually compelling and actionable interactive reports and dashboards.
  • Possess SQL and programming knowledge to deal with data transformations and translations.
  • Created complex SSIS packages to extract data from, MS Access, Oracle and Teradata sources.
  • Have 2+ years of Tableau Desktop and Tableau Server experience. Extended experience of Tableau Geographical maps, drill down and drill through Actions.
  • Expertise in Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with Good knowledge in SQL Server Analysis Services (SSAS) and Power BI.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Server Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS
  • Strong knowledge on different Built in transformations as conditional script, Sort, union, Union All, Merge, Merge Join, Row count, data aggregation, Data conversion, derived column, Audit, Cache transform, Lookup and Fuzzy lookup, Data mapping, Fuzzy grouping and others in SSIS.
  • Customized SSRS delivery formats for Word, Excel and PDF
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
  • 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 in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design.
  • Extensively involved in creating attribute hierarchy on cube dimensions, calculation of measures, defining relationships between dimensions and measure group, and creation of KPIs goal/forecast which is dimension dependent.
  • Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
  • SQL Server 2012 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Created Power BI Visualizations and Dashboards as per the requirement.
  • Experience in creating and maintaining security mechanisms for reports, creating repository domains using Business objects Supervisor.
  • Thorough understanding of Kimball’s’ theory, KPIs, SQL 2012 Architecture.
  • 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.

TECHNICAL SKILLS:

SQL Tools: SSMS, Profiler, Erwin, MS Visio, Export & Import (DTS), MS Access, Toad for Developers, Tableau Business Intelligence/Business Analytics software, Data Visualization

Statistical Tools: SPSS, Minitab, Microsoft Excel

MS: SQL Server 2005/2008/2012/2014, MS Access, My SQL, Oracle, Teradata

Reporting Tools: MS SQL Server Reporting Services(SSRS), Power BI, Excel (Power View)

BI Tools: SSIS, SSAS, SSRS, Toad, Tableau

Languages: SQL, PL/SQL, VBA

Operating System: Windows Server/ Server 2008/server 2012/Professional/ 4.0, Win XP Prof/Standard

PROFESSIONAL EXPERIENCE:

Confidential, Warren, MI

SQL Server Developer/BI Developer

Responsibilities:

  • Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
  • Created date and string expressions in SSIS packages and passed them to create dynamic queries for SSIS source SQL commands.
  • Drive the design and build of visualizations and analytics
  • As part of the ETL process new stored procedures as created using MERGE command for doing insert and updates at the same time and hence increasing performance.
  • Created packages using PL/SQL as per the requirement and converted Oracle stored procedures into SQL Server code or SSIS packages for pulling data from Oracle
  • Used Microsoft Attunity adapters for Teradata and Oracle for optimal performance.
  • Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008 and 2012.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Involved in ETL architecture enhancements to increase the performance using query optimizer
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Created and monitored Control-M jobs for SSIS packages
  • Created Database Triggers, bypassing the mutating table errors, use of row and statement level triggers for advanced auditing of changes made to a table
  • Created Oracle Functions and Procedures to centralize the business logic in the database..
  • Wrote SQL Loader scripts to load data into the SQL Server database from excel spreadsheets.
  • Altered the existing scripts to pass the loans, which were previously failing edit checks when submitted to treasury on a daily basis.
  • Used views, procedures and functions process staged data and loaded the final tables. Created tables, added columns to existing tables.
  • Wrote many adhoc queries for testing the old verses new architecture data to determine if the new system could meet the requirement of minimal loan failure.
  • Helped in the enhancements to increase the ease of use and efficiency for the end user depending on the client’s functionality.
  • Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.

Environment: MS SQL Server 2008 R2/2008/2005, VBA, SQL Server SSAS/SSRS/SSIS, Power BI, MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0, SQL OLAP.

Confidential, Santa Barbara, CA

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008, 2012 and Flat files, DB2 and Oracle.
  • Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008 and 2012.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Involved in ETL architecture enhancements to increase the performance using query optimizer
  • Implemented Event Handlers and Error Handling in SSIS packages. Created SSIS packages for Data Conversion using data conversion transformation.
  • Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
  • Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Developed a Executive level dashboards using Tableau 9.0.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 and 2012.
  • Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements. Defined Key Performance Indicator metrics to create scorecards.
  • Involved in creating report models and applying row level security filters for report model.
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Involved in upgrading from SQL Server 2008 to SQL Server 2012.

Environment: MS SQL Server 2008 R2/2008/2005, SQL Server SSAS/SSRS/SSIS, VBA, MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0SQL OLAP.

Confidential, Pittsburgh, PA

SSAS, SSIS Developer

Responsibilities:

  • Created complex Stored Procedures, functions, tables, temp tables, views and using T-SQL and PL/SQL.
  • Created complex SSIS packages to extract data from Oracle and Teradata sources using Attunity adapters.
  • Extensively used variables and expressions to change values at runtime. Used system and user variables for logging package and task level information and displayed the status in a Java application.
  • Used script task to make decisions and count rows in the source flat files before loading to SQL Server.
  • Thorough understanding of performance tuning, and optimization of SQL queries. Using parallelism in SSIS and decreasing the number of joins in single queries decreased the time from 72 hours to 17 minutes.
  • Used SQL Server logging, flat file logging and CDC to track inserts, updates and deletes.
  • Performed all aspects of database administration, including data modeling, backups and recovery.
  • Extensively created new reports dashboards and modified existing reports using Tableau.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports.
  • Meet the client expectations of the visualization request provided in the reports
  • Generated context filters and used performance actions while handling huge volume of data.
  • Generated tableau dashboards for sales with forecast and reference lines.
  • Generated tableau dashboards with combination charts for clear understanding.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
  • Extensively used T-SQL in creating and altering stored procedures, functions, views, indexes, user profiles, relational
  • Database models, data dictionaries, and data integrity.
  • Writing reports using Microsoft Reporting Services (SSRS)
  • Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
  • Designed, built and tested SSAS Cubes on SQL Server 2005.
  • Created Excel workbooks to enable Cube (SSAS) access for business users.
  • Process the cubes (SSAS), partitions as and when required.
  • Enhanced performance using optimization techniques: normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
  • Worked with development teams in the design of physical databases and in modification.
  • Created packages in SSIS with error handling.
  • Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
  • Worked with different methods of logging in SSIS and advanced data mapping.
  • Experience in creating complex SSIS packages using proper control flow and data flow elements.
  • Migrated data from Oracle, Teradata, Flat files and Excel in to SQL Server using SSIS Packages.
  • Have deployed packages on different servers by configuring it.
  • Installed and configured SQL Server 2008/2005 in Test environment with latest service packs and migrated few databases.
  • Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
  • Implemented computational sensitive queries Stored Procedures.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
  • Used SSIS Configurations files, parent package configuration, XML and SQL Server Configurations for SSIS packages.
  • Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
  • Manages to established firm standards for quality, service, and delivery i.e. delivering regular reports within time, checking mailbox to ensure timely delivery etc.
  • Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
  • Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
  • Involved in migration from SQL Server 2000 to SQL Server 2005.
  • Actively involved in Normalization (3NF) & De-normalization of database.
  • Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.

Environment: MS SQL Server 2008 R2/2008/2005, SQL Server SSAS/SSRS/SSIS, MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0, SQL OLAP.

Confidential, Baltimore, MD

SQL Developer

Responsibilities:

  • Designed and implemented complex SSIS packages to deliver OUTBOUND files to various users in company.
  • 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.
  • Define optimal data models to support the consumption of information
  • Created SQL Objects like Complex Stored procedure, trigger, functions, views and tables
  • Performance tune Stored Procedures & long running queries by looking at query plans, IO Statistics, Joining Techniques and Indexes.
  • Created a SSAS cube, measures, dimensions, Calculations and Partitions using DB2 Named Sets.
  • Created Cube actions for Drill - down reports.
  • Developed and supported SSRS reports for various business units and Optimization of Program Metrics report, Statistical Reports and Demographics reports.
  • Interacted with user groups for delivering 30+ enterprise Reports using SSRS 2008 R2 reports for various reporting needs.
  • Created 100+ reports using iSeries/AS400, DB2 and XML for different internal business uses.
  • Written MDX queries for cubes, Performance optimization of MDX queries and for reports.
  • Regular responsibilities for updating and staging the dimensional databases as well as rebuild Dimensions and cubes in SSAS.
  • Created partitions for various counties and designed aggregations,(manual & usage based),relations, attribute hierarchies in the SSAS cubes
  • Creating dimensions and member sets in Performance point server using Planning Business Modeler.
  • Created Dashboards, score cards, KPI’s for various reporting needs.
  • Interacted with end-users, customers during various phases of the Implementations (ETL, Reporting, Production Support, Enhancements and bug fixes).

Environment: SQL Server 2008 R2, MSBI (SSAS, SSIS & SSRS) with Integrated SharePoint 2010.

Confidential, Dearborn, MI

SQL Developer

Responsibilities:

  • Technical Architect for MSBI Cubes Development and Support.
  • Project Manager for Modeling Analytics and Visualization team.
  • Design and Developing MSBI Cubes using SSAS and SSIS.
  • Creating Architecture models for Cube Development and Data Modeling.
  • Business analysis and Requirement gathering and Designing Functional Specification.
  • Coordinating with EPM, Tech Team and Migrating Code to Different Environments.
  • Responsibilities as Team Lead - Project and Resource Planning.
  • Drive Quality process and initiatives in compliance with QMS, CMM.
  • Customer communication and periodic status reporting.
  • Address day to day challenges in project execution. Collaboration with support groups such as Infrastructure Management, HR, Asset line and Service line Office.
  • Unit Creating Test Cases and data validations.
  • Involving in designing functional specs for customized Interfaces.
  • Training and Development, periodic appraisals and Development plans of associates.

Environment: SQL Server 2008 R2, MSBI (SSAS, SSIS, SSRS and Share Point Performance Point), COGNOS 8.4/10, Space Time Insight.

Confidential

ETL & B.O Designer / Developer and PL/SQL

Responsibilities:

  • As an ETL Designer and B.O Designer I was responsible for Design and Development
  • Creating new summary tables using PL/SQL procedures for aggregated BO report.
  • Loading summary table, creation of business object report and creating Ab initio extract for non- B.O users
  • Creating new Universes on the summary table.
  • Creation of ETL design document and Implementation documents.
  • Testing - unit testing & integration testing
  • Responsible for overseeing the Quality procedures related to the project.

Environment: Informatica 5.1(Power Center), Abinitio (GDE 1.12.3), and B.O 5.1.7, Unix, Windows NT, Sun Solaris 5.8

Hire Now