We provide IT Staff Augmentation Services!

Sql Developer/ Data Analyst Resume

Charlotte, NC

SUMMARY:

  • Over 5 years of IT experience in Database Design, Development and Administration with MS SQLServer … and Oracle11g/10g database technologies.
  • Expert in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server … … databases.
  • Expert in Database designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T - SQL Scripts in MS SQL … .
  • Experience in designing data models (Conceptual, Logic, Physical), Star Schemas, Snowflake Schemas and 1-3NF data models using tools like ERWIN, Visio.
  • Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF's) and other T-SQL (DDL, DML) statements for various applications.
  • Excellent skills in High Level Design Development and implementing ETL packages using SSIS … for integrating data between heterogeneous sources (SQL Server, Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, fuzzy Lookup and Union all.
  • Expert in Database performance tuning and Query optimization using SQL Profiler, Statistics and managing the indexes.
  • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
  • Experience in development and Management of the end-to-end delivery of data warehousing project.
  • Expert in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary Key and Foreign Key concepts.
  • Experienced in sorting the data, defining data source and subtotals for the reports.
  • Experience in developing, managing reports in SSRS using BIDS, Report Manager and Report Builder.
  • Experience in creating Report Models, Parameterized Reports, Drill Down, Drill Through and Graph Reports.
  • Experience in writing business objects and data access using C#, VB.NET and T-SQL.
  • Expert in managing version control using source control tools like Visual Source Safe, Team Foundation Server to maintain code changes.
  • Excellent in Software development methodologies such as Agile, SCRUM, Test Driven Methodologies.
  • Provide after hours production support of existing ETL processes.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used Date functions, String functions and Database functions to manipulate and format source data.

TECHNICAL SKILLS:

Database Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS).

ETL Tools: Data Transformation Services (DTS)-Export/Import, SQL Server Integration Service (SSIS).

Reporting Tools: SQL Server Reporting Services …, Microsoft Access 2013, MS Excel, Power BI.

Databases: MS SQL Server … Oracle … MS-Access Netezza.

Programming: T-SQL, PL-SQL, C #, UNIX Shell Scripting, PERL, AWK, SED, SAS, R, Python.

Operating Systems: Windows NT, Windows 2000, Windows 2003, Sp3, Windows Server 2008, Windows 7, Windows XP.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SQL Developer/ Data Analyst

Responsibilities:

  • Involved in requirement gathering, analysis, design, development and deployment.
  • Worked on Inbuilt application named Import Export Framework (IEF) for Importing and Exporting the files to various Vendors and to maintain consistency against the different coding standards incorporated when creating Import/Export's scripts.
  • Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data.
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
  • Worked on creating tables, views in Teradata according to the requirements.
  • Developed logical database and converted into physical database using Erwin.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Maintained data integrity during extraction, manipulation, processing, analysis and storage.
  • Proposed and implemented optimized side-by-side SQL server migrating plan with minimum server downtime.
  • Experienced in documenting the ETL process flow for better maintenance and analyzing the process flow.
  • Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month.
  • Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2008.
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Created Calculated Columns and Measures in Power BI based on the requirements.
  • Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute SQL flow task, data flow task to extract data from different databases.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
  • Wrote SQL scripts using Script task to insert/update and delete data in SQL database, in creating configuration packages using C# Scripting.
  • Created SSIS Packages to migrate slowly changing dimensions.
  • Deployed the SSIS package on various servers using package configuration from test server to production servers.
  • Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
  • Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2008.
  • Experienced in making and analyzing and multi-dimensional report of Online transactional Processing OLTP data using SSAS.
  • Worked on Netezza queries by performance tuning and techniques.
  • Assessed the Netezza environment for implementation of the ETL solutions.
  • Developing Bteq, MultiLoad and FastLoad scripts to populate data into Teradata database.
  • Created, Maintained & Scheduled various reports in SSRS like Drill down and Drill through & Parameterized Reports using SQL Server Reporting Services SSRS.
  • Experienced in data mapping using Talend and Microsoft Visual Studio Data Tools.
  • Optimized the SQL Queries through Database Tuning using Toad/ SQL Developer.
  • Generated a report which identifies the performance efficiency of every component within the modules of payroll.
  • Implemented data views and control tools for guarantee data transformation using SSIS.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Created different reports using complex queries to create the datasets in SSRS.
  • Experienced in creating SQL databases on Azure.
  • Created SQL datasets for Power BI and Ad-hoc Reports.
  • Used Date functions, String functions and Database functions to manipulate and format source data.

Environment : MS SQL Server 2014, Netezza, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual Source Safe, Power BI, BIDS, SSMS, Talend, Teradata, Microsoft Azure, Erwin, Power BI, QlikView.

