SUMMARY

• 7.5+ years of experience as a SQL developer, Supporting and Maintenance of SQL Server Integration Services (SSIS), Reporting Services (SSRS)
• Solid experience in T - SQL query writing and creation of database objects like Tables, Views, Stored Procedures and Functions, Triggers, Indexes
• Excellent knowledge on Creating, altering, troubleshoot and de-bugging SSIS packages
• Experience in designing Ad hoc reports and different types of Drill Down, Drill Through reports, Tabular reports, Cross tabs, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS 2005/20
• Expertise in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, Merge join, union all
• Written SQL queries for DML operations and for stored procedures and functions
• Experience in Trouble Shooting and Query Optimization techniques
• Knowledge on Data warehousing concepts
• Experience with T-SQL/PL-SQL programming, experience with CLR-functions and CLR-stored procedures
• Ability to use multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, Merge join, union all, and slowly changing dimension
• Good SQL Server Administration skills including, Backups, Disaster Recovery, database maintenance, user authorizations, Database creation
• Knowledge on converting EXCEL to SQL reporting services
• Excellent Communication, Learning, Problem Solving, Conceptual Skills, Ability to work effectively in a team environment or Individual
• Self-motivated and ability to work effectively as a part of a team. ‘Doing whatever it takes’ is my mantra to success
• Able to adapt to changing requirements and conditions and able to work in fast paced environment

TECHNICAL SKILLS

ETL Tools: Visual Studio, BIDS, Management Studio, Microsoft Office Suite, SSRS, SSIS, Data Transformation Services (DTS), DTS Import/Export Wizard

Database Tools: SQL Server 2005/20, MS Access, Oracle 10g

Reporting Tools: SQL Server Reporting Services (SSRS) 2005/2008/2012

Operating System: Windows 95/98/NT/XP/2000, UNIX/LINUX, Sun Solaris

Programming Languages: SQL, Transact SQL/T-SQL, PL/SQL, Powershell, MS Office 2012/2010/2007 , UNIX Shell Scripting, XML, HTML, C, C++, Microsoft Team Foundation Server

Others: Microsoft Team Foundation Server (Revision control), Axosoft, Agile, Real Estate Transaction Standard(RETS)

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

SQL\ETL developer

Responsibilities:

• Data Migration/Production Support
• Interacting with business and getting the requirement, ETL development/architecture/design
• Responsible for implementation of Microsoft SQL Server databases in concurrent large-scale database migration and implementation projects. Database setup and installation
• Configuring new Microsoft SQL Server databases, migrating data and objects from established databases into the new databases utilizing a sustainable process
• Database implementation responsibilities include analyzing data and defining database design and optimizations, database configuration, performing data mapping and transformations and migrating data
• Database Support responsibilities include troubleshooting, diagnosing and resolving a wide range of database issues with complex interdependencies, developing corrective SQL scripts, stored procedures and database fixes, data migration scheduling and monitoring, analyze and implement database change requests and enhancements
• Importing data from EXCEL/TEXTFILES or from other files into SQL server 2005/2008/20012/2014
• Interacting with other SQL Servers. Generating mapping document (Source to Target (matrix, CREA databases)); Written T-SQL quires using all the functions, joins, SQL operators, clause and constraints
• Designing ETL using stored procedures and SSIS packages to meet the requirement
• Generating any possible reusable “automated process” for project to reduce manually time effortof Team
• Designing ETL using stored procedures and SSIS packages to meet the requirement
• Generate ETL related Objects to make automated JOB to migrate data.
• Fixing any of the application related DB issue for Other Projects
• Knowledge of data transformations of all types including calling custom scripts, applying complex logic Migration of Contacts from source DB to destination DB
• Running Field Usage Report on Source data. Ability to resolve complex data issues and Experience in troubleshooting ETL issues. Generate Lookup and Dictionaries

Environment: SQL Server 2005/20, Integration Services (SSIS), Reporting Services (SSRS), T-SQL, PowerShell, C#, Windows 95/NT/2000/2003, XML, MS Excel, MS Access

Confidential, Greensboro, NC

Implementation Specialist\SQL developer

Responsibilities:

• Present technical overview of FirstStrike and technical requirements to clients when planning implementations and upgrades; Manage setup of technical environment for hosted clients
• Provide assistance to clients when designing interfaces from their ERP system(s) and FristStrike.
• Data definition, data manipulation, data control, and transactional control, Administration, including creating and restoring SQL backups.
• Development, including creating and troubleshooting DTS packages, stored procedures, complex data queries.
• Good working knowledge of Windows networking, including IIS and Windows security admin; FTP, secure FTP and PGP
• Designing ETL using stored procedures and SSIS packages to meet the requirement
• Designing interfaces from client ERP systems into FirstStrike. Lead testing of those interfaces. Includes reconciling data between client’s ERP system(s) and FirstStrike.
• Configure FirstStrike, including setting up nightly batch jobs.
• Serve as the technical expert for client software implementations and as a primary contact for client’s IT department.
• Troubleshoot network, database, and software problems for client implementations.
• Conduct technical training for designated client IT owners of the software.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins,
• Functions and database links and formatted the results into reports and kept logs
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, functions and database links and formatted the results into reports and kept logs
• Worked with Help Desk personnel to resolve client installation issues;
• Communicate/coordinate with Client Value Team as well as Audit team to support clients.

Environment: SQL Server 2008/2012/2014 , Integration Services (SSIS), T-SQL, PowerShell, Windows 95/NT/2000/2003, XML, MS Excel, MS Access, MS office, Friststike portal.

Confidential, Greensboro, NC

SQL\ETL developer

Responsibilities:

• Data Migration/Production Support
• Interacting with business and getting the requirement, ETL development/architecture/design
• Responsible for implementation of Microsoft SQL Server databases in concurrent large-scale database migration and implementation projects. Database setup and installation
• Configuring new Microsoft SQL Server databases, migrating data and objects from established databases into the new databases utilizing a sustainable process
• Database implementation responsibilities include analyzing data and defining database design and optimizations, database configuration, performing data mapping and transformations and migrating data
• Database Support responsibilities include troubleshooting, diagnosing and resolving a wide range of database issues with complex interdependencies, developing corrective SQL scripts, stored procedures and database fixes, data migration scheduling and monitoring, analyze and implement database change requests and enhancements
• Importing data from EXCEL/TEXTFILES or from other files into SQL server 2005/2008/20012/2014
• Interacting with other SQL Servers. Generating mapping document (Source to Target (matrix, CREA databases)); Written T-SQL quires using all the functions, joins, SQL operators, clause and constraints
• Designing ETL using stored procedures and SSIS packages to meet the requirement
• Generating any possible reusable “automated process” for project to reduce manually time effortof Team
• Designing ETL using stored procedures and SSIS packages to meet the requirement
• Generate ETL related Objects to make automated JOB to migrate data.
• Fixing any of the application related DB issue for Other Projects
• Knowledge of data transformations of all types including calling custom scripts, applying complex logic Migration of Contacts from source DB to destination DB
• Running Field Usage Report on Source data. Ability to resolve complex data issues and Experience in troubleshooting ETL issues. Generate Lookup and Dictionaries

Environment: SQL Server 2005/20, Integration Services (SSIS), Reporting Services (SSRS), T-SQL, PowerShell, C#, Windows 95/NT/2000/2003, XML, MS Excel, MS Access