Sushma
developermaxm@gmail.com 302-355-2347
.
.
.
.
.
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 ||
