Sql/ Ssis Developer Resume
Rock Island, IL
SUMMARY:
- 5 years of extensive experience as a MS SQL Server SQL Server 2008 Developer with major focus on T - SQL, SSIS, SSRS, SSAS and sound experience as a database developer in banking, IT and financial sectors. Having knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment
- Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise withDDLandDMLstatements,RDBMS’s, data dictionaries and normal forms
- Exceptional hands on working knowledge and recent experience working with SQLServer Integration Services (SSIS)and SQLServerReporting Services (SSRS)
- Thorough experience with SQL Server 2005 instance installation, up gradation and migrating from SQL Server
- Experience in writing Stored Procedures inDWenvironment and then created packages inSSISto load the data into Data Warehouse & sending alerts using SQL Mail
- Experience in creating packages to transfer data betweenORACLE,MS ACCESSandFLAT FILES toSQL SERVER using DTS/SSIS
- Experience in enhancing and deploying theSSISPackages from development server to production server
- Expertise in planning and implementing MS SQL server Security and database permissions
- Solid knowledge and recent experience with all aspects of SQL Server Management Studio (SSMS) includingQuery Editor,Server objects, SQL ServerAgent,Replication,Management and Notification Services
- Proficiency in using different Transformation tools likeDTS packages,BCPandBulk Insertas well as SQL Server Integration Services (SSIS)
- Excellent report creation skills usingMicrosoft Reporting Services(SSRS) (like using dashboards, scorecards, building reports) with proficiency in usingReport Designeras well asReport Builder
- Monitor the production server using tools like SQL Profiler,Windows Perform,Performance Countersand SQL server logs for Monitoring and Tuning SQL Server
- Strong experience with creating Linked Servers for connecting servers at remote site locations and then querying the group of servers usingT-SQL statements. Strong working knowledge onQuery Optimization and server performance tuning strategies
- Successfully implemented Transactional and Snapshot Replication methods for Backup and Restore of Database. Good understanding of high availability SQL Server solutions using active-active and active-passive Clustering modes
- Expertise with job scheduling using SQL Server Agent to perform hourly/ daily/ nightly updates. Expert in performing database consistency checks usingDBCC Utilities
- Experience in Data Modeling usingErwin,Rational Rose(UML) andMS-Visioto create logical and physical data models; use case diagrams and data flow diagrams respectively
TECHNICAL SKILLS:
RDBMS: MS SQL Server 2000/2005/2008/2008 R2/ 2012, My SQL, Oracle 9i/10g
Operating System: Windows 2000/2003, Linux, HP-UNIX
. NET Technologies: ASP.net, C#, VB.net
Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS, Import/Export, SSRS,SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL, Jobs, Replication tools, Data visualization (Composite tool).
Programming: C, C++, Java
Reports: SSRS, Crystal Reports, Congo’s Reporting tool, Business Objects.
PROFESSIONAL EXPERIENCE:
Confidential, Rock Island, IL
SQL/ SSIS Developer
Responsibilities:
- Designed Logical data model using Erwin
- Developed tabular reports using SSRS
- Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables
- Installation and configuration of SQL Server 2005/2000 on Windows 2000/NT/XP OS
- Developed web application for reporting portal using .NET, ASP.NET, C#, VSS
- Managing of database objects like Tables, views, indexes etc
- Implementing Backups and restoring when necessary, Used BCP utility to publish table content to text files
- Developed SSIS Packages to transfer the data between SQL Server database and files
- Created and managed database maintenance plans for various database consistency checks
- Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
- Managed users including creation/alteration, grant of system/db roles and permission on various database objects
- Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them
- Assisted admin team with Log Shipping to ensure full database backup and disaster recovery
Environment: MS SQL Server 2005/08/12 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), Business Intelligent Studio, ASP.NET, ADO.NET, SQL Server Management Studio, ASP, Crystal Report, Enterprise Manager, MS Excel, Windows XP Professional, TFS
Confidential, Boston MA
SQL BI Developer (SSIS/SSRS)
Responsibilities:
- Involved in designing and implementing database applications usingMS SQL Server 2008/ 2012and Business Intelligence (BI)tools to support transactions and business decision-making
- CreatedSSISPackages usingSSIS Designerforexport heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008
- DesignedETL packagesdealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations(For loop, bulk insert, Data flow, Data mining, FTP, XML tasks, etc)usingSQL Server Integration Services (SSIS)
- UsedPackage Configurationsto pass parent package variable values to child package variable
- Deploying SSIS packages from various sources like bids, Management Studio, file systems etc
- Monitored performance andoptimized SQL queriesfor maximum efficiency
- Developed web application for reporting portal using .NET, ASP.NET, C#, VSS
- Responsible for creating reports based on the requirements usingSSRS
- Experience in creating reports usingSSRSand worked onOLAP/OLTPenvironment
- Advanced extensible reporting skills, developedSSRS reports & generated them on SQL Server 2005
- UsedSubscriptions and Snapshotsto set upPush based Report Delivery
- Responsible for scheduling thesubscription reportswith the subscription report wizard
- Developed stored procedures and usedSSIS2005 to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables
- Designed and implemented SQL Server database objects (stored procedures, functions, views and complex T-SQL/queries) to support data integration (SSIS), reporting and various business processes
Environment: SQL Server 2012/2008R2/2008/2005, SSRS 2008, SSIS 2008, SSAS Data Stage, DB2, Oracle 9i/10gVisual Studio 2005, ASP.NET, ADO.NET, XML, XSLT, SSAS, MS Office and Visual source safe.
Confidential, Richfield, MN
SQL/Crystal Report Developer
Responsibilities:
- Developed complex T-SQL stored procedures using joins and unions to create crystal reports and also optimizedSQL queries for efficiency and the front end developer with their queries and procedures
- Developed crystal reports using Crystal Reports 10 for detail information to the sales team regarding sales of all stores according to the criteria given, which helped the sales team to take their decisions
- Developed E-R diagram for reports which gives all the relationships of the tables from huge De-normalized database using Microsoft Visio
- Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
- Developed various functions using SQL Server 2008 for the interfaces which were automatically run on daily, weekly and monthly basis using SQL server task in SSIS
- Responsible for optimization of the T-SQL queries to give the faster results from whole bunch of data using SQL Profiler and also provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers
- Developed temporary tables and views of the databases for faster use and faster retrieval of the data and helped developer’s team to reduce the complexities of fetching data and access complex database
- Developed Demo Results of the reports which are useful for the UAT phase to get the approval from the key users
- Involved in Data conversion to clean the legacy database and reuse it for annual decisions of the sales and also created mapping between legacy tables and current tables in the database
Environment: MS SQL Server 2008, Windows Server 2003,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL,Microsoft Visio 2007, MS Visual Studio 2008,Crystal Report 10.
Confidential
SQL Server Developer
Responsibilities:
- Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept
- Involved in Design, Development and testing of the system
- Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
- Developed User Defined Functions and created Views
- Created Triggers to maintain the Referential Integrity
- 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
Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.