We provide IT Staff Augmentation Services!

Sql / Bi Developer Resume

5.00/5 (Submit Your Rating)

PA

PROFESSIONAL SUMMARY

  • Hands on Experience in developing ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from various sources like (Excel, CSV, flat file) by using multiple transformations provided by SSIS and Analysis Services (MDS). 
  • Expertise in configuring Data Quality Services, (DQS), Master Data Services (MDS) and IIS. 
  • Created views, stored procedures, Triggers and functions for Data Migration. Involved in the complete lifecycle of the project, from Planning Staging and pushing the codes to production. 
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert. 
  • Having Valuable experience in writing SQL queries. Widely worked on Data Extraction, transforming the data by using SSIS.
  • Involved in Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
  • Involved in Normalization and Denormalization of the Database in OLTP.  
  • Experienced with SQL writing, Reporting, Crystal Reports, Flat files and other Data sources 
  • Experience with project methodologies implementing waterfall model.
  • Developing summary and detail Crystal Reports against multiple data sources using ODBC connections. 
  • Handled vast financial data, expert level query optimization and performance tuning experience. 
  • Experience in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning Server Performance.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • I am good in writing complex procedures functions and working with different exception handling.
  • Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014 with T-SQL.
  • Scheduling the Reports Weekly and Monthly basis as per the client requirements.
  • Creation of cubes and modifying measures and attributes, creating hierarchies and relationships among dimensions and facts in SSAS.
  • Good interpersonal and communication skills, commitment, result oriented, and keen to learn recent technologies and undertake challenging tasks.

TECHNICAL SKILLS:

Databases: SQL Server 2012, 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g,

Database Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio

ETL Tools: SQL Server Integration Service (SSIS), DTS, Informatica

Languages: SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report

Office Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Unix.

PROFESSIONAL EXPERIENCE

Confidential, PA

SQL / BI Developer

Responsibilities:

  • Designed and developed SSIS (ETL) packages to extract, transform and load data from OLTP system to the Data warehouse.
  • Created SSIS packages to load data from Flat File to Data warehouse using transformations such as Lookup, Derived Columns, Conditional Split, Sort, Multicast, Aggregate and Slowly Changing Dimension.
  • Involved in optimizing slow running SQL queries to improve performance and availability by using Execution Plan and SQL Server Profiler.
  • Responsible for creating database objects like Table, Views, Stored Procedure, Triggers, Functions etc. using T-SQL to provide structure to store and to maintain database efficiently.
  • Created SQL Server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis in specific areas using SSAS.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL Server. Responsible for implementation of data viewers, SSIS logging for error handling the packages.
  • Responsible for managing BI environment, which includes Data Model, Data Sources, ETL tools, target Data warehouse, Data marts, OLAP analysis and Reporting tools.
  • Generated reports using SQL Server Reporting Services 2008R2/2014 from OLTP and OLAP data sources. 
  • Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports. 
  • Created Tabular reports, Drill down, charts, Functions and Maps using SSRS. Created reports to retrieve data using Stored Procedures that accept parameters.
  • Responsible for the Performance tuning of the SQL Commands with the use of SQL Profiler and Database Engine Tuning Wizard.

Environment: MS SQL Integration Services 2012, MS SQL Server Reporting service 2012, MS SQL Server 2012, Crystal Reports, VB.Net, Window XP, MS Word 2010, Visual Studio 2010, MS Excel 2010, HTML, Java Script, UNIX.

Confidential,Boston MA 

SQL / SSIS Developer

