We provide IT Staff Augmentation Services!

Bi Developer Resume

Boston, MA

Profession Summary:

  • Over 7 years of extensive experience in Database Design, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2000/2005/2008 in Production, Testing, Development and Clustered environments working with various domains
  • Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
  • Adept at SSIS package design, development and deployment.
Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using SSIS, Bulk Insert, DTS Import/Export utility and Bulk Copy Program (BCP).
  • Experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Charts using SSRS.
  • Expertise in using multiple transformations provided by SSIS such as script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
  • Experience in writing complex SQL queries involving multiple table inner joins and outer joins, temporary tables and table variables.
  • Created views to facilitate easy viewing implementation.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Self Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

Technical skills:

RDBMS/DBMS:

MS-SQL Server 2008/2005/2000, Oracle 11g/10g/9i/8i, Teradata V2R5, and MS Access 2003/2000/97

Database Technologies/Tools:

SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP

Reporting Tools:

Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems:

Windows XP, 2000, NT, 98, 95, Windows 2003

Programming Languages:

HTML, C#.Net, VB.Net, C++, T-SQL, SQL, PL/SQL, Dynamic SQL.

Design Technologies/Tools:

Erwin, MS Visio

Data Warehouse / Business Intelligence Tools

SQL Server Analysis Services 2005, Business Intelligence Development Studio

Professional Experience:

Role: SQL/BI Developer
Confidential,Boston, MA Oct 09 - Till Date

The project mainly involved in creating new databases, Performance tuning, creating, deploying and scheduling reports. Also it included Extract, Transfer and Loading (ETL) of data from flat file, excel sources, etc using SSIS, Migration of data, Writing T-SQL code, backups etc and create various operational, drill-through and dynamic reports using SSRS 2005.

Responsibilities:

  • Involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target DW.
  • Designed efficient and optimized ETL Strategy by identifying, analyzing sources and destinations.
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
  • Developed T-SQL programs required to retrieve data from the Data repository using Cursors and Exception handling.
  • ConfigureSSISPackage for run time Parameters and Configuration file.
  • Developed some scripts in C#.Net used in ETL Process that works as transformation.
  • Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
  • Maintained the consistency of data by performing data profiling and cleaning mechanisms, possible transformations and using variables.
  • Optimized the performance of various SQL scripts by using Stored Procedures, Indexes, Views, User defined functions, Indexed Views for querying data faster.
  • Designed and normalized the databases and created different objects like tables, views, Stored Procedures, UDFs, indexes rules and defaults on MS SQL Server.
  • Created complicated reports like parameter based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, chart and tabular using SSRS 2005.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
  • Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
  • Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
  • Involved in installing and migrating legacy databases to SQL Server 2008.
  • Involved in developing in prototype for front end application used for testing purposes using C#.
  • Responsible for regression testing ETL jobs before test to production migration.
  • Resolvedandclosedthe Production tickets generated due to failure of daily incremental production jobs.

Environment: MS SQL Server 2005/2008, MS Access, Oracle 10g, DTS, SSRS,SSIS, SQL, T-SQL, HTML,XML CSS, Software Development Life Cycle (SDLC), Data Warehouse life cycle(DWLC) Project Management, Windows 2000/NT, Windows 2000 Server/Windows95/98/2000.

Role: SQL/BI Developer
Confidential,Milwaukee, WI Jan 08-Sep 09

The project involved collecting Data from various DB2 sources was loaded into the SQL SERVER Database tables and transformed. Primary business process role was to capture the daily positional and static data to perform the ETL Process by determining the supplier transactions that must be posted for the current day, by applying the rules for aggregation of accounting and transactional data.

Responsibilities:

  • Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application SME’s.
  • Involved in designing the process flow for extracting the data across various source systems.
  • DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server2005/2008
  • Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
  • Worked on various tasks and transformations likeExecute Sql Task, DFT, Execute Package Task, Conditional split, Script Component, OLEDB Command, Row Count, DCNV, Unpivot, Merge and Lookupwhile loading the data into Destination.
  • UsedSSISpackages to roll our data to Live Tables and to Claim Processing Database.
  • Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
  • Wrote variousT-SOLqueries,Stored Proceduresand used them to build packages.
  • Created Triggers, Cursors, Tables, Views and SQL Joins for various applications.
  • Scheduled theSSISpackages and Jobs.
  • Designed, Developed and Deployed reports inMS SQL Serverenvironment usingSSRS-2008.
  • Created reports to retrieve data usingStored Proceduresthat accept parameters.
  • Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Created traces using SQL server profiler to find long running queries and modify those queries as a part ofPerformance Tuningoperations.
  • GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • UsedSQL Server profilerfor auditing and analyzing the events which occurred during a particular time horizon and stored in script.
  • Designed GUI interfaces using various controls provided by C#, ASP.NET environment
  • CreatedXML configurationfiles so that packages can be executed on any server/database by changing the configuration path in the XML files.
  • Performed daily tasks including backup and restore by usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Developed unit testing, systems testing and post-production verifications.

