Sql/ssis Developer Resume
Findlay, OhiO
SUMMARY:
- 7 years of professional IT experience as MS SQL Server Database developer with developing, Analysis, Integration and Reporting.
- Worked on various environments for installing, updating and configuring SQL server 2005/2008/2008 R2/2012/2014 on operating system Windows 2000/2008 server.
- Professional experience includes array of domains from Banking, Insurance, Manufacturing and Health care.
- Good knowledge of system development Life cycle (SDLC).
- Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
- Strong hands on experience in control version tools like SVN, TFS.
- Good Experience in creating database objects like Tables Stored Procedures, Views, Indexes and User Defined Functions consumed at various stages of Migration process, Reports and Data Validation.
- Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default.
- Involved in analysis and also creation of the databases relationships using ER (Entity Relationship) diagrams.
- Good knowledge of Normalization/De - Normalization, Data Design methodology and building Referential Integrity for the relational Database Model.
- Good knowledge in configuring and managing Linked Server, Data transfer between SQL Server and other RDBMS.
- Experienced in extracting, transforming and loading (ETL) data, from different Heterogeneous Data sources like MS Access, Flat File, Excel and Oracle, to MS SQL Server using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
- Involved in migration project of DTS Packages (2000) to SSIS (2005), 2005 to 2008 and troubleshoot any migration issues.
- Designed and tuned SSIS packages (ETL) to implement Business rules.
- Experienced in creating Logging, Break Points, Check Points, and use Error Handling in SSIS and automating the ETL process.
- Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc.) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion.
- Extensive Experience in Performance Tuning of SSIS packages.
- Experience in deploying SSIS packages using Manifest files and Import / Export wizards while creating various configuration files to make the package works in various environments
- Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases
- Knowledgeable about other aspects of reporting service such as Report Management, Report Delivery and Report Security.
- Experienced in configuring and maintaining Report Manager, Report Server and Repot Builder for SQL Server Reporting Services (SSRS).
- Well versed with diverse types of reports such as Drill down, Drill through, Parameterized, Cascaded parameterized, Linked, Chart, and Sub-reports using SSRS. Created Subscriptions to the SSRS reports.
- Assisted in the scheduling the reports to refresh and run on daily, weekly and monthly basis and also deployment of the reports using Direct deployment and Uploading files using the Report Manger.
- Involved in integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and Performance Point 2010 and Dashboards.
- Knowledge on Reporting tools like Micro strategy, Qlik view, Crystal Reports, Creating Roles and assigning Permissions to the users.
- Involved in Building Cubes and Dimension Modeling, creating Data Marts, Kimball / Inman Methodologies, Star / Snowflakes Schemas with different architectures and data sources using SSAS.
- Experienced in building cube starting from scratch and their deployment.
- Experienced in performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.
- Excellent Communication Skills and proper follow-through on all directives, bulletins and schedules from the Team Lead, And Ability to present the information to the Business Users and partners.
- Able to work effectively in High Pace Environment giving excellent performance and highly capable of working in a Team Environment with a Positive Attitude. And Able to meet tight deadlines and manage competing priorities.
TECHNICAL SKILLS:
SQL Server Tools: SQL Profiler, Query Analyzer, SQL Server 2012/2008/2008 R2,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, SSAS, MS Access 2003/2007
Database: MS SQL Server 2012, 2008, 2005, MS-Access.
Language: C, C++, C#, T-SQL.
Operating System: Windows 8/7/Vista/XP/NT/2000, DOS, Windows Server 2003.
Tools: Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007.
Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP
Reporting Tools: SSRS (SQL Server Reporting Services)
ETL Tools: SSIS (SQL Server Integration Services), DTS.
Web Technologies: HTML, Share point, Visual studio, XML, XMLA
Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling
Testing Tools: Load Runner, QTP, Test director, win runner.
PROFESSIONAL EXPERIENCE:
Confidential, Findlay, Ohio
SQL/SSIS Developer
Responsibilities:
- Participated in requirements meetings to understand the requirements from the business people.
- Created and Modified tables, views, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 20012/2014.
- Loading data in various Wave environments and Bug Fixing of the application in various areas
- Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2012.
- Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default.
- Performed Development Integration, System Integration, End to End and User Acceptance Testing for the data services.
- Moving/Coping data from APPX environment to SQL environments and Preparing windows batch scripts. Communication to stakeholders - Business partners and IT Management
- Designed, coded, tested and debugging business logic for software Applications
- Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan and Index tuning advisor.
- ETL, data profiling, data quality and clean ups for SSIS packages.
- Created SSIS packages to populate data from various data sources.
- Created package with different data sources (SQL Server, Oracle, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Utilized various data flow transformations like lookup, row count, data conversion, Merge Join, multicast, conditional split, sort, aggregate to migrate data between different data sources as per business requirements.
- Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
- Developed Scheduled Jobs to automate the SSIS packages.
- Used Event Handlers and implemented Error Handling in SSIS packages and notified process results to various user groups.
- Supported regular production runs through scheduling FTP, Encryption and Frequency
- Employed many Slowly Changing Dimension methodologies to maintain and update historical data.
- Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
- Involved in fine tuning queries and stored procedures using SQL Profiler and Execution plan in SQL Server.
Environment: SQL Server 2008 R2/2012/2014, SSIS, SSRS, XML, MS Access, Excel, C#, Crystal Reports, ER Studio.
Confidential, Cleveland, OH
SQL Server Developer (SSIS/SSRS)
Responsibilities:
- Analyzed business needs and developed Technical Specifications based on interaction with Managers and Development Teams.
- Involved in all the stages of Software Development Life Cycle (SDLC).
- Involved in the normalization and de-normalization of the databases.
- Involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
- Test HIPAA regulations in Facets HIPAA privacy module.
- Created and Modified tables, views, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 20012.
- Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2012.
- Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
- Extensively used DML scripts to perform modification tasks like Insert, Update and Delete data in database tables.
- Involved in extensive DATA validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
- Communicated with team members for implementation, tuning and maintenance of Informix databases.
- Provided scripting Services and production support services in UNIX environment.
- Used SSIS features like event handlers, Logging, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
- Developed Complex SSIS Packages using containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
- Created SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc. and vice versa.
- Scheduled SQL jobs to run SSIS packages on a daily, weekly, monthly basis using MS SQL Server Integration Services (SSIS).
- Created Excel including pivot tables, macros, and lookup functions to format a data set from the various SQL sources.
- Created complex stored procedures, triggers and user defined functions using joins to apply business rules to data imported using SSIS packages.
- Deployed SSIS packages from Dev/Staging/Prod using SQL Server table configurations.
- Implemented logging and error handling in SSIS using Event Handlers.
- Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
- Excellent report creation skills using SSRS
- Developed Tabular Reports, Matrix Reports parameterized Reports Sub reports, Snapshot and Adhoc reports (SSRS)
- Experience in performance tuning in SSRS Report by using different methods.
- Created Standard And Data driven Subscription for SSRS Reports
- Wrote C#,VB.NET Code for Script Task in SSIS 2012
- Also responsible for transferring data from Production Server to the Development Server occasionally on Incremental Basis for the purpose of checking the consistency in data.
Environment: MS SQL Server 2012, SQL Server Management Studio (SSMS), Business Intelligence Development Studio(SSIS, SSRS, SSAS), MS-Visual Studio, XML, MS Office 2010, MS Visio 2007, Team Foundation Server.
Confidential, Mooresville, NC
SQL/BI Developer
Responsibilities:
- Involved to work with troubleshooting the stored procedures, functions, views, triggers etc. & part to be increasing the performance tuning.
- Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
- Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
- Developed SSIS ETL packages to meet data flow needs.
- Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
- Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
- Modifying & Implemented simple encryption, stored procedure in order to transform the business rules.
- Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
- Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
- Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
- Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
- Developed SSIS ETL Packages to meet data flow needs & building platform with the using of SSIS.
- Involved to work with .NET, C# environment to do custom coding within SSIS packages, SSRS reports.
- Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control with the using of Team Foundation Server.
- Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2005 using Data Transformation Services (DTS Transformation) and T-SQL scripts.
- Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select statement in certain queries.
- Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
- Designed SQLSSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/08R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
- Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
- Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc
Environment: MS SQL Server 2008R2, SQL Server Management Studio (SSMS), SSIS, SSRS, SQL Query Analyzer, SQL profiler, XML, MS Office 2010, MS Visio 2007, ERWIN Data Modeler.
Confidential
Jr. SQ L Server Developer
Responsibilities:
- Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
- Developed SQL scripts to Insert/Update and Delete data in T-SQL database tables.
- Generated T-SQL scripts for application development.
- Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
- Created Stored Procedures and User Defined functions.
- Worked in Grouping, Summing, totaling, Case Limits, Common Table expressions
- Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.
- Participated in the designing and development of software using agile development practices
- Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency
- Scheduled Jobs and Alerts using SQL Server Agent.
- Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Maintained system entries and handled customer product qualification activities.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Implemented indexes for performance tuning.
- Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
- Data loaded into the database using SSIS 2005 from flat files.
- Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
- Developed several types’ reports and Deployed to the end users using SSRS.
Environment: SQL Server 2000/2005/2008 , SQL Server Query Analyzer, SSIS, SSRS, Windows 2000/XP.