Microsoft BI SSIS Developer

Summary:

• Around 7 years of experience with focus on Database design and Development using different tools of T-SQL DDL and DML Coding and installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008 in Windows Environment.
• Excellent experience in developing complex Stored Procedures, Views, Cursors, and Joins.
• Good experience in creating User Defined Functions and Triggers in observing Business Rules.
• Expertise in working with Version control system SVN,VSS ,TFS,SYNERGY
• Experience in creating/deploying Data Transformation Services DTS , MS SQL Server Integration Services SSIS packages, Reporting Services SSRS .
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting
• Experience in Extraction Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle and to MS SQL Server by using Import Export Wizard, DTS SSIS, and BCP Bulk Insert utilities
• Expertise in creating Packages by SSIS for ETL work.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Expertise in using variables, property expressions, script tasks in SSIS.
• Transformed data from various data sources using OLE DB / MS ACCESS connection by creating various SSIS packages.
• Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.
• Experienced with DTS/SQL server integration services SSIS 2005/2008 Packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing Data transfers and ETL Purposes across different servers.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expert in extracting and transforming data using Import/Export, DTS Packages, MS SQL Server Integration Services SSIS Packages, Bulk Insert and Utilities like BCP.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.
• Created SQL Server Integration Services packages for the ETL tasks.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Strategized and made migration plans.
• Built, Configured, Packaging and Deployed Packages.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, OLAP and Sub reports, adhoc reports, parameterized reports, custom reports and formatting them
• created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Developed Linked reports and Sub reports as per user and business specifications
• Used complex expressions to calculate, group, filter, parameterize and format the contents of a reports according to business user's requirements
• Expert in fine tuning the SSIS packages.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

Technical Skills:

• Databases: MS SQL Server 2008/2005/2000, DB2 UDB 8.X/7.X,Oracle 8i/9i, MS Access 2003/2005, Sybase
• Programming Languages: T-SQL, PL/SQL, Visual Basic 6, Asp.net, C, C , MDX, Shell Scripts, C
• RDBMS: MS SQL Server 2000/2005/2008, MS Access 97/ 2000/ 2003, Sybase, Teradata V2R5, Oracle 8i/9i/10g, IBM DB2 UDB 8.2/8.0,MS Visual Source Safe 2005.
• Database Design Tools
• And Data Modeling: MS Visio, ERWIN 4.5/4.0,Star Schema/Snowflake Schema modeling
• Relational, Fact Dimensions tables, Dimensional and multi dimensional modeling Physical logical data modeling and De-normalization techniques, MS Access, MS Project.
• Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import Export Wizard, Visual Studio.Net, IIS 6.0/7.0Microsoft Management Console, Visual Source Safe 6.0,DTS,
• Operating Systems: Windows XP/98/2000/2003/2008/NT/9x/Vista and MS-DOS, Red Hat Linux.
• DWH / BI Tools: SQL Server Reporting Services SSRS ,SQL Server Analysis Services SSAS ,SQL Server Integration Services SSIS , Business Intelligence Development studio BIDS , Visual Studio, Crystal Reports 9.0, Performance Point Server, ProClarity, SQL Plus, SQL Loader, MS Visio, Erwin, Informatica 6.x.Packages: MS Office, MS Outlook Microsoft Office Suite , Microsoft Office SharePoint Server MOSS 2007/2010.
• Web Technologies: HTML, XML.

Professional Experience:

CONFIDENTAIL

SQL BI SSIS Developer

Responsibilities:

• Create and maintain clearly written technical, user, and system documentation.
• Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers.
• Performed the Migration the Existing DTS packages to the SSIS Batch jobs.
• Used Email Notification package success or failure. If the package is success send the mail with package name, how many records inserted, updated and total records using Send Mail Task. If the package is failed it will send the mail package name and error description using On Error Event handlers in Send Mail task.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Created Package Configuration file with connection information source, staging and destination databases and send mail task connection information and log directory path value
• Provided Package Configuration, Custom Package Logging, Error Handling, and Email Notification to SSIS packages.
• Extensively used SSIS Packages to load data from various formats into a warehouse
• Designed and developed Star Schema in Data warehouse
• Extensively used SQL Profiler to check the performance of the database
• Created SSIS packages to pull data from different sources, like SQL server, flat files and loaded in to the Staging and destination databases
• Created User Interface reports for validating the Data through Reporting Services.
• Highly responsible for development and management SSIS projects.
• Extracting and Loading data into SQL Server Database using SSIS.
• Scheduling Maintaining ETL packages in terms of data validation and consistency.
• Designing SSIS packages to migrate data from database Hierarchical to database Relational .
• Created Mapping, Design and technical Documentation for complex SSIS packages.
• Experience in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Involved in Maintaining Database with Backup, Restore Strategies and scheduling those backups using SSIS packages as a Developer.
• Deployed many packages on different servers using SSIS package Configurations.
• Involved in Backup and Restoring the Databases.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer.
• Responsible for scheduling the packages through Jobs.

