SQL Developer looking for new project last project Completed Yesterday.....

Sushma
 developermaxm@gmail.com                                                                                       302-355-2347

PROFESSIONAL SUMMARY

• 9+ years of experience in Design, Development, Implementation and Maintenance of Data warehouse applications as an ETL/OLAP and OLTP Developer in MS SQL Server 7.0/2000/2005/2008. 
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like SQL Server BI Tools (SSIS and SSRS).
• Extracted data into Data warehouse Facts and Dimensions tables using SQL SERVER 2000/2005 Integrated Services (DTS/SSIS).
• Very good experience and knowledge on SCD Types (Type1, Type2) and Change Data Capture (CDC).
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Experience in Microsoft SQL 2005 Server migrationfromSQL Server 2000, Integration Service (SSIS), Crystal Reports and Reporting Service (SSRS).
• Excellent in High Level Design of ETL SSIS Package for integrating data from sources (Excel, CSV, flat file, Text Format Data).
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrate the DTS Packages to SSIS Packages by using Package migration Wizard.
• Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
• Extensive experience working with repositories such as Team Foundation Server (TFS), and Cheetah.
• 24/7 on call Production Support.

                                         

TECHNOLOGY

Languages/ Web Tools:T-SQL, Visual Studio 2005/2008/2010/2012/2014,VB.NET,C#, VBScript.

Databases/ RDBMS:   SQL Server 2008R2/2008, 2005/ 2000.

Operating Systems:    Windows XP/ 2000/ NT 4.0/ 98/ 95, and UNIX

Version Control:Team Foundation Server (TFS), Cheetah Tracking System

Other Packages/ Tools:MS Visio, SSIS (ETL), SSRS, Erwin, and Microsoft Office SharePoint Server 2007, Microsoft Office Access, Microsoft Excel.

PROFESSIONAL EXPERIENCE

Scottrade, St. Louis, MO        Jan 2015 - Till date

Role: Senior Database Developer

Responsibilities:

• Gathered requirements from business analysts and documented them based on functional specifications.
• Created design document for the package that needs to be developed which includes the name, description and mapping information of the package.
• Worked on SharePoint 2007 for storing the design documents and documentation.
• Developed ETL package with different data sources (SQL Server, Flat Files, Excel Source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services.
• Integrating heterogeneous data from sources such as DB2, Oracle,flat files and MS Excel to SQL Using SSIS.
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed and developed various packages using various task like For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Used SharedObjects to configure the SSIS package.
• Performed activities like analyzing and improving the databases objects.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
• Created complex Stored Procedures for validation process & for loading data from the staging area to the product database in SQL 2008.
• Developed Complex Stored Procedures views, tables and generated TSQL script for application.
• Customized & optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
• Used TFS to work on SSIS packages, Database objects and to write unit test cases for the stored procedures written.
• Replaced old back office AS400/iSeries source files with stored procedures for new back office system.
• Recreated packages with the new source as stored procedure to meet the requirement.
• Transformed end data into xml format and sends it to message queue through SSIS packages.
• Created rollout script for all the packages and objects that are to be deployed to QALAB and QFinal.
• Fixed various issues raised in testing environments.
• Created documentation for each and every package that has been worked on.
• Provides status updates to supervisor on weekly basis.
• Maintained technical knowledge through trainings and other measures.

Environment: SQL Server 2008/ 2008R2/2014, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel 2007, Visual Studio 2008/2010/2013, SharePoint 2007.

Sentara HealthCare, VA Beach, VAMar 2013 –Jan 2015

Role: SQL(SSIS) Programmer/DBA

.....
.
.
.
.
.

Thanks & Regards,

Bhaskar

Sr. Bench Sales Recruiter|| IT RESOURCES INC ||

---

Phone: 302-355-2347 || bhaskar@it-resinc.com|| www.it-resinc.com || 220 Continental Dr, Ste#104, || Newark || DE || 19713 ||