We provide IT Staff Augmentation Services!

Sql Server Bi Developer Resume

New York, NY

SUMMARY:

  • Around 6 (Six) years of work experience in the IT industry as a SQL Server BI Developer which includes experience in design, development, implementation and administration of database systems using MS - SQL Server for both Online Transaction Processing (QLTP), Online Analytical Processing (OLAP) & Data Warehousing Systems applications including industries like Commercial Banking, Finance and Healthcare.
  • Working knowledge of Software Testing life cycle (STLC) and System Development Life Cycle (SDLC) and experience in Star Schema / Snow Flake Schema and experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools.
  • Excellent understanding of Relational Database Systems, Normalization, Winsorization, logical and physical data modeling.
  • Wrote complex queries involving multiple tables using T-SQL skills and developed the ability to create and maintain stored procedures, triggers and user defined functions.
  • Experience in Creating and Updating Clustered and Non-Clustered Indexes to improve SQL Server Performance.
  • Experience in Performance Tuning and Query Optimization.
  • Maintained Error logging using Exception Handling in T-SQL and SSIS.
  • Good Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Chart, Tabular, Drill Down/Drill Through, Cascading, Parameterization and Sub Reports.
  • Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and creating Dynamic packages for Incremental Loads.
  • Experience in enhancing and deploying SSIS Packages from development server to production server by using package configurations.
  • Experience in creating packages to Transfer Data, Data Conversion, Data Migration from sources such as ORACLE, DBA/DB2, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
  • Expert in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS).
  • Experience in Designing and Building the Dimensions and cubes using SQL Server Analysis Services (SSAS).
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery.
  • Experience in using Profilers, Index Tuning Wizard and Performance Monitor to monitor SQL Server.
  • Extensively used SQL Server Import/Export Wizard, for performing the ETL operations.
  • Involved in various Transformation and data cleansing activities using various control flow and data flow tasks in SSIS packages during data migration.
  • Understanding of Tableau reporting to develop reports on various visualization techniques by connecting to different databases.
  • Generated various Monthly, Quarterly, Bi-Yearly and Yearly reports using custom reporting tools and SQL Server Reporting Services (SSRS) for various business users.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL Server Business Intelligence (SSIS, SSRS, SSAS)

Reporting Tools: SSRS, SSAS and Crystal Reports, Open Text

Languages: C, SQL, T-SQL, PL/SQL, HTML, XML, DAX, MDX, DTS, Power BI, PowerPivot, Power view.

Operating Systems: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Databases: MS SQL Server 2016/2014/2012/2008 R2, Oracle 10g/9i/8i, MYSQL, MS-ACCESS

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

SQL Server BI Developer

Responsibilities:

  • Worked on listing out schema changes and impacts during upgrades.
  • Created SSIS packages to implement upstream source server upgrades by using Heterogeneous Data Sources like flat files and flowing the data of market open interest into SQL Server.
  • Created Table Valued Functions about option chains and Stored Procedures required for option pricing.
  • Performed Troubleshooting of reporting data with the required changes both at the front end UI interface and back end queries.
  • Worked on various Schema Changes that are required as part of market updates.
  • Created complex Stored Procedures, Table valued functions, Triggers, Cursors and other SQL Joins by using T-SQL, SQL Server and Oracle.
  • Worked on Error Handling and Logging in SSIS Packages.
  • Tested applications for performance of portfolio, data integrity and validation issues.
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help the investors understand the latest market trends.
  • Extensively used SQL Server in constructing trading strategies based on BS model, Views, Indexes and User Profiles.
  • Used SQL Profiler and Execution Plan to view index performance and thereby eliminating market price table scans.
  • Participated in Technical and Code review meetings as the mappings are developed and the design is implemented.
  • Used various Transformations in SSIS Data flow and used Control flow for loop containers and Execute SQL tasks.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat files, Oracle, Excel) and loaded the data to the target environment (arbitrage opportunity in the market) by performing different kinds of Transformations like Conditional Split, Derived Column, Data Conversion, Look up and Merge Join as required.
  • Created stored procedures using Common Table Expression (CTE) and various types of trading strategies.
  • Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for developing SSIS packages.
  • Schedule the trading opportunities using SQL Server Agent.
  • Worked on writing T-SQL queries for the historical prices data to pull according to customers’ risk appetites.

Environment: SQL Server, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer.

Confidential, Washington DC

SQL Server BI Developer

