Sr. Sql Server Developer/bia Resume
Boise, ID
PROFESSIONAL SUMMARY:
- Over 8 plus years of experience in design, development & analysis of SQL Server 2014/2012/2008 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.
- Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/ 2008/2012/2014.
- Proficient in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server.
- Generated C# scripts used for Script task. Script task is primarily to control the flow of SSIS package.
- Did an end to end testing of the data in TEST and Production databases after loading the data.
- Involved in Development, Review and testing of the new system by implementing business rules and transformations.
- Extensive knowledge in developing management reports using Crystal Reports.
- Experience in creating and maintaining database and its object.
- Extensive knowledge in SQL Server 2012/2014 Developer Skills including writing user defined functions, views, query writing.
- Extensive knowledge on Oracle Forms and Reports.
- Extensively worked on SharePoint 2010.
- Worked on Tableau.
- Worked on SAP BW
- Worked on Creating Congos Cubes
- Flexible, enthusiastic and project oriented team player with solid communication and Leadership skills to develop creative solution for challenging client needs.
OLTP Experience:
- Expertise in writing complex Stored Procedures, Indexed Views and Triggers for data
- Consistency and manipulation.
- Expertise in writing and tuning Transact-SQL (T-SQL) (DDL/DML) Queries.
- Good Knowledge of Normalization/De-Normalization, Normal Form and Data Modeling.
- Proficient in SQL Server technologies such Replication, Index, Functions and Store Procedures.
- Experience in creating Indexes, Views, complex Triggers, effective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
- Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Optimization and Performance Tuning.
SSIS Experience:
- Experience in SQL Server Integration Services (SSIS):
- Strong experience in using Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with MS SQL Server 2005/ 2008/2012/2014.
- Expertise in creating Packages using SSIS for integration services.
- Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
- Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
- Worked with data extraction using SSIS and Data Warehouse staging, and loading.
- Hands on experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
- Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
EXPERIENCE:
- Experienced in defining Query for generating drill down reports in SSRS.
- Expert in designing report layout.
- Expert in AD hoc reports and different types of Tabular reports, Cross tabs, Matrix reports, Custom reports, Crystal reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS 2008/2012/2014.
- Expert in Experienced in sorting the data, defining subtotals for the reports.
- Proficient in using global variables, expressions and functions for the reports.
- Experience in Reporting Services (SSRS) 2008/2012/2014.
EXPERIENCE:
- Experience in OLAP, created Cubes, Dimensions for schemas
- Expertise in upgrading or migrating Analysis Services.
- Proficient in building Star schema and Snow Flake schema depending on business Requirements.
- Expertise hands on Cube Life Cycle
- Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
- Expertise in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
- Strong inclination for finishing job before project deadline.
- Excellent communication skills and experienced in client interaction.
- Good experience working in both Inmon and Kimball methodologies.
TECHNICAL SKILLS:
Languages: C, T-SQL, PL/SQL, JavaScript, C#.
RDBMS: SQL Server 2014/2012/2008 R 2/2008/2005/2000, 7.0, MS-Access, Oracle Database 11g/10g/9i, DB2, MySql, and Teradata V2RX.
Front End: Predisys, MS Visual Basics 6.0, Cimplicity, Crystal Reports.
Web Technologies: HTML, XML, JavaScript, PHP.
Version Controlling Tools: Star Team, Visual Source Safe, Rational ClearCase.
SQL Server Tools: SSMS, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), SSIS, SSAS, SSRS, Data Transformation Services, Jam Autosys SQL Server Agent.
Microsoft Tool: SharePoint 2010 and 2013.
Web Server Technologies: IIS 5.1/6.0.
Data Modeling Tool: ERwin r7.3/7x/4.0, MS Office Visio 2003/2007.
Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7, Unix.
Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.
PROFESSIONAL EXPERIENCE:
Confidential, Boise, ID
Sr. SQL Server Developer/BIA
Responsibilities:
- Enhanced existing SSIS Packages
- Deployed SSIS packages across development, test and production environments using project deployment model
- Improved the performance of the slow running queries by using performance tuning.
- Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & SAP BW)
- Created SSIS Packages by using different kinds of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).
- 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.
- Worked on ETL Tool for designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets to and from SQL Server using BIDS.
- Created new dimensions in the cognos cube to help business for creating reports with the new attributes
- Involved in requirement gathering and IT testing
- Worked in creating stored procedures, views, materialized Views.
- Designed OLAP cubes with star schema and multiple partitions using SSAS.
- Created reports from cube using MDX.
- Created Charts, Tabular, Matrix, Drill Down, Drill Through, Cross Tab reports using SSRS.
- Developed report specifications, created and modified reports using SSRS .
- Deployed and scheduled Reports using SQL ServerReporting Services to generate all daily, weekly, monthly and quarterly Reports including current status
- Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
- Created graphical and scripted Hana Calculation views from SAP BW tables.
Environment: SQL Server 2014, SSIS, SSRS, SSAS, PLSQL, Cognos, Visual Studio, Active Batch, Auto Etl, Dat Manager, IBM ClearQuest, SAP Hana, SAP BW.
Confidential, Omaha, NE
Sr. SQL Server Developer/SSRS/SSIS
Responsibilities:
- Designed and implemented Parameterized and cascading parameterized reports using SSRS.
- Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
- Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
- Build different types of chart reports using SSRS like column chart and Pie charts.
- Created sub reports and pass through parameters from main report to the sub reports.
- Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
- Generated various Report models on Views and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Wrote store procedures to generate account statements for different types of accounts.
- Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
- 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.
- Created SSIS packages to migrate data from Oracle to SQL Server 2008R2
- Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
Environment: SQL Server 2014, SSIS, SSRS,SSAS, Visual studio, Asp.net, C#.net.
Confidential, Norwood, MA
Sr. SQL Server Developer/SSIS/SSRS
Responsibilities:
- As a BI Developer analyzed the requirements and systematically designed the data mart for the online Services. Identified the dimensions, Fact tables and designed the data mart using star schema.
- Worked with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.
- Developed ETL Processes using SQL Server 2012 Integration Services to migrate data from Oracle data source into a SQL Server 2012 database.
- Developed report specifications, created and modified reports using SSRS 2012.
- Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status
- Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
- Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi Dimensional Expression (MDX) to access them.
- Implementing Facts and dimensions for providing views of large sets of data.
- Developed MDM Data Models, Validations Rules and Merge Rules
- Created drill down, drill through, cascading parametric and sub reports from SSAS cubes that can be browsed on web.
- Build new data Visualizations using Tableau with objectives provided by management.
- Created Custom SQL Connections and calculated fields within Tableau to facilitate automated production of data visualizations.
- Actively participated in meetings and checked for the development of the project.
Environment: SQL Server 2012, SQL Server 2008 R2, SSIS, SSRS, Jam Autosys SQL Server Agent, Visual studio, Asp.net, C#.net.
Confidential, Denver, CO
Sr.SQL Server Developer/T-SQL/ SSIS/ SSRS
Responsibilities:
- Collected business requirements from users and translated them as technical specifications and design documents for development.
- Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
- Created, altered, maintained system roles and permissions to users on various database objects.
- Designed ETL SSIS packages to process data to target databases.
- Develop the Documents for Logging/Error Handling for SSIS Packages
- Developed Stored Procedures to support ETLs and Reporting.
- Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users..
- Involved in C# coding developing SSIS Packages.
- Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
- Worked on designing packages, deploying packages and Package security.
- Created Partition on tables with SQL server 2012.
- Extensively worked on cube Life Cycle Process.
- Hands on Power view, Power Pivot.
- Extensively worked on Inmon and Kimball methodologies.
- Extensively worked with offshore teams on creating reports and packages
Environment: SQL Server 2012, SQL Server Agent, Integration Service, Analysis Services, Reporting Services, Business Intelligence Studio, Visual Studio 2008, OLE DB, HTML, XML, HTTP
Confidential, Raleigh, NC
SQL Server BI Developer/SSIS/SSAS/SSRS
Responsibilities:
- Involved in Database maintenance plan and Implemented replication. Designed and implemented data access stored procedures and triggers for automating tasks.
- Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters
- Developed Stored procedures, Views, User defined functions in line with business requirements.
- Developed SSIS packages to automate data retrieval data from Oracle, SQL Server, Excel and Flat Files using MS Business Intelligence (BI) tool.
- Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
- Scheduled SSIS packages to automate incremental load of data mart.
- Developed, scheduled and generated variety of reports like List, Matrix, Chart and Sub Report and standard template by implementing SQL Server Reporting Services (SSRS).
- Deployed and scheduled reports using SSRS to generate weekly and monthly reports.
- Worked in designing and managing SSAS projects.
- Understanding the OLAP processing for changing and maintaining the warehousing optimization dimensions, Hierarchies and adding the aggregations to the cube.
- Managed and coordinate with remote users for change request and optimization of application.
- Scheduled SQL Server Agent jobs, alerts and designed and implemented user log in and security.
- Prepare technical specifications and involve in end user training during hands off phase .
Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS),SQL Server Analysis Services, SQL Server Reporting Services (SSRS),Business Intelligence development Studio(BIDS), HTML, PL-SQL, Visual studio 2008, SVN.
Confidential, Jacksonville, FL
SQL Server BI Developer
Responsibilities:
- Worked on designing, creating and deploying ETL for SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server using BIDS
- Worked on designing packages, deploying packages and Package security.
- Created ETL packages using Heterogeneous data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
- Worked as a developer in creating Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
- Modified existing Stored Procedures according to the new user requirements during the migration process.
- Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
- Developed ETL tool for SSIS packages not only for Initial Data Loads but also for incremental/delta loads.
- Involved in writing C# scripts using script task transformation to create multiple reports based on providence Insurance client’s information.
- Developed Cross Tab, Drill Down and Drill Through reports.
- Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
- Worked with business users to gather various business requirements and implemented them while designing various SSIS packages and SSRS reports.
Environment: MS SQL Server 2005/08, SSIS 2005/08, SSRS 2005/08,C#, Visual Studio 2008, BIDS.
Confidential
SQL Server Developer
Responsibilities:
- Involved in installation and configuration of SQL server 2000 on servers.
- Defined various facts and dimensions in the data mart including Fact less Facts and designed the Data Mart defining Entities, Attributes and relationships between them.
- Implemented triggers and stored procedures and enforced business rules via checks and constraints.
- Fine tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
- Troubleshoot and minimize production down issues.
- Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
- Created, Scheduled maintenances and backup procedures to the database as a disaster recovery method.
- Generated reports using Crystal reports.
- Monitored failed and long running MS SQL Server jobs.
- Monitored, tuned, and analyzed database performance and allocate server resources to achieve optimum database performance.
Environment: SQL Server 2000, T-SQL, DTS, MS Visual Studio 2005 (SSIS, SSRS), Crystal reports 7, Windows 2000 Server, .Net Programming, VSS 4.0.