Summary:

SQL, Sql Server, SSIS,

Technical Skills:

SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SSIS, SSIS 2005, SSIS 2008, SSIS 2012, SSIS 2014,

Experience:

Collabera

Consultant

Project 1

• Actively participated and interacted with users, DBAs and technical manager to fully understand the requirements of the system.
• Performance tuning of existing database objects including stored procedures.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL in SQL Server 2008R2.
• Scheduled jobs, Alerts using SQL Server Agent.
• Responsible for the design, development and implementation of dynamic and customized SSIS packages for ETL extract, transform, and load development following company standards and conventions.
• Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Sort and Execute SQL Task to load data into Database.
• Created ETL process to refresh the data from data warehouse to data mart.
• Created incremental package to refresh the data.
• Used various transformations in SSIS dataflow, tasks and container in control flow.
• Created SSIS Packages to import and export data from different clients.
• Data conversions and data loads from various databases and file structures.

Project 2

• Coordinated with front-end for implementing logic in stored procedures and functions.
• Developed stored procedures, functions, views, triggers, and migrated data from different databases to SQL server.
• Developed entity-relationship diagram and data dictionary for project coordination created SQL create, alter, and insert scripts.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Generated SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.

Project 3

• Participated in meetings for gathering functional requirements and served as the primary point of contact for most of the Enterprise Business intelligence design and development.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and maintain data efficiently.
• Involved in installing and maintaining MS SQL Server 2008R2.
• Designed SQL Server Integration Services SSIS packages to extract data from different sources to SQL Server Data Warehouse.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Created SSIS packages for importing the Excel layouts into the database using SSIS.

Confidential

Consultant

Project 1

• Managed multiple SQL Server installations
• Designed and created databases for 2 new applications.
• Coded all stored procedures for new applications.
• Trouble-shooting for C coding on user-interfaces.
• Migrated databases and database objects from development to production servers.
• Created and managed jobs on SQL Server 2012
• Created linked servers to Oracle 11 databases.
• Visual Studio 2013/Oracle Developer/SQL Server Management Studio development environments

TTI Global

Consultant

Project 1

• Studying the business requirement document, interact with the client and prepare the system design document.
• Updating the project status to the team in weekly status meeting.
• Managing of database objects like Tables, views, indexes etc.
• Performing Importing and exporting the data using DTS.
• Deploying the SSIS Packages into Production environment.
• Supporting to development team via giving the master tables structures , master data and giving staging server access
• Worked with developers to write the SQL queries and SPS and cursors.
• Deploying the SSIS Packages into Production environment.
• Performing backups on timely basis as routine maintenance
• Managing Security Creating users, logins and roles, granting permissions
• Creating and Monitoring the DB Jobs and Maintenance planes.
• Updating the project status to the team in weekly status meeting.
• Configured the Replication in our Project.
• Maintained Traceability between Requirement and Test cases.
• Experience with Mercury quality center for management of Requirements, Test Cases and Defects.

Otis IT Inc

Consultant

Project 1

• Worked with data modeling product support team on tool features, functionality and maintenance.
• Involved in installing SQL Server 2005 and Management tools using SQL Server Setup Program.
• Involved in the creation of database objects like tables, views, stored procedures, triggers, functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Wrote standard and complex T-SQL Queries and used joins and stored procedures to make sure results matched back to expected results based on business requirements.
• Run Import/Export wizard to provide CSV and Excel files to managers for the particular records they want for different meetings.
• Designed and developed SSIS ETL packages for migrating and transforming data from multiple sources like SQL Server and other sources so that it can be used and fed into the data ware house for reporting services.
• Created SSIS Packages to perform filtering operations and automated it to import the data on daily basis from the sources to SQL Server.

Paladin

Consultant

Project 1

• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement using the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.

Confidential

Consultant

Project 1

• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25 after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Confidential

Consultant

Project 1

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL Extract, Transformation and Load strategy to populate the insurance data from various source systems feeds using SSIS
• Installed, configured and maintained SQL Server Integration Services SSIS .
• Created packages using Integration Services SSIS for data extraction from Flat Files, Excel Files OLEDB.
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
• Implemented SQL Server OLAP services SSAS for building the data cubes.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data
• Involved in building dimensional cubes with SQL Server Analysis Services SSAS and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes SSAS and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures using MS SQL Server.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Configured product meta-data tables to support client data reporting needs.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries

Confidential

Consultant

Project 1

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Configured and monitored database application.
• Created tables, indexes and constraints.
• Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Used Data Transformation Services DTS an Extract Transform Loading ETL tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Designed and implemented several complex reports and administration modules.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Prepared of project documentation.
• Prepared test plans for assembly testing System Integration testing.

Confidential

Consultant

Project 1

• Created Complex Stored Procedure, Triggers, Cursors, Tables, Views and other T-SQL JOIN techniques.
• Designed and developed ETL process for extracting data flat file to SQL server 2005 using SSIS.
• Developed transformation services to bring the data into SQL server
• Determined the SQL Server Installation. Installed SQL Server Management tools
• Created and executed SSIS packages to populate data from the various data sources. Data migration import export/BCP from Text to SQL Server.
• Discuss and implement requirements.
• Co-ordinate and work with a global team.

Confidential

Consultant

Project 1

• Migrated data from SQL Server 2000 to SQL Server 2005 with SP2.
• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers maintaining Referential Integrity.
• Developed scripts to migrate data from multiple sources.
• Maintained the security, integrity and availability of SQL Server.
• Performed data backup, recovery, and transfer operations.
• Analyzed business recovery requirements and maintenance strategies and plans for critical databases.
• Database space management.
• Was Responsible for creating, deploying and scheduling new SSIS packages.
• Did Migration of the data from DTS to SSIS packages.
• Created reports using SSRS.
• Managed devices and databases, administered security, scheduled tasks, monitored server and database performance. Monitored allocation of memory and procedure cache, etc.
• Worked with the other IT associates to design, implement, test, and enhance stored procedures and other applications necessary to support systems and file processing.
• Designed, added, eliminated, and maintained indexes, organized tables, recommended changes to application development team.
• Appropriately tuned database applications and monitored their performance for achievement of efficient database access for applications.
• Performed data extraction and migration activities for populating test or non-production and customer databases.
• Completed administration of MS SQL Server version 2000/2005.