Sr. Etl/ssis/sql Developer Resume
Harrisburg, PA
EXPERIENCE SUMMARY:
- Over 10 years of IT experience in software development, Database administration, project management, client communications and onsite/offshore team co - ordination including startup experience.
- Data Warehousing, ETL and Business Intelligence experience using SSIS BIDS Suite (SSIS, SSRS, SSAS & TSQL)
- Proficient experience in installing and configuring SQL Server for data warehouse ETL and reporting purposes.
- Good understanding in developing Data Warehouse architecture, ETL framework and BI Integration.
- Proficient knowledge in databases like Sybase, DB2, Oracle, SQL Server 2008R 2/ 2012/2014/2016 .
- Excellent backend programming skills in creating database objects like Tables, Views, Stored Procedures, Indexes, Triggers and Functions.
- Proficient in Data Conversion, Data Mapping, Data fixing, De-Duplication, Data Cleansing.
- Complete knowledge of loading SCD 1, 2, 3 dimensions and Fact load using Parent Child Configuration using SSIS.
- Practiced in implementing historical and incremental load using TSQL and SSIS objects in Data warehouse.
- Experienced with other Reporting tools like SQL Server Reporting Services (SSRS).
- Strong working Experience in creating Parameterized, Sub Report, Bar and Pie Charts, Gauge report, Drill Down, Drill Through, Linked Reports.
- Strong in developing Star schema and Snowflake data warehouse using combination of TSQL and SSIS for best performance.
- Experience in AWS.
- Expert in creating Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, snowflake schema Modeling and good understanding about Fact and Dimensions.
- Complete understanding of the projects including data analysis, database design, development, implementation, testing and maintenance.
- Experience in UNIX and PERL Scripting in UNIX and Linux platform.
- Experience in performance testing and SQL query performance tuning.
- Proficient knowledge of Full, Delta and Incremental Data load, Normalization /De-normalization.
- Experienced in implementing backup, restoration, disaster recovery procedures, Replication and Snapshots.
- Expertise in slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
- Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
- Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
- Strong passion to learn, ability to adapt, and commitment to perform with good communication skills.
TECHNICAL SKILLS:
Business Intelligence: SQL Server 2008 R 2/ 2012/2014/2016 , Business Intelligence Development Studio
ETL/Reporting Tools: SSIS, DTS, SQL Server Reporting Services (SSRS), Pentaho, Informatica
Databases: SQL Server 2008/ 2012/2014/2016 , Sybase, DB2, Oracle SQL developer
Data Modeling: E/R Studio, Erwin, Visio
Operating Systems: Windows XP SP3, Windows 2003 and 2008 Server SP2, Windows Vista, Windows 7, Windows 8, Windows 2012
Programming Languages: T-SQL, PL/SQL, Unix, Linux, VB.NET
Query Tools: SQL Server Management Studio, Toad, SQL Developer, DTA, SQL Workbench
Deployment Methods: Package deployment, Project Deployment, Integration services catalog, SSIS DB
JOB EXPERIENCE:
Sr. ETL/SSIS/SQL developer
Confidential, Harrisburg, PA
Responsibilities:
- Lead the conversion team Datawarehouse activities which include full DB2 data conversion to Microsoft SQL Server Datawarehouse design, development and maintenance process and test strategies in different environments.
- Decides the hardware device, managing data integrity, decides data recovery and back up.
- Maintenance of database performance as per scheduled running jobs, monitored the issues and validation checks on data.
- Support Adhoc data requests from development and testing team for successful completion of SIT and UAT phase.
- Interact with client Datawarehouse production team for daily basis operations and maintenance of the systems.
- Interact with different project tracks and modules on day to day basis for data conversion collaboration and related activities.
- Used the descriptors for getting the input and output values in ANSI SQL.
- Worked in Dimension Data modeling concepts like Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
- Maintain Business (functional) Application production support, including installation, configuration, tuning complex stored procedures and index structures to improve performance of Enterprise-Level SQL Server environment.
- Maintained all the reporting, data quality, system integration and deployment test scripts.
- Load application tables by using different system interfaces like Data Quality Checks, Data Reconciliation, Data Mapping, Data Quality Issues, Data fixing and Dependencies check on Processes.
- Created database objects like Tables, Views, Stored Procedures, Indexes, Triggers and Functions.
- Involve in production maintenance and operation support, conversion data fixes and application support.
- Maintenance of Deployed and scheduled packages using SSIS, SQL Server job agent as per client’s requirement to generate on daily, weekly, monthly and quarterly Reports.
- Monitored all activities of the server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
Environment: DB2, SQL Server 2012/2014/2016 , SSSIS, SSRS, SSAS, DB2, SQL Server Agent, SSISDB Catalog, ER\STUDIO, MS Access, MS Visio, Windows Server 2008/XP 64-bit Edition, T-SQL, Unix, Linux, PMC, TFS, ADO.NET Entity Framework, and LINQ.
ETL/Data Conversion Lead (DB2-SQL server conversion)
Confidential, Harrisburg, PA
Responsibilities:
- Lead the conversion team activities which include data conversion design/development process and test strategies in different environments (Local/DEV/SIT/UAT).
- Interact with different tracks (Eligibility, Intake, Client Notices, Data Exchange, and Child Care) on day to day basis for data conversion collaboration and related activities.
- Provide weekly status updates to project management and reporting progress toward timelines.
- Mentor new team members to help them ramp up on the project and understand the DB2-SQL Server conversion process.
- Design and automated ETL process to convert legacy data based on data model entity relationships and maintain relationship of 350 tables using SSISDB 2014 and SQL server agent services.
- Prepared ETL functional and technical specification. Wrote shell scripts in UNIX.
- Involved in Data Modeling using data Modelers, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
- Designing and writing ANSI SQL-92 compliant statements.
- Responsible to perform and monitor various Conversion Mock Run activities.
- Develop complex ETL Procedures to migrate large amount of legacy data in staging tables from DB2, Access platform to application (OLTP) tables into enterprise data warehouse (BIDW) called Worker web.
- Creates Legacy Extract Process, De-Duplicating, Scrubbing of data, Conversion transformation process and Data Load Process.
- Created Parameterized, Sub Report, Chart, Drill Down, Drill Through, Linked Report.
Environment: DB2, SQL Server 2012/2014, ANSI-SQL, SSSIS, SSRS, SSAS, DB2, SQL Server Agent, SSISDB Catalog, ER\STUDIO, MS Access, MS Visio, Windows Server 2008/XP 64-bit Edition, Linux, Unix, T-SQL, PMC, TFS, ADO.NET Entity Framework, and LINQ.
Sr. ETL/BI Developer
Confidential, Camp Hill, PA
Responsibilities:
- Interact with business analyst, Development Team and Managers to analyze business needs and developed technical specifications.
- Gather business requirement by understanding business Processes and did Requirement and Feasibility analysis (RF analysis) and work breakdown structure (WBS) during minor and major tasks and made excel recording for requirements and reality checks.
- Provided technical leadership and expertise in data mapping, database design, and implementation and maintenance phases.
- Attended meetings with different stakeholders and client: Insurance Carriers, Employers, Self-insured Employers, and Healthcare Services.
- Created staging environment in SQL server 2008 for the data migration from different heterogeneous sources (legacy data, CSV, Excel files).
- Designed, implemented and configured ETL procedures by creating Control flow and dataflow using SQL Server Integration Services.
- Designed data flow diagrams after RF analysis using MS VISIO before creating SSIS package.
- Created SSIS Package template - indirect xml configuration, logging, package level and data level error handling using event handler (on error, pre execute and post execute event handler).
- Developed complex ETL Procedures to migrate huge amount of legacy data in staging tables from Sybase, Access platform to application (OLTP) tables in enterprise data warehouse (BIDW).
- Performed data decoupling, orchestration of jobs and measure data quality and checked data dependencies using stored procedures and business rules like expected data and actual data in execute SQL task in BIDS.
- Created weekly different types of reports like Tabular, Drill-Down, Parameterized and sub-reports using SQL server reporting services, Weekly Conversion Data Quality Issues Reports.
- Employed error handling techniques and then trouble shooting them by Error Logging, Checkpoint, Event handling, precedence constraints and Package configuration.
- Automated file transfer processes and mail notifications by using Send Mail task in packages.
- Implemented Slowly Changing Dimensions to maintain historical data in Data Warehouse.
- Performed unit testing (UT) and Integration testing to ensure that the system is functioning as per user requirement.
- Maintained all the reporting, data quality, system integration and deployment test scripts.
- Created, Deployed and scheduled packages using SSIS, SQL Server job agent as per client’s requirement to generate on daily, weekly, monthly and quarterly Reports.
- Responsible to perform and monitor various Conversion Mock Run activities. Back up, Restore of Databases and refreshed new scrubbed and cleansed database to Application Team for testing.
Environment: Windows Server 2008/XP 64-bit Edition, T-SQL, SQL Server 2008 R2, SSSIS, SSRS, SQL Server Agent, ER\STUDIO, MS Access, MS Visio, CIMS Application, Dimensional Modeling, MS Access, Top-Team, TFS.
Confidential, Thousand Oak, CA
SQL/SSIS Developer (System Integration)
Responsibilities:
- Designed, implemented and configured ETL procedures by creating Control flow and dataflow using SQL Server Integration Services.
- Created SSIS package with best practices including parent child package to make parallel load to load data more quickly and generate functionality SQL scripts for environmental setting.
- Interacted with business analyst, Development Team and Managers to analyze business needs and developed technical specifications.
- Created staging environment in SQL 2008 for the data migration from different heterogeneous sources (CSV, Excel).
- Defined table definitions and made entity relationship using parent and child entities and loaded data models into repository using ER/STUDIO.
- Designed data flow diagrams after RF analysis using MS VISIO before creating SSIS package.
- Created SSIS Package template - indirect xml configuration, logging, package level and data level error handling using event handler (on error, pre execute and post execute event handler).
- Developed complex ETL Procedures to migrate huge amount of data in staging tables from PSH platform to fact tables in enterprise data warehouse (BIDW).
- Created weekly different types of reports like Tabular, Drill-Down, Parameterized and sub-reports using SQL server reporting services.
- Employed error handling techniques and then trouble shooting them by Error Logging, Checkpoint, Event handling, precedence constraints and Package configuration.
- Implemented Slowly Changing Dimensions to maintain historical data in Data Warehouse.
- Scheduled ETL jobs and deployed in SQL Server File System in production environments.
Environment: Windows Server 2008/XP 64-bit Edition, T-SQL, SQL Server 2008 R2, SSSIS, SSRS, SQL Server Agent, ER/STUDIO, MS Access, MS Visio.