We provide IT Staff Augmentation Services!

Ms Sql Server Ssrs/ssis Developer Resume

0/5 (Submit Your Rating)

Detroit, MI

SUMMARY

  • Over 7+ Years of IT experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC, using MS SQL Server 2008/2005/2000 DTS/SSIS, Reporting & Analysis Services.
  • Migration of DTS - SSIS packages.
  • Hands on experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors.
  • Good experience in Query Optimization and Performance Tuning.
  • Managed reports in SSRS via Management Studio and also Report Manager by setting up permissions and RDL files.
  • Used SSRS to Ad-hoc, Cross-Tab, Drill-down and Sub-Report, customized Reports, on-demand reports and involved in analyzing multi-dimensional reports in SSRS.
  • Created many sub-reports to produce multiple results in a single view for analysis.
  • Experienced in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
  • Skilled in SQL 2005 Business Intelligence tools, ETL processes & strategies using SQL server Analysis and Integration Services.
  • Extensive knowledge of Installation, Configuration and Maintenance of SQL Server/BI Suite (2005/2008), usage of SQLCMD utilities, Creation and Management of Logins, Users, Schemas and Permissions, Transaction Logs, DBCC commands, Automation of SQL Server using Operators, Jobs and Alerts, Database Backups, Restoration and Recovery, High availability of Database using Clustering, Standby Servers, Log Shipping and Database Mirroring and Replication and Bulk Copy (BCP).
  • Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.
  • Extensive knowledge of Relational Database Management Systems using Complex Stored Procedures and Triggers.
  • Experienced in implementing Data Warehouses using SQL 2008/2005 Analysis Services creating Cubes and populating them with Dimensions and Facts.
  • Upgrade DTS packages to SQL Server Integration Services (SSIS) and Expertise in Data Transformation Services (DTS) in SQL server 2000.
  • Migration of MS SQL SERVER 2005 to MS SQL SERVER 2008.
  • Strong Experience in designing cubes, defining referenced relationships, calculated members, writing MDX queries and in identifying KPI’s in SSAS 2008/2005.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Experienced in implementing Calculated Members and Key Performance Indicators (KPIs) via MDX queries.
  • Good knowledge of Collations, Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
  • Extensive Hands on experience in troubleshooting database issues as well as migrating data from different sources like Excel and Flat files to MS SQL Server by using BCP and DTS utility.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008.

Programming Languages: T-SQL, PL/SQL, C#, VB 5.0, 6.0, Oracle and UNIX Shell Script, Perl Script.

Tools: & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, DTSxChange, Visual Source Safe(VSS)6.0, Business Objects XIR2/XIR1/6.X/5.X, Informatica, Visual Studio .NET.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MS Visio, Erwin, Crystal Reports 9.0/XI.

Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.

Data Modeling: Visio 2007 and Erwin 4.1.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

MS SQL SERVER SSRS/SSIS Developer

Environment: SSRS, SSIS, DTSxChange, T-SQL, MS SQL Server 2000/ 2008, Windows 2000/2008 servers.

Responsibilities:

  • Created Complex SQL queries, Derived tables, common table expressions (CTEs), complex stored procedures, views, indexed / materialized views, generating Cross Tab Tables (Pivot), full text Search, Distributed Queries, user defined functions (UDF), Cursors and Database triggers. Extensively involved in designing (Logical and Physical) of customer database.
  • Migration of DTS - SSIS packages.
  • DTSxChange tool to profile, convert & Monitor DTS and SSIS packages.
  • Designed data flow & control flow tasks which were unsuccessfully converted by DTSxChange.
  • Performed Unit testing of the converted packages.
  • Produced Ad-Hoc reports for testing purposes.
  • Supported specific user groups with reports based on necessary business requirements.
  • Created XML, PDF, EXCEL files using SSRS.
  • Used Pull delivery to allow employees to grab any of the reports they need and in whichever format they desire.
  • Used sub-reports and linked reports to produce results based on many different datasets.
  • Formatted the reports to display only the information that was important to the user.
  • Modified and created Stored Procedures to facilitate the datasets required by reporting services.
  • Wrote complex queries and stored procedures in T-SQL to meet new business requirements.
  • Optimized the existing queries to improve performance using SQL Profiler tools.
  • Used to support the data processing engine in database intensive operations like query Performance tuning, parallel query algorithm by writing stored Procedures.
  • Measured the existing size of the data on the relational side, plan for growth (addition of new data everyday) for a year.
  • Communicated with the team members on regular basis. The change requests had to be made for all the implementations.
  • Created XML, PDF, EXCEL files using SSRS.
  • Created different types of reports like drill down reports, drill through reports and linked reports to answer different business questions.

Confidential, Texas

MS SQL Server SSRS/SSIS Developer

