We provide IT Staff Augmentation Services!

Bi- Ssrs/ssis Developer And Sql Server Dba Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • Over 8+ years of experience in the world of IT as a SQL Developer using MS SQL Server 2005/2008/2008 R2/2012/2014, SSIS/SSRS/SSAS
  • Expert in developing Cubes on SSAS using SQL Server 2008/2005/2000 .
  • Strong knowledge in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS packages
  • Worked on Scrum Methodology as well as Open Agile and Lean
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Experience with Developing reports onSSAS & SSRSonSQL Server ( 2005/2008/2008 R2).Sound Experience and understanding ofSSAS, OLAP cube and Architecture using BIDS.
  • Good knowledge of Software Development Life Cycle (SDLC).
  • Experience in creating partitions and designing various storage modes to increase the performance of cubes using SQL Server Analysis Services 2008/2005/2000 (SSAS)
  • Used Teradata to write Stored Procedures, functions triggers.
  • Handful experience in data warehouse environment, including all dimension and fact tables.
  • Strong working experience in SQL Server and T - SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
  • Experience in writing Complex Stored Procedures, Indexed Views and DDL/DML Triggers for data consistency and manipulation.
  • Performed complex SQL, PL/SQL procedures and MDX Queries and generated reports.
  • Expertise in creating indexed tables with Primary, Foreign key constraints to maintain referential integrity.
  • Expertise in designing complex reports like Dashboard Reports, Complex Drill-Down and Drill-through Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SQL Server Reporting Services2008/2005 (SSRS) based on client requirement.
  • Expert in deploying the SSRS reports on Report Server.
  • Involved in Huge data migrations and transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) and Bulk Insert.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration Services 2008/2005/2000 (SSIS).
  • Experience in migrating from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008.
  • Experience in MS SQL Server Database Administration including Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity.
  • Significant experience in 24/7 Production Environment Support.
  • Experience in working in tight schedules, result oriented & committed to meet the goal.
  • Good communication and written skills and can handle multiple projects simultaneously.

TECHNICAL SKILLS:

Operating System: Windows 7/Vista/XP/ 2003/2002/2000 , and MS-DOS ; Mac OS X

Programming Languages: C, C++, T-SQL, C#, VB.Net, ASP.Net.

Web Technologies: HTML, XML, XLST, PHP.

RDBMS: SQL Server 2008R2/2005/2000, MS Access, Oracle 11/10g/9i

BI Tools: SSAS, SSRS, SSIS, Crystal Reports, Business Objects, MS Excel Power Pivot, MDX, SharePoint, Performance point

Data Modeling Tools: MS: Visio, Erwin 7.2/4.5, Visual Studio 2005/2008.

Database Query Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Query Analyzer, SQL Profiler.

PROFESSIONAL EXPERIENCE:

Confidentia, Chicago, IL

BI- SSRS/SSIS Developer and SQL Server DBA

Responsibilities:

  • Actively involved in business rule analysis; gathered user requirements.
  • Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that don’t have primary key.
  • Principle responsibility is to solve complex business problems by designing, implementing, maintaining and monitoring multi-dimensional cubes
  • Developed Web forms in ASP.net with VB.net and C#.
  • Designed MOLAP cubes making use of Star and Snowflake Schemas.
  • Customization of a third party tool that was used for developing the application.
  • Interacted with end-users in requirement gathering sessions, use case analysis, report layout design.
  • Used Calculated Member Builder to create custom measures.
  • Designed and developed SQL Server Integration Services 2008/2005/2000 SSIS Packages to automate the cube processing.
  • Deploying cubes and reporting services reports to Production servers generated by the offshore team.
  • Writing SQL Server Stored procedures/complex queries to retrieve data from Teradata
  • Writing MDX queries to generate OLAP reports.
  • Writing DAX queries to generate Excel and Drill to detail reports. Also created power pivot reporting from Analysis Services tabular model.
  • Created various complex reports like Dashboard, Drill Through, parameterized reports, Matrix and chart reports according to user specifications.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to end users and analysts to be reviewed in Excel Sheets.
  • Working with Tableau, Spotfire, Qlikview, Logi XML tools for reporting.
  • Writing SSIS packages to load data into Facts and confirmed dim tables to build cubes.
  • Extensively worked with SQL Server Integration Services 2008/2005/2000 SSIS to created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Multicast and Derived Column.
  • Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, and Constraints.
  • Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
  • Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
  • Installed and administered Three-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
  • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
  • Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Environment: Visual Studio 2008,2012 SSAS, SSRS, SSIS, Teradata, oracle, Power Pivot, SharePoint, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP.

Confidential, Albany, NY

SQL BI Developer SSIS/SSRS/SSAS

Responsibilities:

  • Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Developed the flow charts and diagrams as well as translation of the detailed designs with Lotus Notes application.
  • Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
  • Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
  • Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
  • Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
  • Deployed 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.
  • Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
  • Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Created different Power Pivot reports as per the client requirement.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
  • Worked on Filtered Views, views and Base table integration between different Source systems.
  • Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
  • Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
  • Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
  • Interacted with vendors, developers and customers to manage the business requirements.
  • Verified business requirements and functional specifications.

