Sql Resume
Pittsburgh, PA
PROFILE SUMMARY:
- 3+ years of experience in SQL Server, Installation, Configuration, Development. Enormous use of SSIS for developing, deploying several number packages, on server, from heterogeneous databases along with Migration (MSMA). Extensive experience in development and deployment of different types of customized reports using SSRS, Server Troubleshooting, Database Backup and Recovery.
- Very strong experience in development of procedures, functions(UDF also), packages and triggers, cursors, indexes, synonyms, collections, Exception handling, Query Tuning using query optimizer, profiler in the development, design & optimization of SQL Server database.
- Installation of SQL Server 2005, 2008 with Server Reporting Services (SSRS) & Integration Services (SSIS) .
- Extensively worked on SQL Server Report Services (SSRS) Designer, Operator and troubleshooting with data sources.
- Expert in developing and deploying cascadingparameterized, Drilldown, adhoc reports with linking sub reports in various file formats with respect to client requirement.
- Expertise includes analysis, design, development and application using SQL Server Integration Services (Control Flow, Data Flow,Data transformation Tools, Data Conversion).
- Extensive knowledge in designing ETL objects mappings, using mapping operators, transforming data in SSIS.
- Very strong experience in development of test plan, test scripts using QC(QualityCenter)
- Experience in QMF Database Query tool.
- Efficient in quickly understanding Data Mapping document and prepare test plan.
- Participating in test plan meetings and discussions.
- Took part in creating technical specifications from Business requirement and Development team.
- Took part in Defect status meetings with Development and QA team.
- Took part in creating technical specifications from Business requirement.
TECHNICAL SKILLS
OPERATING SYSTEMS: Windows 7/Vista/XP/NT/2000, Windows Server 2003/2000
BI &ETL TOOLS: SSIS (2008/2005), SSRS (2008/2005)
DATBASE: MS SQL Server 2008/2005/2000, MS Access 2003/2000, DTS 2000, PL SQL
PROGRAMMING: C, C++, DS, Visual Studio 2010/2008/2005, .Net (VB, ADO), SQL*Plus, HTML, XML
OTHER BI TOOLS: Erwin 7.0, OLAP, OLTP, SQL Profiler, MSMA, SSAS (2005), (Microsoft Migration Assistant), JDE (Java Development Environment), BRM (Business Resource Management), Business Intelligence, Crystal Reports, MS-Office 2003/2007 Suite, MS-DOS, Adobe
EDUCATION& CERTIFICATIONS
- BACHELORS
- POST GRADUATE DIPLOMA IN COMPUTER APPLICATION
- Masters in Information Technology
- Masters Of Computer Science(MS)
PROFESSIONAL EXPERIENCE
Confidential, (Pittsburgh, PA)
SQL developer/QA Analyst (Database Testing, Service Testing, ETL Testing)
April2012- Till Date
Description: Confidential,is a diversified information management company that for four decades has given market leaders the competitive edge in data management, advanced analytics and technology. Our research focus and innovative solutions not only transform industrial and institutional practices; they illuminate the range, reach and potential of what we can do to infuse your organization with new energy. Whether within a process, across the enterprise, or throughout the supply chain, we help our partners put their data to work in powerful new ways - seven of our top ten clients have been with us for 20 years or more. Put MSA to work for you.
Responsibilities:
- Go through the requirement of the projects and discuss scope, specifications and risk involved in testing.
- Prepare Test Plan and explain the same to the authorities for approval.
- Create data mapping,
- Discuss with the team for timelines.
- Discuss different technical involvements with the development team.
- Working on Silk Test.
- Working with Test Manager for Front End, Performance, Stress, Regression and Backend Testing
- Involved in different technical and QA team meetings to review the step by step performance from QA Analysts.
- Prepare different queries for database testing manually as well as using SQL Server Management Studio.
- Log defects and in Test Manager and check daily status of the same till its closed or deferred.
- Schedule defect meetings with technical, QA team and managers.
- Explain the status and reasons for the defects and the risk involved before if it go to production
- Prepare QA summary of the achievements and difficulties faced in the same project and explain to the lead to get it approved.
Environment: SQL Server 2008/2005,T-SQL, SSIS(2008/2005), SSRS(2008/2005), SQL Server Management Studio(2008/2005), Business Intelligence, Microsoft Visual studio (2008/2005), Windows Vista/XP, MS-Office suite 2003/2007,Windows Server 2003,.NET(VB,C#).
Confidential, (Columbus, Ohio)
SQL developer/QA Analyst (Database Testing, Service Testing, ETL Testing)
August2011- March3012
Description:A regional bank committed to Midwest markets. They deliver easy access to competitive products, innovative features, and tools to help you manage your money and your business—all backed by the best service in the industry. It provide personal banking for individuals and families, small business banking, banking for middle market businesses and nonprofit organizations, and specialty financial services through offices and more than 600 local branches, more than 1,300 ATMs, and via online and mobile banking across six states: Ohio, Michigan, Indiana, Pennsylvania, West Virginia, and Kentucky. There headquarter is in Columbus, Ohio, but each of our Huntington branches and offices serves as headquarters for local customers\' financial needs.
Responsibilities:
- Go through the requirement of the projects and discuss scope, specifications and risk involved in testing.
- Prepare Test Plan and explain the same to several technical and management authorities for approval.
- Go through the data mapping, discuss with the team for timelines.
- Discuss different technical involvements with the development team.
- Worked with WSEB and mainframe testing using Huntington own service testing tool.
- Worked with ETL testing using QualityCenter.
- Involved in different technical and QA team meetings to review the step by step performance from QA Analysts.
- Prepare different queries for database testing manually as well as using QMF (database query tool)..
- Log defects and in QualityCenter and check daily status of the same till its closed or deferred.
- Schedule defect meetings with technical, QA team and managers.
- Explain the status and reasons for the defects and the risk involved before if it go to production
- Prepare summary of the achievements and difficulties faced in the same project and explain to the lead to get it approved.
Confidential, (Hoffman Estates,IL)
BI Developer (T-SQL, SSIS, SSRS)
Feb2011 – July2011
Description: Confidential,is a product line company having departmental stores in all over the US.It is the nation\'s fourth largest broadline retailer with over 4,000 full-line and specialty retail stores in the United States and Canada. Sears Holdings is the leading home appliance retailer as well as a leader in tools, lawn and garden, consumer electronics and automotive repair and maintenance. Sears Holdings is the 2011 ENERGY STAR® Retail Partner of the Year. Key proprietary brands include Kenmore, Craftsman and DieHard, and a broad apparel offering, including such well-known labels as Lands\' End, Jaclyn Smith and Joe Boxer, as well as the Apostrophe and Covington brands. It also has the Country Living collection, which is offered by Sears and Kmart. We are the nation\'s largest provider of home services, with more than 11 million service calls made annually. Sears Holdings Corporation operates through its subsidiaries, including Sears, Roebuck and Co. and Kmart Corporation.
Responsibilities:
- Gather report requirements and document technical specifications.
- Working on SRS document and implementing into functional level by making Data Models, both logical and physical using ERWIN.
- Developed SQL queries, functions, triggers, cursors, views and stored procedures.
- Created database objects like tables, views, synonyms, functions and also triggers using T-SQL.
- Primary focus was in the reengineering of the ETL processes using the SQL Server Integration Services (SSIS).
- Extracting data through T-SQL queries, stored procedure to create parameterized reports.
- Extensively worked on source data from Flat file source systems, SQL server source systems.
- Created table definitions and look-up reference data from Revenue Management
- Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
- Doing data transfer from various types of databases with conversion through SSIS.
- Using Data Cleansing to avoid duplicate, corrupt or inaccurate data using SSIS tools.
- Creating data elements mapping between data models to do data integration tasks.
- Extract data from star schema DSS data warehouse by creating and maintaining complex SSIS.
- Tuning package components like Script Task, Data Flow task, Data Conversion, Multicast, Sort,
- Conditional split, Script Component, Configuration file, etc.
- Analyze data and create column mapping for reporting
- Formatting the existing reports as well as creating new reports with different sources.
- Experienced in back and recovery of the SQL server 2005 database and also failover scenarios using SSAS.
- Create and maintain SQL queries and stored procedures.
Environment: SQL Server 2008/2005,T-SQL, SSIS(2008/2005), SSRS(2008/2005), SQL Server Management Studio(2008/2005), Business Intelligence, Microsoft Visual studio (2008/2005), Windows Vista/XP, MS-Office suite 2003/2007,Windows Server 2003,.NET(VB,C#).
Confidential, (San Jose, CA)
BI Developer (T-SQL, SSIS, SSRS)
Sep 2010 – Jan 2011
Description: Confidential,with its business worldwide, is a tooth aligner company located in San Jose, CA. This project mainly focus on the migration of the data from different database sources, in different environments, through ETL(SSIS) process, testing, integrating and deploying into the existing server database followed by different types of report retrieval of the data using SQL,SSRS, SSAS.
Responsibilities:
- Primary focuses were in the reengineering and extracting data from two different data sources using ETL process SQL Server Integration Services SSIS(2008).
- Gather report requirements and document technical specifications.
- Working on SRS document and implementing into functional level by making Data Models
- Participated and finished a training on LMS related to the business systems
- Create and maintain T-SQL queries and stored procedures, functions, triggers.
- Tuning package components like Script Task, Data Flow task, Data Conversion, Slowly Changing Dimension, Look Up, Derived Column, Multicast, Sort, and Conditional split, Script Component, Configuration file.
- Created dynamic configuration packages and deployed successfully.
- Developing, testing and deploying SSIS packages, dynamic configuration packages.
- Created backup and tested the packages with user level testing cases for SSIS packages.
- Analyze data and create column mapping for reporting with SSRS.
- Created report template, retrieved many number of reports using SQL Server, SSRS, SSAS with retrieval, optimization of existing reports
- Retrieval of the data from T-SQL queries, stored procedure to create parameterized reports using SSRS.
- Created Ad-hoc reports using SQL Server Reporting server.
- Test cases on different kinds of reports.
- Retrieval of the data from T-SQL queries, stored procedure to create parameterized reports,multivalue parameterized reports ,cascading reports,drill-down and drill through reports using SSRS.
- Creation of reports using MDX queries in SSAS.
- Co-ordinate and support the team on technical support and documentation
Environment: SQL Server (2008/2005), SSIS(2008/2005), SSRS(2008/2005) SSAS (2005), Server Management Studio (2008/2005), Business Intelligence, Microsoft Visual studio (2010/2008/2005),Windows Vista, Windows XP, MS-Office 2007, JDE(Java Development Environment), Oracle, BRM(Billing and Revenue Management), Adobe
Confidential, (Mumbai, India)
Junior DATABASE DEVELOPER
October 2004 – September 2005
Description: Confidential,is an affiliate company of Reliance Info-communications Ltd, Mumbai, India. Reliance Info communications Ltd. is India\'s largest private information and communication services provider. It has international points of presence in New York, Los Angeles, London and Hong Kong seamlessly integrated with domestic gateways located at Mumbai, Delhi, Chennai, Kolkata and Ernakulum. The Project goal was to gather requirements from Business users and designed, developed and maintained the tool for making decisions depending on different scenarios, Giving weekly reports and integration of data from different sources.
Responsibilities:
- Participated in the full software life cycle.
- Participation in weekly design reviews and walkthroughs with project manager and development team.
- Worked on database design with the team.
- Measured the performance of the shell scripts by getting the expected results.
- Involved in writing T-SQL code using the technical and functional specifications.
- Generated SQL install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
- Involved in writing T-SQL Packages, Functions, Stored Procedures and Data Base Triggers.
- Documented business rules, functional and technical designs, test cases, and user guides.
- Involved in the debugging and error handling.
- Monitored the database growth on daily basis. Established backup and recovery strategies. Worked on Database tuning and performance monitoring.
- Extracting databases from different resources.
Environment: MS SQL2000,C, UNIX, T-SQL, DTS, Windows XP, Windows Server 2000, MS-Office 2003 Suite.