Charlotte, North Carolina, United States
Responsibilities: - • Collected business requirements to set rules for proper data transfer from Data Source to Data target in Data Mapping. • Created SSIS package that extracts loads and transform flat files to FTP and SFTP location daily on Windows and Linux application • Setup Log Shipping for synchronization of data from primary to secondary database. • Established ETL design practices for optimization and performance of packages and Parameterized SSIS. • Work on SQL Server Integration Services (SSIS) to extract data from various sources (Flat files, Excel, Oracle DB2, & SQL Server) • Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications. • Implemented Extracting, Transformation, and Load (ETL), Import, Export Activities using SSIS Package. • Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet. • Wrote Power shell scripts to automate the process of fetching file from Linux and Windows Application. • Served as a SSRS Reports Developer and SQL Server Developer in support of Service Management System. • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task. • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets. • Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS. • Developed Autosys Jill Scripts to run the SSIS packages from the Autosys Firm which runs in every 10 minutes. • Deployed and gave support for the UAT and Prod Release.
• Working with the internal business users to gather business requirements that require data warehousing and operational data store related work • Created several SSIS packages for performing ETL operations to transform data from a cube using MDX. • Generated Reports from the cubes by connecting to Analysis server from SSRS. • Developed the SQL Server Integration Services (SSIS) packages to transform data, as well as Created Interface Stored Procedures used in SSIS to load/transform data to the database. • Worked on T-SQL Programming, Stored Procedures, User-defined functions, Cursors, Views setup and Management of linked servers to Non-SQL Server databases. • Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse. • Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration. • Experience in creating Snapshots of Static Reports and configure Subscription. • Involved in the SSAS storage and Partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing Reports using MDX and SQL. • Tuning package components like Script Task, Data Flow task, Data Conversion, Multicast, Sort, and Conditional split, Script Component, Configuration file, etc. • Responsible for developing, monitoring and deploying SSIS packages. • Experience in Creating, managing SQL Server AZURE Databases, and setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers • Adding nodes to already existing clustered servers as a part of data load\High availability • Configured Transactional Replication and Log Shipping
• Working with the internal business users to gather business requirements that require data warehousing and operational data store related work. • Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and power pivot. • Demonstrated understanding of Business Intelligence Tool Development, Data Modeling, and Teradata database design. • Developed a front-end navigation scheme to support a formal dashboard portfolio strategy, including strategic, tactical, and operational dashboards Uploading statistics to MySQL for analysis and logging. • Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau. • Building Tableau dashboards using stack bars, lines, dual combination, heat maps, tree maps, symbol maps, filled maps, horizontal bars according to deliverable specifications. • Using Idera SQL Compliance Manager for auditing production servers for every Quarter. • Created SSIS package that extracts loads and transform flat files to a FTP and SFTP location on a daily basis on WelkEDI application • Extensively used Repositories like Team Foundation Server (TFS) to sync up with application team databases • Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers • Migrations of SQL server from one version of SQL server to another • Implemented new SQL Server 2012 technique ALWAYS-ON High Availability groups
• Facilitated requirements gathering sessions to understand the metrics required for the Data reports • Worked as a database developer on databases like MS SQL Server using T-SQL, stored procedures and views to get data from Data warehouse. • Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts. • Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS. • Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server • Made Master Child package using variables and Execute package task in SSIS. and transformations that SSIS provides. • Deployed, Tested and Scheduled SSIS packages. • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS. • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status. • Leading and mentor the efforts of data quality completeness initiative for Informatica based ETL architecture. • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications • Developed incremental loading using MERGE statement in SQL and also used slowly changing dimension (SCD). • Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler • Used Execution Plana and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Requirements gathering, Analysis and Design of all the clients (support offices, donors and sponsors) requirements. • Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server. • Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality. • Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data. • Used Crystal Reports to tracked logins, mouse overs, click-through, session durations and demographic comparisons with SQL database of customer information. • Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted. • Designed, coded and implemented ad hoc reports using existing report models in SSRS. • Identified the Data Source and defined them to build the Data Source Views. • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports. • Managed Alerts for successful or unsuccessful completion of scheduled Jobs.