Sql Server Data
Resume:
Sobby Mathew
Lafayette hill, pa 19444
***********@*****.***
SUMMARY:
. 6 years of experience in Information Technology including ETL
Design/Operational Data Store(ODS)/Data Warehousing, Design,
Development, Implementation and Testing of Various Decision Support
systems(DSS).
. 4 plus years of experience in developing ETLs through SQL Server
Integration Services (SSIS).
. 2 plus years of experience using SSRS (SQL Server Reporting Services).
. 2 years of experience in Informatica Power Center versions 7.x/6.x.
. Designed and developed Packages and Data flows in SQL Server SSIS.
. Development of Standard Packages to perform certain reusable tasks
like performing Zipping and Unzipping files, Encrypting and Decrypting
files.
. Migration of packages between environments as well as Production
Support.
. Migration of DTS packages to SSIS packages.
. Experience creating packages in SSIS to load data from various
sources into SQL 2005 as well as using it to create packages to load
data from Oracle to DB2 and vice versa.
. Extensively worked on Transformations for data loading as well as data
validations. Designed and developed processes to identify the data
errors and provided suggestions to resolve the data issues (Error
Handling mechanisms).
. Automation of packages using SQL Server Jobs.
. Monitoring jobs through Log providers and creating tables to keep
track of Audit Performance tuning by reviewing the current design and
using other Custom transformations like Table Difference, Flow Sync
and Distinct.
. Creating Package dependencies by calling Child packages from the
parent using SSIS as well as scripts.
. Implementing Dynamic configurations using XML files, SQL Server and
Registry Settings
. Implemented Type 1, 2, and 3 Slowly Changing Dimensions.
. Hands on experience in Tuning packages to identify and eliminate
performance Bottlenecks and Error Handling Mechanisms
. Experience in Migrating DTS Packages to SSIS Packages.
. Developing Batch and .Net scripts to send HTML emails as well as for
finding the Row Count and file size and integrating them into the SSIS
packages.
. Experience in handling large volumes of data in Production
environment.
. Experience creating reports that have features like drill down,
document map and linked reports using SSRS.
. Created reports that are based on data selected from dropdown menus.
. Used a variety of controls like Tables, Matrix, List, Chart and Image.
. Used Subscriptions to set up Push based Report Delivery.
. Knowledge of Dimensional Data Model concepts, Dimension and Fact
tables, Surrogate keys, Star and Snow Flake Schema, Physical and
Logical Data modeling.
. Understanding of Kimball and Inmon methodologies.
. Experience with databases like SQL Server 2008/2005/2000, Oracle, DB2
as well as developing SQL code (T-SQL) through various procedures,
functions, views and triggers to implement the business rules.
. Experience in UNIX Shell Scripting.
. A Team Player with excellent communication, analytical, verbal and
writing skills. A quick learner, organized, resilient and self-
motivated.
TECHNICAL SKILLS:
Languages\ Scripting Languages\
SQL, PL/SQL, HTML, XML, C, \ Perl, Bash-UNIX- Shell scripting\
C++, Visual Basic 6.0, Java, ASP, \
ASP.NET, COBOL, CGI\
Data Bases\ Query Tools\
SQL Server 2008\2005\2000 \ Toad, SQL Query Analyzer\AQT
Oracle 9i/8i, DB2, MS Access, \
ETL Tool\ Data Modeling\
SQL Server SSIS 2008\2005 \ Visio 2000/2003, ERWIN4.0/3.5/3.x\
Informatica 7x/6x/ Power Center \
Other Tools\ Reporting Tools\
Visual Source Safe, Auto-Task, Cron jobs\ SSRS 2008\2005
MS Project\ Accurev\Symphony\SVN
Operating Systems\
HP-Unix, LINUX, Windows XP/NT/2000/2003\Vista
Professional Experience:
Janney Montgomery Scott, Philadelphia, PA Jan 2010 -
Till Date
SSIS/SSRS ETL Developer
Established in 1832, Janney Montgomery Scott LLC is a full-service
financial services firm, providing comprehensive financial advice and
superior service to individual, corporate and institutional investors.
Responsibilities
. Involved in Migration of their legacy CRM systems into their new one.
. Migrated data using SSIS 2008 from their old CRM system ACT! into Sage
Saleslogix which is their new CRM.
. Created SSIS Packages and SSRS Reports for their Reporting Project
which involved implementing the business logic within the package and
placing the end result in a table which would be used within SSRS to
build the reports.
. Created SSIS packages to Load their Data warehouse and used SSRS to
create Reports for the Business users
. Create SSRS reports that had security based on their logins
. Created Admin Reports in SSRS to help administer the SQL Servers.
. Used a variety of transformations including Execute SQL Task, Union
All, Merge Join, Lookup, OLE Db Command, Fuzzy Lookup, Derived Column.
. Performance tune the packages perform better.
. Implement Logging and Error handling mechanisms.
. Enable Configurations using Xml and SQL Server tables.
. Involved in Unit Testing the package and Production Support.
. Create jobs using SQL Server Agent.
. Build SSRS reports using Tables, Charts, Gauge and Matrix.
. Performance tune reports using Caching and Snapshots.
. Scheduling reports using Data Driven Subscriptions.
. Administer and Deploy reports to the report server
. Migration of DTS 2000 Packages to SQL Server 2008 SSIS Package
Environment:
SQL Server 2008/2005/2000, SQL Server SSIS 2008, SSRS 2008, Windows
2008/2003, Windows XP, SQL Server Management Studio, Flat Files, Excel
Sheets.
IMS Health, Plymouth Meeting, PA Apr 2009 - Dec
2009
SSIS/SSRS ETL Developer
IMS Health is an international company that supplies the pharmaceutical
industry with sales data and consulting services. IMS also uses their own
data to produce syndicated reports such as market forecasts. These predict
how a market in a specific country or specific therapy area will change
over time.
Responsibilities
. Worked on multiple Data Marts like QMI, Radar, Client View, UDA, and
Rx Tools and was involved in the creation of SSIS packages to load the
data marts as well as use SSRS to generate relevant reports.
. Created SSIS packages to load various data marts from multiple sources
like SQL Server, Oracle and Flat Files
. Used a variety of transformations like For Each Loop, Execute SQL
Task, Derived Column, Merge Join, Lookup, Sort, Slowly Changing
Dimensions etc.
. Used Custom xml files to incorporate configurations as opposed to
standard xml files. Using the custom xml files all the environment
configurations could be stored in a single file.
. Implemented logging in SSIS packages using Text Files and log files
generated by the scheduling tool called cybermation.
. Implemented logic for Error Handling in SSIS.
. Involved in performance tuning SSIS packages due to the volume of data
that was involved
. Created a number of Reports using Tables, Charts and Matrix in SSRS.
. Created drill down, parameterized, Multi valued parameter, cascading
parameter reports
. Created complex reports that have up to 20 parameters and 170 columns
and involved in performance tuning the reports
. Created snapshots to send out emails with the report attached to a
specified set of users.
. Used caching and snapshots for performance tuning
. Set up both Push and Pull Based Report Delivery.
. Involved in the administration and deployment of SSIS packages and
SSRS Reports.
. Created the mapping documents for the ETL packages and also involved
in requirement gathering and writing specs and documentation.
. Active involvement in Testing as well as fixing the issues that rose
from it.
Environment:
SQL Server 2005, Oracle 10g, SQL Server SSIS, SSRS, Windows 2003, Windows
XP, SQL Server Management Studio, Flat Files, Excel Sheets, Toad 8.0
QVC, West Chester, PA Nov 2008- Jan 2009
SSIS ETL Developer
QVC, Inc., one of the largest multimedia retailers in the world, broadcasts
live 24 hours a day, 364 days a year. Its merchandise mix is similar to
that of a high-quality department store, featuring the best in beauty,
home, fashion, jewelry, and electronics.
Responsibilities
. Develop SSIS Packages to load Data Mart from Data Warehouse
. Created packages that connect to Oracle and DB2 as Oracle was the
source DB2 was the destination.
. Designed and Implemented logic for handling Errors and Logging.
. Wrote DB2 stored procedures using Merge Statement to load data
. Performance tuning by examining existing logic and choosing alternate
design
. Troubleshooting errors/failures caused by existing packages and fixing
them
. Creating jobs to run the packages using SQL Server Agent
. Migrating Packages between environments and Production Support
. Working with the Business Analyst to create Mapping Documents
. Created Standard Reports for Logging using SSRS
Environment:
SQL Server 2005 SQL Server SSIS, Oracle, DB2, Windows 2003, Windows XP, SQL
Server Management Studio, Flat Files, Excel Sheets, SQL Server Agent, AQT
StarCite, Philadelphia, PA May 2008- Oct
2008
SSIS/SSRS ETL Developer
StarCite, Inc. is the largest on-demand global meetings management company
in the global marketplace for corporate meetings and events. StarCite
brings together buyers and suppliers of meeting-related services on an
unprecedented scale; delivering value through world class technology and
services to both audiences.
Involved in creating a packages that will help extract data from
decommissioned systems (SOM and One Form) and load them into the Data
Warehouse for consolidation and building reports
Responsibilities:
. Develop SSIS packages to load the Data Warehouse from SOM and One Form
Databases.
. Worked on creating Mapping Documents with the Team Lead.
. Created SSIS packages using a number of transformations including
Execute SQL Task, Union All, Merge Join, Lookup, OLE Db Command as
well as Slowly Changing Dimension, Pivot and Unpivot
. Performance tuning by reviewing the current design and looking for
alternate designs and methods
. Using the Custom and SSIS logs to keep track of the errors.
. Creating logic for retries incase of missing files as well as
notifications in case of errors.
. Creating jobs in SQL Server Agent to run the packages
. Created standard and logging reports using SSRS (SQL Server Reporting
Services)
. Modifying existing packages to add new logic as well as increase
performance
. Writing .Net scripts to perform complex logic.
. Writing Stored Procedures to implement business logic.
. Using Checkpoints in packages to enable the package to run from the
point of failure.
. Using XML Configurations to make dynamic changes to packages.
. Creating Code Move Documents that are used to Move Packages, DDLs and
Stored Procedures across Environments
. Took the lead on migrating packages between environments
. Unit Testing the packages to ensure that they performed based on the
requirements and business logic
. Production Support for SSIS packages
. Created Documentation for Knowledge Transfer
. Created reports that have features like drill down, document map and
linked reports using SSRS.
. Used a variety of controls like Tables, Matrix, List, Chart and Image.
. Created reports that are based on data selected from dropdown menus.
. Used Subscriptions to set up Push based Report.
. Set up both Push and Pull Based Report Delivery.
. Worked in an Agile Methodology Environment
Environment:
SQL Server 2005 SQL Server SSIS, SSRS, Windows 2003, Windows XP, SQL Server
Management Studio, Flat Files, Excel Sheets, Visio 2003, SQL Server Agent,
SVN
HBK Investments, Park Avenue, NY Feb 2007-
Apr 2008
SSIS/SSRS ETL Developer
HBK Investments L.P. is a Hedge Fund based in Dallas, Texas. As of mid-
2007, it invests around $14 billion and employs over 350 individuals. In
addition to the main offices in Dallas, the firm maintains satellite
offices in New York, London, Tokyo, and Hong Kong.
Responsibilities:
. Design and Develop an SSIS template that would serve as the standard
template which all other SSIS developers would use.
. Working with the SSIS team in suggesting identifying loop holes in the
template design and suggesting alternative solutions.
. Develop SSIS packages to load the HBK Data Warehouse.
. Develop ETL Design and Package to Load the HBKPricing Data Mart
. Variety of transformations like Execute SQL Task, Union All, Merge
Join, Lookup, OLE Db Command as well as Slowly Changing Dimension,
Pivot and Unpivot was used.
. Performance tuning by reviewing the current design and using other
Custom transformations like Table Difference, Flow Sync, Distinct
etc...
. Monitoring jobs using the Custom SSIS log as well as the Standard in
built log.
. Creating logic for retries incase of missing files as well as
notifications in case of errors.
. Using the Default logging as well as Custom Log to keep track of the
package.
. Creating package dependencies by calling Child packages within Parent.
. Passing variables from Parent to child and vice versa using Standard
SSIS procedure as well as using scripts.
. Testing and Migrating packages between environments
. Migrating SQL Server 2000 DTS packages to SSIS Packages.
. Used a various report controls like Tables, Matrix, List, Chart and
Image to create reports with drill down, document map, dropdown menus
and linked reports using SSRS.
. Used Subscriptions to set up Push based Report.
. Modifying existing packages to add new logic as well as increase
performance
. Writing .Net scripts to perform complex logic.
. Writing Stored Procedures to implement business logic.
. Using Checkpoints in packages to enable the package to run from the
point of failure.
. Using Configurations to make dynamic changes to packages.
Configurations like XML, SQL Server and Environment Variables have
been used.
. Testing and Implementing Custom transformations like Table Difference
and Flow Sync
Environment:
SQL Server 2005 SQL Server SSIS, SSRS, Windows 2003, Windows XP, SQL Server
Management Studio, Flat Files, Excel Sheets, Visio 2003, Accurev, Symphony
Epsilon Interactive, Broomfield, CO
Sept 2006- Feb 2007
SSIS ETL Developer
Epsilon Interactive is a leading provider of strategic, ROI-focused email
communications solutions and marketing automation technologies. Epsilon
Interactive helps marketers acquire, grow and retain profitable customer
relationships through highly relevant and personalized email
communications.
Responsibilities:
. Design and development of Packages and Data flows in SQL Server SSIS.
. Transform complex business requirement into ETLs.
. Developing Batch scripts and integrating them into the SSIS packages.
. Writing .Net scripts to send HTML emails as well as for finding the
Row Count and File size.
. Using a variety of transformations like Aggregate, Union All, Merge
Join, Lookup, OLE Db Command as well as Slowly Changing Dimension,
Pivot and Unpivot.
. Migration of Packages between various environments and loading the
packages in Integration Services (MSDB).
. Automation of packages using SQL Server Jobs.
. Monitoring jobs through Log providers and creating tables to keep
track of Audit.
. Tuning the Packages to avoid bottlenecks and improve performance.
. Creating notifications through email when a package succeeds or fails.
. Working with the Data Modeler on the data model design.
. Involved in testing, modifying and making enhancements to existing
packages.
. Development of Standard Packages to perform certain reusable tasks
like performing Zipping and Unzipping files, Encrypting and Decrypting
files, Adding headers to flat files as well as renaming flat files
with date/timestamp.
. Production Support as well as involved in creating Technical documents
like Source-to-Target mappings and transformation logic.
Environment:
SQL Server 2005 SQL Server SSIS, Windows 2003, Windows XP, SQL Server
Management Studio, Flat Files, Batch files, Visio 2003, Visual Source Safe.
Therakos, Johnson and Johnson, Exton, PA Feb 2005 - June
2006
Informatica Developer
THERAKOS is the leader in research and development in the field of photo
immune therapy. It is a part of the Johnson and Johnson family of
companies.
Responsibilities:
. Design and development of Aggregate tables schema which is useful for
Cognos reporting.
. Design of Aggregate tables, Logical and Physical schema generation.
. Transformed business requirements in to ETL metadata for the Aggregate
tables.
. Design and development of Aggregate mappings and tuned for better
performance.
. Design and Development of workflows and workflow dependencies.
. Involved in designing the process for getting the data from all
systems to Data warehousing system.
. Performed major role in understanding the business requirements and
designing and loading data into data warehouse (ETL).
. Collection of data source information from all the source systems to
the oracle data stores. Involved in Data Extraction, Transformation
and Loading from source systems to ODS.
Environment:
Informatica Power Center7.1.2/6.2, Windows XP, Oracle 9i, PL/SQL, SQL
Server 2000, UNIX shell scripting, HP-Unix, Toad and Flat Files.
EDUCATION:
. MS in Computer Science (West Chester University Of Pennsylvania)
. BE in Computer Science and Engineering (Madras University)
Contact this candidate