Environment: Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2005/2008/2012 , TSQL, PL/SQL 11g, Informatica, Visual Studio 2008, Sharepoint 2007/2010, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

Confidential, Dallas, TX

BI Developer SSRS/SSAS/ETL Developer

Responsibilities:

  • A thorough understanding of SQL Server Analysis Services in designing multi-dimensional cubes.
  • Working in an Agile Software design paradigm consisting three Inventory and Forecast multi-dimensional cubes for Consumer, Luxury and Professional Product divisions.
  • Integrated a massive Supply Chain POS data addition to existing CPD Inventory and Forecast cube, involving dynamic partitions and need based restatement of historical partitions using Power Shell.
  • Experienced in capturing metrics/storage behaviors of cube metadata such as partition growth statistics and aggregation limitations.
  • Developed, deployed and monitored SSIS Packages.
  • High availability to design new cubes as well as changing default configurations on the existing ones.
  • Developed and Optimized database structures, stored procedures, Triggers and Functions for the application.
  • Experience in writing client-side as well as Server-side Multi-dimensional Expressions (MDX) for incorporating data querying capability for Inventory and Forecast cubes.
  • Fine-tuned Sales, Inventory and Forecast and PEA (Performance) cubes involving 100+ calculations to channel the processing to either ETL or fine-tuned Server side MDX.
  • Hands on experience on designing need based Aggregations, Pre-Calculating in SSAS 2005 and 2008.
  • Support BAU Processes like uploading batch information, real estate upload, purging archived data.
  • Supportaccount administration activities like User Login Creation/Role creation/Role Permissions.

Environment: SQL Server 2005 SSIS, SSAS, SSRS, Oracle, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Visual Source Safe, XML, HTML.

Confidential, Omaha, NE

SQL Developer/Senior Data Analyst

Responsibilities:

  • Created dynamic and customized packages to support future changes. Scheduled the same packages by creating the corresponding job tasks.
  • Submit a Weekly Status Report to the offshore Project Manager
  • Import/Export and successfully migrated the Databases such as Oracle, DB2, ERP (Navision) and MS Access to SQL Server 2005 using SSIS.
  • Developed and Optimized database structures, stored procedures, Triggers and Functions for the application.
  • Created Configuration files with XML documents to support the SSIS packages in different environments.
  • Expertise in creating complex TSQL batches / stored procedures, Optimized existing queries and stored procedures.
  • Defined check constraints, functions, indexes, synonyms and views.
  • Experience in designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
  • ScheduledReports to run thereports hourly, daily, monthly accordingto client requirements for the periodic analysis.
  • Deployment and maintenance of various SSRS Reports in SQL Server 2005.
  • Created XML, PDF, EXCEL files using SSRS.
  • Optimized the existing queries to improve performance using SQL Profiler tools.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes for GameStop Merchandising with

Environment: Server 2000/2005 Enterprise, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), Enterprise Manager, Microsoft office share point portal server 2003 .NET, C#, ASP.NET, Red gate.

Confidential

MS SQL Server Developer

Responsibilities:

  • Created tables, views, indexes based on the requirements.
  • Wrote complex SQL queries to retrieve information from the databases depending on the requirement
  • Worked as part of a team for gathering and analyzing Business Requirements
  • Designed cubes with star schema using SQL Server Analysis Services2008/2005 (SSAS)
  • Developing OLAP cubes for migrating existing reports onto this new platform.
  • Experience in writing complex MDX queries for calculated members and measure groups
  • Responsible for stylish design layout like Pie charts, Graphs and Linked Reports
  • Played a major role in production support of SQL Server Analysis Services 2008/2005(SSAS) (cube refresh), SSIS jobs
  • Backed up databases and performed recovery as required
  • Created complex PL/SQL Stored Procedures, triggers, cursors, tables, views and other SQL joins for applications by using T-SQL.
  • Administered MS SSAS in enterprise environment that contained 6 facts and 12 dimensions, providing support in cube design, creating complex MDX queries, cube performance tuning using SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). Worked in design of scalable, reusable, and low maintenance ETL templates. Developed, monitored and deployed SSIS packages.
  • Created Company health determining measures, KPI’s as well as defining Actions, translations and perspectives.

Environment: s: MS SQL Server 2005/2008, Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, ASP.NET, XML, Windows 2003 Server

Confidential

SQL Developer/SSIS

Responsibilities:

  • Configured SQL Server Environment.
  • Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
  • Responsible for Design and Normalization of the database tables
  • Created Entity-Relationship diagrams, function relationship diagram and thus the database schema
  • Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
  • Performed job scheduling in the SQL Server Environment.
  • Used Data Modification Language (DML) to insert and update data
  • Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
  • Developed stored procedures, views and User Defined Functions using T-SQL statements
  • Developed cursors and views to improve performance in data transactions.

Environment: MS SQL Server 2000/05, MS SQL Enterprise Manager, SSIS

Hire Now