OBJECTIVE

• To obtain a position as a senior level .net/SQL Developer that perform various IT related duties.

TECHNICAL SKILLS

• Microsoft SQL Server 2000/2005/2008/2012/2014/2016 Enterprise Manager, SQL Server Profiler, Database Engine Tuning Advisor, BIDS (Business Intelligence Development Studios), SSIS (SQL Server Integration Services), Microsoft Access, TOAD
• Data warehouse Knowledge: STAR schema, dimensional, tabular, MDX, DAX and fact tables.
• Microsoft Visual Studio 2005/2008/2010 , WPF (Windows Presentation Foundation).
• T - SQL, Stored Procedures, Triggers, Views, Table-Valued Functions, User Defined Functions (UDF), Common Table Expressions (CTEs), Recursive Functions
• Microsoft SSRS (SQL Server Reporting Services), Crystal 8.5/11, Actuate 8, Power BI, Tableau
• Object Oriented Principles (OOP), SDLC, Agile
• ASP.net, C#, VB.net, JavaScript, CSS, HTML, Microsoft AJAX, jQuery
• .Net Framework 2.0-4.0
• Maximo 4.1.1, Maximo 6.x, Epicor
• Microsoft Visual Source Safe, ChangeManDS, TFS, SVN
• Team Oriented, Motivated, Excellent Interpersonal Communication Skills.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Designed and Developed parametric Reports, Cross-Tabbed and Sub-Reports in SSRS.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.
• Worked on deploying Cubes in SQL server management studio as well as created partition on that having process full for fact table and process update for dimension daily basis.
• Worked on Control flow tasks such as Execute SQL task, Send Mail Task, File System Task, Dataflow Task and used different data sources and destination with derived column, lookup transformation within Dataflow Task.
• Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by creating logging and worked on package configuration to run package on different server.
• Designed dimension modeling for data warehouse. Developed data warehouse to generate OLAP cubes and identified measures and dimensions according to different requirements.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Developed ETL procedures to ensure conformity, compliance with minimal redundancy, translated business rules and functionality requirements into ETL procedures.
• Designed, developed, tested and maintained Tableau functional reports based on user requirements.
• Developed Power BI model used for financial reporting.
• Experienced in using Data Analysis Expressions DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Implemented various logics through stored procedures, triggers, and user defined function.
• Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.
• Assisted the testing team in preparing the test cases and validation of data.
• Involved in the defect analysis along with testers to understand the data and to make any modification to code.
• Provided data validation, data cleansing, data transformation as well as writing and scheduling complex ETL jobs.
• Used various transformations like MultiCast, Conditionalsplit, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Implemented the Package configuration using XML files.
• Developed several reports utilizing SSRS (SQL Server Reporting Services).
• Used complex expressions to calculate groups, filters, parameterize, and format the contents of the reports.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Developed web application to allow accounting to correct data anomalies.
• Strong Excel experience utilizing VBA, macros, PIVOT tables and VLOOKUP.
• Build minor QlikView reports to adhere to business logics and procedures.
• Worked on developing cubes, dimensions, measures and partitions.
• Query the cube utilizing MDX (multidimensional Expression) language.
• Developed reports and dashboards utilizing Power BI.
• Developed complex calculated measures using Data Analysis Expression language (DAX).

Confidential, Atlanta, GA

Application Developer

Responsibilities:

• Utilized SSIS script task to load large complex data into specified database tables.
• Build SSRS reports per business requirements.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Prepared the complete data mapping for all migrated job using SSIS.
• Developed web pages using ASP.net, HTML and CSS for styling the web page.
• Good understanding of Object-Oriented Programming (OOPs) concepts.
• Experience in using ADO. NET data controls (Dataset, Data Reader, Data Adapter, Data Grid, Grid View, Tree View and Data List).
• Experienced with Microsoft Application building blocks for . Net projects (Data Access, Exception Handling, Caching and Configuration Management Application Blocks).
• Executed SSIS packages via batch files.
• Deployed packages using environment variables as well as configuration file.
• Build, modified and created views, triggers, function and stored procs on SQL Server 2012.
• Configured IIS on Windows 2012 Server.
• Developed web interface that uses membership provider to authenticate users.
• Modified existing website so that users can execute SSRS reports via the web interface.
• Build Static and Dynamic menus in web interface utilizing a combination of TreeView and SiteMapPath to allow users to easily navigate the website.

Confidential, Atlanta, GA

Application Developer

Responsibilities:

• Create and modify SSIS packages per business requirement.
• Utilized script task control to programmatically implement business requirements where it was feasible to implement using SSIS standard controls.
• Build and modified SSRS reports per business requirements.
• Configured web application to allow end-user the ability to launch report using front-end application.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Prepared the complete data mapping for all migrated job using SSIS.
• Developed web pages using ASP.net, HTML and CSS for styling the web page.
• Good understanding of Object-Oriented Programming (OOPs) concepts.
• Experience in using ADO. NET data controls (Dataset, Data Reader, Data Adapter, Data Grid, Grid View, Tree View and Data List).
• Deployed packages using environment variables as well as configuration file.
• Developed websites that have a consistent feel and look throughout all web properties.
• Developed website to allow field techs to enter pertinent information pertain to customer’s assets.

Confidential, Charlotte, NC

SQL Database Developer

Responsibilities:

• Created and modified SQL Stored Procedures, Triggers, User Defined Functions, Views, and Cursors.
• Performance tuning of stored procedures utilizing Database tuning advisor and SQL Profiler.
• Adhoc reporting per client’s requests.
• Build and modify SSIS packages utilizing BIDS 2012.
• Built complex queries utilizing recursive CTE’s.
• Documents both business and application processes utilizing Microsoft Visio.
• Build SSIS configuration files to adhere to deployment processes.
• Utilize SSIS script task extensively to load data from excel files to database tables.
• Utilize SVN as the main source control repository.
• Modified Web interface to adhere to business logic pertaining to the leasing of company assets.

Confidential

SQL Database Developer and .Net Developer

Responsibilities:

• Created and modified SQL Stored Procedures, Triggers, User Defined Functions, Views, and Cursors.
• Utilized Build Extract, Transform and Load (ETL) tools for the purpose of Data Warehousing.
• Build and modify SSIS packages per business requirement.
• Documents both business and application processes utilizing Microsoft Visio.
• Build and modify web pages utilizing VB.net on the .net framework 4.0.
• Upgraded existing classic ASP pages to ASP.net pages.
• Build master pages to provide a consistent header/footer across related pages.
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.
• Involved in writing complex queries using T-Sql programming.
• Involved in creating web methods for web service.
• Used Java Script, HTML, DHTML, IIS and CSS for developing Web Pages.
• Used Grid View control extensively for data display, dynamic generation of rows, and user input inside template columns. Used Edit Item-Templates and Footer Templates extensively for editing and adding rows.
• Involved in complete Life Cycle including Analysis, Design, Development and Testing.
• Upgraded legacy classic ASP code to ASP.net 4.0 code.
• Maintain documentation to aid in support and build a knowledgebase repository.
• Developed web page to allow phone reps to easily enter dispatched information.