Sql Resume
Seattle, WA
SUMMARY
Database Developer - Junior DBA/Support Analyst with 4+ years IT experience in the financial industry. Proficient in SQL Server 2000 / 2005, SQL Server Analysis (OLAP), Reporting Services, Informatica and Data Warehouse tools.
Certifications
Microsoft Certified Technology Specialist in SQL Server 2005
- Implementation and Maintenance
Microsoft Certified Professional in SQL Server 2000
- Designing and Implementing Databases
EXPERTISE
- Extensive knowledge of Normalization and RDBMS concepts.
- Designed and created Views, stored procedures & Triggers.
- Created DTS packages including extensive knowledge of exporting and importing data to and from SQL Server.
- Experience in using tools like Index Tuning Wizard, SQL Profiler for monitoring and tuning MS SQL performance.
- Troubleshoot and reduce production issues.
- Extensive work in ETL process using Informatica consisting of data transformation, data sourcing, mapping, conversion and loading.
- Experience in MS SQL Server installation and configuration.
- Perform Backup and Recovery.
- Database Security Management.
- Experience on analyzing execution plan, fragmentation, and statistics.
- Experience in Performance Monitoring, Tuning and optimization.
- Knowledge on using Erwin.
- Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
- Work with application development staff to develop database architecture, coding standards and quality assurance policies and procedures.
- Exposure to all stages of Software Development Life Cycle.
- Experience in creating test cases, test plan and Release document.
- Assisted production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
- Self-motivator with good analytical and communication skills.
SKILLS
O/S: Windows 98/2000/2003/XP/Vista
Languages: SQL Programming (T-SQL), VB 6.0, ActiveX Script
RDBMS: SQL Server 2000/2005, Oracle 9i, MS Access
GUI: Visual Basic 6.0
Tools: Erwin, Informatica Power Centre 7.1.2, Visio, Crystal Reports 10.0, Visual Source Safe, Test Director, Perforce
TECHNICAL TRAINING / EDUCATION
Technical courses include:
- MS Visio 2003
- Manual Testing and tools: WinRunner6.0, QTP
- Crystal Reports 10.0
PROFESSIONAL EXPERIENCE
ETL / DWH Developer Oct 2007 - Aug 2008
Project : Home Equity Pricing & Analytics
Organization : Confidential, Seattle WA
Environment : SQL Server 2005
Role : Data Warehouse Spl II
Description : Confidential is a leading bank and financial services company which provides comprehensive range of financial services: personal banking, commercial banking, insurance, investment planning, and wealth management. The project is designed to maintain the Home Equity data at one location which helps for pricing and analytical usage. The main job was to extract the data from different sources and import into SQL Server 2005 to do the Data Manipulations and further business logic processing where the customers will slice and dice to evaluate the profits, losses, charge off’s, etc.,
Responsible for:
- Developed, deployed and monitored SSIS packages including DTS to SSIS
- Developed, deployed and managed SSAS cubes by applying business logic as required
- Maintain the data mart with most recent data (yearly/monthly/weekly partitions): loans information, from different sources like Enterprise Data Warehouse, Visual Banker, Credit Risk Analysis System, Financial Data mart, etc.,
- Developed and optimized database structures, stored procedures, views, triggers, and user-defined functions
- Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring performance of SQL Server databases
- Interact and co-ordinate with end users on their requirements
- Build different cubes for maintaining yearly, monthly and weekly partitions
- Migrated and recreated existing Dimensions and Cubes on 2005 Server to achieve the efficiency of Analysis.
- Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
- Involved in designing the new database design to migrate from SQL Server to Oracle
- Managed version control and documentation of all SQL Server objects.
- Post Implementation / production support.
ETL /SQL Server Developer July 2006 - Sep 2007
Project : Customer Optimization - Marketing Data Analytics
Organization : Confidential
Environment : SQL Server 2000
Role : SQL Server / ETL Developer
Description : One of the largest financial organization/ banks in US. It offers clients a full range of products - including stocks, bonds, mutual funds, annuities, banking and customer finance, credit cards. The project was designed to perform marketing data model analytics. The main job was to extract the data from different sources and import into SQL Server 2000 to do the Data Manipulations and further business logic processing.
Responsible for:
- Requirements gathering, analysis for new business requirements.
- Impact Analysis on new enhancements requirements.
- Functional Specification, operational, Process and Procedures Documentation etc..,
- Prepare functional test cases and validate the results.
- Interact and co-ordinate with Business end users on their requirements.
- DTS Packages data loading for Analytical reporting purposes.
- Created/Modified DTS package with ActiveX Scripts and automated jobs.
- Data extraction from Oracle and migrate into SQL Server 2000 using DTS and ActiveX Script.
- Move data from text files to SQL Server 2000 database using BCP Import & Export and DTS packages.
- Managed version control and documentation of all SQL Server objects in perforce.
- Production Support and Maintenance of all data extraction/loading jobs (Daily/Weekly/Monthly).
- Clean-up DTS Packages and other objects in SQL Server Environment. (Co-ordinate with Business and DBA).
- Assisted production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
- Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
- Installation and configuration of MS SQL Server 2005 on Advanced Windows 2003 server.
- Analyzed the existing data marts in SQL 2000 for creating an efficient data warehouse, and also planned and performed the migration from SQL server 2000 to SQL Server 2005 following the Normalization standards to maintain data consistency.
- Migrated and recreated existing Dimensions and Cubes on 2005 Server to achieve the efficiency of Analysis.
- Migrated all DTS packages to SQL Server Integration Services(SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services
- Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
- Data sourcing and technical solution to support the production process.
- Generate T-SQL Scripts for creating file groups, permissions, security roles etc..,
ETL/SQL Server Developer Mar 2005- Apr 2006
Project : Credit Risk Analysis
Organization : Confidential
Environment : SQL Server 2000
Role : SQL Server Developer
Description : ‘Customer Background’ is a sales process and system that is used during the opening of a new customer/account by Treasury Services Large Corporate, Corporate, Financial Institutions, and Public Sector Sales. It is an online profile questionnaire that must be completed, reviewed, and approved in order for the client to be set up with an account. This CB process it a tool that assists CLIENT NAME to remain in compliance with audit and FCC regulations. CB is also in coordination with Patriot Act requirements. After the initial approval process, CB customers must go through a periodic renewal process. The frequency of the renewal process is based upon the risk rating of the customer. CB is undergoing an upgrade to their system. Included in this upgrade are the deletion, change and creation of many new questions to the questionnaire.
Responsible for:
- Requirements gathering, analysis, design, development and deployment.
- Interaction with clients to analyze business requirements.
- Designed, implemented and documented an online questionnaire.
- Developed/optimized Stored Procedures, tables, queries, views and implemented methods to provide database data for relevant applications.
- Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing the performance of SQL Server.
- Successfully extracted data from Oracle Data mart and migrated into SQL Server 2000 using DTS and ActiveX Script.
- Used SQL Server Profiler to trace the slow running queries.
- Optimized Query execution performance with the use of Index Tuning Wizard for tracing slow running queries and stored procedures.
- MS SQL Server 2000 installs.
- Perform Backup and Recovery.
- Database Security Management.
- Experience on analyzing execution plan, fragmentation, and statistics.
- Moved the static data from various text files to SQL Server 2000 database using BCP Import & Export and DTS packages.
- Managed version control and documentation of all SQL Server objects.
- Actively participated in User Acceptance Testing, and debugging of the system.
- Post Implementation / production support.
SQL Server - Support Analyst/Developer Mar 2004 - Feb 2005
Project : HMS (Hospital Management Systems)
Organization : Confidential
Environment : SQL Server 2000, Oracle 8i, Informatica 6.5/7.0
Role : SQL/ETL Developer
Description : The client has launched a promotion called Disease Management Program at various locations of North America to identify the people who are at risk or with past history of asthma & diabetes, and sets up a lifelong preventive and promotional healthcare program by using medical intervention and lifestyle management, there by improving their quality of life. Data warehousing is designed, developed and implemented to store the data of patient’s demographic and medical history, registrations, and the healing rate during and after completion of DMP Program. This data comes from various locations of USA. ETL process is scheduled on daily basis and the data is loaded into data warehouse.
Responsible for:
- Maintain existing mappings and mapplets in Informatica.
- Enhanced existing mappings and mapplets and also tuned them for better performance.
- Request Analysis, design, testing and documentation.
- Created mappings for new requirements.
- Used Transformations like Source Qualifier, Expression, Aggregator, Connected & Unconnected Stored Procedures, Filters and Sequence Generator.
- Repository creation and maintenance.
- Developed scripts for tables, stored procedures, and prepared comprehensive commenting of all codes. Maintained technical documentation for operational support.
- Used joins and other complex queries to view the results that meet the business decision.
- Created/Modified Stored Procedures, Views, and Cursors per requirements.
- Involved in documenting the extraction architecture and control flow of extraction process.
- Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints for data consistency.
- Created views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed.
- Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
- Tuned T-SQL and Stored Procedures for effective retrieval of data.
- Designed sql and t-sql indexes for effective retrieval of data.
- Designed tables and tuned indexes for effective retrieval of data.
- Customized stored procedure, triggers for Business logic processing.
- Built customized reports for the end- users.
Developer May 2002 - Oct 2002
Project : SMS (Stockyard Management System), VSP, India
Organization : Confidential
Location : India
Environment : Oracle 8, VB 6.0
Role : Developer
Description : Stock Yard Management System(SMS) involves in maintaining the stock details received from various production units, unloading and stocking of materials, processing of materials like cutting, bending, straightening, strapping, bundling etc., issue of materials to customers and various stockyards .
Responsible for:
- Analysis on Application Enhancement Requirement.
- Impact Analysis and study on the existing application system.
- Application Design - Based on the Enhancement requirement.
- Developed PL/SQL Stored Procedures to incorporate the changes.
- Enhanced Front-End Interface for the application. (Visual Basic 6.0).
- Developed Functional Test cases and validated the result-set.
- Production Deployment and Presentation to End Customer.
EDUCATION:
Masters in Computer Applications (M.C.A).
Bachelor of Science (B.Sc) in Mathematics and Computer Science.