Confidential, Cleveland, OH

SQL Data Analyst

Responsibilities:

  • Responsible for designing, developing and optimizing SQL databases for Digisoft Consult clients.
  • Expert in designing tables and picking data types.
  • Expert in developing T-SQL (DDL, DML) statements and complicated joins.
  • Expert in creating indexes for fast retrieval of data, views, triggers, stored procedures and User defined functions.
  • Expert in writing and analyzing SQL queries using T-SQL in order to obtain critical data.
  • Created ETL packages with different data sources (SQL Server, Oracle, Flat files, Excel, DB2, and Teradata) and loaded the data into target tables by performing different kinds of transformations using SSIS.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Scheduled jobs and alerts using SQL Server Agent and configure database mail for job failure.
  • Experienced in data integration into a data warehouse from heterogeneous and homogenous data sources including SQL Server database, Oracle database, fixed width / delimited flat files, XML files, and other sources.
  • Expert knowledge with SSIS, SSAS and SSSRS in building and generating business reports for Digisoft consult clients.
  • Maintained data integrity during extraction, manipulation, processing, analysis and storage.
  • Developed the required data warehouse model using Star and snowflake schema for the generalized model.
  • Performed MS SQL DBA duties including: database backups, restoration, performance tuning, and capacity analysis.
  • Optimized the performance of SQL queries using SQL profiler and SQL server database engine wizard.
  • Ability to use SQL Server Analysis Services SSAS in creating cubes, data sources, views, named queries, dimensions and deploying of analysis service project in SQL Servers
  • Experienced in making and analyzing and multi-dimensional report of Online transactional Processing OLTP data using SSAS
  • Solid understanding of analytics, data governance and the principles of data warehousing and business intelligence.
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Developed Reports for business end users using Report Builder with updating Statistics.
  • Created SQL datasets for Power BI and Ad-hoc Reports.
  • Created Tabular, Matrix reports, Charts and graphs as per customer requirements using SSRS and Power BI.
  • Experienced in creating SQL databases on Azure.

Environment : SQL Server 2005/2008/2012/2014/2016 , Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, .Net, T-SQL, Windows 2008/2012, XML, MS Excel, MS Access, MS visual Studio, BIDS, SSMS, Microsoft Azure, Erwin, Power BI.

Confidential

SQL/ ETL Developer

Responsibilities:

  • Collecting requirements from business users and transforming them into logical and physical database designs.
  • Create and maintain clearly written technical, user, and system documentation.
  • Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
  • Created complex queries, which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
  • Involved in Performance tuning and Query Optimization of Stored Procedures and queries using execution plan and profiler.
  • Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
  • Working with complex SQL, Stored Procedures, Triggers, cursors, and packages in very large databases from various servers.
  • Designed SSRS 2008R2 reports with Cascading and Multi-valued Parameters.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Involved in using transformations for loading data from source to destination.
  • Designing and implementing a variety of SSRS reports such as Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Creating reports for users in different departments using web-enabled reporting by SQL server reporting services and Share Point.
  • Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
  • Design report models based on users requirements, explain and train users to use report builder to generate their own personalized reports.
  • Created tables, stored procedures in SQL for data manipulation and retrieval, Database Modification using SQL, PL/SQL, Stored procedures, triggers, Views in MS SQL.
  • Written Stored Procedures functions and views to retrieve the data.
  • Created User Interface using ASP.Net.
  • Involved in integration testing the Business Logic layer and Data Access layer.
  • Used technologies like C#, ADO.Net, JavaScript, HTML, XML and Tiles for Presentation tier

Environment: SQL, PL/SQL, T-SQL, Vb.net, C#, Microsoft BI (SSIS, SSAS and SSRS), Oracle 11g/10g, MS SQL Server 2012/2008, SVN, SQL Developer, Visual Studio 2008.

Confidential

SQL/ .Net Developer

Responsibilities:

  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
  • Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
  • Optimized the performance of queries with modifications in T-SQL queries.
  • Created SQL Server Reports using SSRS for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
  • Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
  • Created SSIS packages to migrate data from Oracle 8i, MS SQL 2005 to MS SQL Server 2008.
  • Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
  • Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, Oracle and XML to create and maintain a centralized data warehouse.
  • Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
  • Worked on Authoring Reports and managing reporting services.
  • Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
  • Generated Chart-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Generated reports using Expressions and Functions using SSRS.

Environment: MS SQL Server 2008, SQL Server 2005, SSRS, SSIS, SSAS, T-SQL, C#, NET Framework 3.5, MS-Excel, XML, Windows 2003/NT/XP.7.

Hire Now