We provide IT Staff Augmentation Services!

Ms Sql Developer / Bi Developer Resume

0/5 (Submit Your Rating)

TN

SUMMARY

  • Around 6 years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2005/2008R 2/2012/2016/2017 in Development, Test and Production Environments on various business domains like Banking, Pharmacy, Maintenance, E - Commerce and Manufacturing.
  • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS), Power BI (Desktop / Service Level).
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
  • Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server
  • Experience in report writing and deploying using SQL Server Reporting Services (SSRS) and creating various reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
  • Experience in writing expressions in SSRS and Expert in fine tuning the reports.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
  • Experience in using T-SQL in SQL Server 2005/2008r2/2012/2016 and 2017 platforms.
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
  • Hands on experience in Creating Star Schema and Snow Flake Schemas.
  • Hands on experience in implementing Data Integration and Data quality business logics and on business/functional requirement analysis, design, development and testing using Informatica Power Center 9.1/9.5
  • Experienced in Mapping Parameter and Mapping variable concepts.
  • Hands on experience in MS Access database management system, mapping, and reporting.
  • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
  • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

RDBMS: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database Utilities: MS SQL Server 2017/2016/2012/2008 R2, 2005, Microsoft Office 2007/2003, MS-Access, Informatica PowerCenter 9.1/9.5

Languages and other: C, HTML, XML, TSQL, MYSQL, NET Frame Work, JavaScript, Jquery, CMS(Joomla), Bootstrap..

Operating Systems: Windows XP/NT/ 2000/2003/2008, DOS

Tools: Crystal Reports8.5,10,XI,R2, Business Objects, Microsoft office 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, GA

Sr. Business Intelligence Developer

Responsibilities:

  • Analyzed business requirements, Functional and Non-Functional Requirements by interacting with Business Analysts and Developers.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Implementing Power BI for future references by using SSRS
  • Used SSIS to unite data from existing system and performed transformations on MS SQL 2008R2.
  • Extract Transform Load(ETL) development Using SQL server 2017, SQL 2017 Integration Services(SSIS)
  • Generated several drill down and drill through reports using SSRS.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: MS SQL Server 2017/2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, MS Visual Studio.NET# 2008, and Windows 2008 Server.

Confidential, TN

Sr. Business Intelligence Developer

Responsibilities:

  • Understanding the process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and architecture.
  • Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008r2 to MS SQL 2012, as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, and Data Integrity.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Created complex Stored Procedures, CTE’s,Case Statements, Tables, SQL Joins and Statements for Applications by using T-SQL.
  • Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Created complex SSIS packages using proper Control and Data flow elements.
  • Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
  • Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: MS SQL Server 2016/2012 and 2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Business Objects Data Integrator 6.5, SharePoint Server, Tibco Monitoring, Microsoft Access, Windows 2003 Server

Confidential, IL

Business Intelligence Developer

Responsibilities:

  • Contributed in the creation of a robust Business Intelligence environment that makes company work flow more effective, therefore tasks would be completed faster with high quality among different departments.
  • Responsible for creating T-SQL queries to build shared dataset for reporting team.
  • Worked with Business Analyst teams to analyze data in the data warehouse, data mart and operational systems.
  • Worked with data warehouse to develop and update ETL packages in SSIS to migrate data from different departments to data warehouse for the use of reporting and analyzing.
  • Worked with DBA to optimize company internal database following Normalization rules in SSMS.
  • Worked with DBA to create jobs, store procedures and triggers in SSMS to automate database updating work.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
  • Involved in SSRS report deployment, debugging reports and report server configuration.
  • Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
  • Involved in documenting the project steps and presenting to the team members.

Environment: SQL Server Data Tools, SSMS (2008r2), SQL Server Integration Services, SQL Server Reporting Services, Database Engine Tuning Advisor, Windows 7, Microsoft Office Suit (2007), SQL Profiler

Confidential

MS SQL Developer / BI Developer

Responsibilities:

  • Expertise in MS SQL Server Management Studio … and MS SQL Server BI suite including SSIS, and SSRS
  • Experience in database programming in writing T-SQL Stored procedures, views, parameters, functions, constraints and indexes using various DDL and DML commands.
  • Experienced in Data Extraction, transformation and loading (ETL) between different systems and formats such as MS Access, Excel Spreadsheet, flat files etc.
  • Expert in creating, configuring and fine-tuning ETL workflows designed in SSIS.
  • Experienced in creating SSIS packages using various transformation like lookup, derived columns, conditional split, merge join, sort, aggregate, union all etc
  • Expertise in OLTP/OLAP System Study, developing database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
  • Experienced in generating reports using SQL Server Reporting Services (drill-down drill through, cascading parameters, sub -reports ) and MS Excel Spreadsheets (functions, subtotal, and pivot tables )
  • Understanding the client’s Confidential Architecture and different internal & external source systems.
  • Involved in interacting with application owners to gather the requirements for the application.
  • Participated in discussions with Project Manager and Business Analysts on any technical and/or Business requirement issues and come up with resolution.
  • Reviewed the Architecture and Performance requirements with the Business Users
  • Involved in gathering business requirement, studying the application and collecting the information from developers, and business
  • Pulled SSRS Reports for DB Analysis and shared with DBA team for more insight also used SQL Profiler to monitor the DB while testing the Application.

Environment: SQL Server 2008R2, Windows 2000/2003, Microsoft office 2003, XML, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003,, .NET Frame Work 1.0,SharePoint 2007.

Confidential

MS SQL Developer / BI Developer

Responsibilities:

  • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. customizing standard objects Accounts,, Products, Prices, Reports and Dashboard in SSRS
  • Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
  • Developed an automated report subscription process using SSRS.
  • Applied conditional formatting in SSRS to highlight key areas in the report data
  • Used Report Builder to do Ad-hoc Reporting.
  • Created report links to refer other reports in a particular report.
  • Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
  • Created multiple hierarchical aggregates for faster performance.
  • Created database objects like tables, users, roles, stored procedures, triggers.
  • Worked on solving issues by doing data recovery in existing database.
  • Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
  • Involved in gathering business requirement, and performed monitoring for the reports which are deployed.

Environment: SQL Server Management Studio (SSMS 2008r2), SQL ServerBusiness IntelligenceDevelopment Studio (BIDS), SQL Loader, SSRS, Data Analyzer, Control-M, Teradata PMON/Viewpoint, Unix Shell Scripting, XML, Microsoft Office (Word, Excel, Access).

Confidential

MS SQL Developer / BI Developer

Responsibilities:

  • The project aims at integrating data in Integrating Services 2008r2 and to generate parameterize reports of the customers.
  • Tested to optimize the Stored Procedures and Triggers to be used in production.
  • Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
  • Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
  • Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
  • Customizing standard objects Accounts, Contacts, Products, Reports and Dashboard in SSRS
  • Developed complex T-SQL code for the application.
  • Worked in Enterprise Manager for job scheduling and batch queries.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Created database objects like stored procedures, Joins, functions and views.
  • Created SQL server Reports using SSRS 2008
  • Created Drill-down, Drill-down and Sub-Report using and linked reports using SQL Server Reporting Services.
  • Identified the data source and defining them to build the data source views.
  • Involved in SSRS report deployment and report server configuration.
  • Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
  • Launching the report builder for Ad hoc reports
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.

Environment: SQL Server Data Tools, BIDS, SQL Server Management Studio (SSMS 2008r2), SQL ServerBusiness IntelligenceDevelopment Studio(BIDS), SQL Loader, Oracle, MS Excel, Flat Files, Functional Testing, Windows 2000 Server.

We'd love your feedback!