We provide IT Staff Augmentation Services!

Sql Server/ssrs Developer/power Pivot Resume

CA

SUMMARY:

  • 8+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - server Applications & Database systems using SQL Server 2000/20 R2/2012.
  • 3 years of Experience in working with upgrading of SQL server 2012.
  • Experience in professional report development using the reporting tools like oracle/cognos/crystal reports.
  • Extensive experience in PL/SQL skills.
  • Extensive experience in using Microsoft BI studio products like S SIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
  • Extensive working experience in:
  • Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
  • Writing Complex Transact SQL (T­SQL) Queries, Sub queries, Correlated sub queries, Dynamic SQL queries etc.
  • Programming in SQL Server .NET Stored Procedures, Triggers, User defined Functions and Views, Cursors
  • Performance tuning of Stored Procedures and T­SQL Queries
  • Implementing SQL Server Indexing and query optimization using Indexes
  • Good exposure or knowledge working on C#, VB.NET framework
  • Logical & Physical Data modeling, data architecture designs etc.
  • Understanding existing data models, data flows and data dictionaries
  • Creating new data models, data flows and data dictionaries
  • Normalization and De normalization techniques
  • Involved in Backing up databases and refreshing Data across environments
  • Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
  • Creating data load and Upgrade scripts for data migrations, data formatting and data validations
  • Implementing all high availability techniques like clustering, log shipping, replication
  • Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
  • Scheduling and Monitoring ETL Processes using DTS Exec utilities and b atch files.
  • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, a nd M S Excel spread sheets and P ower Pivot.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
  • Experience in creating Adhoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling for F ACT and Dimensions Tables using Analysis Services.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi­dimensional expression ( MDX), Perspectives and Roles.
  • Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
  • Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Created Dashboard pages in SharePoint Server that use different types of web parts and e xcel services for reports
  • Created Scorecard/Dashboard pages in Performance point server (PPS)
  • Used ProClarity tool to analyze the data in the cube by using different features like C hart view, Decomposition Tree, Performance Maps, etc.
  • Generated reports from Analysis Services cube by using ProClarity tool.
  • Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Good team player, Excellent interpersonal and c communication skills combined with self-motivation, initiative and the ability to think outside the box.
  • Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS:

Languages: T­SQL, PL/SQL, Dynamic SQL, MDX, C, C++,XML, HTMLDHTML, HTTP, Shell Scripting

Databases: MS SQL Server,2012,2008R2,2008,2005,2000

DWH / BI Tools: SQL Server Integration Services ( SSIS), SQL Server Reporting

Services ( SSRS), SQL Server Analysis Services (S SAS), Business: Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design: Tools: and Data

Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De­normalization techniques.

Packages: MS Office, Microsoft Office Suite, Microsoft Office SharePoint

Server: (MOSS) 2007, Microsoft PerformancePoint Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise ManagerSQL Server Profiler, Import & Export Wizard, Visual Studio .NetMicrosoft Management Console, Visual SourceSafe 6.0, DTSBusiness Intelligence Development Studio (BIDS),Crystal ReportsPowerPivot, ProClarity, Microsoft Office, Excel PowerPivot, Excel Data Explorer.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS­DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, CA

SQL Server/SSRS Developer/Power Pivot

Responsibilities:

  • Modified and created the SSRS reports based on the client requirement.
  • Created efficient stored procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Developed tables, views using SQL server Management studio.
  • Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
  • Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
  • Write, maintain and update technical documentation.
  • Developed and altered research analyses reports with Excel, Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLookup and formulas.
  • Conducted Unit testing on reports generated using SSRS.
  • Extensively used J oins and common Table Expressions to simplify complex queries involving multiple tables
  • Worked on Claims data, Adhoc reports.

Environment: SQL Server 2008, Reporting Services (SSRS), Integration Services (SSIS), T­SQL, Windows XP/7, MS Excel.

