We provide IT Staff Augmentation Services!

Sql Server Bi Developer (ssrs/ssis) Resume

New Berlin, WisconsiN

SUMMARY:

  • 7+ years of experience as SQL Server Developer/Admin/Business Intelligence Developer. Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.
  • Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases.
  • Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.
  • Experience with SQL Server 2000, 2005, 2008 and Denali 2012.
  • SQL Server R RDBMS database development including T - SQL programming.
  • Proficient in T-SQL queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, and DDL etc.
  • Proficient in Performance Tuning of SQL query.
  • Good Understanding of Isolation Level, MOLAP, ROLAP, HOLAP, Normalization, De Normalization,
  • Partitioning, ACID Property, Data Warehouse, Bill Inmon methodology, Ralph Kimball methodology, Star flake schema, Snowflake Schema, SSAS Dimension Attribute Properties and etc.
  • Excellent in MS SQL Server 2005/2008 suite of products like SSIS, SSAS and SSRS.
  • Good experience in developing reports using SQL Server (SSRS)
  • Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and PowerPivot.
  • Experience in Visual Studio Team Foundation Server, Visio
  • ETL experience across Oracle, Access, MySQL and Excel
  • Proficient in writing MDX query and good knowledge of all MDX Functions
  • Experienced in Database Administration
  • Experience in making formal and informal presentations to technical and non-technical staff
  • Expert in Creating and managing roles for security in SSRS reports.
  • Experience developing BI/dashboard components using tools like BIDS, PerformancePoint and PowerPivot.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
  • Experience in implementing high availability process like log shipping, Mirroring, and Clustering.
  • Experience in deploying created reports in various sources like Web browser, XML and PDF.
  • Excellent experience in Crystal report. Use tables, view, Store Procedure as data Source.
  • Handle ODBC, OLEBD. .net Object as Crystal Report Data Source, write Complex Crystal Formula to format report as business logic and also work with parameters.
  • Very good experience of Crosstab Crystal Report to provide unlimited dynamic column in report.
  • Sub Report in Crystal report to Generate section wise.
  • Export and mail Crystal report data with different type and format.
  • Active Directory Basic operation and integration with related application for directory entity.
  • Manage Group, Role, Organizational Unit almost the whole profile of user.
  • Manage Centrify Zone for Mac or Linux users to use active directory users.
  • Over All idea of application design and development in .net.
  • Familiar with Agile methodology in software development.

TECHNICAL SKILLS:

RDBMS/DBMS: MS-SQL Server 2014/2012/2010, 2008R 2/2008/2005/2000, Oracle 11g/10g/9i/8i, Teradata V2R5, MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: UNIX, W indow s NT/XP /Vi sta/7/2008, Mac

Programming Languages: T-SQL, C, Java, C#, T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++

I nternet Tec hnologies /Tools: ASP.NET, Java Sc ript, VBSc ript, XML, C SS, HTML, Ra tiona l R ose, MS Office, Visua lStudi o200 8/2005, DTS, SSAS, SSIS, SSRS, VSTF.

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, SSAS, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, New Berlin, Wisconsin

SQL Server BI Developer (SSRS/SSIS)

