NATE ALEXANDER

• Engineered, monitored, and optimized automated ETL/ELT pipelines to facilitate seamless data integration across enterprise systems.
• Executed schema migrations and database upgrades with zero data loss and minimal scheduled downtime.
• Conducted complex query optimization, indexing, and execution plan analyses, reducing server load by 40% and improving application response times.
• Designed, optimized, and maintained relational and non-relational database architectures to ensure high performance, scalability, and 55% uptime.
• Automated routine database administration tasks, including backups, disaster recovery drills, and index maintenance using SQL.

• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
• Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
• Expertise in writing Test Strategy, Test plan preparation and implementation, Test Case Design, Test Tool usage, Test execution, Defect management, and Defect tracking.
• Validate the data accuracy and consistency in the data warehouse or target system. Perform queries and reports validation to ensure the transformed and loaded data aligns with the expected results.
• Developed and maintained automated test scripts using Selenium WebDriver and Robot Framework.
• Utilized Selenium WebDriver for automating functional and regression test cases.
• Executed tests across multiple browsers to ensure compatibility and responsiveness.
• Conducted regression testing to ensure that changes or enhancements to the process shouldn't impact existing functionalities.
• Writing stored procedures and SQL statements to access filings data from SQL Server database.

• Worked on requirements Analysis, Physical and Logical design development using Erwin, normalization, and SQL Server Enterprise manager
• Used tools such as performance monitor, query execution plans to increase the efficiency of the queries
• Managed and scheduled daily jobs relating to data transfers, backup and restore.
• Migrated DTS packages and converted them to SSIS packages in SQL Server 2008.
• Used ETL Transformations to copy columns and load data from source like Oracle, DB2, Flat files to destination databases.
• Implemented different types of Replication models including Snapshot and Transactional replications.
• Created reports using Cascading parameters and Drill-Through Reports, Sub reports, Parameterized Reports, Report Models and ad hoc Reports.
• Experience in Generating Report Models, Refining and Enhancing the Report Models, Deploying Report Model, Creating Reports on Report Models.
• Designed reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.
• Modified and tuned stored procedures, triggers, views and indexes to provide best performance.
• Analyzed, identified and implemented user roles and assigned relative database access privileges.
• Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.

Environment: MS SQL Server 2008/2012/2016/2019, Erwin, DB2, ER Studio, MS SQL Integration Services, MS SQL Reporting Services 2008, MS Excel, Windows Server 2007

• Gathered business requirement from the end users.
• Involved in creating complex stored procedures according to business logic and also for the creation of RDL for reporting.
• Worked with nested Stored Procedures and Functions.
• Involved in the performance tuning of the existing SQL code.
• Coded with complex customer data related to events such as Delinquency, Bankruptcy, and Collections etc.
• Created objects like tables and views and developed SSIS packages to load data.
• Implemented Incremental Loading into the target tables/views in SSIS.
• Created SSIS packages for moving data between databases.
• Involved in maintaining the Error-Logging for the SSIS packages.
• The data is moved with one-to-many relationships between tables and many to one relationship between tables.
• Created Jobs, Alerts using SQL Server Mail Agent in SSIS.
• Developed SSIS Packages and stored procedures to retrieve all accounts from various systems like Settlements, Foreclosures, Transactions and Mortgage to name a few.
• Created mock-up data for testing the reports.
• Involved in the performance tuning of table valued functions.
• Responsible for creating reports using SSRS.
• Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement.

Environment: Microsoft SQL Server 2008/2016, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Team Foundation Server.

• Designed and normalized the database and created different objects like Tables, Views Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server.
• Involved in installing and migrating legacy database to MS SQL Server 2008R2.
• Research with team members and came up with the high level design, impact analysis document with several solutions to the problem during implementation proposed new system.
• Created several SSIS package to import Flat files CSV into data tables.
• These packages were scheduled in regular time interval.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
• Applied various data transformations like Lookup, Sort, Multitasking, Conditional Split, Derived column.
• Perform data validation checks and filtered bad data.
• Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
• Responsible for the ad-hoc reporting, modification and regenerating on request.
• Building scorecards and dashboards using the Performance Point Services 2010 with BI application.
• Schedule the reports to run daily, weekly and monthly and also automatically emailed reports to department directors and analyst to review it.

Environment: MS SQL Server 2008R2 SSRS/SSAS/SSIS, Point Services 2010, Microsoft office 2010, T-SQL, Windows 7.