Sr.sql Server/bi Developer Resume
NJ
SUMMARY:
- Over 7+ years of IT experience with database development experience, Business Intelligence and have Software Development experience.
- Expertise in Extracting, Transformation and Loading (ETL) data using various tools including SSIS, Bulk insert (BCP), Import/Export data, DTS packages.
- Expert in writing T - SQL, working on DTS, SSIS, and Data Migration projects.
- Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, Data marts, OLAP analysis and Reporting tools.
- Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
- Experience in agile methodologies and SCRUM development.
- Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP.
- Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, Flat Files, MS Access, Oracle and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP and Bulk Insert utilities.
- Expert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
- Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
- Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
- Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player
TECHNICAL SKILLS:
Languages: T-SQL, PLSQL.
Databases: MS SQL Server 2012/2008/2005/2000 .
Database Tools: SQL Query Analyzer, Query Editor and Reporting Server, OLAP (Online Analytical Processing and Business Intelligence & Development Studio (BIDS)), BI stack.
Web Technologies: HTML, XML, JavaScript, c#, WCF
Reporting Tools: SSRS
ETL Tools: MS SQL SSIS
WORK EXPERIENCE:
Confidential, NJ
Sr.SQL Server/BI Developer
Responsibilities:
- Database design, development of Stored Procedures, functions in SQL Server 2012/2008/2005/2000
- Improved the performance and fine-tuned the T-SQL queries, backend stored procedures on which the front-end reports depend.
- Developed reusable stored procedures for error handling and logging.
- Created plan guides to get consistent performance from T-SQL queries
- Created/reviewed/improved Indexes. Implemented purging & archive to manage the data.
- Filegroups creation, DB files management and implemented log shipping.
- Migration of web application from ASP to ASP.Net 2.0/3.5 and migration of reports that uses Crystal Reports 9.0 on Windows 2000 to Crystal Reports 11.5 on Windows 2003
- Production and UAT support.
- Code reviewing & value addition.
- Involved in the COB test of Web application and data server
- Involved in various country roll outs, esp. Australia and Kazakhstan (analyzed the impact and made changes to run the application in a 24X7 mode).
- Low Level designing, preparation of Program specifications, Unit test / User Acceptance test cases.
- Project planning, technical design, following SDLC and preparing FRDs, MDDs, TDDs and test cases for various projects.
Environment: MS SQL server 2012, SSIS, C#, T-SQL
Confidential- Camp Hill, PA
Sr.SQL Server/BI Developer
Responsibilities:
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
- Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
- Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
- Involved in ETL architecture enhancements to increase the performance using query optimizer
- Implemented Event Handlers and Error Handling in SSIS packages.
- Coordinated with front-end for implementing logic in stored procedures and functions.
- Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
- Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
- Advised optimization of queries by looking at Execution Plan for better tuning of the database.
Environment: SQL Server 2012/2008R2, SSIS, T-SQL
Confidential, NC
Sr.BI/SQL Developer
Responsibilities:
- Developed SQL Stored procedures, UDFs, Tables with constraints, Indexes, Defaults, Rules
- Improved the performance of the stored procedures on which the front-end reports are generated and developed SSIS packages to load the data feeds from partner systems.
- Working with Microsoft Performance team on many issues with SQL Server 2005 Performance.
- Developed generic/reusable WCF Services to retrieve the latest price details for the portal.
- Unit testing, SIT & UAT support.
- Production support.
- Involved in the COB test of website and database server
Environment: SQL Server 2008R2/2012 Enterprise Edition, SSIS, T-SQL, WCF, ASP.Net 3.5, C#, XML
Confidential, Malvern, PA
Sr.BI Developer/SSIS developer
Responsibilities:
- Involved in requirements gathering, analysis, design, development, change management and deployment.
- Building UAT and Test environments using Production backups.
- Bulk Import and export of xml documents and data into the system
- Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
- Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
- Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
- Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, view and other SQL joins to implement ETL process.
- Created ETL (SSIS) process to transfer data from multiple data sources (flat files, csv files, XML files and legacy systems) to target systems.
- Created packages in SSIS with error handling and logging.
- Worked with re-directing outputs into different formats including XML Files and various other data sources.
- Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids
- Created SSIS packages to load data into staging table and data mart and also performed logging in SSIS packages to capture error data and for error handling.
- Did Unit testing by developing complex SQL queries and consistency checks by interacting with business analyst teams.
- Extensively developed stored procedures and triggers using T-SQL.
- Provided Index tuning as required for performance improvement of the application (SQL tuning).
- Used SQL Analyzer to find the bottlenecks in SQL code.
- Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made to production systems and made corresponding changes.
Environment: SQL Server 2005/2008R2/2012 Enterprise Edition, SSIS, SSRS, MS-Excel, T-SQL, XML, Web Services.