Confidential, Eden Prairie, MN

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Created numerous efficient S tored Procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
  • Worked in Agile Methodology to efficiently deliver the project on time.
  • Worked on Hedis Measures, Created matrix, tabular, drilldown and drill through reports.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Created Tables, Stored procedures and defined functions. Modified SQL scripts for tuning and scheduling.
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS) .
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Migrated and resolved conversion errors for PerformancePoint Server reports to SharePoint 2010 Business Intelligence platform.
  • Experience working in the production environment for the two major releases at O PTUM and also have experience working as a QA analyst, has experience working on ALM Tool as a part of testing the defects.

Environment: SQL Server 2008, Reporting Services (SSRS), Integration Services (SSIS), T­SQL, Windows XP/7, MS Excel.

Confidential, Plano, TX

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Optimized the performance of queries with modifications in T­SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Developed Pl/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created numerous efficient S tored Procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as S SIS 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 S SIS P ackages 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 S QL scripts .
  • Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
  • 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.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
  • Worked on Database Compression for different databases to save space across different environments.
  • Wrote many s tored procedures for cleaning, manipulating and processing data between the databases.
  • Extensively used J oins and C ommon 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 r eports using SSRS.
  • Created different P owerPivot reports as per the client requirement.
  • Migrated and resolved conversion errors for Performancepoint Server reports to S harepoint 2010 Business Intelligence platform.
  • Repaired/recreated PPS reports damaged in the conversion process.
  • 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: Windows 2003 Advanced Server, ODBC, MS SQL Server 2005/2008/2012 , T­SQL, Visual Studio 2008,Oracle, SSRS, SSIS, Erwin.

Confidential, Pittsburgh,PA

SQL BI developer

Responsibilities:

  • Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and

Tables, Views and SQL joins and other statements for various applications.

  • Performance tuning of the stored procedures, User defined functions and long running queries.
  • Automated the ETL to import and export data from text/ Excel file, in different format, to SQL Server and vice versa using S SIS.
  • Analyzed and designed business processes as per the business requirements with SSRS reports
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
  • Extensively used UltraEdit to verify the text file provided by employer/agency and keep trace of files provided by employer/agency
  • Transformed data from t ext file to SQL server using OLE Automation Objects
  • Created various dynamic reports using S SRS and C rystal reports.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures to migrate data from SQL server database to oracle database.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of S QL Server Analysis(SSAS) a nd used the SSAS as source for generating parameterized reports in S SRS.
  • Used ROLAP tools to access the data in a relational database and generate SQL queries to calculate information at the appropriate level when an end user requests it.
  • Created reports and Data access from MDX, OLAP and Cubes
  • Created SSIS Packages to pull data from Online Database Server to Data­warehouse Server.
  • Performed administration tasks of Database Mirroring, database backups and restore servers in SQL Server 2005.

Environment: MS SQL Server 2005/2008, OLAP, ROLAP, Visual Studio 2005/2008, Windows 2007, Windows XP, T­SQL, XML, Crystal Reports, SSAS, SSRS, SSIS.

Confidential, Seattle, WC

SQL Developer

Responsibilities:

  • Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T­SQL in Development and Production environment for SQL Server 2008.
  • Migrated D TS packages from SQL Server 2000 to SQL Server 2008 as S SIS Packages.
  • Optimized the performance of queries with modifications in T­SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • 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.
  • Created SSIS packages to validate, extract, transform and load data to data warehouse databases..
  • Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
  • Migrated old data from MS Access into S QL Server 2008 using S SIS P ackages in Business Intelligence Development Studio.
  • 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.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
  • Worked on Database Compression for different databases to save space across different environments.
  • Wrote many s tored 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 D rill­through reports, parameterized reports and l inked r eports using SSRS.
  • Experience in creating Multidimensional cubes using SSAS a nd designing DW schemas.
  • Created DSV, Cubes, and Dimensions, MDX for SSAS Reports.
  • Migrated and resolved conversion errors for PerformancePoint Server reports to Sharepoint 2010 Business Intelligence platform.
  • Repaired/recreated PPS reports damaged in the conversion process.
  • 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: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential, Mt. Laurel, NJ

