Sql Resume
Austin, TX
Professional Summary
8+ years of experience in Database Design, Coding, Maintenance, Integration, ETL, T-SQL, Report authoring and management and testing. Well versed in enterprise database integration and data migration among MS SQL Server, Oracle and MS Access. Extensive experience in SQL programming, database objects creation, complex Stored Procedures, Triggers and Performance Tuning, with excellent communication and interpersonal skills.
- Expert experience with the Microsoft Business Intelligence stack: Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS).
- Hands on experience in ETL (Extracting, Transforming and Loading) development using DTS/SSIS; experience in data mining and analysis, design and construction of data marts, data views.
- Expertise in implementing complex data-marts for specific subject areas
- Creating of Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS)
- Excellent experience in transforming data from various data sources like access, excel, flat file using OLE DB connection by creating various DTS packages & SSIS Packages (SQL 2005).
- Expertise in implementing Cubes
- Experienced in defining data sources for creating data source views.
- Experienced in report generation using SQL Server Reporting Services (SSRS) and Excel spreadsheets as per the client Requirements and for the periodic analysis.
- Responsible for converting the data from Legacy Source systems to target systems.
- Developed Drill through and Drill down repots using SQL Server Reporting Services (SSRS).
- Hands-on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000 and SQL Server 2005.
- Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC).
- Expert in transforming complex business logic into database design by creating database objects such as Tables, Stored Procedures, User Defined Functions, Views, User Defined Data Types, Indexes, Cursors, DML Triggers.
- Excellent T-SQL development skills to write complex queries involving multiple tables using join statement.
- Written T-SQL and PL SQL scripts to monitor database growth, Backup/Restore, Data Import/Export. Also written queries involving INNER/OUTER joins.
- Experience in creating and managing fragmentation of Indexes to achieve better query performance.
- Sound Knowledge in Cognos Suite.
- Have Sound Knowledge in all products of Microsoft Suite like MS Excel, MS Access.
- Experience in Performance Tuning and Query Optimization.
- Expert in database Normalization, RDBMS, Data Mapping, Data Modeling (Conceptual, Logical, and Physical data modeling) using Erwin/Visio tools and implementing relational database model as per business needs.
- Written T-SQL scripts for Data Import/Export.
- Strong Experience in working with large databases.
- Written PL SQL Scripts for various applications.
- Worked with Business Users to analyze the Business Process and made necessary changes to Schema Objects to cater their reporting needs.
- Excellent communication and inter-personal skills with ability to work as a team player or independent player and ability to interact with clients.
- Ability to work in challenging and versatile environments and strive for excellence.
Technical Skills
RDBMS:
MS-SQL Server 7/2000/2005/2008, Oracle, MS-Access
Reporting Tools:SSRS, Crystal Reports, Cognos 8(Framework Manager, Query Studio, Report Studio),Excel, PDF
Oracle Support Utilities:
TOAD, and SQL Navigator
Database Tools:
SSMS,BIDS,DTS,SSIS,SSAS,Microsoft SQL server replication services
Data Modeling Tools:
Erwin, MS Visio
Operating Systems:
Windows 2000/xp/2003, Unix
Programming Languages:
C, C#, C++, ASP.NET,T-SQL,PL/SQL
Scripting Languages:
VB6 Script
Other:
MS Office, MS Project
Professional Experience:
Confidential,Austin TX June 2011-Tilldate
SQL Developer Analyst
Technical Responsibilities:
- Collaborated with business experts and application development teams to understand output requirements and ensure application data and master data support those requirements.
- Understand complex business models and the data that supports those models, including inter-relationships between applications.
- Provided solution options, including phased delivery, in order to deliver value to the business.
- Translated business requirements documentation, as well as input from business users, into functional and technical specifications.
- Prepared Diagrams using Microsoft Visio and Erwin for better understanding the Database Models.
- Planned, designed, developed, unit test, tuned and deployed applications and other technical solutions to provide information to the business for operational and analytical reporting. This includes the ability to break work down into tasks, make accurate estimates, follow standard processes and meet established deadlines.
- Wrote and maintained documentation to describe program design, logic, code, test cases, test results, modifications and corrections.
- Responsible for moving the data from one system to an other system.
- Provided technical assistance by responding to inquiries regarding errors, problems, or questions with applications.
- Dropped and recreated the indexes on tables for performance improvements.
- Involved in creating jobs and scheduled jobs according to the requirements.
- Importing/Exporting data from/to different databases using utilities like Import/Export, Bulk Insert.
- Involved in Data Conversion from Microsoft Visual Foxpro to SQL Server Database.
- Designed and developed a fully functional database by creating the logical database design and implementing the physical database design using SQL server 2005.
- Written complex t-sql Queries using joins, aggregate functions, subqueries.
- Participated in Performance tuning SQL statements to improve performance of the system.
- Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other DDL and DML statements for various applications, maintained referential integrity and implemented complex business logic using t-sql and pl sql.
- Involved in Error handling for different applications.
- Participated in migration of data from Microsoft Visual FoxPro to SQL SERVER databases and responsible in creating packages to transfer data between them.
- Involved in documenting the scripts for better understanding.
Environment: MS SQL Server 2005/2008, SSIS, SSRS, MS Excel, Windows 2003 Server
Confidential,Washington, WA Oct 2010-Dec 2010
SSRS Developer
Technical Responsibilities:
- Worked with business experts and application development teams to understand output requirements and ensure application data and master data support those requirements.
- Understand complex business models and the data that supports those models, including inter-relationships between applications.
- Provided solution options, including phased delivery, in order to deliver value to the business.
- Translated business requirements documentation, as well as input from business users, into functional and technical specifications.
- Responsible for analyzing the data, ensuring the data quality and organizing the data.
- Collaborated with other team members to design database models in support of BI tools and other solutions for information delivery.
- Planned, designed, developed, unit test, tuned and deployed applications and other technical solutions to provide information to the business for operational, financial and analytical reporting. This includes the ability to break work down into tasks, make accurate estimates, follow standard processes and meet established deadlines.
- Wrote and maintained documentation to describe program design, logic, code, test cases, test results, modifications and corrections.
- Provided technical assistance by responding to inquiries regarding errors, problems, or questions with applications.
- Written complex MDX Queries.
- Participated in tuning MDX to improve performance of the system.
- Created complex reports against Cube.
- Involved in converting Excel reports to SSRS Reports.
- Experience with excel reporting.
- Involved in creating Complex Parameterized reports.
- Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
Environment: MS SQL Server 2005/2008, SSIS, SSAS, SSRS, MS Excel, Windows 2003 Server
Confidential,MD Sep 2009-Sep 2010
SQL Server/ETL Developer
Technical Responsibilities:
- Worked with business experts and application development teams to understand output requirements and ensure application data and master data support those requirements.
- Understand complex business models and the data that supports those models, including inter-relationships between applications.
- Provided solution options, including phased delivery, in order to deliver value to the business.
- Translated business requirements documentation, as well as input from business users, into functional and technical specifications.
- Collaborated with other team members to design database models in support of BI tools and other solutions for information delivery.
- Planned, designed, developed, unit test, tuned and deployed applications and other technical solutions to provide information to the business for operational, financial and analytical reporting. This includes the ability to break work down into tasks, make accurate estimates, follow standard processes and meet established deadlines.
- Wrote and maintained documentation to describe program design, logic, code, test cases, test results, modifications and corrections.
- Responsible for moving the data from one system to an other system.
- Provided technical assistance by responding to inquiries regarding errors, problems, or questions with applications.
- Involved in various DBA related activities like Created Database, Indexes, Views.
- Dropped and recreated the indexes on tables for performance improvements.
- Involved in creating jobs and scheduled jobs according to the requirements.
- Importing/Exporting data from/to different databases using utilities like Import/Export, Bulk Insert.
- Involved in Creating a Data warehouse.
- Designed Fact and Dimension Tables and also involved in structuring them according to the requirements.
- Involved in designing, developing and converting the data from legacy source systems to Data Warehouse.
- Participated in migration of data from EXCEL to SQL SERVER databases and responsible in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL server using DTS/SSIS.
- Designed and developed a fully functional database by creating the logical database design and implementing the physical database design using SQL server 2000. Successfully tested and validated with end users the database design.
- Written complex t-sql Queries using joins, aggregate functions, subqueries.
- Participated in Performance tuning SQL statements to improve performance of the system.
- Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other DDL and DML statements for various applications, maintained referential integrity and implemented complex business logic using t-sql and pl sql.
- Involved in Error handling for different applications.
- Designed multi-dimensional SQL database structures for numerous projects using common dimensions within a singular data warehouse environment.
- Used Translations to provide a simple and centrally managed mechanism for storing and presenting analytic data to users in their preferred languages.
- Worked with SQL delta tools for comparisons between databases.
Environment: MS SQL Server 2005/2008, SSIS, SSAS,SSRS,VB6 ,Oracle,SQL Delta tool, Windows 2003 Server
Confidential,CA Mar 2008-Jul 2009
SQL Developer/DBA
Technical Responsibilities:
- Contributed substantially in the Data Warehouse development lifecycle including gathering and understating of requirements, data and ETL design, database and report development, and testing using SQL Server 2005 Business Intelligence Development tools - Integration Services, Analysis Services & Reporting Services.
- Troubleshoot data issues, validate result sets, recommend and implement process improvements.
- Worked with other teams to understand business rules and interpret data.
- Maintained an ongoing knowledge of both the technical data model and the business strategic needs.
- Involved in converting the large scale data from different source systems to SQL Server database.
- Designing the logical and physical database structure.
- Designing the security and database access strategies.
- Enforcing the Null and check constraints.
- Active participated in installing SQL Database
- Taking Backups on scheduled time and monitoring scheduled Backups.
- Responsible in Performance tuning the existing stored procedures, views and triggers to meet the current design..
- Monitoring of database size, disk space in all (Production, Model & Development) the environments.
- Involved in Creating stored procedures and functions using complex queries.
- Created Database, Indexes, Views.
- Dropped and recreated the indexes on tables for performance improvements.
- Coordinate and support SSIS testing.
- Responsible for creating a data repository by integrating data from disparate sources.
- Participated as needed, in designing and developing data mart and data warehouse models, ETL to load the data marts and data warehouse, Data Quality, Audit procedures to support business requirements.
- Involved in extracting the data using SSIS from OLTP to OLAP.
- Transformed the complex business logic and calculations into coding.
- Created new logical and physical database design to fit new business requirements and implemented it to the SQL Server 2005.
- Created SSIS Packages configure & deploy Packages using Package Deployment Utility.
- Involved in Extraction, Transformation and Loading (ETL) of data using SSIS.
- Created complex reports (drill down reports) by writing stored procedures.
- Experience with excel reporting.
- Involved in calling parameterized reports through .NET environment.
- Developed complex SQL queries (using various joins and sub-queries) and stored procedures.
- Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
- Demonstrated good sense of layout and graphic presentation of data.
- Involved in Creating & Managing DB objects like Stored Procedures, Views, Indexes, Cursors, Triggers and User Defined Functions.
- Participated in optimizing Complex queries, Code reviews.
- Involved in Performance tuning
Environment: MS SQL Server 2000/2005,SSRS ,SSIS, SSAS, Crystal Reports, VB,.NET, Windows 2003 Server
Confidential,CT May 2007-Jan 2008
BI Consultant
Technical Responsibilities:
- Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for applications.
- Wrote Store Procedures using Transact SQL to populate the fact tables and dimension tables.
- The Stored Procedures support both daily and historical data loading to the fact tables.
- Created scripts to perform validations and run jobs on different instances (Development, Testing, and Production Environments)
- Worked on Linked and Remote Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB drivers.
- Responsible for scheduling the jobs.
- Gathered Requirements from the end user and checked the structure of the schema and data.
- Involved in Performance tuning the SSIS Packages.
- Developed SSIS package from source to staging and/or staging to DW data mappings.
- Developed data warehouse and reporting systems using SSIS and SSRS including Report Builder and Report Models.
- Created new SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
- Created SSIS packages to clean and load data to data warehouse.
- Created SQL server configurations for SSIS packages and XML & Windows event logs.
- Deploy SSIS packages.
- Maintain and Optimize SSIS package, and troubleshooting issues.
- Use SQL Profiler and Execution Plan for troubleshooting, monitoring SQL Server, T-SQL statement, Index, configure jobs and SQL profiler trace.
- Created reports by extracting data from cube.
- Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
- Created report models and deployed on report server.
- Created standard report Subscriptions and Data Driven report Subscriptions
- Worked extensively on enterprise report (dashboards, scorecards, sub report, matrix and drill through) and ad-hoc reports.
Environment: MS SQL Server 2005, SSIS, SSRS, SSMS, Windows 2003 Server T-SQL.
Confidential,India Oct 2005-Mar 2007
SQL Server Developer
Technical Responsibilities:
- Served as developer for the solutions designed by other team members.
- Checked the coding standards followed by peers of the team.
- Prepared test reports and bug logs for the testing done.
- Involved in data migration and data integration.
- Developed stored procedures, triggers and functions and added/changed tables for data Extraction, Transformation and loading.
- Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores procedures, checked deadlocks and created scheduled jobs.
- Extraction, Transformation and Loading of the data using DTS packages.
- Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
- Responsible for designing Schema and finalization of naming and coding standards throughout project life cycle.
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL and PL SQL in Development and Production environment for SQL Server.
- 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 performance tuning using indexing (Cluster Index, Non Cluster index) tables.
Environment: Windows Server 2000, SQL Server 2000, Oracle, HTML, T-SQL.
Confidential,India Jan 2003-Apr 2005
SQL Server Developer
Technical Responsibilities:
- Designed ETL packages for different data sources (SQL Server, Flat Files).
- Experience in designing ER diagrams and mapping the data into database objects.
- Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
- Involved in Performance tuning by creating Indexes.
- Worked with development teams in the design of physical databases and in modification.
- Ensured developers coordinated their efforts in managing and maintaining different application databases.
Environment: MS SQL Server 2000, Windows 2003, Erwin.
EducationBachelor of Technology