Environment: MS SQL Server 2005/2008 R2, MS Excel 2003-2007, MS SQL Server Integration Services SSIS, Team Foundation Server, SQL Profiler, Windows 2003 Advanced Server, Oracle SQL Developer

CONFIDENTAIL

SQL BI SSIS Developer

Responsibilities:

• Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling using Erwin.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created complex queries involving CTE's, Sub-queries and Joins.
• Created Indexes for fast retrieval of the data.
• Extensively used Tasks and Transformation of Control flow and Data flow in SSIS Packages to effectively accomplish complex business requirements.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in Performance tuning and Query Optimization using execution plan.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent.
• Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc. and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Deployed SSIS Packages from Dev/Staging/Production using Package Configurations
• Performed Identification, analysis and resolved report defects within time scope and established development guidelines.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Environment: SQL Server 2005, SQL Server 2008 R2, MS Excel 2003-2007, SQL Profiler, ETL, T-SQL, MS SQL Server Integration Services.

CONFIDENTAIL

SQL Server SSIS Developer

CONFIDENTAIL is a client based investment Management Company, It offers various investment choices and services for institutions and investment professionals, which includes mutual funds, ETFs, Annuity products, brokerage. The project was to migrate data from various heterogeneous data sources such as Oracle, MS Access, MS Excel and flat files into SQL Server 2008 and maintain database for the facility search and Provider search. This was an OLTP database with the data storage of 2.2 TB in size with 210 tables

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Designed Database using Erwin data modeler.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Perform data analysis, data cleansing and source to target mappings using transformations.
• Work closely with cross functional business teams to document ETL requirements and turn those requirements into ETL jobs
• Develop stored procedures, views, and triggers as needed.
• Work with other Developers and Computer Operations to support test, QA, and production environments including daily administration, batch processing, change management, environment migration, and tool automation.
• Created SQL Server Integration Services packages for the ETL tasks.
• Developing scripts for Exception handling for each SSIS packages.
• Used Script component to derive error description from the metadata.
• Testing to ensure correct application of transformation logic from source to target.
• Automation of the ETL jobs using SQL Server Agent Job to run on a daily schedule.
• Setup email notifications incase of job failure in SQL Server Agent.
• Develop numerous drill-through and matrix reports for membership data analysis.
• Documentation for the complete conversion process.

Environment: SQL Server 2005, SSIS, SSRS, SQL Server Management Studio, T-SQL, MS Project and MS Excel.

CONFIDENTAIL

SQL Developer SSIS

CONFIDENTAIL is one of the world's preeminent asset management firms and a premier provider of global investment management, risk management and advisory services to institutional, intermediary and individual investors around the world. The project was migration of data from SQL server 2000 database to SQL server 2005 database, Creation of SSIS packages to integrate the data contained in various heterogeneous file systems and SQL Server database and creation of SSAS Cubes and creating reports using SSRS 2005.

Responsibility:

• Developed logical and physical data models for schemas using MS Visio.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Installed SQL Server 2005 and Management tools using SQL Server Setup Program.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in preparing training document for application development and QA/UAT teams.

Environment: MS SQL Server 2005, SQL Server Integration services SSIS , BIDS, Visual Studio 2005, MS Visio 11.0, Windows NT/2003, Microsoft .NET framework 3.5.

CONFIDENTAIL

Database/ETL Developer

The scope of this project is to migrate SQL 2000 database objects into SQL 2005 Conversion of existing DTS packages into SQL 2005 SSIS This encompasses the data validation, cleansing, data standardization, transformation, load, build, configuration, packaging and deployment.

Responsibilities: As a core Database/ETL developer involved in the following tasks:

