We provide IT Staff Augmentation Services!

Ms Sql Server Bi Developer (ssis/ssrs) Resume

Plano, TX

PROFESSIONAL SUMMARY:

  • Over 7 years of Business Intelligence experience in Development, Client Analysis, Database Development, ETL, Reporting and support of OLAP/OLTP/Data Warehouse systems using SQL Server 2016/2014/2012, SSIS, SSAS and SSRS; across various SDLC environments.
  • Strong experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Excellent experience in Extracting, Transforming and Loading structured and unstructured data from various data sources like Text Files, XML Files, and Excel Files and .CSV files to Microsoft SQL Server 2012, using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data error handling and validating data.
  • Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Indexed views, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
  • Proficient in creating dynamic packages for Incremental Loads and Data Cleaning loading into
  • Data Warehouse using SSIS.
  • Maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
  • Interaction and understanding business applications, Data Modelling, Data Mapping, Table Normalization, Optimization and Tuning.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), from Heterogeneous data sources like Access, Excel, CSV, Oracle, Flat Files using connectors, tasks and transformations using SSIS tools and loading it to Data Warehouses and Data Marts, while providing proper error handling and logging.
  • Expert in developing an enterprise reporting solution by creating interactive Dashboards to analyze the performance of the Weekly, Monthly, Quarterly and Yearly.
  • Hands on experience with Dimensional Modelling, Star Schema, Snowflake Schema, Fact and Dimensional Tables, Operational Data Store (ODS).

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, TSQL, Java, Java Developer, Oracle Express / Forms / Reports / Workflow, VB, VB.Net, C, XML, HTML

GUI: Visual Basic, Visual C++, eVC++, MFC, .NET.

RDBMS: Oracle 9i, 10g, 11g, MS SQL, MS Access, IBM DB2

Web Technologies: ASP.NET, WinForms, Web Forms, ASP, VBScript, JavaScript, HTML, DHTML, COM, IIS, UML, XML, XSLT, and Java, ADO.NET, ASP.NET.

App Servers: WAS, WebLogic

Development Tools: SOAP UI, SOA Test tool, XML Spy

Communications Protocols: TCP/IP, Http/Https, SOAP, SSH, SFTP

Tools: ERWIN, Tool for Application Developer (TOAD), SQL Navigator/Developer, Oracle Developer Suite/Designer/Warehouse BuilderMS Visio/Visual Studio/Office, Rational Clear Case/Quest

Version Control: Clear case, SVN, RTC

Operating Systems: Windows, Solaris, AIX, Zlinux, AS/400, Z/OS

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

MS SQL Server BI Developer (SSIS/SSRS)

Environment: SQL Server 2008, SQL BI Suite 2008 (SQL Server Integration Services, SQL Server Reporting Services), Windows Server, C, C++, VC++, C#, XML, Rational Rose, Clearcase, Purify,XML, .NET Framework 1.1, 2.0, NUnit, CPPUnit, SQL 2000.

Responsibilities:

  • Used SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization and denormalization techniques on database Tables.
  • Creating Queries, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
  • Worked with Interaction and understanding business applications, Data Modelling, Data Mapping, Table Normalization, Optimization and Tuning.
  • Creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Defined Functions, Relational Database Models, and Data Integrity in observing business rules.
  • Creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Extracting, Transforming and Loading structured and unstructured data from various data sources like Text Files, XML Files, and Excel Files and .CSV files to Microsoft SQL Server 2012, using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data and validating data.
  • Worked with using for each loop container loading multiple excel files and multiple excel sheets in a file having the same metadata by creating variables and configuring the for each loop container
  • Proficient in creating dynamic packages for Incremental Loads and Data Cleaning loading into Data Warehouse using SSIS.
  • Maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
  • Generate various stylish reports like Drill Down, Cascading, Parameterized, Drill through, Linked Reports, Matrix Reports, Sub reports and Charts using Global variables, Expressions and Functions for the business users using SQL Server Reporting Services.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS Packages.
  • Interaction and understanding business applications, Data Modelling, Data Mapping, Table Normalization, Optimization and Tuning.

