 6 Years of Total Experience in MICROSOFTSQLSERVER and SSIS talent for Analyzing problems, Developing and Simplifying Procedures and finding innovative solutions.  Strong knowledge in writing Stored Procedures, Functions, Triggers, Cursors and Views etc.  Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.  Good Knowledge using temporary result sets: Temporary Tables, CTE and Temp Variable.  Good knowledge on Tuning the Queries and Strong Knowledge on SqlServerProfiler and DatabaseTuningAdvisor tools.  Strong knowledge in DBCC commands.  Strong Knowledge in DynamicSQL (SP_EXECUTESQL,EXEC)  Translate Business Requirements to Conceptual and Logical Data Models  Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of requirements and/or from a Logical Data Model  Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.  Strong knowledge on using Containers and control flow Tasks.  Strong Knowledge on working Transformations like Derived Column, Data Conversion, Lookup, Conditional Split, Aggregate, Slowly Changing Dimension etc.  Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.  Expertise in enhancing and deploying the SSIS Packages from development server to production server.  Experience on Creating Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.  Good Knowledge and experience on Alteryx ETL tool.  Good knowledge on creating basic SSRS reports.  Good knowledge in Admin tasks like Attaching and detaching databases Backup and Restore the databases, creating jobs & Maintenance plans.  Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
©