Environment: MS SQL SERVER 2005, MS SQL Server 2008, SSIS, SSRS ,DTS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access, Microsoft Visio, Oracle10g, PL/SQL, MDX, Visual Studio 2005, Erwin r7.2, SQL profiler, Windows NT/2003, ASP.NET,C#, XML.

Role: SQL/BI Developer
Confidential,NJ Jan 07-Dec 07

The Project involved supporting various applications by designing databases, performing data modeling tasks, identifying entities, attributes, migrating data into applications, managing development and production databases. Generating various operational, drill-through and dynamic reports using SSRS

Responsibilities:

  • Extensive knowledge of loading data from various sources like CSV, flat files, to SQL Server database using SSIS Package.
  • Used SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
  • Involved in Creation of Dimensions using Star and Snowflake Schema.
  • Scheduled the SSIS packages and Jobs.
  • Developed, designing and deploying of various complex reports such as Drill down, Tabular reports, Parameterized, Pie charts using Expressions, Global variables and Functions in MS Reporting Services.
  • Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008.
  • Developed complex SQL queries involving stored procedures, cursors, triggers, table inner and outer joins, temporary tables, table variables.
  • Developed effective triggers, and useful functions to facilitate consistent data storage.
  • Involved in monitoring the execution plans of the queries to pre access the resources being used by the queries.
  • Created indexes to pull up patient contact information and get the related insurance information for the patient
  • Identified denial trends and present issue and solutions to management.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, SSRS, SSIS, Windows Server 2003, Oracle 9i, Erwin 7.1, Sage MedWare 7.6.2, Quest Performance Analyzer and Quest LiteSpeed backup tool.

Role: SQL Developer
Confidential,TN Aug 06-Jan 07

This project contained several modules like Budget, Obligations, Payments, Procurements, Inventory, Documents, etc. The application developed by us had the ability to integrate data using ssis and generated reports for all internal management activities .

Responsibilities:

  • Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Involved in migrating the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio
  • Worked on ETL SSIS Development, Created packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.
  • Automated scripts in TSQL, DTS and BCP to import data from various ODBC sources into production SQL Server databases
  • Implemented Disaster Recovery plan using Log Shipping method.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Created Reports with all Aggregate functions and Expressions using SSRS and VB.NET.
  • Developed Custom Selection of reports ordering using SQL Server Reporting Services.
  • Generated various reporting services RDL’S using reporting services for Account Aggregation reports
  • Delivered the reports using ‘pulled’ and ‘pushed’ methodologies and formatted them using Global variables and expressions
  • Extensive testing on the Performance of the Stored Procedures.
  • Monitored performance and fine tuned the database objects and server to ensure efficient data retrieval

Environment: MS SQL 2000/2003 Advanced Server, MS SQL Server 2005 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, SQL Server CE client, ASP.Net, vb.Net, Visual Studio, VB Script, MS Access, LiteSpeed Backup software, Windows 2003/2000/XP, MS Visio

Confidential,PA
Role: SQL Server Developer Oct 05-July 06

This project is all about integrating into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation. Process involves data entry and verification of Payments, Commissions, Journal Entry, Unpaid Policies verifications. The application and the database were in two different servers.
Responsibilities:

  • Extensively involved in interacting with the business users and gathering the requirements for the data warehouse.
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & DB2).
  • Worked with different methods of logging and error handling in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Involved in Database Administration, Management using RDBMS such as SQL Server under WINDOWS environment.
  • Designed and developed the classes usingC#.Net XMLfor database connectivity
  • Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005
  • Created ad-hoc reports, drill down, and drill through reports using SSRS.
  • Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Involved in migration of SSRS from SQL 2000 to SQL 2005.
  • Building UAT and Test environments using Production backups.
  • Maintained system monitoring jobs and provide high availability support.

Environment: Microsoft SQL Server 2000/2005, SSIS, SSRS, SSAS, T-SQL, Microsoft IIS, Windows Server 2003,Oracle 9i, PL/SQL, MS Visio, Erwin, SQL Profiler, Query Analyzer, HTML, JavaScript.

Role: SQL Server Developer
Confidential,Hyderabad, India Aug 03-Oct 05

Description: This application maintains sales order numbers; purchase order numberand goods receipt numbers. It also maintains the data of any inquiry of products from clients, offer of products to the clients, inquiry of products to the customer and offer of products from suppliers.

Responsibilities:

  • Created and maintained various databases for production, development and testing using SQL Server 2000.
  • Wrote complex T-SQL queries for data extraction.
  • Imported data from text files and excel spread sheets into SQL Server 2000 database using DTS package.
  • Created T-SQL triggers and Stored procedures encompassing business rules.
  • Wrote DTS packages to move data between production, staging and QA environment.
  • Worked on Migration techniques across different databases and servers
  • Performed everyday backup and developed recovery procedures.
  • Involved in Creation of new database, planning the location of data, index, and transaction log files on the disks.
  • Created packages, procedures, functions, and triggers; handled database performance tuning.

Environment: SQL Server2000, Windows NT, Access 2000, Query Analyzer, Enterprise Manager, Erwin, Data Transformation Services (DTS).

Education: Bachelor of Technology in Computer Science and Engineering

Hire Now