Responsibilities

  • Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, look up, derived column, data conversion and slowly changing dimensions.
  • Worked with T-SQL to create tables, views, stored procedures, triggers and user defined functions for complex business logic.
  • Used SQL Server Profiler and Database Tuning Wizard for Performance tuning and query optimization.
  • Created different database objects like Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures and User Defined Functions etc
  • Used Event handlers to capture the run time error messages by using send mail tasks in the background upon success or failure of a package in SSIS, carried out scheduling and administering of SSIS packages.
  • Involved in error handling, creating package configuration and log details using SSIS logging.
  • Generated and consolidated monthly reports to drive forecast production plan with SQL report services (SSRS).
  • Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio BIDS) as per the client requirements.
  • Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.
  • Involved in analyzing, designing, building and testing of OLAP cubes with SSAS and in adding calculations using MDX.

Environment: MS SQL Integration Services 2008, MS SQL Server 2008, MS SQL Server 2005, Crystal Reports, VB.Net, Window XP, MS Word 2010 , Visual Studio 2008, MS Excel 2010, HTML, Java Script.

Confidential,Minneapolis, MN 

SSRS DEVELOPER

Responsibilities: 

  • Worked on the file import framework process for the various flat files structures to get data imported into our database. 
  • Created the Stored Procedures, tables, Views depending upon the project requirement. 
  • Created the deployment scripts after the development is done for every project. 
  • Automated the SSIS Packages using the SQL Server Agent Jobs. 
  • Used various transformations like Multicast, Conditional split, OLEDB Command, Script 
  • Component and Lookup while loading the data into Destination. 
  • Troubleshooted the SSIS/SQL job Agent whenever necessary. 
  • Created SSIS packages to clean and load data to data warehouse
  • Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
  • Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Involved in performance tuning and monitoring of T-SQL blocks.
  • Imported the various files provide by the clients into the relational database systems.
  • Used the BCP to load the large volumes of data from files into tables.
  • Worked with Business Analysts and Users to understand the requirement.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and 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.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
  • Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions. Designed and implemented parameterized and cascading parameterized reports using SSRS
  • Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement. Documentation for all kinds of reports and SSIS packages.
  • Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2008, 2012 Query Analyzer, Enterprise Manager, SSIS, DTS Designer, SQL Profiler, Index Tuning Wizard, T-SQL, ASP.NET, XML, Windows OS, BCP

Confidential

SQL Server Developer/DBA 

Responsibilities:

  • Implement, and maintain complex databases with all database aspects including access
  • methods, access time, validation checks, protection and security, device allocation, database
  • organization, documentation, and statistical methods.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and Nonproduction database code as well as TSQL code from developers and QA.
  • Upgraded Banks database from SQL Server 2000 to SQL Server 2005.
  • Created and developed the stored procedures, triggers, and UDF to handle complex business rules, history data and audit analysis.
  • Designed and constructed DTS Packages for realtime data transformation between heterogeneous databases by using MS DTS packages.
  • Created and developed data tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
  • Developed, modified, and optimized complex queries to data retrieval and modification.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Generated database SQL scripts and deployed databases including installation and configuration.
  • Gather requirements and design of data warehouse and data mart entities.
  • Scheduled and monitored all maintenance activities of SQL Server 2005 with database consistency check, and index de fragmentation
  • Used SQL Server Business Intelligence Development Studio extensively to achieve all the business purposes.
  • Configured securities and access to product databases in SQL Server 2005, SQL Server 2000 and Windows 2003 Server.

Environment: MS SQL Server 2005, SQL Reporting Services (SSRS), SQL AnalyticalServices, SSIS, Stored Procedures, MS Excel, Windows 2003 Advance Server.

Confidential

SQL DEVELOPER

Responsibilities:

  • Designing and implementing Tables, Constraints, Stored Procedures, Triggers, Indexes, and Views using complex T-SQL queries to meet the business requirement.
  • Analyzing the business requirement and provide the estimates for the solutions.
  • Involved in product deliverables for new feature releases and product enhancements.
  • Provide support to the internal team in understanding the functionality and in developing the new requirement.
  • Solving the issues raised by QA team.
  • Provide technical documentation for new requirement development.
  • Handling Critical Production Issues for different customers.

Environment: SQL Server 2008 (T-SQL)

We'd love your feedback!