MS SQL / BI Developer

Responsibilities:

  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Created Tables, Stored procedures an d defined functions. Created SQL scripts for tuning and scheduling .
  • Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services .
  • Provided Full Reporting Life Cycle support using S QL Server Reporting Service 2008 .
  • Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services ( SSRS) .
  • Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
  • Created linked, unlinked and on­demand SubReports.
  • Understood the various complex reporting requirements of company and created web reports using Reporting Services.
  • Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
  • Optimized the performance of queries with modifications in T ­SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Established Inner Join, Outer Join and created Indexes whenever necessary.
  • Modified report content and exported reports in multiple formats based on user input.
  • Developed logical and physical data models, design data access strategies and wrote S QL code to access and manipulate data stored in relational databases.
  • Involved in implementing Key Performance Indicator ( KPI) Objects in S SAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
  • Created User Defined functions for sharing formulas across multiple reports.
  • Modified existing reports according to requirements of the end users.
  • Gathered business requirements from customers and created status reports .

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T­SQL

Confidential, Houston, TX

SQL/MSBI Developer

Responsibilities:

  • Managed the migration of SQL Server 2000 databases to SQL Server 2005
  • Created Tables, Stored procedures an d defined functions. Created SQL scripts for tuning and scheduling .
  • Fine­tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
  • Developed physical data models, data warehouse models and created D DL scripts to create database schema and database objects.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
  • Developed various operational, drill­through and drill­down reports using SSRS.
  • Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
  • Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Involved in the Data modeling, Physical Design of Database using tools like Erwin.
  • Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.
  • Performing Replication ( snapshot and transactional).
  • Experience in Designing, Building the Dimensions, c ubes with star schema u sing S QL Server Analysis Services (SSAS) f or analyzing purpose.
  • Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the O LAP reporting needs
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
  • Configured replication servers and transactional replication between production & standby server for disaster recovery
  • Created calculated measures and dimension members using multi­dimensional expression ( MDX) .
  • Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: SQL Server 2000/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 9i/8i, T­SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access.

Confidential

MS SQL Server Developer

Responsibilities:

  • Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
  • Writing Complex Transact SQL (T­SQL) Queries, Subqueries, Correlated subqueries, Dynamic SQL queries etc.
  • Programming in SQL Server ­ Stored Procedures, Triggers, User­defined Functions and Views, Cursors
  • Generated database monitoring and data validation reports in S QL Server Reporting Service (SSRS ).
  • Created partition table for very large database for good performance.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Responsible for writing SQL queries, stored procedures, views, triggers, T­SQL and DTS/SSIS
  • Deployed SSIS packages and Reports to Production Servers.
  • Involved in creation of Data warehouse Cubes in SQL Server Analysis Service (SSAS) .
  • Migrated data using ETL Tool in S SIS.
  • Maintained system monitoring jobs and provide high availability support.
  • Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
  • Participated Databases Architecture and data modeling design.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • Reported all events and requirements through established reporting mechanisms in SSRS.
  • Reviewed and developed data models and database designs with development teams
  • Wrote store procedures for some job automations.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
  • Designed and developed M S SQL Server R eporting Services(SSRS) under SQL Server 2005

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential

SQL Server Developer

Responsibilities:

  • Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
  • Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
  • Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
  • Implemented Exceptional Handling
  • Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
  • Creating and automating the regular Jobs.
  • Tuned and Optimized SQL Queries using Execution Plan and Profiler
  • Rebuilding Indexes and Tables as part of Performance Tuning Exercise
  • Involved in performing database Backup and Recovery
  • Worked on Documentation using MS word

Hire Now