SUMMARY:

ETL SQL Database Developer and Administrator in a wide variety of BI applications, particularly, client/server applications and RDBMS: T - SQL, MSSQL Server, Postgresql, Teradata, Oracle, MySQL; design Star Schemas, Snowflake Schemas and migration database projects, close interaction with the DB manufacturers, health care, business services, retails…on Windows and Unix/Linux systems.

SPECIALTIES:

10+ year experience in SQL Programming and Administering with MSSQL Server with SQL Server Management Studio, SSIS, SSRS, Postgresql, Oracle with PL/SQL, MySQL, Teradata with Teradata Studio, Python, T-SQL, SQL Server and ETL/ ELT with Talend or SSIS, C#, Java, Python, Power Designer, DDL, DML, OLTP, OLAP, Snowflake schema, Star schema, MDX queries. Strong passion with data and learn fast any new technologies

EXPERIENCE:

SQL ETL Developer

Confidential, Quincy, MA

Responsibilities:

• Analyze, design and create SQL query data for ETL process.
• Build and maintain ETL documents for Windows and Database Recertification.
• Build and maintain SQL statements to test for ETL.

Technologies: SQL, RDBMS databases: Teradata Studio, MSSQL, Oracle

ETL Developer

Confidential, Boston, MA

Responsibilities:

• Analyze, design and create SQL query data for Tableau dashboard.
• Build ETL process for Sales and Operation.
• Create technical document and schema for database.
• Use Talend to clean data and import to database
• Set and transfer variables between Talend and SQL Server database.
• Transform data on Talend and send email to notice ETL process success or failure.
• Generate Talend package to automation run as schedule.

Technologies: SQL, Snowflake database, Cloud Computing, Python, AWS, Data Warehouse Kimball architecture, SQL, Tableau, Git

ETL Developer

Confidential

Responsibilities:

• Develop the ETL packages to transform data from raw data to production data by SSIS, C#, T - SQL..
• Involve in analyze and design database for internal applications.
• Build and run optimized query on Teradata and PDW.
• Build SSIS package to extract data from Teradata and other source, transform and load to PDW.
• Build dynamic query for ETL automation.
• Create variables to pass setting data from database to ETL package for automation.

Technologies: T-SQL, MSSQL Server, Teradata, Big Data, Data Warehouse Kimball architecture, Parallel Data Warehouse (PDW), SSIS, C#, SQL, Tableau, Git Extension, Source Tree, Teradata SQL Assistant.

Report Developer and DBA

Confidential

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins using optimized T - SQL, PostgreSQL
• Develop the ETL packages to transform data from raw data to production data by SSIS as Workday tenants.
• Schedule the DTS/SSIS package for migration data from legacy system on MS SQL 2008, 2012, 2014.
• Maintain of Stored Procedures to improve performance of different front end Applications.
• Work on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers from SQL-Server to RDBMS like PostgreSQL
• Design database architecture from logical to physical models
• Extract the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate or staging Database using the SSIS.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, multiple dimensional data source view.
• Develop complex stored procedure using T-SQL to generate Ad hoc reports using Crystal Report and T-SQL programming.
• Schedule the Reports to run on hourly, daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the Crystal Reports
• Prepare the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Interact with the business users to gather information about the report.
• Create numerous sub reports, drill down reports as part of the project according to business requirements using SQL Server.
• Design multiple stored procedures, views for the Crystal Report as data sources.
• Create and maintain User Security/Permission
• Migrate the database objects from one server to another server between SQL Server databases and PostgreSQL databases.
• Work with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Technologies: Big Data, PostgreSQL, MySQL, MSSQL Server 2012, 2014, SSIS, SSRS, T-SQL, XML, Visual Basic, C# in SSIS, Crystal Report, Python, Rake, Win Server 2008, 2012, Inmon Datawarehouse.

ETL Developer and Database Architecture

Confidential

Responsibilities:

• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans.
• Worked with Technical Architects and Business Analysts to design database architects and report.
• Populate or refresh OLAP database for report on dashboard by running ETL automation processes for user acceptance testing and loading history data into OLTP database.
• Develop ETL processes by T - SQL scripts to add the logic by getting the related data from the multiple sources.
• Design the functional and technical documents.
• Create report templates and reporting standards for the developers to work on the report development with T-SQL.
• Develop Cubes and Regression Statistic using T-SQL programming
• Create MDX queries to create cube by T-SQL programming.
• Refreshing the cube to get the latest information updated for OLAP databases.
• Extract, Transform and Load data to dashboard as Business Intelligence Web applications.
• Use Talend Open Studio tool is used to clean data and import raw data to SQL Server.
• Use parameters to communicate between Talend and SQL Server and configure Talend to run ETL as automation tasks.
• Shell scripting use to call Talend automation tasks and refresh ETL tasks as Workday tenants.
• Analysis and Design Logical and Physical Data Modeling, import, export, backup, restore, migration... databases.
• Python programming for Geocode location.
• Data visualization with Power BI
• SQL Programming as stored procedures, functions, views, triggers, index, constraints, statistics on relational databases.
• Database server administration, query optimization, stored procedure development and performance analysis.
• Create Entity-relationship and UML diagrams will be employed to model new data import in batch scripting scenarios, combined with command-line scripting in order to transfer, validate and import new information.
• Interface with subject matter experts, customer IT departments and business intelligence experts on a daily basis.
• Self-starter and strongly motivated to operate within this small and rapidly growing Toronto office.

Technologies: Microsoft SQL Server 2000/2005/2008/2012/2014 , PDW, SSRS, SSIS, MySQL, Power Designer, Talend, Crystal Report, Spy Schema modeling tool via ER diagram, OLTP, OLAP, DML, and DDL, T-SQL, SQL Tuning, Python, Java, Unix scripting, Kimball Data Warehouse methodology.

ETL Developer and DBA

Confidential

Responsibilities:

• SQL programming as Stored Procedures, Functions, Views, Triggers in SQL language to do ETL, import/export data to/from database for aviation application written in Java language.

Technologies: Power Designer, T-SQL programming on MSSQL Server 2005/ 2008/ 2008 R2, SSRS, SSIS, SQL Server Management Studio, Oracle, Java, Tomcat, Eclipse, JIRA.

IT Specialist

Confidential

Responsibilities:

• Performs all activities required to support the Information Systems Service Desk; lead and guide day to day operations of IT Help desk.
• Provides remote support over the phone, through email or remote desktop control.
• Supports after hours IT Help desk activities by being the on - call support analyst to respond to issues within 15 minutes 24 hours a day on a rotation basis.
• Creates user accounts in AD, Blackberry and other applications as required for new staff and updates access rights for existing staff.
• Backup/Restore data and database.
• Printers: Install, troubleshoot issues, Sharing and Security, Maintenance
• Windows Server 2003: Administration/Troubleshooting/Configuration
• Group Policy Administration/Creation/Deployments
• Basic Network troubleshooting
• Windows2000/XP/7 Installation/Configuration/Troubleshooting/Administration
• MSSQL Server /Client side administration/configuration
• Project Management for the IT Help desk
• Contacts vendors for product information, pricing and support as required.

ASP/ASP.NET Web Developer

Confidential, Colleyville, TX

Responsibilities:

• Develop, test and maintain modules for web applications as ASP/ASP.NET Developer.
• Write code and calculations for all applications.
• Designed and implemented the database.
• User interface: Designed the GUI and all Web form.
• Created and edited documentation for the flow of the GUI.
• Created all stored procedures, triggers, and views.
• Ensured the integrity of all data and calculations, and made changes as necessary.
• Debugged and maintain the Sterling web application for accounting and financial organization.

Technologies used: Power Designer ASP, ASP.NET, ADO/ADO.NET, C#, T-SQL, MSSQL 2008/2008 R2 SQL Server Management Studio, .NET framework 3.5, IIS, Visual Studio 2008/2010 with Visual Studio Management.

Databases: MSSQL 2005/2008, using stored procedure, trigger, function, batch.

Operating Systems: Windows Server 2008.