Responsibilities:

  • Created SQL Server Reports using SSRS.
  • Identified the data sources and defined them to build the data source views.
  • Scheduled the Reports to run automatically using data driven subscriptions.
  • Experience in creating complex SSIS packages using control and data flow tasks with error handling and logging.
  • Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL and SQL Server.
  • Generated parameterized reports, sub reports, tabular reports using SSRS on probability of default and probability of prepayment with data of customers’ information (age, gender, income, FICO) and macro information (including season, financial crisis and indexes.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
  • Experience in moving the data from heterogeneous data sources like oracle and flat files to SQL Server using SSIS.
  • Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs in mortgage loans information.
  • Used Multi-dimensional expressions (MDX) to present the data asked by Confidential, to simultaneously query on different dimensions.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Improved the performance of cubes by creating Attribute Relationships, Partitions, Aggregations, getting rid of unused attributes and changing the attribute hierarchy options in SSAS.
  • Extensively used SQL Server Import/Export Wizard, for performing the ETL operations.
  • Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
  • Involved in Data migration (Import & Export using BCP) from text to SQL Server.
  • Involved in Creating Stored Procedures for Reports generation.
  • Designed and implemented stored procedures and triggers for credit risk analysis task.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics to prepare for risk model developement.
  • Perform T-SQL tuning and optimizing queries for SSIS packages and provided production support for all the scripts and packages.
  • Created numerous simple to complex queries involving self joins, correlated sub queries, CTE's for Family Loan-Level Dataset cleaning.

Environment: SQL Server, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer.

Confidential, Rockville, MD

SQL Server BI Developer

Responsibilities:

  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on commercial banks’ business requirements and technical specifications.
  • Created stored procedures, triggers, views, functions and wrote complex queries using T-SQL Joins to address various individuals’ reporting operations and random data requests.
  • Created packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
  • Implemented Complex Logging in SSIS Packages.
  • Created SSIS packages to load individuals’ data (including their customer information, transaction history, and family information) and macro information (like market indexes and season) into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow / file system/ Send mail/ active script/ xml task.
  • Involved in various Transformation and data cleansing activities using various control flow and data flow tasks in SSIS packages during data migration.
  • Created the automated processes for the activities such as customer daily transaction records database backup and SSIS Packages to run sequentially using SQL Server Agent job.
  • Created SQL Server Profiler traces & used Database Tuning Advisor (DTA) for optimum performance of queries.
  • Generated various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports about customers’ bank account behavior using SQL Server Reporting Services (SSRS) for various business users.
  • Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF using SSRS.
  • Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts using SSRS Report Builder.
  • Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
  • Generated Customer Risk Type Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS.
  • Familiarized with knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).

Environment: SQL Server, T-SQL, Oracle, PL/SQL, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer.

Confidential

SQL Server BI Developer

Responsibilities:

  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services.
  • Enhanced and deployed the SSIS Packages from development server to production server.
  • Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like enrollment status, operation status, potential default probability from the OLAP system.
  • Wrote the expressions in SSRS wherever necessary.
  • Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Involved in modifying report content and exporting reports in multiple formats based on different supply chain business modes.
  • Designed and implemented Parameterized and cascading reports about default risk using SSRS.
  • Developed data model based on the BA's and the reporting Team using SSAS, SSRS.
  • Created derived columns on the final fact and dimension tables as per business modes and risk level.
  • Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
  • Played a major role in production support of SSAS (cube refresh), SSIS jobs.
  • Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Create different SSRS Reports of risk type and loss given default on quarterly, monthly, daily or real-time basis.
  • Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services.
  • Designed dynamic SSIS Packages to transfer data across various data sources like excel, flat file, oracle and validate the data by running SQL scripts.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Worked on Performance tuning of SQL queries using SQL Profiler and Index Tuning Wizard.

Environment: SQL Server, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer.

Confidential

SQL Server Server Developer

Responsibilities:

  • Monitored Log shipping/Replication and troubleshooting of errors.
  • Wrote Stored Procedures and SQL scripts both in SQL Server and Oracle to implement estimation of loans of local small businesses.
  • Performed extensive data extraction from commercial bank internal websource and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
  • Performed company and business information database backup and archived on regular basis.
  • Administered of all SQL server database objects, logins, users and permissions in each registered server.
  • Resolved any deadlocks issues with Databases/Servers on a real-time basis due to operations of small business.
  • Implemented MS SQL Server Security and database Permissions.
  • Wrote scripts for generating Daily Backup Report of borrowers’ status, verifying completion of all routine backups, log space utilization monitoring etc.
  • Backup and Restoration of loan status databases using third party tool (SQL LITE Speed). Involved in Design and Development of Disaster Recovery Plan.

Environment: SQL Server Enterprise Edition, SSIS, Windows 2000/NT, Excel, SQL Profiler, Replication, DTS, MS Access, T-SQL, Crystal Reports.

Hire Now