We provide IT Staff Augmentation Services!

Sql Server/bi Developer Resume

0/5 (Submit Your Rating)

CA

SUMMARY

  • Over 8 years of IT experience in Analysis, Design, Development and Implementation of Database, ETL and Business Intelligence solutions for Data Marts and Data Warehouses using ETL, SQL Server & OLAP tools.
  • Good experience of entire Software Development Life Cycle (SDLC) methodologies like Waterfall model and Agile Methodology.
  • Good hands at Designing Star, Snowflake schemas and database modeling using Erwin tool.
  • Involved in Logical and physical Design of the Database and Data Warehouse.
  • Extensive experience in designing and developing SQL Server Analysis Services (SSAS) OLAP Cubes.
  • Experience and more efficient indesigning, developing and deployingBusiness Intelligence solutions usingSSIS,SSRS.
  • Good hands atwritingComplexSQLQueriesinvolving multiple tablesusing sub queries and joins in SQL Server Management Studio.
  • Extensive experience in T - SQL like developing Stored Procedures, Views, Cursors, Triggers.
  • Good hands at importing and exporting data from and to flat files, oracle, CSV files, excel and different data sources.
  • Involved in migration of legacy data by creating various SSIS packages.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools like SQL Server Integration Services, DTS, Bulk Insert and BCP.
  • Good hands at using Control-M for job scheduling and to automate data processing.
  • Experience in data migrations while updating to new versions and from other data sources.
  • Expertise in developing Parameterized, Chart, Graph, and Dashboard report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
  • Experience in Database Performance Analyzing, Tuning and Debugging.
  • Experience in Handling Heterogeneous data sources like Oracle, Teradata, and CSV and XML files using SSIS.
  • Auto-generated analysis reports using SQL Server, Tableau, Access, Business Objects and Crystal Reports and Excel pivot tables.
  • Good hands on experience on Tableau, data visualization.
  • Developed interactive web-based reports and forms with VB.NET, ASP.NET and HTML.
  • Good hands at Job Scheduling using Control-M to automate data operations and migrations.
  • Experience in Creating Job Alerts, SQL Mail Agent, and scheduling DTS Packages.
  • Experience in tuning the reports that includes modifying, Testing the required T-SQL and MDX queries using DMV's and creating the necessary environment for Deployment.
  • Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
  • Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2014, 2012, 2008R2, 2005, Oracle DB 11g/10g,My SQL.

Database Tools: SQL Server Entreprise Manager, SQL Server Management Studio (SSMS), Microsoft Management Console, SQL Developer, Data Transformation Services (DTS), Data Stage PX 8.1, 7.5.

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Crystal Reports,Tableau 7.0, 8.0, 9.0.

Operating Systems: Windows 7/8/8.1/10, Windows XP, 2000, Windows 2003 server.

Programming Languages: SQL, T-SQL, PL/SQL, C#.net.

WEB Technologies: XML,HTML4.0/5.0, CSS, Asp.net.

Design Tools: Erwin 7/4, MS Visio 2007/2010.

BI Tools: SQL Server Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), Informatica, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Server/BI Developer

Responsibilities:

  • Worked on Data Extraction, Transformation and Loading from different data sources using ETL tool like SSIS as per client requirements.
  • Involved in design and implementation of data migration and backup of bulk data from old repository to updated one.
  • Worked with Control-M for job scheduling and to automate the tasks like migrations and loading data in bulk.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Created T-SQL functions and stored procedures to supply comma-delimited lists and date information.
  • Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files into the SQL Server data warehouse using SQL Server Integration Services.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Involved in data migrations from client sources (Oracle DB) to current design and from other data sources, Good knowledge on using SSMS for querying.
  • Worked on variousbackend ProceduresandFunctionsusing T-SQL.
  • Developed a High-level dashboard using Power BI, SSRS 2008.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab, Crystal reports.
  • Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
  • Testing and deploying developed reports as per client requirement.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Data Tools (SSIS, SSRS), .Net framework, T-SQL, C#, visual studio, Asp.net, Microsoft Office Share Point Server, TFS.

Confidential, Yardley, PA

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

  • Gathered user requirements to develop the Business Logic and analyzed and designed software and database solutions.
  • Worked closely with database to design and implement database components in timely manner.
  • Involved in ETL architecture enhancements and worked on Data Extraction, Transformation and Loading from different data sources using ETL tool like SSIS as per client requirements.
  • Loaded data from database to Data warehouse using SSIS packages.
  • Designed and developed OLAP Cubes and Dimensions using SSAS.
  • Wrote complex T-SQL queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements
  • Experience in T-SQL Programming using DDL, DML commands for various business applications.
  • Load data from database to Data warehouse using SSIS packages.
  • Supported team in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports.
  • Created reports from complex SQL queries and MDX queries in Agile (Scrum) methodology.
  • Organized data from a data warehouse into Multidimensional Cubes with SQL Server Analysis Services (SSAS) to allow the execution of sophisticated reports.
  • Worked on troubleshooting, performance tuning, monitoring and enhancement of Data stage jobs.
  • Developed complex Stored Procedures, Functions and incorporated them in Crystal Reports to enable report generation on the fly (SSRS).
  • Create and execute unit, functional and integrated testing.

Environment: SQL Server 2012, SQL BI Suite (SSIS, SSRS, SSAS), Enterprise manager, MS Project, T-SQL, TFS, Agile, Crystal Reports.

Confidential, Mount Laurel, NJ

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

  • Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
  • Developed and deployed data transfer packages using SSIS, also maintained the jobs running on Servers.
  • Responsible for creating database objects like tables, Views, Store Procedures, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
  • Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL.
  • Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS reports and Power Pivot.
  • Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics, Tableau Reports using SSRS.
  • Involved in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
  • Scheduled the monthly/weekly/daily reports to run automatically.
  • Configured the report viewing security for various users at various levels using SSRS Report Manager.

Environment: MS SQL Server 2008/2012, MS SQL Server Data Tools, Visual Studio 2008, PL/SQL, Microsoft Office Share Point - 2008, C#, VB.Net.

Confidential, Houston, TX

SQL Server/BI Developer (SSIS)

Responsibilities:

  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
  • Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services with proficiency in using Report Designer as well as Report Builder.
  • Created SQL Server Reports based on the requirements using SSRS 2012.
  • Designed and developed databases using MS SQL server.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Developed reports and deployed them on server using SQL Server Reporting Services.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 (SSAS)
  • Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: SQL Server 2008, MS SQL Server Data Tools, T-SQL, DTS, SQL Profiler, Erwin, Oracle, C#.net.

Confidential

SQL Server Developer

Responsibilities:

  • Writing SQL Server database procedures, functions and triggers
  • Responsible for overseeing the Quality procedures related to the project
  • Developing test plan and test strategy
  • Review of the test cases written for unit and integration level
  • Integrating the test scripts written for individual units
  • Writing Test scripts and functions wherever necessary for various units of the business modules
  • Effective coordination between development team and testing team
  • Writing RTMs before the test planning phaseAnalysis of the specifications provided by the users
  • Generating reports using crystal reports

Environment: Visual Basic 6.0, Windows 2000 operating system, Microsoft SQL Server 2000 server, Visual Source Safe

We'd love your feedback!