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 SQLServer databases.
• Expert in Database designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T - SQLScripts 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 (SQLServer, 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 SQLProfiler, Statistics and managing the indexes.
• Expertise in SQLServer Integration Services (SSIS) and SQLServer Reporting Services (SSRS) with good knowledge on SQLServer Analysis Services (SSAS).
• Experience in report writing using SQLServer 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, SQLtask, 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, SQLServer Management Studio, Business Intelligence Development Studio, SQLProfiler, SQLServer Integration Services (SSIS), SQLServer Analysis Service (SSAS).

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

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

Databases: MS SQLServer … 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 Datamodeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Maintained dataintegrity during extraction, manipulation, processing, analysis and storage.
• Proposed and implemented optimized side-by-side SQLserver 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 SQLServer 2008.
• Designed and developed Power BIgraphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Created Calculated Columns and Measures in Power BIbased on the requirements.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute SQLflow 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 SQLscripts using Script task to insert/update and delete data in SQLdatabase, 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 SQLscheduler as SQLserver 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 SQLServer 2008.
• Experienced in making and analyzing and multi-dimensional report of Online transactional Processing OLTP datausing SSAS.
• Worked on Netezzaqueries by performance tuning and techniques.
• Assessed the Netezzaenvironment for implementation of the ETL solutions.
• Developing Bteq, MultiLoad and FastLoad scripts to populate data into Teradatadatabase.
• Created, Maintained & Scheduled various reports in SSRS like Drill down and Drill through & Parameterized Reports using SQLServer Reporting Services SSRS.
• Experienced in datamapping using Talend and Microsoft Visual Studio DataTools.
• Optimized the SQLQueries 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, SQLtask, Script task and Send Mail task etc.
• Created different reports using complex queries to create the datasets in SSRS.
• Experienced in creating SQLdatabases on Azure.
• Created SQLdatasets for Power BI and Ad-hoc Reports.
• Used Date functions, String functions and Database functions to manipulate and format source data.

Environment: MS SQLServer 2014, Netezza, MS SQLServer 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 SQLdatabases for Digisoft Consult clients.
• Expert in designing tables and picking datatypes.
• 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 SQLqueries using T-SQLin order to obtain critical data.
• Created ETL packages with different datasources (SQLServer, Oracle, Flat files, Excel, DB2, and Teradata) and loaded the datainto target tables by performing different kinds of transformations using SSIS.
• Practical understanding of the Datamodeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Scheduled jobs and alerts using SQLServer Agent and configure database mail for job failure.
• Experienced in dataintegration into a datawarehouse from heterogeneous and homogenous data sources including SQLServer 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 dataintegrity during extraction, manipulation, processing, analysis and storage.
• Developed the required datawarehouse model using Star and snowflake schema for the generalized model.
• Performed MS SQLDBA duties including: database backups, restoration, performance tuning, and capacity analysis.
• Optimized the performance of SQLqueries using SQLprofiler and SQLserver database engine wizard.
• Ability to use SQLServer Analysis Services SSAS in creating cubes, datasources, views, named queries, dimensions and deploying of analysis service project in SQLServers
• Experienced in making and analyzing and multi-dimensional report of Online transactional Processing OLTP datausing SSAS
• Solid understanding of analytics, datagovernance and the principles of datawarehousing 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 SQLdatasets 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 SQLdatabases on Azure.

Environment: SQLServer 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 SQLserver 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 SQLserver reporting services and Share Point.
• Wrote several SQLScripts 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 SQLfor 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 SQLServer 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-SQLqueries.
• Created SQLServer 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 SQL2005 to MS SQLServer 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 SQLServer 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 SQLServer 2008, SQLServer 2005, SSRS, SSIS, SSAS, T-SQL, C#, NET Framework 3.5, MS-Excel, XML, Windows 2003/NT/XP.7.