Sr. T-sql/ssis/ssas Developer Resume
Seattle, WA
SUMMARY
- More than 8 years of IT experience in the Analysis, Design, Development, Implementation, perform and Testing Client/Server applications using Microsoft SQL Server 2000/2005/2008 R2/2012 and BI Suite.
- Extensive experience with all phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging).
- Experience with Installation and Configuration of MS SQL Server 2012/2008R 2/2005/2000.
- Expertise experience in latest technologies in SQL Server 2012 like Data Quality Services (DQS) and Master Data Services (MDS).
- Excellent work experience in MS SQL Server development including designing logical/physical databases, DTS packages, with business intelligence suite like Microsoft Reporting Services (SSRS), Integration services (SSIS), and Analysis services (SSAS), performance tuning and Troubleshooting.
- In - depth knowledge of T-SQL, OLTP, OLAP in designing database and data warehousing.
- Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, DTS and SSIS 2005/2008R2/2012 Packages with appropriate control & data flow elements.
- Experience in using transformations like Aggregate, Multicast, Data conversion, Merge Join etc.
- Experience in logical, physical and dimensional data modeling, data mapping and data normalization, well verse in ERWIN.
- Experience with ad-hoc reporting, regular reporting, parameterized, Custom Reporting, power view reports, power pivots, and graphical reporting using SSRS for daily/weekly/bi-weekly/monthly reports and from SSAS cubes as well.
- Experience in creating Power Pivot data models to provide the data to Power View dashboards.
- Created and implemented cubes, transaction to reporting solutions with SQL Server Analysis services.
- Strong experience in SQL Server Database Administration, Management, Upgrading, Migrations and Development in Production\Nonproduction environment and clustered environments.
- Experience in planning and implementation of Microsoft SQL Server Security and Database permissions.
- Experience with Database Backup, Recovery and Disaster Recovery Procedures.
- Experience in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server 2012/2008R2/2005/2000 in OLTP environments.
- Experience in Microsoft.net technologies using C#, ASP.NET 1.1/2.0/3.0/3.5 , ADO.NET, Language integrated Query (LINQ), WCF, WPF, Windows Forms, Windows Controls, XML, JavaScript, Web Services, Web controls, Web Forms, and Visual Studio.NET2005/2008.
- Experience with Installation and Configuration of MS SQL Server 2008/2005/2000 and in planning and implementation of MSSQL Server Security and Database permissions.
- Extensive work experience with Database Backup, Recovery and Disaster Recovery Procedures and in configuring Database High Availability techniques like Database Mirroring, Log Shipping, Clustering and Recovery on SQL Server 2005 and 2008R2.
- Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
- Involved in DBA activities such as backups, restores, replication of data.
- SQL Server 2005 OLAP database development including KPIs, Data mining, working with slowly changing dimensions (Fixed, Changing and Historical).
TECHNICAL SKILLS
- C/C++
- C#
- T-SQL
- SQL Server 2000/2005/2008 R2/2012
- Oracle 9i/10g
- PL/SQL
- MS Management Studio
- Business Intelligence Development Studio
- Microsoft SharePoint 2013
- OLAP
- OLTP
- Query Analyzer
- Data Tuning
- DTS
- SQL Server Integration Services(SSIS)
- SQL Server Reporting Services(SSRS)
- SQL Server Analysis Services (SSAS)
- Data Quality Services (DQS)
- Master Data Services (MDS)
- MDX
- BCP
- Import/Export Wizard
- Erwin 3.x/4.x/7.x
- MS VISIO 2000/2003
- ASP.NET
- ADO.NET
- LINQ
- Web Services
- WSDL
- SOAP
- AJAX
- .Net framework 3.0/3.5
- Windows Communication Foundation(WCF)
- Windows Presentation Foundation (WPF)
- BizTalk Server 2004/2006
- Crystal Reports XI/8.5/8.0
- Business Objects
- Visual Studio 2005/2008/2010
- MS Visual Source Safe
- MS Performance Point Server
- Windows 98/XP/Vista
- Unix/Linux
- MS Office 2000/2003/2007
PROFESSIONAL EXPERIENCE
Confidential, Seattle, WA
Sr. T-SQL/SSIS/SSAS Developer
Responsibilities:
- Lead responsibilities in scheduling KT sessions with End client, business to implementation partner.
- Co ordinate with offshore and onsite by providing in-detail analysis and explanation like KT, shadowing and reverse shadowing tasks.
- Worked extensively on metadata driven database architecture for all environments, error logs, permissions, changes.
- Designed, modified and maintained dimensions and measures on SSAS cubes, feed from EDW and extracts to BO reports.
- Designed and Developed SSIS packages for extracting the data from multiple data source and load into the appropriate tables in the database.
- Expertise in using tasks like Conditional Split, Derived Column, Lookup, Merge Join etc.
- Optimized Queries and used SQL Profiler to identify the bottle necks in scripts.
- Designed and developed an automated process in SSIS to load data on a monthly basis.
- Created reports from cubes and maintained SSAS cubes, MDX queries using SQL server Analysis Services (SSAS) on very large databases (VLDB).
- Set up the SharePoint server 2013 and configured it to work with SQL server 2012.
- Integrated SharePoint and Power Pivot by fetching data from SQL server 2012 and deployed them onto SharePoint site.
- Created dashboards in Share Point using Power View to display the repots, Provided/configured role based securities for reports using SSRS, SAP BOBJ and MOSS.
- Created custom intermediate schema to store data pulled from original data source.
- Created Stored Procedures and Views which work on the basis of core business model.
- Optimized existing stored procedures and tuned queries to run faster consuming less resources.
- Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified the existing reports based on End User Requirements.
- Handled and supported BO reports and SSRS reports by providing ad-hoc SQL queries and analysis on business changes.
- Created maintenance reports by using various components like Grouping, Sorting, Filters, bookmarks and Navigation.
- Worked extensively on unit testing, regression testing for each and every deployment and fix.
Environment: Microsoft SQL Server 2012/2008 R2/2005/2000, T-SQL, Visual Studio 2010/2008/2005 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), EDW, MDX, PDW, Team Foundation Server (TFS), HP Quality Center, OLTP, OLAP, Microsoft VISIO 2003/2007, Data Quality Services (DQS), Windows Server 2012, SAP Business Objects (BOBJ), SAP HANA, SAP BI/BW, SAP BODS, Microsoft Share Point Server, TeraData, Informatica, Oracle 10g.
Confidential, Minneapolis, MN
Sr.SQL Server SSIS/SSRS Developer
Responsibilities:
- Extensively worked on the extraction of data from file load systems, transformed and loaded to theData warehouse.
- Designed and floated multiple report models on views (due to security issues) and deployed them on to the production reporting server.
- Generated various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports, power view presentation, in customer level, manger level, and vendor level using Microsoft technologies like SQL Server Reporting Services (SSRS) and SAP technologies like Business Objects.
- Modified the stored procedures to get the new functionality depending on the business requirement.
- Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements,Runtime Events and log providers etc.
- Involved in extracting the data from flat files in the development server and loading the clean datato QA, UAT, production servers using SSISInvolved in scheduling packages using SQL Server Agent.
- Wrote SQL joins, sub queries, tracing and performance tuning for sophisticated SSRS and BO reports.
- Used SQL Profiler for debugging issue, performance tuning whenever necessary.
- Extensively involved in solving the production issues when dealing the sales force cases.
- Gave 24/7 production support whenever required.
- Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system throughSSIS packages and custom procedures.
- Managed, operated and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed on a daily basis.
- Continued to improveETLautomation of processes enhance the import speed accuracy and quality of daily data updates
- Analyzed data importing processes and design processes/applications to help increase automation, efficiency, flexibility and extensibility.
- Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
- Worked extensively with complex T-SQL queries, created functions, views and stored procedures.
- Created many tables with the cluster and non-clustered indexes on columns.
- Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.
Environment: Windows 2012/ 2008/2003/2000/ NT4.0, Microsoft SQL Server 2008 R2/2005/2000, T-SQL, Visual Studio 2010/2008, Team Foundation Server (TFS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Red gate, DTS, Performance Tuning, trouble shooting, Clustering.
Confidential, Portland, OR
Sr.SQL Server SSIS/SSRS Developer / DBA
Responsibilities:
- Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.
- Installed and Configured Microsoft SQL Server 2008 R2 on different domain servers like dev, QA, UAT and production on Windows operating system.
- Worked independently on multiple projects with minimal supervision and in agile SCRUM environment.
- Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.
- Designed, Developed and tested packages to extract, transform and load data using SQL Server integration services (SSIS).
- Developed advancedETLimport packages usingSSIS, T-SQL Scripts, T-SQL scripts for Execute SQL task and Expressions in ADO.NET sources to transform and import raw index data into database tables and to staging by executing business logic, rules and client requirement.
- Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system throughSSIS packages and custom procedures.
- Manage, operate and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed on a daily basis.
- Continue to improveETLautomation of processes enhance the import speed accuracy and quality of daily data updates
- Developed data importing processes and designed processes/applications to help increase automation, efficiency, flexibility and extensibility by creating T-SQL Scripts, Stored procedures, functions… Etc.
- Worked on various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Crystal reports on daily/weekly/bi-weekly/monthly basis.
- Implement code changes, bug fixes and configuration changes (if needed) and other development and administrative activities.
- Created Snapshot and Transactional replication and performed backup and restore operations as well.
- Technical support to users for various purposes like Access change, performance issues and storage space
- Work in cooperation with other teams and business analysts for of efficient database access and for processing applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL scripts to application development teams.
- To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.
- Running various DBCC commands for administration of database objects and system performance.
- 24x7 Technical Support for Production OLTP and Data Warehouse based on Microsoft SQL Server 2005 and 2008 Servers/databases.
- To ensure all scheduled administrative jobs are running/completed for Microsoft SQL Servers.
- Involved in working with the system/storage administrators to appropriately spread files across the SAN drives.
Environment: Windows 2008/2003/2000/ NT4.0, MS-SQL Server 2008/2005/2000 , T-SQL, Visual Studio 2010/2008, LINQ, WCF, Team Foundation Server(TFS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX queries, Red gate, SQL Profiler, Auto sys, System Monitor/ Performance Monitor, DTS, Performance Tuning, trouble shooting, Clustering, Microsoft Office.
Confidential, Foster City, CA
SQL Server SSIS/SSRS/SSAS Developer/DBA
Responsibilities:
- Responsible to Install, Upgrade, Design, and Implementation of SQL Server 2008/2005/2000 . Enterprise database environment for multiple client sites.
- Set up, oversee, and trouble shoot network architecture, server side configuration, client side configuration, connection, manager, and security.
- Implemented Database Maintenance Plans, Reports and Monitoring.
- Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc…), database capacity issues, replication, and other distributed data issues.
- Create and implement best backup and recovery strategies (Full Backup Model with 4 hours period transaction logs backup).
- Have done plenty of T-SQL Scripting, query optimization, indexing using SQL server 2008 R2.
- Assistance to database developers and web programmers in query writing, query optimization, Performance Tuning on very large volume of databases (VLDB) in terabytes.
- Evaluate back-up and recovery hardware and software and make recommendations to management to automate and implement on-going improvements.
- Involved in creation of Windows clustering (active/passive) nodes.
- Created Snapshot, Merge and Transactional replication and replication Issues.
- Designed and implemented Disaster Recovery site using Log Shipping.
- Used Database Mirroring for increasing database availability.
- Involved in Capacity planning of the database system.
- Created Test Plans with the help of QA Teams and conducting Unit, Integration and System Testing.
- Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS and SSIS.
- Transformed data from various data sources like MS Access, Oracle 9i/10g, DB2 using ODBC connection by creating various ETL packages.
- Involved in extracting the data using SSIS from OLTP to OLAP.
- Created complex Tabular and Matrix reports using SSRS.
- Used ADO.NET components like Data Adapter, Data Reader and Dataset to display data on web pages.
Environment: Windows 2003/2000, MS-SQL Server 2008/2005/2000 , T-SQL Programming, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytics Services (SSAS), System Monitor/ Performance Monitor, DTS, Performance Tuning, Clustering, C#, ASP.NET, VB Script, Oracle 9i, DB2, SQL Profiler and Team Foundation Server (TFS).
Confidential, Memphis, TN
SQL Server SSIS/SSRS/SSAS Developer
Responsibilities:
- Collaborate with various functional business units to gather reporting requirements.
- Develop the Data Model for the staging environment using Erwin.
- Work with business users to clarify ETL requirements and business rules.
- Design, develop, implement, and assist in validating ETL processes.
- Developed advancedETLimport packages usingSSIS, T-SQL Scripts, T-SQL scripts for Execute SQL task and Expressions in ADO.NET sources to transform and import raw index data into database tables and to staging by executing business logic, rules and client requirement.
- Measure the member access to preventive care using a set of nationally-recognized measures called HEDIS (Health Employer Data Information Set).
- Document all ETL related work per SFHP*s methodology using Microsoft SSIS tool.
- Maintain existing code and fix bugs whenever needed.
- Ensure that all timelines of loading/validating data are met.
- Ensure smooth functioning of our development, QA and production environments.
- Create ad-hoc and automated reporting solutions.
- Process and analyze data to support clinical and financial initiatives for managed care organizations· Create and execute unit test plans based on system and validation requirements.
- Troubleshoot, optimize, and tune ETL processes.
- Ability to synthesize data from various sources and perform various types of data analysis.
- Ability to understand and develop audit rules for industry standard health data code sets such as ICD-9/ICD-10, CPT/HCPCS, Revenue codes, and NDC (Pharmacy).
- Familiarity with standard regulatory reporting requirements such as HEDIS measures.
- Active participation in monthly departmental meetings and providing the necessary inputs on how to improve the standards.
- Worked in development of SFHP utility to automate all the processes from scratch to EDW build and check audit rules.
- Participated in Production support and bug fixes.
Environment: Microsoft SQL Server 2005/2008, T-SQL Scripting, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Compare, SQL Server Agent, Database tuning advisor, C#, VB.Net, Windows Server 2003, Team Foundation Server 2006, Microsoft Share Point Server, Performance tuning, Microsoft Office 2007/Excel/Outlook.
Confidential, Concord, CA
SQL Server SSIS/SSRS/SSAS/.Net Developer
Responsibilities:
- Developed, executed and maintained SQL queries/scripts and to validate completeness, integrity and accuracy of data.
- Analyzed Reports and Fixed Bugs in stored procedures.
- Generated daily, weekly and monthly reports for the managers using SSRS.
- Provided data sets, sql queries and written stored procedures and functions in Business Objects reporting and Java based UI environment.
- Performed Unit testing, regression testing on reports, and monitored the performance of the reports.
- Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.
- Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
- Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
- Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, sequence Container and conditional split, data conversion, derived column and multi casting.
- Worked in setup logging environment to track the status of the events like error raise, task fail so on.
- Used configuration files, to migrate SSIS packages from development stage to quality analysis (testing) without having to reconfigure the packages.
- Created reports and packages in order to get the details of the customer who has the property & casualty insurance.
- Created and consumed Web Services for user authentication and file transfer using SOAP, XML.
- Worked in creating and executing complex Stored Procedures, user defined functions, SQL scripts using T-SQL Programming and SQL Queries to support Script task, execute tasks in SSIS packages.
- Created Efficient Triggers, Cursors, Tables, and Views and SQL Joins to generate statements for application with T-SQL scripting.
- Experienced in working with XML document structures and hierarchical data.
- Based on the Financial Advisor’s requirement, the online module is developed on ASP.NET, C# and SQL Server 2008.
- Used BizTalk Server 2006 to integrate and manage business processes by exchanging business documents such as purchase orders and invoices between desperate applications across the organization.
Environment: Microsoft SQL Server 2005/2008, Visual Studio 2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytics Services (SSAS), Business Intelligence Development Studio (BIDS), DTS, SQL Profiler, Windows Server 2003, C#, ASP.NET, Visual Studio 2008, SAP Business Objects, LINQ, WCF, SOAP, XML, BizTalk server 2006, Microsoft Visio, Erwin, MS Office 2007.
Confidential, Columbus, OH
SQL Server SSIS/SSRS/SSAS Developer
Responsibilities:
- Created new user databases, database files, database file groups in SQL Server 2005 via SSMS and T-SQL.
- Created and modified stored procedures, functions and triggers.
- Installed and configured MS SQL Server tools SSIS, SSRS, and SSAS.
- Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
- Generated production reports, parameterized reports and regular reports using the tools SSRS.
- Used stored procedures, functions, tables, views and triggers and worked in designing and developing Reports, Data warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schemas.
- Designed, developed and reviewed cubes with end user and changed the cube and documentation according to their requirements using Sql Server Analysis Services (SSAS).
- Designed facts and dimension tables defined relation between facts and dimensions.
- Created logical multi dimensional models and studied relationships among the logical objects.
- Designed, administrated and developed Star Schema Data marts.
- Enforced referential integrity via creation of constraints on database objects.
- Developed database components using ADO.NET, C# and ASP.NET for data access.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Worked on DTS Packages, DTS Import/Export for Transferring data from Heterogeneous Databases.
- Maintained SQL Script for creation of Database Objects.
- Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
Environment: MS SQL Server 2005, Business Intelligence - SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services (SSAS), Visual studio 2005, Erwin, SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL, MS Visio 2003, C#, ASP.NET and Visual Studio 2005.
Confidential, Windsor, CT
SQL Server SSIS/SSRS Developer
Responsibilities:
- Debugged and deployed reports in SSRS.
- Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
- Created several SSIS packages in Microsoft SQL Server 2005.
- Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
- Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
- Wrote several complex stored procedures for the ease of application.
- Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
- Constructed Cubes based on data volumes mostly adhering to Star Schema.
Environment: Microsoft SQL Server 2000/2005, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services (TFS), ODBC, Oracle 8i, MS Access, T-SQL programming.