Responsible for the Performance tuning of the SQL Commands with the use of the SQL Pro-filer and Database Engine Tuning Wizard.Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).Established ETL design practices for optimization and performance of packages and Parameterized SSIS.Involved in enhancing and deploying the SSIS Packages from development server to production server.Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.Extensively designed the packages and data mapping using Control flow task, Sequence container task, Data-flow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
#SQLPRO CSV IMPORT MAPPING WINDOWS#
Environment: Windows 2011/2010 enterprise, SQL Server 2022/2019/2016/2014, SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2018/2016/2014, OLE DBġ0/2019 to 01/2022 SQL/ETL Developer Northwest Federal Credit Union | City, STATE ,.Used Execution Plan, SQL Pro-filer and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS in Business Intelligence Development Studio (BIDS).using SSIS/DTS utility.Ġ2/2022 to Current SQL Server/SSIS/SSRS Developer Apex Systems | Addison, TX ,
Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them. Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging. Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications. Experience in maintaining one to many and many to one relationship while moving data between two databases. Represent API Support with project teams to ensure that API Knowledge is provided, thus ensuring effective support for new products and enhancements. Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services of and SQL Server Integration Services.
#SQLPRO CSV IMPORT MAPPING PROFESSIONAL#
A Microsoft Certified Professional with around 6 + years of total IT experience in the Design, Modelling, Development, Implementation and Support of SQL Server 2022/2019/2016/2014/2012.
0 kommentar(er)