Roles and Responsibilities

  • Installed, configured, maintained and supported SQL server 2010 and 2012 in different environments.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Migrated objects from SQL to Oracle using SQL developer.
  • Created tables, indexes, views, aliases and constraints.
  • Worked with T-SQL, DDL, DML and DCL
  • Created and executed SQL statements in both SQL production and development environments.
  • Provided SQL Support to front end users.
  • Create SSIS and DTS packages to process the data. Make use of various Control Flow and Data Flow items from Toolbox. Perform Error handing and version log using Event Handler.
  • Work with data analytic to check and manage SQL Server performance
  • Work in store procedure to prevent SQL Injection
  • Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
  • Manage Large Scale Store procedure and tuning to reduce execution time
  • Developed and maintained a backup and recovery strategy for all databases.
  • Work with EVENT MANAGER to manage the whole scheduling reports and manage recipient scheduling.
  • Used Report Manager to assign roles, permissions and to create report schedules.
  • Configured Reporting Services to a scale out deployment to allow concurrent users.
  • Created schema and Virtualized SQL server tables in Composite Studio 6.2 to provide Composite ODBC access through excel to business users for analyzing data.
  • Used Lookups Transformation to get the data from data sets
  • Created permanent tables, temporary tables and table variables.
  • Used Joins to write queries that retrieve data from more than one table.
  • Responsible for hiding and disabling attributes and attribute hierarchies.
  • Implementing the calculations to aggregate physical measures.
  • Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
  • Developed SQL scripts, ensured optimal performance of the queries to generate reports from various relational databases like Oracle.
  • Created report snapshots to improve the performance of SSRS.
  • Created SSRS report to read blob data for various types of images from a SQL table
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
  • Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, to SQL Server
  • Created Data Stage Job to load data from SQL server 20012 to Oracle 11g.
  • Created complex SSIS packages using various transformations.
  • Created SSIS package to load multilevel XML data into Oracle database.
  • Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Created stored procedures to retrieve data from CDC enabled tables to load all deltas into destinations.
  • Created SSIS package to loop through multiple shared folders for multiple file servers to get all the files along with file path and folder names.
  • Developed backend SSIS package to transfer data from SQL to DB2 database using WMQ application
  • Created SSIS package to transfer data from Share Point 2010 to SQL database using Share point List Adapters.
  • Created Event Handlers for the SSIS package on Error, on Post execute.
  • Used named calculations and new named query cubes to calculate values at run time.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created stored procedures to load data into fact tables and dimensions tables for spot fire reporting dashboard
  • Crystal Report with SQL Server, Use Tables, view, Store Procedure as data Source
  • Write Complex Crystal Formula to format report as business logic
  • Crosstab Report with Crystal Report to provide unlimited dynamic column in report.
  • Sub Report in Crystal report to Generate section wise
  • Export and mail Crystal report data with different type and format.
  • Active Directory Basic operation and integration with related application for directory entity.
  • Manage Group, Role, Organizational Unit for users in Active directory
  • Manage User’s Profile and access in Active Directory
  • Manage Centrify Zone for Mac or Linux users to use active directory users.

Environment: SQL Server 2012,2010,2008 Control-M Manager, DTS, SharePoint, Visual Studio 2008,SSRS2008, T-SQL, Visio 2010, Crystal Report2011,.Net,Enterprise Manager, Windows Server.

Confidential, NC

MS SQL Server Developer/SSRS

Roles and Responsibilities

  • Involved in new databases design and creation using Rational Rose.
  • Designing and Developed queries using Microsoft visual studio 2008 R2.
  • Created Database Diagram using third party tool Erwin in beginning of the project, identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
  • Created database and database objects like tables, stored procedures, power views, triggers, rules, defaults user defined data types and functions with T-SQL to facilitate data consistency.
  • Created multiple hierarchical aggregates for faster performance.
  • Interacted with Business Analyst to understand the business requirements and implemented the same into a functional Data warehouse design.
  • Good working skills in optimizing the SQL to improve performance. Written UNIX Shell scripts for Informatica ETL Tool.
  • Created perspective of the cube to simplify the process of browsing for the end users.
  • Supported all production operation activities with focus on integration and development of new and existing products and services., control, and automation opportunity to improve overall access to information.
  • Created report snapshots to improve the performance of SSRS.
  • Liaised with project management and development teams to identify and implement reporting
  • Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure reports with error description.
  • Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
  • Administrated the created reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2005, T­SQL, Window 200 Advanced Server, ETL, SQL Server Integration Services, SQL Server Reporting Services, Oracle 9i/11g SQL Server Analysis Services. UNIX, XML, Flat Files.

Confidential, Menlo Park, CA

SQL Server SSIS/SSRS Developer

Roles and Responsibilities

  • Designed and implemented stored procedures and triggers for automating tasks.
  • Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be power viewable in the cube.
  • Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs.
  • Involved in writing MDX Scripts for the OLAP CUBES.
  • Developed multidimensional Objects (Cubes, Dimensions) using MS Analysis.
  • Created Analytical Reports using ProClarity tool.
  • Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting, so create reports that draw content from a variety of data sources.
  • Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
  • Deployed SSRS Reports in SharePoint for web based access for multiple end users
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Created reports using stored procedure and also involved in scheduling, creating snapshots and subscriptions for the reports SSRS.
  • Involved in improving the performance of the system.
  • Developed and executed several optimized queries in SQL.
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Deployed SSRS Reports in SharePoint for web based access for multiple end users.

