Sql Bi Developer Resume
Jersey City, NJ
SUMMARY
- Over 8 years of strong IT experience with demonstrated success in the Database development, design, Administration and deployment of large - scale enterprise applications.
- Expert in MS SQL Server 2014/2012/2008 suite of products like SSIS, SSRS and SSAS.
- Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
- Extensive knowledge in T-SQL queries (DDL and DML) for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
- Extensive knowledge of addressing Performance Issues and involved in Index tuning, Data Profiling and optimized queries using query execution plan.
- Expertise in developing SQL Server SSIS packages to import and transform data between databases and external data sources.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Experience in Extraction &Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS utilities.
- Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
- Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
- Experience in developing Crystal Reports, Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
- Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder.
- Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
- Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
- Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
- Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
- Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.
- Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
- Expert in gathering business requirements and converting them into technical requirements
- Implement/code reporting and database solutions using client standard coding and design standards which include MSSQL queries and stored procedures Implement and test solution architecture
- Maintain and Monitoring of Various SSRS reports, SQL code, store procedures and Solving Tickets on Daily Basis for Production Issues.
- Experience in providing 24 x 7 production support.
- Excellent communication skills, organizing skills, highly punctual and an excellent listener.
- Proven experience in project and team leading with minimal defect delivery. Equally comfortable working independently as well as in a team environment
- Ability to work in a team and as an individual with minimal supervision.
TECHNICAL SKILLS
Programming Skills: T-SQL, C, HTML, XML, JavaScript, ASP.NET, VB, C#
Databases: Microsoft SQL 2014/2012/2008 , MySQL, SYBASE, MS ACCESS
BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)Database Design Tools and Data Modeling MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables
Operating Systems: Microsoft Windows, UNIX, LINUX.
Tools: and Utilities: Business Intelligence Development Studio (BIDS), Visual Studio 2013/2008, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel and PowerPoint.
Version Control Tools: VSS
PROFESSIONAL EXPERIENCE
Confidential, Jersey City, NJ
SQL BI Developer
Responsibilities:
- Part of a large technical team, responsible for development of database objects (schema changes, stored procedures implementation) and SSIS packages.
- Understood Brokerage business knowledge and financial products.
- Responsible of analyzing the existing data elements (Client specific schema) and mapping to Confidential specific data elements.
- Worked in Agile based environment involved to work closely with web, Mid-tier, BSA and QA to understand business requirements.
- Responsibilities involve Requirement analysis, Design and prototyping, developing unit tests, bug fixes, maintenance and production support.
- Responsible for adhering to our Programming, documentation and process standards.
- The development technologies involved Microsoft SQL Server 2014, Microsoft SQL Server Integration Services (SSIS), Microsoft Visual Studio 2013, Microsoft Office, XML, Scripting (Visual Basic, C#), Team Foundation Server(TFS).
- Wrote complex SQL queries using joins, stored procedures, User Defined Functions, Views, Indexes XML Queues,
- Wrote complex script tasks in C#, VB script for generating xml message to place into the queue.
- Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all, forloop, foreachloop, lookup, Derived Column and others.
- Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
- Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
- Created code reviews for DB objects in code collaborator and get them debugged before they check-in into TFS and QA roll out.
- Handling tickets for Database deployments into QA, QFinal and Production Environments
- Worked on various QA and Production Defects.
- Handled multiple tasks, in-depth knowledge in agile environments and worked hard to produce best results.
Environment: SQL Server 2014/2012/2008 , SSIS, T-SQL, SSMS, C# scripting, BIDS, Excel 2010, SharePoint 2013, TFS, Visual Studio 2013/2008, Code Collaborator Client, Rally, ServiceNow.
Confidential - Fort Worth, TX
SQL BI Developer
Responsibilities:
- Performed Server installation and configuration using SQLServer 2012.
- Created Packages that Transfers Databases from OneSQL Serverinstance to Another Instance and Scheduled the SSIS packagefor migration of data from old system to MS SQL 2012.
- Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous sources.
- Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
- Developed and maintained critical applications for sales auditing team by balancing sales and settlements of credit amounts with the bank on a day to day basis.
- Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts and SSRS reports.
- Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
- Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
- Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
- Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
- Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
- Worked on multidimensional data modeling.
- Participated in Databases Architecture and data modeling design.
- Reviewed and developed data models and database designs with development teams
- Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
- Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2012.
- Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
- Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
- Planned Backup strategy based on projects requirements.
- Responsible for database backup and Restore, Creating Roles, Granting access.
- Worked on call support to resolve issues whenever needed.
- Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)
Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent technologies like SSIS,SSRS.
Confidential, Salt lake City, Utah
SQL BI Developer
Responsibilities:
- Created Parameterized reports, Crystal Reports, Cascaded Reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS and designed reports using Crystal Reports.
- Responsible forInstallation, Configurationand AdministrationofSQL Server 2012, 2008R2 and Installation of Service Packs & hot fixes.
- Responsible for a Sybase 12.5.4 system to SQL server 2012 migration project.
- Monitored and identified several performance bottlenecks, and reconfigured the Sybase server and SQL servers to improve performance. Modified the stored procedures and the functionalities so that business needs were met and performance needs were met.
- Created report snapshots to improve the performance of SSRS.
- Gathered and analyze reporting requirements from Business team and created database design document and implementation plan.
- Coded reports and database solutions using coding and design standards which include complex MS SQL queries and stored procedures.
- SAFE has hundreds of existing reports that have been written using the Sybase Info-maker reporting tool that must be evaluated and rewritten using Microsoft SQL Server 2012.
- StrongSQL ServerDevelopment skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, and User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
- Managed and monitored the use of disk space.
- Worked with DTS packages and MS OLAP Services.
- Maintained the consistency of the client’s Database using DBCC.
- Provided Technical support to SAFE technical team and Mentor State Staff team members in SQL reporting Services.
- Rewrites SAFE existing Info maker reports that are needed in the new environment to SQL Server.
- Consolidated and optimized SSRS reports.
- Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Participated in project team meeting as a technical expert and provided solutions.
- Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
- Maintain and Monitoring of Various SSRS reports, SQL code, store procedures
- Design and develop new SSRS reports and also migration of reports from Sybase to SQL Server 2012.
- Created and scheduled Snapshots and Subscriptions for the reports using SSRS.
- Tracking bug fixes in data base development and deliver reports on time by using Team Foundation Server (TFS).
- Created various reports includes charts, Indicators, median by using SSDT 2012.
- Participate in the design, development, configuration, testing, deployment, support and/or maintenance of new applications
- Involved in IT Gap Analysis meetings and documented the gaps and required enchantments.
Environment: SQL Server 2008/2012, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Info maker.
Confidential, Westport, CT
SQL BI Developer (SSIS/SSAS)
Responsibilities:
- Implemented triggers and stored procedures and enforced business rules via checks and constraints.
- Involved to work with T-SQL, stored procedure to increase the performance tuning in terabyte database environment.
- Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
- Involved to work with complex database solutions in order to schedule the application.
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
- Involved to integrate the SSRS reports to SharePoint location.
- Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
- Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
- Created SSIS Packages usingcontrol flow transformationto generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
- Implemented SSIS packages to extract the data from XML to OLTP environment & Involved to do XML Configuration for SSIS packages.
- Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
- Involved to work with .NET, C# environment within SSIS, SSRS to implement the business requirements.
- Involved to work with Team Foundation Server to managing the source code, keeping track of such things as defects, requirements, tasks & scenarios.
- Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
- Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
- Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.
Environment: MS SQL Server 2005,2008R2, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Report Builder, TFS.
Confidential, Richmond, VA
SQL BI Developer
Responsibilities:
- Involved in the Data modeling, physical and logical design of Database
- Created tables, indexes, sequences, constraints, triggers and procedures.
- Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
- Designed stored procedures and triggers for automating tasks.
- Defined check constraints, Business rules, Indexes, and Views.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Tuned and Optimized SQL Queries using execution plan and profiler
- Helped in integration of the front end with the SQL Server backend.
- Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS/ETL)
- Created DTS/ETL package to schedule the jobs for batch processing.
- Used SQL Profiler and query analyzer to optimize DTS/ETL package queries and stored procedures
- Configured Server for sending automatic mails to the respective people when a DTS/ETL process failure or success.
- Performed development support, document reviews, test plan, integration of the system.
Environment: MS SQL Server 2008/2005, SSRS, SSIS, SharePoint Server 2007, OLAP, Erwin 7.0, DTS/ETL/SSIS, BIDS.
Confidential
SQL Server Developer/DBA Trainee
Responsibilities:
- Involved in installation, configuration and administration of SQL server 2005 and 2008 on Servers.
- Install, configure, administer and secure Sybase 12.X and 15.X databases using UNIX/LINUX operating systems.
- Applied patches and service packs to keep the database at current patch level.
- Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, SSIS, backup/restore, database corruption, security, and contribute to continuous improvement.
- Learned to Implement database standards, naming convention for the database objects and maintain database security.
- Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions.
- Responsible for installation and configuration of Oracle 9i and 10g database servers on a UNIX platform.
- Implemented trigger and stored procedures and enforced business rules via checks and constraints.
- Involved in data conversions and data loads from various databases and file structures.
- Monitor failed and long running MS SQL Server jobs.
Environment: SQL Server 2008/2005,UNIX/ LINUX, DTS, T-SQL, Crystal reports7.