• Strategize and make migration plan.
• Co-ordinate with team members on resolving migration issues using migration tool.
• Migrated SQL 2000 Procedures into SQL 2005 for compatibility.
• Worked on system objects.
• Designed and Configured an XML file for passing dynamic parameters to SSIS packages.
• Migrated DTS Packages into SSIS packages.
• Design and Development of ETL tasks using Execute Package task, Execute Sql Task, Lookup transformation, SQL Command.
• Perform ETL and Query tuning for better performance.
• Created Security Credentials and Proxy Accounts for jobs.
• Automated the ETL jobs.
• Build, Configuration, Packaging and Deployment.
• Maintain, support and document for future migration tasks.

Environment: SQL Server 2000/2005, DTS, SSIS, T-SQL, SSRS, XML and MS-Excel.

CONFIDENTAIL

MS SQL Server Developer

• CONFIDENTAIL is the world's largest private educational testing and measurement organization and a leader in educational research. ETS conducts testing services worldwide and has wide testing areas. The present project is to handle the scoring and reporting for GMAT and GRE tests taken by candidates worldwide.
• Determined the SQL Server 2005 Installation. Installed SQL Server Management tools using SQL Server 2005 setup program.
• Designing standards for the database table, column, procedure and views.
• Created junked and conformed dimension in Data Warehouse environment.
• Created degenerative dimension within OLAP environment.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Analyzed the requirements and fine tune the stored procedures to improve performance.
• Data transferred between various servers using BCP and Data Transformation Services in SQL Server Integration Services.
• Implemented Data Transformation Services Packages in SQL Server Integration Services SSIS for transferring data and Data Loads.
• Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks.
• Involved in Query Optimization using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005.
• Used profiler to find badly performing queries and deadlocks.
• Tuned SQL queries using show plans and execution plans for better performance.
• Resolved various performance issues and running DBCC command.
• Used SSRS to write complex formulas and to query the database different to generate different types of ad-hoc reports.
• Worked on Client/Server tools like SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server 2005.
• Created Database Maintenance Planner for the performance of SQL Server 2005, which covers Database Integrity checks, Database Statistics update.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Worked on DTS Package in SQL Server Integration Services SSIS , DTS Import/Export for transferring data from heterogeneous database.
• Generated ad-hoc reports using MS-Access and Crystal Reports.

Environment: MS SQL Server 2005, T-SQL, MS Excel, MS Access, Windows NT, ASP.Net, Visual Basic, SQL Server Integration Services, SQL Server Reporting Services

CONFIDENTAILBI Database Analyst/SQL Developer

Responsibilities:

• Supervised the activity of the Database for identifying the bottlenecks that are slowing down the performance of the data warehouse.
• Identified and implemented the methods to fine tune the queries, procedures and functions.
• Reviewed the executions of views and stored procedure and identified the bottle necks within the query.
• Monitored Database and Server Resources with various tools such as Performance Monitor, SQL Profiler, Stored Procedures and Database Tuning Advisor.
• Finding and Tuning Problem Queries.
• Implemented Peer to Peer Transactional Replication within the system.
• Creation of file groups for the existing Tempdb Database.
• Changing collation in the existing configurations.
• Designed Ideal disk configurations for the future Database server.
• Designed and Created Cube and report from scratch including research.
• Set up guidelines for the team for the future.
• Created reports using ProClarity and analyzed accordingly
• Worked with database performance tuning and query optimization, data integrity and statistics
• Provided documentation on current database environment and as well on the structure that needs to be modified in the future for better performance of the system.
• Advised on the question and concern they had for maintaining the database.

Environment: SQL Server 2000, T-SQL, Analysis Services SSAS , Reporting Services SSRS , Integration Services SSIS , DataTel 18ERP system , Query Analyzer, Cognos, SQL Profiler, SQL Database Tuning Advisor, SQL Performance Monitor, Windows OS.

CONFIDENTAIL

MS SQL Server Developer

CONFIDENTAILis a joint venture between CONFIDENTAIL- one of India's foremost financial services companies-and prudential plc - a leading international financial services group headquartered in the United Kingdom. This project was for doing database tuning. In the project, we created two separate database systems: one for day-to-day customer transaction processing, and a second system for reporting. Customer-centric data base was build to analyze transactions across finance, marketing, risk and collections.

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import Export of data from one server to other servers using tools like Data Transformation Services DTS .
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Managed rollback segments, and table spaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.

Environment: MS SQL Server 2000, Windows 2000, Erwin, VSS, Crystal reports 8.0