Confidential, TX

SQL Database Developer

Environment: MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance, C#, ASP, ASP.NET, VB.NET, Rational Rose, VSS, SQL server 2000, IIS, XML. .NET Framework 2.0 & 3.0, ADO.NET, Extreme Programming, C, C++, VC++, C#, XML, Rational Rose, ClearCase, Purify,XML, .NET Framework 1.1, 2.0, NUnit, CPPUnit, SQL 2000

Responsibilities:

  • Updated job knowledge by participating in al opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
  • Participated in development and creation of Data warehouses.
  • Participated in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
  • Generated various stylish reports like Drill Down, Cascading, Parameterized, Drill through, Linked Reports, Matrix Reports, Sub reports and Charts using Global variables, Expressions and Functions for the business users using SQL Server Reporting Services.
  • Prepared documentations and specifications.
  • Designed, Developed and Deployed SSIS Packages.
  • Designed and Developed reports in SQL Server Reporting Services for management.
  • Endured that the code is written keeping in mind any security issues such as SQL Injection.
  • Being aware of potential blocking, deadlocking and write code to avoid those situations.
  • Ensured performance, security, and availability of databases.
  • Helped in writing and optimizing in-application SQL statements.
  • Handled common database procedures such as upgrade, backup, recovery, migration, etc.
  • Created functions to provide custom functionality as per the requirements.
  • Identified columns for Primary Keys in all the tables at the design time and create them.
  • Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Created database objects such as tables, views, stored procedures, Triggers etc.

Confidential, Detroit, MI

SQL Developer/Data Analyst

Environment: SQL Server 2008R2/2012, SQL BI Suite (SQL Server Integration Services, SQL Server Reporting Services), TFS, SharePoint, MS Access 2007, Excel 2007, XML, .NET Framework 2.0 & 3.0, Rational Rose, VSS, SVN, SQL Server 2005, XML, Python, WPF, Agile Development, . .NET Framework 2.0 & 3.0, ADO.NET, Extreme Programming, C, C++, VC++, C#, Purify, NUnit, CPPUnit, SQL 2000

Responsibilities:

  • Designed and Developed reports in SQL Server Reporting Services for management.
  • Identified columns for Primary Keys in all the tables at the design time and create them.
  • Creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Involved in the development of Stored Procedures, Views and Database functions
  • Working on critical issues and provide the solution in less turnaround time.
  • Participating in crisis and war room calls.
  • Worked with Extracting, Transforming and Loading structured and unstructured data from various data sources like Text Files, XML Files, and Excel Files and .CSV files to Microsoft SQL Server 2012, using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data error handling and validating data.
  • Worked with using for each loop container loading multiple excel files and multiple excel sheets in a file having the same metadata by creating variables and configuring the for each loop container
  • Worked with Maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

Confidential

Data Consultant

Environment: MS SQL Server 2008, SSIS, SSRS, T-SQL, Visual Studio 2008, MS Office, SQL Profiler, C#, ASP, ASP.NET, VB.NET, Rational Rose, VSS, SQL server 2000, IIS, XML. .NET Framework 2.0 & 3.0, ADO.NET, Extreme Programming

Responsibilities:

  • Designed, developed and administration of solutions in the SQL Server.
  • Worked with senior data developer and created Access tables defining data types and formats.
  • Created relationship among the tables to enforce referential integrity.
  • Involved in the development of Stored Procedures, Views and Database functions
  • Created reports in Access and Excel for analysis purpose.
  • Undergone in IBM MQ and Message Broker
  • Created database objects in Management Studio and Imported Access data into SQL databases
  • Utilized Access & Excel applications for reporting
  • Increased effectiveness and efficiency in collaboration with management
  • Created relationship among the tables to enforce referential integrity
  • Enhance and Support existing applications.

Hire Now