SUMMARY

• Around 10+ years of experience in Database Design, Development and maintenance of database applications on Informatica, Talend, SQL in OLTP/OLAP/BI environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as team member.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Experience in monitoring SQL Server Performance tuning in SQL Server 2000/ /2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report on SSAS Cube and using SSRS to develop Drill - down, Drill-through And Cascading reports.
• Implemented High Availability & Disaster Recovery techniques, Database Mirroring, Transactional Replication and Log Shipping.
• Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012.
• Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Experience in Physical and logical data modeling using ERWIN & VISIO.
• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
• Experience in BI Development and Deployment of SSIS packages from Access, SQL and Oracle.

TECHNICAL SKILLS

Project methodology: Rational Unified Process (RUP), UML, Agile

Database: Informatica, Oracle ETL, SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Team Foundation Server(TFS) Proficient, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP, Oracle 10g, 11g, 12c, 19c, MS SQL Server 2008/2012, 2017, 2019Teradata 12/13, MS access

MS office tools: MS Visio, MS Project, MS Excel, MS SharePoint, MS PowerPoint

Testing Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Scripting: PL/SQL, T-SQL, XML, HTML

Querying Tools: Quest TOAD 9.1, SSMS 2008/2012, Teradata SQL AssistantModeling Tools Erwin, ER studio(embarcadero), toad data modelerBA Tools IBM DOORS, Rational Requisite Pro, Remedy suite, IBM RAT, RQA, DXL

ETL/BI Tools: Microsoft SQL Server Reporting Services, Crystal Reports, DTS, SSIS, Erwin and Visio. Visual Studio, SSIS Packages, SSRS Reporting, Visual SourceSafe, MS Office, Business Object XI, Crystal Enterprise, SSIS, SSAS, SSRS Power Pivot, Power view, DTS, MDX, ODBC.

PROFESSIONAL EXPERIENCE

Confidential, Portsmouth, RI

Sr. SQL Developer

Responsibilities:

• Designed and developed various ETL Pakages,, SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.
• Created logic and indexed tables/views/stored Procedures based on the business requirements
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Data migration from text files, DB2, excel files to SQL server, successfully created database diagrams and physical models for the project.
• Experienced solving issues raised by QA, UA for database, supported the different UI with back end logics, and wrote SQL codes to summarize the data.
• Responsible for Data migration from old SQL Server to latest SQL Server Databases.
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
• . Created database objects like tables, users, roles, stored procedures, triggers, worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
• Created Views to enforce security and data customization, Created Non - Clustered indexes to improve query performance and query optimization, Involved in the performance tuning and optimization of T-SQL queries.
• Developed user requested reports using Crystal Reports and Excel.

Environment: Informatica, Oracle, MS SQL Server R2, T- SQL, MS Microsoft SQL Server Integration Services (SSIS)R2, Microsoft SQL Server Reporting Services Microsoft SQL Server Analysis Services (SSAS) R2, SQL Server Business Intelligence Development Studio, ETL, Oracle Packages, Star Team Version Control tool), Erwin /MS Visio

Confidential, NJ

SQL Developer

Responsibilities:

• Migrated DTS packages from SQL Server 2000 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Installed, authored, and managed reports using SQL Server 2012 Reporting Services.
• Rebuilding/Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point - In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• To set up SQL Server configuration settings for better server management.
• Experience in using SQL Server Profiler & SQL Server Agent.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Worked as a database and SQL developer, did extensive work on creating partitions on tables, creating relational databases.
• Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
• Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
• Created and Modified Stored Procedures, Triggers, Tables, Views and also making use of Merge Statements instead of Cursors in T-SQL

Environment: MS SQL Server 2005/2008/2012 , MS SQL Server Integration / Reporting Services 2012 OLTP, MS SQL Server 2008R2, MS SQL Server Analysis Services 2008R2, Integration Services (SSIS), T-SQL, MS Excel, Tortoise SVN, Waterfall Environment, C#.NET, VB.NET, XML, SQL profiler, MDX, SSIS Expression Language, CMD prompt, SQL Server Configuration Tools, Toad for SQL Server, SQL Compare and Ervin Data Modelling Tool, XPath