Sql Server Developer/ssis/ssrs/ssas Resume
TennesseE
SUMMARY:
- 8+ of IT Experience in Database Design, Development, Implementation and Support of Microsoft SQL Server 2008/2005/2000 in Development, Testing and Production Environments with various business domains like Financial, Banking, Communications, and Healthcare.
- Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL
- Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
- Experience in maintaining one to many and many to one relationships while moving data between two databases.
- Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
- Expertise in writing T - SQL Queries, Dynamic-queries, subqueries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and
- Cursors.
- Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
- Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
- Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
- Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
- Experience in ETL processes involving migrations and in sync processes between two databases.
- Experience in Microsoft Visual C# in script component of SSIS.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
- Experience in creating configuration files to deploy the SSIS packages across all environments.
- Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
- Defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
- Performance Oriented in Developing and Extending Cubes, Dimensions and Data Source Views,
- Data Mining Models and Deploying and Processing SSAS Objects.
- Worked with report manager for deploying the reports across all the environments.
- Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
- Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
TECHNICAL SKILLS:
Languages: C, T-SQL, PL/SQL
RDBMS: SQL Server 2012/ 2008/2005/2000, 7.0, MS-Access, Oracle Database
Front End: MS Visual Basics 6.0.
Web Technologies: HTML, XML, JavaScript, PHP
SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services, EDI.
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, Tennessee
SQL Server Developer/SSIS/SSRS/SSAS
Responsibilities:
- Analyze the user story raised by business and create a technical impact document for the fix and enhancement
- Analyzed the requirement, designed and developed a SSIS package for business transformations.
- Analyzing and developed/modified stored procedures based on client business needs in SQL Server. Also taking care of SQL query optimization and performance tuning.
- Developed the SSRS reports for business needs.
- Preparing the Technical design document, Test case document and Unit testing for the developed package and modified stored procedures.
- Analyzed the requirement, designed and developed a stored procedure, triggers, functions and partitions for encounter inbound business needs.
- Involved in SQL query optimization and performance tuning.
- Analyzing and developed the SSIS packages for the migrating the encounter data between the systems.
- Analyzed, Developed and deployed the SSRS reports for business needs.
- Preparing the Technical design document, Test case document and Unit testing for the developed package and modified stored procedures.
- Coordinating offshore team for day to day activities and updating the senior management on project status periodically.
Environment: Microsoft SQL, MSBI tools
Confidential, California
SQL Server Developer/SSIS/SSRS/SSAS
Responsibilities:
- Responsible for writing recursive CTEs, CTE, temp tables and effective DDL/DML
- Worked on data migration SSIS packages.
- Worked on QNXT provider’s module for data filtration, data manipulation and data cleanup.
- Worked on scripting of data cleanup sql codes based on requirements in comparing QNXT data.
- Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
- Involved in TFS setup, aligning scripts in tfs, code checkin and checkout activities.
- Responsible for writing T-SQL Queries, Dynamic-queries, subqueries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors. Testing stored proc, developing test cases and test scenarios
- Worked on Ad-hoc requirements and various complex bug fixes.
- Responsible for month end maintenance activities and large data pulls using SSIS packages.
- Familiar in drafting user stories and carrying out the stakeholder meets.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
- Used spreadsheets for reporting server.
- Developed and tested system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication.
- Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls.
- Created power pivot file and power view reports in excel.
- Extensively worked on data extraction, Transformation and loading data from various sources like
- Oracle, SQL Server and Flat files.
- Created parameterized reports, Drill down and Drill through reports using SSRS.
- Responsible for performance tuning.
- Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
- Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
- Scheduled batch jobs; ran daily SSRS reports
- Developing SSIS packages to extract transform and load the data from multiple flat files, excel files.
- Configuring SSIS packages using package configuration wizard to allow packages run on different environments.
- Develop SSIS packages to load the data into data marts.
- Worked in accordance with HIPAA standards.
Environment: Microsoft SQL, MSBI tools
Confidential, Redmond, WA
SQL Server Developer/SSIS/SSRS/SSAS
Responsibilities:
- Responsible for writing recursive CTEs, CTE, temp tables and effective DDL/DML
- Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
- Responsible for writing T-SQL Queries, Dynamic-queries, subqueries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors. Testing stored proc, developing test cases and test scenarios
- Responsible for building the SSAS tabular model. Involved in writing MDX queries and performance optimization of the SSAS cubes
- Working on Microsoft big data COSMOS.
- Experience in writing scope scripts.
- Working in AGILE environment, comfortable working in high pressured environments.
- Worked on Ad-hoc requirements and various complex bug fixes.
- Responsible for month end maintenance activities and large data pulls from COSMOS and CUBES using SSIS packages and scope scripts.
- Familiar in drafting user stories and carrying out the stakeholder meets.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source
- (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
- Used spreadsheets for reporting server.
- Developed and tested system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication.
- Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls.
- Created power pivot file and power view reports in excel.
- Extensively worked on data extraction, Transformation and loading data from various sources like
- Oracle, SQL Server and Flat files.
- Created parameterized reports, Drill down and Drill through reports using SSRS.
- Worked on formatting SSRS reports using the Global variables and expressions using team foundation server 2010.
- Responsible for performance tuning.
- Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
- Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
- Scheduled batch jobs; ran daily SSRS reports
- Developing SSIS packages to extract transform and load the data from multiple flat files, excel files.
- Configuring SSIS packages using package configuration wizard to allow packages run on different environments.
- Develop SSIS packages to load the data into data marts.
Environment: Microsoft SQL, PostgreSQL, TL (SSIS) and Reporting (SSRS) and Supporting.
Confidential, Idaho, Texas
SQL Server Developer/SSIS/SSRS/SSAS
Responsibilities:
- Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
- Creating joins and sub queries for complex queries involving multiple tables.
- Optimized query performance by creating indexes.
- Using DDL and DML for writing triggers, stored procedures, and data manipulation.
- Created several SSIS Packages to pull data from SQL server and Flat files into Excel sheet and to archive the data as per the business logic.
- Requirement gathering and creating mapping specs.
- Developed web site and web applications using HTML, DHTML, JavaScript, JQuery, XML, AJAX, Classic ASP, PHP, SQL Server, MySql, PostgreSQL, Adobe Flex 3.
- Ported EDMS from Windows(SQL/Oracle/IIS) to Linux(DB2/Postgres/Apache/PHP)
- Designed and developed REST based web services in Java for accessing external data in both Postgres and HDFS. Also included necessary business logic.
- Created custom reports from new ERP Systems, one utilizing SQL Server on its back end and Crystal Reports for its reporting tool and the other ERP system utilizes PostgreSQL on its back end and requires the use of Crystal Clear a Java based Crystal Report like tool
- Created various SSIS packages which would load raw physical data into the tables of the databases.
- Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
- Designed, implemented and maintained UNIX-based custom statistics collection package.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
- Used spreadsheets for reporting server.
- Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services SSAS.
- Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies and defined Dimension Relationships.
- Developed and tested system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication.
- Assessing reporting requirements to Epic Users through necessary investigations, analysis and evaluation to generate desired reports. Evaluating requests for completeness and working with Epic User if needed to finalize the request
- Generating complex reports including design, documentation, configuration, testing, implementation and ongoing support for the existing Reports.
- Validating the Reports in Clarity Production Database Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls.
- Created power pivot file and power view reports in excel.
- Developed web-based reports, scorecards, and dashboards.
- Created reports with multiple views in power view.
- Strong experience in Data Warehousing and ETL using SSIS.
- Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
- Created parameterized reports, Drill down and Drill through reports using SSRS.
- Worked on formatting SSRS reports using the Global variables and expressions using team foundation server 2010.
- Assign permission to user(s), role(s) and object. Administrate security for server logins (Windows and SQL server account).
Environment: Microsoft SQL, PostgreSQL, TL (SSIS) and Reporting (SSRS) and Supporting.
Confidential, Ann Arbor, Michigan
SQL Server Developer/SSIS/SSRS/SSAS
Responsibilities:
- Plan, design, and implement application database code objects, such as ITSM, CONCUR, Assure NET, KRONOS, and LOFTWARE.
- Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
- Involved and supported users with ITSM incidents and Change management issues.
- Implemented Service Now and migrated data from ITSM databases to Service Now.
- Resolved issues on Concur Travel and expenses configuration issues, configured Audit rules and Cognos reports.
- Mysql 5.1 and Postgres database implemented for syslog and linux stats capture and logging. ETL process desgined for both databases for different teams, linux sysadmins and devops.
- Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
- Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
- Attended Service Now demo sessions with vendor and implemented.
- Customized and configured Kronos Jobs for accruals and Reports.
- Upgraded Kronos application from 4.3 versions to 6.3 Version also upgraded SQL version 2000 to 2012, modified GEM - Kronos and HR DB - Kronos interfaces.
- Given Support to User issues on Kronos Clocks.
- Migrated from ITSM to Service now with along with vendor. Customized the application reports and worked as Service Now admin.
- Mysql and Postgres systems documented and teams mentored on the usage of syslog ETL systems to each database.
- Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
- Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
- Proposed Kronos upgrade project to Client including SQL server upgrade.
- Experienced in extracting data from Development / UAT / Production servers by using SSIS.
- Provide database coding to support business applications using T-SQL.
- Experienced with Clustering setup and Active Directory in Windows 2010.
- Develop new processes to facilitate import and normalization, including data file for counterparties.
- Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
- Involved in Database Modeling, Database Mapping, And Normalization Using ERWIN.
- Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
- Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
- Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL
- Server Integration Services (SSIS) for data integration from heterogeneous data sources, ad-hoc request and ETL related operations.
- Experience in creating Multidimensional and Tabular modeling using SSAS and designing DW schemas.
- Supported 24X7 in production issues and User’s issues on applications.
Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, PostgreSQL, backup/restore, MS Office suite 2003
Confidential, Grand Rapids, MI
SQL Server Developer
Responsibilities:
- Involved in beginning of the project, updated existing database from SQL server 2005 instances to SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
- Design primary-standby databases (Manual log shipping to the same servers) setup for existing applications running in SQL server 2008 Standard Edition and Enterprise Edition.
- Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
- Installed, configured, operated and troubleshot Windows SharePoint Portal Services. Created and maintained websites using Windows SharePoint Team Services.
- Involved in Design of Data warehouse using Kimball and Star Schema.
- Created XML files by using SSIS Package Configuration.
- Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software
- System Requirements (SSR). Created test cases and test scripts.
- Moved SQL server objects among test, QA and Production environment. Took full, differential and
- Transactional backup of databases often and moved them to external tape storages.
- Used DDL to define indexes (keys), specifies links between tables, and imposes constraints between tables.
- Delivered SharePoint training to users and administrators.
- Worked with IBM Rational Clear Case and Rational Clear Quest to automate and enforce the development processes and aid with configuration management.
- Audited database user’s audits using SQL profiler and costumed stored procedures/packages.
- Loaded flat files into stage tables by using Bulk Copy Program BCP and DTS packages. Scheduled database jobs for automation of DBA tasks.
- Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
- Developing various simple to complex reports using different Reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports and Business Objects.
- Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources and ETL related operations. Partitioned large tables’ 1.2 million rows tables using range partition.
- Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression (MDX)
- Providing high availability SQL Server solutions, including Log shipping, Mirroring, Snapshot and Replication.
- Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
- Developed complex reports and provided to business people for further analysis. Responsible for make changes in application according to business logic.
- Faced, resolved connectivity issues and ODBC with front end application languages ASP.net, VB.net and C#.net. Responsible for connectivity issues to the database, IIS 6.0 and Veritas Cluster software among servers.
Environment: Windows NT/2008, MS SQL Server Management Studio 2008 R2, T-SQL, DTS, SSIS, SSRS, SSAS, TFS, Replication, Oracle 9i, Rational Rose, Informatica 8.6, PL/SQL, SQL*Plus, SQL*Loader, Shell scripts, .NET Framework 4.0, VB.NET, C#.net, Visual Basic 7.0, Visual Studio 2008, ERwin 4.0.5, ODBC, AIX 5.3
Confidential
SQL Server Developer/SSIS/SSRS/DBA
Responsibilities:
- Involved in Requirements Gathering to define data requirements for reporting warehouse.
- Migrated databases from SQL Server 2005 to SQL Server 2008.
- Installed and maintained MS SQL Server 2008.
- Involved in designing the Logical and Physical data models for the data warehouse using Erwin 7.0.
- Created tables, stored procedures, views, functions, and triggers using T- SQL.
- Involved in database designing using Normalization.
- Created the clustered/non-clustered indexes on tables, and traced out for any table required any indexes and determine the type of index on it.
- Created triggers to enforce complex business rules and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
- Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *. Txt file, *.CSV files.
- Used various transformations such as Slowly Changing Dimension, Multicast, Merge Join,
- Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
- Responsible for creating batch files and scheduling the jobs.
- Developed cubes for reporting based on the business requirements using SSAS 2008.
- Identified KPIs and created different scorecards and dashboards.
- Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
- Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
- Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008.
- Developed complex stored procedure using T-SQL to generate ad-hoc reports using SSRS.
Environment: MS SQL Server 2008/2005, SSIS 2008, SSRS 2008, SSAS 2008, DTS, T-SQL, OLAP Service, Visual Studio 2005, ASP.NET, SQL Server Profiler, Erwin Data Modeler 7.0, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), VLDB.
Confidential
SQL Server Developer/DBA
Responsibilities:
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Involved in Implementation of database design and administration of SQL based database.
- Upgraded the systems from SQL Server 6.5 to SQL Server 7.0
- Performed installation and upgrading MS SQL Server 6.5 to SQL Server 7.0.
- Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
- Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
- Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
- Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables
- Experience in writing and using VBScript and Excel.
- Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
- Developed ER Diagrams using Erwin 3.5.2.
- Experience in Database backup and disaster recovery procedures.
- Experience in Replication - Snapshot, Merge and Transactional.
- Implemented database standards and naming convention for the database objects.
Environment: SQL Server 2005/2000, T-SQL, Win NT v4, MS Access, Visual Basic 5.0