Sql Server Developer Resume
Chicago, IL
SUMMARY
- Over 6 years of professional experience in Database Design and Development, Banking and Financing and Support of MS SQL Server 2005, MS SQL Server 2008, Test, Development Replication & Cluster Server Environments
- Extensive knowledge in Writing and Tuning T - SQL (DDL, DML, DCL) to improve the database performance and availability.
- Good hands on experience in writing T-SQL queries such as Creation of Databases, Tables, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
- Extensive experience in writing queries by using Joins Indexes and views.
- Good Hands on experienced in SQL Server Analysis Services (SSAS) SQL Server Integration Servers (SSIS) and SQL Server Reporting Services (SSRS)
- Good hands on experience with using ETL tools such as SQL server Integration service (SSIS) worked with using various transformation function to implement the complex business roles
- Worked with performance tuning SSIS and TSQL code and good hands on worked with large volume data.
- Ability to create reports using SSRS and Crystal Report XI.
- Knowledge of Crystal Reports/SSRS and features like drill-down, charts, dashboards, crosstabs, sub-reports, variables and control structures.
- Good hands on experience with using SQL server reporting Service (SSRS) and developed various reports types such as drilldown, drill-through, sub reports.
- Good hands on experience testing process helped testing team to develop test plan, test cases, traceability matrix etc.
- Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
- Worked with OLAP and OLTP application good hands on working with Data Mart, Data warehouse application provide support for BI reports for daily, weekly and monthly reports.
- Knowledge of full life cycle project development, data warehousing, analysis, data modeling.
- Knowledge in Query Optimization, troubleshooting procedures and T-SQL codes.
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
- Experience immigration of Data from Excel, Flat file, Sybase, Oracle to SQL Server by using various Loading techniques such as (BCP and DTS utility). Extracting, Transforming and loading of data using SQL Server DTS and SSIS
- Good Hands on experienced in the installation and configuration of SQL Server 2008 and upgrades MS SQL Server from MS SQL Server 2005 to MS SQL server 2008
- Organize professional with excellent Oral and written communication skills.
- Ability to work on fast paced work environment.
- Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training /supporting end users.
- Worked with supporting the Production and Application environment and provided the various levels supports on rotation basis.
- Good hands on experience with problem solving skills and provided solutions to various business problems.
TECHNICAL SKILLS
Tools: SQL Server 2005&2008, VBA, Matlab, Eviews, SPSS, MS Excel, MS Word, MS PowerPoint, MS Access, MS Outlook
MSSQL Server components/environment: SQL Server Management Studio, Business Intelligence tools (SSIS, SSAS, SSRS), Crystal Report, BO, Performance Tuning, Capacity Planning, Database modeling by using Erwin Data modeler
Operating Systems: Windows 2003 Server, Windows XP, Windows Vista, Windows 7, LINUX
PROFESSIONAL EXPERIENCE
Confidential, Chicago IL
SQL Server Developer
Responsibilities:
- Responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting.
- Gathered requirements from end user and involved in developing logical model and implementing requirements in SQL Server 2008, data validation, complete technical specs and post production support.
- Involved in writing complex queries using T-SQL.
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
- Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
- Import Data Sets from various sources like Databases, Oracle, Flat Files, and Excel into SQL Server Data Warehouse.
- Used SQL Server Profiler for troubleshooting, monitoring and tried to Optimize SQL queries for improved performance and availability.
- Developed queries for drill down reports to get the dataset required building the report, created data source and data sources views for metadata view.
- Maintained data integrity by performing validation checks and also fine-tuned the database objects and server to ensure efficient data retrieval.
- Involved in optimizing code and improving efficiency in databases including removed unnecessary columns, and eliminated redundant and inconsistent data and performing other maintenance tasks.
- Organized data entry usingMS Accessand MS Excel
Environment: MS SQL Server 2008, SQL Server 2005 Enterprise Edition, OLTP, OLAP, T-SQL, MDX, Web Services, Excel VBA, Windows 7 Standard Edition, Microsoft Office 2007, ASP.NET, MS Access 2007, T-SQL, and SQL Server 2005 Manager Studio, T-SQL and SQL Agent.
Confidential
Consultant (Database Developer)
Responsibilities:
- Create and maintain the databases using SQL Server.
- Create packages, procedures, functions and triggers. Handle database performance and tuning.
- Modify SQL Store procedure to gather to relevant information to use in a report.
- Plan the Backup policy for the databases.
- Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts
- Analyze data and design reports to present related information.
- Performing data transfer/migration using Export/Import and Data Transformation Services.
- Running BCP for Import and Export of Heterogeneous Data.
- Ensuring that the backups are running fine for various databases on different servers.
- Performing database recovery using the backup sets.
- Providing support to the Application developers on the application databases.
- Edit customer database files utilizingMSAccessandMSExcel
- Built a database inAccessto capture customer contacts and documentation flow.
Environment: MS SQL Server 2008, SQL Server 2005 Enterprise Edition, OLTP, OLAP, T-SQL, MDX, Web Services, Excel VBA, Windows 7 Standard Edition, Microsoft Office 2007, ASP.NET, MS Access 2007, T-SQL, and SQL Server 2005 Manager Studio, T-SQL and SQL Agent.
Confidential
Jr. DBA/Database Developer
Responsibilities:
- Determined the SQL Server installation. Installed SQL Server management tools using SQL Server Setup Program.
- Actively involved in tracking of policy issuing and premium information.
- Modeling of the SQL Server 2005 database.
- Successfully fed policy data to claim management system.
- Merged data into a single server environment to have better control, consistency and security of data.
- Created reporting stored procedures to roll up transactions level data up to policy level
- Developed ER diagrams and mapped the data into objects to modify the database and created alerts for error reporting.
- Worked on Client/Server tools. Used SQL Server Enterprise Manager to administer SQL Server.
- Created views and stored procedures and optimized them as required by front end people, as well as scheduled jobs for backup.
- Created Triggers to enforce data and referential integrity.
Environment: Microsoft SQL Server 2005, T-SQL, Windows XP, Microsoft Office 2007/2003