Environment: MSSQLServer2005, SSRS, SSIS, Microsoft Visual Studio 2005, Windows Server 2003 Enterprise Edition, SQL Query Analyzer, Internet Information Services (IIS) version 6.0.

Responsibilities:

  • Worked closely with the requirement team and designing team for understanding the business requirement.
  • Designed and applied Entity and Attributes description and definition for the models.
  • Implemented different types of Constraints on tables designed in the data staging area for the migration.
  • Designed various SSIS modules in order to fetch the data in the data staging environment based on the different types of incoming data.
  • Designed various packages using various task e.g. For Each Loop, File System Task, Fuzzy Lookups, Multicasting various others for data cleansing.
  • Extensively used Views for complex joins queries involving multiple tables from different databases.
  • Created complex Stored Procedures, Triggers, and Functions for validation process & for loading data from the staging are to the product database in SQL 2005.
  • Implemented Views (Partition View, Parameterized Views) and other T-SQL code for making joins between the tables.
  • Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
  • Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005 Reports Services (SSRS).
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Maintained scheduling the subscription reports with the subscription report wizard.
  • Utilize SSRS (Reporting Services) to generate user/business reports provide technical support to adept to Team Lead.
  • Serve as technical expert guiding choices to implement analytical and reporting solutions for client.
  • Worked closely with DBA's deploying packages for staging/production server with shell scripts.
  • Documented all database objects, which were used in the project and for further upgrades and maintenance.

Confidential, Campbell, CA

MS SQL Server SSRS/SSIS/SSAS Developer

Environment: MS SQL 2008/2005 Server, SSIS, SSAS, T-SQL, Erwin 4.0, and Windows NT.

Responsibilities:

  • Managed the entire process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
  • Developed reporting templates to produce quicker SSRS solutions based off a base set of requirements.
  • Proactively promoted the reporting life cycle for the creation and management of business reports.
  • Created reports for auditing and testing OLAP database for data integrity or anomalies.
  • Migration of MS SQL SERVER 2005 to MS SQL SERVER 2008.
  • Designed reports using MDX and the reporting wizard to produce Drill Down and Drill Through reports to provide custom views of the information for users.
  • Worked with Oracle and MS SQL Server databases to create complex reports.
  • Created crystal reports, ODBC and database connections.
  • Created MOLAP Warehouse on SQL 2008 Server Analysis Services and created cubes with dimensions and facts.
  • Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse for each of the areas of Compliance Management, Preference Management, and Privacy Management.
  • Involved in the creation of Tables, Table Partitions, and Indexes.
  • Developed and maintained various cubes using MDX complex queries using SSAS.
  • Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
  • Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).
  • Analyzed the requirements and selected the appropriate fact tables/created fact tables.
  • Designed SSAS cube to hold summary data.
  • Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, integrity monitoring, population, maintenance, reorganization, security, and recovery of databases.
  • Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
  • Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
  • Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Confidential

MS SQL Server Developer/SSRS Developer

Environment: Windows Server 2003, MS Visio 2003,MS SQL Server 2005, SSRS 2005, T-SQL, MS office 2007.

Responsibilities:

  • Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
  • Developed stored procedures, views and functions.
  • Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
  • Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
  • Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
  • Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs for SSRS.
  • Created and maintained databases, tables, users, logins, indexes, check constraints, and business rules using T-SQL.
  • In order to perform Error Handling created each stored procedure with TRY and CATCH blocks.
  • To get the best performance for SSRS reports and applied performance tuning on various SQL procedures and created proper indexes on tables.
  • Created report snapshots to improve the performanceofSSRS.
  • Created user defined functions to split the string for the multi valued parameters and pass to the main query.
  • Involved in activities of Integration testing and deployment in various environments, like QA, staging and production.
  • Involved in various activities of generating Insert and update scripts to load the data to and from production servers to dev servers.
  • Designed and developer SSRS security architecture using Role based security model provided in SSRS 2005.

Confidential

MS SQL Server Developer

Environment: MSSQLServer2000,Visualstudio2003,DTS&BCP.

Responsibilities:

  • Created Database Objects in TSQL - Tables, Indexes, Views, and Roles.
  • Created Customized Stored Procedures, Triggers, and Cursors.
  • Involved in job scheduling using MS SQL server Agent.
  • Prepare and set up environment for Disaster recovery.
  • Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
  • Data conversions from legacy systems to SQL server Using DTS.
  • Wrote DTS scripts for data transfer
  • Responsibilities also included transferring of customer, personal financial history information from various ODBC driver files to SQL server database files using DTS.
  • Performed Data transfer (Import & Export) using BCP.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using Execution Plan.
  • Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
  • Designed and created views for security purposes, implemented rules, defaults, and User defined data types.

We'd love your feedback!