Environment: Windows XP, MS SQL Server 2008R2, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential, Cleveland, OH

SQL BI Developer

Roles and Responsibilities

  • Experienced in creating different types of reports Drill down Reports, drill through reports, parameterized reports, crystal report, matrix reports, tabular reports, chart reports as per the user request.
  • Created Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
  • Worked for Web sales department to create, test, distribute and maintain Crystal Reports.
  • Partnered with various Business lines to improve existing reports and create new control reports to reduce errors and streamline the process.
  • Provide suggestions to assigned business line to streamline reporting and procedures as necessary.
  • Built the SSRS reports from Different Databases like Oracle and SQL Server.
  • Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Pulled the data from DB2 Server by using open queries and SSIS Packages to load data into SQL Server database to create SSRS Reports.
  • Creating Indexes and used Scan and Seeks for performance tuning.
  • Created dashboard reports (daily, weekly, and monthly) for the upper management to monitor the Home Equity loan performance.
  • Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
  • Deployed the report rdl files to the report manger (or) share point site to make report visible for user by using web server link, it’s easy for upper management to view the reports in report manager or share point site.
  • Utilized functions in DB2 Queries to concatenate, finding date differences, finding date part, finding part of the string in DB2 Server which are different from SQL Functions.
  • Worked on Team Foundation Sever 2008 to store (check in or check out) the sql queries, packages, and reports to share them with the team members. Even if the local system crashes down we can able to use the code from TFS.
  • Documented the process (Upper management reports) of pulling the data from DB2 Server and load it into the SQL Server tables, so that it could be used as a manual for new hires and for audit validations.
  • Responsible for interacting with business users to learn the business requirements and business functionality to improve the reporting process.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files etc. to SQL Server using SSIS/DTS packages using various features.
  • Involved in Creating SSIS Packages to pull the data from DB2 Server, Flat files and Excel Files then load the data into the SQL Server table destination.
  • Utilized different types of task’s (Execute SQL task, Data flow task, For Loop Container, For each Loop Container, Bulk Insert task) to load the data from source to destination based on business requirement with all conditions applied by task functionality.
  • Used different transformations (Derived Column, Data Conversion, Condition Split, Lookup transformation, multicast, and script component transformation) under Data Flow Task while pulling and loading data from one source to another source to makes the data clean and consistent.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Responsible for creating and scheduling the jobs to run store procedures and SSIS packages on daily manner to automate the loading process by using SQL Server Agent, adding new steps to the existed jobs in the SQL server agent.

Environment: Enterprise Manager, SQL Server 2008/2012, Control-M Manager, Oracle 9i/10g Visual Studio 2008/2012, SSIS, SSAS, SSRS, C #, T-SQL, Performance Tuning, Visio 2010, Windows Server.

Confidential, St Petersburg, FL

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Responsible for creating SSIS packages to extract data from different sources to consolidate and merge into one single source.
  • Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
  • Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
  • Created SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
  • Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Design, deployment, and maintenance of various SSRS Reports in SQL Server 2012.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Created different types of SSRS reports like linked reports, tabular reports, charts, sub-reports, drill-down and various parameter based reports like drop down, Multi-Valued, Multi-select.
  • Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
  • Created Ad-hoc reports Using Report Builder, Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
  • Deployed SSRS reports to SharePoint Integrated Server mode and later used these reports on different Dashboard tabs.
  • Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates Named Set, MDX Query and Custom Table
  • Configured the Dashboard zones and connected different dashboard components to achieve Cascading Parameters and Parameter driven reports.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Created subscriptions to provide a Daily/Monthly/Quarterly basis reports.
  • Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
  • Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2012. Developed reports from OLAP cubes.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
  • Created usage based aggregations in cube to minimize time for query retrieval from client tool.
  • Managed and troubleshoot report server related issues.
  • Involved in Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
  • Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
  • Created logging, custom logging and error handling packages.

Environment: s: MS SQL Server 2012. Windows Server 2003/2008 and VM ware. ERWIN, SSRS, SSIS, SSAS, Litespeed, VERITAS netbakups, MS Excel PowerPivot, Windows7 and Windows 8, Performance Point Dashboard Designer, MS SharePoint Server 2010.

Hire Now